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 |