Table: dim_program

Type: Dimension Columns: 11

Description

Information about programs. The data grain is program (a program may only have on associated class per center) at the business level.

Columns

Column Name Description
program_id

Unique identifier for the program

program

Name of the program

registration_type

The origin registration program;; enumerated: 'Early Bird' or 'Standard'

program_enrollment_open_at

Start date time for the period in which guardians can enroll their children into this program

program_enrollment_close_at

End date time for the period in which guardians can enroll their children into this program

capacity

The total number of spots available in the program

program_start_date

Start date for the program

program_end_date

End date for the program

program_group_id

Unique identifier for the associated program group

slicer_program_key

A key for grouping programs with the same name together; connects to dim_slicer_program

business_id

Unique identifier for the business