RBD_LOCATION_VW

(SQL View)
Index Back

Dashboard Location

This is the record for the Dashboard Location view.

SELECT A.SETID , A.LOCATION , A.DESCR FROM %Table(LOCATION_TBL) A WHERE %EffdtCheck(LOCATION_TBL B, A, %CurrentDateIn)

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