PERSDATA_BRA_CV

(SQL View)
 Index Back

Persona Data BRA - Clairvia

Clone of PERSON_DATA_BRA record for Clairvia Fullsync message

SELECT BRA.EMPLID , BRA.EFFDT , BRA.REG_REGION , BRA.ETHNIC_GRP_CD , BRA.NATIONALITY_CD_BRA , BRA.EDUCATION_LVL_BRA , BRA.SETID FROM PS_PERS_DATA_BRA BRA , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_DATA_BRA,BRA,%CurrentDateIn) AND ASG.EMPLID = BRA.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

  • 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

    Default Value: OPR_DEF_TBL_HR.REG_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