BUSINESS_UNITDefault Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RC_NONVW
RC_VERTICALHD=HelpDesk
SW=Support
FROM_CASERC_CASE_FROM_VW(SQL View) |
Index Back |
|---|---|
Call Center viewUsed as prompt view on RUN_RCC1008 run control record. |
| SELECT BUSINESS_UNIT , RC_VERTICAL , CASE_ID , RC_STATUS , RC_SUMMARY FROM PS_RC_CASE |
| # | 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_RB.BUSINESS_UNIT Prompt Table: SP_BU_RC_NONVW |
| 2 | RC_VERTICAL |
Character(4) | VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk SW=Support |
| 3 | FROM_CASE |
Number(15,0) | DECIMAL(15) NOT NULL | Case Number |
| 4 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 5 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |