CAN_EXT_SCHOOL(SQL Table) |
Index Back |
|---|---|
Canadian External School CodeSAC-R75-19990831 |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | CAN_GOV_SCHOOL_CD | Character(15) | VARCHAR2(15) NOT NULL |
Institution Code
Sac-r75-19990831
Prompt Table: CAN_GOV_SCHOOL |