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]	294	294	1
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
Y	LIP - Language Instruction Program	Indicates a Language instruction program for the student. Required if Language Proficiency = 1, 2, 6, 7, 8, or 9.	[S_CO_STU_X]LIP	145	156	2
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
AB	Military Connected	This value indicates whether or not a student is a dependent of a Military Service member.	[S_CO_STU_X]Military Connected	151	151	1

Back to Top