PY_MOD_GRPAC_VW (SQL View)	Index Back
Paycheck Modeling PayGroups Paycheck Modeling Configured Paygroups: - Status is Enabled - Status is Temporarily Disabled but current date is not covered by a discabled periods

PY_MOD_GRPAC_VW

(SQL View)

Paycheck Modeling PayGroups

Paycheck Modeling Configured Paygroups: - Status is Enabled - Status is Temporarily Disabled but current date is not covered by a discabled periods

SELECT A.COMPANY , A.PAYGROUP , A.PY_MOD_BTCHRUN_LCK FROM PS_PY_MOD_PAYGRP A WHERE ((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

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

#	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_MOD_BTCHRUN_LCK	Character(1)	VARCHAR2(1) NOT NULL	Lock Paycheck Modeling during pay calc or pay confirm batch run