September Guarantee records are stored in the table DT_YP_SEPTEMBER_GUARANTEE. This table can hold multiple records for a young person if they have had multiple September Guarantee records against them.
Records for both a year 11 and a year 12 guarantee are stored in this table.
Calculate the current guarantee record
When creating your report, link the DT_YP_REPORT table to the DT_YP_SEPTEMBER_GUARANTEE table.
Use either of the fields to return the appropriate September Guarantee records.
DT_YP_REPORT. Current_YP_September_Guarantee_Ref | This returns the current guarantee record up to the end of the academic year. This does not take into account the customer's set grace period for recording. |
DT_YP_REPORT. Current_Including_Grace_Config_YP_September_Guarantee_ref | This returns the current guarantee record up until the end of the set grace period. This period allows records to be entered after 1 September till the set period of time. |
To locate September Guarantee records for the young people in your marked cohort, the table DT_YP_TRACKER should be used.