FO_PAYGROUP_VW

(SQL View)
 Index Back

Paygroup view for Proj Profile

Not including company in this view because at this point the user will not enter a company at the proj profile. Allows users to choose from ALL valid paygrouips

SELECT DISTINCT A.PAYGROUP ,A.DESCR ,A.DESCRSHORT FROM PS_PAYGROUP_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PAYGROUP_TBL B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description