GM_VAR_TMP

(SQL Table)
Index Back

Project VarianceTemp Table

This record stores the retrieved data from the PROJ_RESOURCE record with views. The results is later grouped,summarized and loaded to the GM_PROJ_VAR_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 BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL BUDGET_AMT
7 ACTUALS Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Actuals Amount
8 ENCUMBERED_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Encumbered Amount
9 PRE_ENCUM_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Pre Encumbered Amount
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code