GPJP_DEP_NM_VW

(SQL View)
 Index Back

VIEW USED IN WITHHOLDING TAX

View is used in withholding tax efile app engine

SELECT A.EMPLID , A.DEPENDENT_BENEF , PR.PERS_NUMBER_JPN , A.NAME_FORMAL , A.NAME_AC , A.NAME , B.GPJP_NO_RSDNT_RLTV , D.RELATIONSHIP , PRD.PERS_NUMBER_JPN , E.BIRTHDATE FROM PS_DEP_BEN_NAME A LEFT OUTER JOIN PS_GPJP_IT_D_TX_VW B ON A.EMPLID = B.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF , PS_DEP_BEN_EFF D ,PS_DEP_BEN E LEFT OUTER JOIN PS_PERS_NID_JPN PR ON PR.EMPLID = E.EMPLID LEFT OUTER JOIN PS_PERS_DNID_JPN PRD ON PRD.EMPLID = E.EMPLID AND PRD.DEPENDENT_BENEF = E.DEPENDENT_BENEF WHERE A.EMPLID = D.EMPLID AND A.EMPLID = E.EMPLID AND A.DEPENDENT_BENEF = D.DEPENDENT_BENEF AND A.DEPENDENT_BENEF = E.DEPENDENT_BENEF AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_DEP_BEN_NAME A_ED WHERE A_ED.EMPLID = A.EMPLID AND A_ED.DEPENDENT_BENEF = A.DEPENDENT_BENEF) AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_DEP_BEN_EFF D_ED WHERE D_ED.EMPLID = D.EMPLID AND D_ED.DEPENDENT_BENEF = D.DEPENDENT_BENEF)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
3 GPJP_NTNLID Character(150) VARCHAR2(150) NOT NULL USED IN EFILE
4 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 GPJP_NO_RSDNT_RLTV Character(1) VARCHAR2(1) NOT NULL Non-Resident Relative indicator
8 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
9 PERS_NUMBER_JPN Character(150) VARCHAR2(150) NOT NULL This field stores the My Number of each employee and dependent.
10 BIRTHDATE Date(10) DATE Date of Birth