TL_TA000300_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 Record
4	EFFDT	Date(10)	DATE	Effective Date
5	EMPL_EFFDT	Date(10)	DATE	Effective Date from EMPL_DATA
6	START_DT	Date(10)	DATE	Start Date
7	END_DT	Date(10)	DATE	end date
8	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup
9	RULE_PGM_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule Program ID
10	RULEPGM_EFFDT	Date(10)	DATE	Rule Program Date
11	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
12	BATCH_NUM	Number(4,0)	SMALLINT NOT NULL	Batch Number
13	TIME_RPTG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Time Reporter Status A=Active I=Inactive
14	ORIG_END_DT	Date(10)	DATE	Unadjusted End Date
15	WRKGRP_EFFDT	Date(10)	DATE	Workgroup Effective Date
16	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
17	COMB_PRI_WRK	Number(3,0)	SMALLINT NOT NULL	Prior SEQ_NBR for combining
18	COMB_NXT_WRK	Number(3,0)	SMALLINT NOT NULL	Next SEQ_NBR for combining
19	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
20	IN_BATCH	Character(1)	VARCHAR2(1) NOT NULL	In Batch
21	TA_COUNT	Number(15,0)	DECIMAL(15) NOT NULL	Utility field used in TA process to hold various counts, such as the number of EEs in a batch.
22	TA_PREV_COUNT	Number(15,0)	DECIMAL(15) NOT NULL	Utility field used in TA process to hold various counts, such as the number of EEs in a batch.