GP_LINK_LO_LVW

(SQL View)
Index Back

Related Language View

Related Language View for Location Description

SELECT DISTINCT B.SETID , A.LOCATION , A.LANGUAGE_CD , A.DESCR FROM PS_LOCATION_LANG A , PS_SET_CNTRL_REC B WHERE B.RECNAME = 'LOCATION_TBL' AND B.SETCNTRLVALUE IN ( SELECT C.DEFAULT_SETID FROM PS_BUS_UNIT_TBL_HR C) AND A.SETID = B.SETID

  • Related Language Record for GP_LINK_LO_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ORG_LINK_UNIT Character(12) VARCHAR2(12) NOT NULL Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description