Student - School Association Data 20-21
Introduction
The purpose of the Student School Association (SSA) file is to capture the school(s) in which a student attends in your district throughout the currently selected school year for funding and accountability purposes.
This report is intended to be used when the current version of the report has a different specification or file layout than what is needed.
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] or [ReEnrollments] 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 school enrollment falls within the Report Start and End Dates.
- The student is not pre-registered.
Note: Student records that have the same entry and exit dates, and that are designated with exit code 11 (Transfer to a public school in the same school district) are excluded.
Graduates: Students that are graduating MUST have the Senior Exit Code field ([S_CO_STU_X]SeniorExitCode) on the Grad info tab populated with the appropriate graduate exit code for them to be correctly reported as a graduate.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Schools to Include | 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 reported. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Fall or Spring | Select Fall or Spring. The selection will be returned as part of the file output name. |
| Report Start Date | Enter the starting date of the date range for the report. This value defaults to the first day of the selected term. |
| Report End Date | Enter the ending date of the date range for the report. This value defaults to the current date when left blank. |
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.
Data Element | Description | [Table]FieldName | Field Length |
School District/BOCES Code | A unique code assigned to a district by CDE. | [Prefs]value [Prefs]name=districtnumber | 4 |
State ID (SASID) | A unique ten-digit number must be assigned to each student by CDE. | [Students]State_StudentNumber | 10 |
School Code | A unique code assigned by CDE to a school building. | [Schools]School_Number [Schools]Alternate_School_Number | 4 |
First Name | The 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 was not populated, the student's preferred name is reported. | [StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name | 30 |
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 was not populated, the student's preferred name is reported. | [StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name | 30 |
Gender | The student's gender. Note: This is the student's legal gender. If the legal gender field was not populated, student's preferred gender is reported. | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender | 2 |
Date of Birth | The month, day, and year on which an individual was born (i.e. 09151989). | [Students]DOB | 8 |
Entry Date | The month, day, and year on which a student enters and begins to receive an education program in a school. If the student was included in the end of year membership count during the previous school year, the student must have an entry date at least one day prior to the end of the currently reported school year. | [Students]EntryDate [ReEnrollments]EntryDate | 8 |
Grade Level | The grade level or primary instructional level at which a student enters a school or an educational institution during a given school year. | [Students]Grade_Level [S_CO_STU_X]Kindergarten [ReEnrollments]Grade_Level [S_CO_REN_X] Kindergarten | 3 |
Entry Type | The process by which a student enters a school during a given school year. | [Students]EntryCode [ReEnrollments]EntryCode | 2 |
Exit Withdraw Date | The month, day, and year the student exited a school or grade in your district (i.e. 11052009). If the student completed the school year in your district and did not exit before the end of the school year, this field will be defaulted to “00000000”. Notes:
| [S_CO_STU_X]Grad_Date [Students]ExitDate [ReEnrollments]ExitDate | 8 |
Exit Withdraw Type | The circumstances under which the student exited from membership. Note: For grade levels 9-12. Values entered in to the Graduate Exit Code field will be evaluated BEFORE the exit code in the student’s current enrollment. Graduates: Students that are graduating MUST have the Senior Exit Code field ([S_CO_STU_X]SeniorExitCode) on the Grad info tab populated with the appropriate graduate exit code for them to be correctly reported as a graduate. | [S_CO_STU_X]SeniorExitCode [Students]ExitCode [ReEnrollments]ExitCode | 2 |
Retention Code | Indicates if a student is being retained at the current grade level for the next school year. | [S_CO_STU_X]Retention_Code [S_CO_REN_X]Retention_Code | 1 |
Pupil’s Attendance Information | For each record submitted provide a code from either the "A" or "B" grouping depending on whether the student is currently attending a district program (A) or is a resident student attending an educational program not operated by the reporting district (B). | [S_CO_STU_X]Attend_Info [S_CO_REN_X]Attend_Info | 2 |
County Code of Residence for Joint School Districts | The County of residence for students who live in a district with boundaries that cross more than one county. | [S_CO_STU_X]County_Joint_District [S_CO_REN_X]County_Joint_District | 2 |
District of Parent’s Residence | School district where the parent/guardian resides, if the student attends a district other than the school district of residence and resides in CO. This will default to your District Number if the Attendance code is not 04 or 05. | [S_CO_STU_X]Parent_Res_District [S_CO_REN_X]Parent_Res_District | 4 |
Country of Parent’s Residence for Non-Residence Students | Country code where the parent/guardian resides, for foreign exchange students. This will default to zero-filled if the Attendance code is not 04 or 05. | [S_CO_STU_X]Parent_Res_Country [S_CO_REN_X]Parent_Res_Country | 3 |
State of Parent’s Residence for Non-Residence Students | State code where the parent/guardian resides, if the student attends a district other than the school district of residence. This will default to zero-filled if the Attendance code is not 04 or 05. | [S_CO_STU_X]Parent_Res_State [S_CO_REN_X]Parent_Res_State | 2 |
Public School Finance Funding Status | The student’s public school finance funding status. Note: When a student’s exit date is October 1, the Student School Association extract will report Funding Code 86, regardless of the value stored. | [S_CO_STU_X]Status_For_Funding [S_CO_REN_X]Status_For_Funding | 2 |
Date First Enrolled in the U.S. | The date a student first enrolled in any public or non-public US school (not including Puerto Rico). MMDDYYYY format or zero. | [S_CO_STU_X]Date_First_Enrolled_US [S_CO_REN_X]Date_First_Enrolled_US | 8 |
Primary School | Indicate if this school is the primary school for funding for this student in your district. | Always 1 | 1 |
Independent Student | A program established by the school district under the supervision of a certificated or licensed teacher and included in the student's academic schedule. | [S_CO_REN_X]IndependentStudy [S_CO_STU_X]IndependentStudy | 1 |
Expelled Education | A program established to provide educational services pursuant to section 22-33-203 to expelled pupils. | [S_CO_STU_X]Expelled [S_CO_REN_X]Expelled | 1 |
Home Based Education | The student is a home school student and receiving some services from the district. | [S_CO_STU_X]HomeBasedEd [S_CO_REN_X]HomeBasedEd | 1 |
Gifted General Intellect | Student is identified as gifted in general or specific intellectual ability. | [S_CO_STU_X]Gifted_General_Intellect [S_CO_REN_X]Gifted_General_Intellect | 1 |
Gifted Creativity | Student is identified as gifted in creativity. | [S_CO_STU_X]Gifted_Creativity [S_CO_REN_X]Gifted_Creativity | 1 |
Gifted Leadership | Student is identified as gifted in leadership ability. | [S_CO_STU_X]Gifted_Leadership [S_CO_REN_X]Gifted_Leadership | 1 |
Gifted Reading | Student is identified as gifted in reading. | [S_CO_STU_X]Gifted_Reading [S_CO_REN_X]Gifted_Reading | 1 |
Gifted Writing | Student is identified as gifted in writing. | [S_CO_STU_X]Gifted_Writing [S_CO_REN_X]Gifted_Writing | 1 |
Gifted Math | Student is identified as gifted in mathematics. | [S_CO_STU_X]Gifted_Math [S_CO_REN_X]Gifted_Math | 1 |
Gifted Science | Student is identified as gifted in science. | [S_CO_STU_X]Gifted_Science [S_CO_REN_X]Gifted_Science | 1 |
Gifted Social Studies | Student is identified as gifted in social studies. | [S_CO_STU_X]Gifted_Social_Studies [S_CO_REN_X]Gifted_Social_Studies | 1 |
Gifted World Language | Student is identified as gifted in world language. | [S_CO_STU_X]Gifted_World_Language [S_CO_REN_X]Gifted_World_Language | 1 |
Gifted Visual Arts | Student is identified as gifted in visual arts. | [S_CO_STU_X]Gifted_Visual_Arts [S_CO_REN_X]Gifted_Visual_Arts | 1 |
| Non-School Program | Indicates a program not run by the student's school. | [S_CO_STU_X]NonSchoolPrgm [S_CO_REN_X]NonSchoolPrgm | 2 |
Gifted Drama and Theater | Student is identified as gifted in drama and theater. | [S_CO_STU_X]Gifted_Drama_Theater [S_CO_REN_X]Gifted_Drama_Theater | 1 |
Gifted Musical | Student is identified as gifted in music. | [S_CO_STU_X]Gifted_Music [S_CO_REN_X]Gifted_Music | 1 |
Gifted Dance | Student is identified as gifted in dance. | [S_CO_STU_X]Gifted_Dance [S_CO_REN_X]Gifted_Dance | 1 |
Gifted Psychomotor | Student is identified as gifted in psychomotor ability. | [S_CO_STU_X]Gifted_Psychomotor [S_CO_REN_X]Gifted_Psychomotor | 1 |
| Total Days Attended by Students | The aggregate number of whole and partial days the students have attended school for the current school year. It is calculated by adding the number of days each student attended (full and partial days) in the current school year. A decimal is added to the tenths place. | Calculated. | 5 |
| Total Days Excused by Students | The aggregate number of whole and partial days that students had excused absences (out of school), for the current school year. Absence due to a suspension is excused. (A student who is tardy is not considered to be absent). A decimal is added to the tenths place. | Calculated. | 5 |
| Total Days Unexcused by Students | The aggregate number of whole and partial days students were absent (out of school), without being excused from a parent/guardian for the current school year. (A student who is tardy is not considered to be absent). A decimal is added to the tenths place. | Calculated. | 5 |
| Total Possible Attendance Days | The aggregate number of whole and partial days students would have attended school if there had been no absences for the current school year. A decimal is added to the tenths place. It is calculated by adding the number of days that each student was enrolled in the current school year. Expelled students are included until date of expulsion. | Calculated. | 5 |
| Truant Status | Indicates habitually truant students who are at least the age of six and under the age of seventeen years on or before August 1 of the year in question, who have four total days of Unexcused Absences from a public school in any one calendar month: calculated by the sum of unexcused absences converted to days and fractions of days.
| Calculated. | 1 |
| Total Days Missed Due to Out-of School Suspensions | The aggregate number of whole and partial days the student was absent due to out-of-school suspensions. A decimal is added to the tenths place. | Calculated. | 5 |