NJ SMART Assessment File Layout

1/1

Local Identification Number

Registration > Entry & Reports > Student Demographic > Registration: Student ID field (reg.student_id)

Required

2/2

State Identification Number

Registration > Entry & Reports > Student Demographic > Personal: State ID field (reg_personal.state_report_id)

Required

10-digit state identification number.

3/3

First Name

Registration > Entry & Reports > Student Demographic > Registration: First Name field (reg.first_name)

Required

Periods are not allowed. The file does accept apostrophes and hyphens.

4/5

Last Name

Registration > Entry & Reports > Student Demographic > Registration: Last Name field (reg.last_name)

Required

Periods are not allowed. The file does accept apostrophes and hyphens.

5/8

Date Of Birth

Registration > Entry & Reports > Student Demographic > Registration: Birth Date field (reg.birthdate)

Required

YYYYMMDD format

6/78

Section 504

Registration > Entry & Reports > Student Demographic > Personal: 504 Plan field (reg_personal.section_504_plan)
 

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: Section 504 Plan field.

(The system looks in reg_program_column for the program__id and field_number associated with state_code_equiv=NJ504PLAN. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

7/79

SE/504 Setting Accommodation

Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Setting Accom field (reg_user.field_value for screen_number=950 and field_number=1).

or,

 If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Setting Accom field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504SETNG. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

8/80

SE/504 Schedule Accommodation

Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Schedule Accom field (reg_user.field_value for screen_number=950 and field_number=2).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Schedule Accom field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504SCHED. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

9/81

SE/504 Test Material Accommodation

Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Test Material Accom field (reg_user.field_value for screen_number=950 and field_number=3).

or ,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Test Material Accom field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504MAT. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

10/82

SE/504 Test Procedure Accommodation

Registration > Entry & Reports > Student District Defined > NJ Section 504: SE 504 Test Procedure Accom field (reg_user.field_value for screen_number=950 and field_number=4).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > NJ504 – NJ Section 504: SE 504 Test Procedure Accom field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJ504PROC. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

11/83

APA Science Test

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Science Test field (reg_user.field_value for screen_number=951 and field_number=1).

or ,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Science Test field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJSCIENCE. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

12/84

APA Math Test

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Math Test field (reg_user.field_value for screen_number=951 and field_number=2).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Math Test field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJMATH. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

13/85

APA Language Test

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: APA Language Test field (reg_user.field_value for screen_number=951 and field_number=3).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: APA Language Test field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJLANG. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

14/86

LEP Exempt From Taking LAL

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: LEP Exempt from Taking LAL field (reg_user.field_value for screen_number=951 and field_number=4).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: LEP Exempt from Taking LAL field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJLEPLAL. The submission file uses the corresponding reg_programs.value).

Required

Valid values are Y (for Yes) or N (for No)

15/87

Time In District Less Than One Year

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Time in District Less than 1 Year field (reg_user.field_value for screen_number=951 and field_number=6).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: Time in District Less than 1 Year field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJDISTRICT. The submission file uses the corresponding reg_programs.value).

Required

Y = Yes, student has been enrolled in the state assessment accountable (AYP) district for less than 1 year

N = No. Student has been enrolled in the state assessment accountable (AYP) district for more than 1 year

16/102

Time In School Less Than One Year

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Time in School Less than 1 Year field (reg_user.field_value for screen_number=951 and field_number=5).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: Time in School Less than 1 Year field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJSCHOOL. The submission file uses the corresponding reg_programs.value).

Required

Y = Yes, student has been enrolled in the state assessment accountable (AYP) school for less than 1 year

N = No. Student has been enrolled in the state assessment accountable (AYP) school for more than 1 year

17/91

State Assessment Testing Site County

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site County field (reg_user.field_value for screen_number=951 and field_number=7).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site County field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTCOUNTY. The submission file uses the corresponding reg_programs.value).

Required

For a listing of valid County Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls

18/91

State Assessment Testing Site District

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site District field (reg_user.field_value for screen_number=951 and field_number=8).

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site District field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTDIST. The submission file uses the corresponding reg_programs.value).

Required

For a listing of valid District Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls

19/104

State Assessment Testing Site School

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: State Testing Site School field (reg_user.field_value for screen_number=951 and field_number=9).

or

If a program override exists, the value comes from Registration > Entry & Reports > Student Demographic > Programs > PREID – NJ Pre-ID Programs: State Assessment Testing Site School field.

(The system looks in reg_program_column for the program_id and field_number associated with state_code_equiv=NJTSCHOOL. The submission file uses the corresponding reg_programs.value).

Required

For a listing of valid School Codes, refer to http://www.nj.gov/education/njsmart/download/school_codes.xls

20/105

State Assessment Accountable County

Registration > Entry & Reports > Student District Defined > NJ Smart Info: County – Attending field (reg_user.field_value for screen_number=990 and field_number=2).

Required

This code must match one of the CDS codes for Resident, Receiving, or Attending County from the student's SID submission record.

21/106

State Assessment Accountable District

Administration > General Setup > District > District: State Equivalency Code field (reg_district.state_code_equiv)

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student District Defined > NJ Smart Info: District – Resident (Override) field (reg_user.field_value for screen_number=990 and field_number=4).

Required

This code must match one of the CDS codes for Resident, Receiving, or Attending District from the student's SID submission record.

22/107

State Assessment Accountable School

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building field (Based on the reg_entry_with.building, the submission uses the corresponding reg_building.state_code_equiv)

or,

If a program override exists, the value comes from Registration > Entry & Reports > Student District Defined > NJ Smart Info: School - Attending (Override) field (reg_user.field_value for screen_number=990 and field_number=5).

Required

This code must match one of the CDS codes for Resident, Receiving, or Attending School from the student's SID submission record.

23/170

Examiner SMID Day 1

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=10).

Or ,

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 15)

Required

You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5.

24/171

Examiner SMID Day 2

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=11).

Or,

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 16)

Required

You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5.

25/172

Examiner SMID Day 3

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=12).

Or,

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 17)

Required

You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5.

26/173

Examiner SMID Day 4

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=13).

Or,

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 18)

Required

You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5.

27/174

Examiner SMID Day 5

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Examiner Staff ID Day 1 field (reg_user.field_value for screen_number=951 and field_number=14).

Or,

Registration > Entry & Reports > Student District Defined > NJ Pre-ID Programs: Out of Dist Exam SMID Day 1 field (reg_user.field_value for screen_number = 951 and field_number = 19)

Required

You either have to have a staff member selected for Examiner Staff ID Day 1 through Day 5, or enter the appropriate SMID for Out of Dist Exam SMID Day 1 through Day 5.