CTE Student Fact
Field # | Field Name | Required? | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPlus? |
---|---|---|---|---|---|---|
1 | Submitting AUN | R | 9 | reg_district.state_equiv_code | 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 | PASECUREID | R | 10 | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: State Reporting ID | |
4 | CIP School Number | R | 4 | reg_entry_with.building using reg_building.state_code_equiv | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel > click appropriate School Year link > Enrollment panel: Building | |
5 | Student School Number | R | 4 | reg_entry_with.building using reg_building.state_code_equiv | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel > click appropriate School Year link > Enrollment panel: Building | |
6 | CIP Code | R | 12 | reg_user.field_value where screen_number=’400’ and field_number=’1’ | patb_cip_code | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: CIP Code field |
7 | Delivery Method Code | R | 12 | reg_user.field_value where screen_number=’400’ and field_number=’2’ | patb_delivery_code | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Delivery Method field |
8 | Reporting Date | R | 10 | reg_user.field_value where screen_number=’400’ and field_number=’3’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Reporting Date field “XXXX-06-30”, where XXXX is the current school year | |
9 | Reporting Date Period Level | R | 10 | reg_user.field_value where screen_number=’400’ and field_number=’4’defaults to Year | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Reporting Date Period Level field | |
10 | CTE Status Type Code | R | 12 | reg_user.field_value where screen_number=’400’ and field_number=’5’ | patb_cte_status | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: CTE Status Type field |
11 | CTE Program Completion Plan Code | R | 12 | Hardcoded to N/A | N/A | |
12 | Registered Apprentice Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’6’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Registered Apprenticeship field | |
13 | Internship Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’7’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Internship field | |
14 | Cooperative Work Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’8’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Cooperative Work field | |
15 | Job Exploration Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’9’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Job Exploration field | |
16 | Agriculture Experience Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’10’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Agriculture Experience field | |
17 | School-Sponsored Enterprise Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’11’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: School Spon Enterprise field | |
18 | Number of Program Hours Completed | R | 7,2 | reg_user.field_value where screen_number=’400’ and field_number=’12’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Program Hours field | |
19 | Percentage of Program Completed | R | 6,2 | reg_user.field_value where screen_number=’400’ and field_number=’13’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Percent Complete field | |
20 | Cumulative Post-Secondary Credits Earned | R | 6,2 | reg_user.field_value where screen_number=’400’ and field_number=’15’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Post Secondary Credits field | |
22 | Work Based Experience Indicator | R | 1 | reg_user.field_value where screen_number=’400’ and field_number=’14’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Work Based Experience field | |
25 | CTE Program Performance Code | CR | reg_user.field_value where screen_number=’400’ and field_number=’16’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: CTE Program Performance Code | ||
26 | Pell Grant Indicator | CR | reg_user.field_value where screen_number=’400’ and field_number=’17’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: Pell Grant Indicator | ||
28 | POS Task List Completion Indicator | CR | reg_user.field_value where screen_number=’400’ and field_number=’19’ | Registration > Entry & Reports > Student District Defined > PIMS CTE Student: POS Task List Complete |