FPMCACTG_VW_LNG

(SQL View)
 Index Back

Grade CAEC Link

When assigning grade at hiring or promotion, check that grade belongs to an active CAEC.

SELECT DISTINCT A.SETID , A.FP_RANK_CD , B.FP_STFBDG_LVL3 , A.EFFDT , C.LANGUAGE_CD , C.DESCR FROM PS_FPM_CA_CTG_MBR A , PS_FPM_CA_CTG_TBL B , PS_FPMRANK_TBL_LNG C WHERE A.SETID = B.SETID AND A.FP_CA_CATG_ID = B.FP_CA_CATG_ID AND A.EFFDT = B.EFFDT AND A.SETID = C.SETID AND A.FP_RANK_CD = C.FP_RANK_CD AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_FPMRANK_TBL_LNG C_ED WHERE C.SETID = C_ED.SETID AND C.FP_RANK_CD = C_ED.FP_RANK_CD AND C_ED.EFFDT <= A.EFFDT)

  • Related Language Record for FPM_CA_CTG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
    2 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade
    3 FP_STFBDG_LVL3 Character(2) VARCHAR2(2) NOT NULL Article
    00=Test Test
    01=Minister and Secretaryof State
    02=National Headquarters
    10=Decentralized Services
    91=Ministry (test)
    92=National Headquarters
    93=Decentralized Services
    98=Special
    4 EFFDT Date(10) DATE Effective Date
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description