PERS_DATA_BRA

(SQL Table)
 Index Back

Persona Data Effdt

Personal Data Effective Date Child Brazil

  • Parent record: PERS_DATA_EFFDT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 ETHNIC_GROUP_BRA Character(2) VARCHAR2(2) NOT NULL Ethnic Group Brazil
    01=Native
    02=White
    04=Black
    06=Yellow
    08=Brown
    09=Non Informed
    4 NATIONALITY_CD_BRA Character(2) VARCHAR2(2) NOT NULL Nationality code Brazil

    Default Value: BR

    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
    6 ARRIVAL_DATE_BRA Date(10) DATE Arrival date to Brazil
    7 NATURAL_DT_BRA Date(10) DATE Naturalization Date
    8 SPOUSE_IND_BRA Character(1) VARCHAR2(1) NOT NULL Brazilian Spouse Indicator

    Y/N Table Edit

    Default Value: N

    9 CHILDREN_IND_BRA Character(1) VARCHAR2(1) NOT NULL Brazilian Children

    Y/N Table Edit

    Default Value: N