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