TL_TS_LOCKDOWN (SQL Table)	Index Back
Timesheet Lockdown Record enables and tracks lockdown to prevent timesheet updates at the pay group level.

TL_TS_LOCKDOWN

(SQL Table)

Timesheet Lockdown

Record enables and tracks lockdown to prevent timesheet updates at the pay group level.

# 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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

4 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

5 LOCK_IND Character(1) VARCHAR2(1) NOT NULL Field introduced with feature to lock and unlock timesheets for updates, which may be desirable in the payroll window.
Y/N Table Edit
Default Value: N

6 LOCK_CURR_IND Character(1) VARCHAR2(1) NOT NULL Field introduced with feature to lock and unlock timesheets for updates, which may be desirable in the payroll window. Lock Current and Prior Period
Y/N Table Edit
Default Value: N

#	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	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
5	LOCK_IND	Character(1)	VARCHAR2(1) NOT NULL	Field introduced with feature to lock and unlock timesheets for updates, which may be desirable in the payroll window. Y/N Table Edit Default Value: N
6	LOCK_CURR_IND	Character(1)	VARCHAR2(1) NOT NULL	Field introduced with feature to lock and unlock timesheets for updates, which may be desirable in the payroll window. Lock Current and Prior Period Y/N Table Edit Default Value: N