Description
Session & attendance information. The data grain is a time entry (check-in and/or check-out time) for a single session. Note that a session can have multiple time entries (i.e., a child was checked in and out more than once for a session)
Columns
| Column Name | Type | Description |
|---|---|---|
school |
string
|
The name of the school |
business |
string
|
The name of the business |
child |
string
|
The full name of the student |
child_last_name |
string
|
The last name of the student |
child_first_name |
string
|
The first name of the student |
class |
string
|
The name of the class |
session_date |
date32[day]
|
The date of the session |
is_session_voided |
string
|
Indicates whether the session has been voided; enumerated: 'Yes' or 'No' |
is_excused_absence |
string
|
Indicates whether the session was an excused absence with notifications from guardians; enumerated: 'Yes' or 'No' |
is_unexcused_absence |
string
|
Indicates whether the session was an unexcused absence without notifications from guardians; enumerated: 'Yes' or 'No' |
is_present |
string
|
Indicates whether the student was checked into the session; enumerated: 'Yes' or 'No' |
is_class_closed |
string
|
Indicates whether the class was marked as closed; enumerated: 'Yes' or 'No' |
session_type |
string
|
Type of the session; enumerated: 'Drop-in Care' or 'Regular Session' |
is_session_created |
string
|
Indicates whether the session was created; enumerated: 'Yes' or 'No' |
is_session_manually_created |
string
|
Indicates whether the session was created manually; enumerated: 'Yes' or 'No' |
is_session_in_contract |
string
|
Indicates whether the session is in a contract; enumerated: 'Yes' or 'No' |
absence_reason |
string
|
The reason provided by the gaurdian for the excused absence |
check_in_time |
timestamp[ns]
|
The datetime when the check-in occurred |
check_in_by |
string
|
The full name of the person who created the check-in time entry |
check_in_by_type |
string
|
The type of the person who checked the child in; enumerated: 'Staff', 'Guardian', or 'Unknown' |
check_out_time |
timestamp[ns]
|
The datetime when the check-out occurred |
check_out_by |
string
|
The full name of the person who created the check-out time entry |
check_out_by_type |
string
|
The type of the person who checked the student out; enumerated: 'Staff', 'Guardian', or 'Unknown' |
is_nonsubsidized |
string
|
Indicates whether the session record is non-subsidized; enumerated: 'Yes' or 'No' |
contract_pick_up_time |
string
|
The student drop-off time specified on the contract |
contract_drop_off_time |
string
|
The student pick-up time specified on the contract |
school_id |
string
|
Unique identifier for the school |
business_id |
string
|
Unique identifier for the business |
class_id |
string
|
Unique identifier for the class |
contract_id |
string
|
Unique identifier for the contract |
session_id |
string
|
Unique identifier for the session |
account_id |
string
|
Unique identifier for the account |
account_child_id |
string
|
Unique identifier for the student within an account |
child_id |
string
|
Unique identifier for the student |
fee_schedule_start_time |
string
|
The start time specified on the fee schedule |
fee_schedule_end_time |
string
|
The end time specified on the fee schedule |
fee |
string
|
The name of the fee associated with the session |
session_extended_id |
string
|
Unique identifier for the session, including sessions where |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |