NEW HIRE PROCESS DETAIL Table
View exposing detailed new-hire process progress by employee, tile, and step including access timestamps, completion timestamps, and tile and step status values.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
NEW_HIRE_EMPLOYEE_KEY |
Surrogate key identifying the new hire employee. |
VARCHAR2 |
20 |
NEW_HIRE_PROCESS_TILE_STEP_KEY |
Surrogate key identifying the new hire process tile step. |
VARCHAR2 |
4 |
STEP_COMPLETION_DATE |
Date associated with step completion. |
DATE |
|
STEP_COMPLETION_TIME |
Time associated with step completion. |
VARCHAR2 |
6 |
STEP_COMPLETION_TIMESTAMP |
Step completion timestamp associated with the record. |
DATE |
|
STEP_FIRST_ACCESS_DATE |
Date associated with step first access. |
DATE |
|
STEP_FIRST_ACCESS_TIME |
Time associated with step first access. |
VARCHAR2 |
6 |
STEP_FIRST_ACCESS_TIMESTAMP |
Step first access timestamp associated with the record. |
DATE |
|
STEP_LAST_ACCESS_DATE |
Date associated with step last access. |
DATE |
|
STEP_LAST_ACCESS_TIME |
Time associated with step last access. |
VARCHAR2 |
6 |
STEP_LAST_ACCESS_TIMESTAMP |
Step last access timestamp associated with the record. |
DATE |
|
TILE_COMPLETION_DATE |
Date associated with tile completion. |
DATE |
|
TILE_COMPLETION_TIME |
Time associated with tile completion. |
VARCHAR2 |
6 |
TILE_COMPLETION_TIMESTAMP |
Tile completion timestamp associated with the record. |
DATE |
|
TILE_FIRST_ACCESS_DATE |
Date associated with tile first access. |
DATE |
|
TILE_FIRST_ACCESS_TIME |
Time associated with tile first access. |
VARCHAR2 |
6 |
TILE_FIRST_ACCESS_TIMESTAMP |
Tile first access timestamp associated with the record. |
DATE |
|
TILE_LAST_ACCESS_DATE |
Date associated with tile last access. |
DATE |
|
TILE_LAST_ACCESS_TIME |
Time associated with tile last access. |
VARCHAR2 |
6 |
TILE_LAST_ACCESS_TIMESTAMP |
Tile last access timestamp associated with the record. |
DATE |
|
TILE_STATUS |
Tile status associated with the record. |
VARCHAR2 |
70 |
TILE_STEP_STATUS |
Tile step status associated with the record. |
VARCHAR2 |
70 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |