Skip to main content
Skip table of contents

Student - Demographic Data

Introduction

This export provides the required records for the Student Profile Interchange Requirements – Student. The report will output all students who are enrolled for current year only from the July 1 through the date the report is run. Students will only appear once per extract at the school of the last enrollment

Note: This report should only be run for Individual Schools for auditing purposes. The report should be run for all School or for the District for submission.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

  • The student is not flagged as Exclude from State Reporting.
  • The school is not flagged as Exclude from State Reporting.
  • The student’s Entry Date is on or after July 1 of school year selected.
  • The student’s Entry Date is on or before the date the report is run (system date).
    Note for CSI Schools Only: Student records that have the same entry and exit date, and that are designated with exit code 11 (Transfer to a public school in the same school district) are excluded.
  • If a date is specified at runtime in the optional “Point in Time Date” parameter, only students enrolled on that date will be reported.
  • If there is no lunch status for the selected date, the current status is extracted.
  • If Point In Time and Lunch Status Date are provided, then the students with the respective statuses for the selected dates display.
  • If either Point In Time or Lunch Status Date is provided, then the status for the provided date displays for both parameters.
  • If neither Point In Time nor Lunch Status Date is provided, then the students are extracted regardless of their enrollment status, except pre-registered students, and the lunch status as of the current date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools*

Select one, all or a selection of Schools. A school selection will only be offered at District Office. When running at a school, only that school will be available.

Select Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected x Students Only – Run the report for students in the current selection.
  • All Students – Run the report for all students in the current school or district that meet the selection criteria.

If running the report for a single student, or group of students, select the students prior to running the report.

Point in Time

OPTIONAL – Enter a date to report information from a specific point in time. The date entered must be within the year selected. Only active students on that date will be reported.

Lunch Status Date

OPTIONAL - Select the date to display the student's lunch status.

  • The lunch status date selection does not affect the report's selection criteria, when Point in Time is entered or blank.
  • If a student has a lunch status history record with a status that is applicable as of the lunch status date, that value should pull.
  • If a student does not have a lunch status history record that is "active" as of the lunch status date, the current status should pull.
    • Students that enroll in school up to 5 days after the count date can be reported (claimed). In this case, if the lunch status date is 10/1/2020, a student that enrolls on 10/3/2020 will not have a lunch status history record that is active on 10/1/2020. In this case, the student's current status should be reported.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Excel Col

Data Element

Description

[Table]FieldName

Start

End

Field Length

A

School District/BOCES Code

A unique code assigned to a district by CDE.

[Prefs]value

[Prefs]name=districtnumber

1

4

4

B

Student's State ID (SASID)

A unique ten-digit number must be assigned to each student by CDE.

[Students]State_StudentNumber

5

14

10

C

Local ID (LASID)

The student's Locally Assigned Student ID (LASID). Districts/BOCES may zero fill if they choose not to use a LASID.

[Students]Student_Number

15

24

10

D

Student's First Name

A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.

Note: This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

25

54

30

E

Student's Middle Name

The secondary name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. Blanks are NOT allowed. Use NMN (no middle name) where appropriate.

Note: This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

55

84

30

F

Student's Last Name

The name borne in common by members of a family.

Note: This is the student's legal name. If the legal name field is not populated, the student's preferred name is reported.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

85

114

30

G

Student's Gender

An individual's sex.

Valid values:

  • 01 - Female
  • 02 - Male
  • 03 - Non-Binary

Note: This is the student's legal gender. If the legal gender field is not populated, the student's preferred gender is reported..

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

115

116

2

H

Student’s Date of Birth

The month, day, and year on which an individual was born (i.e. 09151989).

[Students]DOB

117

124

8

I

Student’s Ethnicity: Hispanic or Latino

A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. The term “Spanish origin” can be used in addition to “Hispanic/Latino or Latino.”

[Students]FedEthnicity

286

286

1

J

Student’s Race: American Indian or Alaska Native

A person having origins in any of the original peoples of North or South America (including Central America), and who maintains a tribal affiliation or community recognition.

[StudentRace]RaceCd = I

287

287

1

K

Student’s Race: Asian

A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.

[StudentRace]RaceCd =A

288

288

1

L

Student’s Race: Black or African American

A person having origins in any of the Black racial groups of Africa.

[StudentRace]RaceCd = B

289

289

1

M

Student’s Race: White

A person having origins in any of the original peoples of Europe, the Middle East, or North Africa.

[StudentRace]RaceCd = W

290

290

1

N

Student’s Race: Native Hawaiian or Other Pacific Islander

A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

[StudentRace]RaceCd = P

291

291

1

O

Free/Reduced Lunch Eligible (FREE_LUNCH)

Student meets the eligibility criteria for free or reduced lunch pursuant to the provisions of the "Federal National School Lunch Act".

[S_CO_STU_X]StateLunchStatus

292

293

2

P

Free Lunch Eligibility Identification (FREE_LUNCH_IDENTIFICATION)


Pulls value from the Free Lunch Eligibility Identification field on the Lunch page.[S_CO_STU_X]2942941

Q

Section 504 Having a Disability (SECTION_504_DISABILITY)

The student is identified as handicapped under regulations implementing Section 504 of the Rehabilitation Act of 1973, but may or may not be eligible for special education placement under the Individuals with Disabilities Education Act.

[S_CO_STU_X]Handicapped_504

[S_CO_REN_X]Handicapped_504

295

295

1

R

Immigrant

A child is an immigrant if he/she is age 3 through 21 and was not born in any state and has not been attending one or more schools in any one or more States for more than 3 full academic years.

[S_CO_STU_X]Immigrant

[S_CO_REN_X]Immigrant

296

296

1

S

Language Background

Any student, who has a language proficiency code of Non English Proficient (NEP), Limited English Proficient (LEP), Fluent English Proficient (FEP), Primary or Home Language Other Than English (PHLOTE), or Former ELL (FELL), must have a language background other than English (ENG).

[S_CO_STU_X]English_Learner

[S_CO_REN_X]English_Learner

297

299

3

T

Primary Disability

A 2-digit code representing the student’s Primary Disability. If the student has more than one disability, the code number reported must be that of his or her major disability, as reflected on the student’s Individualized Education Program (IEP).

Note: This value is conditional on the Special Education Exit Date entered on the Special Ed student tab. if the Special Education Exit Date is blank or a future date, the report returns the Disability value.

Derived from:

[S_CO_STU_X]Primary_Disability

[S_CO_REN_X]Primary_Disability

[S_CO_STU_X]IEP_EntryDate

[S_CO_REN_X]IEP_EntryDate

[S_CO_STU_X]IEP_ExitDate

[S_CO_REN_X]IEP_ExitDate

300

301

2

U

Attends District Funded HSED Program

HSED funded using state funds either in the form of a district run HSED program or tuition paid, by the district, to an external HSED program.

[S_CO_STU_X]GED_Program

302

302

1

V

Homeless

Flag if the student meets the criteria of a homeless individual according to the 2001 McKinney-Vento reauthorization Act. A homeless individual is one who lacks a “fixed, regular, and adequate primary nighttime residence.”

[S_CO_STU_X]Homeless

[S_CO_REN_X]Homeless

303

303

1

W

Primary Nighttime Residence

The temporary residence that is being used by the student as a result of economic displacement. The residence may be either public or private.

[S_CO_STU_X]Primary_Night_Residence

[S_CO_REN_X]Primary_Night_Residence

304

305

2

X

Language Proficiency

A student's English language proficiency is described by his or her ability to speak, listen, read, and write in English. English Language Learners (ELL) must have an English Proficiency rating entered (1, 2, or 3) and non-ELL students must be coded as 0 or 4. Former English Language Learners are coded as 5.

[S_CO_STU_X]LanguageProficiency

[S_CO_REN_X]LanguageProficiency

306

306

1

YLIP - Language Instruction ProgramIndicates a Language instruction program for the student. Required if Language Proficiency = 1, 2, 6, 7, 8, or 9.[S_CO_STU_X]LIP1451562

Z

Special Education Transition

Specifically designed for 12th grade Special Education students aged 18 to 21 to move students from educational environments to life skills and/or vocation.

[S_CO_STU_X]Transition

[S_CO_REN_X]Transition

307

307

1

AA

Alternate Assessment Participant

Student will be taking the Alternate Assessment rather than the TCAP Assessment, ACT Assessment or ACCESS Assessment. Eligibility for the alternate assessment must be determined by the student's IEP team. There must be a value for all students in Grades K-12.

[S_CO_STU_X]CSAP_Alternate_Assessment

[S_CO_REN_X]CSAP_Alternate_Assessment

308

308

1

ABMilitary ConnectedThis value indicates whether or not a student is a dependent of a Military Service member.[S_CO_STU_X]Military Connected1511511

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.