SB3 PowerSchool SIS Texas
Breadcrumbs

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