Skip to content

Assessment Fact

Table Overview

This table contains 48 columns.

Quick Navigation

Column Definitions

ACADEMIC_SESSION_GROUP_KEY

Business Definition

Foreign key to ACADEMIC_SESSION_GROUP_DIM that anchors each attempt to a school-year or term grouping (for example, 2025–2026, Fall). Analysts use this key to trend performance by academic periods and align results to district calendars. Values of -1 or null indicate attempts that could not be aligned to a defined session group.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ALLOW_EXTENDED_DOWNWARD_PLACEMENT

Business Definition

Flag indicating whether benchmark placement logic allowed a broader downward placement range for this attempt. This is used in benchmark scenarios where policies permit placing a student below their typical level to ensure appropriate instructional match. Null or false values indicate standard placement rules were applied.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

APP_DOMAIN_KEY

Business Definition

Foreign key to APP_DOMAIN_DIM that classifies the assessment into a harmonized domain or subject (for example, Reading, Math, Science). This key is used for subject-level rollups and cross-application comparisons. A value of -1 denotes an unknown or unmapped domain.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

APPLICATION_KEY

Business Definition

Foreign key to APPLICATION_DIM identifying the curriculum or application that originated the assessment (for example, CAT, NWEA, Renaissance). This enables platform-level segmentation and controls how scores are interpreted. A value of -1 indicates the source application could not be resolved.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_COMPLETED_ON

Business Definition

Timestamp or date the student finished the assessment. This is used for recency metrics, SLA calculations, and determining eligibility for reporting windows. Null implies the attempt never reached a completed state.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_COMPLETED_ON_KEY

Business Definition

Surrogate date key representing when the student completed the assessment attempt, optimized for joins to date dimensions and partitioning. Use this key for calendar aggregations and reporting filters. Null indicates the attempt was not completed (for example, still in progress or expired).

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_EXPIRED_ON

Business Definition

Timestamp or date the attempt expired due to time or window constraints. This supports operational monitoring of test administration and detecting student disengagement. Typically null for completed or graded attempts.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_EXPIRED_ON_KEY

Business Definition

Surrogate date key representing when the assessment attempt expired without completion. Use this key to analyze timeouts and window-compliance behavior. Often null for attempts that were completed or reset before expiry.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_GRADED_ON

Business Definition

Timestamp or date when final grading was posted. Use this field to measure time-to-grade and to trigger downstream workflows that depend on final scores. Null for assessments that are auto-scored at completion or where grading is not applicable.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_GRADED_ON_KEY

Business Definition

Surrogate date key representing when grading was finalized (system or human). It facilitates computing grading latency and joining to date dimensions. Null indicates the attempt has not been graded or grading does not apply.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_ID

Business Definition

Natural identifier for a specific assessment attempt provided by the source platform (for example, Learnosity session ID or NWEA test result ID). Analysts use this value to trace lineage back to source logs and vendor systems. Format and cardinality vary by platform.

Data Type

VARCHAR

Nullable

No

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_ID_ASSESSMENT_KEY

Business Definition

Composite surrogate identifier combining the natural assessment attempt ID with the assessment definition key to guarantee uniqueness across platforms and reloads. Use this as the primary join key to de-duplicate records and stabilize references over time.

Data Type

VARCHAR

Nullable

No

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_ITEMS_COUNT

Business Definition

Total number of items included on the assessment form for this attempt. This is used with attempted, correct, and skipped counts to compute completion and accuracy rates. Values may vary by form, window, or student routing in adaptive tests.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_KEY

Business Definition

Foreign key to ASSESSMENT_DIM that represents the assessment definition (type, name, subject, and source). This key enables grouping attempts into consistent definitions across feeds. A value of -1 indicates the attempt could not be mapped to a known definition.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_NAME

Business Definition

Human-readable name for the assessment instance derived from ASSESSMENT_DIM or the source system. Intended for reporting labels and user interfaces rather than joins. Names may differ across platforms and over time.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_RESET_ON

Business Definition

Timestamp or date when the attempt was reset by a user or policy, invalidating some or all prior work. Use this to identify re-takes and to exclude pre-reset activity from performance metrics where required. Null indicates no reset occurred.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_STARTED_ON

Business Definition

Timestamp or date when the student first engaged with the assessment. Commonly used to calculate time-on-assessment and to align attempts to instructional windows. Null indicates the attempt was scheduled or created but never started.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_STARTED_ON_KEY

Business Definition

Surrogate date key representing when the student began the assessment attempt. Use for calendar-based aggregations and cohort analyses. Present for most attempts except those created administratively without a start event.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ASSESSMENT_STATUS

Business Definition

Lifecycle status for the attempt such as STARTED, COMPLETED, GRADED, EXPIRED, or RESET. This column is used to filter valid attempts and to drive operational dashboards. Status transitions are tracked in the assessment status log.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

CHRONOLOGICALGRADELEVEL

Business Definition

Ordered grade level reflecting the student’s chronological placement (for example, 6, 7, 8) at the time of the attempt. This supports cohort normalization and is distinct from rostered or instructional grade in some cases. Differences highlight acceleration or retention scenarios.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

DOMAIN_THETA

Business Definition

Per-domain IRT theta (ability) estimate calculated for adaptive assessments. This value supports domain-specific placement and growth analysis. Null for platforms that do not compute IRT metrics.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

DOMAIN_THETAS

Business Definition

Serialized representation (for example, JSON) of domain-level theta estimates across multiple strands or skills. Used by analytics to understand multi-dimensional proficiency. Null where the source does not provide domain granularity.

Data Type

VARIANT

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

EVENT_ACTION_NAME

Business Definition

Human-readable action that triggered the state captured by this record (for example, SUBMITTED, SCORED, RESET). It provides context for audits, replay, and troubleshooting. Values align with the vendor’s event model.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

EVENT_TYPE_KEY

Business Definition

Coded event type identifier used to categorize assessment lifecycle events (for example, submission, grading, expiration). Pair with EVENT_TYPE_NAME for reporting and filters. Enables consistent event grouping across sources.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

EVENT_TYPE_NAME

Business Definition

Friendly label for the coded event type, harmonized across sources where possible (for example, Submitted, Graded, Expired). Used for dashboards and readable audit trails. Names may evolve as vendor taxonomies change.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

INSTRUCTIONAL_GRADE

Business Definition

Instructional grade level associated with the student at the time of the attempt, often derived from placement outcomes. This can differ from roster or chronological grade and is used to guide instruction and intervention. Null where not assigned by the source.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ITEM_POOL_NAME

Business Definition

Name of the item pool or bank used to assemble the assessment form (for example, CAT Bank v3). This helps isolate form effects and compare results across pools or versions. Values are managed by the originating platform.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

LANGUAGE

Business Definition

Language of the delivered assessment form or session (for example, EN, ES). Use this to segment bilingual populations and evaluate language-specific performance patterns. Null indicates language was not specified by the source.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

ORG_KEY

Business Definition

Foreign key to ORG_DIM identifying the school, district, or organization associated with the attempt. This supports hierarchical rollups and governance rules. A value of -1 indicates the organization could not be resolved.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCALED_SCORE

Business Definition

Scaled score suitable for comparing performance across forms and time within the same platform. Scales and interpretations are platform-specific and generally not comparable across different vendors without explicit alignment. Use with SCORE_STANDARD_ERROR and bounds where provided.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCALED_SCORE_LOWER_BOUND

Business Definition

Lower bound of the confidence interval around the scaled score as provided by the source. Use in conjunction with the upper bound and standard error to assess measurement precision. Null where the vendor does not publish bounds.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCALED_SCORE_UPPER_BOUND

Business Definition

Upper bound of the confidence interval around the scaled score as provided by the source. Analysts use this with the lower bound to illustrate uncertainty in point estimates. Null where bounds are not available.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCHOOL_YEAR

Business Definition

School year label associated with the attempt (for example, 2025–2026) derived from academic calendars or session group mapping. Use for year-over-year comparisons and compliance reporting. Values follow institutional definitions of school year start and end.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCORE_GIVEN

Business Definition

Score awarded by the platform for the attempt or section, which may represent raw points, percent, or another vendor-specific metric. Always interpret in context of SCORE_MAX and platform documentation. Not all platforms use a single unified scoring model.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCORE_MAX

Business Definition

Maximum attainable score for the attempt under the platform’s scoring model. Combine with SCORE_GIVEN to compute percent correct or scaled measures where appropriate. Null where not published by the vendor or not applicable.

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCORE_STANDARD_ERROR

Business Definition

Standard error associated with the score or theta estimate, indicating the precision of measurement. Lower values suggest more reliable estimates. Null for sources that do not provide measurement error.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SCORE_THETA

Business Definition

Overall IRT theta (ability) estimate for the attempt when computed by adaptive platforms. This supports growth modeling, placement, and cross-form comparability within the platform. Null for non-IRT sources.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SOURCE_SYSTEM_ID

Business Definition

Identifier assigned by the originating system for lineage and troubleshooting (for example, vendor record ID or GUID). Use to reconcile duplicates and to query vendor APIs if detailed traces are needed. May not be unique across all platforms.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

STUDENT_GRADE

Business Definition

Rostered grade level of the student at the time of the attempt according to student information systems or rosters. This is used for roster-aligned reporting and differs from instructional or chronological grade in certain cases. Null indicates missing roster data.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

SUBJECT

Business Definition

Subject or content area associated with the assessment attempt (for example, Reading, Mathematics). This value is harmonized across applications via APP_DOMAIN and supports curriculum-level reporting. Variations reflect vendor taxonomy differences.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_END_DATE

Business Definition

Date (without time) reflecting when the attempt ended, normalized for date-only reporting needs. Use when time precision is unnecessary or when aligning to daily operational windows. Typically derived from ASSESSMENT_COMPLETED_ON.

Data Type

DATE

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_NAME

Business Definition

Name of the test or form as provided by the source platform. Intended for display and user navigation rather than stable joins. Names can change across releases or windows.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_START_DATE

Business Definition

Date-only representation of when the attempt began, used for daily aggregations and reports where timestamp precision is not required. Typically derived from ASSESSMENT_STARTED_ON.

Data Type

DATE

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_WINDOW_ID

Business Definition

Identifier of the testing window (for example, Fall, Winter, Spring or vendor-defined cycles). Use to segment benchmark attempts and compare seasonal performance. Pair with TEST_WINDOW_NAME and TEST_WINDOW_ORDER.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_WINDOW_NAME

Business Definition

Human-readable label for the testing window used in reporting (for example, Fall, Winter, Spring). This supports easy filtering and audience-friendly dashboards. Values may be vendor-defined.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TEST_WINDOW_ORDER

Business Definition

Numeric sequence of the testing window within the school year (for example, 1=Fall, 2=Winter, 3=Spring). Enables consistent chronological ordering and analytics over seasonal cycles.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

TIME_TAKEN_COMPLETE_SECONDS

Business Definition

Elapsed time in seconds from the recorded start to completion of the attempt, excluding periods after expiration or reset. Analysts use this for effort and test-taking behavior heuristics. Null if the attempt did not complete.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT

USER_KEY

Business Definition

Foreign key to USER_DIM identifying the student (or relevant user) who owns the attempt. Use for student-level rollups, cohort analysis, and joins to demographics. A value of -1 indicates the user could not be resolved.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT