| 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 |
|
|
TX-Bilingual |
Bilingual Program Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400010549 where 400010549 is used on the ELL tab in Student Information. |
400010549 |
1 |
|
TX-BilingualESLSummer |
Bilingual ESL Summer School |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400000090 where 400000090 is used on the ELL tab in Student Information. |
400000090 |
4 |
|
TX-CareerAndTechnologyEd |
Career and Technial Ed Indicator |
LOGIC / If Submission = 1 Then use students.CUSTOM_400009169 else use students.CUSTOM_300000057 |
1,3 |
|||
|
TX-ESL |
ESL Program Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD7 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400010549 where 400010549 is used on the ELL tab in Student Information. |
400010549 |
1 |
|
TX-GiftedAndTalented |
Gifted Talented Indicator |
STUDENTS |
CUSTOM_400000003 / If student is enrolled into grade level EE or PK then use 0. |
Custom_Field_Log_Entries for FIeld ID 400000003 where 400000003 is used on the PEIMS tab in Student Information. If student is enrolled into grades EE or PK then use 0. |
1,3,4 |
|
|
TX-PregnancyRelatedSvcs |
TX-PregnancyRelatedSvcs |
LOGIC / If school district=LEISD THEN use field_id=400000228 and exit=LOG_FIELD4 AND field=LOG_FIELD3 ELSE use field_id=400010960 AND exit=LOG_FIELD3 AND field=LOG_FIELD2 |
Custom_Field_Log_Entries for FIeld ID 400000228(Little Elm) or 400010960(all other Texas Districts) where 400000228 is used on the Pregnancy Related Services tab and 400010960 is used on the PRS tab in Student Information. |
See End User Logic for Feild ID information. |
3 |
|
|
TX-SpecialEducation |
Special Ed Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD29 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400000005 where 400000005 is used on the Special Education tab in Student Information. |
400000005 |
1,3 |
| TX-AlternativeLanguageProgram |
Alternative Language Program |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If field value is not found or blank, then output 0. |
Custom_Field_Log_Entries for FIeld ID 300000097 where 300000097 is used on the PEIMS tab in Student Information. |
300000097 |
1 |
| TX-DyslexiaServices |
Dyslexia Services |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If field value is not found or blank, then output blank. |
Custom_Field_Log_Entries for FIeld ID 300000129 where 300000129 is used on the PEIMS tab in Student Information. |
300000129 |
3 |
| 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 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
1 |
|
|
TX-DisplacedHomemakerCode |
Displaced Homemaker |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400000005 where 400000005 is used on the CATE or CTE tab in Student Information. |
400000095 |
1 |
|
TX-CTETransportationServices |
Transportation CTE Support Service |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400000066 where 400000066 is used on the CATE or CTE tab in Student Information. |
400000066 |
1 |
|
TX-SingleParentPregTeenCode |
SIngle Parent Pregant Teen |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for FIeld ID 400000023 where 400000023 is used on the LSPSP or CTE tab in Student Information. |
400000023 |
1 |
| 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 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
1,3 |
|
| TX-EffectiveDateSpEd |
Effective Date Special Ed |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. |
30000098 |
1,3 |
| TX-EffectiveDateDisabilities |
Effective Date Disabilities |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 |
Custom_Field_Log_Entries for Field ID 300000099 where 300000099 is used on the PEIMS/Special Education tab in Student Information. |
300000099 |
1,3 |
|
TX-PrimaryDisability |
Primary Disability Code |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If field value is blank, use field default value. If field default value is not set then output 00. |
Custom_Field_Log_Entries for Field ID 300000099 where 300000099 is used on the PEIMS/Special Education tab in Student Information. |
300000099 |
1,3 |
|
TX-SecondaryDisability |
Secondary Disability Code |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 |
Custom_Field_Log_Entries for Field ID 300000099 where 300000099 is used on the PEIMS/Special Education tab in Student Information. |
300000099 |
1,3 |
|
TX-TertiaryDisability |
Tertiary Disability Code |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 |
Custom_Field_Log_Entries for Field ID 300000099 where 300000099 is used on the PEIMS/Special Education tab in Student Information. |
300000099 |
1,3 |
|
TX-MultiplyDisabled |
Multiply Disabled Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. |
30000098 |
1,3 |
|
TX-MedicallyFragile |
Medically Fragile Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. |
30000098 |
1,3 |
|
TX-InstructionalSetting |
Instructional Setting |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 /If district is not RISD, and Log_Field17 for Field ID 300000100 equals one, then output "00" |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. If district is not RISD, and Log_Field17 for Field ID 300000100 (Speech Therapy Indicator) equals one, then output "00" |
300000098 |
1,3 |
|
TX-ChildCountFunding |
Child Count Funding Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD5 / If field value is blank and student's birthdate is greater than Sept 1, (syear - 3), output 0 Else output 3 |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. If field value is blank and student's birthdate is greater than Sept 1, (current school year - 3), output 0 Else output 3 |
400000005 |
1,3 |
| TX-EffectiveDateServices |
Effective Date Services |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-AssistiveTechnology |
Assistive Tech Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-AudiologicalServices |
Audiological Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-CounselingServices |
Counseling Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-EarlyChildhoodIntervention |
Early Childhood Intervention Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD5 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-InterpretingServices |
Interpreting Services Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD6 / If field value is blank, use field default value. If field default value is not set then output 00. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-MedicalDiagnosticServices |
Medical Diagnostic Services Indicaotr |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD7 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-OccupationalTherapy |
Occupational Therapy Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD8 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-OrientationMobilityTraining |
Orient Mobility Training Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD9 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-PhysicalTherapy |
Physical Therapy Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD10 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-PreschlPrgmChildDisabilities |
Preschool Program Children w/Disabilities Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD11 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-PsychologicalServices |
Psychologocal Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD12 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-Recreation |
Recreation Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD13 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-RegDaySchProgDeaf |
Regular Day School Program Deaf |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD14 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-SchoolHealthServices |
School Health Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD15 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-SocialWorkServices |
Social Work Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD16 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-SpeechTherapy |
Speech Therapy Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD17 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-Transportation |
Transportation Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD18 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000100 where 300000100 is used on the PEIMS/Special Education tab in Student Information. |
300000100 |
1,3 |
|
TX-PPCDServiceLocationIndicator |
PPCD Service Location |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD6 / If field value is blank, use field default value. If field default value is not set then output 0. |
Custom_Field_Log_Entries for Field ID 300000098 where 300000098 is used on the PEIMS/Special Education tab in Student Information. |
300000098 |
1,3 |
|
TX-LEAOfRDSPDService |
District of RDSPD Service |
STUDENTS |
CUSTOM_300000007 |
Students.custom_30000007 where custom_300000007 is used on the Special Education tab in Student Information. If Students.custom_300000007 is Blank or 0 then use Blank otherwise use Students.custom_300000007 |
1,3 |
| 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 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
1,3 |
|
|
TX-CampusIdOfEnrollment |
Campus ID of Enrollment |
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 |
|
|
TX-SocialWorkServices |
Title 1 Part A Social Work Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD7 / If Log_Field_1 equals 6 output a zero, ELSE if there is a value populated use that value, If no value output zero. |
Custom_Field_Log_Entries for FIeld ID 400009828 where 400009828 is used on the Title 1 SES tab in Student Information. If Log_Field_1 (Title 1 Part A Indicator) equals 6 output a zero, Else If there is a value populated use that value, If no value exist then output a zero. |
400009828 |
3 |
|
TX-HealthServices |
Title 1 Part A Health Services Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD8 / If Log_Field_1 equals 6 output a zero, ELSE if there is a value populated use that value, If no value output zero. |
Custom_Field_Log_Entries for FIeld ID 400009828 where 400009828 is used on the Title 1 SES tab in Student Information. If Log_Field_1 (Title 1 Part A Indicator) equals 6 output a zero, Else If there is a value populated use that value, If no value exist then output a zero. |
400009828 |
3 |
|
TX-TitleIPartAIndicator |
Title 1 Part A Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If school Title 1 Part A program (sch.custom_400009177) is not Blank and equal to 6, output 6 Else use Title 1 Part A (400009829, log_field1) Else if Title 1 Part A (400009829, log_field1 is blank, output 0. |
Custom_Field_Log_Entries for FIeld ID 400009828 where 400009828 is used on the Title 1 SES tab in Student Information. If School.custom_400009177 (Title 1 Part A program) is not Blank and equal to 6, output 6 Else use Title 1 Part A (400009829, log_field1) Else if Title 1 Part A 400009829, log_field1 is blank, output 0. |
400009828 |
1,3 |
| 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 |
4 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
4 | |
|
TX-CampusIdOfEnrollment |
Campus ID of Enrollment |
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 |
4 | |
|
TX-GradeLevel |
Grade Level |
SCHOOL_GRADELEVELS |
SHORT_NAME |
School_Gradelevels.short_name where short_name is used in School Setup > Grade Levels |
4 | |
|
TX-InstructionalSetting |
Instructional Setting 1 |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 / Use field value, if no field value exist, output 00. |
Custom_Field_Log_Entries for FIeld ID 300000021 where 300000021 is used on the PEIMS tab in Student Information. if no value exist, output 00. |
300000021 |
4 |
|
TX-TotalESYContactHoursInstructionalSetting |
ESY Contact Hours 1 |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 |
Custom_Field_Log_Entries for FIeld ID 300000021 where 300000021 is used on the PEIMS tab in Student Information. |
300000021 |
4 |
|
TX-InstructionalSetting_2 |
Instructional Setting 2 |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 |
Custom_Field_Log_Entries for FIeld ID 300000021 where 300000021 is used on the PEIMS tab in Student Information. |
300000021 |
4 |
|
TX-TotalESYContactHoursInstructionalSetting_2 |
ESY Contact Hours 2 |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD5 |
Custom_Field_Log_Entries for FIeld ID 300000021 where 300000021 is used on the PEIMS tab in Student Information. |
300000021 |
4 |