FPM_CA_CTG02_VW

(SQL View)
 Index Back

Setids for CA categories

This view retrieves the setids and descriptions linked to categories. It is used by the French Public Sector Commitment Accounting functionalities.

SELECT A.SETID , A.FP_CA_CATG_ID , A.DESCR FROM PS_FPM_CA_CTG_TBL A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FPM_CA_CTG_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.FP_CA_CATG_ID = A_ED.FP_CA_CATG_ID AND A_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: FPMCA_CTGV2_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
    2 FP_CA_CATG_ID Character(6) VARCHAR2(6) NOT NULL CAE Category
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description