GPTH_DEP_NID_VW

(SQL View)
 Index Back

EE Dep/Ben with NID

DEP_BEN_NID_VW is a view joining DEPENDENT_BENEF and NID.

SELECT A.EMPLID ,A.DEPENDENT_BENEF ,C.NATIONAL_ID_TYPE ,C.NATIONAL_ID ,B.RELATIONSHIP ,B.DEP_BENEF_TYPE ,B.SEX FROM PS_DEP_BEN A , PS_DEP_BEN_EFF B , PS_DEP_BENEF_NID C WHERE A.EMPLID = B.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_DEP_BEN_EFF B1 WHERE B1.EMPLID = B.EMPLID AND B1.DEPENDENT_BENEF = B.DEPENDENT_BENEF) AND A.EMPLID = C.EMPLID AND A.DEPENDENT_BENEF = C.DEPENDENT_BENEF AND C.COUNTRY='THA'

  • Parent record: PERSONAL_DATA

    • # 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 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    5 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    6 DEP_BENEF_TYPE Character(1) VARCHAR2(1) NOT NULL Dependent Beneficiary Type
    B=Beneficiary
    C=COBRA Dependent Only
    D=Dependent
    E=QDRO Estate
    N=None
    O=Both
    Q=QDRO Representative - Employee
    R=QDRO Representative -Recipient
    7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec

    Default Value: M