GPTH_SI_COMPVW1

(SQL View)
Index Back

Get Business Code Type

GPTH_SI_ COMPVW1 is used to get Business Code and Business Type.

SELECT A.COMPANY , A.GPTH_SI_ER_ACCT , A.GPTH_SI_ER_PER , A.GPTH_SI_EE_PER , A.GPTH_SI_BUS_CODE , A.GPTH_SI_BUS_TYPE , G.PROCESS_INSTANCE ,G.EMPLID FROM PS_GPTH_SI_COMPANY A ,PS_GPTH_RPT_G_TMP 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) AND G.PRC_ORD_TS=( SELECT MAX(G_ED.PRC_ORD_TS) FROM PS_GPTH_RPT_G_TMP G_ED WHERE G.PROCESS_INSTANCE=G_ED.PROCESS_INSTANCE AND G.EMPLID=G_ED.EMPLID AND G.EMPL_RCD=G_ED.EMPL_RCD) GROUP BY A.COMPANY , A.GPTH_SI_ER_ACCT , A.GPTH_SI_ER_PER , A.GPTH_SI_EE_PER , A.GPTH_SI_BUS_CODE , A.GPTH_SI_BUS_TYPE , G.PROCESS_INSTANCE ,G.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPTH_SI_ER_ACCT Character(10) VARCHAR2(10) NOT NULL GPTH_SI_ER_ACCT
3 GPTH_SI_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Employer Contribution Rate
4 GPTH_SI_EE_PER Number(5,2) DECIMAL(4,2) NOT NULL Employee Contribution Rate
5 GPTH_SI_BUS_CODE Character(10) VARCHAR2(10) NOT NULL This field will be used to store total business type code information.
6 GPTH_SI_BUS_TYPE Character(40) VARCHAR2(40) NOT NULL This field will be used to store business type information.
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID