WORK REQUEST DETAIL Table
View exposing detailed facilities work request records used to manage requested maintenance and operational services.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CATALOG_TYPE_OBJECT_PARTS |
Catalog type object parts associated with the record. |
VARCHAR2 |
1 |
CODE_GROUP_OBJECT_PARTS |
Code group object parts associated with the record. |
VARCHAR2 |
8 |
CREATED_BY_USER |
Created by user associated with the record. |
VARCHAR2 |
12 |
CREATE_DATE |
Date associated with create. |
DATE |
|
CREATE_TIME |
Time associated with create. |
VARCHAR2 |
6 |
CREATE_TIMESTAMP |
Create timestamp associated with the record. |
DATE |
|
CUSTOMER_EMAIL |
Customer email associated with the record. |
VARCHAR2 |
60 |
CUSTOMER_KRBNAME |
Customer krbname associated with the record. |
VARCHAR2 |
8 |
CUSTOMER_NAME |
Customer name associated with the record. |
VARCHAR2 |
60 |
CUSTOMER_NOTE_LONG_TEXT_FLAG |
Indicator identifying whether customer note long text (Y/N). |
VARCHAR2 |
1 |
CUSTOMER_OFFICE_ADDR |
Customer office addr associated with the record. |
VARCHAR2 |
30 |
CUSTOMER_PHONE |
Customer phone associated with the record. |
VARCHAR2 |
20 |
CUSTOMER_SURVEY_COMMENT |
Customer survey comment associated with the record. |
VARCHAR2 |
240 |
CUSTOMER_SURVEY_COMMENT_DATE |
Date associated with customer survey comment. |
DATE |
|
CUSTOMER_SURVEY_COMMENT_TIME |
Time associated with customer survey comment. |
VARCHAR2 |
6 |
CUSTOMER_SURVEY_RATING |
Customer survey rating associated with the record. |
VARCHAR2 |
5 |
DESCRIPTION_LONG_TEXT_FLAG |
Indicator identifying whether description long text (Y/N). |
VARCHAR2 |
1 |
FACILITIES_GROUP |
Facilities group associated with the record. |
VARCHAR2 |
3 |
HR_ORG_UNIT_KEY |
Surrogate key identifying the hr org unit. |
VARCHAR2 |
10 |
INCIDENT_ID |
Business identifier for the incident. |
VARCHAR2 |
20 |
INTERNAL_NOTE_LONG_TEXT_FLAG |
Indicator identifying whether internal note long text (Y/N). |
VARCHAR2 |
1 |
IS_CONTROLLED_ACCESS |
Indicator identifying whether controlled access (Y/N). |
VARCHAR2 |
1 |
IS_CREATED_ON_WEB |
Indicator identifying whether created on web (Y/N). |
VARCHAR2 |
1 |
IS_EHS_RELATED |
Indicator identifying whether ehs related (Y/N). |
VARCHAR2 |
1 |
KEY_APPROVER_EMAIL |
Key approver email associated with the record. |
VARCHAR2 |
60 |
KEY_APPROVER_KRBNAME |
Key approver krbname associated with the record. |
VARCHAR2 |
8 |
KEY_APPROVER_NAME |
Key approver name associated with the record. |
VARCHAR2 |
60 |
KEY_APPROVER_OFFICE_ADDR |
Key approver office addr associated with the record. |
VARCHAR2 |
30 |
KEY_APPROVER_PHONE |
Key approver phone associated with the record. |
VARCHAR2 |
20 |
KEY_RECIPIENT_EMAIL |
Key recipient email associated with the record. |
VARCHAR2 |
60 |
KEY_RECIPIENT_KRBNAME |
Key recipient krbname associated with the record. |
VARCHAR2 |
8 |
KEY_RECIPIENT_NAME |
Key recipient name associated with the record. |
VARCHAR2 |
60 |
KEY_RECIPIENT_OFFICE_ADDR |
Key recipient office addr associated with the record. |
VARCHAR2 |
30 |
KEY_RECIPIENT_PHONE |
Key recipient phone associated with the record. |
VARCHAR2 |
20 |
LAST_UPDATED_BY_USER |
Last updated by user associated with the record. |
VARCHAR2 |
12 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_TIME |
Time associated with last update. |
VARCHAR2 |
8 |
LAST_UPDATE_TIMESTAMP |
Last update timestamp associated with the record. |
DATE |
|
LOCATION_DESCRIPTION |
Description of location. |
VARCHAR2 |
30 |
NOTIFICATION_COMPLETION_DATE |
Date associated with notification completion. |
DATE |
|
NOTIFICATION_COMPLETION_TIME |
Time associated with notification completion. |
VARCHAR2 |
6 |
NOTIFICATION_REFERENCE_DATE |
Date associated with notification reference. |
DATE |
|
PREVIOUS_WORK_REQUEST_KEY |
Surrogate key identifying the previous work request. |
NUMBER |
34 |
REQUESTER_EMAIL |
Requester email associated with the record. |
VARCHAR2 |
60 |
REQUESTER_KRBNAME |
Requester krbname associated with the record. |
VARCHAR2 |
8 |
REQUESTER_NAME |
Requester name associated with the record. |
VARCHAR2 |
60 |
REQUESTER_OFFICE_ADDR |
Requester office addr associated with the record. |
VARCHAR2 |
30 |
REQUESTER_PHONE |
Requester phone associated with the record. |
VARCHAR2 |
20 |
REQUIRED_END_DATE |
Date associated with required end. |
DATE |
|
REQUIRED_END_TIME |
Time associated with required end. |
VARCHAR2 |
6 |
REQUIRED_END_TIMESTAMP |
Required end timestamp associated with the record. |
DATE |
|
REQUIRED_START_DATE |
Date associated with required start. |
DATE |
|
REQUIRED_START_TIME |
Time associated with required start. |
VARCHAR2 |
6 |
REQUIRED_START_TIMESTAMP |
Required start timestamp associated with the record. |
DATE |
|
SYSTEM_STATUS_STRING |
System status string associated with the record. |
VARCHAR2 |
40 |
USER_STATUS_STRING |
User status string associated with the record. |
VARCHAR2 |
40 |
VERSION_NUMBER |
Version number associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_CENTER_KEY |
Surrogate key identifying the work center. |
VARCHAR2 |
8 |
WORK_ORDER_CATEGORY_KEY |
Surrogate key identifying the work order category. |
VARCHAR2 |
7 |
WORK_ORDER_NUMBER |
Work order number associated with the record. |
VARCHAR2 |
7 |
WORK_ORDER_PLANNER_GROUP_KEY |
Surrogate key identifying the work order planner group. |
VARCHAR2 |
20 |
WORK_REQUEST_ACTIVITY_KEY |
Surrogate key identifying the work request activity. |
VARCHAR2 |
13 |
WORK_REQUEST_CAUSE_KEY |
Surrogate key identifying the work request cause. |
VARCHAR2 |
13 |
WORK_REQUEST_CRAFT_KEY |
Surrogate key identifying the work request craft. |
VARCHAR2 |
13 |
WORK_REQUEST_DAMAGE_KEY |
Surrogate key identifying the work request damage. |
VARCHAR2 |
13 |
WORK_REQUEST_DATE |
Date associated with work request. |
DATE |
|
WORK_REQUEST_DESCRIPTION |
Description of work request. |
VARCHAR2 |
40 |
WORK_REQUEST_FUNC_LOCATION_KEY |
Surrogate key identifying the work request func location. |
VARCHAR2 |
30 |
WORK_REQUEST_KEY |
Surrogate key identifying the work request. |
VARCHAR2 |
7 |
WORK_REQUEST_LOCATION_KEY |
Surrogate key identifying the work request location. |
VARCHAR2 |
24 |
WORK_REQUEST_NUMBER |
Work request number associated with the record. |
VARCHAR2 |
7 |
WORK_REQUEST_PRIORITY |
Work request priority associated with the record. |
VARCHAR2 |
1 |
WORK_REQUEST_STATUS_KEY |
Surrogate key identifying the work request status. |
VARCHAR2 |
10 |
WORK_REQUEST_TIME |
Time associated with work request. |
VARCHAR2 |
6 |
WORK_REQUEST_TIMESTAMP |
Work request timestamp associated with the record. |
DATE |
|
WORK_REQUEST_TYPE_KEY |
Surrogate key identifying the work request type. |
VARCHAR2 |
5 |
WORK_REQUEST_WORK_CATEGORY_KEY |
Surrogate key identifying the work request work category. |
VARCHAR2 |
13 |