| # |
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 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
GM_WF_COMP_LIST
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 9 |
AMT_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Amount Record
Prompt Table:
GM_WF_COMPONENT
|
| 10 |
AMT_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Amount Field Name
Prompt Table:
GM_AMT_FIELDS
|
| 11 |
FIELDNAME_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Field
Prompt Table:
GM_CURR_FIELDS
|
| 12 |
CRTA_OPERATOR_NUM |
Character(2) |
VARCHAR2(2) NOT NULL |
Criteria Operator
<=Less Than
>=Greater Than
B=Between(Inclusive)
|
| 13 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 14 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 15 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|