PC_TL_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 Default Value: Y
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: Y
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Default Value: Y
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
7	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
8	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
9	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
10	TRANS_DT	Date(10)	DATE	Transaction Date
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMPL_RCD_NUM	Number(3,0)	SMALLINT NOT NULL	Project Employee Job Record #
14	DATE_UNDER_RPT	Date(10)	DATE	Date Under Report
15	PERIOD_PRCS_DT	Date(10)	DATE	Period Process Date
16	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
17	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
18	DLYTASK_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Daily Task Sequence Number
19	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
20	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
21	DATE_RANGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=Accounting Date E=All T=Transaction Date
22	FROM_DATE	Date(10)	DATE	From Date
23	THRU_DATE	Date(10)	DATE	Through Date
24	DATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	From and To Date Type A=Accounting Date J=Journal Date P=Posted Date T=Transaction Date Default Value: A
25	RUN_DT	Date(10)	DATE	Run Date Default Value: %DATE
26	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
27	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
28	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
29	KEY1	Character(65)	VARCHAR2(65) NOT NULL	First Key
30	KEY2	Character(65)	VARCHAR2(65) NOT NULL	Second Key
31	KEY3	Character(65)	VARCHAR2(65) NOT NULL	Third Key
32	KEY4	Character(65)	VARCHAR2(65) NOT NULL	Fourth Key
33	KEY5	Character(65)	VARCHAR2(65) NOT NULL	Fifth Key
34	KEY6	Character(65)	VARCHAR2(65) NOT NULL	Sixth Key
35	KEY_DATE_07	Date(10)	DATE	Key Date 07
36	KEY_NUM_8	Number(8,0)	INTEGER NOT NULL	Key Number 8
37	KEY_NUM_9	Number(8,0)	INTEGER NOT NULL	Key Number 9
38	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
39	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
40	AE_WHERE	Character(254)	VARCHAR2(254) NOT NULL	AE Generic Where Clause
41	AE_WHERE_1	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_1
42	AE_WHERE_2	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_2
43	AE_WHERE_3	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_3
44	AE_WHERE_4	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_4
45	AE_WHERE_5	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_5
46	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
47	AE_INT_2	Number(2,0)	SMALLINT NOT NULL	Number Work Field
48	AE_ROUND_INC	Signed Number(8,5)	DECIMAL(6,5) NOT NULL	Rounding Increment
49	AE_CNV_IN_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE input convert field
50	AE_CNV_OUT_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE output converion field
51	AE_CNV_JUSTIFY	Character(1)	VARCHAR2(1) NOT NULL	AE Convert Justify Indicator
52	AE_STRIP_ZERO	Character(1)	VARCHAR2(1) NOT NULL	AE Strip Zeros
53	AE_CHUNK_BY	Character(20)	VARCHAR2(20) NOT NULL	Chunking Method
54	AE_CHUNK_BY_VALUE	Character(15)	VARCHAR2(15) NOT NULL	Current value of chunk-by fld
55	AE_ALIAS_1	Character(15)	VARCHAR2(15) NOT NULL	AE Alias 1
56	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
57	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
58	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
59	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name