| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EOCF_ACTION_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Active Analytics Framework Action ID field
|
| 2 |
RES_FIRST_CNTCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resolved by First Contact
Y/N Table Edit
|
| 3 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table:
RC_PRIORITY_TBL
|
| 4 |
URGENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Urgency
Prompt Table:
RC_URGENCY_TBL
|
| 5 |
RC_SEVERITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_SEVERITY_TBL
|
| 6 |
RC_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Case severity
Prompt Table:
RC_IMPACT_TBL
|
| 7 |
RC_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Status
Prompt Table:
RC_STATUS_TBL
|
| 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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_RC_AAF_NONVW
|
| 12 |
QUICK_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Quick Code
Prompt Table:
RC_QUICK_CD_VW
|
| 13 |
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
Y/N Table Edit
Default Value: N
|
| 14 |
RC_RESP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Response flag used in the PAF Case Update action to indicate that this case has been responded to.
Y/N Table Edit
Default Value: N
|
| 15 |
RC_REST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used in PAF configurationt to indicate that this case has been restored.
Y/N Table Edit
Default Value: N
|
| 16 |
RC_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Typically a summary of a long field.
|
| 17 |
LINK_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
This identifies the category that the link will be displayed under
Prompt Table:
RC_LINKCAT_VW
|
| 18 |
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
|
| 19 |
RC_LINK |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
Prompt Table:
RC_LINK_VW
|
| 20 |
KEYWORDS |
Character(100) |
VARCHAR2(100) NOT NULL |
Query Keywords
|
| 21 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Prompt Table:
RC_CASETYPE_TBL
|
| 22 |
CASE_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Field to capture the case subtype.
Prompt Table:
RC_CASE_SUBTYPE
|
| 23 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table:
RF_PROVGRP_VW2
Set Control Field: SETID
|
| 24 |
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: SETID
|
| 25 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table:
%EDITTABLE19
Set Control Field: SETID
|
| 26 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE12
Set Control Field: SETID
|
| 27 |
ERROR_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Code
Prompt Table:
RC_ERROR_TBL
|
| 28 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
Prompt Table:
RC_ERROR_TBL
|
| 29 |
RESOLVE_CASE_ACT |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to determine how to resolve a case for the case update action in PAF.
0001=No Solution
0002=Specific Solution
0003=Update Solutions
0004=Resolve Regardless
Default Value: 0001
|
| 30 |
SOLUTION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Solution ID
Prompt Table:
RC_SOLUTION_VW3
|
| 31 |
SOLUTION_ID1 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Solution ID
Prompt Table:
RC_SOLUTION_VW3
|
| 32 |
TIME1 |
Time(15) |
TIMESTAMP |
This field is used to populate the current time. Common field.
|
| 33 |
UPDATE_DELAY |
Character(1) |
VARCHAR2(1) NOT NULL |
This field contains the delay preference for the Case Update PAF Action.
0=Update Immediately
1=Delay Update
Default Value: 0
|
| 34 |
DELAY_MINUTES |
Number(10,0) |
DECIMAL(10) NOT NULL |
Delay Minutes.....................................
|
| 35 |
REPEAT_TIMES |
Number(3,0) |
SMALLINT NOT NULL |
Repeat the Action for specified number of times
|
| 36 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RB_BNDRECDFN_VW
|
| 37 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFIELD_VW
|
| 38 |
EOCF_LIB_TERM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
a library element that can be evaluated.
NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
Default Value: 0
|
| 39 |
EOCF_CONTEXT_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
the ID value for a configured context
|
| 40 |
EOCF_CONFIG_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
the unique identifier for a phrase definition (ignoring versioning)
Default Value: 0
|
| 41 |
EOCF_PHRASE_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
the unique identifier for a phrase definition (ignoring versioning)
|
| 42 |
EOCF_LIB_TERM_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
the name of the Term in the library
|
| 43 |
EOCF_ACTION_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
user-defined name to identify the characteristics of a particular action
|
| 44 |
EOCF_CTX_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
context name
|
| 45 |
DELAY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Delay Options in AFF Workflow Action setup.
R=Record/Field
T=Term
Default Value: R
|
| 46 |
SLA_SRCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SLA search flag is used to store automatic agreement search options
L=Autoselect Single Longest
M=Show Result Page for Multiples
N=Do not Auto Search
S=Autoselect Single Shortest
Default Value: N
|
| 47 |
SLA_SRCH_OPT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Result further configuration. When search result page is not available, use this field to further define search option.
L=Autoselect Longest
N=Do not Select
S=Autoselect Shortest
Default Value: N
|
| 48 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 49 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 50 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 51 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 52 |
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.
|
| 53 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 54 |
RC_DESCRLONG |
Long Character |
CLOB |
Long description used in CallCenter for Problem, Solution...
|