FANLTRCATSRCHLN

(SQL View)
 Index Back

FanLtr Comm Catg Search

Fin Aid Award Notification Letter Communication Category Search view.

SELECT B.INSTITUTION ,B.COMM_CATEGORY , A.LANGUAGE_CD ,A.DESCR FROM PS_COMM_CATG_LANG A ,PS_COMM_CATG_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.COMM_CATEGORY = B.COMM_CATEGORY AND B.ADMIN_FUNCTION = 'FINA' AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMM_CATG_LANG B WHERE B.INSTITUTION = A.INSTITUTION AND B.COMM_CATEGORY = A.COMM_CATEGORY AND A.EFFDT <= %CurrentDateIn )

  • Related Language Record for FANLTR_CAT_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description