GM_PCL_HDR1_VW

(SQL View)
Index Back

Protocol Version Search VW

Secured search record for Protocol Versions based on the Protocol Type.

SELECT DISTINCT A.BUSINESS_UNIT , A.PCL_ID , A.PCL_TYPE , T.PCL_SUB_TYPE FROM PS_GM_PCL_HDR A , PS_GM_PCL_TYPE T WHERE 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_TYPE Character(10) VARCHAR2(10) NOT NULL Protocol Type

Prompt Table: GM_PCL_TYPE

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