# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
UUID_RAW |
Character(36) |
VARCHAR2(36) NOT NULL |
Universal Unique Identifier - can be used as an identifier when processing a batch of data.
|
2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
3 |
BO_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name Description of Business Object
|
4 |
PRODUCT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Description
|
5 |
PROVIDER_GRP_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Provider Group Name
|
6 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
7 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
|
8 |
RC_PRIORITY_SDESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Priority Short Descr
|
9 |
RC_SHORT_DESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Short Description. Used on may CallCenter set-up tables
|
10 |
RC_AGREEMENT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Agreement Count
|
11 |
RC_WARRANTY_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Warranty Count
|
12 |
RC_NO_RESP_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
No Response Count
|
13 |
RC_NO_REST_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Not Restored Count
|