GPBR_ESB_VW_LNG

(SQL View)
 Index Back

Establishment Brazil Rel Lng

Establishment Brazil Related Language View

SELECT DISTINCT DRV.COMPANY , CASE WHEN XRF.CAT_TYPE_BRA = '1' THEN '01' WHEN XRF.CAT_TYPE_BRA = '2' THEN '02' WHEN XRF.CAT_TYPE_BRA = '3' THEN '03' END , DRV.ESTABID ,C.LANGUAGE_CD , A.DESCR FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_ESTAB_TBL A , PS_ESTAB_TBL_BRA B ,PS_ESTAB_TBL_LANG C WHERE DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' AND A.ESTABID = B.ESTABID AND DRV.ESTABID = A.ESTABID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ESTAB_TBL A2 WHERE A2.ESTABID = A.ESTABID AND A2.EFFDT <= XRF.GPBR_ES_PS) AND A.ESTABID = C.ESTABID UNION SELECT DISTINCT DRV.COMPANY , '04' , DRV.ESTABID ,C.LANGUAGE_CD , A.DESCR FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_ESTAB_TBL A , PS_ESTAB_TBL_BRA B ,PS_ESTAB_TBL_LANG C WHERE DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' AND A.ESTABID = B.ESTABID AND DRV.ESTABID = A.ESTABID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ESTAB_TBL A2 WHERE A2.ESTABID = A.ESTABID AND A2.EFFDT <= XRF.GPBR_ES_PS) AND A.ESTABID = C.ESTABID

  • Related Language Record for GPBR_ESTAB3_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPBR_CAT_TYP2 Character(2) VARCHAR2(2) NOT NULL CAT Type Form
    01=Initial
    02=Reopened
    03=Death Communication
    04=All
    3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description