| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
CASE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
|
| 3 |
RC_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
CallCenter Category. Used in HD.
|
| 4 |
CATEGORY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Category Description field. Used in Text Tray
|
| 5 |
RC_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
CTD - Type Description
|
| 6 |
RC_DETAIL_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
CTD - Detail Description
|