SPACE UNIT SNAPSHOT Table
View exposing monthly snapshot records of facilities organization and space unit reference data including facilities organization keys, space unit identifiers, names, DLC, and snapshot timestamps.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
15 |
FCLT_ORGANIZATION_KEY |
Surrogate key identifying the fclt organization. |
VARCHAR2 |
16 |
SPACE_UNIT |
Space unit associated with the record. |
VARCHAR2 |
70 |
SPACE_UNIT_CODE |
Code identifying space unit. |
VARCHAR2 |
16 |
SPACE_UNIT_KEY |
Surrogate key identifying the space unit. |
VARCHAR2 |
16 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
TIMESTAMP(6) |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |