TL_TR_CTVAL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
7	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan
8	EFFDT_USED	Date(10)	DATE	Date driving 'processed' code
9	ERN_EFFDT_USED	Date(10)	DATE	Date driving 'processed' code
10	TKN_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_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
17	CALC_EXP_DT	Date(10)	DATE	calculated expiry date
18	MAX_DT	Date(10)	DATE	Max Date
19	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field
20	VALID_INST_ID	Number(15,0)	DECIMAL(15) NOT NULL	Validation Instance
21	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
22	SAVE_IND	Character(1)	VARCHAR2(1) NOT NULL	Archive Exception
23	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
24	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
25	TABLE_NAME1	Character(30)	VARCHAR2(30) NOT NULL	Table Name