RC_LOCAT_VW_LNG

(SQL View)
 Index Back

HelpDesk Locations


SELECT A.SETID ,B.LANGUAGE_CD , B.DESCR FROM PS_LOCATION_TBL A , PS_LOCATION_LANG B WHERE A.SETID = B.SETID AND A.LOCATION = B.LOCATION AND 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')

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