StaffData/StaffRoster

Table containing one record per active staff per month, starting December, 2020. Active staff in any given month are all CDCR employees who are not on long-term leave and have not stopped working for CDCR. Data are updated several times each month and records in more recent months may be added for new employees. Additionally, due to delays in recording of changes in personnel status, some staff may not appear in a given month during which they were active and some staff may appear in a month during which they were not active.

StaffId
Anonymized integer uniquely identifiying each staff member. StaffId is stable across tables and timepoints. 88758923, -9450823
 * Examples

BoundedBirthYear
The year of the staff's birth. In cases where birth year is greater than 2000 or less than 1949, the years 2000 and 1949 are used respectively. NULL indicates the birth year is unknown. 1949, 1952, 1967, 2000, NULL
 * Values

BoundedBirthDecade
The decade of the staff's BoundedBirthYear. Note: This column will be removed in a future release. 1940, 1950, 1960, 1970, 1980, 1990, 2000, NULL
 * Values

Month
An integer indicating the year and month for which the record applies. 202012, 202101
 * Examples

Institution
Abbreviated name of prison where staff primarly works. If primary work location is not a prison, then value is "Other". CCWF, COR, Other
 * Examples

Gender
Self-reported gender of staff member. Note, to safeguard against potential identification of individuals, cases where gender is not male or female are set to NULL. Also, self-reported gender may change for a given individual over time. Male, Female, NULL
 * Values

Ethnicity
Self-reported ethnicity of staff member. NULL indicates ethnicity is unknown. Note that self-reported ethnicity may change for an individual over time. African American, White, Other, NULL
 * Examples

Zipcode
Residential zipcode of staff member. NULL indicates that a valid Zipcode is missing.

Class
The staff's primary job classification. NULL means job type is unknown. See "Class" column in Supplemental/Staff_positions
 * Values

DirectCare
An integer indicating the degree to which the staff's position involves contact with residents. See "Resident Contact" column in Supplemental/Staff_positions
 * Values

MinimumEducationRequired
An integer indicating the minimum education requirement of the staff's position. See "Minimum Education Required" column in Supplemental/Staff_positions
 * Values