PY_MOD_APGRP_VW (SQL View)	Index Back
Paycheck Modeling PayGroups Paycheck Modeling Authorized Paygroups: - Not locked due to regular payroll confirmation run - Status is Enabled - Status is Temporarily Disabled but current date is not covered by a discabled periods

PY_MOD_APGRP_VW

(SQL View)

Paycheck Modeling PayGroups

Paycheck Modeling Authorized Paygroups: - Not locked due to regular payroll confirmation run - Status is Enabled - Status is Temporarily Disabled but current date is not covered by a discabled periods

SELECT A.COMPANY , A.PAYGROUP FROM PS_PY_MOD_PAYGRP A WHERE A.PY_MOD_BTCHRUN_LCK <> 'Y' AND ((A.PY_MOD_ACCES_CNTRL = 'E' ) OR (A.PY_MOD_ACCES_CNTRL = 'T' AND NOT EXISTS ( SELECT 'Y' FROM PS_PY_MOD_PGRP_PRD B WHERE B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND (%CurrentDateTimeIn BETWEEN %Dttm(B.START_DT,B.START_TIME) AND %Dttm(B.END_DT, B.END_TIME)))))

# 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

#	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