REVIEWER_IDGM_PCL_REVW_VW(SQL View) |
Index Back |
|---|---|
Reviewer View |
| SELECT DISTINCT M.COM_MEMBER_ID ,P.NAME , M.PROF_ROLE_TYPE FROM PS_GM_PCL_COM_MEMB M , PS_PERSONAL_DATA P WHERE M.REV_FLG = 'Y' AND M.COM_MEMBER_ID = P.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | PCL_ROLE_ID | Character(5) | VARCHAR2(5) NOT NULL | Protocol Role Id. Used in Grants Protocol Setup |