Record Integration Tracking System (RITS)

Introduction

The Record Integration Tracking System (RITS) is designed to be used with the Data Pipeline Project. This file will provide all the required fields for the RITS. The report will include all currently active students.

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 is active.
The student’s Entry Date is on or after July 1 of the selected school year.
The student’s Entry Date is on or before the date the report is run (system date).

Report Input

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

Field	Description
Select Schools*	Select Multiple Schools using Ctrl+Click to select multiple schools or Shift+Click to select a range of schools or All Schools
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. Note: If running the report for a single student, or group of students, select the students prior to running report.
Include Pre-registered students	If Yes is selected, both active and pre-registered students will be reported.
Include Only Students Without a SASID	If Yes is selected, only students without a SASID will 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	Student’s State ID (SASID)*	A unique ten-digit numeric field containing the ten-digit value assigned by CDE to the student whose record is being submitted for processing.	[Students]State_StudentNumber	1	10	10
B	School District/BOCES Code*	A unique four-digit number assigned by CDE to each school district or BOCES.	[Prefs]value [Prefs]name=districtnumber	11	14	4
C	School Code	The four-digit numeric value CDE has assigned to your district/BOCES.	[Schools]Alternate_School_Number [Schools]School_Number	15	18	4
D	Local ID (LASID)*	A ten-digit number assigned to each student by the reporting district/BOCES.	[Students]Student_Number	19	28	10
E	Student’s Last Name*	The thirty-character field contains the student’s last name. 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	29	58	30
F	Student's Suffix	The student's suffix. Examples: Sr - Senior Jr - Junior I - First II - Second III - Third IV - Fourth V - Firth VI - Sixth Note: This can be blank.	[StudentCoreFields]PSCore_Legal_Suffix [Students]Suffix	59	61	3
G	Student’s First Name*	The thirty-character field contains the student’s first name. 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	59	88	30
H	Student’s Middle Name*	The thirty-character field contains the student’s middle name. Blanks are NOT allowed. Use NMN (no middle name) where appropriate. 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_Middle_Name [Students]Middle_Name	89	118	30
I	Student’s Date of Birth (DOB)*	An eight-digit numeric field contain the month, day, and year on which an individual was born (i.e. 09151989) The date must be a valid date in the form of MMDDYYYY.	[Students]DOB	119	126	38
J	Grade Level*	A three-digit numeric field containing the value of the grade the student is enrolled in for the school and district/BOCES. The grade value must be valid for the school code and district/BOCES being submitted.	[Students]Grade_Level [S_CO_STU_X]Kindergarten	127	129	23
K	Student’s Gender*	A two-digit numeric field containing the value of the student’s gender. 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	130	131	2
L	Active/Inactive Indicator	A one-digit numeric field containing the value representing that the SASID of the student is active or inactive.	Derived from: [Students]Enroll_Status If Enroll_Status <= 0, 0 is reported; else, 1 is reported.	132	132	1

Back to Top