NEW HIRE PROCESS DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
NEW_HIRE_EMPLOYEE_KEY |
XXX |
VARCHAR2 |
20 |
NEW_HIRE_PROCESS_TILE_STEP_KEY |
XXX |
VARCHAR2 |
4 |
STEP_COMPLETION_DATE |
XXX |
DATE |
7 |
STEP_COMPLETION_TIME |
XXX |
VARCHAR2 |
6 |
STEP_COMPLETION_TIMESTAMP |
XXX |
DATE |
7 |
STEP_FIRST_ACCESS_DATE |
XXX |
DATE |
7 |
STEP_FIRST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
STEP_FIRST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
STEP_LAST_ACCESS_DATE |
XXX |
DATE |
7 |
STEP_LAST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
STEP_LAST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
TILE_COMPLETION_DATE |
XXX |
DATE |
7 |
TILE_COMPLETION_TIME |
XXX |
VARCHAR2 |
6 |
TILE_COMPLETION_TIMESTAMP |
XXX |
DATE |
7 |
TILE_FIRST_ACCESS_DATE |
XXX |
DATE |
7 |
TILE_FIRST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
TILE_FIRST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
TILE_LAST_ACCESS_DATE |
XXX |
DATE |
7 |
TILE_LAST_ACCESS_TIME |
XXX |
VARCHAR2 |
6 |
TILE_LAST_ACCESS_TIMESTAMP |
XXX |
DATE |
7 |
TILE_STATUS |
XXX |
VARCHAR2 |
70 |
TILE_STEP_STATUS |
XXX |
VARCHAR2 |
70 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |