WORK REQUEST DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CATALOG_TYPE_OBJECT_PARTS |
XXX |
VARCHAR2 |
1 |
CODE_GROUP_OBJECT_PARTS |
XXX |
VARCHAR2 |
8 |
CREATED_BY_USER |
XXX |
VARCHAR2 |
12 |
CREATE_DATE |
Date when UROP applicatioan initiated. |
DATE |
|
CREATE_TIME |
XXX |
VARCHAR2 |
6 |
CREATE_TIMESTAMP |
XXX |
DATE |
|
CUSTOMER_EMAIL |
XXX |
VARCHAR2 |
60 |
CUSTOMER_KRBNAME |
XXX |
VARCHAR2 |
8 |
CUSTOMER_NAME |
XXX |
VARCHAR2 |
60 |
CUSTOMER_NOTE_LONG_TEXT_FLAG |
XXX |
VARCHAR2 |
1 |
CUSTOMER_OFFICE_ADDR |
XXX |
VARCHAR2 |
30 |
CUSTOMER_PHONE |
XXX |
VARCHAR2 |
20 |
CUSTOMER_SURVEY_COMMENT |
XXX |
VARCHAR2 |
240 |
CUSTOMER_SURVEY_COMMENT_DATE |
XXX |
DATE |
|
CUSTOMER_SURVEY_COMMENT_TIME |
XXX |
VARCHAR2 |
6 |
CUSTOMER_SURVEY_RATING |
XXX |
VARCHAR2 |
5 |
DESCRIPTION_LONG_TEXT_FLAG |
XXX |
VARCHAR2 |
1 |
FACILITIES_GROUP |
XXX |
VARCHAR2 |
3 |
HR_ORG_UNIT_KEY |
This field should be used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions. |
VARCHAR2 |
10 |
INCIDENT_ID |
XXX |
VARCHAR2 |
20 |
INTERNAL_NOTE_LONG_TEXT_FLAG |
XXX |
VARCHAR2 |
1 |
IS_CONTROLLED_ACCESS |
XXX |
VARCHAR2 |
1 |
IS_CREATED_ON_WEB |
XXX |
VARCHAR2 |
1 |
IS_EHS_RELATED |
XXX |
VARCHAR2 |
1 |
KEY_APPROVER_EMAIL |
XXX |
VARCHAR2 |
60 |
KEY_APPROVER_KRBNAME |
XXX |
VARCHAR2 |
8 |
KEY_APPROVER_NAME |
XXX |
VARCHAR2 |
60 |
KEY_APPROVER_OFFICE_ADDR |
XXX |
VARCHAR2 |
30 |
KEY_APPROVER_PHONE |
XXX |
VARCHAR2 |
20 |
KEY_RECIPIENT_EMAIL |
XXX |
VARCHAR2 |
60 |
KEY_RECIPIENT_KRBNAME |
XXX |
VARCHAR2 |
8 |
KEY_RECIPIENT_NAME |
XXX |
VARCHAR2 |
60 |
KEY_RECIPIENT_OFFICE_ADDR |
XXX |
VARCHAR2 |
30 |
KEY_RECIPIENT_PHONE |
XXX |
VARCHAR2 |
20 |
LAST_UPDATED_BY_USER |
XXX |
VARCHAR2 |
12 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
|
LAST_UPDATE_TIME |
XXX |
VARCHAR2 |
8 |
LAST_UPDATE_TIMESTAMP |
XXX |
DATE |
|
LOCATION_DESCRIPTION |
XXX |
VARCHAR2 |
30 |
NOTIFICATION_COMPLETION_DATE |
XXX |
DATE |
|
NOTIFICATION_COMPLETION_TIME |
XXX |
VARCHAR2 |
6 |
NOTIFICATION_REFERENCE_DATE |
XXX |
DATE |
|
PREVIOUS_WORK_REQUEST_KEY |
XXX |
NUMBER |
34 |
REQUESTER_EMAIL |
XXX |
VARCHAR2 |
60 |
REQUESTER_KRBNAME |
XXX |
VARCHAR2 |
8 |
REQUESTER_NAME |
XXX |
VARCHAR2 |
60 |
REQUESTER_OFFICE_ADDR |
XXX |
VARCHAR2 |
30 |
REQUESTER_PHONE |
XXX |
VARCHAR2 |
20 |
REQUIRED_END_DATE |
XXX |
DATE |
|
REQUIRED_END_TIME |
XXX |
VARCHAR2 |
6 |
REQUIRED_END_TIMESTAMP |
XXX |
DATE |
|
REQUIRED_START_DATE |
XXX |
DATE |
|
REQUIRED_START_TIME |
XXX |
VARCHAR2 |
6 |
REQUIRED_START_TIMESTAMP |
XXX |
DATE |
|
SYSTEM_STATUS_STRING |
XXX |
VARCHAR2 |
40 |
USER_STATUS_STRING |
XXX |
VARCHAR2 |
40 |
VERSION_NUMBER |
XXX |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WORK_CENTER_KEY |
XXX |
VARCHAR2 |
8 |
WORK_ORDER_CATEGORY_KEY |
XXX |
VARCHAR2 |
7 |
WORK_ORDER_NUMBER |
XXX |
VARCHAR2 |
7 |
WORK_ORDER_PLANNER_GROUP_KEY |
XXX |
VARCHAR2 |
20 |
WORK_REQUEST_ACTIVITY_KEY |
XXX |
VARCHAR2 |
13 |
WORK_REQUEST_CAUSE_KEY |
XXX |
VARCHAR2 |
13 |
WORK_REQUEST_CRAFT_KEY |
XXX |
VARCHAR2 |
13 |
WORK_REQUEST_DAMAGE_KEY |
XXX |
VARCHAR2 |
13 |
WORK_REQUEST_DATE |
XXX |
DATE |
|
WORK_REQUEST_DESCRIPTION |
XXX |
VARCHAR2 |
40 |
WORK_REQUEST_FUNC_LOCATION_KEY |
XXX |
VARCHAR2 |
30 |
WORK_REQUEST_KEY |
XXX |
VARCHAR2 |
7 |
WORK_REQUEST_LOCATION_KEY |
XXX |
VARCHAR2 |
24 |
WORK_REQUEST_NUMBER |
XXX |
VARCHAR2 |
7 |
WORK_REQUEST_PRIORITY |
XXX |
VARCHAR2 |
1 |
WORK_REQUEST_STATUS_KEY |
XXX |
VARCHAR2 |
10 |
WORK_REQUEST_TIME |
XXX |
VARCHAR2 |
6 |
WORK_REQUEST_TIMESTAMP |
XXX |
DATE |
|
WORK_REQUEST_TYPE_KEY |
XXX |
VARCHAR2 |
5 |
WORK_REQUEST_WORK_CATEGORY_KEY |
XXX |
VARCHAR2 |
13 |