| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RC_BUS_PROCESS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Business Process ID used in Business Process tracking.
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
Default Value: 1
|
| 4 |
SOURCE_PHASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Phase
Prompt Table:
RC_SRC_PHASE_VW
|
| 5 |
TARGET_PHASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Phase
Prompt Table:
RC_ACTIVITY_VW
|
| 6 |
RC_COMPLETE_SUCCES |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Source Activity exit criteria option.... "All tasks complete and successful". This means that all the required Tasks attached to this State have been executed and all of them returned a result signifying success.
Y/N Table Edit
Default Value: N
|
| 7 |
RC_COMPLETE_1_FAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Source Activity exit criteria option.... "All tasks complete but at least one failed". This means that all the required Tasks attached to this State have completed their execution and one or more Tasks have returned a result signifying failure.
Y/N Table Edit
Default Value: N
|
| 8 |
RC_NO_COMP_1_FAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Source Activity exit criteria option.... "All tasks not complete but one failed". This means that one of the required Tasks have completed its execution before the other Tasksk and has returned a result signifying failure. The other required Tasks have not completed their execution and are still being executed.
Y/N Table Edit
Default Value: N
|
| 9 |
RC_TIMED_NO_COMPLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Task not completed in timeFor Business Projects
Y/N Table Edit
Default Value: N
|
| 10 |
DEFAULT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Election
Y/N Table Edit
Default Value: N
|
| 11 |
AUTOMATIC |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a flag for Business Process tracking to indicate whether a transition is Automatic or Manual.
A=Automatic
M=Manual
Default Value: A
|
| 12 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 13 |
SYSD_APPLICATION01 |
Character(1) |
VARCHAR2(1) NOT NULL |
PS CRM Core
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 16 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 17 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 18 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 19 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 20 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 21 |
SYSD_APPLICATION09 |
Character(1) |
VARCHAR2(1) NOT NULL |
System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
SYSD_APPLICATION10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Application 10
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|