EXT_ORG_PRS_VW

(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.DESCR , A.OTH_NAME_SORT_SRCH , A.EXT_ORG_TYPE , B.SCHOOL_CODE , B.LS_SCHOOL_TYPE , B.FICE_CD , B.ATP_CD , A.CITY , A.STATE , A.COUNTRY FROM PS_EXT_ORG_PRI_VW A , PS_EXT_ORG_TBL_ADM B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_TBL A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND %EffdtCheck( EXT_ORG_TBL_ADM B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record: EXTORGPRSVWLNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    4 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Default Value: SCHL

    Prompt Table: SCC_ORG_TYP_TBL

    5 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL

    6 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

    Default Value: SCD

    Prompt Table: LS_SCHL_TYP_TBL

    7 FICE_CD Character(6) VARCHAR2(6) NOT NULL FICE Code
    8 ATP_CD Character(6) VARCHAR2(6) NOT NULL ATP Code
    9 CITY Character(30) VARCHAR2(30) NOT NULL City
    10 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_VW

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

    Prompt Table: COUNTRY_TBL