BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: LOCATION_TBL
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
Default Value: 3
BUS_UNIT_TBL_WR(SQL Table) |
Index Back |
|---|---|
Service Request Business UnitService Request Business Unit definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | WR_LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Service Location
Prompt Table: LOCATION_TBL |
| 3 | WR_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Service Request Priority
1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low Default Value: 3 |
| 4 | WR_CLOSE_DAYS | Number(4,0) | SMALLINT NOT NULL | Days To Close After Complete |