| # |
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 |
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.
Default Value: RC_CASE.CASE_ID
Prompt Table:
RC_CASE
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RC_CASE.BUSINESS_UNIT
Prompt Table:
SP_BU_RC_NONVW
|
| 5 |
NOTE_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Note ID
Default Value: 1
|
| 6 |
RC_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Typically a summary of a long field.
|
| 7 |
RC_NOTE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Note Types
Prompt Table:
RC_NOTETYPE_TBL
|
| 8 |
RC_NOTE_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Case Notes
A=Outbound - AAF
B=Inbound Notification
I=Internal
N=Outbound - Note
O=Outbound Notification
S=Self Service
U=Outbound - Solution
|
| 9 |
NOTE_CONTACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Note Contact Type is used to see all the Contact persons or Contacts specific to Customer
C=Customer Contact
E=Employee Contact
Default Value: C
Prompt Table:
RC_NOTE_CNT_VW
|
| 10 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 11 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 12 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 13 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 14 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RC_NOTE_HD_VW
|
| 15 |
RSLN_SEQ_NBR |
Number(8,0) |
INTEGER NOT NULL |
Resolution Sequence Number
|
| 16 |
RC_VISIBILITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Case Visibility, used for cases and case objects/attributes.
A=All
I=Internal
Default Value: I
|
| 17 |
MCF_EMAIL_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Email Id
|
| 18 |
CMF_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Correspondence ID
|
| 19 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email address to store the address of email.
|
| 20 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 21 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 22 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 23 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 24 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 25 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 26 |
RC_DESCRLONG |
Long Character |
CLOB |
Long description used in CallCenter for Problem, Solution...
|