DSB_GER_COMP_VW

(SQL View)
 Index Back

German Disability View

This view shows companies who are also defined in the COMP_LOC_TBL, SI_UNIT_GER, and have locations in Germany.

SELECT DISTINCT D.COMPANY , D.EFFDT , D.DESCR FROM PS_COMP_LOC_TBL A , PS_SI_UNIT_GER B , PS_LOCATION_TBL C , PS_COMPANY_TBL D WHERE A.SETID = C.SETID AND A.LOCATION = C.LOCATION AND C.COUNTRY = 'DEU' AND A.COMPANY = D.COMPANY AND A.SI_UNIT = B.SI_UNIT

  • Related Language Record: DSB_GER_COMP_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description