| Element Name | Alias Name | Table | Field/Logic | End User Logic | Feild ID | Sub |
|---|---|---|---|---|---|---|
|
RestraintEventIdentifier |
Restraint Instance Number |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. |
400009430 and 300000002 |
3 |
|
EventDate |
Date of Restraint Event |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD5 |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. |
400009430 and 300000002 |
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 | |
|
StateOrganizationId |
Campus ID of Restraint Event |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 / If value is blank then use schools.SCHOOL_NUMBER. |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. |
400009430 and 300000002 |
3 |
|
TX-PrimaryRestraintReason |
Restraint Reason Code |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 / Use field value. If field value is blank, then use field default value. |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. |
400009430 and 300000002 |
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-InstructionalSetting |
Instructional Setting |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If Special Education (log_field29) is not equal to 1, output spaces, otherwise use field value. If field value is blank, then use field default value. |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. |
400009430 and 300000002 |
3 |
|
TX-RestraintStaff |
Restraint Staff Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD6 / Output 01 |
Custom_Field_Log_Entries for FIeld ID 300000002 & 400009430 where 300000002 is used on the Special Education tab and 400009430 is used on the Student Restraint tab in Student Information. Use '01'. |
400009430 and 300000002 |
3 |
|
TX-SpecialEducation |
Special ED Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
If student has a SPED record (Field ID 300000098) and Date of Restraint Event is between SPED Start/End date, then use 1 otherwise use 0. |
"If student has a SPED record (Field ID 300000098) and Date of Restraint Event is between SPED Start/End date, then use 1 otherwise use 0." |
300000098 |
3 |
|
TX-PrimaryDisability |
Primary Disability |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If Special Education (log_field29) is not equal to 1, output spaces, otherwise use field value. If field value is blank, then use field default value. |
Custom_Field_Log_Entries for FIeld ID 300000099 where 300000099 is used on the PEIMS/Special Education tab in Student Information. |
400000005 |
3 |
Student Restraint Event Extension
Updated on