StaffData/StaffWork

Person-period data table with one row per staff per day per institution per shift

StaffId
Anonymized signed integer that uniquely identifies each staff. This ID is stable across time and tables. 9869200; -19577694
 * Examples

WorkDate
The date of the shift that was worked 2020-12-01; 2021-01-31
 * Examples

Month
The year and month of the date worked, used to segment files 2019-11, 2020-01
 * Examples

Institution
The institution where the shift took place PBSP, RJD
 * Examples

Unit
Comma-separated list of all locations worked during that shift at that institution. Note: Due to privacy concerns, this column is currently blank. 2W D 07 Security Patrol, 2W D8 Floor
 * Examples

Watch
The watch during which the work shift occurred. The three watches and their time periods are as follows: 1; 2; 3
 * 1st Watch [22:00, 06:00)
 * 2nd Watch [06:00, 14:00)
 * 3rd Watch [14:00, 22:00)
 * Values

Position
The staff's work discipline, when available. Custody, Nursing, Other, NULL
 * Values