| # |
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 |
GM_CONDITION_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition ID
|
| 6 |
GM_CONTROL_ID |
Number(3,0) |
SMALLINT NOT NULL |
Control ID
|
| 7 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
|
| 8 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
GM_WF_COMPONENT
|
| 9 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
PSRECFIELDALL
|
| 10 |
CRTA_OPERATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Criteria Operator
<=Less Than
<>=Not Equal To
==Equals
>=Greater Than
B=Between
NN=Is Not Blank
NU=Is Blank
|
| 11 |
CRTA_OPERATOR_NUM |
Character(2) |
VARCHAR2(2) NOT NULL |
Criteria Operator
<=Less Than
>=Greater Than
B=Between(Inclusive)
|
| 12 |
CRTA_VAL1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Criteria Value 1
|
| 13 |
CRTA_VAL2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Criteria Value 2
|