Skip to content

Learnosity Items Dim

Table Description

A comprehensive dimension table that stores detailed information about Learnosity assessment items, including their metadata, psychometric properties, activity associations, and question characteristics. This table serves as a central repository for item-level data used in educational assessments and activities.

Grain: One row per unique Learnosity item.

Scope: MyPath, IR

Table Type: Type 2 (Slowly Changing Dimension)

Key Business Uses: - Analyze item difficulty and discrimination parameters - Track item versioning and publishing status - Support item bank management and content alignment - Enable psychometric analysis of assessment items

Primary Relationships: - Links to ASSESSMENT_ITEM_FACT for item-level scoring data - Supports filtering by domain, subject, and grade level

Table Overview

This table contains 58 columns.

Quick Navigation

Column Definitions

activity_assessment_grade

Business Definition

Intended grade level for the activity containing this item, derived from Learnosity activity metadata. This supports grade-level filtering and alignment analysis. May differ from ASSESSMENT_GRADE when items are reused across grade bands.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_created_on

Business Definition

Timestamp when the associated activity was created in the source system. This provides activity-level provenance and supports curriculum lineage analysis. Null for Helix items or when activity creation dates are not recorded.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_domain

Business Definition

Domain or content strand for the activity (for example, Reading, Math, Science), sourced from Learnosity activity tags. Use with DOMAIN and SUBJECT for multi-level content classification. Null for Helix items where domain is derived differently.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_id

Business Definition

Identifier or comma-delimited list of activity GUIDs that reference this item, linking assessment items to curriculum activities. For Helix sources, multiple activities may share the same item, represented as a pipe-delimited list. This column supports reporting by activity and enables curriculum-to-assessment traceability.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_name

Business Definition

Human-readable name or comma-delimited list of activity names associated with this item. For Helix items, this may include pipe-delimited activity names from multiple lessons. This column supports content search and reporting labels but should not be used for joins due to variability.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_status

Business Definition

Publication status of the associated activity (for example, 'published', 'draft', 'archived'). This column is used to filter operational items from development content and to enforce content governance rules. Helix-sourced items typically default to 'published'.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_subject

Business Definition

Subject area of the activity (for example, Reading, Math) from Learnosity activity metadata. This complements SUBJECT at the item level and supports activity-level rollups. Helix items are typically tagged as 'Reading' for Growth Test activities.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_tag_status

Business Definition

Operational status tag for the activity such as 'Operational', 'Field Test', or 'Pilot'. This distinguishes live assessment content from experimental or pilot items and is used to segment reporting by item maturity. Helix items default to 'Operational'.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

activity_updated_on

Business Definition

Timestamp of the most recent update to the associated activity. This helps identify curriculum refreshes and content versioning events. Null when activity update tracking is not available.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

assessment_grade

Business Definition

Target grade level for the item itself as defined by content specialists or Learnosity tags (for example, '3', '4-5', 'High School'). This column supports grade-specific item pools and alignment reporting. May differ from ACTIVITY_ASSESSMENT_GRADE when items are reused.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

cat_item_type_style

Business Definition

CAT-specific classification for item style or format (for example, 'MC', 'SA', 'EBSR'). This helps CAT engines select items by interaction type and ensures test form balance. Null for non-CAT items or when Learnosity does not provide style metadata.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

difficulty_parameter_b1

Business Definition

IRT difficulty parameter (b1) representing the ability level at which an examinee has a 50% probability of answering correctly. Lower values indicate easier items, higher values indicate harder items. This parameter is central to CAT algorithms and item selection logic. Null for items without IRT calibration.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

difficulty_parameter_b2

Business Definition

IRT difficulty parameter (b2) for polytomous or multi-step items under graded response or partial credit models. This parameter represents the threshold for achieving a higher score category. Null for dichotomous items or items without polytomous calibration.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

difficulty_parameter_unscaled_b1

Business Definition

Unscaled version of the difficulty parameter b1 before applying score transformations or equating. This value is used for research and recalibration studies where raw metric comparisons are needed. Typically provided by Learnosity but null for Helix items.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

difficulty_parameter_unscaled_b2

Business Definition

Unscaled version of the difficulty parameter b2 before score transformations. Used in conjunction with DIFFICULTY_PARAMETER_UNSCALED_B1 for raw metric analysis. Null for most items except those with polytomous IRT models.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

discrimination_parameter

Business Definition

IRT discrimination parameter (a) indicating how steeply the item's probability curve rises with ability. Higher values mean the item differentiates well between ability levels; lower values indicate flatter response curves. This parameter influences item selection in adaptive tests. Null for non-IRT items.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

discrimination_parameter_unscaled_a

Business Definition

Unscaled version of the discrimination parameter (a) before metric transformations. Research teams use this for cross-calibration studies and longitudinal comparisons. Typically provided by Learnosity for calibrated items.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dok

Business Definition

Depth of Knowledge (DOK) level classification (for example, '1', '2', '3', '4') from Norman Webb's framework, indicating cognitive complexity. DOK 1 represents recall, DOK 4 represents extended thinking. Used for standards alignment and rigor analysis. Null when DOK tags are not assigned.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

domain

Business Definition

Content domain or strand within the subject (for example, 'Number and Operations', 'Reading Comprehension', 'Grammar'). This provides granular content classification for standards mapping and skill-level reporting. Null for Helix items where domain is derived from other fields.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

domain_name

Business Definition

Extended or user-friendly name for the domain, complementing the DOMAIN code. This field is used for reporting labels and may include localized or display-friendly text. Typically populated for Learnosity items but null for Helix.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_created_by

Business Definition

User or process that created this record in the data warehouse (for example, 'DBT_SERVICE', 'ETL_BATCH'). This supports operational auditing and troubleshooting ETL pipelines. Typically set to CURRENT_USER at insert time.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_created_on

Business Definition

Timestamp when this dimension record was first created in the data warehouse. Used for ETL auditing, SCD tracking, and understanding data warehouse load history. All records should have this value.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_effective_end_date

Business Definition

Effective end timestamp for this version of the dimension record under SCD Type 2. A value of '2999-12-31' indicates the current active version; historical versions have actual end dates. Use this with DW_EFFECTIVE_START_DATE for temporal joins.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_effective_start_date

Business Definition

Effective start timestamp for this version of the dimension record under SCD Type 2. Represents when this particular version of the item became active. Used for point-in-time queries and historical reporting.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_is_active

Business Definition

Flag indicating whether this is the currently active version of the item record ('Y' for active, 'N' for historical). Most queries filter on DW_IS_ACTIVE = 'Y' to retrieve current state. Historical versions are retained for audit and trend analysis.

Data Type

VARCHAR(1)

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_updated_by

Business Definition

User or process that last updated this record (for example, 'DBT_INCREMENTAL', 'DATA_ENG_TEAM'). This aids in ETL troubleshooting and change tracking. Typically set to CURRENT_USER on updates.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

dw_updated_on

Business Definition

Timestamp of the most recent update to this warehouse record. For SCD Type 2, this captures when a new version was created or the existing record was modified. Use this for incremental load watermarking.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

galileo_specification_id

Business Definition

Reference identifier to Galileo Educational Network specifications or curriculum standards framework. This supports external standards alignment and compliance reporting for state or district requirements. Null when items are not mapped to Galileo.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

galileo_specification_title

Business Definition

Human-readable title for the Galileo specification or standard referenced by GALILEO_SPECIFICATION_ID. This provides context for standards-aligned reporting and audit trails. Typically used in conjunction with state assessment programs.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

import_date

Business Definition

Date when the item was imported into the system from the source platform (Learnosity or Helix). This supports versioning analysis and helps identify recently added content. Null for legacy items where import dates were not recorded.

Data Type

DATE

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

irt_model

Business Definition

IRT model type used for calibration (for example, '1PL', '2PL', '3PL', 'GRM' for graded response). This informs analysts which parameters are meaningful for the item and which statistical assumptions apply. Null for non-IRT or untagged items.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

item_created_on

Business Definition

Timestamp when the complete item record (activity + question + metadata) was created in the source system. This represents the composite creation date and is used for item lifecycle reporting. Null for legacy or incomplete records.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

item_id

Business Definition

Natural identifier for the item from the source system (Learnosity reference or Helix question name prefixed with 'helix:'). This column is normalized to lowercase and serves as the business key for matching across systems. Analysts use this to trace items back to vendor platforms and curriculum repositories.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

item_key

Business Definition

Surrogate key uniquely identifying each item record in the dimension, generated from the LEARNOSITY_ITEMS_DIM_ITEM_KEY sequence. This key enables efficient joins to fact tables and supports SCD Type 2 tracking by providing stable references across historical versions. The -1 value represents unknown or unmatched items in dimensional queries.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

item_status

Business Definition

Operational status of the item itself (for example, 'Operational', 'Field Test', 'Retired'). This distinguishes live items from pilot or deprecated content and drives item pool filtering. Helix items default to 'Operational'.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

item_updated_on

Business Definition

Timestamp of the most recent update to the complete item record. This aggregates changes from question, activity, or metadata updates and is the primary field for identifying recent item modifications. Null when not tracked.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

language

Business Definition

Language in which the item is presented (for example, 'English', 'Spanish', 'en', 'es'). This supports bilingual assessments and language-specific reporting. Helix items default to 'English'; Learnosity items may include localized variants.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

max_score

Business Definition

Maximum attainable score for the item under the defined scoring model, accommodating partial-credit scenarios. Use this to normalize scores or compute percent correct. Null for dichotomous items where SCORE represents the full value.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

multiple_responses

Business Definition

Flag indicating whether the item allows or expects multiple correct responses (for example, 'select all that apply' items). This affects scoring logic and UI rendering. Null for single-response items or when the property is not applicable.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

product

Business Definition

Product or curriculum line associated with the item (for example, 'Imagine Learning', 'Edgenuity', 'Imagine Math'). This enables product-level segmentation and supports multi-product reporting environments. Helix items inherit product from the source lesson structure.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

pseudoguessing_parameter_c

Business Definition

IRT pseudo-guessing parameter © representing the probability of a low-ability examinee answering correctly by chance (lower asymptote). Commonly used in 3PL models for multiple-choice items. Values near 0 indicate minimal guessing; values near 0.25 suggest strong guessing effects. Null for constructed-response or non-3PL items.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

publishing_status

Business Definition

Publishing workflow status (for example, 'published', 'draft', 'under review', 'archived'). This tracks items through content development stages and is used to filter production-ready content. All Helix items are marked 'published'.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_choices

Business Definition

Serialized representation (JSON or structured text) of answer choices for the question, including labels and values. For multiple-choice items, this contains option text; for other types, it may encode choice metadata. Null for open-ended or constructed-response items.

Data Type

VARIANT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_created_on

Business Definition

Timestamp when the question was originally created in the source system. This supports content age analysis and lineage tracking. Null for legacy items or Helix items where creation timestamps are not captured.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_id

Business Definition

Unique identifier for the question component of the item from the source system. In Learnosity, this differs from ITEM_ID when items have complex structures; in Helix, it typically mirrors ITEM_ID with a 'helix:' prefix. Use this for question-level lineage and content analysis.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_size

Business Definition

Number of answer choices or response options available for the question, cast to string for compatibility. Used to analyze choice cardinality and identify items with unusual option counts. Null for non-choice-based items.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_stimulus

Business Definition

Text of the question stem or prompt presented to the student, which may include embedded HTML or rich media references. For passage-based items, this may reference a shared stimulus. Analysts use this for content review and keyword searches.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_type

Business Definition

Interaction type or response format for the question (for example, 'mcq' for multiple choice, 'shorttext', 'clozetext', 'inline choice'). This column is critical for UI rendering, scoring rules, and test form balancing. Question types follow Learnosity or Helix-specific taxonomies.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

question_updated_on

Business Definition

Timestamp of the most recent update to the question in the source system. Use this to identify recently revised content and to trigger re-review workflows. Null when update tracking is unavailable.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

score

Business Definition

Default or standard score value awarded for a correct response to the item. In partial-credit models, this may represent the maximum possible score. Null when scoring is context-dependent or defined externally.

Data Type

FLOAT

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

scoring_type

Business Definition

Scoring algorithm or rule applied to the item (for example, 'exactMatch', 'partialCredit', 'rubric'). This determines how student responses are evaluated and converted to scores. Helix items typically use 'exactMatch' while Learnosity items may vary.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

security

Business Definition

Security or exposure classification for the item (for example, 'Public', 'Secure', 'Embargo'). Items marked 'Secure' should not be exposed in certain contexts to prevent compromise. Used for operational security and test administration policies. Null for Helix items.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

source_application

Business Definition

Name of the originating application or system (for example, 'Learnosity', 'Helix\TabletMedia'). This distinguishes items by source platform and supports multi-vendor item bank management. Use this column to segment analysis by source system.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

source_system_id

Business Definition

Identifier assigned by the originating vendor system (Learnosity or Helix) for lineage and troubleshooting. This enables reconciliation with source APIs and supports vendor-specific operations. Null for Helix items where internal IDs are used.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

subject

Business Definition

Primary subject area of the item (for example, 'Reading', 'Math', 'Science', 'ELA'). This is the top-level content classification used for subject-based reporting and curriculum alignment. Helix items are predominantly 'Reading'.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

template_version

Business Definition

Version identifier for the item rendering template or format specification used by the assessment platform. Changes in template versions can affect item presentation and scoring logic. Null for Helix items where templates are not versioned.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

test_type

Business Definition

Classification of the test or assessment type (for example, 'CAT', 'Growth/Lexile Test', 'Benchmark'). This column helps analysts segment items by assessment purpose and calibration model. Helix items are labeled 'Growth/Lexile Test' while Learnosity items follow CAT or other vendor classifications.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS

valid_response

Business Definition

Correct answer key or serialized valid response data for the item. For multiple-choice items, this is the correct option label; for complex items, it may be a JSON structure. Used for automated scoring, answer key reports, and content validation.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS