BUSINESS_UNITPROJECT_IDACCOUNTDTTM_STAMPDefault Value: %date
OPRIDGM_FCST_SUM_TA0(SQL Table) |
Index Back |
|---|---|
Project Forecast Sum TableThis record stores the grouped and summarized data from the GM_PRJ_FCST_TEMP table. The results is later is displayed on the GM_PRJ_FCST_PNL panel. |
| # | 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 | DTTM_STAMP |
DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %date |
| 5 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | BUD_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Total Direct Budget |
| 7 | ACT_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Total Actuals Amount |
| 8 | ENCUM_AMOUNT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Encumbered Amount |
| 9 | PRE_ENCUM_AMT | Signed Number(32,3) | DECIMAL(30,3) NOT NULL | Pre Encumbered Amount |
| 10 | UNOBLIGATED_BAL | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Unobligated Balance |
| 11 | AVG_MO_BURN_RATE | Signed Number(11,2) | DECIMAL(9,2) NOT NULL | Average Monthly Burn Rate |
| 12 | REMAINING_MONTHS | Signed Number(3,0) | DECIMAL(2) NOT NULL | Remaining Months |
| 13 | TOTAL_FORECAST | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Forecast |
| 14 | UNCOMMITED_BAL | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Uncommited Balance |
| 15 | UNCOM_PERCENTAGE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Uncommited Percentage |
| 16 | FROM_DATE | Date(10) | DATE | From Date |
| 17 | TO_DATE | Date(10) | DATE | To Date |
| 18 | FROM_DT | Date(10) | DATE | From Date |
| 19 | TO_DT | Date(10) | DATE | To Date |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |