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

PY_LCK_PGRP_ACS

(SQL Table)

Page Grouping Access

Used to assign Page Grouping for a Company/Paygroup.

Related Language Record: PY_LCK_PGACS_LN

# 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 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive
Default Value: A

7 PY_LCK_ACCESS_OPT Character(1) VARCHAR2(1) NOT NULL Used in Lockout Access Controls
D=Disable Fully
E=Enable
T=Disable Temporarily
Default Value: E

8 PY_LCK_BTCHRUN_LCK Character(1) VARCHAR2(1) NOT NULL Lock component/s during pay calc or pay confirm batch run.
Y/N Table Edit
Default Value: N

9 PY_LCK_BATCH_RCNTL Character(1) VARCHAR2(1) NOT NULL Disable component while batch process pay calc or pay confirm is running.
B=Calculation & Confirmation
C=Calculation
F=Confirmation
N=Not Applicable
Default Value: N

10 PY_LCK_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in Lockout Access Controls
M=Message Catalog
T=Text
Default Value: M

11 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

13 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	ACTIVE_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Definition Active or Inactive? A=Active I=Inactive Default Value: A
7	PY_LCK_ACCESS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Used in Lockout Access Controls D=Disable Fully E=Enable T=Disable Temporarily Default Value: E
8	PY_LCK_BTCHRUN_LCK	Character(1)	VARCHAR2(1) NOT NULL	Lock component/s during pay calc or pay confirm batch run. Y/N Table Edit Default Value: N
9	PY_LCK_BATCH_RCNTL	Character(1)	VARCHAR2(1) NOT NULL	Disable component while batch process pay calc or pay confirm is running. B=Calculation & Confirmation C=Calculation F=Confirmation N=Not Applicable Default Value: N
10	PY_LCK_MSG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in Lockout Access Controls M=Message Catalog T=Text Default Value: M
11	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGSETDEFN
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
13	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.