| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
FPY_BO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Object Type
A=All
B=Bonus
C=Company
D=Department
E=Absence
J=Job Data
L=Location
O=Job Code
P=Person Details
S=Position Data
U=Business Unit
|
| 3 |
FPY_BUS_OBJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Object
ABS=Absence
ADD=Person Address
ALL=All
BNS=Bonus
BUS=Business Unit
CCI=Company
CMP=Compensation Data
COM=Company
DCI=Department
DEP=Department
EML=Person Email
JCD=JobCode
JCI=Job Data
JOB=Job Data
LCI=Location
LEG=Person Legislative Data
LOC=Location
NAM=Person Name
NID=Person National Identifier
OCI=JobCode
ORG=Organisation Instance
PCI=Person
PER=Person
PHN=Person Phone
POS=Position
SCI=Position
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
ROW_REFERENCE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
helper fields for H-Grid reference
|
| 6 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 7 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 8 |
FPY_IDENTIFIER |
Character(254) |
VARCHAR2(254) NOT NULL |
Fusion Identifier
|
| 9 |
FPY_KEY_STR1_VAL |
Character(120) |
VARCHAR2(120) NOT NULL |
Key String Value 1
|
| 10 |
FPY_KEY_STR2_VAL |
Character(120) |
VARCHAR2(120) NOT NULL |
Key String Value2
|
| 11 |
FPY_KEY_STR3_VAL |
Character(120) |
VARCHAR2(120) NOT NULL |
Key String value 3
|
| 12 |
FPY_KEY_STR4_VAL |
Character(120) |
VARCHAR2(120) NOT NULL |
Key String Value4
|
| 13 |
FPY_KEY_NUM1_VAL |
Number(20,0) |
DECIMAL(20) NOT NULL |
Key number 1 Value
|
| 14 |
FPY_KEY_NUM2_VAL |
Number(20,0) |
DECIMAL(20) NOT NULL |
Key Number Value 2
|
| 15 |
FPY_KEY_DT1_VAL |
Date(10) |
DATE |
Key Date Value1
|
| 16 |
FPY_KEY_STR1_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key String Field1
|
| 17 |
FPY_KEY_STR2_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key String Field2
|
| 18 |
FPY_KEY_STR3_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key String Field3
|
| 19 |
FPY_KEY_STR4_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key Field String 4
|
| 20 |
FPY_KEY_NUM1_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key Nummer Field 1
|
| 21 |
FPY_KEY_NUM2_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key Field Number 2
|
| 22 |
FPY_KEY_NUM3_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key Number Field
|
| 23 |
FPY_KEY_NUM3_VAL |
Number(3,0) |
SMALLINT NOT NULL |
Key Number Value
|
| 24 |
FPY_KEY_DT1_FLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Key Date Field 1
|
| 25 |
FPY_PS_IDENTIFIER |
Character(120) |
VARCHAR2(120) NOT NULL |
Peoplesoft Identifier
|
| 26 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 27 |
FPY_REQUIRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_REQUIRED_FLAG
N=No
Y=Yes
|
| 28 |
MSG_SEVERITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel
E=Error
M=Message
W=Warning
|
| 29 |
FPY_DESCR |
Long Character |
CLOB |
Description
|