Programs Fact File Layout
The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Programs Fact file.
* = Required for all students
+ = Required only for specified students
Field # | FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name | Positions | NYS or Local Purpose | eSchoolPlus Table.Column | Where in eSchoolPlus? |
|---|---|---|---|---|---|
1 | *DISTRICT CODE (DISTRICT OF RESPONSIBILITY CODE) | 1 - 8 | NYS Reporting | reg_district.state_code_equiv If length is Not 8 or first character is Not "8", then "NY" + first 6 characters | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE (BUILDING OF ENROLLMENT CODE) | 9 - 14 | Local use only | reg_building.building Check value for program with state_code_equiv 'NYALTACC'. If set then report reg_programs.program_value | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building or, Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "NYALTACC" |
3 | *SCHOOL YEAR DATE (SCHOOL YEAR) | 15 - 24 | NYS Reporting | School Year Prompt-06-30 | N/A |
4 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 25 - 36 | NYS Reporting | reg_entry_with.student_id | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Student ID |
5 | *PROGRAMS CODE (PROGRAM SERVICE CODE) | 37 - 44 | NYS Reporting | State_Code_Equiv of the program value | Registration > Entry & Reports > Student Demographic > Programs: State Code Equiv for programs required to be sent to the State |
6 | *BEGINNING DATE (PROGRAM SERVICE ENTRY DATE) | 45 - 54 | NYS Reporting | reg_programs.start_date | Registration > Entry & Reports > Student Demographic > Programs: Start Date |
7 | +ENDING DATE (PROGRAM SERVICE EXIT DATE) | 55 - 64 | NYS Reporting | reg_programs.end_date If Blank, then Withdrawal Date BLANK if withdrawal reason is not entered | Registration > Entry & Reports > Student Demographic > Programs: Exit Date Or, Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Date |
8 | +STATE LOCATION ID (PROGRAM SERVICE PROVIDER BEDS CODE) | 65 - 84 | NYS Reporting | reg_building.state_code_equiv where reg_building.building = building (from Service Provider, Alternate Accountability Building, or Enrollment Building) | Registration > Entry & Reports > Student Demographic > Programs: Server Provider value Or, Registration > Entry & Reports > Student Demographic > Programs: Alternate Accountability Building value Or, Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building |
9 | +PROGRAM INTENSITY (CTE/TECH PREP PROGRAM INTENSITY) | 85 - 104 | NYS Reporting | reg_programs.program_value And reg_programs.program_id = 'CTE' And reg_programs.field_number = '4' using nytb_prg_intensity.description or, reg_programs.program_value converted to nytb_ell_service_level.code when reg_programs.program_id and field_number map to reg_program_column.state_code_equiv = 0231 | Registration > Entry & Reports > Student Demographic > Programs > CTE – NY Career Tech Education (CTE) program: Program Intensity Registration > Entry & Reports > Student Demographic > Programs > LEP – NY Limited English Proficiency: ELL Service Level |
10 | ENTRY REASON CODE 1 | 105 - 114 | Local use only | N/A | |
11 | ENTRY REASON CODE 2 | 115 - 124 | Local use only | N/A | |
12 | ENTRY REASON CODE 3 | 125 - 134 | Local use only | N/A | |
13 | +EXIT REASON CODE 1 (REASON FOR ENDING PROGRAM SERVICE CODE) | 135 - 144 | NYS Reporting | reg_programs.withdrawal_reason Blank if reg_programs.program_id <> "CTE" And Programs Code Not In ("0232", "5786", "0352", "0363", "0385", "0396", "0407", "0418", "0429", "0440", "0451", "0462", "0473", "0484", "0495", "0231") | Registration > Entry & Reports > Student Demographic > Programs: Withdrawal Reason |
14 | EXIT REASON CODE 2 | 145 - 154 | Local use only | N/A | |
15 | EXIT REASON CODE 3 | 155 - 164 | Local use only | N/A | |
16 | PROGRAM COMMENT | 165 - 224 | Local use only | N/A | |
17 | ORIGINAL PGM START DATE | 225 - 234 | Local use only | N/A | |
18 | +PARTICIPATION INFO CODE (CTE PROGRAM TYPE) | 235 - 240 | NYS Reporting | reg_programs.program_value where reg_programs.program_id = 'CTE' And reg_programs.field_number = '2' | Registration > Entry & Reports > Student Demographic > Programs > CTE – NY Career Tech Education (CTE) program: Participation Info Code |
19 | PROGRAM FREQUENCY | 241 – 243 | Leave blank | N/A | |
20 | +PROGRAM DURATION | 244 – 247 | NYS Reporting | Calculated if reg_programs.program_id maps to either reg_program_column.state_code_equiv = 4026 or 4027 Refer to the HEDUC – NY Higher Education (STEP/LPP) section in Programs Setup for details on the calculation. It will be a value from 1 to 6. Leave blank Note: This field was earlier required to report the duration of a NYS P-Tech program (program code 4026) and a NYC P-Tech program (program code 4027) both of which are moved to the Partner Project Fact report. | This is calculated for any record created where the student is active in Registration > Entry & Reports > Student Demographic > Programs > HEDUC: NYS P-Tech Program Or, NYC P-Tech Grades 9-14 Program |
21 | PROGRAM CYCLE | 248 – 257 | Leave blank | N/A | |
22 | PROGRAM PROVIDER NAME | 258 – 307 | Leave blank | N/A | |
23 | +PROGRAM PROVIDER TYPE CODE (HOMELESS PRIMARY NIGHTTIME RESIDENCE) | 308 – 327 | NYS Reporting | reg_programs.program_value where reg_programs.program_id = 'NIGHT' And reg_programs.field_number = '44' | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) program: Homeless Night Res |
24 | PROGRAM LOCATION DISTRICT CODE | 328 – 347 | Leave blank | N/A | |
25 | PROGRAM STUDENT ID | 348 - 372 | Leave blank | N/A | |
26 | PARENTAL PERMISSION CODE | 373 - 392 | Leave blank | N/A | |
27 | PROGRAM SESSION CODE | 393 - 412 | Leave blank | N/A | |
28 | +PROGRAM ELIGIBILITY CODE 1 | 413 – 432 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the first reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the first of these fields where the Value box is checked:
| |
29 | +PROGRAM ELIGIBILITY CODE 2 | 433 – 452 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the second reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the second of these fields where the Value box is checked:
| |
30 | +PROGRAM ELIGIBILITY CODE 3 | 453 – 472 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the third reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the third of these fields where the Value box is checked:
| |
31 | +PROGRAM ELIGIBILITY CODE 4 | 473 – 492 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the fourth reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the fourth of these fields where the Value box is checked:
| |
32 | +PROGRAM ELIGIBILITY CODE 5 | 493 – 512 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the fifth reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the fifth of these fields where the Value box is checked:
| |
33 | +PROGRAM ELIGIBILITY CODE 6 | 513 - 532 | If the Program Service Code is either 5817 or 5806, the download reports reg_program_column.state_code_equiv for the sixth reg_programs record where program_id = NCLB, the field_number maps to reg_program_column.link_dates_to = 19, and program_value = Y. The download populates the Program Eligibility Codes ordered by the reg_programs.field_number. Valid state_code_equivs are DCMP, APP, HOMELESSCH, MIGRANTYOU, RUNAWAY, FOSTER, FDPIR, HSTART, or CARRYOVER. The download converts the APP value to APPLICATION. Leave blank | Registration > Entry & Reports > Student Demographic > Programs > NCLB – NY No Child Left Behind (NCLB) The download reports based on the sixth of these fields where the Value box is checked:
|