FPMRANK_VW1

(SQL View)
 Index Back

FPS Active Grades

This view retrieves active grades. It is used by the French Public Sector functionalities.

SELECT SETID , FP_RANK_CD , DESCR FROM PS_FPMRANK_TBL WHERE EFF_STATUS = 'A'

  • Related Language Record: FPMRANK_VW1_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description