Data Domains and Key Tables#

This page gives a quick, domain-by-domain overview of the data available in a typical EDU warehouse and the main tables that hold it. The list below is derived from the edu_wh core_warehouse models. Use it to see what’s covered, decide which domain you need, and find the right tables before you write a query.

Implementation-specific

Exact table names and availability can vary by implementation. For the authoritative list and column details for your warehouse, use your site’s dbt Docs. This page is a general guide.

Core dimensions (used across domains)#

These dimensions are shared across many domains. You’ll often join to them no matter which domain you’re querying.

Table	Purpose
`dim_student`	Student demographics and attributes (annualized; use `k_student` or `k_student_xyear` as needed)
`dim_school`	School identifiers and attributes
`dim_lea`	Local Education Agency (district/LEA) identifiers and attributes
`dim_esc`	Education Service Center (ESC) identifiers and attributes
`dim_network`	Network (e.g., CMO) identifiers and attributes
`dim_calendar_date`	Calendar dates, school year, day of week, `is_school_day`, etc.
`dim_staff`	Staff and educator information
`dim_program`	Program definitions (e.g., special education, ELL); often joined on `k_program` and `k_school`
`dim_session`	Session/term (e.g., fall, spring)
`dim_grading_period`	Grading period definitions
`dim_school_calendar`	School calendar and calendar windows
`dim_parent`	Parent/contact information

Attendance#

What’s covered: Daily attendance events, section-level attendance, presence/absence, enrollment days, and pre-aggregated attendance measures.

Table	Type	Purpose
`fct_student_daily_attendance`	Fact	One row per student per day (per school/session); `is_present`, `is_absent`, `is_enrolled`
`fct_student_school_attendance_event`	Fact	School-level attendance events
`fct_student_section_attendance_event`	Fact	Section/class-level attendance events
`msr_student_cumulative_attendance`	Measure	Pre-aggregated attendance (e.g., attendance rate, chronic absentee) at student/school/year grain
`dim_calendar_date`	Dimension	Join for date, school year, day of week, `is_school_day`

See also: Attendance Query Guide for more detail.

Assessment#

What’s covered: Student assessment events, overall and sub-scores (e.g., subject or objective-level).

Table	Type	Purpose
`fct_student_assessment`	Fact	Student-level assessment events; scale scores, administration date, grade at time of assessment
`fct_student_objective_assessment`	Fact	Sub-scores / objective-level results linked to a student assessment event
`dim_assessment`	Dimension	Assessment metadata (title, family, subject, identifier)
`dim_objective_assessment`	Dimension	Objective/sub-assessment metadata

See also: Assessment Query Guide for more detail.

Student Demographics and subgroups#

What’s covered: Student demographics (in dim_student) and subgroup membership.

Table	Type	Purpose
`dim_student`	Dimension	Many demographic and subgroup columns (e.g., race/ethnicity, grade level, ELL/special ed indicators)
`fct_student_subgroup`	Fact	Subgroup membership where used
`dim_subgroup`	Dimension	Subgroup definitions

See also: Demographics Query Guide for point-in-time and longitudinal patterns.

Enrollment#

What’s covered: Student enrollment and membership at school level.

Table	Type	Purpose
`fct_student_school_association`	Fact	Student–school association; entry/exit dates, grade level, membership (grain: student, school, entry date)
`dim_school`	Dimension	School identifiers and names
`dim_lea`	Dimension	LEA/district for roll-ups
`dim_student`	Dimension	Student demographics for the enrollment year

Courses, sections, and grades#

What’s covered: Course and section definitions, student enrollment in sections, grades, and transcripts.

Table	Type	Purpose
`fct_student_section_association`	Fact	Student enrollment in a course section; begin/end dates, homeroom flag (grain: student, course section, begin date)
`fct_student_grades`	Fact	Student grades (e.g., final grade, grade type) by course/section
`fct_student_learning_standard_grades`	Fact	Grades or performance against learning standards
`fct_course_transcripts`	Fact	Course transcript records
`dim_course`	Dimension	Course definitions (code, title, subject)
`dim_course_section`	Dimension	Course section (course + section identifier, school, session, etc.)
`dim_class_period`	Dimension	Class period (e.g., period 1, 2)
`dim_classroom`	Dimension	Classroom/location
`dim_grading_period`	Dimension	Grading period for grade reporting
`dim_session`	Dimension	Session/term
`brg_course_section_program`	Bridge	Links course sections to programs

Programs#

What’s covered: Program enrollment (generic and program-specific). Many implementations use a subset of these; program data may be sparse.

Table	Type	Purpose
`fct_student_program_association`	Fact	Student enrollment in programs; begin/end dates (generic)
`fct_student_special_education_program_association`	Fact	Special education program enrollment
`fct_student_language_instruction_program_association`	Fact	Language instruction / ELL program enrollment
`fct_student_title_i_part_a_program_association`	Fact	Title I Part A program association
`fct_student_homeless_program_association`	Fact	Homeless program association
`fct_student_migrant_education_program_associations`	Fact	Migrant education program
`fct_student_cte_program_associations`	Fact	Career and technical education (CTE) program
`fct_student_school_food_service_program_associations`	Fact	School food service program
`fct_student_program_service`	Fact	Program services received by students
`dim_program`	Dimension	Program names and types; often joined on `k_program` and `k_school`

Discipline#

What’s covered: Discipline incidents, behaviors, and actions.

Table	Type	Purpose
`fct_student_discipline_actions`	Fact	Discipline actions applied to students (per incident/event)
`fct_student_discipline_actions_summary`	Fact	Summary of discipline actions
`fct_student_discipline_incident_summary`	Fact	Summary of discipline incidents
`fct_student_discipline_incident_behaviors`	Fact	Behaviors associated with discipline incidents
`fct_student_discipline_incident_non_offenders`	Fact	Non-offender associations to incidents
`dim_discipline_incident`	Dimension	Discipline incident details (school, date, etc.)

Staff and staffing#

What’s covered: Staff assignments to schools and sections.

Table	Type	Purpose
`fct_staff_school_association`	Fact	Staff assignment to a school (e.g., role, grade levels, subjects)
`fct_staff_section_association`	Fact	Staff assignment to course sections (e.g., teacher of record)
`dim_staff`	Dimension	Staff identifiers and attributes

Academic records, GPA, diploma, and cohort#

What’s covered: Academic records, GPA, diplomas, and cohort membership.

Table	Type	Purpose
`fct_student_academic_record`	Fact	Student academic record (e.g., term-level record; links to diploma)
`fct_student_gpa`	Fact	Student GPA (e.g., by term or cumulative)
`fct_student_diploma`	Fact	Diploma awards
`fct_student_cohort_association`	Fact	Student membership in a cohort (e.g., graduation cohort)
`dim_cohort`	Dimension	Cohort definitions (e.g., graduation year)
`dim_graduation_plan`	Dimension	Graduation plan types

Parents and contacts#

What’s covered: Student–parent/contact associations.

Table	Type	Purpose
`fct_student_parent_association`	Fact	Student–parent/contact relationship (e.g., primary contact, living with)
`dim_parent`	Dimension	Parent/contact identifiers and attributes

Learning standards#

What’s covered: Learning standard definitions (e.g., state standards). Grade/performance data may live in fct_student_learning_standard_grades.

Table	Type	Purpose
`dim_learning_standard`	Dimension	Learning standard identifiers and attributes

TPDM (Teacher Preparation Data Model)#

What’s covered: Educator preparation programs, candidates (teacher candidates), and their enrollment and staff relationships. Based on the Ed-Fi TPDM/EPDM. These models live in the tpdm_warehouse layer and are optional—enabled only when edu:tpdm:enabled is true for your implementation.

Table	Type	Purpose
`dim_candidate`	Dimension	Educator candidate (person enrolled in an educator preparation program)
`dim_educator_preparation_program`	Dimension	Educator preparation program definitions
`fct_candidate_educator_preparation_program_association`	Fact	Candidate enrollment in an educator preparation program (enrollment dates, pathway, completion)
`fct_candidate_staff_association`	Fact	Candidate relationship to staff (e.g., mentor, supervisor)

TPDM availability

TPDM tables are not built unless your deployment enables them. Check dbt Docs or your project’s edu:tpdm:enabled setting to see if this domain is available.

Next steps#

Use dbt Docs for your implementation to confirm table names, columns, and grains.
For step-by-step query building (purpose → tables → columns → joins/aggregates → check), see Writing Queries with EDU in Getting Started.