| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RC_NONVW
|
| 2 |
QUICK_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Quick Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DISP_TMPL_FAM_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Display Template Family Code
Prompt Table:
RDT_TMPL_FAM6VW
|
| 7 |
DISP_TMPL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template identifier to define the display template.
Prompt Table:
RDT_TMPL_DFN2VW
|
| 8 |
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
|
| 9 |
RC_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specialty type. Used on HD case.
Prompt Table:
RC_CTD_TYP_F_VW
Set Control Field: BUSINESS_UNIT
|
| 10 |
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
|
| 11 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table:
RC_PRIORITY_TBL
|
| 12 |
URGENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Urgency
Prompt Table:
RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT
|
| 13 |
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
|
| 14 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table:
RF_GRP_MEM_VW
Set Control Field: BUSINESS_UNIT
|
| 15 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Prompt Table:
RC_CASETYPE_TBL
|
| 16 |
CASE_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Field to capture the case subtype.
Prompt Table:
RC_CASE_SUBTYPE
|
| 17 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table:
%EDITTABLE19
Set Control Field: BUSINESS_UNIT
|
| 18 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE12
Set Control Field: BUSINESS_UNIT
|
| 19 |
PROBLEM_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Problem Type for Support Cases
Prompt Table:
RC_PROBTYPE_TBL
Set Control Field: BUSINESS_UNIT
|
| 20 |
RC_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Typically a summary of a long field.
|
| 21 |
RC_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Status
Prompt Table:
RC_STATUS_TBL
|
| 22 |
RC_SEVERITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_SEVERITY_TBL
|
| 23 |
RC_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_IMPACT_TBL
|
| 24 |
RC_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
Prompt Table:
RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT
|
| 25 |
ERROR_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Code
Prompt Table:
RC_ERROR_TBL
|
| 26 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
Prompt Table:
RC_ERROR_TBL
|
| 27 |
KEYWORDS |
Character(100) |
VARCHAR2(100) NOT NULL |
Query Keywords
|
| 28 |
LINK_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
This identifies the category that the link will be displayed under
Prompt Table:
RC_LINKCAT_VW
|
| 29 |
LINK_VERSION |
Character(4) |
VARCHAR2(4) NOT NULL |
Version of Human Resource Management System application.
12.1=EBS 12.1
8.0=8.0 SP1
8.3=8.3
8.8=8.8
8.9=8.9
9.0=9.0
9.1=9.1
9.2=9.2
OTH=Other
Prompt Table:
RC_CATVER_VW
|
| 30 |
RC_LINK |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
Prompt Table:
RC_LINK_VW
|
| 31 |
ASSIGNED_TO_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case assigned To Overwrite
Y/N Table Edit
Default Value: N
|
| 32 |
CASE_SUBTYPE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case SubType Overwrite
Y/N Table Edit
Default Value: N
|
| 33 |
CASE_TYPE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Type Overwrite
Y/N Table Edit
Default Value: N
|
| 34 |
ERROR_CODE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Error Code Overwrite
Y/N Table Edit
Default Value: N
|
| 35 |
KEYWORDS_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Keywords Overwrite
Y/N Table Edit
Default Value: N
|
| 36 |
PRODUCT_GROUP_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Product Group Overwrite
Y/N Table Edit
Default Value: N
|
| 37 |
PRODUCT_ID_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Product ID Overwrite
Y/N Table Edit
Default Value: N
|
| 38 |
PROBLEM_TYPE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Problem Type Overwrite
Y/N Table Edit
Default Value: N
|
| 39 |
PROVIDER_GRP_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Provider Group Overwrite
Y/N Table Edit
Default Value: N
|
| 40 |
RC_CATEGORY_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Category Overwrite
Y/N Table Edit
Default Value: N
|
| 41 |
RC_DESCRLONG_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Long Description Overwrite
Y/N Table Edit
Default Value: N
|
| 42 |
RC_DETAIL_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Detail Overwrite
Y/N Table Edit
Default Value: N
|
| 43 |
RC_IMPACT_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Impact Overwrite
Y/N Table Edit
Default Value: N
|
| 44 |
RC_SOURCE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Source Overwrite
Y/N Table Edit
Default Value: N
|
| 45 |
RC_LINK_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Related Actions Overwrite
Y/N Table Edit
Default Value: N
|
| 46 |
RC_PRIORITY_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Priority Overwrite
Y/N Table Edit
Default Value: N
|
| 47 |
URGENCY_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Urgency Overwrite
Y/N Table Edit
Default Value: N
|
| 48 |
RC_SEVERITY_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Severity Overwrite
Y/N Table Edit
Default Value: N
|
| 49 |
RC_STATUS_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Status Overwrite
Y/N Table Edit
Default Value: N
|
| 50 |
RC_SUMMARY_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Summary Overwrite
Y/N Table Edit
Default Value: N
|
| 51 |
RC_TYPE_OW |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Type Overwrite
Y/N Table Edit
Default Value: N
|
| 52 |
SOLUTION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Solution ID
Prompt Table:
RC_SOLUTIONDVW2
|
| 53 |
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
|
| 54 |
RC_QC_USAGECOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Usage Count for Quick Code usage by Case (HRHD)
Default Value: 0
|
| 55 |
RC_QC_LASTUSED |
Date(10) |
DATE |
Qucik Code Last Used Date
|
| 56 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 57 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 58 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 59 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 60 |
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.
|
| 61 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 62 |
RC_DESCRLONG |
Long Character |
CLOB |
Long description used in CallCenter for Problem, Solution...
|