| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
MESSAGE_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Message Sequence
|
| 3 |
PARENTSEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Parent Sequence
|
| 4 |
CONTEXT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Plan Context. A single number that identifies the node, participant and plan combinations.
|
| 5 |
PERIOD_CONTEXT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Period context
|
| 6 |
RUN_CONTEXT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Field is used to identify information about an EIM job.
|
| 7 |
RUN_INSTANCE |
Number(15,0) |
DECIMAL(15) NOT NULL |
Field identififies instances of EIM process runs.
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 9 |
PLAN_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Plan ID
|
| 10 |
REF_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 11 |
STEP_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Step ID
|
| 12 |
SECTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Section ID for sections in the rule.
|
| 13 |
RULE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Rule ID for plan rules.
|
| 14 |
HCMD_CLASSNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Class name for object descriptors.
|
| 15 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 16 |
ELAPSEDTIME |
Number(9,0) |
DECIMAL(9) NOT NULL |
Elapsed time (in seconds)
|
| 17 |
DYNAMIC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dynamic Flag
|
| 18 |
STATIC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Static Flag
|