WORK REQUEST ACTIVITY Table
View exposing facilities work request activity records associated with requested maintenance and operational services.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_CODE |
Code identifying activity. |
VARCHAR2 |
40 |
ACTIVITY_GROUP_CODE |
Code identifying activity group. |
VARCHAR2 |
13 |
ACTIVITY_GROUP_NAME |
Activity group name associated with the record. |
VARCHAR2 |
100 |
ACTIVITY_NAME |
Activity name associated with the record. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_REQUEST_ACTIVITY_KEY |
Surrogate key identifying the work request activity. |
VARCHAR2 |
13 |