BUSINESS_UNIT_WRPrompt Table: SP_BU_WR_NONVW
WR_ID1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
Prompt Table: WM_STATUS_WR
Default Value: %date
WM_WR_WO_SRCH(SQL View) |
Index Back |
|---|---|
Work Request Search viewWork Request Search record definition |
| SELECT BUSINESS_UNIT AS BUSINESS_UNIT_WR , WR_ID , WR_PRIORITY , WR_SUBJECT , STATUS_CD , REQUIRED_DATE , COMPLTED_DT , CLOSED_DATE FROM PS_WM_WR_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_WR |
Character(5) | VARCHAR2(5) NOT NULL |
Work Request Business Unit
Prompt Table: SP_BU_WR_NONVW |
| 2 | WR_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Request ID |
| 3 | WR_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Service Request Priority
1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low |
| 4 | WR_SUBJECT | Character(60) | VARCHAR2(60) NOT NULL | Subject |
| 5 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_WR |
| 6 | REQUIRED_DATE | Date(10) | DATE |
Required By
Default Value: %date |
| 7 | COMPLTED_DT | Date(10) | DATE | Completed Date |
| 8 | CLOSED_DATE | Date(10) | DATE | Service Order Closed Date |