GM_OPPT_DTL_TMP(SQL Table) |
Index Back |
|---|---|
Grants Budget Line DetailBudget line detail contains an optional breakdown of a budget summary line. For example, the detail level can identify major pieces of equipment that are summarized in the parent 'Equipment' summary line. For salary and fringe categories, the detail level describes the participation of individual employees/investigators. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Version ID
Prompt Table: GM_PROPOSAL |
| 4 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL |
SUB_PROP_NBR
Prompt Table: GM_PROP_PROJ |
| 5 | BUDGET_ID |
Character(15) | VARCHAR2(15) NOT NULL |
BUDGET_ID
Prompt Table: GM_BUD_HDR |
| 6 | BUDGET_PERIOD_GM |
Number(3,0) | SMALLINT NOT NULL |
BUDGET_PERIOD_GM
Default Value: 1 Prompt Table: GM_BUD_PERIOD |
| 7 | BUDGET_LN |
Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 8 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 11 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 12 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 13 | COST_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount |
| 14 | PM_MARGIN_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |