| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
FP_ACTION_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Request Reference
|
| 5 |
FP_NOTIF_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Order reference
|
| 6 |
FP_CNL_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled row indicator in case a row is deleted.
Y/N Table Edit
|
| 7 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
|
| 8 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
%RECNAME_EDIT
|
| 9 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 10 |
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
|
| 11 |
FP_LEGALSTAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Civil Service Position Code
Prompt Table:
FPMLEGALSTA_TBL
|
| 12 |
FP_SCNDMT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee on Secondment
Y/N Table Edit
|
| 13 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 14 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Leads to Civil Pension
Y/N Table Edit
Default Value: N
|
| 15 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date
|
| 16 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 17 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancement %
|
| 18 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return
Y/N Table Edit
|
| 19 |
FP_CRT_DOSSIER |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Hire/Re-hire
Y/N Table Edit
|
| 20 |
FP_DEPART_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Terminate Record
Y/N Table Edit
|
| 21 |
FP_POSN_DISCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Vacant Position
|
| 22 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position before Return
|
| 23 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Statutory Headcount
|
| 24 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Headcount
|
| 25 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential Full-Time Equivalent
|
| 26 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating AttendanceFlag
Y/N Table Edit
Default Value: N
|
| 27 |
FP_SETID_CA |
Character(6) |
VARCHAR2(6) NOT NULL |
Public Sector SetID
|
| 28 |
FP_COMM_ACNT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Commitment Acctng Entity ID
|
| 29 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Advancement % Service Length
Prompt Table:
FPMLEGALSTA_TBL
|
| 30 |
FP_INDEBT_ORG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization Code
Prompt Table:
FPMINDBTORG_TBL
|
| 31 |
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
|
| 32 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number
|
| 33 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 34 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiving Organization
Prompt Table:
FPMINDBTORG_TBL
|
| 35 |
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
Default Value: P
|
| 36 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 37 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 38 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retroactivity Code
Y/N Table Edit
|
| 39 |
FP_TBL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Step increment indicator
A=Assignment Table
C=CareerTable
D=Request Table
E=Absence Table
F=Assignment History
G=Statutory Position History
H=Carrer History
I=Other DataTable
J=Premium Hist
K=Work Time History
L=Compensaton History
M=Premium
N=Order Table
O=Contract Table
P=Bonus Table
R=Compensation Table
S=Statutory Position Table
T=Other Data History
U=Bonus History
W=Work Time Table
|
| 40 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|