| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
|
| 6 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 7 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 8 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 10 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 11 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 12 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 13 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 14 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 15 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 16 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 17 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 18 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 19 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 20 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Position Data
Y/N Table Edit
|
| 21 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
Y/N Table Edit
|
| 22 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 23 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 24 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 25 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 26 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 27 |
HOURLY_RT_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
HFR
|
| 28 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 29 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
|
| 30 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 31 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 32 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate
|
| 33 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 34 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 36 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 37 |
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
|
| 38 |
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
|
| 39 |
FP_LEGALSTAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Civil Service Position Code.
Prompt Table:
FPMLEGALSTA_TBL
|
| 40 |
FP_SCNDMT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment for FPS
Y/N Table Edit
|
| 41 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type for FPS
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 42 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Penison for FPS
Y/N Table Edit
Default Value: N
|
| 43 |
FP_SOURCE_ORG |
Character(50) |
VARCHAR2(50) NOT NULL |
Home Organisation for FPS
|
| 44 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Rec Organisation for FPS
|
| 45 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
Y/N Table Edit
|
| 46 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position for FPS
Prompt Table:
FPMLEGALSTA_TBL
|
| 47 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date for FPS
|
| 48 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 49 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancment for FPS
|
| 50 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status for FPS
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 51 |
FP_PT_PCT_DET |
Character(3) |
VARCHAR2(3) NOT NULL |
Work Time for FPS
100=100
50=50
60=60
70=70
80=80
90=90
|
| 52 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number for FPS
|
| 53 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Duration for FPS
|
| 54 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating for FPS
Y/N Table Edit
Default Value: N
|
| 55 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Nbr for FPS
|
| 56 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Headcount for FPS
|
| 57 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential FTE for FPS
|
| 58 |
FP_RANK_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Grade
Prompt Table:
FPMRANK_TBL
|
| 59 |
FP_STEP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Step
Prompt Table:
FPMSALSTEP_TBL
|
| 60 |
FP_RK_ENT_DT |
Date(10) |
DATE |
Date Entry for FPS
|
| 61 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 62 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Change Date for FPS
|
| 63 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Category for FPS
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 64 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category level for FPS
|
| 65 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Date for FPS
Y/N Table Edit
|
| 66 |
FP_STEP_END_DT |
Date(10) |
DATE |
Step Actual End Date for FPS
|
| 67 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
From Date for FPS
|
| 68 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Nomination Date for FPS
|
| 69 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee for FPS
Y/N Table Edit
|
| 70 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period state for FPS
A=Rejected
B=None
E=In progress
V=Validated
|
| 71 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
Expected Date for FPS
|
| 72 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction for FPS
N=
S=Sanction Extension
Y=Sanction
|
| 73 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Grade for FPS
N=
Y=Downgrading
|
| 74 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application for FPS
|
| 75 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Indiex for FPS
Y/N Table Edit
|
| 76 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated for FPS
Y/N Table Edit
|
| 77 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
|
| 78 |
FP_INSTALL_DT |
Date(10) |
DATE |
Installation Date
|
| 79 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step for FPS
|
| 80 |
FP_STEP_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Step for FPS
Prompt Table:
FPMSALSTEP_TBL
|
| 81 |
FP_BUSINESS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupation Code
Prompt Table:
FPMBUISNESS_TBL
|
| 82 |
FP_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 83 |
FP_CHG_SAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Salary
Y/N Table Edit
|
| 84 |
FP_POINTYP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Point Type Code
Prompt Table:
FPMPOINTYP_TBL
|
| 85 |
FP_GROSS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Gross Index
|
| 86 |
FP_INCS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index
|
| 87 |
FP_INCS_IND2 |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index for FPS
|
| 88 |
FP_PT_PCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Part Time Percentage for FPS
050=50
060=60
070=70
080=80
090=90
100=100
|
| 89 |
FP_PT_END_DT |
Date(10) |
DATE |
Part Time End date for FPS
|
| 90 |
FP_PT_FOREND_DT |
Date(10) |
DATE |
Expected End Date for FPS
|
| 91 |
FP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Field for FPS
|
| 92 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
|
| 93 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
Default Value: OT
|
| 94 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_VW
|
| 95 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
%EDITTABLE6
|
| 96 |
GP_DFLT_ELIG_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
Y/N Table Edit
Default Value: Y
|
| 97 |
GP_ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Eligibility Group
Prompt Table:
GP_ELIG_GRP
|
| 98 |
GP_DFLT_CURRTTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
Y/N Table Edit
Default Value: Y
|
| 99 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 100 |
GP_DFLT_EXRTDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
Y/N Table Edit
Default Value: Y
|
| 101 |
GP_ASOF_DT_EXG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a flag to determine whether to use a default exchange rate or not.
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date
|
| 102 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Activity for FPS
Y/N Table Edit
|
| 103 |
FP_ROW_END_DT |
Date(10) |
DATE |
Job Instance End date for FPS
|
| 104 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 105 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
Y/N Table Edit
Default Value: N
|