SAA_NOTE_ACX_VW

(SQL View)
 Index Back

Note Access View


SELECT A.INSTITUTION , A.SAA_NOTE_TYPE , B.SAA_ACCESS_VALUE , ' ' , A.DESCR , B.SAA_NOTE_VIEW , B.SAA_NOTE_UPDATE , B.SAA_NOTE_CREATE , B.SAA_NOTE_VIEWALL , B.SAA_NOTE_UPDATEALL , B.SAA_NOTE_SUPER FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B 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' UNION SELECT DISTINCT A.INSTITUTION , A.SAA_NOTE_TYPE , D.EMPLID , D.OPRID , A.DESCR , B.SAA_NOTE_VIEW , B.SAA_NOTE_UPDATE , B.SAA_NOTE_CREATE , B.SAA_NOTE_VIEWALL , B.SAA_NOTE_UPDATEALL , B.SAA_NOTE_SUPER FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B , PSROLEUSER C , PSOPRDEFN 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 = 'ROLE' AND C.ROLENAME = B.SAA_ACCESS_VALUE AND D.OPRID = C.ROLEUSER AND D.EMPLID <> ' ' UNION SELECT DISTINCT A.INSTITUTION , A.SAA_NOTE_TYPE , C.EMPLID , C.OPRID , A.DESCR , B.SAA_NOTE_VIEW , B.SAA_NOTE_UPDATE , B.SAA_NOTE_CREATE , B.SAA_NOTE_VIEWALL , B.SAA_NOTE_UPDATEALL , B.SAA_NOTE_SUPER FROM PS_SAA_NOTE_TYPE A , PS_SAA_NOTE_ACCESS B , PSOPRDEFN 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 = 'PLST' AND C.OPRCLASS = B.SAA_ACCESS_VALUE AND C.EMPLID <> ' '

  • Related Language Record: SAA_NOTE_ACX_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SAA_NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL This field denotes an advising note's category code.
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 SAA_NOTE_VIEW Character(1) VARCHAR2(1) NOT NULL View

    Y/N Table Edit

    Default Value: N

    7 SAA_NOTE_UPDATE Character(1) VARCHAR2(1) NOT NULL Update

    Y/N Table Edit

    Default Value: N

    8 SAA_NOTE_CREATE Character(1) VARCHAR2(1) NOT NULL Create

    Y/N Table Edit

    Default Value: N

    9 SAA_NOTE_VIEWALL Character(1) VARCHAR2(1) NOT NULL View All

    Y/N Table Edit

    Default Value: N

    10 SAA_NOTE_UPDATEALL Character(1) VARCHAR2(1) NOT NULL Update All

    Y/N Table Edit

    Default Value: N

    11 SAA_NOTE_SUPER Character(1) VARCHAR2(1) NOT NULL Super User

    Y/N Table Edit

    Default Value: N