TL_VALID_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VALID_STREAM_ID	Number(15,0)	DECIMAL(15) NOT NULL	Validation Stream ID
3	VALID_INST_ID	Number(15,0)	DECIMAL(15) NOT NULL	Validation Instance
4	VALID_DEFN_ID	Character(10)	VARCHAR2(10) NOT NULL	Validation ID
5	VALID_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Validation Set
6	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
7	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
8	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
11	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date. Default Value: %date
12	SAVE_IND	Character(1)	VARCHAR2(1) NOT NULL	Archive Exception Y/N Table Edit Default Value: N
13	TIME_RPTG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Time Reporting Type E=Exception Time Reporting P=Positive Time Reporting
14	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)
15	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
16	TL_VALID_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Validation Option
17	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
18	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
19	FUT_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Allow Future Time Entry
20	FUT_ALLOW	Number(3,0)	SMALLINT NOT NULL	Future Days Grace Allowed
21	PPA_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Prior Period Adjustment Access
22	PPA_ALLOW	Number(3,0)	SMALLINT NOT NULL	Days from Prd End Dt to Adj
23	PY_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Restrict Prior Year Time Entry
24	PY_MONTH	Character(2)	VARCHAR2(2) NOT NULL	Prior Year Ends In 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
25	USE_TL_SYSDATE	Character(1)	VARCHAR2(1) NOT NULL	Use TL System Date
26	TL_SYSTEM_DT	Date(10)	DATE	TL System Date
27	YEAR_START_DT	Date(10)	DATE	Year Start Date
28	MIN_START_DT	Date(10)	DATE	Min Start Date
29	MAX_DATE	Date(10)	DATE	Maximum Date
30	TL_CF_VALID_CALLED	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Validation Called
31	TL_SQL_TEXT	Long Character	CLOB	Used for displaying SQL Text.
32	TL_CR_PARTIAL_HRS	Character(1)	VARCHAR2(1) NOT NULL	Create Parital Work hours configuration at Workgroup level
33	START_DT	Date(10)	DATE	Start Date
34	END_DT	Date(10)	DATE	end date