GPTH_PF_VW

(SQL View)
 Index Back

To fetch data for PF query

GPTH_PF_VW is used to fetch data for query GPTH_PF_QRY

SELECT A.GPTH_PF_MNGR , A.GPTH_PF_MBRSHIP , D.COMPANY , A.EMPLID , D.CAL_RUN_ID , D.PAYMENT_DATE , B.DESCR100 , C.LAST_NAME , C.FIRST_NAME , A.GPTH_PF_ER_PER , A.GPTH_PF_EE_PER , D.GPTH_SAL_BAS_EARN , D.GPTH_SAL_BAS_EARN * A.GPTH_PF_ER_PER / 100 AS GPTH_PF_ER_CONTRI , D.GPTH_SAL_BAS_EARN * A.GPTH_PF_EE_PER / 100 AS GPTH_PF_EE_CONTRI FROM PS_GPTH_PF_DATA A , PS_GPTH_PF_MRNM B , PS_PERSON_NAME C , PS_GPTH_PF_RSLT D WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPTH_PF_DATA A_ED WHERE A.EMPLID = A_ED.EMPLID AND A_ED.EFFDT <= D.PAYMENT_DATE) AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPTH_PF_MRNM B_ED WHERE B.GPTH_PF_MNGR = B_ED.GPTH_PF_MNGR AND B_ED.EFFDT <= D.PAYMENT_DATE) AND A.GPTH_PF_MNGR = B.GPTH_PF_MNGR AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND D.EMPL_RCD = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPTH_PF_MNGR Character(50) VARCHAR2(50) NOT NULL Provident Fund Manager Name
2 GPTH_PF_MBRSHIP Character(30) VARCHAR2(30) NOT NULL Payee member ship number
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 PAYMENT_DATE Date(10) DATE NOT NULL Payment Date
7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 GPTH_PF_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Provident Fund Employer Rate
11 GPTH_PF_EE_PER Number(5,2) DECIMAL(4,2) NOT NULL Provident Fund Employee Rate
12 GPTH_SAL_BAS_EARN Signed Number(20,6) DECIMAL(18,6) NOT NULL Salary Base earn THA
13 GPTH_PF_ER_CONTRI Signed Number(20,6) DECIMAL(18,6) NOT NULL Provident fund Employer rate
14 GPTH_PF_EE_CONTRI Signed Number(20,6) DECIMAL(18,6) NOT NULL Provident fund employee rate