AV_RATING_P_VW(SQL View) |
Index Back |
---|---|
Constituents with RatingsThis view is used as a prompt for the id field on the search record for Ratings. It will only retrieve constituents that have ratings utilized during a update/display operation. |
SELECT DISTINCT C.OPRID , A.INSTITUTION , B.EMPLID , B.NAME FROM PS_AV_PRSN_RATING A , PS_HCR_PERSON_NM_I B , PS_SCRTY_TBL_INST C WHERE A.INSTITUTION = C.INSTITUTION AND A.EMPLID = B.EMPLID AND C.ACCESS_CD = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |