RC_SRCH_LCTNLVW (SQL View)	Index Back
HelpDesk Locations Language related view of RC_SRCH_LCTN_VW

RC_SRCH_LCTNLVW

(SQL View)

HelpDesk Locations

Language related view of RC_SRCH_LCTN_VW

SELECT A2.SETID , A2.LOCATION , A2.LANGUAGE_CD , A2.DESCR 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_SRCH_LCTN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 RC_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Descripton of the Location to be displayed in helpdesk page.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RC_LOC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Descripton of the Location to be displayed in helpdesk page.