AV_WSET_O_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 , B.EXT_ORG_ID , C.DESCR ,A.WORKSET_ACCESS_TYP FROM PS_AV_WORKSET A , PS_AV_WORKSET_MBR B , PS_EXT_ORG_TBL C WHERE A.WORKSET_CD = B.WORKSET_CD AND A.OPRID = B.OPRID AND B.AV_PNL_TYPE = 'O' AND B.EXT_ORG_ID=C.EXT_ORG_ID AND A.WORKSET_STATUS = 'A'

  • Related Language Record: AVWSETOSRCHLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: AV_OPREMPLID_VW

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

    Prompt Table: AV_WSET_O_DYNVW

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

    Default Value: P