| # |
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: 999999999999999
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_RC_VR_NONVW
|
| 5 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
|
| 6 |
PROFILE_CM_SEQ_PHN |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for a phone number.
Prompt Table:
RC_PHONE_VW1
|
| 7 |
PROFILE_CM_SEQ_EML |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for a email address.
Prompt Table:
RC_EMAIL_VW1
|
| 8 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table:
RC_GRP_MEM_VW
Set Control Field: BUSINESS_UNIT
|
| 9 |
RC_TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Tracking Number Field.
|
| 10 |
CASE_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Field to capture the case subtype.
Prompt Table:
RC_CASE_SUBTYPE
Set Control Field: BUSINESS_UNIT
|
| 11 |
CASE_VISIBILITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal
Default Value: EXTL
|
| 12 |
FIN_ACCOUNT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Financial Account Number
Prompt Table:
RBF_FIN_ACCOUNT
|
| 13 |
DISP_TMPL_FAM_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Display Template Family Code
|
| 14 |
RC_VERTICAL |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk
SW=Support
|
| 15 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 16 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Default Value: BUS_UNIT_DEF_VW.CASE_TYPE
Prompt Table:
RC_CASETYPE_TBL
|
| 17 |
PERSON_PIN |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to store the Personal Identification Number of a person for use in agreements
Prompt Table:
RC_PIN_VW3
|
| 18 |
SIN |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to represent the Site Identification Number
Prompt Table:
RC_SIN_VW2
|
| 19 |
CASE_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
RC_CNTCT_VW
|
| 20 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
Prompt Table:
BO
|
| 21 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
Prompt Table:
BO_ROLE_TYPE
|
| 22 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
Prompt Table:
BO_ROLE_TYPE
|
| 23 |
BO_ID_SITE |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table:
RC_CUST_SITE_VW
|
| 24 |
ROLE_TYPE_ID_SITE |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 25 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
Prompt Table:
BO
|
| 26 |
BO_ID_ALT_CNCT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Alternate Contact Business Object.
Used in RC_CASE
|
| 27 |
BO_ID_PARTNER |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID of Partner Company.
Prompt Table:
RC_PTNR_SRCH_VW
|
| 28 |
ROLE_TYPE_ID_PART |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner
|
| 29 |
BO_ID_PART_CONT |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
This is the business object identifier for the partner contact.
Prompt Table:
RC_PTNR_REPS_VW
|
| 30 |
ROLE_TYPE_ID_PARTC |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner contact
|
| 31 |
BO_ID_REPORTED_BY |
Number(31,0) |
DECIMAL(31) NOT NULL |
Reported By Field. This is used in Case Record to store BO_ID of Reported By Person.
|
| 32 |
ROLE_TYPE_ID_RPTBY |
Number(12,0) |
DECIMAL(12) NOT NULL |
Reported By Field. This is used in Case Record to store ROLE_TYPE_ID of Reported By Person.
|
| 33 |
BO_ID_CUST_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 34 |
BO_ID_CONTACT_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 35 |
BO_ID_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 36 |
BO_ID_CNT_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID for Bill to Contact
|
| 37 |
PROFILE_CM_SLD_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for the Sold To Address
|
| 38 |
PROFILE_CM_BIL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for Billing
|
| 39 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
Prompt Table:
RC_DEPT_VW
|
| 40 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_VW1
|
| 41 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 42 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
|
| 43 |
AGREEMENT_LINE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field records the value for the agreement line number
|
| 44 |
WARRANTY_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to store the name of the warranty.
|
| 45 |
RC_PAY_FOR_SVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag determines if "pay for service" is applicable for a support case. By default this is applicable unless otherwise the selected entitlement (agreement/warranty) determines it is not necessary.
Y/N Table Edit
Default Value: N
|
| 46 |
INST_PROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the installed product ID (key field)
Prompt Table:
%EDITTABLE15
|
| 47 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
|
| 48 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the Serial ID of an item or installed product
Prompt Table:
%EDITTABLE14
|
| 49 |
ASSETTAG |
Character(40) |
VARCHAR2(40) NOT NULL |
Asset Tag
Prompt Table:
%EDITTABLE17
|
| 50 |
DISTRIBUTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Purchased From
|
| 51 |
RC_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
Default Value: BUS_UNIT_DEF_VW.RC_SOURCE
Prompt Table:
RC_SOURCE_TBL
|
| 52 |
RC_CONTACT_METHOD |
Character(5) |
VARCHAR2(5) NOT NULL |
Contact Method for the Case
|
| 53 |
RC_CONTACT_INFO |
Character(70) |
VARCHAR2(70) NOT NULL |
This field displays the phone number with extension or email address based on the selection (phone/email) from the case page (support/helpdesk). If the user has overridden the value displayed then this is stored on the case record.
|
| 54 |
CM_TYPE_ID |
Number(6,0) |
INTEGER NOT NULL |
Contact Method Type ID
Prompt Table:
RC_CM_TYPE
|
| 55 |
CM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|
| 56 |
RB_LOCATION_DETAIL |
Character(254) |
VARCHAR2(254) NOT NULL |
RB_LOCATION_DETAIL
|
| 57 |
PROFILE_CM_SEQ_ADD |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field is used to store the profile contact method sequence number for an address.
Prompt Table:
RC_ADDRESS_VW2
|
| 58 |
PROFILE_CM_SEQ_PGR |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for a pager number.
|
| 59 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
|
| 60 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table:
RF_PROVGRP_VW2
Set Control Field: BUSINESS_UNIT
|
| 61 |
PRIOR_PRVDR_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
PRIOR PROVIDER GROUP ID field is used to store prior value of the Provider Group.
|
| 62 |
PRIOR_ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
|
| 63 |
RC_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Status
Default Value: BUS_UNIT_DEF_VW.RC_STATUS
Prompt Table:
RC_STATUS_TBL
|
| 64 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
Default Value: BUS_UNIT_DEF_VW.RC_PRIORITY
Prompt Table:
RC_PRIORITY_TBL
|
| 65 |
RC_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_IMPACT_TBL
|
| 66 |
URGENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Urgency
Prompt Table:
RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT
|
| 67 |
RC_SEVERITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Default Value: BUS_UNIT_DEF_VW.RC_SEVERITY
Prompt Table:
RC_SEVERITY_TBL
|
| 68 |
BUS_PROC_INSTANCE |
Number(18,0) |
DECIMAL(18) NOT NULL |
Business Project Instance. This is the Business Project instance of a business project.
|
| 69 |
RC_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
CallCenter Category. Used in HD.
Prompt Table:
RC_CTD_CAT_F_VW
Set Control Field: BUSINESS_UNIT
|
| 70 |
RC_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specialty type. Used on HD case.
Prompt Table:
RC_CTD_TYP_VW
Set Control Field: BUSINESS_UNIT
|
| 71 |
RC_DETAIL |
Character(5) |
VARCHAR2(5) NOT NULL |
Detail field on HD Case. Used in Quick Code.
Prompt Table:
RC_CTD_DET_F_VW
Set Control Field: BUSINESS_UNIT
|
| 72 |
PROBLEM_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Problem Type for Support Cases
Prompt Table:
RC_PROBTYPE_TBL
Set Control Field: BUSINESS_UNIT
|
| 73 |
RC_FIRST_CONTACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marked Y if the case is resolved on the first call.
Y/N Table Edit
Default Value: Y
|
| 74 |
RES_FIRST_CNTCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resolved by First Contact
Y/N Table Edit
Default Value: N
|
| 75 |
CREATION_DATE |
Date(10) |
DATE |
Creation date of the case.
|
| 76 |
CLOSED_DATE |
Date(10) |
DATE |
Date Closed
|
| 77 |
CLOSED_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time stamp for when the case status category was changed to closed.
|
| 78 |
CLOSED_BY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is indicate closed by oprid.
|
| 79 |
RC_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Typically a summary of a long field.
|
| 80 |
ERROR_ID |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error ID
|
| 81 |
RC_REOPN_REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Case Reopen Reason Code
Prompt Table:
RC_ROPN_SS_VW
|
| 82 |
RC_CLOSE_REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Case Close Reason Code. This is being used in SS
Prompt Table:
RC_CLOSE_SS_VW
|
| 83 |
ERROR_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Code
|
| 84 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
|
| 85 |
RC_RESP_DATE |
Date(10) |
DATE |
Response date
|
| 86 |
RC_RESP_TIME |
Time(15) |
TIMESTAMP |
Response Time
|
| 87 |
RC_RESPMET_DATE |
Date(10) |
DATE |
Response Date Met
|
| 88 |
RC_RESPMET_TIME |
Time(15) |
TIMESTAMP |
Response Time Met
|
| 89 |
RC_RESP_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
Response Indicator, to indicate different stage of response for SLA.
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
Default Value: NA
|
| 90 |
RC_REST_DATE |
Date(10) |
DATE |
Restore Date
|
| 91 |
RC_REST_TIME |
Time(15) |
TIMESTAMP |
Restore Time
|
| 92 |
RC_RESTMET_DATE |
Date(10) |
DATE |
Restore Date Met
|
| 93 |
RC_RESTMET_TIME |
Time(15) |
TIMESTAMP |
Restore Time Met
|
| 94 |
RC_REST_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
Restore Indicator, indicate different stage of restore for SLA
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
Default Value: NA
|
| 95 |
REMOTE_CASE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Remote system case ID. Used to store case unique identify ID from 3rd party system.
|
| 96 |
RB_ANONYMOUS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RB_ANONYMOUS_FLAG
Y/N Table Edit
Default Value: N
|
| 97 |
RB_SITE_NOCUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Site without customer flag
Y/N Table Edit
Default Value: N
|
| 98 |
SECURE_CASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes
Default Value: N
|
| 99 |
GLOBAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Case flag for relationship
Y/N Table Edit
Default Value: N
|
| 100 |
TARGET_CLOSE_DATE |
Date(10) |
DATE |
Target close date
|
| 101 |
SALES_ENTRY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
sales entry id
|
| 102 |
TRANSACTION_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction table's primary key.
|
| 103 |
RC_BS_INSTANCE |
Number(15,0) |
DECIMAL(15) NOT NULL |
RC_BS_INSTANCE
|
| 104 |
FORM_INSTANCE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Instance ID
|
| 105 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 106 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table:
RCF_BILL_AC_VW2
|
| 107 |
KEYWORDS |
Character(100) |
VARCHAR2(100) NOT NULL |
Query Keywords
|
| 108 |
ESCALATION_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Escalation Count. Used in Case to register the number of times the case got escalated.
|
| 109 |
ESCALATION_DTTM |
DateTime(26) |
TIMESTAMP |
Escalation Date Time. Used in RC_CASE to register the Date Time of Last Escalation.
|
| 110 |
SURVEY_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Survey Score. This is used in Case Component. To store Survey Score calculated from Branch Script.
|
| 111 |
RC_RED_DTTM |
DateTime(26) |
TIMESTAMP |
The date time that this case will turn Red if it has not yet been resolved.
|
| 112 |
RC_YELLOW_DTTM |
DateTime(26) |
TIMESTAMP |
The date time that this case will turn yellow if it has not yet been resolved.
|
| 113 |
AGR_SELECTED_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time an agreement was selected for the transaction.
|
| 114 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 115 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 116 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 117 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 118 |
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.
|
| 119 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 120 |
RC_DESCRLONG |
Long Character |
CLOB |
Long description used in CallCenter for Problem, Solution...
|