PERS_DATA_MEX

(SQL Table)
 Index Back

Personal Data Effdt Mexico

Personal Data Effdt Mexico

  • 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