Description
Staff emplyment history information. The data grain is staff level within a business.
Columns
| Column Name | Description |
|---|---|
business_id |
Unique identifier for the business |
staff_employment_history_key |
Surrogate key integer for staff within a business (will be unique on this table) |
staff_id |
Unique identifier for the staff |
last_login_date |
The date when the staff last logged into Kangarootime (connects to the dim_date table; NULL indicates that the staff has not logged in) |
last_login_time_key |
Surrogate key for the time when the staff last logged into Kangarootime (a surrogate key to the dim_time table; -1 indicates that the staff has not logged in) |
invited_date |
The date when the staff was sent an email invitation to work (connects to the dim_date table; NULL indicates that no invite was sent) |
invited_time_key |
Surrogate key for the time when the staff was sent an email invitation to work (a surrogate key to the dim_time table; -1 indicates that no invite was sent) |
invite_accepted_date |
The date when the staff accepted the invitation to work (connects to the dim_date table; NULL indicates that the invitation has not been accepted) |
invite_accepted_time_key |
Surrogate key for the time when the staff accepted the invitation to work (a surrogate key to the dim_time table; -1 indicates that the invitation has not been accepted) |
employment_start_date |
The date when the staff is to begin employment (connects to the dim_date table; NULL indicates that the start date has not been set yet; if start date is greater than end date then the employee has been rehired without a new end date) |
employment_end_date |
The date when the staff is to end employment (connects to the dim_date table; NULL indicates that the end date has not been set yet; if start date is greater than end date then the employee has been rehired without a new end date) |
reason_for_leaving |
The reason for ending employment (No value indicates employment has not ended); enumerated: 'New Job', 'Going Back To School', 'Staying Home', 'Moving', 'Terminated', 'Dissatisfied', 'No Call No Show', 'Walk Out', 'Temporary', 'Leave Of Absence', 'Resigned', or 'Unspecified' |