AV_INST_WE_SRCH

(SQL View)
 Index Back

Person/Institution workset sea

selects all orgs for an institution that belong to a workset. Secured by institution.

SELECT A.OPRID , A.WORKSET_CD , D.INSTITUTION , B.EXT_ORG_ID , A.WORKSET_ACCESS_TYP FROM PS_AV_WORKSET A , PS_AV_WORKSET_MBR B , PS_SCRTY_TBL_INST D WHERE A.WORKSET_CD = B.WORKSET_CD AND A.OPRID = B.OPRID AND A.OPRID = D.OPRID AND D.ACCESS_CD = 'Y' AND B.AV_PNL_TYPE = 'O' AND A.WORKSET_STATUS = 'A'

# 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 WORKSET_CD Character(10) VARCHAR2(10) NOT NULL Workset Code

Prompt Table: AV_WSET_O_VW

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution

Default Value: AV_OPR_DEF_TBL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
5 WORKSET_ACCESS_TYP Character(1) VARCHAR2(1) NOT NULL Workset Access
A=Staff Role
O=Public
P=Private
S=Security Role