HCI_PDATA_BRAVW

(SQL View)
 Index Back

Person Data Brazil View

Personal Data Effective Date Child Brazil View

SELECT EMPLID ,EFFDT ,NATIONALITY_CD_BRA ,EDUCATION_LVL_BRA 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 NATIONALITY_CD_BRA Character(2) VARCHAR2(2) NOT NULL Nationality code Brazil
    4 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