PY_MOD_PAYGRP (SQL Table)	Index Back
Paychk Mod Paygrup Setup Tbl Paycheck Modeling Paygroup Setup table

PY_MOD_PAYGRP

(SQL Table)

Paychk Mod Paygrup Setup Tbl

Paycheck Modeling Paygroup Setup table

Parent Record Of PY_MOD_PGDEDLNG PY_MOD_PGERNLNG PY_MOD_PGRP_DED PY_MOD_PGRP_ERN PY_MOD_PGRP_PRD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 PY_MOD_ACCES_CNTRL Character(1) VARCHAR2(1) NOT NULL Paycheck Modeling access controls
D=Disable Fully
E=Enable
T=Disable Temporarily
Default Value: E

4 PY_MOD_BATCH_RCNTL Character(1) VARCHAR2(1) NOT NULL Disable Paycheck Modeling while batch process pay calc or pay confirm is running

5 PY_MOD_BTCHRUN_LCK Character(1) VARCHAR2(1) NOT NULL Lock Paycheck Modeling during pay calc or pay confirm batch run

6 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
Default Value: 0

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: PY_MOD_COMP_VW
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PY_MOD_PGRDS_VW
3	PY_MOD_ACCES_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Paycheck Modeling access controls D=Disable Fully E=Enable T=Disable Temporarily Default Value: E
4	PY_MOD_BATCH_RCNTL	Character(1)	VARCHAR2(1) NOT NULL	Disable Paycheck Modeling while batch process pay calc or pay confirm is running
5	PY_MOD_BTCHRUN_LCK	Character(1)	VARCHAR2(1) NOT NULL	Lock Paycheck Modeling during pay calc or pay confirm batch run
6	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr Default Value: 0
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.