| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
FP_CONVERSION_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Reclassification ID
|
| 6 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 7 |
FP_CONV_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Conversion Status
A=None
S=Simulated Reclassification
V=Validated Reclassification
|
| 8 |
FP_ACTION_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Request Reference
|
| 9 |
FP_NOTIF_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Order reference
|
| 10 |
FP_CNL_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled row indicator in case a row is deleted.
Y/N Table Edit
Default Value: N
|
| 11 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
Default Value: R
|
| 12 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
%RECNAME_EDIT
|
| 13 |
FP_ACTION_DES |
Character(30) |
VARCHAR2(30) NOT NULL |
Action Description
|
| 14 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 15 |
FP_RANK_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Grade
Prompt Table:
FPMRANK_TBL
|
| 16 |
FP_RANK_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
Grade Description
|
| 17 |
FP_STEP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Step
Prompt Table:
FPMSALSTEP_TBL
|
| 18 |
FP_STEP_NO |
Number(3,0) |
SMALLINT NOT NULL |
Step Number
|
| 19 |
FP_GROSS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Gross Index
|
| 20 |
FP_INCS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index
|
| 21 |
FP_PROM_LCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Advancement Locked in
Y/N Table Edit
Default Value: N
|
| 22 |
FP_SENTOSTPDY |
Number(2,0) |
SMALLINT NOT NULL |
Career Sen Step Incrmnt (D)
|
| 23 |
FP_SENTOSTPMN |
Number(2,0) |
SMALLINT NOT NULL |
Career Sen Step Incrmnt (M)
|
| 24 |
FP_SENTOSTPYR |
Number(2,0) |
SMALLINT NOT NULL |
Career Sen Step Incrmnt (Y)
|
| 25 |
FP_SENINSTPDY |
Number(2,0) |
SMALLINT NOT NULL |
Career Seniority in Scale (D)
|
| 26 |
FP_SENINSTPMN |
Number(2,0) |
SMALLINT NOT NULL |
Career Seniority in Scale (M)
|
| 27 |
FP_SENINSTPYR |
Number(2,0) |
SMALLINT NOT NULL |
Career Seniority in Scale (Y)
|
| 28 |
FP_TRUESEN_DY |
Number(2,0) |
SMALLINT NOT NULL |
Step Actual Seniority (D)
|
| 29 |
FP_TRUESEN_MN |
Number(2,0) |
SMALLINT NOT NULL |
Step Actual Seniority (M)
|
| 30 |
FP_TRUESEN_YR |
Number(2,0) |
SMALLINT NOT NULL |
Actual Step Seniority (Y)
|
| 31 |
FP_SENTRANSDY |
Number(2,0) |
SMALLINT NOT NULL |
Sen to be Carried Over (D)
|
| 32 |
FP_SENTRANSMN |
Number(2,0) |
SMALLINT NOT NULL |
Sen to be Carried Over (M)
|
| 33 |
FP_SENTRANSYR |
Number(2,0) |
SMALLINT NOT NULL |
Sen to be Carried Over (Y)
|
| 34 |
FP_SENKEPT_DY |
Number(2,0) |
SMALLINT NOT NULL |
Credited Seniority (D)
|
| 35 |
FP_SENKEPT_MN |
Number(2,0) |
SMALLINT NOT NULL |
Credited Seniority (M)
|
| 36 |
FP_SENKEPT_YR |
Number(2,0) |
SMALLINT NOT NULL |
Credited Seniority (Y)
|
| 37 |
FP_SENRAN_DY |
Number(2,0) |
SMALLINT NOT NULL |
Grade Actual Seniority (D)
|
| 38 |
FP_SENRAN_MN |
Number(2,0) |
SMALLINT NOT NULL |
Grade Actual Seniority (M)
|
| 39 |
FP_SENRAN_YR |
Number(2,0) |
SMALLINT NOT NULL |
Actual Grade Seniority
|
| 40 |
FP_SENCOR_DY |
Number(2,0) |
SMALLINT NOT NULL |
Actual Corps Seniority (D)
|
| 41 |
FP_SENCOR_MN |
Number(2,0) |
SMALLINT NOT NULL |
Actual Corps Seniority (M)
|
| 42 |
FP_SENCOR_YR |
Number(2,0) |
SMALLINT NOT NULL |
Actual Corps Seniority (Y)
|
| 43 |
FP_DURSTEP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Step Service Length (Days)
|
| 44 |
FP_DURSTEP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Step Service Length (Months)
|
| 45 |
FP_DURSTEP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Step Service Length (Years)
|
| 46 |
FP_DURRAN_DY |
Number(2,0) |
SMALLINT NOT NULL |
Grade Service Length (Days)
|
| 47 |
FP_DURRAN_MN |
Number(2,0) |
SMALLINT NOT NULL |
Grade Service Length (Months)
|
| 48 |
FP_DURRAN_YR |
Number(2,0) |
SMALLINT NOT NULL |
Grade Service Length (Years)
|
| 49 |
FP_DURCOR_DY |
Number(2,0) |
SMALLINT NOT NULL |
Corps Service Length (Days)
|
| 50 |
FP_DURCOR_MN |
Number(2,0) |
SMALLINT NOT NULL |
Corps Service Length (Months)
|
| 51 |
FP_DURCOR_YR |
Number(2,0) |
SMALLINT NOT NULL |
Corps Service Length (Y)
|
| 52 |
FP_SENEQSTP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Actual Scale Seniority (D)
|
| 53 |
FP_SENEQSTP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Actual Scale Seniority (M)
|
| 54 |
FP_SENEQSTP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Actual Scale Seniority (Y)
|
| 55 |
FP_SENENTRK_DY |
Number(2,0) |
SMALLINT NOT NULL |
Grade Entry Seniority (D)
|
| 56 |
FP_SENENTRK_MN |
Number(2,0) |
SMALLINT NOT NULL |
Grade Entry Seniority (M)
|
| 57 |
FP_SENENTRK_YR |
Number(2,0) |
SMALLINT NOT NULL |
Grade Entry Seniority (Y)
|
| 58 |
FP_SENENTCRP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Corps Entry Seniority (D)
|
| 59 |
FP_SENENTCRP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Corps Entry Seniority (M)
|
| 60 |
FP_SENENTCRP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Corps Entry Seniority (Y)
|
| 61 |
FP_SENENTCTG_DY |
Number(2,0) |
SMALLINT NOT NULL |
Catgy Entry Seniority (D)
|
| 62 |
FP_SENENTCTG_MN |
Number(2,0) |
SMALLINT NOT NULL |
Catgy Entry Seniority (M)
|
| 63 |
FP_SENENTCTG_YR |
Number(2,0) |
SMALLINT NOT NULL |
Catgy Entry Seniority (Y)
|
| 64 |
FP_SEN_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Seniority Calculation
Y/N Table Edit
Default Value: Y
|
| 65 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated for FPS
Y/N Table Edit
Default Value: N
|
| 66 |
FP_CLD_STEP |
Character(1) |
VARCHAR2(1) NOT NULL |
(Sub)Step Terminated
Y/N Table Edit
Default Value: N
|
| 67 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
From Date for FPS
|
| 68 |
FP_STEP_END_DT |
Date(10) |
DATE |
Step Actual End Date for FPS
|
| 69 |
FP_RK_ENT_DT |
Date(10) |
DATE |
Date Entry for FPS
|
| 70 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
|
| 71 |
FP_CORPS_DES |
Character(30) |
VARCHAR2(30) NOT NULL |
Corps Description
|
| 72 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Change Date for FPS
|
| 73 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Category for FPS
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 74 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee for FPS
Y/N Table Edit
Default Value: N
|
| 75 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period state for FPS
A=Rejected
B=None
E=In progress
V=Validated
Default Value: B
|
| 76 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category level for FPS
|
| 77 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Indiex for FPS
Y/N Table Edit
|
| 78 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application for FPS
|
| 79 |
FP_ROW_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Row Origin Code
A=Automatic
M=Manual
Default Value: M
|
| 80 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Nomination Date for FPS
|
| 81 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Date for FPS
Y/N Table Edit
Default Value: N
|
| 82 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
Expected Date for FPS
|
| 83 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction for FPS
N=
S=Sanction Extension
Y=Sanction
Default Value: N
|
| 84 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Grade for FPS
N=
Y=Downgrading
Default Value: N
|
| 85 |
FP_UPDT_PR_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Modify Advancement Date
N=
Y=Modify Advancement Date
Default Value: N
|
| 86 |
FP_PROM_OK |
Character(1) |
VARCHAR2(1) NOT NULL |
Advancement Flag
Y/N Table Edit
Default Value: N
|
| 87 |
FP_PROPD_BRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Promo Prob Period Suspension
Y/N Table Edit
Default Value: N
|
| 88 |
FP_PRO_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Access Mode
C=Competition
P=Advancement
|
| 89 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
|
| 90 |
FP_NX_STP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Next (Sub)Step for Increment
|
| 91 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step for FPS
|
| 92 |
FP_STFBDG_LVL1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Section
EM=Labor
LG=Housing
S1=Sector 1
S2=Sector 2
SL=Solidarity
TO=Tourism
TR=Transportation
|
| 93 |
FP_STFBDG_LVL3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Article
00=Test Test
01=Minister and Secretaryof State
02=National Headquarters
10=Decentralized Services
91=Ministry (test)
92=National Headquarters
93=Decentralized Services
98=Special
|
| 94 |
FP_SETID_CA |
Character(6) |
VARCHAR2(6) NOT NULL |
Public Sector SetID
|
| 95 |
FP_COMM_ACNT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Commitment Acctng Entity ID
|
| 96 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Activity for FPS
Y/N Table Edit
Default Value: N
|
| 97 |
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
Default Value: C
|
| 98 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|