PERSON_BRA

(SQL Table)
Index Back

PERSON BRAZIL

Complementary Data For Brazil

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 RG_ISSUEDBY_BRA Character(5) VARCHAR2(5) NOT NULL RG Issued By
    3 RG_ISSUED_DT_BRA Date(10) DATE RG Issued DT
    4 RG_STATE_BRA Character(6) VARCHAR2(6) NOT NULL RG State

    Prompt Table: STATE_BRA_VW

    5 CTPS_SERIES_BRA Character(5) VARCHAR2(5) NOT NULL CTPS Series
    6 CTPS_EXP_DT_BRA Date(10) DATE CTPS Expedition Date
    7 CTPS_STATE_BRA Character(6) VARCHAR2(6) NOT NULL CTPS State

    Prompt Table: STATE_BRA_VW

    8 VOTER_ZONE_BRA Character(3) VARCHAR2(3) NOT NULL Voter Zone
    9 VOTER_SECTION_BRA Character(4) VARCHAR2(4) NOT NULL Voter Section
    10 VOTER_CITY_BRA Character(30) VARCHAR2(30) NOT NULL Voter City
    11 VOTER_STATE_BRA Character(6) VARCHAR2(6) NOT NULL Voter State

    Prompt Table: STATE_BRA_VW

    12 MILITAR_SERIES_BRA Character(1) VARCHAR2(1) NOT NULL Military Series
    13 MILITAR_REGION_BRA Character(2) VARCHAR2(2) NOT NULL Military Region
    14 MILITAR_STATE_BRA Character(6) VARCHAR2(6) NOT NULL Military State Brazil

    Prompt Table: STATE_BRA_VW

    15 MIL_CERT_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Military Certificate Type
    01=Marine
    02=Army
    03=Aeronautic
    04=Other
    16 MILITAR_CAT_BRA Character(2) VARCHAR2(2) NOT NULL Military Category
    01=First
    02=Second
    03=Third
    04=Dispense
    05=Other
    17 PIS_PASEP_DT_BRA Date(10) DATE PIS/PASEP Date Brazil