Student Lite File Layout

1

*DISTRICT CODE

(DISTRICT OF RESPONSIBILITY CODE)

1-8

NYS Reporting

reg_district.state_code_equiv

If length is Not 8 or first character is Not "8", then "NY" + first 6 characters

Administration > General Setup > District > District: State Equivalency Code

2

*LOCATION CODE

(BUILDING OF ENROLLMENT CODE)

9-14

NYSSIS and NYS Reporting

reg_building.building

Check value for program with state_code_equiv 'NYALTACC'. If set then report reg_programs.program_value

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building

or,

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "NYALTACC"

3

*SCHOOL YEAR DATE

(SCHOOL YEAR)

15-24

NYSSIS and NYS Reporting

School Year Prompt-06-30

N/A

4

*STUDENT ID

(SCHOOL DISTRICT STUDENT ID)

25-36

NYSSIS and NYS Reporting

reg_entry_with.student_id

Use 9 numeric characters, left padded with zeros

Ex. 51972 = 000051972

5

*LAST NAME SHORT

(STUDENT'S LAST NAME)

37-61

NYSSIS and NYS Reporting

reg.last_name

Registration > Entry & Reports > Student Demographic > Registration: Last Name

6

*FIRST NAME SHORT

(STUDENT'S FIRST NAME)

62-76

NYSSIS and NYS Reporting

reg.first_name

Registration > Entry & Reports > Student Demographic > Registration: First Name

7

MIDDLE INITIAL

(STUDENT'S MIDDLE INITIAL)

77

NYSSIS and NYS Reporting

reg.middle_name

Registration > Entry & Reports > Student Demographic > Registration: Middle Name (first character)

8

*CURRENT GRADE LEVEL

(GRADE LEVEL)

78-79

NYSSIS

reg_entry_with.grade

See Grade Level Table. If 13 or 14 then reg_programs.program_value

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade

9

HOME ROOM

80-85

Local use only

reg.homeroom_primary

Registration > Entry & Reports > Student Demographic > Registration: Primary Homeroom

10

*BIRTH DATE

(DATE OF BIRTH)

86-95

Local use only

reg.birthdate

Registration > Entry & Reports > Student Demographic > Registration: Birth Date

11

*GENDER CODE

(GENDER DESCRIPTION)

96-101

NYSSIS and NYS Reporting

reg.gender

Registration > Entry & Reports > Student Demographic > Registration: Gender

12

*ETHNIC CODE SHORT

(RACE 1 CODE)

102-103

NYSSIS and NYS Reporting

reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 1

or,

reg_personal.Ethnic_Code

Validate against regtb_ethnicity.state_code_equiv

Registration > Entry & Reports > Student Demographic > Personal: Race (if more than one, where Order = 1)

13

HOME LANGUAGE CODE

(HOME LANGUAGE DESCRIPTION)

104-119

NYSSIS and NYS Reporting

reg.language

Registration > Entry & Reports > Student Demographic > Registration: Home Language

14

CHALLENGE TYPE

120-149

Leave blank

N/A

15

LEVEL OF INTEGRATION

150-164

Leave blank

N/A

16

LEP PARTICIPATION

165-167

Leave blank

N/A

17

+DURATION OF LEP

(YEARS ENROLLED IN A BILINGUAL OR ESL PROGRAM)

168-169

reg_personal.ell_years

If "Use LEP Program for LEP Duration" prompt is checked then it will be calculated value from LEP Eligibility (difference between Start date and End date, if End date is NULL then today's date). Else reg_personal.ell_years

Registration > Entry & Reports > Student Demographic > Personal: ELL Years

Or,

If Use LEP Program for LEP Duration checked on prompt screen then calculated from Start and End Dates from Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "0231"

18

+POST GRADUATE ACTIVITY

(POSTGRADUATE PLAN DESCRIPTION)

170-199

NYS Reporting for P-Tech Students (4026) & Smart Scholars-ECHS (4037)

reg_academic.exp_grad_plan

Registration > Entry & Reports > Student Demographic > Academic: Expected Graduation Plans

19

STUDENT STATUS

200

Local use only

reg.current_status

Registration > Entry & Reports > Student Demographic > Registration: Current Year Status

20

+LAST STATUS DATE

201-210

Local use only

reg_entry_with.withdrawal_date

If NULL or > Run Date, then Run Date

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Date

21

POVERTY CODE

211

Leave blank

N/A

22

POPULATION CODE

212

Leave blank

N/A

23

MOBILITY CODE

213

Leave blank

N/A

24

+DIPLOMA TYPE CODE

(CREDENTIAL TYPE DESCRIPTION)

214-216

NYS Reporting

reg_academic.code using regtb_diplomas.state_code_equiv

Registration > Entry & Reports > Student Demographic > Academic: Diploma Type

25

PROGRAM SERVICES CODE

217

Leave blank

N/A

26

+GRADE 09 ENTRY DATE

(FIRST DATE OF ENTRY INTO GRADE 9)

218-227

NYSSIS and NYS Reporting

reg.grade_9_date

BLANK if "12/31/1899" Or "01/01/1900"

Registration > Entry & Reports > Student Demographic > Registration: Date Entered Grade 9

27

+SERVICE PROVIDER

(BACKMAPPING BEDS CODE)

228-247

If Back Map BEDS Screen and Back Map BEDS Field are selected, the value fetched from the User Defined Screen or the Program based on the selection made for Back Map BEDS Screen and Back Map BEDS Field.

Registration > Entry & Reports > Student Demographic > Programs: Program and field selected on Prompt screen

28

INOCULATION DATE

(IMMUNIZATION DATE FOR FIRST POLIO VACCINATION)

248-257

Leave blank

N/A

29

ADDRESS 1

(STUDENT'S ADDRESS LINE 1)

258-287

NYSSIS and NYS Reporting

reg_contact.street_number + reg_contact.street_prefix + reg_contact.street_name + reg_contact.street_suffix

where reg_stu_contact.contact_type = 'P' and reg_stu_contact.contact_priority = '0'

Registration > Entry & Reports > Student Demographic > Addresses panel: House Number + Street Prefix + Street Name + Street Suffix

30

ADDRESS 2

(STUDENT'S ADDRESS LINE 2)

288-317

NYSSIS and NYS Reporting

reg_contact.complex + reg_contact.apartment

Registration > Entry & Reports > Student Demographic > Addresses panel: Complex + Apartment

31

CITY

(STUDENT'S ADDRESS CITY)

318-342

NYSSIS and NYS Reporting

reg_contact.city

Registration > Entry & Reports > Student Demographic > Addresses panel: City

32

STATE

(STUDENT'S ADDRESS STATE CODE)

343-344

NYSSIS and NYS Reporting

reg_contact.state

Registration > Entry & Reports > Student Demographic > Addresses panel: State

33

ZIP CODE

(STUDENT'S ADDRESS ZIP CODE)

345-354

NYSSIS and NYS Reporting

reg_contact.zip

Registration > Entry & Reports > Student Demographic > Addresses panel: Zip Code

34

HOME PHONE

(PHONE AT PRIMARY RESIDENCE)

355-368

NYSSIS

reg_stu_contact.phone

Registration > Entry & Reports > Student Demographic > Phone panel: Phone Number

35

PRIMARY GUARDIAN NAME

(STUDENT'S GUARDIAN ONE NAME)

369-408

NYSSIS

reg_contact.first_name + reg_contact.last_name

where reg_stu_contact.contact_type = 'G' and reg_stu_contact.contact_priority = '1'

Registration > Entry & Reports > Student Demographic > Contacts: First Name + Last Name for Contact with Priority of 1

36

ALTERNATE GUARDIAN NAME

(STUDENT'S GUARDIAN TWO NAME)

409-448

NYSSIS

reg_contact.first_name + reg_contact.last_name

where reg_stu_contact.contact_type = 'G' and reg_stu_contact.contact_priority = '2'

Registration > Entry & Reports > Student Demographic > Contacts: First Name + Last Name for Contact with Priority of 2

37

PLACE OF BIRTH

(STUDENT'S PLACE OF BIRTH)

449-498

Local use only

reg_personal.birth_city + reg_personal.birth_state + reg_personal.birth_country

Registration > Entry & Reports > Student Demographic > Personal: City of Birth + State of Birth + Country of Birth

38

+INITIAL US ENTRY DATE

(DATE OF ENTRY INTO UNITED STATES)

499-508

If Entry Into US Screen and Entry Into US Field are selected, the value fetched from the User Defined Screen or the Program based on the selection made for Entry Into US Screen and Entry Into US Field.
BLANK if "12/31/1899" Or "01/01/1900"

Registration > Entry & Reports > Student Demographic > Programs: Program and field selected on Prompt screen

39

+YEARS IN US SCHOOLS

(YEARS IN UNITED STATES SCHOOLS)

509-512

Local use only

{School Year (Prompt)} - Year(reg.us_enroll_date)

if Month(reg.us_enroll_date) < 7, then + 1

Calculated from Registration > Entry & Reports > Student Demographic > Registration: US Enrollment Date

40

+COUNTRY OF ORIGIN CODE

(COUNTRY OF ORIGIN)

513-516

reg_personal.origin_country

Registration > Entry & Reports > Student Demographic > Personal: Country of Origin

41

*DISTRICT CODE OF RESIDENCE

517-524

NYS Reporting

42

*HISPANIC ETHNICITY INDICATOR

(HISPANIC/LATINO ETHNICITY INDICATOR)

525-527

NYSSIS and NYS Reporting

reg_personal.Hispanic

Registration > Entry & Reports > Student Demographic > Personal: Hispanic/Latino Ethnicity

43

+RACE 2 CODE

528-531

NYSSIS and NYS Reporting

reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 2

Validated against regtb_ethnicity.state_code_equiv

Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 2

44

+RACE 3 CODE

532-535

NYSSIS and NYS Reporting

reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 3

Validated against regtb_ethnicity.state_code_equiv

Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 3

45

+RACE 4 CODE

536-539

NYSSIS and NYS Reporting

reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 4

Validated against regtb_ethnicity.state_code_equiv

Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 4

46

+RACE 5 CODE

540-543

NYSSIS and NYS Reporting

reg_ethnicity.Ethnic_Code Where reg_ethnicity.Ethnicity_Order = 5

Validated against regtb_ethnicity.state_code_equiv

Registration > Entry & Reports > Student Demographic > Personal: Race where Order = 5

47

*HOMELESS

(HOMELESS INDICATOR)

544-546

Local use only

reg_programs.program_value where state_code_equiv = 'HOMELESS'
("Y" if program_value is Not NULL and Not N, otherwise "N")

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "HOMELESS"

48

*MIGRANT STATUS

(MIGRANT INDICATOR)

547-554

NYS Reporting

reg_programs.program_value where state_code_equiv = 'MIGRANT'
("Y" if program_value is Not NULL and Not N, otherwise "N")

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "MIGRANT"

49

IMMIGRANT INDICATOR

555-557

Local use only

reg_programs.program_value where state_code_equiv = 'IMMIGRANT'
("Y" if program_value is Not NULL and Not N, otherwise "N")

Or,

reg_personal.immigrant

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "IMMIGRANT"

Or,

Registration > Entry & Reports > Student Demographic > Personal: Immigrant

50

*NEGLECTED OR DELINQUENT

(NEGLECTED OR DELINQUENT INDICATOR)

558-560

NYS Reporting

reg_programs.program_value where state_code_equiv = 'ATRISK'
("Y" if program_value is Not NULL and Not N, otherwise "N")

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "ATRISK"

51

+HOMELESS PRIMARY NIGHTTIME RESIDENCE

561-568

Leave blank

N/A

52

NATIVE LANGUAGE

569-584

Leave blank

N/A

53

+CAREER PATH CODE

585-604

NYS Reporting

reg_user.field_value where screen_number = 10900 and field_number = 2

Registration > Entry & Reports > Student District Defined > NY Graduation Information: Career Path Code

54

+GUIDANCE COUNSELOR DISTRICT CODE

605-624

NYS Reporting

reg_district.state_code_equiv

If length is Not 8 or first character is Not "8", then "NY" + first 6 characters

Administration > General Setup > District > District: State Equivalency Code

Leave blank if you selected Exclude Guidance Counselor Information when you ran the download for Student Lite.

55

GUIDANCE COUNSELOR

625-636

NYS Reporting

reg_staff.staff_state_id converted from reg.counselor

Registration > Entry & Reports > Student Demographic > Registration: Counselor

Administration > Registration Setup > Building > Staff > Staff Information panel: Staff State ID

Leave blank if you selected Exclude Guidance Counselor Information when you ran the download for Student Lite.