Description
Staff position information. The data grain is day of week for the each staff within a schools. A staff may have multiple positions.
Columns
| Column Name | Type | Description |
|---|---|---|
business_id |
string
|
Unique identifier for the business |
staff_employment_history_key |
int32
|
Surrogate key integer for staff within a business |
staff_position_key |
int32
|
Surrogate key integer for unique staff + position within a business (will be unique on this table) |
school_id |
string
|
Unique identifier for the school; no value indicates that the position is at the business level |
position |
string
|
The name of the position |
position_id |
string
|
Non-unique identifier of the staff position |
pay_rate |
double
|
The rate of pay associated with the position (may be hourly rate or yearly salary); use the pay_rate_type field to determine if the pay rate is hourly or salary |
pay_rate_type |
string
|
The pay rate type; enumerated: 'Hourly', 'Salary', or 'Unspecified' |
calculated_hourly_pay_rate |
double
|
A computed hourly pay rate; uses pay_rate for 'Hourly' pay rate type and an estimate of pay_rate/(40 hours x 52 weeks) for 'Salary' |
calculated_yearly_pay_rate |
double
|
A computed yearly pay rate; uses pay_rate for 'Salary' pay rate type and an estimate of pay_rate x 40 hours x 52 weeks for 'Hourly' |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |