This version of the Ed-Fi ODS / API is no longer supported. See the Ed-Fi Technology Version Index for a link to the latest version.
Key Structure in the Ed-Fi ODS / API
Unified Keys in the As-Shipped Ed-Fi ODS
Running the SQL Query above on the as-shipped ODS data store results in the following report:
FOREIGN_TABLE_NAME | FOREIGN_COLUMN_NAME | PRIMARY_TABLE_NAME | CONSTRAINT_NAME |
---|---|---|---|
AcademicWeek | SchoolId | CalendarDate | FK_AcademicWeek_CalendarDate_BeginDate |
AcademicWeek | SchoolId | CalendarDate | FK_AcademicWeek_CalendarDate_EndDate |
AcademicWeek | SchoolId | School | FK_AcademicWeek_School_SchoolId |
BellScheduleMeetingTime | SchoolId | BellSchedule | FK_BellScheduleMeetingTime_BellSchedule |
BellScheduleMeetingTime | SchoolId | ClassPeriod | FK_BellScheduleMeetingTime_ClassPeriod |
CourseOffering | SchoolId | School | FK_CourseOffering_School_SchoolId |
CourseOffering | SchoolId | Session | FK_CourseOffering_Session_SchoolId |
Grade | SchoolId | GradingPeriod | FK_Grade_GradingPeriod_BeginDate |
Grade | SchoolId | StudentSectionAssociation | FK_Grade_StudentSectionAssociation |
GradebookEntry | SchoolId | GradingPeriod | FK_GradebookEntry_GradingPeriod |
GradebookEntry | SchoolId | Section | FK_GradebookEntry_Section_SchoolId |
ObjectiveAssessment | AcademicSubjectDescriptorId | Assessment | FK_ObjectiveAssessment_Assessment_AssessmentTitle |
ObjectiveAssessment | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment |
ObjectiveAssessment | AssessedGradeLevelDescriptorId | Assessment | FK_ObjectiveAssessment_Assessment_AssessmentTitle |
ObjectiveAssessment | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment |
ObjectiveAssessment | AssessmentTitle | Assessment | FK_ObjectiveAssessment_Assessment_AssessmentTitle |
ObjectiveAssessment | AssessmentTitle | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment |
ObjectiveAssessment | Version | Assessment | FK_ObjectiveAssessment_Assessment_AssessmentTitle |
ObjectiveAssessment | Version | ObjectiveAssessment | FK_ObjectiveAssessment_ObjectiveAssessment |
ObjectiveAssessmentAssessmentItem | AcademicSubjectDescriptorId | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem |
ObjectiveAssessmentAssessmentItem | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment |
ObjectiveAssessmentAssessmentItem | AssessedGradeLevelDescriptorId | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem |
ObjectiveAssessmentAssessmentItem | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment |
ObjectiveAssessmentAssessmentItem | AssessmentTitle | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem |
ObjectiveAssessmentAssessmentItem | AssessmentTitle | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment |
ObjectiveAssessmentAssessmentItem | Version | AssessmentItem | FK_ObjectiveAssessmentAssessmentItem_AssessmentItem |
ObjectiveAssessmentAssessmentItem | Version | ObjectiveAssessment | FK_ObjectiveAssessmentAssessmentItem_ObjectiveAssessment |
ObjectiveAssessmentLearningObjective | AcademicSubjectDescriptorId | LearningObjective | FK_ObjectiveAssessmentLearningObjective_LearningObjective_Objective |
ObjectiveAssessmentLearningObjective | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentLearningObjective_ObjectiveAssessment |
ObjectiveAssessmentLearningObjective | AssessedGradeLevelDescriptorId | LearningObjective | FK_ObjectiveAssessmentLearningObjective_LearningObjective_Objective |
ObjectiveAssessmentLearningObjective | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_ObjectiveAssessmentLearningObjective_ObjectiveAssessment |
ReportCardGrade | GradingPeriodBeginDate | Grade | FK_ReportCardGrade_Grade |
ReportCardGrade | GradingPeriodBeginDate | ReportCard | FK_ReportCardGrade_ReportCard_SchoolId |
ReportCardGrade | GradingPeriodDescriptorId | Grade | FK_ReportCardGrade_Grade |
ReportCardGrade | GradingPeriodDescriptorId | ReportCard | FK_ReportCardGrade_ReportCard_SchoolId |
ReportCardGrade | SchoolId | Grade | FK_ReportCardGrade_Grade |
ReportCardGrade | SchoolId | ReportCard | FK_ReportCardGrade_ReportCard_SchoolId |
ReportCardGrade | StudentUSI | Grade | FK_ReportCardGrade_Grade |
ReportCardGrade | StudentUSI | ReportCard | FK_ReportCardGrade_ReportCard_SchoolId |
ReportCardStudentCompetencyObjective | GradingPeriodBeginDate | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard_StudentUSI |
ReportCardStudentCompetencyObjective | GradingPeriodBeginDate | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective_StudentUSI |
ReportCardStudentCompetencyObjective | GradingPeriodDescriptorId | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard_StudentUSI |
ReportCardStudentCompetencyObjective | GradingPeriodDescriptorId | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective_StudentUSI |
ReportCardStudentCompetencyObjective | SchoolId | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard_StudentUSI |
ReportCardStudentCompetencyObjective | SchoolId | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective_StudentUSI |
ReportCardStudentCompetencyObjective | StudentUSI | ReportCard | FK_ReportCardStudentCompetencyObjective_ReportCard_StudentUSI |
ReportCardStudentCompetencyObjective | StudentUSI | StudentCompetencyObjective | FK_ReportCardStudentCompetencyObjective_StudentCompetencyObjective_StudentUSI |
ReportCardStudentLearningObjective | GradingPeriodBeginDate | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard |
ReportCardStudentLearningObjective | GradingPeriodBeginDate | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective_StudentUSI |
ReportCardStudentLearningObjective | GradingPeriodDescriptorId | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard |
ReportCardStudentLearningObjective | GradingPeriodDescriptorId | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective_StudentUSI |
ReportCardStudentLearningObjective | SchoolId | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard |
ReportCardStudentLearningObjective | SchoolId | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective_StudentUSI |
ReportCardStudentLearningObjective | StudentUSI | ReportCard | FK_ReportCardStudentLearningObjective_ReportCard |
ReportCardStudentLearningObjective | StudentUSI | StudentLearningObjective | FK_ReportCardStudentLearningObjective_StudentLearningObjective_StudentUSI |
Section | SchoolId | ClassPeriod | FK_Section_ClassPeriod_SchoolId |
Section | SchoolId | CourseOffering | FK_Section_CourseOffering_SchoolId |
Section | SchoolId | Location | FK_Section_Location_SchoolId |
Section | SchoolId | School | FK_Section_School_SchoolId |
SectionAttendanceTakenEvent | SchoolId | Section | FK_SectionAttendanceTakeEvent_Section_SchoolId |
SectionAttendanceTakenEvent | SchoolId | CalendarDate | FK_SectionAttendanceTakenEvent_CalendarDate_SchoolId |
SessionAcademicWeek | SchoolId | AcademicWeek | FK_AcademicWeek_Session_SchoolId |
SessionAcademicWeek | SchoolId | Session | FK_SessionAcademicWeek_Session_SchoolId |
SessionGradingPeriod | SchoolId | GradingPeriod | FK_SessionGradingPeriod_GradingPeriod_SchoolId |
SessionGradingPeriod | SchoolId | Session | FK_SessionGradingPeriod_Session_SchoolId |
StaffEducationOrganization-AssignmentAssociation | StaffUSI | StaffEducationOrganization-EmploymentAssociation | FK_StaffEducationOrganizationAssignmentAssociation |
StaffEducationOrganization-AssignmentAssociation | StaffUSI | Staff | FK_StaffEducationOrgAssignmentAssociation_Staff_StaffUSI |
StudentAcademicRecordReportCard | EducationOrganizationId | ReportCard | FK_StudentAcademicRecordReportCard_ReportCard |
StudentAcademicRecordReportCard | EducationOrganizationId | StudentAcademicRecord | FK_StudentAcademicRecordReportCard_StudentAcademicRecord_StudentUSI |
StudentAcademicRecordReportCard | StudentUSI | ReportCard | FK_StudentAcademicRecordReportCard_ReportCard |
StudentAcademicRecordReportCard | StudentUSI | StudentAcademicRecord | FK_StudentAcademicRecordReportCard_StudentAcademicRecord_StudentUSI |
StudentAssessmentItem | AcademicSubjectDescriptorId | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem |
StudentAssessmentItem | AcademicSubjectDescriptorId | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment_StudentUSI |
StudentAssessmentItem | AssessedGradeLevelDescriptorId | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem |
StudentAssessmentItem | AssessedGradeLevelDescriptorId | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment_StudentUSI |
StudentAssessmentItem | AssessmentTitle | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem |
StudentAssessmentItem | AssessmentTitle | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment_StudentUSI |
StudentAssessmentItem | Version | AssessmentItem | FK_StudentAssessmentItem_AssessmentItem |
StudentAssessmentItem | Version | StudentAssessment | FK_StudentAssessmentItem_StudentAssessment_StudentUSI |
StudentAssessmentStudentObjectiveAssessment | AcademicSubjectDescriptorId | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment |
StudentAssessmentStudentObjectiveAssessment | AcademicSubjectDescriptorId | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment_StudentUSI |
StudentAssessmentStudentObjectiveAssessment | AssessedGradeLevelDescriptorId | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment |
StudentAssessmentStudentObjectiveAssessment | AssessedGradeLevelDescriptorId | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment_StudentUSI |
StudentAssessmentStudentObjectiveAssessment | AssessmentTitle | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment |
StudentAssessmentStudentObjectiveAssessment | AssessmentTitle | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment_StudentUSI |
StudentAssessmentStudentObjectiveAssessment | Version | ObjectiveAssessment | FK_StudentAssessmentStudentObjectiveAssessment_ObjectiveAssessment |
StudentAssessmentStudentObjectiveAssessment | Version | StudentAssessment | FK_StudentAssessmentStudentObjectiveAssessment_StudentAssessment_StudentUSI |
StudentCompetencyObjective | BeginDate | StudentProgramAssociation | FK_StudentCompetencyObjective_StudentProgramAssociation |
StudentCompetencyObjective | BeginDate | StudentSectionAssociation | FK_StudentCompetencyObjective_StudentSectionAssociation |
StudentCompetencyObjective | SchoolId | GradingPeriod | FK_StudentCompetencyObjective_GradingPeriod |
StudentCompetencyObjective | SchoolId | StudentSectionAssociation | FK_StudentCompetencyObjective_StudentSectionAssociation |
StudentCompetencyObjective | StudentUSI | Student | FK_StudentCompetencyObjective_Student_StudentUSI |
StudentCompetencyObjective | StudentUSI | StudentProgramAssociation | FK_StudentCompetencyObjective_StudentProgramAssociation |
StudentCompetencyObjective | StudentUSI | StudentSectionAssociation | FK_StudentCompetencyObjective_StudentSectionAssociation |
StudentGradebookEntry | ClassPeriodName | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | ClassPeriodName | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | ClassroomIdentificationCode | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | ClassroomIdentificationCode | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | LocalCourseCode | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | LocalCourseCode | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | SchoolId | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | SchoolId | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | SchoolYear | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | SchoolYear | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | SequenceOfCourse | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | SequenceOfCourse | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | TermDescriptorId | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | TermDescriptorId | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentGradebookEntry | UniqueSectionCode | GradebookEntry | FK_StudentGradebookEntry_GradebookEntry_SchoolId |
StudentGradebookEntry | UniqueSectionCode | StudentSectionAssociation | FK_StudentGradebookEntry_StudentSectionAssociation_StudentUSI |
StudentLearningObjective | SchoolId | GradingPeriod | FK_StudentLearningObjective_GradingPeriod_SchoolId |
StudentLearningObjective | SchoolId | StudentSectionAssociation | FK_StudentLearningObjective_StudentSectionAssociation_StudentUSI |
StudentLearningObjective | StudentUSI | Student | FK_StudentLearningObjective_Student_StudentUSI |
StudentLearningObjective | StudentUSI | StudentProgramAssociation | FK_StudentLearningObjective_StudentProgramAssociation |
StudentLearningObjective | StudentUSI | StudentSectionAssociation | FK_StudentLearningObjective_StudentSectionAssociation_StudentUSI |
StudentSchoolAttendanceEvent | SchoolId | School | FK_StudentSchoolAttendanceEvent_School_SchoolId |
StudentSchoolAttendanceEvent | SchoolId | Session | FK_StudentSchoolAttendanceEvent_Session_SchoolId |