Documentation for Administrators

Student Attendance Extension

Updated on

Expand or collapse content Basic Reporting Period Attendance
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
Expand or collapse content Special Programs Reporting Period Attendance
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.0
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,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 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) = 1

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-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
Previous Article Staff Association Extension
Next Article Student Discipline Extension