PY_LCK_PGACS_LN (SQL Table)	Index Back
Page Grouping Access Used to assign Page Grouping for a Company/Paygroup.

PY_LCK_PGACS_LN

(SQL Table)

Page Grouping Access

Used to assign Page Grouping for a Company/Paygroup.

Related Language Record for PY_LCK_PGRP_ACS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_LCK_TARGET_USER Character(1) VARCHAR2(1) NOT NULL Used in Lockout Access Controls
G=General
P=Payroll

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: PY_MOD_COMP_VW

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PY_MOD_PGRDS_VW

4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

5 PY_LCK_PGRP_ID Character(3) VARCHAR2(3) NOT NULL Payroll Lock Down Component Group ID
Prompt Table: %EDITTABLE

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_LCK_TARGET_USER	Character(1)	VARCHAR2(1) NOT NULL	Used in Lockout Access Controls G=General P=Payroll
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: PY_MOD_COMP_VW
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PY_MOD_PGRDS_VW
4	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
5	PY_LCK_PGRP_ID	Character(3)	VARCHAR2(3) NOT NULL	Payroll Lock Down Component Group ID Prompt Table: %EDITTABLE
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.