Student Discipline Extension

Updated on Nov 06, 2019

Discipline Incident

Element Name	Alias Name	Table	Field/Logic	End User Logic	Sub
Discipline-Incident-ID	Discipline Incident ID		LOGIC / DI_ + schools.CUSTOM_100000001 + schools.CUSTOM_327 + - + discipline_referrals.CUSTOM_83	DI_ concatenated with Schools.custom_100000001 concatenated with Schools.custom_327 concatenated with - concatenated with Discipline_Referrals.custom_83	3
IncidentIdentifier	Disciplinary Incident Number	DISCIPLINE_REFERRALS	CUSTOM_83	Discipline_Referrals.custom_83 where custom_83 is used in Discipline Referrals	3
TX-CampusIdOfEnrollment	Campus ID of Enrollment	SCHOOLS	CUSTOM_327	Schools.custom_327(Campus ID) where custom_327 is used in School Information	3

Student Discipline Incident 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
DisciplineIncidentReference	Disciplinary Incident Number	DISCIPLINE_REFERRALS	CUSTOM_83	Discipline_Referrals.custom_83 where custom_83 is used in Discipline Referrals		3
TX-DisciplinaryActionReason	Disciplinary Action Reason	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD11 / If value is blank, use 00.	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
TX-BehaviorLocation	Behavior Location	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD12 / If value is blank, use 00.	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3

Discipline Action

Element Name	Alias Name	Table	Field/Logic	End User Logic	Field ID	Sub
DisciplineActionIdentifier	Disciplinary Action Number		LOGIC / ROW_NUMBER() OVER (ORDER BY discipline_referrals_log_entries.LOG_FIELD2 ASC) AS ACTION_NUMBER	ROW_NUMBER() OVER (ORDER BY discipline_referrals_log_entries.LOG_FIELD2 ASC) AS ACTION_NUMBER. Auto increment action_number starting with 1.		3
DisciplineDate	Date of Disciplinary Action	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD2	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
ActualDisciplineActionLength	Actual Length of Disciplinary Assignement	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD9	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
StudentUniqueStateId	Texas Unique Student ID	STUDENTS	CUSTOM_400009369	Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information		3
DisciplineIncidentReference	Disciplinary Incident Number	DISCIPLINE_REFERRALS	CUSTOM_83	Discipline_Referrals.custom_83 where custom_83 is used in Discipline Referrals		3
StateOrganizationId	Campus ID of Disciplinary Responsibility	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD14	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
StateOrganizationId	Campus ID of Disciplinary Assignment	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD13	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
TX-DisciplinaryActionCode	Disciplinary Action Code	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD1	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
TX-ReportingPeriod	Reporting Period Indicator	TEXAS_ATTENDANCE_CYCLES	REPORTING_PERIOD	Texas_Attendance_Cycles.reporting_period where reporting_period is used in Attendance Cycles		3
TX-OfficialLengthOfDisciplinaryAssignment	Official Length of Disciplinary Assignemnt	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD5	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3
TX-DisciplinaryLengthDifferenceReason	Disciplinary Length Difference Reason	DISCIPLINE_REFERRALS_LOG_ENTRIES	LOG_FIELD10	Discipline_Referrals_Log_Entries for FIeld ID 2000001 used on Discipline Referrals	2000001	3

Previous Article Student Attendance Extension

Next Article Student Transcript Extension

Documentation for Administrators

Student Discipline Extension

Texas State Reporting