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 |