GPBR_ESTAB3_VW

(SQL View)
 Index Back

Establishment Brazil

Establishment Brazil

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 , A.DESCR FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_ESTAB_TBL A , PS_ESTAB_TBL_BRA B 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) UNION SELECT DISTINCT DRV.COMPANY , '04' , DRV.ESTABID , A.DESCR FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_ESTAB_TBL A , PS_ESTAB_TBL_BRA B 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)

  • Related Language Record: GPBR_ESB_VW_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description