PERS_DATABRA_VW

(SQL View)
 Index Back

Persona Data Effdt

Personal Data Effective Date Child Brazil

SELECT EMPLID , EFFDT , REG_REGION , ETHNIC_GRP_CD , NATIONALITY_CD_BRA , EDUCATION_LVL_BRA , SETID , ' ' FROM PS_PERS_DATA_BRA

  • 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 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    4 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL

    5 NATIONALITY_CD_BRA Character(3) VARCHAR2(3) NOT NULL Nationality code Brazil
    6 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
    7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    8 BLOOD_TYPE Character(3) VARCHAR2(3) NOT NULL Blood Type
    A+=A+
    A-=A-
    AB+=AB+
    AB-=AB-
    B+=B+
    B-=B-
    O+=O+
    O-=O-
    U=Unknown