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 | Description |
|---|---|
business_id |
Unique identifier for the business |
staff_employment_history_key |
Surrogate key integer for staff within a business |
staff_position_key |
Surrogate key integer for unique staff + position within a business (will be unique on this table) |
school_id |
Unique identifier for the school; no value indicates that the position is at the business level |
position |
The name of the position |
position_id |
Non-unique identifier of the staff position |
pay_rate |
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 |
The pay rate type; enumerated: 'Hourly', 'Salary', or 'Unspecified' |
calculated_hourly_pay_rate |
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 |
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' |