CAN_SCHL_SRCH(SQL View) |
Index Back |
|---|---|
Canadian Ext Schl Search ViewThis view is used as a search view for the Canadian External School Table (panelgroup CAN_EXT_SCHOOL) |
| SELECT A.EXT_ORG_ID , A.CAN_GOV_TYPE , A.EFFDT , C.DESCR , C.OTH_NAME_SORT_SRCH , C.EXT_ORG_TYPE , B.SCHOOL_CODE , B.LS_SCHOOL_TYPE , B.FICE_CD , B.ATP_CD , C.CITY , C.STATE , C.COUNTRY FROM PS_CAN_EXT_SCHOOL A , PS_EXT_ORG_TBL_ADM B , PS_EXT_ORG_PRI_VW C WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND B.EXT_ORG_ID = C.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_TBL_ADM B1, B, %CurrentDateIn) AND %EffdtCheck(EXT_ORG_TBL C1, C, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | CAN_GOV_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Sac-r75-19990831
CISP=CIS Post Secondary Schools CISS=CIS Secondary Schools ESIP=ESIS Post Secondary Schools ESIS=ESIS Secondary Schools PSIP=PSIS Post Secondary Schools PSIS=PSIS Secondary Schools |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | OTH_NAME_SORT_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Search Name |
| 6 | EXT_ORG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Organization Type
Default Value: SCHL Prompt Table: SCC_ORG_TYP_TBL |
| 7 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL |
School Code
Prompt Table: SCHOOL_TBL |
| 8 | LS_SCHOOL_TYPE | Character(3) | VARCHAR2(3) NOT NULL | School Type |
| 9 | FICE_CD | Character(6) | VARCHAR2(6) NOT NULL | FICE Code |
| 10 | ATP_CD | Character(6) | VARCHAR2(6) NOT NULL | ATP Code |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |