| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
| ID |
Date ID |
TEXAS_CALENDAR_DATES |
SCHOOL_DATE + DAY_EVENT + WAIVER_EVENT + DAY_MINUTES + WAIVER_MINUTES |
Texas_Calendar_Dates.school_date concatenated with Texas_Calendar_Dates.day_event concatenated with Texas_Calendar_Dates.waiver_event concatenated with Texas_Calendar_Dates.day_minutes concatenated with Texas_Calendar_Dates.waiver_minutes where all fields are used in Calendar Dates |
3 |
|
|
Date |
Calendar Date |
TEXAS_CALENDAR_DATES |
SCHOOL_DATE |
Texas_Calendar_Dates.school_date where school_date is used in Calendar Dates |
3 |
|
|
TX‐SchoolDayCode |
School Day Event Code |
TEXAS_CALENDAR_DATES |
DAY_EVENT |
Texas_Calendar_Dates.day_event where day_event is used in Calendar Dates |
3 |
|
|
TX‐CalendarWaiverEventType |
Calendar Waiver Event Type |
TEXAS_CALENDAR_DATES |
WAIVER_EVENT |
Texas_Calendar_Dates.waiver_event where waiver_event is used in Calendar Dates |
3 |
|
|
TX‐SchoolDayOperationalMinutes |
School Day Operational Minutes |
TEXAS_CALENDAR_DATES |
DAY_MINUTES |
Texas_Calendar_Dates.day_minutes where day_minutes is used in Calendar Dates |
3 |
|
|
TX‐SchoolDayWaiverMinutes |
School Day Waiver Minutes |
TEXAS_CALENDAR_DATES |
WAIVER_MINUTES |
Texas_Calendar_Dates.waiver_minutes where waiver_minutes is used in Calendar Dates |
3 |
|
| TX‐SchoolDayInstructionalMinutes |
School Day Instructional Minutes |
TEXAS_CALENDAR_DATES |
DAY_MINUTES |
When Instructional Program Type is 01 (Standard Program 75,600 Operational Minutes) or 02 (Charter School after 01/01/2015 75,600 Operational Minutes), use Texas_Calendar_Dates.day_minutes where day_minutes is used in Calendar Dates |
3 |
|
| TX-InstructionalProgramType |
Instructional Program Type |
TEXAS_CALENDARS_TRACKS |
PROGRAM_TYPE |
Texas_Attendance_Cycles.program_type where program_type is used in Instructional Tracks |
| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
StateOrganizationId |
Campus ID |
SCHOOLS |
CUSTOM_327 |
Schools.custom_327(Campus ID) where custom_327 is used in School Information |
3 |
|
|
TX-SchoolYear |
School Year |
TEXAS_ATTENDANCE_CYCLES |
SYEAR |
Texas_Calendar_Dates.syear where syear is used in Attendance Cycles |
3 |
|
|
TX-ReportingPeriod |
Reporting Period Indicator |
TEXAS_ATTENDANCE_CYCLES |
REPORTING_PERIOD |
Texas_Calendar_Dates.reporting_period where reporting_period is used in Attendance Cycles |
3 |
|
|
BeginDate |
Reporting Period Begin Date |
TEXAS_ATTENDANCE_CYCLES |
START_DATE |
Texas_Calendar_Dates.start_date where start_date is used in Attendance Cycles |
3 |
|
|
EndDate |
Reporting Period End Date |
TEXAS_ATTENDANCE_CYCLES |
END_DATE |
Texas_Calendar_Dates.end_date where end_date is used in Attendance Cycles |
3 |
|
|
TX‐InstructionalTrack |
Instructional Track Indicator |
TEXAS_CALENDARS_TRACKS |
TRACK |
Texas_Calendar_Dates.track where track is used in Attendance Cycles |
3 |
|
|
TX‐NumberDaysTaught |
Number Days Taught |
ATTENDANCE_CALENDAR |
COUNT_SCHOOL_DATE |
Count of the number of Calendar Dates from Attendance_Calendar where the Attendance_Calendar.school_date falls between the range of Texas_Attendance_Cycles.start_date and Texas_Attendance_Cycles.end_date. |
3 |
|
|
CalendarDateReference |
Calendar Dates |
TEXAS_CALENDAR_DATES |
CD_ + SCHOOL_DATE + DAY_EVENT + WAIVER_EVENT + DAY_MINUTES + WAIVER_MINUTES |
CD concatentated with Texas_Calendar_Dates.school_date concatenated with Texas_Calendar_Dates.day_event concatenated with Texas_Calendar_Dates.waiver_event concatenated with Texas_Calendar_Dates.day_minutes concatenated with Texas_Calendar_Dates.waiver_minutes where all fields are used in Calendar Dates |
3 |