GM_PCL_ROLE_HUM

(SQL View)
Index Back

Role Type view

Role Type view for all Protocl

SELECT DISTINCT A.PROF_ROLE_TYPE , A.DESCR , A.PCL_SUB_TYPE , A.DESCRSHORT FROM PS_GM_PROF_ROLE_TY A WHERE A.GM_ROLE_TYPE = 'T' AND PROF_ROLE_TYPE <> 'COMH' AND (A.PCL_SUB_TYPE = 'H' OR A.PCL_SUB_TYPE = 'B') AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GM_PROF_ROLE_TY D WHERE A.PROF_ROLE_TYPE = D.PROF_ROLE_TYPE AND D.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 PCL_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Protocol Subtype - Human , Animal
A=Animal
B=Both
H=Human
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description