TL_PAYCALC_EDIT (SQL Table)	Index Back
Time and Labor Recalc table This table is used during the payroll calculation process. If a Time and Labor paysheet record encounters a change due to a late change to the job or tax tables, the record is written to this table for reprocessing through pay update

TL_PAYCALC_EDIT

(SQL Table)

Time and Labor Recalc table

This table is used during the payroll calculation process. If a Time and Labor paysheet record encounters a change due to a late change to the job or tax tables, the record is written to this table for reprocessing through pay update

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

3 PAY_END_DT Date(10) DATE Pay Period End Date

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #

6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

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

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
5	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
6	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr