| 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 |
|
|
TX-CampusIdOfEnrollment |
Campus ID of Enrollment |
SCHOOLS |
LOGIC / String District (sch.CUSTOM_100000001) and School (sch.CUSTOM_327) together. |
Schools..custom_100000001 (District ID) concatenated with Schools.custom_327 (Campus ID) where custom_100000001 & custom_327 are used in School Information |
3 |
|
|
TX-AttendanceEventIndicator |
Attendance Event |
LOGIC / Output 01 |
Use '01' |
3 |
||
|
TX-InstructionalTrack |
Instructional Track Indicator |
TEXAS_CALENDARS_TRACKS |
TRACK |
Texas_Calendars_Tracks.track where track is used in Instructional Tracks |
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-NumberDaysTaught |
Number Days Taught |
ATTENDANCE_CALENDAR |
LOGIC / Count the number of school days (ac.SCHOOL_DATE) for the school year. |
Count the number of school days (Attendance_Calendar.school_date) for the school year. |
3 |
|
|
TX-GradeLevel |
Grade Level |
SCHOOL_GRADELEVELS |
SHORT_NAME |
School_Gradelevels.short_name where short_name is used in School Setup > Grade Levels |
3 |
|
|
TX-TotalDaysAbsent |
Total Days Absent |
LOGIC / Count number of days absent between student enrollment start date and student enrollment end date. If student_enrollment_codes.short_name is 2, 5 or 6 then count .5 else count 1.0 |
Count number of days absent between Student_Enrollment.start_date and Student_Enrollment.end_date where Attendance_Day.state_value is < 1 or 0. If Student_Enrollment_Codes.short_name is 2, 5 or 6 then count .5 else count 1.0 |
3 |
||
|
TX-TotalIneligibleDaysPresent |
Total Ineligible Days Present |
LOGIC / Count number of in ineligible days present between student enrollment start date and student enrollment end date. If student_enrollment_codes.short_name is 2, 5 or 6 then count .5 else count 1.0 Days are considered Ineligible when the student_enrollment_codes.short_name is not 1, 2, 3, 6 or 7. |
Count number of days present between Student_Enrollment.start_date and Student_Enrollment.end_date where Attendance_Day.state_value is NULL or 1 and Student_Enrollment_Codes.short_name is not 1, 2, 3, 6 and 7. If Student_Enrollment_Codes.short_name is 2, 5 or 6 then count .5 else count 1.0 |
3 |
||
|
TX-TotalEligibleDaysPresent |
Total Eligible Days Present |
LOGIC / Count number of in eligible days present between student enrollment start date and student enrollment end date. If student_enrollment_codes.short_name is 2, 5 or 6 then count .5 else count 1.0 Days are considered eligible when the student_enrollment_codes.short_name is 1, 2, 3, 6 or 7. |
Count number of days present between Student_Enrollment.start_date and Student_Enrollment.end_date where Attendance_Day.state_value is NULL or 1 and Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7. If Student_Enrollment_Codes.short_name is 2, 5 or 6 then count .5 else count 1.0 |
3 |
||
|
TX-PrimaryPKFundingSource |
Primary PK Funding Source |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If student grade level is not PK or PK Program Type is 01 or 03, output Blank Else if no value or default is present, output Blank. |
Custom_Field_Log_Entries for FIeld ID 400000114 used on the PK tab in Student Information If student grade level is not PK or PK Program Type is 01 or 03, output Blank |
400000114 |
3 |
|
TX-SecondaryPKFundingSource |
Secondary PK Funding Source |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If student grade level is not PK or PK Program Type is 01 or 03, output Blank Else if no value or default is present, output Blank. |
Custom_Field_Log_Entries for FIeld ID 400000116 used on the PK tab in Student Information If student grade level is not PK or PK Program Type is 01 or 03, output Blank |
400000116 |
3 |
|
TX-PKProgramTypeIndicator |
PK Program Type |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If student grade level is not PK, output Blank Else if no value or default is present, output 00. |
Custom_Field_Log_Entries for FIeld ID 400000112 used on the PK tab in Student Information LOG_FIELD1 |
400000112 |
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 |
3,4 |
|
|
TX-CampusIdOfEnrollment |
Campus ID of Enrollment |
SCHOOLS |
LOGIC / String District (sch.CUSTOM_100000001) and School (sch.CUSTOM_327) together. |
Schools..custom_100000001 (District ID) concatenated with Schools.custom_327 (Campus ID) where custom_100000001 & custom_327 are used in School Information |
3,4 |
|
|
TX-AttendanceEventIndicator |
Attendance Event |
LOGIC / For Regular Attendance, output 01. For Regular - Bilingual/ESL, output 02. For Regular - CTE, output 03. For Regular - PRS, output 04. For Regular - SpecialEd, output 05. For Regular - SpecialEd Mainstream, output 11. |
For Regular Attendance, use 01. For Regular - Bilingual/ESL, use 02. For Regular - CTE, use 03. For Regular - PRS, use 04. For Regular - SpecialEd, use 05. For Regular - SpecialEd Mainstream, use 11. |
3,4 |
||
|
TX-InstructionalTrack |
Instructional Track Indocator |
TEXAS_CALENDARS_TRACKS |
TRACK |
Texas_Calendars_Tracks.track where track is used in Instructional Tracks |
3,4 |
|
|
TX-ReportingPeriod |
Reporting Period Indicator |
TEXAS_ATTENDANCE_CYCLES |
REPORTING_PERIOD |
Texas_Attendance_Cycles.reporting_period where reporting_period is used in Attendance Cycles |
3,4 |
|
|
TX-NumberDaysTaught |
Number Days Taught |
ATTENDANCE_CALENDAR |
LOGIC / Count the number of school days (ac.SCHOOL_DATE) for the school year. |
Count the number of school days (Attendance_Calendar.school_date) for the school year. |
3,4 |
|
|
TX-GradeLevel |
Grade Level |
SCHOOL_GRADELEVELS |
SHORT_NAME |
School_Gradelevels.short_name where short_name is used in School Setup > Grade Levels |
3,4 |
|
| TX_BilingualESLFundingCode |
Bilingual Fund Code |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD9 |
Use "BE" if Custom_Field_Log_Entries for FIeld ID 400010549 (log_field9) used on the Bilingual/ESL tab in Student Information is NULL otherwise use log_field9. |
3,4 |
|
|
TX-TotalEligibleDaysPresent |
Total Eligible Days Present |
LOGIC / For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Count number of in eligible days present between student enrollment start date and student enrollment end date. If student_enrollment_codes.short_name is 2, 5 or 6 then count .5 else count 1.0 Days are considered eligible when the student_enrollment_codes.short_name is 1, 2, 3, 6 or 7. ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3), output NULL. |
Count number of days present between Student_Enrollment.start_date and Student_Enrollment.end_date where Attendance_Day.state_value is NULL or 1 and Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7. If Student_Enrollment_Codes.short_name is 2, 5 or 6 then count .5 else count 1.0Count number of days present between Student_Enrollment.start_date and Student_Enrollment.end_date where Attendance_Day.state_value is NULL or 1 and Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7. If Student_Enrollment_Codes.short_name is 2, 5 or 6 then count .5 else count 1.0 |
3,4 |
||
|
TX-RegDaySchProgDeaf |
Regular Day School Program Deaf |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD8 / For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - CTE (AttendanceEventIndicator = 3) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ For Regular - SpecialEd (AttendanceEventIndicator = 5): If Special Ed (ESE) log_field8 = NULL, then out 0, Else use log_field8. |
Custom_Field_Log_Entries for FIeld ID 400000005 used on the Special Education tab in Student Information |
400000005 |
3 |
|
TX-InstructionalSetting |
Instructional Setting |
LOGIC / For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - CTE (AttendanceEventIndicator = 3) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ For Regular - SpecialEd (AttendanceEventIndicator = 5): Use Special Ed (ESE) log_field2 OR If Special Ed (ESE) log_field20 = 2, then use 00, else use log_field2. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - CTE (AttendanceEventIndicator = 3) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - SpecialEd (AttendanceEventIndicator = 5) Use Custom_Field_Log_Entries.log_field2 (for FIeld ID 400000005) OR If Custom_Field_Log_Entries.log_field20 = 2 (for FIeld ID 400000005), then use 00, else use Custom_Field_Log_Entries.log_field2. |
3,4 |
||
|
TX-ExcessHoursInstrSetting |
Excess Hours in Instructional Setting |
LOGIC / For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - CTE (AttendanceEventIndicator = 3) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ For Regular - SpecialEd (AttendanceEventIndicator = 5): If sped.CONTACT_HOURS is not NULL AND cte.CTE_HOURS is not NULL AND ( gh.CTE_CERTIFIED is NULL or = 1 AND (cte.CTE_HOURS+sped.CONTACT_HOURS)>6 THEN (cte.CTE_HOURS+sped.CONTACT_HOURS)-6 ELSE, output 0 |
6\n THEN (cte.CTE_HOURS + sped.CONTACT_HOURS) - 6\nELSE\n use 0"}'>For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - CTE (AttendanceEventIndicator = 3) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - SpecialEd (AttendanceEventIndicator = 5) cte.CTE_HOURS = Course_Periods.custom_14 or Master_Courses.custom_3 gh.CTE_CERTIFIED = 1, if Custom_Field_Log_Entries.log_field4 (for FIeld ID 300000032 - General Ed Homebound, CTE Certified Teacher)) = 'Y', otherwise gh.CTE_CERTIFIED = 0 If sped.CONTACT_HOURS is not NULL AND cte.CTE_HOURS is not NULL AND (gh.CTE_CERTIFIED is NULL or = 1) AND (cte.CTE_HOURS + sped.CONTACT_HOURS) > 6 THEN (cte.CTE_HOURS + sped.CONTACT_HOURS) - 6 ELSE use 0 |
3 |
||
|
TX-CTEEligibleDaysPresentV1 |
Eligible Days Present V1 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) |
3 |
||
|
TX-CTEEligibleDaysPresentV2 |
Eligible Days Present V2 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3) When Master_Courses.custom_field_3 (CTE_Hours) = 2 AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) AND Attendance_Day.state_value is NULL or 1 AND Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7 AND student_id for Custom_Field_Log_Entries for FIeld ID (400000228 for leisd or 400010960 for all other Texas districts) IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
3 |
||
|
TX-CTEEligibleDaysPresentV3 |
Eligible Days Present V3 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3) When Master_Courses.custom_field_3 (CTE_Hours) = 3 AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) AND Attendance_Day.state_value is NULL or 1 AND Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7 AND student_id for Custom_Field_Log_Entries for FIeld ID (400000228 for leisd or 400010960 for all other Texas districts) IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
3 |
||
|
TX-CTEEligibleDaysPresentV4 |
Eligible Days Present V4 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3) When Master_Courses.custom_field_3 (CTE_Hours) = 4 AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) AND Attendance_Day.state_value is NULL or 1 AND Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7 AND student_id for Custom_Field_Log_Entries for FIeld ID (400000228 for leisd or 400010960 for all other Texas districts) IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
3 |
||
|
TX-CTEEligibleDaysPresentV5 |
Eligible Days Present V5 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3) When Master_Courses.custom_field_3 (CTE_Hours) = 5 AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) AND Attendance_Day.state_value is NULL or 1 AND Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7 AND student_id for Custom_Field_Log_Entries for FIeld ID (400000228 for leisd or 400010960 for all other Texas districts) IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
3 |
||
|
TX-CTEEligibleDaysPresentV6 |
Eligible Days Present V6 |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Output NULL ------------------------------------------ Regular - CTE (AttendanceEventIndicator = 3) When se.IS_PRESENT=1 AND se.IS_ELIG=1 AND cte.IS_CERTIFIED=1 AND se.SCHOOL_DATE=cte.SCHOOL_DATEAND prs.STUDENT_ID IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
For Regular - Bilingual/ESL (AttendanceEventIndicator = 2) and Regular - PRS (AttendanceEventIndicator = 4) and Regular - SpecialEd (AttendanceEventIndicator = 5) and Regular - SpecialEd Mainstream (AttendanceEventIndicator=11) : Use NULL ------------------------------------------ For Regular - CTE (AttendanceEventIndicator = 3) When Master_Courses.custom_field_3 (CTE_Hours) >= 6 AND (Course_Periods.custom_1 (CTE Certified) = Y OR (Course_Teacher_History.course_period_id IS NULL and Users.custom_300000003 (CTE Certified) = Y) OR (Users.custom_300000003 (CTE Certified) = Y and (User.custom_300000004 (CTE Certified Begin Date) IS NULL or <= Attendance_Calendar.school_date))) AND Attendance_Day.state_value is NULL or 1 AND Student_Enrollment_Codes.short_name is 1, 2, 3, 6 or 7 AND student_id for Custom_Field_Log_Entries for FIeld ID (400000228 for leisd or 400010960 for all other Texas districts) IS NULL Count number of in eligible days present between student enrollment start date and student enrollment end date. If count is NULL, use 0 Else use count. |
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 |
3 |