GM_PCL_ADMN_VW (SQL View)	Index Back
Committee Administrator Table Control Table to capture the Committee Administrator . Setup Table for Grants Protocol Management

GM_PCL_ADMN_VW

(SQL View)

Committee Administrator Table

Control Table to capture the Committee Administrator . Setup Table for Grants Protocol Management

SELECT A.SETID ,A.PCL_SUB_TYPE ,A.EMPLID ,A.DESCR FROM PS_GM_PCL_COM_ADMN A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GM_PCL_COM_ADMN B WHERE A.SETID = B.SETID AND A.PCL_SUB_TYPE = B.PCL_SUB_TYPE AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 PCL_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Protocol Subtype - Human , Animal
A=Animal
B=Both
H=Human

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PCL_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Protocol Subtype - Human , Animal A=Animal B=Both H=Human
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description