| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FPY_WR_POS_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Period of Service ID
|
| 2 |
FPY_PERSON_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Person ID
|
| 3 |
ORG_INSTANCE_ERN |
Number(3,0) |
SMALLINT NOT NULL |
Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce.
Hire, Termination, and Service dates are captured at the Organiational Instance level.
|
| 4 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 5 |
FPY_PROC_MARKER |
Character(36) |
VARCHAR2(36) NOT NULL |
FPY_PROC_MARKER
|
| 6 |
FPY_ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY Error Flag
N=No
Y=Yes
|
| 7 |
FPY_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_MODE
|
| 8 |
FPY_JOB_CI |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_JOB_CI
|
| 9 |
FPY_PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Flag
|
| 10 |
FPY_BYPASS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Flag
|
| 11 |
FPY_ERR_CORR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Required
N=No
Y=Yes
|
| 12 |
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
|
| 13 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 14 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 15 |
ORG_INST_SRV_DT |
Date(10) |
DATE |
Org Instance Service Date
|
| 16 |
PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
|
| 17 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 18 |
FPY_PER_ORG |
Character(120) |
VARCHAR2(120) NOT NULL |
Per Org
|