PGM_LOADETC_AET

#	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	CALC_ETC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Calculate ETC Option
6	CALC_ETB_OPT	Character(1)	VARCHAR2(1) NOT NULL	Calculate ETB Option
7	AN_TYPE_ETC	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type - ETC
8	AN_TYPE_ETB	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type - ETB
9	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
10	AE_WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Dynamic where clause
11	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
12	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
13	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
14	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
15	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
17	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
18	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
19	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
20	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
21	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
22	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
24	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
25	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
26	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
27	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
28	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
29	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
30	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
31	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
32	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
33	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
34	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
35	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
36	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
37	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
38	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
39	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
40	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
41	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
42	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
43	BUDGET_ITEM_PREV	Character(15)	VARCHAR2(15) NOT NULL	When processing a batch of budget items, this field holds the previous budget item processed.
44	PC_BUDGET_ITEM	Character(15)	VARCHAR2(15) NOT NULL	Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
45	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
46	FIELD_LIST	Long Character(4000)	CLOB	Field List
47	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
48	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration
49	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
50	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.
51	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
52	END_DT	Date(10)	DATE	End Date
53	START_DT	Date(10)	DATE	Start Date
54	PC_SUM_CAL_ID	Character(2)	VARCHAR2(2) NOT NULL	Default Summary Calendar ID
55	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
56	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
57	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.
58	PERIOD_DAYS	Number(5,0)	INTEGER NOT NULL	Number of Work Days
59	DAILY_ETC_QTY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Daily ETC Quantity
60	DAILY_ETC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Daily ETC Amount
61	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.
62	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
63	TRANS_DT	Date(10)	DATE	Transaction Date