| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
RB_CHAT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
CRM Chat ID
|
| 4 |
MCF_CHAT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
MCF InitChat ID
|
| 5 |
INTERACTION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
interaction id
|
| 6 |
CUST_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
This field is used to represent the customer name
|
| 7 |
CUSTOMER_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field to track customer value of a person
|
| 8 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 9 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 10 |
BO_ID_CNTCT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field represents the business object ID for a Contact
|
| 11 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 12 |
BO_ID_SITE |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 13 |
TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Association Types
|
| 14 |
RB_PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Definiton of Page name for self-service user
|
| 15 |
RB_CHAT_QUEUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Queue for chat application
|
| 16 |
RB_CHAT_SUBJECT |
Character(40) |
VARCHAR2(40) NOT NULL |
subject field for Chat application ....
|
| 17 |
RB_CHAT_QUESTION |
Long Character |
CLOB |
chat question ...........
|
| 18 |
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.
|
| 19 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 20 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|