SP_LOCSET_OPRVW (SQL View)	Index Back
Location Table Set ID This view is used to validate the Location Set ID as limited by operator security This view list only the Set ID's used by the Location table.

SP_LOCSET_OPRVW

(SQL View)

Location Table Set ID

This view is used to validate the Location Set ID as limited by operator security This view list only the Set ID's used by the Location table.

SELECT B.OPRID , A.SETID , A.DESCR , A.DESCRSHORT , A.DESCRLONG FROM PS_SP_LOCSET_NONVW A , PS_SEC_SETID_OPR B WHERE A.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	DESCRLONG	Long Character	CLOB	Long Description