TL_APP_ABS (SQL Table)	Index Back
TL Approvals Abs TL approvals absence record will contain the record key structure to tie the TL and absence approval transactions back to the approval framework.

TL_APP_ABS

(SQL Table)

TL Approvals Abs

TL approvals absence record will contain the record key structure to tie the TL and absence approval transactions back to the approval framework.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

5 BGN_DT Date(10) DATE Begin Date

6 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

7 END_DT Date(10) DATE end date

8 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	BGN_DT	Date(10)	DATE	Begin Date
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
7	END_DT	Date(10)	DATE	end date
8	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.