GPBR_EID_VW_LNG

(SQL View)
 Index Back

Establishment ID Rel Lng View

Related Language View used by SEFIP Autonomous to display Establishment ID and its related Establishment data.

SELECT %Substring(b.estab_id_bra,1,14) ,c.language_cd , a.estabid , c.descr FROM PS_ESTAB_TBL a , ps_estab_id_bra b , PS_ESTAB_TBL_lang c WHERE a.country = 'BRA' AND a.effdt = ( SELECT MAX(effdt) FROM PS_ESTAB_TBL WHERE estabid = a.estabid AND country = a.country AND effdt <= %CurrentDateIn) AND b.estabid = a.estabid AND b.effdt = a.effdt AND b.country = a.country AND b.estab_id_type_bra IN('CEI', 'CNPJ') AND b.estabid = c.estabid AND b.effdt = c.effdt

  • Related Language Record for GPBR_EID_EST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_INSCR Character(14) VARCHAR2(14) NOT NULL Company Inscription Brazil
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description