AVWSETOSRCHLNG

(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.LANGUAGE_CD , C.DESCR FROM PS_AV_WORKSET A , PS_AV_WORKSET_MBR B , PS_EXT_ORG_LANG 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

  • Related Language Record for AV_WSET_O_DYNSR AV_WSET_O_SRCH
  • # 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_DYNVW

    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description