Description
This fact table records satisfaction of the program at a given datetime.
Columns
| Column Name | Type | Description |
|---|---|---|
survey_id |
int32
|
Unique identifier for the survey (multiple students may be associated with a single survey) |
school_id |
string
|
Unique identifier for the school |
student_id |
string
|
Unique identifier for the student |
contact_id |
string
|
Unique identifier for the contact (A contact may belong to more than one account) |
created_at |
timestamp[ns]
|
The datetime when the survey was created |
satisfaction |
string
|
The satisfaction for the program experience; enumerated: 'Positive', 'Negative', or 'Dismissed' |
source |
string
|
The source of the survey; enumerated: 'poc', 'parent', 'k2', 'school', 'classroom', 'kiosk', or 'system' |
business_id |
string
|
Unique identifier for the business |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |