| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table:
SP_BU_CA_NONVW
|
| 2 |
GM_TRANS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Type
PB=Protocol Batch Notification
PG=Proposal Component Approval
PM=Milestone Notfication
PN=Protocol Notification
PP=Proposal Notification
PT=Protocol Approval
|
| 3 |
GM_ELEMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Element
A=Protocol Approval
B=Protocol Batch Notification
C=Proposal Components
M=Award Milestone
N=Protocol Notification
S=Proposal Status
|
| 4 |
GM_ELEMENT_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
GM_ELEMENT_VALUE
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 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
|
| 7 |
GM_DATE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
GM_DATE_TYPE
CRD=Committee meeting Reminder
CRN=Continuing Review
EXP=Expiration
REN=Renewal
|
| 8 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 9 |
REV_TYPE_ADMIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Type Assigned
E=Exempt
F=Full Review
X=Expedited
|
| 10 |
GM_DISPOSITION |
Character(4) |
VARCHAR2(4) NOT NULL |
Disposition
APPR=Approved
DEND=Denied
REAS=Re-Assign Approver
RETD=Returned
RETN=Re-Assign Review Type
REV=Reviewed
|
| 11 |
EVENT_FLAG |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Flag
A=Adverse Event
C=Children
N=None
P=Prisoners
S=Student PI
Default Value: N
|
| 12 |
GM_APPROVAL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Requirments
A=All Approvers Required
P=Pecent of Approvers Required
Default Value: A
|
| 13 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 14 |
COMMENTS_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
EDI Comments
|
| 15 |
NOTES |
Long Character |
CLOB |
Notification Text
|