WORK REQUEST ACTIVITY DETAIL Table
View exposing detailed facilities work request activity records associated with requested maintenance and operational services.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_SEQUENCE |
Activity sequence associated with the record. |
NUMBER |
34 |
ACTIVITY_TEXT |
Activity text associated with the record. |
VARCHAR2 |
40 |
CREATED_BY_USER |
Created by user associated with the record. |
VARCHAR2 |
12 |
CREATE_DATE |
Date associated with create. |
DATE |
|
LAST_UPDATED_BY_USER |
Last updated by user associated with the record. |
VARCHAR2 |
12 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
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 |
WORK_REQUEST_KEY |
Surrogate key identifying the work request. |
VARCHAR2 |
12 |