| # |
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 Record
|
| 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 |
Secondment for FPS
Y/N Table Edit
|
| 13 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type for FPS
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 14 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Penison for FPS
Y/N Table Edit
Default Value: N
|
| 15 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date for FPS
|
| 16 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 17 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancment for FPS
|
| 18 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
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 for FPS
|
| 23 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Headcount for FPS
|
| 24 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Nbr for FPS
|
| 25 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential FTE for FPS
|
| 26 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating for FPS
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 |
Duration for FPS
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 |
Work Time for FPS
100=100
50=50
60=60
70=70
80=80
90=90
|
| 32 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number for FPS
|
| 33 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 34 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Rec Organisation for FPS
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 for FPS
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 38 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Activity for FPS
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
|