DEP_BEN_EFF_BRA

(SQL Table)
 Index Back

Brazil Dependent Record

Brazil Dependent Record

  • Parent record: DEP_BEN

    • # 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_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 STUDENT_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Student 1/0

    1/0 Table Edit (1=True, 0=False)

    Default Value: 0

    5 EDUCATION_LVL_BRA Character(2) VARCHAR2(2) NOT NULL Education Level Brazil
    01=Analphabet
    02=5th (4th old) Grade Incomplete
    03=5th (4th old) Grade Complete
    04=6th to 9th Grade Incomplete
    05=Elementary School Complete
    06=Medium School Incomplete
    07=Medium School Complete
    08=University Incomplete
    09=University Complete
    10=Post Graduation/Specialization
    11=Post Graduation -- Complete
    12=Master Degree -- Incomplete
    13=Master Degree -- Complete
    14=Ph Degree -- Incomplete
    15=Ph Degree -- Complete
    16=Post Ph Degree -- Incomplete
    17=Post Ph Degree -- Complete

    Default Value: 01

    6 EDUCATION_IND_BRA Number(1,0) SMALLINT NOT NULL Dependent - Brazil University or Technical Level

    1/0 Table Edit (1=True, 0=False)

    Default Value: 0

    7 VACCINE_CERT_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Vaccination Certificate

    1/0 Table Edit (1=True, 0=False)

    Default Value: 0

    8 DISABLED_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Disabled 1/0

    1/0 Table Edit (1=True, 0=False)

    Default Value: 0

    9 FAM_ALLOW_TERM_BRA Character(2) VARCHAR2(2) NOT NULL Family Allowance Termination Code
    10=Dependent exceeds ceiling age
    20=Child Abandonment
    30=Dependent's Death
    40=End Disability
    50=Court Decision
    60=Child Custody
    70=Termination
    10 FAM_TERM_DT_BRA Date(10) DATE Family Allowance Termination Date Brazil