ER Aims DLF 2009/2010

  1. The ER Aims DLF file is used for the analysis of funding at Aims level within the Employer Responsive model.
Variable Name Variable Label Data Definition Field Type Field Length
Year YEAR Academic Year of Dataset   String 8
COLLECTION Collection Funding Stream (LR, ER, ESF SR, UfI, ACL)   String 3
PERIOD PERIOD Collection Period Data Contains Period Data Numeric
L25 L25 LSC Number Of Funding LSC   Numeric 8
L25_REG L25_REG Region of the Funding LSC Region of the Funding LSC String 2
L01 L01 Provider Number   Numeric 10
L46 L46 UK Provider Reference Number Numeric 8
L03 L03 Learner Reference Number   String 12
A05 A05 Leaning Aim Data Set Sequence   Numeric 5
A15 A15 Programme Type   Numeric 2
A26 A26 Sector Framework Of Learning   Numeric 3
A_OP_SLN_P1 A_OP_SLN_P1 On Programme SLN Period 1   Numeric 15,5
A_ACH_SLN_P1 A_ACH_SLN_P1 Achievement SLN Period 1   Numeric 15,5
A_BAL_SLN_P1 A_BAL_SLN_P1 Balancing SLN Period 1   Numeric 15,5
A_TOTAL_SLN_P1 A_TOTAL_SLN_P1 Total SLN Period 1  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P1 A_ALS_PAYMENT_P1 ALS Payment Period 1   Numeric 15,5
A_OP_PAYMENT_P1 A_OP_PAYMENT_P1 On Programme Payment Period 1   Numeric 15,5
A_ACH_PAYMENT_P1 A_ACH_PAYMENT_P1 Achievement Payment Period 1   Numeric 15,5
A_BAL_PAYMENT_P1 A_BAL_PAYMENT_P1 Balancing Payment Period 1   Numeric 15,5
A_TOTAL_PAYMENT_P1 A_TOTAL_PAYMENT_P1 Total Payment Period 1  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P1 A_SLN_PAYMENT_P1 Any SLN or Payments Period 1  SLN Payment Data Definition Numeric 1
A_OP_SLN_P2 A_OP_SLN_P2 On Programme SLN Period 2   Numeric 15,5
A_ACH_SLN_P2 A_ACH_SLN_P2 Achievement SLN Period 2   Numeric 15,5
A_BAL_SLN_P2 A_BAL_SLN_P2 Balancing SLN Period 2   Numeric 15,5
A_TOTAL_SLN_P2 A_TOTAL_SLN_P2 Total SLN Period 2  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P2 A_ALS_PAYMENT_P2 ALS Payment Period 2   Numeric 15,5
A_OP_PAYMENT_P2 A_OP_PAYMENT_P2 On Programme Payment Period 2   Numeric 15,5
A_ACH_PAYMENT_P2 A_ACH_PAYMENT_P2 Achievement Payment Period 2   Numeric 15,5
A_BAL_PAYMENT_P2 A_BAL_PAYMENT_P2 Balancing Payment Period 2   Numeric 15,5
A_TOTAL_PAYMENT_P2 A_TOTAL_PAYMENT_P2 Total Payment Period 2  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P2 A_SLN_PAYMENT_P2 Any SLN or Payments Period 2  SLN Payment Data Definition Numeric 1
A_OP_SLN_P3 A_OP_SLN_P3 On Programme SLN Period 3   Numeric 15,5
A_ACH_SLN_P3 A_ACH_SLN_P3 Achievement SLN Period 3   Numeric 15,5
A_BAL_SLN_P3 A_BAL_SLN_P3 Balancing SLN Period 3   Numeric 15,5
A_TOTAL_SLN_P3 A_TOTAL_SLN_P3 Total SLN Period 3  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P3 A_ALS_PAYMENT_P3 ALS Payment Period 3   Numeric 15,5
A_OP_PAYMENT_P3 A_OP_PAYMENT_P3 On Programme Payment Period 3   Numeric 15,5
A_ACH_PAYMENT_P3 A_ACH_PAYMENT_P3 Achievement Payment Period 3   Numeric 15,5
A_BAL_PAYMENT_P3 A_BAL_PAYMENT_P3 Balancing Payment Period 3   Numeric 15,5
A_TOTAL_PAYMENT_P3 A_TOTAL_PAYMENT_P3 Total Payment Period 3  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P3 A_SLN_PAYMENT_P3 Any SLN or Payments Period 3  SLN Payment Data Definition Numeric 1
A_OP_SLN_P4 A_OP_SLN_P4 On Programme SLN Period 4   Numeric 15,5
A_ACH_SLN_P4 A_ACH_SLN_P4 Achievement SLN Period 4   Numeric 15,5
A_BAL_SLN_P4 A_BAL_SLN_P4 Balancing SLN Period 4   Numeric 15,5
A_TOTAL_SLN_P4 A_TOTAL_SLN_P4 Total SLN Period 4  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P4 A_ALS_PAYMENT_P4 ALS Payment Period 4   Numeric 15,5
A_OP_PAYMENT_P4 A_OP_PAYMENT_P4 On Programme Payment Period 4   Numeric 15,5
A_ACH_PAYMENT_P4 A_ACH_PAYMENT_P4 Achievement Payment Period 4   Numeric 15,5
A_BAL_PAYMENT_P4 A_BAL_PAYMENT_P4 Balancing Payment Period 4   Numeric 15,5
A_TOTAL_PAYMENT_P4 A_TOTAL_PAYMENT_P4 Total Payment Period 4  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P4 A_SLN_PAYMENT_P4 Any SLN or Payments Period 4  SLN Payment Data Definition Numeric 1
A_OP_SLN_P5 A_OP_SLN_P5 On Programme SLN Period 5   Numeric 15,5
A_ACH_SLN_P5 A_ACH_SLN_P5 Achievement SLN Period 5   Numeric 15,5
A_BAL_SLN_P5 A_BAL_SLN_P5 Balancing SLN Period 5   Numeric 15,5
A_TOTAL_SLN_P5 A_TOTAL_SLN_P5 Total SLN Period 5  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P5 A_ALS_PAYMENT_P5 ALS Payment Period 5   Numeric 15,5
A_OP_PAYMENT_P5 A_OP_PAYMENT_P5 On Programme Payment Period 5   Numeric 15,5
A_ACH_PAYMENT_P5 A_ACH_PAYMENT_P5 Achievement Payment Period 5   Numeric 15,5
A_BAL_PAYMENT_P5 A_BAL_PAYMENT_P5 Balancing Payment Period 5   Numeric 15,5
A_TOTAL_PAYMENT_P5 A_TOTAL_PAYMENT_P5 Total Payment Period 5  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P5 A_SLN_PAYMENT_P5 Any SLN or Payments Period 5 SLN Payment Data Definition Numeric 1
A_OP_SLN_P6 A_OP_SLN_P6 On Programme SLN Period 6   Numeric 15,5
A_ACH_SLN_P6 A_ACH_SLN_P6 Achievement SLN Period 6   Numeric 15,5
A_BAL_SLN_P6 A_BAL_SLN_P6 Balancing SLN Period 6   Numeric 15,5
A_TOTAL_SLN_P6 A_TOTAL_SLN_P6 Total SLN Period 6  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P6 A_ALS_PAYMENT_P6 ALS Payment Period 6   Numeric 15,5
A_OP_PAYMENT_P6 A_OP_PAYMENT_P6 On Programme Payment Period 6   Numeric 15,5
A_ACH_PAYMENT_P6 A_ACH_PAYMENT_P6 Achievement Payment Period 6   Numeric 15,5
A_BAL_PAYMENT_P6 A_BAL_PAYMENT_P6 Balancing Payment Period 6   Numeric 15,5
A_TOTAL_PAYMENT_P6 A_TOTAL_PAYMENT_P6 Total Payment Period 6  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P6 A_SLN_PAYMENT_P6 Any SLN or Payments Period 6  SLN Payment Data Definition Numeric 1
A_OP_SLN_P7 A_OP_SLN_P7 On Programme SLN Period 7   Numeric 15,5
A_ACH_SLN_P7 A_ACH_SLN_P7 Achievement SLN Period 7   Numeric 15,5
A_BAL_SLN_P7 A_BAL_SLN_P7 Balancing SLN Period 7   Numeric 15,5
A_TOTAL_SLN_P7 A_TOTAL_SLN_P7 Total SLN Period 7  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P7 A_ALS_PAYMENT_P7 ALS Payment Period 7   Numeric 15,5
A_OP_PAYMENT_P7 A_OP_PAYMENT_P7 On Programme Payment Period 7   Numeric 15,5
A_ACH_PAYMENT_P7 A_ACH_PAYMENT_P7 Achievement Payment Period 7   Numeric 15,5
A_BAL_PAYMENT_P7 A_BAL_PAYMENT_P7 Balancing Payment Period 7   Numeric 15,5
A_TOTAL_PAYMENT_P7 A_TOTAL_PAYMENT_P7 Total Payment Period 7  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P7 A_SLN_PAYMENT_P7 Any SLN or Payments Period 7  SLN Payment Data Definition Numeric 1
A_OP_SLN_P8 A_OP_SLN_P8 On Programme SLN Period 8   Numeric 15,5
A_ACH_SLN_P8 A_ACH_SLN_P8 Achievement SLN Period 8   Numeric 15,5
A_BAL_SLN_P8 A_BAL_SLN_P8 Balancing SLN Period 8   Numeric 15,5
A_TOTAL_SLN_P8 A_TOTAL_SLN_P8 Total SLN Period 8  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P8 A_ALS_PAYMENT_P8 ALS Payment Period 8   Numeric 15,5
A_OP_PAYMENT_P8 A_OP_PAYMENT_P8 On Programme Payment Period 8   Numeric 15,5
A_ACH_PAYMENT_P8 A_ACH_PAYMENT_P8 Achievement Payment Period 8   Numeric 15,5
A_BAL_PAYMENT_P8 A_BAL_PAYMENT_P8 Balancing Payment Period 8   Numeric 15,5
A_TOTAL_PAYMENT_P8 A_TOTAL_PAYMENT_P8 Total Payment Period 8  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P8 A_SLN_PAYMENT_P8 Any SLN or Payments Period 8  SLN Payment Data Definition Numeric 1
A_OP_SLN_P9 A_OP_SLN_P9 On Programme SLN Period 9   Numeric 15,5
A_ACH_SLN_P9 A_ACH_SLN_P9 Achievement SLN Period 9   Numeric 15,5
A_BAL_SLN_P9 A_BAL_SLN_P9 Balancing SLN Period 9   Numeric 15,5
A_TOTAL_SLN_P9 A_TOTAL_SLN_P9 Total SLN Period 9  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P9 A_ALS_PAYMENT_P9 ALS Payment Period 9   Numeric 15,5
A_OP_PAYMENT_P9 A_OP_PAYMENT_P9 On Programme Payment Period 9   Numeric 15,5
A_ACH_PAYMENT_P9 A_ACH_PAYMENT_P9 Achievement Payment Period 9   Numeric 15,5
A_BAL_PAYMENT_P9 A_BAL_PAYMENT_P9 Balancing Payment Period 9   Numeric 15,5
A_TOTAL_PAYMENT_P9 A_TOTAL_PAYMENT_P9 Total Payment Period 9  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P9 A_SLN_PAYMENT_P9 Any SLN or Payments Period 9  SLN Payment Data Definition Numeric 1
A_OP_SLN_P10 A_OP_SLN_P10 On Programme SLN Period 10   Numeric 15,5
A_ACH_SLN_P10 A_ACH_SLN_P10 Achievement SLN Period 10   Numeric 15,5
A_BAL_SLN_P10 A_BAL_SLN_P10 Balancing SLN Period 10   Numeric 15,5
A_TOTAL_SLN_P10 A_TOTAL_SLN_P10 Total SLN Period 10  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P10 A_ALS_PAYMENT_P10 ALS Payment Period 10   Numeric 15,5
A_OP_PAYMENT_P10 A_OP_PAYMENT_P10 On Programme Payment Period 10   Numeric 15,5
A_ACH_PAYMENT_P10 A_ACH_PAYMENT_P10 Achievement Payment Period 10   Numeric 15,5
A_BAL_PAYMENT_P10 A_BAL_PAYMENT_P10 Balancing Payment Period 10   Numeric 15,5
A_TOTAL_PAYMENT_P10 A_TOTAL_PAYMENT_P10 Total Payment Period 10  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P10 A_SLN_PAYMENT_P10 Any SLN or Payments Period 10  SLN Payment Data Definition Numeric 1
A_OP_SLN_P11 A_OP_SLN_P11 On Programme SLN Period 11   Numeric 15,5
A_ACH_SLN_P11 A_ACH_SLN_P11 Achievement SLN Period 11   Numeric 15,5
A_BAL_SLN_P11 A_BAL_SLN_P11 Balancing SLN Period 11   Numeric 15,5
A_TOTAL_SLN_P11 A_TOTAL_SLN_P11 Total SLN Period 11  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P11 A_ALS_PAYMENT_P11 ALS Payment Period 11   Numeric 15,5
A_OP_PAYMENT_P11 A_OP_PAYMENT_P11 On Programme Payment Period 11   Numeric 15,5
A_ACH_PAYMENT_P11 A_ACH_PAYMENT_P11 Achievement Payment Period 11   Numeric 15,5
A_BAL_PAYMENT_P11 A_BAL_PAYMENT_P11 Balancing Payment Period 11   Numeric 15,5
A_TOTAL_PAYMENT_P11 A_TOTAL_PAYMENT_P11 Total Payment Period 11  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P11 A_SLN_PAYMENT_P11 Any SLN or Payments Period 11  SLN Payment Data Definition Numeric 1
A_OP_SLN_P12 A_OP_SLN_P12 On Programme SLN Period 12   Numeric 15,5
A_ACH_SLN_P12 A_ACH_SLN_P12 Achievement SLN Period   Numeric 15,5
A_BAL_SLN_P12 A_BAL_SLN_P12 Balancing SLN Period   Numeric 15,5
A_TOTAL_SLN_P12 A_TOTAL_SLN_P12 Total SLN Period  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_P12 A_ALS_PAYMENT_P12 ALS Payment Period   Numeric 15,5
A_OP_PAYMENT_P12 A_OP_PAYMENT_P12 On Programme Payment Period   Numeric 15,5
A_ACH_PAYMENT_P12 A_ACH_PAYMENT_P12 Achievement Payment Period   Numeric 15,5
A_BAL_PAYMENT_P12 A_BAL_PAYMENT_P12 Balancing Payment Period   Numeric 15,5
A_TOTAL_PAYMENT_P12 A_TOTAL_PAYMENT_P12 Total Payment Period 12  Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_P12 A_SLN_PAYMENT_P12 Any SLN or Payments Period 12  SLN Payment Data Definition Numeric 1
A_OP_SLN_Y2D A_OP_SLN_Y2D On Programme SLN Year To Date   Numeric 15,5
A_ACH_SLN_Y2D A_ACH_SLN_Y2D Achievement SLN Year To Date   Numeric 15,5
A_BAL_SLN_Y2D A_BAL_SLN_Y2D Balancing SLN Year To Date   Numeric 15,5
A_TOTAL_SLN_Y2D A_TOTAL_SLN_Y2D Total SLN Year To Date  Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_Y2D A_ALS_PAYMENT_Y2D ALS Payment Year To Date   Numeric 15,5
A_OP_PAYMENT_Y2D A_OP_PAYMENT_Y2D On Programme Payment Year To Date   Numeric 15,5
A_ACH_PAYMENT_Y2D A_ACH_PAYMENT_Y2D Achievement Payment Year To Date   Numeric 15,5
A_BAL_PAYMENT_Y2D A_BAL_PAYMENT_Y2D Balancing Payment Year To Date   Numeric 15,5
A_TOTAL_PAYMENT_Y2D A_TOTAL_PAYMENT_Y2D Total Payment Year To Date  Total Funding data definition Numeric 15,5
A_OP_SLN_EFY A_OP_SLN_EFY On Programme SLN Expected for Year Numeric 15,5
A_ACH_SLN_EFY A_ACH_SLN_EFY Achievement SLN Expected for Full Year Numeric 15,5
A_BAL_SLN_EFY A_BAL_SLN_EFY Balance SLN Expected for Full Year Numeric 15,5
A_TOTAL_SLN_EFY A_TOTAL_SLN_EFY SLN Expected for Full Year Total Funding data definition Numeric 15,5
A_ALS_PAYMENT_EFY A_ALS_PAYMENT_EFY Additional Learner Support Payment Expected for Full Year Numeric 15,5
A_OP_PAYMENT_EFY A_OP_PAYMENT_EFY On Programme Payment Expected for Full Year Numeric 15,5
A_ACH_PAYMENT_EFY A_ACH_PAYMENT_EFY Achievement Payment Expected for Full Year Numeric 15,5
A_BAL_PAYMENT_EFY A_BAL_PAYMENT_EFY Balance Payment Expected for Full Year Numeric 15,5
A_TOTAL_PAYMENT_EFY A_TOTAL_PAYMENT_EFY Payment Expected for Full Year Total Funding data definition Numeric 15,5
A_SLN_PAYMENT_EFY A_SLN_PAYMENT_EFY Any SLN or payments expected for full year SLN Payment Data Definition Numeric 1
A_IY_SLN_PAYMENT A_IY_SLN_PAYMENT Does The Aim Generate SLN or Receive In Year Payment, Up to The Current Period In Year SLN Payment Data Definition Numeric 1
P_IY_SLN_PAYMENT P_IY_SLN_PAYMENT Programme Generates SLN or Receives an In Year Payment, Up to The Current Period In Year SLN Payment Numeric
L_IY_SLN_PAYMENT L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date In Year SLN Payment Numeric
A_PRIOR_SLN_
PAYMENT 		A_PRIOR_SLN_PAYMENT Has the Aim Generated SLN or Received a Payment in Previous Years Prior SLN Payment Numeric 1
P_PRIOR_SLN_
PAYMENT		 P_PRIOR_SLN_PAYMENT Programme Generated SLN or Received a Payment Prior to This Year Prior SLN Payment Data Definition Numeric
L_PRIOR_SLN_
PAYMENT		 L_PRIOR_SLN_PAYMENT Learner received an SLN or Payment in Previous Year(s) Prior SLN Payment Numeric
A_IY_QUALIFYING
_SLN_PERIOD		 A_IY_QUALIFYING_SLN_PERIOD Aim Passes In Year Qualifying Period to be Eligible to Generate SLN In Year Qualifying SLN Period Numeric 1
A_TODATE_QUALIFYING_
SLN_PERIOD		 A_TODATE_QUALIFYING_SLN_PERIOD Aim Passes the Qualifying Period in Any Year to be Eligible to Generate SLN To Date SLN Qualifying SLN Period Numeric 1
A_FULLY_FUNDED A_FULLY_FUNDED Aim Fully Funded Fully Funded Numeric 1
A_FUNDED_AGE_BAND A_FUNDED_AGE_BAND_DLF Age Band Used in DLF Funding Calc Age Numeric 1

Date last modified: 29th July 2009