GPTH_SI_EE_VW

(SQL View)
 Index Back

Employee Contribution Rate

GPTH_SI_EE_VW is used to get Employee Contribution Rate.

SELECT B.EMPLID , A.GPTH_SI_EE_PER FROM PS_GPTH_SI_COMPANY A , PS_JOB_VW B WHERE A.COMPANY = B.COMPANY AND B.effdt = ( SELECT MAX(C.effdt) FROM PS_JOB_VW C WHERE C.emplid = B.emplid AND C.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GPTH_SI_COMPANY D WHERE A.COMPANY = D.COMPANY AND D.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 GPTH_SI_EE_PER Number(5,2) DECIMAL(4,2) NOT NULL Employee Contribution Rate