| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 2 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP |
Date and Time Stamp
|
| 3 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 4 |
AUDIT_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Name of the record definition audited.
AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
|
| 5 |
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.
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_RC_VR_NONVW
|
| 7 |
DISP_TMPL_FAM_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Display Template Family Code
|
| 8 |
RC_VERTICAL |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk
SW=Support
|
| 9 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Prompt Table:
RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT
|
| 10 |
CASE_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
RC_CNTCT_VW
|
| 11 |
ROLE_TYPE_ID_SITE |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 12 |
BO_ID_ALT_CNCT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Alternate Contact Business Object.
Used in RC_CASE
|
| 13 |
BO_ID_PARTNER |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID of Partner Company.
Prompt Table:
%EDITTABLE36
|
| 14 |
ROLE_TYPE_ID_PART |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner
|
| 15 |
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
|
| 16 |
ROLE_TYPE_ID_PARTC |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the partner contact
|
| 17 |
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.
|
| 18 |
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.
|
| 19 |
BO_ID_CUST_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 20 |
BO_ID_CONTACT_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 21 |
BO_ID_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 22 |
BO_ID_CNT_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID for Bill to Contact
|
| 23 |
PROFILE_CM_SLD_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for the Sold To Address
|
| 24 |
PROFILE_CM_BIL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for Billing
|
| 25 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
Prompt Table:
RC_DEPT_VW
|
| 26 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_VW1
|
| 27 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
|
| 28 |
DISTRIBUTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Purchased From
|
| 29 |
RB_LOCATION_DETAIL |
Character(254) |
VARCHAR2(254) NOT NULL |
RB_LOCATION_DETAIL
|
| 30 |
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
|
| 31 |
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
|
| 32 |
PROFILE_CM_SEQ_PGR |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for a pager number.
|
| 33 |
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
|
| 34 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
|
| 35 |
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.
|
| 36 |
PRIOR_ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
|
| 37 |
ASSIGN_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence number assignment
|
| 38 |
RC_PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
|
| 39 |
RC_ER_ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
|
| 40 |
RC_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_IMPACT_TBL
Set Control Field: BUSINESS_UNIT
|
| 41 |
URGENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Urgency
Prompt Table:
RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT
|
| 42 |
BUS_PROC_INSTANCE |
Number(18,0) |
DECIMAL(18) NOT NULL |
Business Project Instance. This is the Business Project instance of a business project.
|
| 43 |
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
|
| 44 |
CREATION_DATE |
Date(10) |
DATE |
Creation date of the case.
|
| 45 |
CLOSED_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time stamp for when the case status category was changed to closed.
|
| 46 |
CLOSED_BY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is indicate closed by oprid.
|
| 47 |
ERROR_ID |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error ID
|
| 48 |
RC_REOPN_REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Case Reopen Reason Code
Prompt Table:
RC_ROPN_SS_VW
|
| 49 |
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
|
| 50 |
ERROR_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Code
|
| 51 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
|
| 52 |
RC_RESP_DATE |
Date(10) |
DATE |
Response date
|
| 53 |
RC_RESP_TIME |
Time(15) |
TIMESTAMP |
Response Time
|
| 54 |
RC_RESPMET_DATE |
Date(10) |
DATE |
Response Date Met
|
| 55 |
RC_RESPMET_TIME |
Time(15) |
TIMESTAMP |
Response Time Met
|
| 56 |
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
|
| 57 |
RC_REST_DATE |
Date(10) |
DATE |
Restore Date
|
| 58 |
RC_REST_TIME |
Time(15) |
TIMESTAMP |
Restore Time
|
| 59 |
RC_RESTMET_DATE |
Date(10) |
DATE |
Restore Date Met
|
| 60 |
RC_RESTMET_TIME |
Time(15) |
TIMESTAMP |
Restore Time Met
|
| 61 |
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
|
| 62 |
REMOTE_CASE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Remote system case ID. Used to store case unique identify ID from 3rd party system.
|
| 63 |
RB_ANONYMOUS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RB_ANONYMOUS_FLAG
Y/N Table Edit
Default Value: N
|
| 64 |
RB_SITE_NOCUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Site without customer flag
Y/N Table Edit
Default Value: N
|
| 65 |
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
|
| 66 |
GLOBAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Case flag for relationship
Y/N Table Edit
Default Value: N
|
| 67 |
CASE_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Field to capture the case subtype.
Prompt Table:
RC_CASE_SUBTYPE
Set Control Field: BUSINESS_UNIT
|
| 68 |
SALES_ENTRY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
sales entry id
|
| 69 |
TRANSACTION_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction table's primary key.
|
| 70 |
RC_BS_INSTANCE |
Number(15,0) |
DECIMAL(15) NOT NULL |
RC_BS_INSTANCE
|
| 71 |
FORM_INSTANCE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Instance ID
|
| 72 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 73 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table:
%EDIT_TABLE
Set Control Field: BUSINESS_UNIT
|
| 74 |
KEYWORDS |
Character(100) |
VARCHAR2(100) NOT NULL |
Query Keywords
|
| 75 |
ESCALATION_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Escalation Count. Used in Case to register the number of times the case got escalated.
|
| 76 |
ESCALATION_DTTM |
DateTime(26) |
TIMESTAMP |
Escalation Date Time. Used in RC_CASE to register the Date Time of Last Escalation.
|
| 77 |
SURVEY_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Survey Score. This is used in Case Component. To store Survey Score calculated from Branch Script.
|
| 78 |
RC_RED_DTTM |
DateTime(26) |
TIMESTAMP |
The date time that this case will turn Red if it has not yet been resolved.
|
| 79 |
RC_YELLOW_DTTM |
DateTime(26) |
TIMESTAMP |
The date time that this case will turn yellow if it has not yet been resolved.
|
| 80 |
AGR_SELECTED_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time an agreement was selected for the transaction.
|
| 81 |
NOTE_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Note ID
|
| 82 |
ATTACH_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Attachment Sequence Number
|
| 83 |
RSLN_SEQ_NBR |
Number(8,0) |
INTEGER NOT NULL |
Resolution Sequence Number
|
| 84 |
INT_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Interested Parties Sequence No
|
| 85 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 86 |
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
|
| 87 |
SIN |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to represent the Site Identification Number
|
| 88 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 89 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 90 |
BO_ID_SITE |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 91 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 92 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 93 |
SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 94 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 95 |
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)
|
| 96 |
AGREEMENT_LINE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field records the value for the agreement line number
|
| 97 |
WARRANTY_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to store the name of the warranty.
|
| 98 |
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.
|
| 99 |
INST_PROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the installed product ID (key field)
|
| 100 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 101 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency - this field is brought over from HRMS
|
| 102 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the Serial ID of an item or installed product
|
| 103 |
ASSETTAG |
Character(40) |
VARCHAR2(40) NOT NULL |
Asset Tag
|
| 104 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 105 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address type field used in HD_360_RESPONSE_SYNC message.
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other
|
| 106 |
RC_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
|
| 107 |
RC_CONTACT_METHOD |
Character(5) |
VARCHAR2(5) NOT NULL |
Contact Method for the Case
|
| 108 |
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.
|
| 109 |
CM_TYPE_ID |
Number(6,0) |
INTEGER NOT NULL |
Contact Method Type ID
|
| 110 |
CM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|
| 111 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
|
| 112 |
PROBLEM_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Problem Type for Support Cases
|
| 113 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
|
| 114 |
RC_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Status
|
| 115 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
|
| 116 |
RC_SEVERITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
|
| 117 |
RC_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
CallCenter Category. Used in HD.
|
| 118 |
RC_DETAIL |
Character(5) |
VARCHAR2(5) NOT NULL |
Detail field on HD Case. Used in Quick Code.
|
| 119 |
RC_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specialty type. Used on HD case.
|
| 120 |
RES_FIRST_CNTCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resolved by First Contact
Y/N Table Edit
|
| 121 |
CLOSED_DATE |
Date(10) |
DATE |
Date Closed
|
| 122 |
RC_TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Tracking Number Field.
|
| 123 |
RC_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Typically a summary of a long field.
|
| 124 |
RC_VISIBILITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Case Visibility, used for cases and case objects/attributes.
A=All
I=Internal
|
| 125 |
SOLUTION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Solution ID
|
| 126 |
RSLN_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Resolution Summary
|
| 127 |
RSLN_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Resolution Status for Call Center application.
0=Viewed
1=Successful Resolution
2=Waiting on Customer
3=In Consideration
4=Failed Resolution
5=Withdrawn
|
| 128 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 129 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 130 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 131 |
RC_REASON_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Reason Code for Call Center
|
| 132 |
LEAD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
|
| 133 |
SO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Order ID
|
| 134 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 135 |
TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Association Types
|
| 136 |
ISSUE_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Issue visibility
|
| 137 |
ISSUE_VISIBILITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Issue subtype
EXTL=External
INTL=Internal
|
| 138 |
FIN_ACCOUNT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Financial Account Number
|
| 139 |
TARGET_CLOSE_DATE |
Date(10) |
DATE |
Target close date
|
| 140 |
CLAIM_DATE |
Date(10) |
DATE |
Claim Date
|
| 141 |
CLAIM_PAID_DATE |
Date(10) |
DATE |
Claim Paid date
|
| 142 |
EXT_DUE_DATE |
Date(10) |
DATE |
External Due date
|
| 143 |
CASE_VISIBILITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal
|
| 144 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Used to store the identification number for the reason code.
|
| 145 |
BO_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name Description of Business Object
|
| 146 |
RC_DESCRLONG |
Long Character |
CLOB |
Long description used in CallCenter for Problem, Solution...
|