FPMPROMTABL_TBL(SQL Table) |
Index Back |
|---|---|
Source and Target GradesThis table stores all the possible combinations of Source and Target Grades. It is used by the French Public Sector functionalities. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FP_THRUDATE |
Date(10) | DATE NOT NULL | Starting Date |
| 2 | FP_SETID_RANK |
Character(5) | VARCHAR2(5) NOT NULL |
Set ID
Prompt Table: SETID_TBL |
| 3 | FP_RANK_START |
Character(6) | VARCHAR2(6) NOT NULL |
Grade of Origin
Prompt Table: FPMRANK_VW1 |
| 4 | FP_SETID_RANK_END |
Character(5) | VARCHAR2(5) NOT NULL |
Set ID
Prompt Table: SETID_TBL |
| 5 | FP_RANK_END |
Character(6) | VARCHAR2(6) NOT NULL |
New Grade
Prompt Table: FPMRANK_VW2 |
| 6 | FP_STEP_MIN | Character(4) | VARCHAR2(4) NOT NULL |
Lowest Step
Prompt Table: FPMSALSTEP_TBL |
| 7 | FP_TRUESEN_MIN_YR | Number(2,0) | SMALLINT NOT NULL | Min Step Actual Seniority (Y) |
| 8 | FP_TRUESEN_MIN_MN | Number(2,0) | SMALLINT NOT NULL | Min Step Actual Seniority (M) |
| 9 | FP_TRUESEN_MIN_DY | Number(2,0) | SMALLINT NOT NULL | Min Step Actual Seniority (D) |
| 10 | FP_DURSTEP_MIN_YR | Number(2,0) | SMALLINT NOT NULL | Min Step Length Service (Yr) |
| 11 | FP_DURSTEP_MIN_MN | Number(2,0) | SMALLINT NOT NULL | Min Step Length Service (Mth) |
| 12 | FP_DURSTEP_MIN_DY | Number(2,0) | SMALLINT NOT NULL | Min Step Length Service (Day) |
| 13 | FP_STEP_MAX | Character(4) | VARCHAR2(4) NOT NULL |
Highest Step
Prompt Table: FPMSALSTEP_TBL |
| 14 | FP_TRUESEN_MAX_YR | Number(2,0) | SMALLINT NOT NULL | Max Step Actual Seniority (Y) |
| 15 | FP_TRUESEN_MAX_MN | Number(2,0) | SMALLINT NOT NULL | Max Step Actual Seniority (M) |
| 16 | FP_TRUESEN_MAX_DY | Number(2,0) | SMALLINT NOT NULL | Max Step Actual Seniority (D) |
| 17 | FP_DURSTEP_MAX_YR | Number(2,0) | SMALLINT NOT NULL | Max Step Length Service (Yrs) |
| 18 | FP_DURSTEP_MAX_MN | Number(2,0) | SMALLINT NOT NULL | Max Step Length Service (Mnth) |
| 19 | FP_DURSTEP_MAX_DY | Number(2,0) | SMALLINT NOT NULL | Max Step Length Service (Days) |
| 20 | FP_SENRAN_YR | Number(2,0) | SMALLINT NOT NULL | Actual Grade Seniority |
| 21 | FP_SENRAN_MN | Number(2,0) | SMALLINT NOT NULL | Grade Actual Seniority (M) |
| 22 | FP_SENRAN_DY | Number(2,0) | SMALLINT NOT NULL | Grade Actual Seniority (D) |
| 23 | FP_DURRAN_YR | Number(2,0) | SMALLINT NOT NULL | Grade Service Length (Years) |
| 24 | FP_DURRAN_MN | Number(2,0) | SMALLINT NOT NULL | Grade Service Length (Months) |
| 25 | FP_DURRAN_DY | Number(2,0) | SMALLINT NOT NULL | Grade Service Length (Days) |
| 26 | FP_SENCOR_YR | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (Y) |
| 27 | FP_SENCOR_MN | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (M) |
| 28 | FP_SENCOR_DY | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (D) |
| 29 | FP_DURCOR_YR | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Y) |
| 30 | FP_DURCOR_MN | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Months) |
| 31 | FP_DURCOR_DY | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Days) |
| 32 | FP_SENCAT_YR | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (Y) |
| 33 | FP_SENCAT_MN | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (M) |
| 34 | FP_SENCAT_DY | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (D) |
| 35 | FP_DURCAT_YR | Number(2,0) | SMALLINT NOT NULL | Category Service Length (Y) |
| 36 | FP_DURCAT_MN | Number(2,0) | SMALLINT NOT NULL | Category Service Length (M) |
| 37 | FP_DURCAT_DY | Number(2,0) | SMALLINT NOT NULL | Category Service Length (D) |
| 38 | FP_MARK_N1 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-1 Rating |
| 39 | FP_MARK_N2 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-2 Rating |
| 40 | FP_MARK_N3 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-3 Rating |
| 41 | FP_PRO_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
C=Competition P=Advancement |
| 42 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |