GM_PCL_SRCH_ADM(SQL View) |
Index Back |
|---|---|
Protocol Version Search VWSecured search record for Protocol Versions based on the Protocol Type. |
| SELECT DISTINCT B.BUSINESS_UNIT , B.PCL_ID , B.PCL_VRSN_ID , A.PCL_TYPE , B.DESCR , B.PHASE_TYPE , B.START_DT , B.END_DT , B.SUBMIT_DATE , B.COM_ID , B.MEET_ID , B.REV_TYPE_ADMIN , B.RET_BY_REV , B.PCL_STATUS , T.PCL_SUB_TYPE FROM PS_GM_PCL_HDR A , PS_GM_PCL_VRSN B , PS_GM_PCL_TYPE T WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PCL_ID = B.PCL_ID AND A.PCL_TYPE = T.PCL_TYPE AND T.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'GM_PCL_TYPE' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PCL_ID |
Character(15) | VARCHAR2(15) NOT NULL |
PCL_ID
Prompt Table: GM_PCL_HDR |
| 3 | PCL_VRSN_ID |
Character(7) | VARCHAR2(7) NOT NULL | PCL_VRSN_ID |
| 4 | PCL_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Protocol Type
Prompt Table: GM_PCL_TYPE |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PHASE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Protocol Phase Type
C=Continuing Review M=Modified N=New R=Renewal |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | SUBMIT_DATE | DateTime(26) | TIMESTAMP | Submit Date |
| 10 | COM_ID | Character(5) | VARCHAR2(5) NOT NULL |
Committee Id. Used in Grants Protocol Setup
Prompt Table: GM_PCL_COM_HDR |
| 11 | MEET_ID | Character(5) | VARCHAR2(5) NOT NULL |
Meeting Id. Used in Grants Protocol Setup
Prompt Table: GM_MEET_SRCH |
| 12 | REV_TYPE_ADMIN | Character(1) | VARCHAR2(1) NOT NULL |
Review Type Assigned
E=Exempt F=Full Review X=Expedited |
| 13 | RET_BY_REV | Character(1) | VARCHAR2(1) NOT NULL |
Returned by Reviewer Flag
Y/N Table Edit |
| 14 | PCL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
PCL_STATUS
APPR=Approved DEND=Denied DRFT=Draft EXPD=Expired INAC=Inactive PEND=Pending RETD=Returned |
| 15 | PCL_SUB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Protocol Subtype - Human , Animal
A=Animal B=Both H=Human |