| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: GM_PCL_HDR.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 |
TITLE56 |
Character(56) |
VARCHAR2(56) NOT NULL |
TITLE56
|
| 5 |
PHASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Protocol Phase Type
C=Continuing Review
M=Modified
N=New
R=Renewal
|
| 6 |
PCL_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
PCL_STATUS
APPR=Approved
DEND=Denied
DRFT=Draft
EXPD=Expired
INAC=Inactive
PEND=Pending
RETD=Returned
Default Value: DRFT
|
| 7 |
REV_TYPE_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Requested Review
E=Exempt
F=Full Review
X=Expedited
|
| 8 |
REV_TYPE_ADMIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Type Assigned
E=Exempt
F=Full Review
X=Expedited
|
| 9 |
COM_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Committee Id. Used in Grants Protocol Setup
Prompt Table:
GM_PCL_COM_HDR
|
| 10 |
MEET_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Meeting Id. Used in Grants Protocol Setup
Prompt Table:
GM_PCL_MTN_SRCH
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 12 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 13 |
IRB_APP_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
IRB Application Type
F=Deviations from Federal
M=Modified/Revised
N=New Application
R=Periodic Renewal
|
| 14 |
REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table:
GM_PCL_REVW_VW
|
| 15 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
GM_DEPT_TBL_VW
|
| 16 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
GM_CUSTOMER_VW2
|
| 17 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 18 |
END_DT |
Date(10) |
DATE |
End Date
|
| 19 |
SUBMIT_DATE |
DateTime(26) |
TIMESTAMP |
Submit Date
|
| 20 |
EXP_DT |
Date(10) |
DATE |
Expiration Date
|
| 21 |
DISPOSITION_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given transaction is approved by an oper
|
| 22 |
PCL_BCK_GRND |
Character(60) |
VARCHAR2(60) NOT NULL |
Historical Project Background
|
| 23 |
PRTCL_ABSTRACT |
Character(254) |
VARCHAR2(254) NOT NULL |
Protocol Abstract
|
| 24 |
DETAIL_PLAN_STUDY |
Character(254) |
VARCHAR2(254) NOT NULL |
Detail Plan of Study
|
| 25 |
STUDENT_PI |
Character(1) |
VARCHAR2(1) NOT NULL |
Student PI
Y/N Table Edit
|
| 26 |
STDNT_PI_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GM_ELIG_PI_VW
|
| 27 |
ADVERSE_EVENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Adverse Event
Y/N Table Edit
|
| 28 |
ADVRS_EVNT_DTL |
Character(254) |
VARCHAR2(254) NOT NULL |
Adverse Event Detail
|
| 29 |
FDA_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
FDA Approval Info
|
| 30 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GM_ELIG_PI_VW
|
| 31 |
ADVISOR_STATEMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
Faculty Advisor Statement
|
| 32 |
ASSUR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Assurance Id
|
| 33 |
ASSUR_APPR_DATE |
Date(10) |
DATE |
Assurance Approval Date
|
| 34 |
ASSUR_EXPR_DATE |
Date(10) |
DATE |
Assurance Approval Date
|
| 35 |
ADVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Academic Advisor
|
| 36 |
PCL_PURPOSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Protocol Purpose
|
| 37 |
YES_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Yes Count
|
| 38 |
NO_CNT |
Number(4,0) |
SMALLINT NOT NULL |
No Count
|
| 39 |
ABS_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Absention Count
|
| 40 |
DISPOSITION_COMM |
Character(254) |
VARCHAR2(254) NOT NULL |
Disposition Comments
|
| 41 |
APPROVER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver ID
Prompt Table:
GM_PERSONAL1_VW
|
| 42 |
ASSGN_NTF_DT |
DateTime(26) |
TIMESTAMP |
Assign Notification Date
|
| 43 |
CR_NTF_DT |
DateTime(26) |
TIMESTAMP |
Continuing Renewal Notificatio
|
| 44 |
REN_NTF_DT |
DateTime(26) |
TIMESTAMP |
Renewal Notification
|
| 45 |
EXP_NTF_DT |
DateTime(26) |
TIMESTAMP |
EXP_NTF_DT
|
| 46 |
MEET_REM_NTF_DT |
DateTime(26) |
TIMESTAMP |
MEET_REM_NTF_DT
|
| 47 |
SUB_NTF_DT |
DateTime(26) |
TIMESTAMP |
SUB_NTF_DT
|
| 48 |
NEXT_CR_DT |
Date(10) |
DATE |
Next CR Date
|
| 49 |
RET_BY_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Returned by Reviewer Flag
Y/N Table Edit
|