GM_PM_TM_C_VW(SQL View) |
Index Back |
|---|---|
Time Cost Budget Detail |
| SELECT A.BUSINESS_UNIT ,A.PROPOSAL_ID ,A.VERSION_ID ,A.SUB_PROP_NBR ,A.BUDGET_ID ,A.BUDGET_PERIOD_GM ,A.BUDGET_LN ,A.SEQ_NUM ,C.BUDGET_CATEGORY ,A.ACTUAL_COST_RATE ,A.COST_AMT ,A.CURRENCY_CD ,B.AN_TYPE_ESA_COST ,'HRS' ,A.QTY_X_HOURS ,A.PROJ_ROLE FROM PS_GM_OPPTY_DTL_TM A ,PS_GM_BUD_LINE_SUM C ,PS_INSTALLATION_PC B WHERE A.COST_AMT <> 0 AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROPOSAL_ID = C.PROPOSAL_ID AND A.VERSION_ID = C.VERSION_ID AND A.SUB_PROP_NBR = C.SUB_PROP_NBR AND A.BUDGET_ID = C.BUDGET_ID AND A.BUDGET_PERIOD_GM = C.BUDGET_PERIOD_GM AND A.BUDGET_LN = C.BUDGET_LN |
| # | 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 | SUB_PROP_NBR | Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | BUDGET_ID | Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
| 6 | BUDGET_PERIOD_GM | Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 7 | BUDGET_LN | Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 8 | SEQ_NUM_PD2 | Number(3,0) | SMALLINT NOT NULL | Represents the second displayed column in the position monitor. |
| 9 | BUDGET_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL | BUDGET_CATEGORY |
| 10 | ACTUAL_COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Actual Cost Rate |
| 11 | BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BUDGET_AMT |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 15 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 16 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |