PY_MOD_PGRP_VW1

(SQL View)
 Index Back

Paycheck Modeling PayGroups

Paycheck Modeling Authorized Paygroups: - Not locked dur to regular payroll confirmation run - Status is Enabled

SELECT DISTINCT A.COMPANY , A.PAYGROUP , A.PY_MOD_ACCES_CNTRL FROM PS_PY_MOD_PAYGRP A WHERE A.PY_MOD_BTCHRUN_LCK <> 'Y' AND A.PY_MOD_ACCES_CNTRL <> 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PY_MOD_ACCES_CNTRL Character(1) VARCHAR2(1) NOT NULL Paycheck Modeling access controls
D=Disable Fully
E=Enable
T=Disable Temporarily