Table: dim_registration_group

Type: Dimension Columns: 6

Description

A table that enables grouping (slicing) of registrations in meaningful ways. Because businesses have different registration flows (Program vs. IOE) or custom mappings that they've provided, this table provides groupings tailored to these differences.

Columns

Column Name Type Description
registration_group_key string

Unique identifier for the registration group; registration_group_type dictate the following key to id mappings: 'Mapped Program Group' - program_group_id, 'Mapped Registration Link' - registration_id, 'Unmapped Program Group' - program_group_id, or 'No Program' - {business_id}_{Age of student at enrollment_start_date}

registration_group string

A label used for grouping registrations (this uses either a custom grouping (based on program groups or registration links), program group or defaults to the student's age at the time of the application start date's)

registration_group_type string

A categorization of the registration; enumerated: 'Mapped Program Group', 'Mapped Registration Link', 'Unmapped Program Group', or 'No Program'

business_id string

Unique identifier for the business

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.