Documentation for Administrators

Student Enrollment Extension

Updated on

Expand or collapse content Student School Association
Element Name
 Alias Name
 Table Field/Logic
 End User Logic Field ID Sub
StudentUniqueStateId
 Texas Unique Student ID
 STUDENTS
 CUSTOM_400009369
 Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information
1,3,4,5,6
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_100000001 + CUSTOM_327
 Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information
1,3,4,5,6
TX-GradeLevel
 Grade Level
 SCHOOL_GRADELEVELS
 SHORT_NAME
 School_Gradelevels.short_name where short_name is used in School Setup > Grade Levels
1,3,4,5,6
TX-CampusIdOfEnrollment
 Campus ID of Enrollment
 SCHOOLS
 CUSTOM_327
 Schools.custom_327(Campus ID) where custom_327 is used in School Information
1,4
TX-CampusIdOfResidence
 Campus ID of Residence
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1 / If TX-Attribution (LOG_FIELD2) = '00','12','22','24','26','28' output blank

Else output district value (LOG_FIELD5)+value of LOG_FIELD1
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the PEIMS tab in Student Information

If TX-Attribution (LOG_FIELD2) = '00','12','22','24','26','28' output blank

Else output district value (LOG_FIELD5)+value of LOG_FIELD1
 300000001
 1,3,4,5,6
TX-CampusIdOfAccountability
 Campus ID of Accountability
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1 / If submission not = 4 and value is not blank, output value

Else output blank
 Custom_Field_Log_Entries for FIeld ID 300000000 used on the PEIMS tab in Student Information

If submission not = 4 and value is not blank, output value

Else output blank
 300000000
 1,3,5,6
Element Name Alias Name Table Field/Logic End User Logic Feild ID Sub
TX-LastDateOfEnrollment
 Last Date of Enrollment
 STUDENT_ENROLLMENT
 END_DATE / If submission = 1 or 4 OR submission = 3 and student's grade level equals EE, PK, KG, 01, 02, 03, 04, 05 or 06, output blank.

Else output field value.
 Student_Enrollment.end_date is used on Student Enrollment

If submission = 1 or 4 OR submission = 3 or 5 and student's grade level equals EE, PK, KG, 01, 02, 03, 04, 05 or 06, output blank

Else output field value.
3,5,6
TX-Attribution
 Student Attribution
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD2 / If field value is blank, the use field default value. If no field default value has been set then output 00.
 Custom_Field_Log_Entries for FIeld ID 400009173 used on the PEIMS tab in Student Information

If field value is blank, the use field default value. If no field default value has been set then output 00.
 400009173
 1,3,4,5,6
TX-PKProgramTypeIndicator
 PK Program Type
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1 / If grade level is not PK output blank.

Else output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 Custom_Field_Log_Entries for FIeld ID 400000112 used on the PK tab in Student Information

If grade level is not PK output blank.

Else output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 400000112
 1
TX-PrimaryPKFundingSource
 Primary PK Funding Source
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1 / If grade level is not PK OR field value =1 or 3 output blank

Else output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 Custom_Field_Log_Entries for FIeld ID 400000114 used on the PK tab in Student Information

If grade level is not PK OR field value =01 or 03 output blank

Else output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 400000114
 1
TX-SecondaryPKFundingSource
 Secondary PK Funding Source
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1 / If grade level is not PK OR field value =1 or 3 output blank

Else output field valueElse output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 Custom_Field_Log_Entries for FIeld ID 400000116 used on the PK tab in Student Information

If grade level is not PK OR field value =01 or 03 output blank

Else output value in field. If no field value, then use field default value.  If no field default value has been set, then output 00.
 400000116
 1
Expand or collapse content Student Section Association
Element Name Alias Name Table Field/Logic End User Logic Field ID Sub
StudentUniqueStateId
 Texas Unique Student ID
 STUDENTS
 CUSTOM_400009369
 Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information
3,4,6
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_100000001 + CUSTOM_327
 Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information
3,4,6
UniqueSectionCode
 Class ID Number
LOGIC / If course_period.course_period_id is blank, then output CH + non_campus + marking period sort_name + short_name

Else output course_period.course_period_id + marking period.short_name.
 If Course_Period.course_period_id is blank, then output 'CH' concatenated with CoursePeriod.custom_4 concatenated with marking period (School or Course) sort_name concatenated with Courses.short_name(Submission 3) or Student_Report_Card_Gardes.course.num (Submission 4)

Else output Course_Period.course_period_id + marking period (School or Course) short_name.
3,4,6
BeginDate
 Student Begin Date
 SCHEDULE, STUDENT_REPORT_CARD_GRADES
 START_DATE / Submission 3 pulls this data from the SCHEDULE table, whereas Submission 4 pulls this data from the STUDENT_REPORT_CARD_GRADES table
 Submission 3 pulls this data from Schedule.start_date where start_date is used in Schedules, whereas Submission 4 pulls this data from Student_Report_Card_Grades.start_date where start_date is used in Grades
3,4,6
EndDate
 Student End Date
 SCHEDULE, STUDENT_REPORT_CARD_GRADES
 END_DATE
 Submission 3 pulls this data from Schedule.end_date where end_date is used in Schedules, whereas Submission 4 pulls this data from Student_Report_Card_Grades.end_date where end_date is used in Grades
3,4,6
HomeroomIndicator
 Home Room
 COURSE_PERIODS
 CUSTOM_15 / If value = Y then out true

Else output false.
 Course_Periods.custom_15 where custom_15 is used in Course Periods.  If value = Y then output true otherwise output false.
3,6
TX-CourseSequence
 Course Sequence
LOGIC
 If Course_Period.course_period_id is equal to blank and course_sequence (Master_Courses.custom_field_13) is not equal to blank and partial_credit (Master_Courses.custom_field_16 not equal to 1 or Y) not equal to Y, then use course_sequence (Master_Courses.custom_field_13).

Set (Schedule or Course_Periods).priority = 0 for School_Years table, 1 for School_Semesters table & 2 for School_Quarters table.Set (Schedule or Course_Periods).priority = 0 for School_Years table, 1 for School_Semesters table & 2 for School_Quarters table.

If Schedule.priority = 0, then output A.

If Course_Periods.priority equals Schedule.priority and Course_Periods.priority not equal to blank and Schedule.priority not equal to blank, IF Master_Courses.course_sequence is not blank, then use Master_Courses.course_sequence, otherwise output 0.

If Course_Periods.priority is not equal to Schedule priority, then use 1, 2, 3 or 4 based on Scheduling.sibling_count and Scheduling.course_sequence.
3,4,6
TX-CourseCompletionIndicator
 Course Completion
 STUDENT_REPORT_CARD_GRADES
 CUSTOM_11 / If field value is equal to blank, then output 0.
 Student_Report_Card_Grades.custom_11 where custom_11 is used in Grades.  If feild value is equal to blank then output Zeros.
3,4,6
Expand or collapse content Career And Technical Education Course Extension
Element Name Alias Name Table Field/Logic End User Logic
 Field ID
 Sub
StateOrganizationId
 District ID
 SCHOOLS
 CUSTOM_100000001
 Schools.custom_100000001(District ID) where custom_100000001 is used in School Information
1
StudentUniqueStateId
 Texas Unique Student ID
 STUDENTS
 CUSTOM_400009369
 Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information
1
TX-ServiceId
 Service ID
 COURSES
 CUSTOM_10
 Courses.custom_10 where custom_10 is used on Courses
1
Expand or collapse content School Leaver Extension
Element Name Alias Name Table Field/Logic End User Logic Field ID Sub
StateOrganizationId
 District ID
 SCHOOLS
 CUSTOM_100000001
 Schools.custom_100000001(District ID) where custom_100000001 is used in School Information
1
StudentUniqueStateId
 Texas Unique Student ID
 STUDENTS
 CUSTOM_400009369
 Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information
1
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_100000001 + CUSTOM_327
 Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information
1
TX-LeaverReasonCode
 Leaver Reason
 STUDENT_ENROLLMENT_CODES
 SHORT_NAME
 Student.Enrollment.COdes.short_name where short_name is used in Enrollment Codes
1
TX-DateOfGraduation
 Date of Graduation
 STUDENTS
 CUSTOM_400000015 / Students.custom_400000015 where custom_400000015 is used in Student Information. If submission = 3 or Student_Enrollment_Codes.short_name does not = 01 output blank

If not rsid and student_enrollment.end_date is not empty use student_enrollment.end_date

else use Students.custom_400000015
 Students.custom_400000015 where custom_400000015 is used in Student Information. If submission = 3 or Student_Enrollment_Codes.short_name does not = 01 output blank

If not rsid and student_enrollment.end_date is not empty use student_enrollment.end_date

else use Students.custom_400000015
1
TX-GraduationTypeCode
 Graduation Type
 STUDENTS
 CUSTOM_300000003 / If field is blank or submission =3 or students.CUSTOM_400000015 is blank or drop code does not equal 01 output blank

else use field value
 Students.custom_300000003 where custom_300000003 is used in Student Information.  If field is blank or submission = 3 or students.custom_400000015 is blank or Student_Enrollment_Codes.short_name does not equal 01 output blank

else use Students.custom_300000003
1
TX-IndividualGraduationCommitteeGraduateIndicator
 Individual Graduation Committee Graduate
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD2 / If submission =3 or submission = 1 and Student_Enrollment_Codes.short_name does not = 01 output blank

If value is blank output 00
 
Else output the value
 If submission = 3 or submission = 1 and Student_Enrollment_Codes.short_name does not = 01 output blank

If Custom_Field_Log_Entries.log_field_2 is blank or Field ID 300000042 is blank output 00
 
Else output Custom_Field_Log_Entries.log_field_2
 300000042
 1
TX-MilitaryEnlistmentIndicatorCode
 Military Enlistment
 STUDENTS
 CUSTOM_300000070
 Students.custom_300000070 where custom_300000070 is used in Student Information
1
Expand or collapse content Student Graduation Program
Element Name Alias Name Table Field/Logic End User Logic Field ID Sub
StateOrganizationId
 District ID
 SCHOOLS
 CUSTOM_100000001
 Schools.custom_100000001(District ID) where custom_100000001 is used in School Information
1,3
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_100000001 + CUSTOM_327
 Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information
1,3
StudentUniqueStateId
 Texas Unique Student ID
 STUDENTS
 CUSTOM_400009369
 Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information
1,3
TX-FHSPParticipant
 FHSP Participant
 STUDENTS
 CUSTOM_300000023 / Use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000023 used on the Graduation tab in Student Information
3
TX-FHSPDistingLevelAchieveIndicator
 FHSP Disting Level Achieve Indicator
 STUDENTS
 CUSTOM_300000024 / If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000024 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
1,3
TX-STEMEndorsementIndicator
 STEM Endorsement Indicator
 STUDENTS
 CUSTOM_300000025 / If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000025 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
1,3
Element Name
 Alias Name
 Table
 Field/Logic
 End User Logic
 Feild ID
 Sub
TX-BusinessAndIndustryEndorsementIndicator
 Business and Industry Endorsement Indicator
 STUDENTS
 CUSTOM_300000026 / If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000026 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 1,3
TX-PublicServicesEndorsementIndicator
 Public Services Endorsement Indicator
 STUDENTS
 CUSTOM_300000027 / If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000027 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
1,3
TX-ArtsAndHumanitiesEndorsementIndicator
 Arts and Humanities Endorsement Indicator
 STUDENTS
 CUSTOM_300000028 / If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000028 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 1,3
TX-MultiDisciplinaryStudiesEndorsementIndicator
 Multi Disciplinary Studies Endorsement Indicator
 STUDENTS
 CUSTOM_300000029 / If CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
 Students.custom_300000029 used on the Graduation tab in Student Information

If submission = 1 and students.CUSTOM_300000003 = '34','54','55','56','57' or field value = 1 output 0

If submission = 3 and CUSTOM_300000023 = 0 then output 0

Else use field value.  If no field value, then use field default value, if no field default value has been set, then output 0.
1,3
TX-IndividualGraduationCommitteeReviewIndicator
 Individual Graduation Committee Review
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD_2 / If submission = 1 OR student's grade level = 11 or 12 output blank

If value is blank output 00
 
Else output the value
 Custom_Field_Log_Entries for FIeld ID 300000042 used on the Graduation tab in Student Information

If submission equals 3 or submission equals 1 and drop code is not equal to 01 output blank, if value is blank and not default is set output 00.
 300000042
 3
Previous Article Student
Next Article Staff Association Extension
Download Article PDF Print Article

Texas State Reporting

Texas Reports 26
State Reporting Fields: TSDS Extracts 12