NJ ASSA Student Data Validation 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.

Date to Scan

Enter the date to scan for the report. Usually, this date is October 15 of the current school year.

1

Student Number

This field contains the locally assigned student number. This field value is extracted from the Demographics page, Student Selection > Demographics.

[Students]student_number

Numeric

N/A

2

LastFirst

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

[Students]lastfirst

Alpha-numeric

35

3

School ID

This field contains the ID number assigned the school in which this student is enrolled. This field is extracted from the Edit School page, District Setup > Schools/School Info.

[Schools]school_number

Numeric

4

4

School Abbreviation

This field contains the abbreviation of the school name. This field is extracted from the Edit School page, District Setup > Schools/School Info.

[Schools]Abbreviation

Alpha-numeric

20

5

Grade level

This field contains the student’s current grade level. This field value is extracted from the Edit Current Enrollment page, Start Page > Transfer Info > Select Current Enrollment.

[Students]grade_level

Alpha-numeric

2

6

Part Time Student

A value of 1 in this field identifies this student as a part-time student. A value of 0 identifies this student as a full-time student.

This field value is extracted from the Modify Information page, Student Selection > Modify Info.

[Students]parttimestudent

Alpha-numeric

1

7

NJ Grade Level Code

This field contains the student’s current grade level for the school enrollment.

Note: If you choose (determine automatically) blank is stored in the database and the NJ Grade Level is calculated based on the Students Grade level, their part-time student setting, and their special status setting.

This field is extracted from the Start Page > Student Selection > State / Province – NJ > NJS Student tab.

[S_NJ_STU_X]GradeLevelCode

Alpha-numeric

2

8

Gender

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

[Students]gender

Alpha-numeric

1

9

Ethnicity

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

[Students]ethnicity

Alpha-numeric

1

10

Date of Birth

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

[Students]dob

Numeric

10

11

Entry Date

This field contains the date the student entered the school district. This field value is extracted from the Edit Current Enrollment page, Start Page > Transfer Info > Select Current Enrollment.

[Students]entrydate

Numeric

10

12

Exit Date

This field contains the date the student withdrew from the school district, if applicable. This field value is extracted from the Edit Current Enrollment page, Start Page > Transfer Info > Select Current Enrollment.

[Students]exitdate

Numeric

10

13

Enroll Status

This field contains the student’s enrollment status.

[Students]enroll_status

Alpha-numeric

1

14

District Of Residence

This field contains the district in which the student resides. This field value is extracted from the Edit Current Enrollment page, Start Page > Transfer Info > Select Current Enrollment.

[Students]DistrictOfResidence

Alpha-numeric

4

15

Shared time

This field contains an am or pm from if the student is a shared time student. This field value is extracted from the NJS Student tab, Student Select > State/Province – New Jersey > NJS Student.

[S_NJ_STU_X]shared_time_code

Alpha-numeric

1

16

Lunch Status

This field identifies the lunch program in which this student participates. It is used to determine the student’s economically disadvantaged student.

This field value is extracted from the Lunch Status page, Student Select > Lunch.

[Students]lunchstatus

Alpha-numeric

4

17

Tier

This field contains the special education tier for the student, if this student as an IEP. This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]SPEDtier

Alpha-numeric

18

Special Education

This field contains the special education classification for the student, if applicable.

Note: This is different from the student’s special education enrollment.  Special education enrollment is performed through the Special Programs module. This field value is extracted from the NJS SpEd tab, Student Select > State/Province – New Jersey >NJS SpEd.

[S_NJ_STU_X]SpecialEd_Classification

Alpha-numeric

1

19

NJ PTC Code

This field contains the program type code for the school enrollment. This field value is extracted from the NJS SpEd tab, Student Select > State/Province – New Jersey > NJS SpEd.

Note: If you choose (determine using special program enrollments), this field is blank. The NJ Program Type Code is automatically based on the Students Grade level, their part-time student setting, and their special status setting, and their special program enrollments.

For students with no special program enrollments, the values output will be the same as the NJ Grade Level Code.

For  students with special program enrollments the values output will be 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 56, 57.

[S_NJ_STU_X]ProgramTypeCode

Alpha-numeric

2

20

Tuition code

This field contains the source of payment for a tuition student. This field value is extracted from the NJS Student tab, Student Select > State/Province – New Jersey > NJS Student.

[S_NJ_STU_X]tuition_code

Alpha-numeric

1

21

LEP

A value of 1 is displayed in this field if the student is a Limited English Proficient (LEP) student. A value of 0 indicates that the student is not a Limited English Proficient student.

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

[S_NJ_STU_X]LEP_TF

Alpha-numeric

1

22

Special Status

This field contains the special status for the student. This field value is extracted from the ASSA tab, Student Select > State/Province – New Jersey > ASSA.

[S_NJ_STU_X]special_status

Alpha-numeric

1

23

Private School For Disabled

A value of 1 is displayed in field if this student attends a private school for the disabled. A value of 0 indicates that the student does not attend a private school for the disabled.

This field value is extracted from the ASSA tab, Student Select > State/Province – New Jersey > ASSA.

[S_NJ_STU_X]school_disabled

Alpha-numeric

1

24

Tier I Services – Counseling

A value of 1 in this field indicates that the student is eligible for regular counseling (at least monthly) provided by the schools psychologist, school social worker, or guidance counselor received by the student or their parent or guardian as specified by the student’s IEP. A value of 0 indicates that this student is not eligible for regular counseling.

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

[S_NJ_STU_X]Counseling_Services_YN

Alpha-numeric

1

25

Tier 1 Services - Occupational

A value of 1 in this field indicates that the student is eligible for services specified in the student’s IEP for: improving, developing, or restoring functions impaired or lost through illness, injury, or deprivation; improving ability to perform tasks for independent functioning when functions are impaired or lost; and preventing, through early intervention, initial or further impairment or loss or function. A value of 0 indicates that this student is not eligible for occupational services.

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

[S_NJ_STU_X]Occupational_Therapy_Services_YN

Alpha-numeric

1

26

Tier 1 Services – Physical

A value of 1 in this field indicates that the student is eligible for services and treatments as specified in the student’s IEP provided by a qualified physical therapist. A value of 0 indicates that this student is not eligible for physical therapy services.

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

[S_NJ_STU_X]Physical_Therapy_Services_YN

Alpha-numeric

1

27

Tier I Services – Speech

A value of 1 in this field indicates that the student is eligible for services for the rehabilitation or prevention of communicative disorders as specified in the student’s IEP in addition to another special education program. A value of 0 indicates that this student is not eligible for speech therapy services.

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

[S_NJ_STU_X]Speech_Lang_Therapy_Services

Alpha-numeric

1

28

Tier I Services – Other

A value of 1 in this field indicates that the student is eligible for other services specified in the student’s IEP. A value of 0 indicates that this student is not eligible for other services.

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

[S_NJ_STU_X]Other_Related_Services_YN

Alpha-numeric

1

29

Tier IV Services – Individual Instruction

A value of 1 in this field indicates that the student receives one-to-one instruction for 50% or more of the instructional day by a certified teacher or discrete trial instruction for 10 or more hours per week. A value of 0 indicates that this student does not receive individual instruction.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_ind_instr_TF

Alpha-numeric

1

30

Tier IV Services – Pupil

A value of 1 in this field indicates that the student is in a program in which the number of teachers and aides in the class must be three or less. A value of 0 indicates that this student is not enrolled in this type of program.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_pupil_TF

Alpha-numeric

1

31

Tier IV Services – Assist

A value of 1 in this field indicates that the student belongs in a program requiring a combination of devices that reflect highly advanced assistive technology for the purposes of communication, mobility and/or access to computer and other equipment. A value of 0 indicates that this student does not require high level assistive technology services.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_Assist_TF

Alpha-numeric

1

32

Tier IV Services – Ext Year

A value of 1 in this field indicates that the student belongs to a program requiring a minimum of 10 hours of instruction a week for pre-school disabled students or at least four hours of instruction per day for all other students for 210 or more days in a year. A value of 0 indicates that this student attends school less than 210 days of the year.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_ExtYear_TF

Alpha-numeric

1

33

Tier IV Services – Intensive

A value of 1 in this field indicates that the student belongs to a program that requires related services such as counseling, occupational therapy, physical therapy, speech and others for six or more hours per week. A value of 0 indicates that this student does not require intensive related services.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_Intensive_TF

Alpha-numeric

1

34

Tier IV Services – Interpreter

A value of 1 in this field indicates that the student belongs to a program that requires an interpreter for 60% or more of the pupil’s instructional day. A value of 0 indicates that this student does not require interpreter services.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_Interpreter_TF

Alpha-numeric

1

35

Tier IV Services – Aide

A value of 1 in this field indicates that the student belongs to a program that requires a personal aide for 60% or more of the student’s instructional day. A value of 0 indicates that this student does not require a personal aide for 60% or more of the student’s instructional day.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_Aide_TF

Alpha-numeric

1

36

Tier IV Services – Res Placement

A value of 1 in this field indicates that the student is in a program that requires a residential placement for which the district pays both the day tuition and the full residential cost. A value of 0 indicates that this student does not require residential placement.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_ResPlacement_TF

Alpha-numeric

1

37

Tier IV Services – Ind Nursing

A value of 1 in this field indicates that the student belongs to a program that requires individual nursing services as a related service for 50% or more of the student’s instructional day. A value of 0 indicates that this student does not require individual nursing services as a related service for 50% or more of the student’s instructional day.

This field value is extracted from the Obsolete tab, Student Select > State/Province – New Jersey > Obsolete.

[S_NJ_STU_X]TIV_serv_IndNursing_TF

Alpha-numeric

1