PY_PAYGRP_TASK (SQL Table)	Index Back
Paygroups Use PAYGROUP_TBL to group employees by how they are paid. For example, if your company has both salaried and hourly employees, you might set up a monthly paygroup for the salaried employees paid once a month, and another paygroup for hourly employees paid weekly. Use a subordinate record, PAYGRP_EMPLTYPE, to identify the valid employee types for each paygroup.

PY_PAYGRP_TASK

(SQL Table)

Paygroups

Use PAYGROUP_TBL to group employees by how they are paid. For example, if your company has both salaried and hourly employees, you might set up a monthly paygroup for the salaried employees paid once a month, and another paygroup for hourly employees paid weekly. Use a subordinate record, PAYGRP_EMPLTYPE, to identify the valid employee types for each paygroup.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: OPR_DEF_TBL_HR.COMPANY
Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 PY_LDTL_TASK_FLD Character(1) VARCHAR2(1) NOT NULL T&&L Elements to Paysheets
A=Account Code
B=Business Unit
C=Activity ID
D=Department
J=Job Code
L=Locality
P=Position Number
R=Project ID
S=State
U=PC Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: OPR_DEF_TBL_HR.COMPANY Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	PY_LDTL_TASK_FLD	Character(1)	VARCHAR2(1) NOT NULL	T&&L Elements to Paysheets A=Account Code B=Business Unit C=Activity ID D=Department J=Job Code L=Locality P=Position Number R=Project ID S=State U=PC Business Unit