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 | Description |
|---|---|
registration_term_key |
Unique identifier for the registration term; registration_term_type dictate the following key to id mappings: 'Mapped Program Term' - program_group_id, 'Mapped Registration Link' - registration_id, 'Unmapped Program Group' - {business_id}{YEAR(program.start_date)}, or 'No Program' - {business_id} |
registration_term |
A label used for grouping registrations terms (this uses either a custom grouping (based on program groups or registration links), program start year or defaults to the application start date year) |
registration_order |
The ascending order that the term occurs in (with the oldest terms being first; within registration_group for custom mapped terms) |
registration_reverse_order |
The descending order that the term occurs in (with the newest terms being first; within registration_group for custom mapped terms) |
registration_term_type |
A categorization of the registration; enumerated: 'Mapped Program Term', 'Mapped Registration Link', 'Unmapped Program Term', or 'No Program' |
business_id |
Unique identifier for the business |