CAN_SCHL_SRCHLN(SQL View) |
Index Back |
|---|---|
CAN_SCHL_SRCH Related lang.Related language record for search view for the Canadian External School Table (panelgroup CAN_EXT_SCHOOL) |
| SELECT A.EXT_ORG_ID , B.CAN_GOV_TYPE , A.LANGUAGE_CD , A.EFFDT , A.DESCR FROM PS_EXT_ORG_LANG A , PS_CAN_EXT_SCHOOL B WHERE B.EXT_ORG_ID = A.EXT_ORG_ID |
| # | 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 | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |