DSB_BTNR_LOC_VW

(SQL View)
 Index Back

Germany Disability View

This view returns the various locations given a specific Company and BTNR (Social Insurance Number).

SELECT DISTINCT C.COMPANY , S.BTNR , L.LOCATION , L.EFFDT , L.EFF_STATUS , L.DESCR FROM PS_COMP_LOC_TBL C , PS_SI_UNIT_GER S , PS_LOCATION_TBL L WHERE C.LOCATION = L.LOCATION AND C.SETID = L.SETID AND C.SI_UNIT = S.SI_UNIT AND S.EFF_STATUS = 'A' AND L.EFF_STATUS = 'A'

  • Related Language Record: DSB_BTNR_LOC_VL

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

    Prompt Table: COMPANY_TBL

    2 BTNR Character(8) VARCHAR2(8) NOT NULL Employer Social Insurance Nbr
    3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description