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