GPTH_SI_COMPVW1(SQL View) |
Index Back |
---|---|
Get Business Code TypeGPTH_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 |