Data catalog / curated / dim_employee
curated.dim_employee
dim employee. 1,046 rows.
LayerCurated
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 | |
dm8_race_ethnicity | text | Confidential, HR only |
std_sex | text | Confidential, HR only |
age | bigint | Confidential, HR only |
Quality rules
Rules run on the cleansed source tables upstream.
Sample rows
| employee_id | dept_code | job_class | hire_date | term_date | term_reason | dm8_race_ethnicity | std_sex | age |
|---|---|---|---|---|---|---|---|---|
| E20000 | PD | Customer Service Rep | 2017-05-16 00:00:00 | HISP | M | 58 | ||
| E20001 | PD | Analyst | 2016-04-02 00:00:00 | WHITE | M | 56 | ||
| E20002 | DS | Inspector | 2011-12-25 00:00:00 | WHITE | F | 25 | ||
| E20003 | ANM | Engineer | 2018-07-14 00:00:00 | 2026-04-14 00:00:00 | Retirement | HISP | M | 43 |
| E20004 | FD | Recreation Coordinator | 2004-01-05 00:00:00 | MULTI | M | 36 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.