| # |
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
Default Value: S
|
| 4 |
GM_ELEMENT_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
GM_ELEMENT_VALUE
Prompt Table:
%EDITTABLE15
|
| 5 |
GM_REQ_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Approval Process
Y/N Table Edit
Default Value: N
|
| 6 |
EXCEPTION_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Exception Oprid. The operator id that all transactions with routing exceptions are routed to.
Prompt Table:
GM_EXP_APPROVER
|
| 7 |
PROF_ROLE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Role Type
Prompt Table:
GM_ROLE_WF_TY
|
| 8 |
PRIOR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
PRIOR_DAYS
|
| 9 |
GM_WF_ON_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify When Approved
Y/N Table Edit
Default Value: N
|
| 10 |
GM_SELF_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Approval
Y/N Table Edit
Default Value: N
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 12 |
PCL_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Protocol Subtype - Human , Animal
A=Animal
B=Both
H=Human
Default Value: B
|
| 13 |
NOTE |
Long Character(256) |
VARCHAR2(256) |
Note
|