FPAEEPROM_VW(SQL View) |
Index Back |
|---|---|
Promotable Employees per GradeThis view retrieves the promotable employees per grade. It is used by the French Public Sector functionalities. |
| SELECT A.FP_THRUDATE , A.FP_SETID_RANK , A.FP_RANK_START , A.FP_SETID_RANK_END , A.FP_RANK_END , A.EMPLID , A.EMPL_RCD , A.BIRTHDATE , A.FP_FLAG_ORIG , A.FP_STEP_CD , A.FP_TRUESEN_DY , A.FP_TRUESEN_MN , A.FP_TRUESEN_YR , A.FP_DURSTEP_DY , A.FP_DURSTEP_MN , A.FP_DURSTEP_YR , A.FP_SENRAN_DY , A.FP_SENRAN_MN , A.FP_SENRAN_YR , A.FP_DURRAN_DY , A.FP_DURRAN_MN , A.FP_DURRAN_YR , A.FP_SENENTRK_DY , A.FP_SENENTRK_MN , A.FP_SENENTRK_YR , A.FP_CORPS_CD , A.FP_SENCOR_DY , A.FP_SENCOR_MN , A.FP_SENCOR_YR , A.FP_DURCOR_DY , A.FP_DURCOR_MN , A.FP_DURCOR_YR , A.FP_SENENTCRP_DY , A.FP_SENENTCRP_MN , A.FP_SENENTCRP_YR , A.FP_CATG_FP , A.FP_SENCAT_DY , A.FP_SENCAT_MN , A.FP_SENCAT_YR , A.FP_DURCAT_DY , A.FP_DURCAT_MN , A.FP_DURCAT_YR , A.FP_SENENTCTG_DY , A.FP_SENENTCTG_MN , A.FP_SENENTCTG_YR , A.FP_MARK_N1 , A.FP_MARK_N2 , A.FP_MARK_N3 , A.FP_PRO_ACCESS , A.LAST_UPDATE_DATE FROM PS_FPAEEPROM_TBL A , PS_FPMPROMTABL_TBL B WHERE A.FP_SETID_RANK = B.FP_SETID_RANK AND A.FP_RANK_START= B.FP_RANK_START AND A.FP_SETID_RANK_END = B.FP_SETID_RANK_END AND A.FP_RANK_END = B.FP_RANK_END AND A.FP_THRUDATE = B.FP_THRUDATE AND A.FP_MARK_N1 >= B.FP_MARK_N1 AND A.FP_MARK_N2 >= B.FP_MARK_N2 AND A.FP_MARK_N3 >= B.FP_MARK_N3 AND (A.FP_PRO_ACCESS = B.FP_PRO_ACCESS OR B.FP_PRO_ACCESS = ' ') AND A.FP_FLAG_ORIG = 'Y' |
| # | 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 |
SetID
Prompt Table: SETID_TBL |
| 3 | FP_RANK_START |
Character(6) | VARCHAR2(6) NOT NULL |
Grade of Origin
Prompt Table: FPMRANK_TBL |
| 4 | FP_SETID_RANK_END |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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: FPAEMPLOYM_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 |
| 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 |