TL_APP_RPLN_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
8	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
9	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
10	BGN_DT	Date(10)	DATE	Begin Date
11	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
12	END_DT	Date(10)	DATE	end date
13	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
14	TL_APPR_RPT_ADHOC	Character(7)	VARCHAR2(7) NOT NULL	TL adhoc approval group for reported time
15	TL_APPR_RPT_GRP1	Character(7)	VARCHAR2(7) NOT NULL	TL Approval Group on the workgroup and TRC page for reported time approvals
16	TL_APPR_RPT_GRP2	Character(7)	VARCHAR2(7) NOT NULL	TL Approval Group on the workgroup and TRC page for reported time approvals