Table: dim_program

Type: Dimension Columns: 13

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 Type Description
program_id string

Unique identifier for the program

program string

Name of the program

registration_type string

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

program_enrollment_open_at timestamp[ns]

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

program_enrollment_close_at timestamp[ns]

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

capacity int32

The total number of spots available in the program

program_start_date date32[day]

Start date for the program

program_end_date date32[day]

End date for the program

program_group_id string

Unique identifier for the associated program group

slicer_program_key int32

A key for grouping programs with the same name together; connects to dim_slicer_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.