TSDL - Student Roster Data

Contents

Introduction

This report generates a fixed format text file for upload into the Louisiana Teacher Student Data Link (TSDL) system. The report consists of student course enrollment information, course teacher information and other miscellaneous student information.

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 students who are actively enrolled at report run time and who are not excluded from state reporting.

Class Record Selection Criteria:
The report selects records from the [CC] table that meet the following criteria:

The section of the class enrollment record is not checked to be excluded from state reporting ([Sections]Exclude_State_Rpt_YN not equal to 1)
The class enrollment record has not been excluded from state reporting ([CC]Period_Obsolete not equal to 1).
The class enrollment record has not been dropped ([CC]SectionID is not negative).
The class enrollment exit date is not before the Class entry date. ([CC]DateLeft is greater than [CC]DateEnrolled)

Report Input

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

Field	Description
Select Students	Choose to run the report for the Selected N Students Only or for All Students.
Schools to Include	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Start Date for the report	Enter the start date for the period you want the report to cover. Defaults to the first day of the school year.
End Date for the report	Enter the end date for the period you want the report to cover. Defaults to the last day of the school year.
EOC Courses Only	Select Yes to output only EOC courses. Select No to output all courses that meet the selection criteria. If set to "Yes" the report will only include courses where [S_LA_CRS_X]EOCTestFlag = 1 (This flag/indicator is in the Louisiana State Information section located on the District Setup > Courses > New Course or District Setup > Courses > Edit Course District Information pages)

Back to Top

Report Output

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

Item #	Data Element	Description	[Table]FieldName	Length
1	System Indicator	Always extracted as "TSD."	Always "TSD"	3
2	LEA Code	The LEA Code assigned by the LDOE.	First 3 characters of [S_LA_SCH_X]SiteCode	3
3	Record Type Code	Code indicating the record type. Must be "010".	Always "010"	3
4	School Site Code	The school's site code.	[S_LA_SEC_X]NonLEASiteCode or [S_LA_SCH_X]SiteCode	6
5	Teacher First Name	The Teacher's first name.	[Users]First_Name	30
6	Teacher MI	The Teacher's middle initial.	First character of [Users]Middle_Name	1
7	Teacher Last Name	The Teacher's last name	[Users]Last_Name	30
8	Teacher Suffix Name	The Teacher's name suffix. This field is optional	Blanks	5
9	Course Code	The course code assigned to the course.	[Courses]Alt_Course_Number or [CC]Course_Number	6
10	Period	The period the student takes this course.	[Section_Meeting]Period_Number	2
11	Class Code	The unique, district-assigned code identifying the section for this site.	[S_LA_SEC_X]NonLEAClassCode or [Courses]Course_Number + [Sections]Section_Number	20
12	Class Type	Indicates if this is a day or night class.	[S_LA_SEC_X]NightClassInd_TF	1
13	Partial Student First Name	The first character of the student's first name.	[Students]First_Name	1
14	Filler	Filler	Blank	30
15	Partial Student Last Name	The first 3 characters of the student's last name.	[Students]Last_Name	3
16	Filler	Filler	Blank	32
17	Student Unique State ID	The unique student ID assigned by the state.	[Students]State_StudentNumber	10
18	Filler	Filler	Blank	1
19	Student Day of Birth	The student's day of birth parsed from the student's full date of birth.	Day portion of [Students]DOB	2
20	Filler	Filler	Blank	4
21	Student Gender	The student's gender. Valid values: M – Male F – Female	[Students]Gender	1
22	Student Grade	The current grade level of the student.	[Students]Grade_Level. If [Students]Grade_Level = 9 and [S_LA_STU_TransNinthGrade_X] TransNinthYearID = the current school year ID then T9	2
23	Student Education Classification	Indicates if the student is a regular education, special education or talented/gifted student. Valid values: 00 – Regular Education 01 – Special Education 02 – Talented/Gifted	[S_LA_STU_504SPED_X]SPEDIndicator or 00 if null	2
24	Student LEP	Indicates the level of the student's English proficiency. Valid values: 01 – Fully English Proficient 02 – Limited English Proficient	[S_LA_STU_Language_X]EnglishProficiency	2
25	Student Free/Reduced Lunch	Indicates the student's eligibility for free or reduced price lunches. Valid values: 00 – Paid 01 – Free 02 - Reduced	If [Students]lunchstatus = F or FDC set to 01. If [Students]lunchstatus = R set to 02. Otherwise set to 00.	2
26	Student Migrant Status	Y/N flag indicating if this student is a migrant.	Currently always "N"	1
27	Student Section 504 Status	Y/N flag indicating if this student qualifies under section 504.	[S_LA_STU_504SPED_X]SPEDIndicator must not be 1 and [S_LA_STU_504SPED_X]Is504_TF = Y or [S_LA_STU_504SPED_X]ExitDate > run date of the report.	1
28	Student Primary Exceptionality	Indicates the primary exceptionality of the student if the student is special education or section 504.	[S_LA_STU_504SPED_X] SER_StuRosterExcptnlty	2
29	Student Ethnicity (Hispanic/Latino)	Indicates if the student is Hispanic or Latino.	Set to Y if [Students]FedEthnicity = 1	1
30	Student Race: American Indian or Alaska Native	Y/N flag indicating the student's racial background.	Set to Y if [StudentRace]RaceCD = AA otherwise set to N	1
31	Student Race: Asian	Y/N flag indicating the student's racial background.	Set to Y if [StudentRace]RaceCD = AS otherwise set to N	1
32	Student Race: Black or African American	Y/N flag indicating the student's racial background.	Set to Y if [StudentRace]RaceCD = BA otherwise set to N	1
33	Student Race: Native Hawaiian or Other Pacific Islander	Y/N flag indicating the student's racial background.	Set to Y if [StudentRace]RaceCD = NO otherwise set to N	1
34	Student Race: White	Y/N flag indicating the student's racial background.	Set to Y if [StudentRace]RaceCD = WH otherwise set to N	1
35	Student Homeless (McKinney-Vento Act)	Y/N flag indicating of this student is classified as homeless.	Set to Y if [S_LA_STU_X]HomelessCode is not null otherwise set to N	1
36	Student Career Diploma	Y/N flag indicating if this student is attempting to obtain a career diploma.	Set to Y if [S_LA_STU_X]OptionCode = 4 otherwise set to N	1
37	Teacher Social Security Number	The social security number of the teacher teaching this class.	[Teachers]SSN or [Users]SSN	9
38	Class Begin Date	The day this class section begins.	[CC]DateEnrolled	8
39	Class End Date	The day this class section ends.	[CC]DateLeft	8

Back to Top