NJ SMART Career and Technical Data 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.

Students to Include

The default option is All students. Select this option to begin the report query with all students.

Choose The selected # students only option to begin the report query with the currently selected students only.

Note: If you run the extract for a specific group of students, all students in the group are included on the extract, even if a student is not enrolled on the entered snapshot date.

Start Date

The start date for attendance calculation purposes, typically the firstday of school.

End Date

The last date for attendance calculation purposes, typically the last day of school.

Snapshot Date

Enter the snapshot date used to select the student enrollment records to include in the report selection criteria. The default is June 30 of the current year.

Unassigned State ID’s

Click Exclude Students with unassigned State ID Numbers to exclude students that do not have a SID number from the extract. By default, students without SID numbers are included in the extract.

Tally CTE Program College Credit Values

Select the course credits you want to include in the calculated college credit value. Your choices are:

• Courses that have been completed
• Courses that have not been completed
• Both – completed and not completed

Enter Code Category Linked to Truancy

Enter the Attendance Category code used to count absences defined as Truant.    Any days of absence with Absence Codes related to this Attendance Category will be included in the calculation of Cumulative Days Towards Truancy.

Selects the student name to be printed in the report.

Valid values:

• Preferred Name
• Legal Name

Note: Preferred Name is the name visible in all PowerSchool student pages.

1

Local Identification Number

This field contains the number used by the district to identify the student. If that field is blank, the student number is extracted.

This field is extracted from the Demographics page, Student Selection > Demographics.

[S_NJ_STU_X]District_StudentID

If blank, [Students]Student_Number

Alpha-numeric

N/A

2

State Identification Number

This field contains the number used by the state of New Jersey to identify the student. This field is extracted from the This field value is extracted from the NJS SID tab, Student Selection > State/Province – New Jersey > NJS SID.

[Students]State_StudentNumber

Alpha-numeric

N/A

4

First Name

This field contains the student’s first name. This field is extracted from the Demographics page, Student Selection > Demographics.

Note: If populated, the report will extract the student's legal first name.

[Students]First_name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

30

5

Last Name

This field contains the student’s last name. This field is extracted from the Demographics page, Student Selection > Demographics.

Note: If populated, the report will extract the student's legal last name.

[Students]Last_name

[StudentCoreFields]PSCore_Legal_Last_Name

Alpha-numeric

30

6

Date of Birth

This field contains the student’s date of birth. This field is extracted from the NJS SID tab, Student Selection > State/Province – New Jersey > NJS SID.

Format: MM/DD/YYYY

[Student]DOB

Alpha-numeric

10

7

CIP Code

This field contains the state-approved Classification of Instructional Program (CIP) code in which this CTE student is enrolled. This field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]PrimaryCIPCode

Alpha-numeric

6

8

CTE Program Status

This field contains the code that identifies the progress made by the CTE student that is enrolled in an approved CTE program. This field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]CTEProgramStatus

Alpha-numeric

4

9

CTE Test Skill
(Obsolete)

If the CTE Program Status field value is 3 (COMP), this field contains the code that identifies the results of the technical skills assessment. Otherwise, this field is left blank.

If applicable, this field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]CTETestSkillAssesment

Alpha-numeric

1

10

CTE Test Developer
(Obsolete)

If the CTE Program Status field value is 3 (COMP), this field contains the code that identifies the type of skills assessment this student took at the end of the program. Otherwise, this field is left blank.

This field value is extracted from the Edit Course District page, Start Page >School Setup >Courses.

Note: A value will not extract in this field for Completers if there is no Stored Grade for the course.

[S_NJ_CRS_X]CTETestDeveloperCode

Alpha-numeric

1

11

CTE Test Name
(Obsolete)

If the CTE Program Status field value is 3 (COMP), this field contains the test assessment this student took at the end of the CTE program. Otherwise, this field is left blank.

This field value is extracted from the Edit Course District page, Start Page >School Setup >Courses.

Note: A value will not extract in this field for Completers if there is no Stored Grade for the course.

[S_NJ_CRS_X]CTETestName

Alpha-numeric

3

12

Single Parent Status

A Y value in this field identifies the student as a single parent or a single pregnant woman. An N value in this field indicates the student is not a single parent or single pregnant woman.

This field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]CTESingleParentStatus_YN

Alpha-numeric

1

College Credits Earned 

An indication of whether a CTE student has attained postsecondary dual/concurrent credit or postsecondary articulated credit within a sequence of courses in a CTE Program or CTE Program of Study, or no postsecondary credit attained.

Valid Values:  0, 1, 2

[S_NJ_STU_X]CollegeCreditsEarned

13

CTE College Credits Earned (Obsolete)

A Y value in this field indicates the student has completed college credit-bearing courses that are part of a recognized CTE articulation agreement. An N value in this field indicates the student has not completed college credit-bearing courses that are part of a recognized CTE articulation agreement.

This field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]CTEProgramOfStudy_YN

Alpha-numeric

1

Type of Earned College Credits (Obsolete)

14

Number of CTE College Credits 

If the Program of Study field value is Y for this student, the CTE College Credit value entered on the NJS CTE tab is extracted for this field. However, if the CTE College Credit field is blank, the Tally for CTE Program College Credit Values field on the report interface is used to calculate this credit value as follows:

If the Tally CTE Program Credit Values field value is Courses that have been completed, the sum of credits earned by the student for each course where the course CIP code equals the student’s Primary CIP Code is included in the extract.

If the Tally CTE Program Credit Values field value is Courses that have not been completed, the sum of possible credits for each course where the course CIP code equals the student’s Primary CIP Code is included in the extract.

If the Tally CTE Program Credit Values field value is Both – completed and not completed, the sum of possible credits and student earned credits for each course where the course CIP code equals the student’s Primary CIP Code is included in the extract.

[S_NJ_STU_X]CTECollegeCredits

OR

[S_NJ_CRS_X]CTECollegeCredits

Numeric

2

15

Post Secondary Institution

This field contains the code identifying the post secondary institution at which the student has earned the most academic credits as part of the CTE recognized articulation agreement.

This field value is extracted from the NJS CTE tab, Student Selection > State/Province – New Jersey > NJS CTE.

[S_NJ_STU_X]CTEPostSecondaryInstitution

Alpha-numeric

8

-

Cumulative Days In Membership

(Obsolete)

Discontinued Spring 2021

The cumulative number of membership days that apply to this Shared Time ([Students]Shared_Time) student.

If the Cumulative Days in Membership value is blank on the NJ SMART Student page, this field value is calculated.

If the Cumulative Days in Membership value is not blank on the NJ SMART Student page, and the Add Value check box is not selected, this field displays the value entered in the Cumulative Days in Membership field.

If the Cumulative Days in Membership value is not blank on the NJ SMART Student page, and the Add Value check box is selected, this field displays the sum of the calculated membership value plus the value entered in the Cumulative Days in Membership field.

This field value is extracted from the Start Page > Student Selection > New Jersey State Information> NJS Student Tab.

Calculated

Or

[S_NJ_STU_X]CumulativeDaysInMembership

Or

Null value extracts for non-Shared Time students

Numeric

5

-

Cumulative Days Present

(Obsolete)

Discontinued Spring 2021

The cumulative number of days that for this Shared Time student was present is displayed.

If the Cumulative Days Present value is blank on the NJ SMART Student page, this field value is calculated.

If the Cumulative Days Present value is not blank on the NJ SMART Student page, and the Add Value check box is not selected, this field displays the value entered in the Cumulative Days Present field.

If the Cumulative Days Present value is not blank on the NJ SMART Student page, and the Add Value check box is selected, this field displays the sum of the calculated membership value plus the value entered in the Cumulative Days Present field.

This field value is extracted from the Start Page > Student Selection > New Jersey State Information> NJS Student Tab.

Calculated

Or

[S_NJ_STU_X]CumulativeDaysPresent

Or

Null value extracts for non-Shared Time students

Numeric

5

-

Cumulative Days Towards Truancy

(Obsolete)

Discontinued Spring 2021

The number of days that this Shared Time student has accumulated towards qualifying as truant.

If the Cumulative Days Towards Truancy value is blank on the NJ SMART Student page, this field value is calculated.

If the Cumulative Days Towards Truancy value is not blank on the NJ SMART Student page, and the Add Value check box is not selected, this field displays the value entered in the Cumulative Days Towards Truancy field.

If the Cumulative Days Towards Truancy value is not blank on the NJ SMART Student page, and the Add Value check box is selected, this field displays the sum of the calculated membership value plus the value entered in the Cumulative Days Present field.

This field value is extracted from the Start Page > Student Selection > New Jersey State Information> NJS Student Tab.

Calculated

Or

[S_NJ_STU_X]CumulativeDaysTowardTruancy

Or

Null value extracts for non-Shared Time students

Numeric

5

[S_NJ_SEC_X]CTECountyCodeAssigned

[S_NJ_CRS_X]CTECounty_Code_Override

[S_NJ_SEC_X]CTEDistrictCodeAssigned

[S_NJ_CRS_X]CTEDistrict_Code_Override

[S_NJ_SEC_X]CTESchoolCodeAssigned

[S_NJ_CRS_X]CTESchool_Code_Override

[S_NJ_SEC_X]NCES_Subject_Area

[S_NJ_CRS_X]NCES_Subject_Area

[S_NJ_SEC_X]NCES_Course_ID

[S_NJ_CRS_X]NCES_Course_ID

CTE Work-based Learning

An indication of whether each secondary CTE student has participated in a work-based learning experience within the academic year.

If this field is left blank, a value of 0 is reported.

The chosen method for delivering instruction to the student - fulltime on premises, hybrid (partial in person on premises/partial remote), or fulltime remote. Further, denote whether the student is fulltime remote due to parental or guardian choice or fulltime remote because the district has not yet offered the student another option.

*Note: Same as reported for SID