| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FP_MATRIX_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade Table Type
GEC=Under Contract Grid
GES=Statutory Grid
GFP=Public Service Grid
Prompt Table:
FPMMATXTYP_TBL
|
| 2 |
FP_MATRIX_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Grade Table Code
Prompt Table:
FPMSALMATRX_TBL
|
| 3 |
FP_SCALE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Scale
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 5 |
FP_STEP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Step
|
| 6 |
FP_STEP_NO |
Number(3,0) |
SMALLINT NOT NULL |
Step Number
|
| 7 |
FP_STP_CHV_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking
C=Scale letter / Sub-Step
S=Step
Default Value: S
|
| 8 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step for FPS
|
| 9 |
FP_IN_STP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Length in (Sub)Step
|
| 10 |
FP_IN_STP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Length in Step (Months)
|
| 11 |
FP_IN_STP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Length in Step (Days)
|
| 12 |
FP_NX_STP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Min Lgth for (Sub)Step Incr
|
| 13 |
FP_NX_STP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Min Lgth for Step Incremnt (M)
|
| 14 |
FP_NX_STP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Min Lgth for Step Incremnt (D)
|
| 15 |
FP_STEP_ATTB |
Character(4) |
VARCHAR2(4) NOT NULL |
Step Attribute
E=Exceptionnal
N=Normal
P=Temporary
Default Value: N
|
| 16 |
FP_PR_STP_YR |
Number(2,0) |
SMALLINT NOT NULL |
Theoretical Career Seniority
|
| 17 |
FP_PR_STP_MN |
Number(2,0) |
SMALLINT NOT NULL |
Career Seniority (Months)
|
| 18 |
FP_PR_STP_DY |
Number(2,0) |
SMALLINT NOT NULL |
Career Seniority (Days)
|
| 19 |
FP_AUTO_PROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic (Sub)Step Increment
C=Assorted Advancement
N=No
R=Auto Advancement Requested
Y=Auto Advancement Done
Y/N Table Edit
Default Value: N
|
| 20 |
FP_GROSSIND_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Gross Index Table Code
Default Value: BRUT
Prompt Table:
FPMGROSSIND0_TB
|
| 21 |
FP_GROSS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Gross Index
Prompt Table:
FPMGROSSIND_TBL
|
| 22 |
FP_INCS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index
Prompt Table:
FPMINDEXAMT_VW
|
| 23 |
FP_NX_STP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Next (Sub)Step for Increment
Prompt Table:
FPMSALSTEP_TBL
|
| 24 |
FP_REQ_RTFY_PRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Mdatory Advancement Validation
Y/N Table Edit
Default Value: N
|
| 25 |
FP_ANNL_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Amount
|
| 26 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 27 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|