Data catalog / cleansed / hr_employee
cleansed.hr_employee
Employees. 1,046 rows.
LayerCleansed
Source systemHR (SQL Server)
Data ownerHuman Resources Director
Data stewardTamika Wells
ClassificationConfidential
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01
Lineage
Columns
| Column | Type | Classification |
|---|---|---|
employee_id | text | |
dept_code | text | |
job_class | text | |
hire_date | timestamp without time zone | |
term_date | timestamp without time zone | |
term_reason | text | |
race_ethnicity_code | text | |
sex_code | text | |
birth_year | bigint | |
modified_at | timestamp without time zone | |
_run_id | text | Load metadata |
_extracted_at | timestamp without time zone | Load metadata |
dm8_race_ethnicity | text | Confidential, HR only |
std_sex | text | Confidential, HR only |
Quality rules
DQ-601 Warn Race and ethnicity conforms to the DM8 profile
Standards
DQ-602 Warn Sex conforms to the City demographic standard
Standards
Sample rows
| employee_id | dept_code | job_class | hire_date | term_date | term_reason | race_ethnicity_code | sex_code | birth_year | modified_at | _run_id | _extracted_at | dm8_race_ethnicity | std_sex |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| E20000 | PD | Customer Service Rep | 2017-05-16 00:00:00 | H | M | 1968 | 2026-03-12 00:00:00 | R-20261111-0200 | 2026-11-11 02:06:28 | HISP | M | ||
| E20001 | PD | Analyst | 2016-04-02 00:00:00 | W | M | 1970 | 2026-03-07 00:00:00 | R-20261111-0200 | 2026-11-11 02:06:28 | WHITE | M | ||
| E20002 | DS | Inspector | 2011-12-25 00:00:00 | W | F | 2001 | 2026-04-02 00:00:00 | R-20261111-0200 | 2026-11-11 02:06:28 | WHITE | F | ||
| E20003 | ANM | Engineer | 2018-07-14 00:00:00 | 2026-04-14 00:00:00 | Retirement | H | M | 1983 | 2026-04-14 00:00:00 | R-20261111-0200 | 2026-11-11 02:06:28 | HISP | M |
| E20004 | FD | Recreation Coordinator | 2004-01-05 00:00:00 | 2 | M | 1990 | 2026-07-14 00:00:00 | R-20261111-0200 | 2026-11-11 02:06:28 | MULTI | M |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.