| # |
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 |
PROF_ROLE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Role Type
Prompt Table:
%EDITTABLE14
|
| 6 |
GM_REQ_APPER |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_REQ_APPER
Y/N Table Edit
Default Value: N
|
| 7 |
GM_PERFORM_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_PERFORM_ACT
A=Approve
N=Notify
R=Review
|
| 8 |
GM_WF_POOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Pool List
Y/N Table Edit
Default Value: N
|
| 9 |
GM_REASSIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_REASSIGN
Y/N Table Edit
Default Value: N
|
| 10 |
GM_WF_IN_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action When In Progress
B=Worklist/Email
E=Email Notification Only
W=Worklist Only
|
| 11 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|