RC_LOCATIONLVW

(SQL View)
 Index Back

HelpDesk Locations


SELECT A2.SETID , A2.DESCR , A2.LANGUAGE_CD FROM PS_LOCATION_TBL A , PS_LOCATION_LANG A2 WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_LOCATION_TBL A1 WHERE A.SETID = A1.SETID AND A.LOCATION = A1.LOCATION AND A1.EFFDT <= %CurrentDateIn AND A1.EFF_STATUS = 'A') AND A.SETID = A2.SETID AND A.LOCATION = A2.LOCATION AND A.EFFDT = A2.EFFDT

  • Related Language Record for RC_LOCATION_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    2 RC_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Descripton of the Location to be displayed in helpdesk page.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code