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

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 2W D 07 Security Patrol, 2W D8 Floor
 * Examples

Watch
The watch during which the work shift occurred. There are three watches: 1st between 22:00 and 05:59; 2nd between 06:00 and 13:59; and 3rd between 14:00 and 21:59. 1; 2; 3
 * Values

Position
Comma-separated list of all positions worked during the shift at that institution 242761 D 7 BLDG SEC PAT, 242426 RO270 D 8 FLR 2
 * Examples