OUAC_EX_ORG_TBL

(SQL Table)
Index Back

External Organization Table

Use EXT_ORG_TBL to maintain information about organizations. Each organization is assigned an identification number. If the organization is a school or offers courses then it should also be included in the SCHOOL_TBL. When adding an External Organization, you'll be given the opportunity to automatically have it added to the SCHOOL_TBL. SAC99C - AD01 - WTT - 03/01/1999 Added OUAC_INST_CODE, OUAC_MIDENT_CODE, OAC_ENROLLMENT, and the GRADE_% columns to the table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 OUAC_MIDENT_CODE Character(8) VARCHAR2(8) NOT NULL Prov. Ministry School Number
4 OUAC_INST_CODE Character(12) VARCHAR2(12) NOT NULL OUAC Institution Code
5 GRADE_9_ENROLL Number(5,0) INTEGER NOT NULL Grade 9 Enrollment
6 GRADE_10_ENROLL Number(5,0) INTEGER NOT NULL Grade 10 Enrollment
7 GRADE_11_ENROLL Number(5,0) INTEGER NOT NULL Grade 11 Enrollment
8 GRADE_12_ENROLL Number(5,0) INTEGER NOT NULL Grade 12 Enrollment
9 OAC_ENROLLMENT Number(5,0) INTEGER NOT NULL OAC Enrollment