PY_MOD_EMPJOBLS

(SQL View)
 Index Back

Paycheck Modeling

This view list employee jobs that can be use to create a model check

SELECT DISTINCT A.COMPANY , A.PAYGROUP , A.EMPLID , A.EMPL_RCD FROM PS_JOB_CURR_ALL_VW A , PS_PY_MOD_PAYGRP B , PS_PAYGROUP_TBL G WHERE A.EMPL_STATUS IN ('A','P','Q','U') AND B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND G.COMPANY = A.COMPANY AND G.PAYGROUP = A.PAYGROUP AND G.EFF_STATUS = 'A' AND G.COUNTRY = 'USA' AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PS_PAYGROUP_TBL G_ED WHERE G.COMPANY = G_ED.COMPANY AND G.PAYGROUP = G_ED.PAYGROUP AND G_ED.EFFDT <= %CurrentDateIn)

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record