CATE Course Extract

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
• Current School Only – Includes all records associated with the current school that meet the selection criteria.
• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.
• ASAP – Execute the report in the order it is received in the Report Queue.
• At Night – Execute the report during the next evening.
• On Weekend – Execute the report during the next weekend.
• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

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.

Attendance Calculations

If running this extract for multiple schools, please verify that each individual school uses the term codes listed on the report interface. If one or more schools use different term codes, run the extract one school at a time.

List all term codes that are part of Semester 1 NOT including the year term (comma delimited):

Type the term codes that are part of Semester 1, not including the year term (for example Q1 and Q2). Use a comma to separate the term codes.

List all term codes that are part of Semester 2 NOT including the year term (comma delimited):

Type the term codes that are part of Semester 2, not including the year term (for example Q3 and Q4). Use a comma to separate the term codes.

1600

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

1610

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

1620

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

1200

Teacher Certification ID

This field contains the certification ID assigned to the teacher responsible for teaching this course. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[Teachers]NH_educatorID

Numeric

10

N/A

1201

Teacher Certification ID 2

If applicable, this field contains the certification ID assigned to a secondary teacher responsible for teaching this course. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

This field is blank if this course is taught only by one teacher.

[Teachers]NH_educatorID

Numeric

10

N/A

1202

Teacher Certification ID 3

This field contains the certification ID assigned to a tertiary teacher responsible for teaching this course. This field is extracted from the Edit Staff Information page, Start Page > Staff > Select A Staff Member > Edit Information.

This field is blank if this course is taught only by one or two teachers.

[Teachers]NH_educatorID

Numeric

10

N/A

1740

Program ID

This field contains the CIP code identifying the program in which the student is enrolled. This field is extracted from the Edit Course district Information page, Start Page > District Setup > Edit Course District Information.

[Courses]Code

Alpha-numeric

10

N/A

1400

Begin Date

This field contains the beginning date for this course for the given year and term. This date is calculated based on the [Terms]FirstDay field.

N/A

Date

10

N/A

1410

End Date

This field contains the end date for this course for the given year and term. This date is calculated based on the [Terms]LastDay field.

N/A

Date

10

N/A

1420

School Year

This field is calculated by extracting the from the current year end date

N/A

Alpha-numeric

12

N/A

1430

Term ID

This field contains the term ID assigned to the course section on the Edit Section page, Start Page > School Setup > Course > Edit Section. If the term ID for the course section is blank, the term ID assigned to the course is extracted from the Edit Course page, Start Page > District Setup > Edit Course.

[S_NH_SEC_X]TermID

OR

[S_NH_CRS_X]TermID

Alpha-numeric

2

N/A

1440

Credits

This field contains the number of credits hours a student earns when successfully completing this course. This field is extracted from the Edit Course page, Start Page > District Setup > Edit Course.

[Courses]Credit_Hours

Alpha-numeric

5

N/A

1460

Room Number

This field contains the number of the room where this course section is taught. This value is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Section.

[Sections]Room

Alpha-numeric

10

N/A

1470

Local Class Code

This field contains the local class code assigned to the course section. This field value is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Section.

[Sections]Course_Number

OR

[S_NH_SEC_X]localClassCode

Alpha-numeric

10

N/A

1480

Local Class Name

This field contains a description of the local class code. This field value is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Section.

[Courses]Course_Name

Alpha-numeric

50

N/A

1770

Length in Minutes

This field contains the number of minutes the course section is in session.

[S_NH_SEC_X]LengthOfClass

Numeric

3

N/A

1780

Number Meeting Semester One

This field contains the number of meeting days in Semester 1. The ADA ADM function is used to calculate this field.

N/A

Numeric

3

N/A

1790

Number Meeting Semester Two

This field contains the number of meeting days in Semester 2. The ADA ADM function is used to calculate this field.

N/A

Numeric

3

N/A

1300

Course ID

This field contains the ID number assigned to this course. This field value is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Course.

[S_NH_CRS_X]Subject_Code

Alpha-numeric

10

N/A

1320

Section Number

This field contains the Section number assigned to this Section of the course. This field value is extracted from the Edit Section page, Start Page > School Setup > Sections > Select Course > Edit Section.

[Sections]Section_Number

Alpha-numeric

10

N/A