Student Attendance
Student attendance refers to the tracking and reporting of students’ presence or absence in school. This category is essential for understanding student engagement and identifying potential issues that may affect academic performance. Here are the key components:
Attendance Events: These are records of each instance of a student’s presence or absence. They include details such as the date, type of attendance (e.g., present, absent, tardy), and the reason for absence if applicable.
Daily Attendance: This tracks whether a student is present or absent for the entire school day.
Class Period Attendance: This tracks attendance for each class period throughout the school day.
Attendance Interventions: These are actions taken by the school to address attendance issues, such as contacting parents, providing counseling, or implementing attendance improvement plans.
The Student Attendance category describes student attendance and attendance taken events. It can be used to exchange daily, section, intervention, or program attendance events. It may be used in cases where only absences are reported (attendance is assumed if no absence is reported), or where both attendance and absences are reported.
Category | Resource | Element | TX Element | TX Element Name | Stored in Table [Field Name] | Required? | Comments | |
---|---|---|---|---|---|---|---|---|
studentSchoolAttendanceEventsPrimary PowerSchool Source DataTables: ATTENDANCE (att), ATTENDANCE_CODE (ac), CALENDAR_DAY (cd), BELL_SCHEDULE_ITEMS (bsi), S_TX_BSI_X (bsix) Selection CriteriaPublish for all enrolled students where student and/or school not excluded from publishing.
Resource Output | ||||||||
attendanceEventCategoryDescriptor | E3008 | ac.att_code - mapped value or presence_status_cd | Y | attendance code mapping TBD - absent/present status may be sufficient, only absences published | ||||
eventDate | E3027 | att.event_date | Y | |||||
schoolId | students/reenrollments schoolId, entrydate, exitdate | Y | enrolled school on date of attendance record - p_schoolid | |||||
sessionReference | derived from Terms (t) | Y | Reporting period term or school year term TBD | |||||
schoolId | enrolled school (same as above) | Y | p_schoolid - context school | |||||
schoolYear | p_yearid + 1991 | Y | context school year | |||||
sessionName | reporting period term or school year term TBD | Y | to_char(t.schoolid) || '-' || replace(trim(t.abbreviation), '[tab]', '') || '-' || to_char(t.dcid) | |||||
studentUniqueId | derived from att.studentid | Y | State-assigned number for student (s.state_studentnumber) | |||||
attendanceEventReason | to_char(substr(att.att_comment, 1, 40)) | N | ||||||
eventDuration | E3053 | TX | percentage of day | |||||
additional fields for display only | ||||||||
sch.school_name | district view only - from sp.schoolid | |||||||
s.student_number | ||||||||
s.lastfirst | ||||||||
s/r.grade_level | grade level from most recent enrollment in selected year | |||||||
studentSectionAttendanceEventsPrimary PowerSchool Source DataTables ATTENDANCE (att), ATTENDANCE_CODE (ac), Sections (sec), CC Requested for TX Exchange, not collected by TEA; publish per Base Profile (except use TX section identifier)
| ||||||||
attendanceEventCategoryDescriptor | ac.att_code - mapped value | Y | attendance code mapping possibly required, TBD Descriptors are same as for daily attendance | |||||
eventDate | att.event_date | Y | ||||||
sectionReference | Y | |||||||
localCourseCode | sec.course_number | Y | FORMAT: replace(trim(sec.course_number), ' ', '_') | |||||
schoolId | sec.schoolid | Y | sec.schoolid = p_schoolid | |||||
schoolYear | terms.yearid + 1991 | Y | terms.yearid = p_yearid | |||||
sectionIdentifier | S_TX_SEC_X. E1056_ClassID_Calc | Y | May 2022 SR release | |||||
sessionName | section term, name derived from terms.schoolid, terms.abbreviation, terms.dcid | Y | to_char(t.schoolid) || '-' || replace(trim(t.abbreviation), '[tab]', '') || '-' || to_char(t.dcid) | |||||
studentUniqueId | derived from cc.studentid | Y | State-assigned number for student (s.state_studentnumber) | |||||
attendanceEventReason | to_char(substr(att.att_comment, 1, 40)) | N | ||||||
additional fields for display only | ||||||||
sch.school_name | district view only - most recent enrolled school in selected year | |||||||
s.student_number | ||||||||
s.lastfirst | ||||||||
s/r.grade_level | grade level from most recent enrollment in selected year | |||||||
COURSES.course_name | ||||||||
sec.section_number | ||||||||
studentProgramAttendanceEvents | ||||||||
attendanceEventCategoryDescriptor | E3008 | ac.att_code - mapped value | Y | attendance code mapping required. Descriptors are same as for daily attendance | ||||
eventDate | E3027 | att.event_date | Y | |||||
educationOrganizationId | Y | |||||||
programReference | Y | |||||||
educationOrganizationId | Y | |||||||
programName | Y | |||||||
programTypeDescriptor | Y | |||||||
studentUniqueId | Y | |||||||
educationalEnvironmentDescriptor | E0173 | INSTRUCTIONAL-SETTING-CODE | TX | |||||
programAttendanceDuration | E3053 | TX | time in minutes | |||||
Attendance Extensions | ||||||||
basicReportingPeriodAttendanceTable-S_TX_STU_ATT_BASIC_C Summary report per student for each reporting period | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | S_TX_STU_ATT_BASIC_C.E0975_CALENDAR_CODE | ||||||
reportingPeriodDescriptor | E0934 | S_TX_STU_ATT_BASIC_C.E0934_RPT_PERIOD | ||||||
gradeLevelDescriptor | E0017 | S_TX_STU_ATT_BASIC_C. | ||||||
numberDaysTaught | E0935 | S_TX_STU_ATT_BASIC_C.E0935_DAYS_TAUGHT | ||||||
totalDaysAbsent | E0036 | S_TX_STU_ATT_BASIC_C.E0036_DAYS_ABS | ||||||
totalIneligibleDaysPresent | E0936 | S_TX_STU_ATT_BASIC_C.E0936_INELIG_DAYS_PRES | ||||||
totalEligibleDaysPresent | E0937 | S_TX_STU_ATT_BASIC_C.E0937_ELIG_DAYS_PRES | ||||||
rsTotalEligibleDaysPresent | E1678 | S_TX_STU_ATT_BASIC_C.E1678_RS_DAYS_PRES | ||||||
raTotalEligibleDaysPresent | E1679 | S_TX_STU_ATT_BASIC_C.E1679_RA_DAYS_PRES | ||||||
specialProgramsReportingPeriodAttendanceTable-S_TX_STU_ATT_SPR_C Summary report per student in program for each reporting period while student active in program | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | S_TX_STU_ATT_SPR_C.E0975_CALENDAR_CODE | ||||||
reportingPeriodDescriptor | E0934 | S_TX_STU_ATT_SPR_C.E0934_RPT_PERIOD | ||||||
gradeLevelDescriptor | E0017 | S_TX_STU_ATT_SPR_C.E0017_GRADE_LEVEL | ||||||
numberDaysTaught | E0935 | S_TX_STU_ATT_SPR_C.E0935_DAYS_TAUGHT | ||||||
totalEligPregRelSvcsDaysPresent | E0939 | S_TX_STU_ATT_SPR_C.E0939_PRS_DAYS_PRES | ||||||
rsTotalEligPregRelSvcsDaysPresent | E1686 | S_TX_STU_ATT_SPR_C.E1686_PRS_RS_DAYS_PRES | ||||||
raTotalEligPregRelSvcsDaysPresent | E1687 | S_TX_STU_ATT_SPR_C.E1687_PRS_RA_DAYS_PRES | ||||||
totalEligSpEdMainstreamDaysPresent | E0940 | S_TX_STU_ATT_SPR_C.E0940_MS_DAYS_PRES | ||||||
rsTotalEligSpEdMainstreamDaysPresent | E1688 | S_TX_STU_ATT_SPR_C.E1688_MS_RS_DAYS_PRES | ||||||
raTotalEligSpEdMainstreamDaysPresent | E1689 | S_TX_STU_ATT_SPR_C.E1689_MS_RA_DAYS_PRES | ||||||
totalEligResidentialFacilityDaysPresent | E1652 | S_TX_STU_ATT_SPR_C.E1652_RF_DAYS_PRES | ||||||
rsTotalEligResidentialFacilityDaysPresent | E1684 | S_TX_STU_ATT_SPR_C.E1684_RF_RS_DAYS_PRES | ||||||
raTotalEligResidentialFacilityDaysPresent | E1685 | S_TX_STU_ATT_SPR_C.E1685_RF_RA_DAYS_PRES | ||||||
specialEducationProgramReportingPeriodAttendanceTable-S_TX_STU_ATT_SPED_C | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | S_TX_STU_ATT_SPED_C.E0975_CALENDAR_CODE | ||||||
reportingPeriodDescriptor | E0934 | S_TX_STU_ATT_SPED_C.E0934_RPT_PERIOD | ||||||
gradeLevelDescriptor | E0017 | S_TX_STU_ATT_SPED_C.E0017_GRADE_LEVEL | ||||||
numberDaysTaught | E0935 | S_TX_STU_ATT_SPED_C.E0935_DAYS_TAUGHT | ||||||
instructionalSettingDescriptor | E1073 | S_TX_STU_ATT_SPED_C.E0173_SPED_IS | ||||||
eligibleDaysPresentInInstrSetting | E0944 | S_TX_STU_ATT_SPED_C.E0944_SPED_IS_DAYS_PRES | ||||||
rsEligibleDaysPresentInInstrSetting | E1690 | S_TX_STU_ATT_SPED_C.E1690_SPED_IS_RS_DAYS_PRES | ||||||
raEligibleDaysPresentInInstrSetting | E1691 | S_TX_STU_ATT_SPED_C.E1691_SPED_IS_RA_DAYS_PRES | ||||||
excessHoursInInstructionalSetting | E0945 | S_TX_STU_ATT_SPED_C.E0945_SPED_IS_EXCESS_HRS | ||||||
rsExcessHoursInInstructionalSetting | E1694 | S_TX_STU_ATT_SPED_C.E1694_SPED_IS_RS_EXCESS_HRS | ||||||
raExcessHoursInInstructionalSetting | E1695 | S_TX_STU_ATT_SPED_C.E1695_SPED_IS_RA_EXCESS_HRS | ||||||
regionalDaySchoolProgramForDeafDescriptor | E0833 | S_TX_STU_ATT_SPED_C.E0833_RDSPD | ||||||
leaOfRDSPDService | E1527 | S_TX_STU_ATT_SPED_C.E1527_DIST_RDSPD | ||||||
cteProgramReportingPeriodAttendanceTable-S_TX_STU_ATT_CTE_C | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | S_TX_STU_ATT_CTE_C.E0975_CALENDAR_CODE | ||||||
reportingPeriodDescriptor | E0934 | S_TX_STU_ATT_CTE_C.E0934_RPT_PERIOD | ||||||
gradeLevelDescriptor | E0017 | S_TX_STU_ATT_CTE_C.E0017_GRADE_LEVEL | ||||||
numberDaysTaught | E0935 | S_TX_STU_ATT_CTE_C.E0935_DAYS_TAUGHT | ||||||
cteServiceIdDescriptor | E0724 | S_TX_STU_ATT_CTE_C.E0724_CTE_SERVICE_ID | ||||||
eligibleDaysPresentV1 | E0950 | S_TX_STU_ATT_CTE_C.E0950_DAYS_PRES_V1 | ||||||
rsEligibleDaysPresentV1 | E1696 | S_TX_STU_ATT_CTE_C.E1696_RS_DAYS_PRES_V1 | ||||||
raEligibleDaysPresentV1 | E1702 | S_TX_STU_ATT_CTE_C.E1702_RA_DAYS_PRES_V1 | ||||||
eligibleDaysPresentV2 | E0951 | S_TX_STU_ATT_CTE_C.E0951_DAYS_PRES_V2 | ||||||
rsEligibleDaysPresentV2 | E0697 | S_TX_STU_ATT_CTE_C.E1697_RS_DAYS_PRES_V2 | ||||||
raEligibleDaysPresentV2 | E1703 | S_TX_STU_ATT_CTE_C.E1703_RA_DAYS_PRES_V2 | ||||||
eligibleDaysPresentV3 | E0952 | S_TX_STU_ATT_CTE_C.E0952_DAYS_PRES_V3 | ||||||
rsEligibleDaysPresentV3 | E1698 | S_TX_STU_ATT_CTE_C.E1698_RS_DAYS_PRES_V3 | ||||||
raEligibleDaysPresentV3 | E1704 | S_TX_STU_ATT_CTE_C.E1704_RA_DAYS_PRES_V3 | ||||||
bilingualESLProgramReportingPeriodAttendance | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | |||||||
reportingPeriodDescriptor | E0934 | |||||||
gradeLevelDescriptor | E0017 | |||||||
numberDaysTaught | E0935 | |||||||
bilingualESLFundingDescriptor | E1651 | |||||||
totalEligBilingualESLDaysPresent | E0938 | |||||||
rsTotalEligBilingualESLDaysPresent | E1682 | |||||||
raTotalEligBilingualESLDaysPresent | E1683 | |||||||
flexibleRegularProgramReportingPeriodAttendance | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | |||||||
reportingPeriodDescriptor | E0934 | |||||||
gradeLevelDescriptor | E0017 | |||||||
numberDaysTaught | E0935 | |||||||
flexAttendanceProgramDescriptor | E1045 | |||||||
flexAttendTotalEligibleMinutesPresent | E1046 | |||||||
flexAttendTotalIneligibleMinutesPresent | E1047 | |||||||
flexTotalEligPregRelSvcsDaysPresent | E1048 | |||||||
flexTotalEligSpEdMainstreamDaysPresent | E1049 | |||||||
flexTotalEligResidentialFacilityDaysPresent | E1653 | |||||||
flexibleSpecialEducationProgramReportingPeriodAttendance | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | |||||||
reportingPeriodDescriptor | E0934 | |||||||
gradeLevelDescriptor | E0017 | |||||||
numberDaysTaught | E0935 | |||||||
flexAttendanceProgramDescriptor | E1045 | |||||||
instructionalSettingDescriptor | E1073 | |||||||
flexAttendDaysEligibleInInstrSetting | E1051 | |||||||
flexAttendExcessMinutesInInstrSetting | E1052 | |||||||
flexibleCTEProgramReportingPeriodAttendance | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | |||||||
reportingPeriodDescriptor | E0934 | |||||||
gradeLevelDescriptor | E0017 | |||||||
numberDaysTaught | E0935 | |||||||
flexAttendanceProgramDescriptor | E1045 | |||||||
flexAttendTotalCareerTechMinutesPresent | E1053 | |||||||
flexibleBilingualESLProgramReportingPeriodAttendance | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
calendarCode | E0975 | |||||||
reportingPeriodDescriptor | E0934 | |||||||
gradeLevelDescriptor | E0017 | |||||||
numberDaysTaught | E0935 | |||||||
flexAttendanceProgramDescriptor | E1045 | |||||||
bilingualESLFundingDescriptor | E1651 | |||||||
flexTotalEligBilingualESLDaysPresent | E1050 | |||||||
extendedSchoolYearServicesAttendanceTables: S_TX_STU_ESY_C Selection Criteria: | ||||||||
schoolId | ||||||||
studentUniqueId | ||||||||
gradeLevelDescriptor | E0017 | |||||||
firstInstructionalSettingDescriptor | E0173 | INSTRUCTIONAL-SETTING-CODE | S_TX_STU_ESY_C.E0173_INSTR_SETTING1 | |||||
totalESYContactHoursInFirstInstructionalSetting | E1013 | TOTAL-ESY-CONTACT-HRS-IN-INSTR-SETTING | S_TX_STU_ESY_C.E1013_CONTACT_HOURS1 | |||||
secondInstructionalSettingDescriptor | E0173 | INSTRUCTIONAL-SETTING-CODE | S_TX_STU_ESY_C.E0173_INSTR_SETTING2 | |||||
totalESYContactHoursInSeconsInstructionalSetting | E1013 | TOTAL-ESY-CONTACT-HRS-IN-INSTR-SETTING | S_TX_STU_ESY_C.E1013_CONTACT_HOURS2 | |||||
flexibleCTEProgramReportingPeriodAttendancesTables: S_TX_STU_ATT_FLEX_CTE_C | ||||||||
CalendarCode | E0975 | CALENDAR_CODE | CalendarCode- | |||||
GradeLevel | E0017 | GRADE_LEVEL | GradeLevel-S_TX_STU_ATT_FLEX_CTE_C.E0017_GRADE_LEVEL | |||||
ReportingPeriod | E0934 | RPT_PERIOD | ReportingPeriod- | |||||
StudentUID | STU_UID | StudentUID-S_TX_STU_ATT_FLEX_CTE_C.STU_UID | ||||||
NumberDaysTaught | E0935 | DAYS_TAUGHT | NumberDaysTaught- | |||||
FlexAttendanceProgram | E1045 | FLEX_PROG | FlexAttendanceProgram- | |||||
FlexAttendTotalCTEMinPres | E1053 | FLEX_CTE_MIN_PRES | FlexAttendTotalCTEMinPres- | |||||
flexibleBilingualESLProgramReportingPeriodAttendancesTables: s_tx_stu_att_flex_bilesl_c attflexesl | ||||||||
CalendarCode | E0975 | CALENDAR_CODE | CalendarCode - s_tx_stu_att_flex_bilesl_c attflexesl. | |||||
GradeLevel | E0017 | GRADE_LEVEL | GradeLevel - | |||||
ReportingPeriod | E0934 | RPT_PERIOD | ReportingPeriod- | |||||
StudentUID | STU_UID | StudentUID- | ||||||
NumberDaysTaught | E0935 | DAYS_TAUGHT | NumberDaysTaught- | |||||
FlexAttendanceProgram | E1045 | FLEX_PROG | FlexAttendanceProgram- | |||||
BilingualESLFunding | E1651 | FLEX_BILESL_FUND | BilingualESLFunding- | |||||
FlexTotalEligBilESLDaysPres | E1050 | FLEX_BILESL_DAYS_PRES | FlexTotalEligBilESLDaysPres-s_tx_stu_att_flex_bilesl_c attflexesl. | |||||
flexibleSpecialEducationProgramReportingPeriodAttendancesTables: S_TX_STU_ATT_FLEX_SPED_C | ||||||||
CalendarCode | E0975 | CALENDAR_CODE | CalendarCode- | |||||
GradeLevel | E0017 | GRADE_LEVEL | GradeLevel-S_TX_STU_ATT_FLEX_SPED_C.E0017_GRADE_LEVEL | |||||
ReportingPeriod | E0934 | RPT_PERIOD | ReportingPeriod- | |||||
StudentUID | STU_UID | StudentUID-S_TX_STU_ATT_FLEX_SPED_C.STU_UID | ||||||
NumberDaysTaught | E0935 | DAYS_TAUGHT | NumberDaysTaught- | |||||
FlexAttendanceProgram | E1045 | FLEX_PROG | FlexAttendanceProgram- | |||||
FlexAttendDaysEligIns | E1051 | FLEX_SPD_IS_DAYS_PRES | FlexAttendDaysEligIns- | |||||
FlexAttendExcessMinInIns | E1052 | FLEX_SPD_IS_EXCS_MIN | FlexAttendExcessMinInIns- | |||||
flexibleRegularProgramReportingPeriodAttendancesTables: S_TX_STU_ATT_FLEX_C | ||||||||
CalendarCode | E0975 | CALENDAR_CODE | CalendarCode- | |||||
GradeLevel | E0017 | GRADE_LEVEL | GradeLevel-S_TX_STU_ATT_FLEX_C.E0017_GRADE_LEVEL | |||||
ReportingPeriod | E0934 | RPT_PERIOD | ReportingPeriod- | |||||
StudentUID | STU_UID | StudentUID-S_TX_STU_ATT_FLEX_C.STU_UID | ||||||
NumberDaysTaught | E0935 | DAYS_TAUGHT | NumberDaysTaught- | |||||
FlexAttendanceProgram | E1045 | FLEX_PROG | FlexAttendanceProgram- | |||||
FlexAttendTotalEligMinPres | E1046 | FLEX_SPD_IS_DAYS_PRES | FlexAttendDaysEligIns- | |||||
FlexAttendTotalIneligMinPres | E1047 | FLEX_SPD_IS_EXCS_MIN | FlexAttendExcessMinInIns- | |||||
FlexTotalEligPRSDaysPres | E1048 | FLEX_PRS_DAYS_PRES | FlexAttendExcessMinInIns- | |||||
FlexTotalEligRFTDaysPres | E1653 | FLEX_RFT_DAYS_PRES | FlexAttendExcessMinInIns- | |||||
FlexTotalEligSpEdMSDaysPres | E1049 | FLEX_MS_DAYS_PRES | FlexAttendExcessMinInIns- | |||||
bilingualESLProgramReportingPeriodAttendancesTables: S_TX_STU_ATT_BILESL_C | ||||||||
CalendarCode | E0975 | CALENDAR_CODE | CalendarCode-S_TX_STU_ATT_BILESL_C.E0975_CALENDAR_CODE | |||||
GradeLevel | E0017 | GRADE_LEVEL | GradeLevel-S_TX_STU_ATT_BILESL_C.E0017_GRADE_LEVEL | |||||
ReportingPeriod | E0934 | RPT_PERIOD | ReportingPeriod- | |||||
StudentUID | STU_UID | StudentUID-S_TX_STU_ATT_BILESL_C.STU_UID | ||||||
NumberDaysTaught | E0935 | DAYS_TAUGHT | NumberDaysTaught- | |||||
BilingualESLFunding | E1651 | BILESL_FUND | FlexAttendanceProgram- | |||||
RaTotalEligBilESLDaysPresent | E1683 | BILESL_RA_DAYS_PRES | FlexAttendDaysEligIns- | |||||
RsTotalEligBilESLDaysPresent | E1682 | BILESL_RS_DAYS_PRES | FlexAttendExcessMinInIns- | |||||
TotalEligBilESLDaysPresent | E0938 | BILESL_DAYS_PRES | FlexAttendExcessMinInIns- |