BUSINESS_UNITPROJECT_IDACCOUNTGM_PRJ_FCST_VW5(SQL View) |
Index Back |
|---|---|
Account summaryThis is a view of GM_PRJ_FCST_TEMP. This view summarizes the data by account. The summarized result is passed to the GM_PRJ_FCST_SUM table. |
| SELECT BUSINESS_UNIT , PROJECT_ID , ACCOUNT , SUM(BUD_AMOUNT) , SUM(ACT_AMOUNT) , SUM(ENCUM_AMOUNT) , SUM(PRE_ENCUM_AMT) FROM PS_GM_FCT_TMP GROUP BY BUSINESS_UNIT , PROJECT_ID , ACCOUNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 4 | BUD_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Total Direct Budget |
| 5 | ACT_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Total Actuals Amount |
| 6 | ENCUM_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Encumbered Amount |
| 7 | PRE_ENCUM_AMT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Pre Encumbered Amount |