WPL_SRV_VW_BRA

(SQL View)
 Index Back

Worplace Service Takers Tb BRA

Workplace service takers setup table BRA.

SELECT A.COMPANY ,A.WPLACE_LOC_BRA ,A.WPLACE_CODE_BRA ,A.ESTABID ,A.EFFDT ,A.ID_SRV_TKR_BRA ,B.DESCR FROM PS_WPL_SRV_TKR_BRA A , PS_GPBR_SERV_TAKER B WHERE A.ID_SRV_TKR_BRA = B.GPBR_SERVICE_TAKER AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GPBR_SERV_TAKER B2 WHERE B2.GPBR_SERVICE_TAKER = B.GPBR_SERVICE_TAKER AND B2.EFFDT <= A.EFFDT)

  • Related Language Record: WPL_SRV_LNG_BRA

  • Parent record: WPLACE_TBL_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 WPLACE_LOC_BRA Character(1) VARCHAR2(1) NOT NULL Worplace location.
    1=Employer Establishment
    2=Service Taker Establishment
    3=Third Party Establishment
    3 WPLACE_CODE_BRA Character(10) VARCHAR2(10) NOT NULL Workplace code.
    4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_COMP_VW

    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 ID_SRV_TKR_BRA Character(3) VARCHAR2(3) NOT NULL Service Taker ID

    Prompt Table: %EDITTABLE

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