Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse NEW HIRE PROCESS TILE STEP Table


View exposing tile and step reference data for the new-hire process including tile and step identifiers, names, and sequences.


Field Name

Description

Data Type

Length

NEW_HIRE_PROCESS_TILE_STEP_KEY

Surrogate key identifying the new hire process tile step.

VARCHAR2

4

STEP_ID

Business identifier for the step.

VARCHAR2

2

STEP_NAME

Step name associated with the record.

VARCHAR2

50

STEP_SEQUENCE

Step sequence associated with the record.

NUMBER

TILE_ID

Business identifier for the tile.

VARCHAR2

2

TILE_NAME

Tile name associated with the record.

VARCHAR2

50

TILE_SEQUENCE

Tile sequence associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE