Data Table Contract
Contract details
Contract Type: datatable_contract
Validation Schema Version: 1.0
Lifecycle Status: active
Table: employee
Table Name: employee
Schema Name: hr
Catalog Name: dc_demo_service
Description: Contains employee master data
Discovery Tags: employee, masterdata
Sensitive Columns
-
personal_phone
-
personal_email
-
work_phone
-
work_email
Column overview
| column_name | data_type | is_primary_key | is_business_key | is_nullable | sensitivity_type |
|---|---|---|---|---|---|
| id | integer | True | True | False | None |
| first_name | string | False | False | False | None |
| last_name | string | False | False | False | None |
| birth_date | date | False | False | False | None |
| personal_phone | string | False | False | False | pii |
| personal_email | string | False | True | False | pii |
| work_phone | string | False | False | False | pii |
| work_email | string | False | True | False | pii |
| created_at | timestamp | False | False | False | None |
| created_year | integer | False | False | False | None |
Column details
Column Name: id
Data Type: integer
Description: Unique identifier for the employee.
Is Primary Key: True
Is Business Key: True
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None
Column Name: first_name
Data Type: string
Description: Employee first name
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None
Column Name: last_name
Data Type: string
Description: Employee last name
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None
Column Name: birth_date
Data Type: date
Description: Date of birth for employee.
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None
Column Name: personal_phone
Data Type: string
Description: Employee personal phone number
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: confidential
Sensitivity Type: pii
Column Name: personal_email
Data Type: string
Description: Employee personal email.
Is Primary Key: False
Is Business Key: True
Is Nullable: False
Is Id Column: False
Sensitivity Level: confidential
Sensitivity Type: pii
Column Name: work_phone
Data Type: string
Description: Employee work phone number
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: restricted
Sensitivity Type: pii
Column Name: work_email
Data Type: string
Description: Employee personal email.
Is Primary Key: False
Is Business Key: True
Is Nullable: False
Is Id Column: False
Sensitivity Level: restricted
Sensitivity Type: pii
Column Name: created_at
Data Type: timestamp
Description: Timestamp when the employee record was created.
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None
Column Name: created_year
Data Type: integer
Description: Year the employee record was created.
Is Primary Key: False
Is Business Key: False
Is Nullable: False
Is Id Column: False
Sensitivity Level: None
Sensitivity Type: None