DSB_CMP_BTNR_VW

(SQL View)
 Index Back

German Disability View

This view returns the various BTNRs (Social Insurance Number) given a specific Company and processing year.

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

  • Related Language Record: DSB_CMP_BTNR_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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 BTNR Character(8) VARCHAR2(8) NOT NULL Employer Social Insurance Nbr
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description