SAA_NOTE_ACX_LV

(SQL View)
 Index Back

Note Access Rel Lang View

SAA_NOTE_ACX_VW related language view

SELECT C.LANGUAGE_CD , A.INSTITUTION , A.SAA_NOTE_TYPE , B.SAA_ACCESS_VALUE , C.DESCR FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B , PS_SAA_NOTETYPE_LN C WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SAA_NOTE_TYPE A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.INSTITUTION = A.INSTITUTION AND B.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND B.SAA_ACCESS_TYPE = 'USER' AND C.INSTITUTION = A.INSTITUTION AND C.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND C.EFFDT = A.EFFDT UNION SELECT DISTINCT E.LANGUAGE_CD , A.INSTITUTION , A.SAA_NOTE_TYPE , D.EMPLID , E.DESCR FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B , PSROLEUSER C , PSOPRDEFN D , PS_SAA_NOTETYPE_LN E WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SAA_NOTE_TYPE A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.INSTITUTION = A.INSTITUTION AND B.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND B.SAA_ACCESS_TYPE = 'ROLE' AND C.ROLENAME = B.SAA_ACCESS_VALUE AND D.OPRID = C.ROLEUSER AND D.EMPLID <> ' ' AND E.INSTITUTION = A.INSTITUTION AND E.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND E.EFFDT = A.EFFDT UNION SELECT DISTINCT D.LANGUAGE_CD , A.INSTITUTION , A.SAA_NOTE_TYPE , C.EMPLID , D.DESCR FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B , PSOPRDEFN C , PS_SAA_NOTETYPE_LN D WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SAA_NOTE_TYPE A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.INSTITUTION = A.INSTITUTION AND B.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND B.SAA_ACCESS_TYPE = 'PLST' AND C.OPRCLASS = B.SAA_ACCESS_VALUE AND C.EMPLID <> ' ' AND D.INSTITUTION = A.INSTITUTION AND D.SAA_NOTE_TYPE = A.SAA_NOTE_TYPE AND D.EFFDT = A.EFFDT

  • Related Language Record for SAA_NOTE_ACX_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SAA_NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's category code.
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description