| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FPY_PERSON_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Person ID
|
| 2 |
FPY_PERSON_NUM |
Character(120) |
VARCHAR2(120) NOT NULL |
Person Number
|
| 3 |
FPY_LEGISLATION_CD |
Character(120) |
VARCHAR2(120) NOT NULL |
Legislation Code
|
| 4 |
FPY_START_DTTM |
Character(50) |
VARCHAR2(50) NOT NULL |
Start Date Time
|
| 5 |
FPY_EFF_END_DT |
Character(50) |
VARCHAR2(50) NOT NULL |
Effective End Date
|
| 6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 7 |
FPY_PROC_MARKER |
Character(36) |
VARCHAR2(36) NOT NULL |
FPY_PROC_MARKER
|
| 8 |
FPY_ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY Error Flag
N=No
Y=Yes
|
| 9 |
FPY_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_MODE
|
| 10 |
FPY_JOB_CI |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_JOB_CI
|
| 11 |
FPY_PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Flag
|
| 12 |
FPY_BYPASS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Flag
|
| 13 |
FPY_ERR_CORR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Required
N=No
Y=Yes
|
| 14 |
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
|
| 15 |
FPY_HIGH_EDUCAT_LV |
Character(120) |
VARCHAR2(120) NOT NULL |
Highest Education Level
|
| 16 |
FPY_SEX |
Character(120) |
VARCHAR2(120) NOT NULL |
Gender
|
| 17 |
FPY_MAR_STATUS |
Character(120) |
VARCHAR2(120) NOT NULL |
Marital Status
|
| 18 |
FPY_MAR_STATUS_DT |
Character(100) |
VARCHAR2(100) NOT NULL |
Marital Status Date
|
| 19 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
Default Value: A
|
| 20 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
Default Value: U
|
| 21 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 22 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
Default Value: U
|
| 23 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 24 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|