FPAEEPROM_VW

(SQL View)
Index Back

Promotable Employees per Grade

This 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