Skip to main content
Skip table of contents

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:

  1. 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.

  2. Daily Attendance: This tracks whether a student is present or absent for the entire school day.

  3. Class Period Attendance: This tracks attendance for each class period throughout the school day.

  4. 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

studentSchoolAttendanceEvents

Primary PowerSchool Source Data

Tables: ATTENDANCE (att), ATTENDANCE_CODE (ac), CALENDAR_DAY (cd), BELL_SCHEDULE_ITEMS (bsi), S_TX_BSI_X (bsix)
Also uses Ed-Fi code download and mapping tables, attendance calculation temporary tables

Selection Criteria

Publish for all enrolled students where student and/or school not excluded from publishing. 
Different from other states: ignore conversions and attendance views

  • Based on attendance during a single period, designated as Official Attendance Period or Counts for ADA

  • Check for Official Attendance Period first, if none checked, the check for Counts for ADA.

  • If more than one period is Official Attendance or Counts for ADA, any one student should not be scheduled in both

  • That would be a data error and there is a PEIMS Error Check for it.

  • If student takes section at another school during reporting class period, CC record has Remote ADA Period Class flag

  • cc record is for section at remote school

  • s_tx_cc_x.remote_ada_class = 1

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
TX attendanceEventCategoryDescriptor codes:
    1 - State reported absent at official attendance time
    Usage for codes 2 - 11 TBD

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
session 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 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

studentSectionAttendanceEvents

Primary PowerSchool Source Data

Tables

ATTENDANCE (att), ATTENDANCE_CODE (ac), Sections (sec), CC
Also uses Ed-Fi code download and mapping tables, attendance calculation temporary tables

Requested for TX Exchange, not collected by TEA; publish per Base Profile (except use TX section identifier)


Selection Criteria

Publish for all enrolled students and sections not excluded from reporting or Ed-Fi. 
Section attendance is published from school where section was taken, which may be different from enrolled school.

Resource Output

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

basicReportingPeriodAttendance

Table-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

specialProgramsReportingPeriodAttendance

Table-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

specialEducationProgramReportingPeriodAttendance

Table-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

cteProgramReportingPeriodAttendance

Table-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

extendedSchoolYearServicesAttendance

Tables: S_TX_STU_ESY_C

Selection Criteria:
PEIMS Extended Year Students can have hours for one or two instructional settings.  In current reporting, we collect the Instructional Setting for each set of hours.

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

flexibleCTEProgramReportingPeriodAttendances

Tables: S_TX_STU_ATT_FLEX_CTE_C

CalendarCode

E0975

CALENDAR_CODE

CalendarCode-
S_TX_STU_ATT_FLEX_CTE_C.E0975_CALENDAR_CODE

GradeLevel

E0017

GRADE_LEVEL

GradeLevel-S_TX_STU_ATT_FLEX_CTE_C.E0017_GRADE_LEVEL

ReportingPeriod

E0934

RPT_PERIOD

ReportingPeriod-
S_TX_STU_ATT_FLEX_CTE_C.E0934_RPT_PERIOD

StudentUID

STU_UID

StudentUID-S_TX_STU_ATT_FLEX_CTE_C.STU_UID

NumberDaysTaught

E0935

DAYS_TAUGHT

NumberDaysTaught-
S_TX_STU_ATT_FLEX_CTE_C.E0935_DAYS_TAUGHT

FlexAttendanceProgram

E1045

FLEX_PROG

FlexAttendanceProgram-
S_TX_STU_ATT_FLEX_CTE_C.E1045_FLEX_PROG

FlexAttendTotalCTEMinPres

E1053

FLEX_CTE_MIN_PRES

FlexAttendTotalCTEMinPres-
S_TX_STU_ATT_FLEX_CTE_C.E1053_FLEX_CTE_MIN_PRES

flexibleBilingualESLProgramReportingPeriodAttendances

Tables: s_tx_stu_att_flex_bilesl_c attflexesl

CalendarCode

E0975

CALENDAR_CODE

CalendarCode - s_tx_stu_att_flex_bilesl_c attflexesl.
E0975_CALENDAR_CODE

GradeLevel

E0017

GRADE_LEVEL

GradeLevel -
s_tx_stu_att_flex_bilesl_c attflexesl.
E0017_GRADE_LEVEL

ReportingPeriod

E0934

RPT_PERIOD

ReportingPeriod-
s_tx_stu_att_flex_bilesl_c attflexesl.
E0934_RPT_PERIOD

StudentUID

STU_UID

StudentUID-
s_tx_stu_att_flex_bilesl_c attflexesl.
STU_UID

NumberDaysTaught

E0935

DAYS_TAUGHT

NumberDaysTaught-
s_tx_stu_att_flex_bilesl_c attflexesl.
E0935_DAYS_TAUGHT

FlexAttendanceProgram

E1045

FLEX_PROG

FlexAttendanceProgram-
s_tx_stu_att_flex_bilesl_c attflexesl.
E1045_FLEX_PROG

BilingualESLFunding

E1651

FLEX_BILESL_FUND

BilingualESLFunding-
s_tx_stu_att_flex_bilesl_c attflexesl.
E1651_FLEX_BILESL_FUND

FlexTotalEligBilESLDaysPres

E1050

FLEX_BILESL_DAYS_PRES

FlexTotalEligBilESLDaysPres-s_tx_stu_att_flex_bilesl_c attflexesl.
E1050_FLEX_BILESL_DAYS_PRES

flexibleSpecialEducationProgramReportingPeriodAttendances

Tables: S_TX_STU_ATT_FLEX_SPED_C

CalendarCode

E0975

CALENDAR_CODE

CalendarCode-
S_TX_STU_ATT_FLEX_SPED_C .E0975_CALENDAR_CODE

GradeLevel

E0017

GRADE_LEVEL

GradeLevel-S_TX_STU_ATT_FLEX_SPED_C.E0017_GRADE_LEVEL

ReportingPeriod

E0934

RPT_PERIOD

ReportingPeriod-
S_TX_STU_ATT_FLEX_SPED_C.E0934_RPT_PERIOD

StudentUID

STU_UID

StudentUID-S_TX_STU_ATT_FLEX_SPED_C.STU_UID

NumberDaysTaught

E0935

DAYS_TAUGHT

NumberDaysTaught-
S_TX_STU_ATT_FLEX_SPED_C.E0935_DAYS_TAUGHT

FlexAttendanceProgram

E1045

FLEX_PROG

FlexAttendanceProgram-
S_TX_STU_ATT_FLEX_SPED_C .E1045_FLEX_PROG

FlexAttendDaysEligIns

E1051

FLEX_SPD_IS_DAYS_PRES

FlexAttendDaysEligIns-
S_TX_STU_ATT_FLEX_SPED_CC.E1073_FLEX_SPED_IS

FlexAttendExcessMinInIns

E1052

FLEX_SPD_IS_EXCS_MIN

FlexAttendExcessMinInIns-
S_TX_STU_ATT_FLEX_SPED_C.E1052FLEX_SPD_IS_EXCS_MIN

flexibleRegularProgramReportingPeriodAttendances

Tables: S_TX_STU_ATT_FLEX_C

CalendarCode

E0975

CALENDAR_CODE

CalendarCode-
S_TX_STU_ATT_FLEX_C .E0975_CALENDAR_CODE

GradeLevel

E0017

GRADE_LEVEL

GradeLevel-S_TX_STU_ATT_FLEX_C.E0017_GRADE_LEVEL

ReportingPeriod

E0934

RPT_PERIOD

ReportingPeriod-
S_TX_STU_ATT_FLEX_C.E0934_RPT_PERIOD

StudentUID

STU_UID

StudentUID-S_TX_STU_ATT_FLEX_C.STU_UID

NumberDaysTaught

E0935

DAYS_TAUGHT

NumberDaysTaught-
S_TX_STU_ATT_FLEX_C.E0935_DAYS_TAUGHT

FlexAttendanceProgram

E1045

FLEX_PROG

FlexAttendanceProgram-
S_TX_STU_ATT_FLEX_C .E1045_FLEX_PROG

FlexAttendTotalEligMinPres

E1046

FLEX_SPD_IS_DAYS_PRES

FlexAttendDaysEligIns-
S_TX_STU_ATT_FLEX_C.E1046_FLEX_ELIG_MIN_PRES

FlexAttendTotalIneligMinPres

E1047

FLEX_SPD_IS_EXCS_MIN

FlexAttendExcessMinInIns-
S_TX_STU_ATT_FLEX_C.E1047_FLEX_INELIG_MIN_PRES

FlexTotalEligPRSDaysPres

E1048

FLEX_PRS_DAYS_PRES

FlexAttendExcessMinInIns-
S_TX_STU_ATT_FLEX_C.E1048_FLEX_PRS_DAYS_PRES

FlexTotalEligRFTDaysPres

E1653

FLEX_RFT_DAYS_PRES

FlexAttendExcessMinInIns-
S_TX_STU_ATT_FLEX_C.E1653_FLEX_RFT_DAYS_PRES

FlexTotalEligSpEdMSDaysPres

E1049

FLEX_MS_DAYS_PRES

FlexAttendExcessMinInIns-
S_TX_STU_ATT_FLEX_C.E1049_FLEX_MS_DAYS_PRES

bilingualESLProgramReportingPeriodAttendances

Tables: 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-
S_TX_STU_ATT_BILESL_C.E0934_RPT_PERIOD

StudentUID

STU_UID

StudentUID-S_TX_STU_ATT_BILESL_C.STU_UID

NumberDaysTaught

E0935

DAYS_TAUGHT

NumberDaysTaught-
S_TX_STU_ATT_BILESL_C.E0935_DAYS_TAUGHT

BilingualESLFunding

E1651

BILESL_FUND

FlexAttendanceProgram-
S_TX_STU_ATT_BILESL_C.E1651_BILESL_FUND

RaTotalEligBilESLDaysPresent

E1683

BILESL_RA_DAYS_PRES

FlexAttendDaysEligIns-
S_TX_STU_ATT_BILESL_C.E1683_BILESL_RA_DAYS_PRES

RsTotalEligBilESLDaysPresent

E1682

BILESL_RS_DAYS_PRES

FlexAttendExcessMinInIns-
S_TX_STU_ATT_BILESL_C.E1682_BILESL_RS_DAYS_PRES

TotalEligBilESLDaysPresent

E0938

BILESL_DAYS_PRES

FlexAttendExcessMinInIns-
S_TX_STU_ATT_BILESL_C.E0938_BILESL_DAYS_PRES

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.