Field # | Field Name | Required? | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPlus? |
---|
1 | Submitting AUN | R | 9 | reg_district.state_code_equiv | reg_district | Administration > General Setup > District > District > Preferences panel > Other panel: State Code Equivalent |
2 | School Year Date | R | 10 | | | School Year Prompt from the PIMS Download page |
3 | Calendar ID | R | 12 | reg_user_district.field_value where screen_number=’500’ and field_number=’2’ | | Administration > General Setup > District District Defined > PIMS Calendar: Calendar |
4 | PASECUREID | R | 10 | reg_personal.state_report_id | | Registration > Entry & Reports > Student Demographic > Personal > General panel: State Reporting ID |
5 | District of Residence AUN | R | 9 | reg_programs.value where state_code_equiv = ‘DISTRES’ | | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘DISTRES’ |
6 | Funding District AUN | R | 9 | reg_programs.value where state_code_equiv = ‘DISTFUND’ | reg_district | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘DISTFUND’ |
7 | Residence Status Code | R | N/A | reg_programs.value where state_code_equiv = ‘RESIDENT’ using state_code_equiv | regtb_residency (Residencies) | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘RESIDENT’ |
8 | Days Enrolled | R | 3 | Count of att_stu_day_memb.membership_value where membership_value >0 | | Attendance > All > Student > Day Totals > Day Totals panel: Count of Membership column for appropriate Date Range and Building |
9 | Days Present | R | 6 | count of membership days (from att_stu_day_memb) – sum of absences values (from att_stu_day_totals) | | Attendance > All > Student > Day Totals > Day Totals panel: Count of Membership column minus sum of Value column |
10 | Percentage of Time Enrolled for Calendar | R | 3 | ((reg_programs.value where state_code_equiv=’WEIGHT’)*Days/Days) *100 or if no WEIGHT program values found, then def_mem_value from reg calendar * 100 | | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘PAWGT’ (see the section How the Percentage Data is Used in the PIMS Student Calendar File) |
11 | Grade | R | 3 | reg.grade | reg_grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel > click appropriate School Year link > Enrollment panel: Grade |
13 | Sending Charter School - School Number | CR | 4 | reg_programs.value where state_code_equiv = ‘PACHARTER’ and field_number=2 | regtb_state_bldg | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘PACHARTER’, field 2 |
14 | Sending Charter School AUN | CR | 9 | reg_programs.value where state_code_equiv = ‘PACHARTER’ and field_number=1 | reg_district | Registration > Entry & Reports > Student Demographic > Programs: Program with State Code Equiv of ‘PACHARTER’, field 1 |
15 | Special Education Indicator | R | 1 | | | |
16 | Days Absent - Unexcused | R | 6 | | | |