GPTH_SI_COMP_VW

(SQL View)
Index Back

Company SSO Info

Company SSO Info

SELECT A.COMPANY , A.GPTH_SI_ER_PER , A.GPTH_SI_ER_ACCT , G.PROCESS_INSTANCE ,G.EMPLID FROM PS_GPTH_SI_COMPANY A ,PS_GPTH_RPT_G_VW G WHERE A.COMPANY=G.COMPANY AND A.EFF_STATUS='A' AND A.EFFDT=( SELECT MAX(A_ED.EFFDT) FROM PS_GPTH_SI_COMPANY A_ED WHERE A_ED.COMPANY=A.COMPANY AND A_ED.EFFDT <= G.PRD_END_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPTH_SI_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Employer Contribution Rate
3 GPTH_SI_ER_ACCT Character(10) VARCHAR2(10) NOT NULL GPTH_SI_ER_ACCT
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID