CATE Student Enrollment Extract
Contents
Introduction
This report produces a Beginning, Middle, or End of Year Submission for students enrolled in a career and technical education program.
Prior to generating this extract, verify that the term is set to the school year for which you want to run the report.
Selection Criteria
Selection criteria determine which database records are used in the report. For the CATE Student Enrollment Extract, student enrollment records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school is associated with a student included in the report.
- The school is not excluded from state reporting.
Student Selection
The report selects which student records to use based on the following criteria:
- The student is not enrolled in a school that is excluded from state reporting.
- The student is not excluded from state reporting.
- The student has an active school enrollment during the reporting period.
- The student is not excluded from CATE extracts.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools* | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Report Start Date* | Enter the first date in the date range for this report. Any course that is active after this date is included on the report, if the course and/or school are not excluded from state reporting. |
Report End Date* | Enter the last date in the date range for this report. Any course that is active prior to this date is included on the report, if the course and/or school are not excluded from state reporting. |
Reporting Period* | Select the reporting period for which you want to run the report.
|
Include Column Headings* | Select whether to include or not include column headers in the report. |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run nightly. Check the weekdays only box. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # or Position | Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin / End Position |
1 | SASID | This field contains SASID assigned to this student by the New Hampshire Department of Education. This field is extracted from the Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements. | [Students]State_StudentNumber | Numeric | 10 | N/A |
2 | Date of Birth | This field contains the student’s date of birth. This field is extracted from the Start Page > Student Selection > General Demographics. | [Students]DOB | Date | 8 | N/A |
3 | SAU Number Send | This field contains the SAU number assigned to the school financially responsible for the student. This field is extracted from the Current Enrollment page, Start Page > Student Selection > Transfer Information. | [S_NH_STU_CATE_X]SAU_Number_Send OR [S_NH_REN_CATE_X]SAU_Number_Send | Numeric | 3 | N/A |
4 | District Number Send | This field contains the number of the district financially responsible for the student. This field is extracted from the Current Enrollment page, Start Page > Student Selection > Transfer Information. | [S_NH_STU_X]DistrictResponsible OR [S_NH_REN_X]District_Responsible | Numeric | 3 | N/A |
5 | School Number Send | This field contains the number of the school financially responsible for the student. This field is extracted from the Current Enrollment page, Start Page > Student Selection > Transfer Information. | [S_NH_STU_CATE_X]School_Number_Send OR [S_NH_REN_CATE_X]School_Number_Send | Numeric | 5 | N/A |
6 | SAU Number Receive | This field contains the school administrative unit number assigned to the SAU where the Career and Technical Education Center is located. This field is extracted from the Start Page > District Setup > District Information. | [Prefs]NH_SAUNbr | Numeric | 3 | N/A |
7 | District Number Receive | This field contains the number of the district where the t. This field is extracted from the Start Page > District Setup > District Information. | [Schools]District_Number OR [Prefs]Name-districtnumber | Numeric | 3 | N/A |
8 | School Number Receive | This field contains the number identifying the Career and Technical Education Center. This field is extracted from the Alternate School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. If the Alternate School Number field is blank, this field is extracted from the School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Schools]Alternate_School_Number Or [Schools]School_Number | Numeric | 5 | N/A |
9 | School Year | This field is calculated. | Based On: ~(v.curyearid) | Alpha-numeric | 12 | N/A |
10 | Grade | This field contains the student’s grade level. This field is extracted from the Grade Level field under the New Hampshire State Reporting section on the Edit Current Enrollments page, Start Page > Student Selection > Transfer Information. If this field is blank, the grade level decoded with the correct values for the report. | [Students]Grade_Level OR [ReEnrollments]Grade_Level OR [S_NH_STU_X]State_GradeLevell OR [S_NH_REN_X]State_GradeLevel | Numeric | 2 | N/A |
11 | CATE Enrollment Status | This field contains the enrollment stats of the student for the specified reporting period. | [S_NH_STU_CATE_X]EnrollStatus OR [S_NH_REN_CATE_X]EnrollStatus | Numeric | 2 | N/A |
12 | Entry Date | This field contains the date the student enrolled in the district. Entry date must be greater than or equal to the first day of the school. This field is extracted from the All Enrollments page, Start Page > Student Selection > All Enrollments. | [CC]DateEnrolled | Date | 10 | N/A |
13 | Entry Code | This field contains the code identifying the reason the student enrolled in the Career and Technical Education Center. This field is extracted from the Current Enrollment page, Start Page > Student Selection > Transfer Information. | [S_NH_STU_CATE_X]EntryCode OR [S_NH_REN_CATE_X]EntryCode | Numeric | 3 | N/A |
14 | Exit Date | This field contains the date the student withdrew from the district. Exit date must be less than or equal to the last date of school. This field is extracted from the All Enrollments page, Start Page > Student Selection > All Enrollments. | [CC]DateLeft | Date | 10 | N/A |
15 | Exit Code | This field contains the code identifying the reason the student withdrew. This field is extracted from the Current Enrollment page, Start Page > Student Selection > Transfer Information. | [S_NH_STU_CATE_X]ExitCode OR [S_NH_REN_CATE_X]ExitCode | Numeric | 3 | N/A |
16 | Primary Program ID (CIP Code) | This field contains the CIP code identifying the program in which the student is enrolled. This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]Primary_ProgID | Alpha-numeric | 10 | N/A |
17 | Program Completer | This field contains a 1 if the student has completed all required courses within a specific program and all technical core program competencies at a proficient level. This field contains a zero (0) for a student who has not completed the program. This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]ProgramCompleter | Numeric | 1 | N/A |
18 | Address | No longer required - leave blank. |
| Alpha-numeric | 50 | N/A |
19 | Address 2 | No longer required - leave blank. |
| Alpha-numeric | 50 | N/A |
20 | Town | No longer required - leave blank. |
| Alpha-numeric | 50 | N/A |
21 | State | No longer required - leave blank. |
| Alpha-numeric | 2 | N/A |
22 | Postal Code | No longer required - leave blank. |
| Alpha-numeric | 12 | N/A |
23 | Telephone | No longer required - leave blank. |
| Alpha-numeric | 20 | N/A |
24 | Work | No longer required - leave blank. |
| Numeric | 1 | N/A |
27 | Transportation Mode | This field contains the code identifying how the student is transported to the CTE Center, if the student does not reside in the district where the CTE center is located (a tuitioned student). This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]TranMode | Numeric | 1 | N/A |
28 | CATE Days in Attendance S1 | This field contains the number of days in Semester 1 that the student was in attendance at the CTE. Semester 1 is not included in the BOY. The ADA ADM function is used to calculate the attendance. | N/A | Numeric | 3 | N/A |
29 | CATE Days in Attendance S2 | This field contains the number of days in Semester 2 that the student was in attendance at the CTE. Semester 2 is not included in the BOY or MOY. The ADA ADM function is used to calculate the attendance. | N/A | Numeric | 3 | N/A |
30 | Displaced Homemaker | A value of 1 in this field indicates that the student qualifies as a displaced homemaker. A value of 0 in this field indicates that the student does not qualify as a displaced homemaker. This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]DisplacedHomemaker | Alpha-numeric | 1 | N/A |
31 | Single Parent/Single Pregnant Woman | A value of 1 in this field indicates that the student qualifies as a single parent of single woman who is pregnant. A value of 0 in this field indicates that the student does not qualify as a single parent of single woman who is pregnant. This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]SingleParent | Alpha-numeric | 1 | N/A |
32 | PrimaryProgramFlag | A value of Y is calculated if Primary Program ID matches the CIP code in a course the student is currently enrolled in, otherwise N. | N/A | Alpha-numeric | 1 | N/A |
33 | TSAFlag | Technical Skill Assessment Flag. This field is extracted from the CATE Data Elements page, Start Page > Student Selection > New Hampshire State Information > CATE Data Elements. | [S_NH_STU_CATE_X]Tech_Skill_Assessment_flag | Alpha-numeric | 1 | N/A |