TL_EMPLCOMP (SQL Table)	Index Back
TR Compensatory Time Off Plan This object is defined to satisfy the scroll levels while defining comp plans to employees. This table will be the parent of TL_EMPL_COMP table

TL_EMPLCOMP

(SQL Table)

TR Compensatory Time Off Plan

This object is defined to satisfy the scroll levels while defining comp plans to employees. This table will be the parent of TL_EMPL_COMP table

# 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 Rcd Nbr
Default Value: 0

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	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 Rcd Nbr Default Value: 0
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date