PAYGRP_EMPLTYPE (SQL Table)	Index Back
Paygroup Employee Types Use PAYGRP_EMPLTYPE to identify the valid employee types for each paygroup. A paygroup is a set of employees grouped 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. You must create a paygroup record on the PAYGROUP_TBL before you can enter data on PAYGRP_EMPLTYPE.

PAYGRP_EMPLTYPE

(SQL Table)

Paygroup Employee Types

Use PAYGRP_EMPLTYPE to identify the valid employee types for each paygroup. A paygroup is a set of employees grouped 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. You must create a paygroup record on the PAYGROUP_TBL before you can enter data on PAYGRP_EMPLTYPE.

Parent record: PAYGROUP_TBL

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Prompt Table: EMPL_TYPE_VW

5 PRINT_PAY_SHEET Character(1) VARCHAR2(1) NOT NULL Print Paysheets
Y/N Table Edit
Default Value: Y

6 CONF_REQD_JOB Character(1) VARCHAR2(1) NOT NULL Confirmation Reqd for Job
Y/N Table Edit
Default Value: Y

7 CONF_REQD_PARTIAL Character(1) VARCHAR2(1) NOT NULL Confirmation Reqd for Partial
Y/N Table Edit
Default Value: Y

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried Prompt Table: EMPL_TYPE_VW
5	PRINT_PAY_SHEET	Character(1)	VARCHAR2(1) NOT NULL	Print Paysheets Y/N Table Edit Default Value: Y
6	CONF_REQD_JOB	Character(1)	VARCHAR2(1) NOT NULL	Confirmation Reqd for Job Y/N Table Edit Default Value: Y
7	CONF_REQD_PARTIAL	Character(1)	VARCHAR2(1) NOT NULL	Confirmation Reqd for Partial Y/N Table Edit Default Value: Y