Skip to main content
Skip table of contents

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.

Back to Top

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:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
  • All Schools – Run the report for the entire district.

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:

  • The selected [number] students only – Run the report for students in the current selection.
  • All students – Run the report for all students in the current school or district that meet the selection criteria.

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.

  • BOY - Beginning of Year
  • MOY - Middle of Year
  • EOY - End of Year

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.

Back to Top  

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

32PrimaryProgramFlagA 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/AAlpha-numeric1N/A
33TSAFlag

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_flagAlpha-numeric1N/A

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.