TL_TA000900_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
3	KEEP_GOING	Character(1)	VARCHAR2(1) NOT NULL	Keep Going Flag for App Engine....
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
9	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan
10	EFFDT_USED	Date(10)	DATE	Date driving 'processed' code
11	EXPIRE_PER	Character(1)	VARCHAR2(1) NOT NULL	Expiration Period D=Days M=Months N=Never Y=Years Default Value: N
12	EXPIRE_NUM	Number(3,0)	SMALLINT NOT NULL	Expiration Number
13	HRS_GO_POSITIVE	Character(1)	VARCHAR2(1) NOT NULL	This Field is used as an Indicator to limit Positive Compensatory Time Off Plan Y/N Table Edit Default Value: N
14	MAX_POS_HRS	Number(4,0)	SMALLINT NOT NULL	Max Positive Hours Allowed
15	HRS_GO_NEGATIVE	Character(1)	VARCHAR2(1) NOT NULL	Accrued Balance Go Negative Y/N Table Edit Default Value: N
16	MAX_DT	Date(10)	DATE	Max Date
17	MAX_NEG_HRS	Number(4,0)	SMALLINT NOT NULL	This Field is used to Define Maximum Positive Hours Allowed for a Compensatory Time Off Plan and for Leave Plan
18	CALC_EXP_DT	Date(10)	DATE	calculated expiry date
19	MSG_DATA1	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 1
20	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
21	TL_QUANTITY1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
22	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
23	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
24	VALID_DEFN_ID	Character(10)	VARCHAR2(10) NOT NULL	Validation ID
25	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID