EXT_ORG_SRCH2

(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 , B.SCHOOL_CODE , B.LS_SCHOOL_TYPE , B.ATP_CD , B.FICE_CD , A.CITY , A.STATE , A.POSTAL , A.COUNTRY FROM PS_EXT_ORG_PRI_VW A LEFT OUTER JOIN PS_EXT_ORG_TBL_ADM B ON A.EXT_ORG_ID = B.EXT_ORG_ID AND A.EFFDT = B.EFFDT 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'

# 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 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
7 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type
8 ATP_CD Character(6) VARCHAR2(6) NOT NULL ATP Code
9 FICE_CD Character(6) VARCHAR2(6) NOT NULL FICE Code
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_TBL

12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL