RF_ASST_LOC_LVW (SQL View)	Index Back
Department View This view is used exclusively in outer joins by other FieldService views. It is not in use on any page.

RF_ASST_LOC_LVW

(SQL View)

Department View

This view is used exclusively in outer joins by other FieldService views. It is not in use on any page.

SELECT B.SETCNTRLVALUE , A.LOCATION , A.LANGUAGE_CD , A.DESCR FROM PS_LOCATION_LANG A , PS_SET_CNTRL_REC B WHERE A.SETID = B.SETID AND B.RECNAME = 'LOCATION_TBL' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_LOCATION_TBL C WHERE C.SETID = A.SETID AND C.LOCATION = A.LOCATION AND C.EFFDT <= %CurrentDateIn)

Related Language Record for RF_ASSET_LOC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description