BUSINESS_UNITPROPOSAL_IDVERSION_IDDefault Value: 0
Default Value: 0
GM_OPPTY_VER_VW(SQL View) |
Index Back |
|---|---|
Proposal Vesion |
| SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , TITLE56 , TOTAL_BUDGET_AMT , PROPOSED_AMT_EXP , PROPOSED_AMT_TIME , ESTIMATED_AMOUNT , ESTIMATED_AMT_EXP , ESTIMATED_AMT_TIME , BILL_AMT , BILL_AMT_EXP , BILL_AMT_TIME , COST_AMT , COST_AMT_EXP , COST_AMT_TIME , PM_MARGIN_PCT , MARGIN_PCT_EXP , MARGIN_PCT_TIME , RESOURCE_TOTAL , NBR_OF_HOURS , WEEKLY_WEEKS , CURRENT_VERSION , SCEN_ADJUST_PCT_EX , SCEN_ADJUST_PCT_TM , CURRENCY_CD FROM PS_GM_PROPOSAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 5 | TOTAL_BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | TOTAL_BUDGET_AMT |
| 6 | PROPOSED_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Proposed Amount Expense |
| 7 | PROPOSED_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Proposed Amount Time |
| 8 | ESTIMATED_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount SCP - Added new label - Estimated Cost |
| 9 | ESTIMATED_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount Expense |
| 10 | ESTIMATED_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount Time |
| 11 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 12 | BILL_AMT_EXP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 13 | BILL_AMT_TIME | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 14 | COST_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount |
| 15 | COST_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Expense |
| 16 | COST_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Time |
| 17 | PM_MARGIN_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 18 | MARGIN_PCT_EXP | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 19 | MARGIN_PCT_TIME | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 20 | RESOURCE_TOTAL | Number(3,0) | SMALLINT NOT NULL | Resource Total |
| 21 | NBR_OF_HOURS | Number(5,0) | INTEGER NOT NULL | Number of Hours |
| 22 | WEEKLY_WEEKS | Number(3,0) | SMALLINT NOT NULL | Weeks |
| 23 | CURRENT_VERSION | Character(1) | VARCHAR2(1) NOT NULL | Current Version |
| 24 | SCEN_ADJUST_PCT_EX | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Expense
06/09/2004 PR_FS_B005
Added Label NON_LABOR_ADJUST
Default Value: 0 |
| 25 | SCEN_ADJUST_PCT_TM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Time
06/09/2004 PR_FS_B005
Added Label - LABOR_ADJUST
Default Value: 0 |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |