PERSDATA_MEX_CV

(SQL View)
 Index Back

Personal Data Effdt Mexico

Personal Data Effdt Mexico

SELECT MEX.EMPLID , MEX.EFFDT , MEX.AFORE_MEX , MEX.MED_REC_CD_MEX FROM PS_PERS_DATA_MEX MEX , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_DATA_MEX,MEX,%CurrentDateIn) AND ASG.EMPLID = MEX.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PERSON.EMPLID

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 AFORE_MEX Character(4) VARCHAR2(4) NOT NULL AFORE retirement Found code Mexico
    0010=Allianz Dresdner
    0020=Banamex Aegon
    0030=Bancomer
    0040=Garante
    0050=Inbursa
    0060=ING
    0070=Principal
    0080=Profuturo GNP
    0090=Santander Mexicano
    0100=Tepeyac
    0110=XXI
    0120=Zurich
    0130=Banorte Generalli
    4 MED_REC_CD_MEX Character(3) VARCHAR2(3) NOT NULL Medic Region Code Mexico