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 |
Set ID
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 | Set ID |
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 Record |
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 |
Category for FPS
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 |