GM_PCL_WF_HIS

(SQL Table)
Index Back

Protocol Workflow History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PCL_ID Character(15) VARCHAR2(15) NOT NULL PCL_ID
3 PCL_VRSN_ID Character(7) VARCHAR2(7) NOT NULL PCL_VRSN_ID
4 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL Notify From
5 GM_ACTIVITY_CD Character(3) VARCHAR2(3) NOT NULL Activity
ADV=Adverse Event
APP=Approval Process
ASN=Assign Review Type
CHD=Children
CRD=Committee Meeting Reminder
CRN=Continue Review
EXP=Expiration
PRS=Prisoner
RAN=Re-assign Review Type
REN=Renewal
STD=Student PI
STG=Status Changed
SUB=Submit
6 NOTIFED_DTTM DateTime(26) TIMESTAMP The date and time a designated person was notified of a given position limit violation
7 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type
8 GM_WF_IN_PROG Character(1) VARCHAR2(1) NOT NULL Notification Type
B=Worklist/Email
E=Email Notification Only
W=Worklist Only
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 COM_ID Character(5) VARCHAR2(5) NOT NULL Committee Id. Used in Grants Protocol Setup
11 GM_PERFORM_ACT Character(1) VARCHAR2(1) NOT NULL GM_PERFORM_ACT
A=Approve
N=Notify
R=Review