PGM_ETCLOAD_TMP (SQL Table)	Index Back
Application Engine table Application Engine temporary table that stores the Estimate To Complete rows before they are inserted into the INTFC_PROJ_RES table.

PGM_ETCLOAD_TMP

(SQL Table)

Application Engine table

Application Engine temporary table that stores the Estimate To Complete rows before they are inserted into the INTFC_PROJ_RES table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

5 ACTIVITY_ID_DETAIL Character(15) VARCHAR2(15) NOT NULL This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

9 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM

10 BUDGET_ITEM_REV Character(15) VARCHAR2(15) NOT NULL Revenue Budget Item

11 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field

12 AMOUNT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field

13 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours

14 START_DT Date(10) DATE Start Date

15 END_DT Date(10) DATE End Date

16 NO_OF_DAYS3 Number(9,0) DECIMAL(9) NOT NULL Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	ACTIVITY_ID_DETAIL	Character(15)	VARCHAR2(15) NOT NULL	This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	BILL_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Bill Currency Code
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
9	PC_BUDGET_ITEM	Character(15)	VARCHAR2(15) NOT NULL	Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
10	BUDGET_ITEM_REV	Character(15)	VARCHAR2(15) NOT NULL	Revenue Budget Item
11	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
12	AMOUNT_2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
13	REMAINING_WORK	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	New Remaining work in hours
14	START_DT	Date(10)	DATE	Start Date
15	END_DT	Date(10)	DATE	End Date
16	NO_OF_DAYS3	Number(9,0)	DECIMAL(9) NOT NULL	Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.