FPAEEPROM_TBL(SQL Table) |
Index Back |
|---|---|
Promotable Employees per GradeThis record is used by the French Public Sector functionalities. It stores the promotable employees per grade. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FP_SETID_RANK |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | FP_RANK_START |
Character(6) | VARCHAR2(6) NOT NULL |
Grade of Origin
Prompt Table: FPMRANK_TBL |
| 3 | FP_THRUDATE |
Date(10) | DATE NOT NULL | Starting Date |
| 4 | FP_SETID_RANK_END |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 5 | FP_RANK_END |
Character(6) | VARCHAR2(6) NOT NULL |
New Grade
Prompt Table: FPMRANK_TBL |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: FPAPROM_SRCH |
| 7 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 9 | FP_FLAG_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Selected by Processing
Y/N Table Edit Default Value: N |
| 10 | FP_STEP_CD | Character(4) | VARCHAR2(4) NOT NULL | Step |
| 11 | FP_TRUESEN_DY | Number(2,0) | SMALLINT NOT NULL | Step Actual Seniority (D) |
| 12 | FP_TRUESEN_MN | Number(2,0) | SMALLINT NOT NULL | Step Actual Seniority (M) |
| 13 | FP_TRUESEN_YR | Number(2,0) | SMALLINT NOT NULL | Actual Step Seniority (Y) |
| 14 | FP_DURSTEP_DY | Number(2,0) | SMALLINT NOT NULL | Step Service Length (Days) |
| 15 | FP_DURSTEP_MN | Number(2,0) | SMALLINT NOT NULL | Step Service Length (Months) |
| 16 | FP_DURSTEP_YR | Number(2,0) | SMALLINT NOT NULL | Step Service Length (Years) |
| 17 | FP_SENRAN_DY | Number(2,0) | SMALLINT NOT NULL | Grade Actual Seniority (D) |
| 18 | FP_SENRAN_MN | Number(2,0) | SMALLINT NOT NULL | Grade Actual Seniority (M) |
| 19 | FP_SENRAN_YR | Number(2,0) | SMALLINT NOT NULL | Actual Grade Seniority |
| 20 | FP_DURRAN_DY | Number(2,0) | SMALLINT NOT NULL | Grade Service Length(Days) |
| 21 | FP_DURRAN_MN | Number(2,0) | SMALLINT NOT NULL | Grade Service Length(Months) |
| 22 | FP_DURRAN_YR | Number(2,0) | SMALLINT NOT NULL | Grade Service Length (Years) |
| 23 | FP_SENENTRK_DY | Number(2,0) | SMALLINT NOT NULL | Grade Entry Seniority (D) |
| 24 | FP_SENENTRK_MN | Number(2,0) | SMALLINT NOT NULL | Grade Entry Seniority (M) |
| 25 | FP_SENENTRK_YR | Number(2,0) | SMALLINT NOT NULL | Grade Entry Seniority (Y) |
| 26 | FP_CORPS_CD | Character(6) | VARCHAR2(6) NOT NULL | Corps |
| 27 | FP_SENCOR_DY | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (D) |
| 28 | FP_SENCOR_MN | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (M) |
| 29 | FP_SENCOR_YR | Number(2,0) | SMALLINT NOT NULL | Actual Corps Seniority (Y) |
| 30 | FP_DURCOR_DY | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Days) |
| 31 | FP_DURCOR_MN | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Months) |
| 32 | FP_DURCOR_YR | Number(2,0) | SMALLINT NOT NULL | Corps Service Length (Y) |
| 33 | FP_SENENTCRP_DY | Number(2,0) | SMALLINT NOT NULL | Corps Entry Seniority (D) |
| 34 | FP_SENENTCRP_MN | Number(2,0) | SMALLINT NOT NULL | Corps Entry Seniority (M) |
| 35 | FP_SENENTCRP_YR | Number(2,0) | SMALLINT NOT NULL | Corps Entry Seniority (Y) |
| 36 | FP_CATG_FP | Character(2) | VARCHAR2(2) NOT NULL |
Civil Service Category
A=A B=B C=C D=D X=No Existing Category |
| 37 | FP_SENCAT_DY | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (D) |
| 38 | FP_SENCAT_MN | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (M) |
| 39 | FP_SENCAT_YR | Number(2,0) | SMALLINT NOT NULL | Actual Category Seniority (Y) |
| 40 | FP_DURCAT_DY | Number(2,0) | SMALLINT NOT NULL | Category Service Length (D) |
| 41 | FP_DURCAT_MN | Number(2,0) | SMALLINT NOT NULL | Category Service Length (M) |
| 42 | FP_DURCAT_YR | Number(2,0) | SMALLINT NOT NULL | Category Service Length (Y) |
| 43 | FP_SENENTCTG_DY | Number(2,0) | SMALLINT NOT NULL | Catgy Entry Seniority (D) |
| 44 | FP_SENENTCTG_MN | Number(2,0) | SMALLINT NOT NULL | Catgy Entry Seniority (M) |
| 45 | FP_SENENTCTG_YR | Number(2,0) | SMALLINT NOT NULL | Catgy Entry Seniority (Y) |
| 46 | FP_MARK_N1 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-1 Rating |
| 47 | FP_MARK_N2 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-2 Rating |
| 48 | FP_MARK_N3 | Number(6,2) | DECIMAL(5,2) NOT NULL | Years N-3 Rating |
| 49 | FP_PRO_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
C=Competition P=Advancement |
| 50 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |