INSTITUTIONSAA_NOTE_TYPESAA_ACCESS_TYPEPLST=Permission List
ROLE=Role
USER=User
SAA_ACCESS_VALUESCCPU_NTACX_BND(SQL View) |
Index Back |
|---|---|
Bind for SAA_NOTE_ACCESSThis table hosts required fields for SAA_NOTE_ACCESS Population Update. |
| SELECT A.INSTITUTION , A.SAA_NOTE_TYPE , B.SAA_ACCESS_TYPE , B.SAA_ACCESS_VALUE 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 |
| # | 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 | SAA_ACCESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Access Type
PLST=Permission List ROLE=Role USER=User |
| 4 | SAA_ACCESS_VALUE |
Character(30) | VARCHAR2(30) NOT NULL | Access Value |