AV_WS_INST_SRCH

(SQL View)
Index Back

Worksets

Selects all worksets owned by the user secured by Institution.

SELECT DISTINCT C.INSTITUTION , A.OPRID , A.WORKSET_CD ,A.WORKSET_ACCESS_TYP , A.WORKSET_SRCH FROM PS_AV_WORKSET A , PS_SCRTY_TBL_INST C WHERE C.ACCESS_CD = 'Y' AND A.WORKSET_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution

Default Value: AV_OPR_DEF_TBL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

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

Prompt Table: AV_OPREMPLID_VW

3 WORKSET_CD Character(10) VARCHAR2(10) NOT NULL Workset Code

Prompt Table: AV_WORKSET_SRCH

4 WORKSET_ACCESS_TYP Character(1) VARCHAR2(1) NOT NULL Workset Access
A=Staff Role
O=Public
P=Private
S=Security Role

Default Value: P

5 WORKSET_SRCH Character(30) VARCHAR2(30) NOT NULL Workset Search