SPB_PROV_ID_LVW

(SQL View)
Index Back

Service Provider ID lang view

Language view for SPB_PROV_ID_VW record

SELECT P.PERSON_ID , C.LANGUAGE_CD , I.DESCR100 , C.DESCR FROM PS_SPB_SRV_PROV_ID P , PS_SPB_PROV_ID I , PS_COUNTRYTBL_LANG C WHERE P.SP_PROV_ID = I.SP_PROV_ID AND ((P.COUNTRY = I.COUNTRY AND C.COUNTRY = P.COUNTRY) OR (I.COUNTRY = ' ' AND C.COUNTRY = P.COUNTRY))

  • Related Language Record for SPB_PROV_ID_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description