IMMEDIATE_FAMLY

(SQL View)
 Index Back

EE Immediate Family Members

IMMEDIATE_FAMILY is one of a group of records used to record information about an employee's job assignments away from home base. Use IMMEDIATE_FAMILY to identify an employee's dependents.

SELECT A.EMPLID ,A.DEPENDENT_BENEF ,A.BIRTHDATE ,A.BIRTHPLACE ,A.RELATIONSHIP ,A.NAME ,A.MAR_STATUS ,A.STUDENT ,A.OCCUPATION FROM PS_DEPENDENT_VW A WHERE A.RELATIONSHIP IN('SP','C') AND A.DEP_BENEF_TYPE <> 'C'

  • Related Language Record: IMEDIAT_FML_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
    3 BIRTHDATE Date(10) DATE Date of Birth
    4 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    5 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    8 STUDENT Character(1) VARCHAR2(1) NOT NULL Student
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 OCCUPATION Character(40) VARCHAR2(40) NOT NULL Occup