AV_WSET_ORG_VW1

(SQL View)
Index Back

Workset Org Search


SELECT A.OPRID , A.WORKSET_CD , B.EXT_ORG_ID , B.DESCR , B.CITY , B.STATE , B.COUNTRY , B.OTH_NAME_SORT_SRCH FROM PS_AV_WORKSET_MBR A ,PS_EXT_ORG_PRI_VW B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID

  • Related Language Record: AVWSETORGVW1LNG
  • # 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
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CITY Character(30) VARCHAR2(30) NOT NULL City
    6 STATE Character(6) VARCHAR2(6) NOT NULL State
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    8 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name