| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FPY_ASG_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Assignment ID
|
| 2 |
FPY_EFFECTIVE_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
Effective Seq
|
| 3 |
FPY_START_DTTM |
Character(50) |
VARCHAR2(50) NOT NULL |
Start Date Time
|
| 4 |
FPY_EFF_END_DT |
Character(50) |
VARCHAR2(50) NOT NULL |
Effective End Date
|
| 5 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
FPY_PROC_MARKER |
Character(36) |
VARCHAR2(36) NOT NULL |
FPY_PROC_MARKER
|
| 7 |
FPY_ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY Error Flag
N=No
Y=Yes
|
| 8 |
FPY_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_MODE
|
| 9 |
FPY_JOB_CI |
Character(1) |
VARCHAR2(1) NOT NULL |
FPY_JOB_CI
|
| 10 |
FPY_PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Flag
|
| 11 |
FPY_BYPASS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Flag
|
| 12 |
FPY_ERR_CORR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Required
N=No
Y=Yes
|
| 13 |
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
|
| 14 |
FPY_EFF_LAST_CHNG |
Character(30) |
VARCHAR2(30) NOT NULL |
Effective last Change
|
| 15 |
FPY_PERSON_NUM |
Character(120) |
VARCHAR2(120) NOT NULL |
Person Number
|
| 16 |
FPY_PERSON_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Person ID
|
| 17 |
FPY_ACTION |
Character(120) |
VARCHAR2(120) NOT NULL |
Action for Job Data
|
| 18 |
FPY_ACTION_REASON |
Character(120) |
VARCHAR2(120) NOT NULL |
Job Action Reason
|
| 19 |
FPY_LEGALENTITY_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field to hold the value of Company coming from Fusion.
|
| 20 |
FPY_LOCATION_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Location Id
|
| 21 |
FPY_POSITION_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Position ID
|
| 22 |
FPY_DEPT_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Dept ID
|
| 23 |
FPY_ASG_PERTYPE_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
FPY_ASG_PERTYPE_ID
|
| 24 |
FPY_JOB_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Job ID
|
| 25 |
FPY_WR_POS_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Period of Service ID
|
| 26 |
FPY_ASG_NUM |
Character(120) |
VARCHAR2(120) NOT NULL |
Assignment Number
|
| 27 |
FPY_TAXADDRESSID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Tax Address ID
|
| 28 |
FPY_PAY_GROUP |
Character(150) |
VARCHAR2(150) NOT NULL |
Pay Group
|
| 29 |
FPY_BARG_UNIT |
Character(120) |
VARCHAR2(120) NOT NULL |
Bargaining Unit
|
| 30 |
FPY_WR_PRI_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fusion Work Relation Primary Flag
|
| 31 |
FPY_ASG_PRI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Assignment Flag
|
| 32 |
FPY_EMPL_TYPE |
Character(120) |
VARCHAR2(120) NOT NULL |
FPY_EMPL_TYPE
|
| 33 |
FPY_PER_ORG |
Character(120) |
VARCHAR2(120) NOT NULL |
Per Org
|
| 34 |
FPY_EMPL_STATUS |
Character(120) |
VARCHAR2(120) NOT NULL |
Employee Status
|
| 35 |
FPY_STD_HRS_FREQ |
Character(120) |
VARCHAR2(120) NOT NULL |
Standard Hrs Frequency
|
| 36 |
FPY_REG_TEMP |
Character(120) |
VARCHAR2(120) NOT NULL |
Reg Temp
|
| 37 |
FPY_PAR_ORG_INST |
Number(3,0) |
SMALLINT NOT NULL |
Parent Org Instance
|
| 38 |
FPY_JOB_INDICATOR |
Character(120) |
VARCHAR2(120) NOT NULL |
Job Indicator
|
| 39 |
FPY_BUSINESS_UNIT |
Character(120) |
VARCHAR2(120) NOT NULL |
Business Unit Name
|
| 40 |
FPY_ZIP_CD_CAN |
Character(20) |
VARCHAR2(20) NOT NULL |
Canada Zip Code
|
| 41 |
FPY_POSTAL_USA |
Character(20) |
VARCHAR2(20) NOT NULL |
Postal Code USA
|
| 42 |
FPY_LEGISLATION_CD |
Character(120) |
VARCHAR2(120) NOT NULL |
Legislation Code
|
| 43 |
FPY_PAYROLL_STATUS |
Character(120) |
VARCHAR2(120) NOT NULL |
Payroll Status
|
| 44 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 45 |
ACTION_DT |
Date(10) |
DATE |
Action Date
|
| 46 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 47 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 48 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 49 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 50 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 51 |
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
|
| 52 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 53 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 54 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 55 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
|
| 56 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 57 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 58 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 59 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 60 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 61 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 62 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 63 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 64 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 65 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 66 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 67 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
|
| 68 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 69 |
JOB_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job
|
| 70 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 71 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Position Data
|
| 72 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 73 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
|
| 74 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 75 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
|
| 76 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 77 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 78 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
|
| 79 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 80 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 81 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 82 |
BENEFIT_SYSTEM |
Character(2) |
VARCHAR2(2) NOT NULL |
A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration
BN=Base Benefits
OT=Not Managed in PeopleSoft
|
| 83 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|