FPM_CA_CTG_VW

(SQL View)
 Index Back

Grade - CAEC Link

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

SELECT DISTINCT A.SETID , A.FP_RANK_CD , B.FP_STFBDG_LVL3 , A.EFFDT , A.FP_CA_CATG_ID , C.DESCR FROM PS_FPM_CA_CTG_MBR A , PS_FPM_CA_CTG_TBL B , PS_FPMRANK_TBL 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 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: FPMCACTG_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL Set ID
    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 FP_CA_CATG_ID Character(6) VARCHAR2(6) NOT NULL CAE Category
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description