| # |
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 Rcd Nbr
|
| 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 SetID
|
| 24 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 25 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 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 |
Hours Type
|
| 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 |
Employee on Secondment
Y/N Table Edit
|
| 41 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 42 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Leads to Civil Pension
Y/N Table Edit
Default Value: N
|
| 43 |
FP_SOURCE_ORG |
Character(50) |
VARCHAR2(50) NOT NULL |
Home Organization
|
| 44 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiving Organization
|
| 45 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return
Y/N Table Edit
|
| 46 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position before Return
Prompt Table:
FPMLEGALSTA_TBL
|
| 47 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date
|
| 48 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 49 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancement %
|
| 50 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 51 |
FP_PT_PCT_DET |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time % on Secondment
100=100
50=50
60=60
70=70
80=80
90=90
|
| 52 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number
|
| 53 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Advancement % Service Length
|
| 54 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating AttendanceFlag
Y/N Table Edit
Default Value: N
|
| 55 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Headcount
|
| 56 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Statutory Headcount
|
| 57 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential Full-Time Equivalent
|
| 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 |
Grade Entry Date
|
| 61 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 62 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Corps Change Date
|
| 63 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Civil Service Category
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 64 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category Level
|
| 65 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Period Grade
Y/N Table Edit
|
| 66 |
FP_STEP_END_DT |
Date(10) |
DATE |
(Sub)Step Actual End Date
|
| 67 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
Expected Advancement Date
|
| 68 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Appointment Date
|
| 69 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee
Y/N Table Edit
|
| 70 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period State
A=Rejected
B=None
E=In progress
V=Validated
|
| 71 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
PPd Expected End Date
|
| 72 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction
N=
S=Sanction Extension
Y=Sanction
|
| 73 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Demotion
N=
Y=Downgrading
|
| 74 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application Date
|
| 75 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Index
Y/N Table Edit
|
| 76 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated
Y/N Table Edit
|
| 77 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 78 |
FP_INSTALL_DT |
Date(10) |
DATE |
Installation Date
|
| 79 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step
|
| 80 |
FP_STEP_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Derived Step
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 2
|
| 88 |
FP_PT_PCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time Percentage
050=50
060=60
070=70
080=80
090=90
100=100
|
| 89 |
FP_PT_END_DT |
Date(10) |
DATE |
Part-Time End Date
|
| 90 |
FP_PT_FOREND_DT |
Date(10) |
DATE |
PT Expected End Date
|
| 91 |
FP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 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 |
Retroactivity Code
Y/N Table Edit
|
| 103 |
FP_ROW_END_DT |
Date(10) |
DATE |
JOB Instance End Date
|
| 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
|