Publish Data (Categories and Resources)
This section includes the Ed-Fi resources that are published from PowerSchool to the state Ed-Fi Data ODS.
Ed-Fi Resources Published from PowerSchool to the State Ed-Fi Data ODS
Category | Entity | DEX Resource | eSP Download Dependency | TX Download Table |
|---|---|---|---|---|
Class Roster | Course | Course Catalog > Course | no | |
CourseOffering | Organization Schedules > Course Offering | no | ||
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
School | Organization Catalog > School | no | ||
Section | Organization Schedules > Section | no | ||
Staff | HR/ERP system (if eFP or BP, Staff Demographics > Staff) | N/A | ||
StaffSchoolAssociation | Staff Associations > Staff School | yes | TX_090 | |
StaffSectionAssociation | Staff Sections > Staff Section | yes | TX_090 | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSectionAssociation | Student Sections > Student Section | yes | TX_STU_PASSFAIL | |
Child Find | Calendar | Organization Calendars > School Calendar | no | |
CalendarDate | Organization Calendars > Calendar Date | no | ||
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
Program | Program Catalog > Program | no | ||
ReportingPeriodExt | Organization Calendars > Reporting Period | no | ||
School | Organization Catalog > School | no | ||
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationResponsibilityAssociation | Enrollment & Demographic > Responsible Organizations | no | ||
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for ESY Programs) | |
StudentSpecialEducationProgramEligibilityAssociation | Student Programs > Child Find | yes | TX_STUDENT_CHILD_FIND (only for student absences related to Child Find) | |
Summer | BasicReportingPeriodAttendance | Reporting Period Attendance > Basic | yes | TX_100, TX_400 |
BilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance > Bilingual ESL Program | yes | TX_100, TX_400 | |
Calendar | Organization Calendars > School Calendar | no | ||
CalendarDate | Organization Calendars > Calendar Date | no | ||
Course | Course Catalog > Course | no | ||
CourseOffering | Organization Schedules > Course Offering | no | ||
CourseTranscript | Student Transcripts > Student Course Transcript | yes | TX_STU_PASSFAIL | |
CTEProgramReportingPeriodAttendance | Reporting Period Attendance > CTE Program | yes | TX_100, TX_410 | |
DisciplineAction | Student Discipline > Discipline Action | no | ||
DisciplineIncident | Student Discipline > Discipline Incident | no | ||
FlexibleBilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Bilingual ESL Program - Flex | yes | TX_100, TX_500 | |
FlexibleCTEProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > CTE Program - Flex | yes | TX_100, TX_510 | |
FlexibleRegularProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Regular Program - Flex | yes | TX_100, TX_500 | |
FlexibleSpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Special Education Program - Flex | yes | TX_100, TX_505 | |
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
Program | Program Catalog > Program | no | ||
ReportingPeriodExt | Organization Calendars > Reporting Period | no | ||
RestraintEvent | Restraint Events > Restraint Events | no | ||
School | Organization Catalog > School | no | ||
Section | Organization Schedules > Section | no | ||
SpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance > Special Education Program | yes | TX_100, TX_405 | |
SpecialProgramsReportingPeriodAttendance | Reporting Period Attendance > Special Programs | yes | TX_100, TX_400 | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentAcademicRecord | Student Transcripts > Student Academic Records | yes | TX_STU_PASSFAIL | |
StudentCTEProgramAssociation | Student Programs > CTE | no | ||
StudentDisciplineIncidentBehaviorAssociation | Student Discipline > Student Discipline Incident Behavior | no | ||
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationResponsibilityAssociation | Enrollment & Demographic > Responsible Organizations | no | ||
StudentLanguageInstructionProgramAssociation | Student Programs > Language Instruction | no | ||
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSchoolAttendanceEvent | ||||
StudentSectionAssociation | Student Sections > Student Section | yes | TX_STU_PASSFAIL | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for ESY Programs) | |
StudentTitleIPartAProgramAssociation | Student Programs > Student Title I Part A Programs | no | ||
ECDS PK | Assessment | Assessment Vendor | N/A | |
Course | Course Catalog > Course | no | ||
CourseOffering | Organization Schedules > Course Offering | no | ||
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
ObjectiveAssessment | Assessment Vendor | N/A | ||
Program | Program Catalog > Program | no | ||
School | Organization Catalog > School | no | ||
Section | Organization Schedules > Section | no | ||
Staff | HR/ERP system (if eFP or BP, Staff Demographics > Staff) | N/A | ||
StaffSectionAssociation | Staff Sections > Staff Section | yes | TX_090 (for FALL Seat Count) | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentAssessment | Assessment Vendor | N/A | ||
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSectionAssociation | Student Sections > Student Section | yes | TX_STU_PASSFAIL (For SUMMER Course Completion) | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for ESY Programs) | |
SELA | LocalEducationAgency | Organization Catalog > Local Education Agency | no | |
Program | Program Catalog > Program | no | ||
School | Organization Catalog > School | no | ||
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for ESY Programs) | |
Extended Year | BasicReportingPeriodAttendance | Reporting Period Attendance > Basic | yes | TX_100, TX_400 |
BilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance > Bilingual ESL Program | yes | TX_100, TX_408 | |
Calendar | Organization Calendars > School Calendar | no | ||
CalendarDate | Organization Calendars > Calendar Date | no | ||
Course | Course Catalog > Course | no | ||
CourseOffering | Organization Schedules > Course Offering | no | ||
CourseTranscript Ext | Student Transcripts > Student Course Transcript | yes | TX_STU_PASSFAIL | |
ExtendedSchoolYearServicesAttendance | Reporting Period Attendance > Extended School Year | yes | TX_100, TX_400 | |
FlexibleBilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Bilingual ESL Program - Flex | yes | TX_100, TX_500 | |
FlexibleCTEProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > CTE Program - Flex | yes | TX_100, TX_510 | |
FlexibleRegularProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Regular Program - Flex | yes | TX_100, TX_500 | |
FlexibleSpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Special Education Program - Flex | yes | TX_100, TX_505 | |
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
Program | Program Catalog > Program | no | ||
ReportingPeriodExt | Organization Calendars > Reporting Period | no | ||
School | Organization Catalog > School | no | ||
Section | Organization Schedules > Section | no | ||
SpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance > Special Education Program | yes | TX_100, TX_405 | |
SpecialProgramsReportingPeriodAttendance | Reporting Period Attendance > Special Programs | yes | TX_100, TX_400 | |
Staff | HR/ERP system (if eFP or BP, Staff Demographics > Staff) | N/A | ||
StaffSectionAssociation | Staff Sections > Staff Section | yes | TX_090 (for FALL Seat Count) | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentAcademicRecord | Student Transcripts > Student Academic Records | yes | TX_STU_PASSFAIL | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentLanguageInstructionProgramAssociation | Student Programs > Language Instruction | no | ||
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSectionAssociation | Student Sections > Student Section | yes | TX_STU_PASSFAIL (For SUMMER Course Completion) | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for ESY Programs) | |
FALL Submission | BudgetExt | HR/ERP system (if eFP or BP, Accounts > Account Budgets) | N/A | |
ContractedInstructionalStaffFTEExt | HR/ERP system (if eFP or BP, Staff FTEs > Contracted Instructional FTEs) | N/A | ||
Course | Course Catalog > Course | no | ||
CourseOffering | Organization Schedules > Course Offering | no | ||
EducationServiceCenter | For ESC's only | N/A | ||
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
PayrollExt | HR/ERP system (if eFP or BP, Payroll > Payroll Transactions) | N/A | ||
PriorYearLeaver | Prior Year Leavers > Prior Year Leaver, Prior Year Contact, Prior Year Contact Relationship | yes | TX_100, TX_101, TX_203 (For FALL) | |
Program | Program Catalog > Program | no | ||
School | Organization Catalog > School | no | ||
Section | Organization Schedules > Section | no | ||
SSAOrgAssociationExt | Organization Catalog > SSA Organization Association | no | ||
Staff | HR/ERP system (if eFP or BP, Staff Demographics > Staff) | N/A | ||
StaffEducationOrganizationAssignmentAssociation | Staff Associations > Staff Assignment | yes | TX_090 (for FALL Seat Count) | |
StaffEducationOrganizationEmploymentAssociation | HR/ERP system (if eFP or BP, Staff Associations > Staff Employment) | N/A | ||
StaffSectionAssociation | Staff Sections > Staff Section | yes | TX_090 (for FALL Seat Count) | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentAcademicRecord | Student Transcripts > Student Academic Records | yes | TX_STU_PASSFAIL | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentLanguageInstructionProgramAssociation | Student Programs > Language Instruction | no | ||
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) | |
StudentSpecialEducationProgramAssociation | Student Programs > Special Education | yes | TX_408 (only for EXTENDED YEAR ESY Programs) | |
StudentTitleIPartAProgramAssociation | Student Programs > Student Title I Part A Programs | no | ||
PEIMS Attendance | BasicReportingPeriodAttendance | Reporting Period Attendance > Basic | yes | TX_100, TX_400 (Summer) |
BilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance > Bilingual ESL Program | yes | TX_100, TX_400 (Summer) | |
Calendar | Organization Calendars > School Calendar | no | ||
CalendarDate | Organization Calendars > Calendar Date | no | ||
CTEProgramReportingPeriodAttendance | Reporting Period Attendance > CTE Program | yes | TX_100, TX_410 (Summer) | |
FlexibleBilingualESLProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Bilingual ESL Program - Flex | yes | TX_100, TX_500 (Summer) | |
FlexibleCTEProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > CTE Program - Flex | yes | TX_100, TX_510 (Summer) | |
FlexibleRegularProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Regular Program - Flex | yes | TX_100, TX_500 (Summer) | |
FlexibleSpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance - Flex > Special Education Program - Flex | yes | TX_100, TX_102, TX_505 (Summer) | |
LocalEducationAgency | Organization Catalog > Local Education Agency | no | ||
ReportingPeriodExt | Organization Calendars > Reporting Period | no | ||
School | Organization Catalog > School | no | ||
SpecialEducationProgramReportingPeriodAttendance | Reporting Period Attendance > Special Education Program | yes | TX_100, TX_102, TX_405 (Summer) | |
SpecialProgramsReportingPeriodAttendance | Reporting Period Attendance > Special Programs | yes | TX_100, TX_400 (Summer) | |
Student | Student Identification > Student ID | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentEducationOrganizationAssociation | Enrollment & Demographic > Student Demographics | yes | TX_101 (for FALL and SUMMER As Of Status) | |
StudentSchoolAssociation | Enrollment & Demographic > School Enrollment | yes | TX_STUDENT_TRUANCY (only for SUMMER Truancy values) |