PERSON_BRA_CV

(SQL View)
 Index Back

PERSON BRAZIL Clairvia

Clone of PERSON_BRA record for Clairvia Fullsync message

SELECT BRA.EMPLID , BRA.RG_ISSUEDBY_BRA , BRA.RG_ISSUED_DT_BRA , BRA.RG_STATE_BRA , BRA.CTPS_SERIES_BRA , BRA.CTPS_EXP_DT_BRA , BRA.CTPS_STATE_BRA , BRA.VOTER_ZONE_BRA , BRA.VOTER_SECTION_BRA , BRA.VOTER_CITY_BRA , BRA.VOTER_STATE_BRA , BRA.MILITAR_SERIES_BRA , BRA.MILITAR_REGION_BRA , BRA.MILITAR_STATE_BRA , BRA.MIL_CERT_TYPE_BRA , BRA.MILITAR_CAT_BRA , BRA.PIS_PASEP_DT_BRA FROM PS_PERSON_BRA BRA , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = BRA.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
    2 RG_ISSUEDBY_BRA Character(20) VARCHAR2(20) 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