PY_WC_PAYGRP (SQL Table)	Index Back
Setup Table for NA WorkCenter This is used to set up for a paygroup in WorkCenter, such as threshold amounts / hours for payroll alerts.

PY_WC_PAYGRP

(SQL Table)

Setup Table for NA WorkCenter

This is used to set up for a paygroup in WorkCenter, such as threshold amounts / hours for payroll alerts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 PY_THRESHOLD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Payroll WorkCenter paycheck threshold total gross.

4 PY_THRESHOLD_HR Signed Number(9,2) DECIMAL(7,2) NOT NULL Payroll WorkCenter paycheck threshold total hours.

5 PY_TH_AMT_INACT_EE Signed Number(12,2) DECIMAL(10,2) NOT NULL Payroll WorkCenter paycheck threshold total gross for inactive employees.

6 PY_TH_HR_INACT_EE Signed Number(9,2) DECIMAL(7,2) NOT NULL Payroll WorkCenter paycheck threshold total hours for inactive employees.

7 PY_INCL_PAYGRP Character(1) VARCHAR2(1) NOT NULL Include Pay Group.
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 Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PY_THRESHOLD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Payroll WorkCenter paycheck threshold total gross.
4	PY_THRESHOLD_HR	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Payroll WorkCenter paycheck threshold total hours.
5	PY_TH_AMT_INACT_EE	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Payroll WorkCenter paycheck threshold total gross for inactive employees.
6	PY_TH_HR_INACT_EE	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Payroll WorkCenter paycheck threshold total hours for inactive employees.
7	PY_INCL_PAYGRP	Character(1)	VARCHAR2(1) NOT NULL	Include Pay Group. Y/N Table Edit Default Value: N