EXT_ORG_SRCH

(SQL View)
 Index Back

External Org Search View

This search view is used to include the city, state, and country address fields as alternate search keys. It was created to be used on external organization summary panels.

SELECT A.EXT_ORG_ID , A.EFFDT , A.DESCR , A.OTH_NAME_SORT_SRCH , A.EXT_ORG_TYPE , A.CITY , A.STATE , A.COUNTRY FROM PS_EXT_ORG_PRI_VW A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EXT_ORG_PRI_VW A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: EXT_ORG_SRCH_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: 0

    Prompt Table: EXT_ORG_TBL

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    5 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Default Value: SCHL

    Prompt Table: SCC_ORG_TYP_TBL

    6 CITY Character(30) VARCHAR2(30) NOT NULL City
    7 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL