CUR_AGE_CAT_VW

(SQL View)
 Index Back

Current Aging Categry by Setid


SELECT DISTINCT A.SETID , A.AGING_ID , A.AGING_CATEGORY , A.DESCR FROM PS_AGING_CATEG_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_AGING_TBL WHERE SETID = A.SETID AND AGING_ID = A.AGING_ID AND EFFDT <= %CurrentDateIn AND EFF_STATUS = 'A')

  • Related Language Record: CUR_AGE_CATVWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 AGING_ID Character(5) VARCHAR2(5) NOT NULL Aging ID
    3 AGING_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description