GM_FCT_TMP

(SQL Table)
Index Back

Project Forecast Temp Table

This temp record stores the retrieved data from the PROJ_RESOURCE record with views. The results is later grouped,summarized and loaded to the GM_PROJ_FCST_SUM table.

# 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.
5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
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