Setting Up EDI Manager for OUAC TransactionsThis chapter discusses how to:
Set up EDI Manager for Ontario Universities Application Center (OUAC) transactions.
Set up OUAC law categories.
Set up teaching subjects and CEGEP programs.
Set up OUAC organizations.
Setting Up EDI Manager for OUAC TransactionsElectronic Data Interchange (EDI) is a means of transmitting data electronically from one entity to another. Through the EDI Manager, you can receive data files from external sources and load important recruiting and admissions data into staging tables, where you can review and edit the data. You can then post the data to tables in your database.
Before you begin processing external OUAC transactions, you must set up conversion parameters in the EDI Manager. This setup enables the EDI Manager to recognize OUAC elements (such as OUAC element number 400 - expected enrollment date) and to map data from OUAC elements to PeopleSoft objects (such as the field ADMIT_TERM in the table ADM_APPL_PROG).
To map OUAC elements to PeopleSoft objects, you must first define a conversion type definition, such as ADMIT_TERM, for the destination objects in your database. Use the Conversion Type Definition page to define conversion type definitions. Then, you must define conversion data profiles that relate internal values to external values. Use the Conversion Data Profile page to define conversion data profiles. Last, define an inbound map definition that links the OUAC element to the PeopleSoft object. Use the Business Document Layout page to map OUAC elements to PeopleSoft objects. EDI Manager pages are discussed in more detail in your PeopleSoft PeopleTools documentation.
This table lists the OUAC elements that are school specific:
|
OUAC ELEMENT |
EC Map ID |
Business Doc Record |
Name |
|
010 - Institution |
OUAC_LAW_A OUAC_LAW_U OUAC_PT OUAC_TEA_A OUAC_TEA_U OUAC_UAS_A OUAC_UAS_U |
OUAC_CTL_WD OUAC_CTL_WD OUAC_CTL_WD OUAC_CTL_WD OUAC_CTL_WD OUAC_CTL_WD OUAC_CTL_WD |
INSTITUTION INSTITUTION INSTITUTION INSTITUTION INSTITUTION INSTITUTION INSTITUTION |
|
395 - University/Program Desired |
OUAC_UAS_A OUAC_UAS_U OUAC_UAS_U OUAC_PT |
OUAC_A5_U5_WD OUAC_A5_U5_WD OUAC_D1_WD OUAC_A5_U5_WD |
ACAD_PROG ACAD_PROG ACAD_PROG ACAD_PROG |
|
400 - Expected Enrollment Date |
OUAC_UAS_A OUAC_UAS_U OUAC_UAS_U OUAC_PT |
OUAC_A5_U5_WD OUAC_A5_U5_WD OUAC_D1_WD OUAC_A5_U5_WD |
ADMIT_TERM ADMIT_TERM ADMIT_TERM ADMIT_TERM |
|
410 - Full or Part-time |
OUAC_UAS_A OUAC_UAS_U OUAC_PT |
OUAC_A5_U5_WD OUAC_A5_U5_WD OUAC_A5_U5_WD |
ACAD_LOAD_APPR ACAD_LOAD_APPR ACAD_LOAD_APPR |
|
411 - Year Desired |
OUAC_UAS_A OUAC_UAS_U OUAC_PT |
OUAC_A5_U5_WD OUAC_A5_U5_WD OUAC_A5_U5_WD |
ACADEMIC_LEVEL ACADEMIC_LEVEL ACADEMIC_LEVEL |
|
440 - Residence Information Requested |
OUAC_UAS_A OUAC_UAS_U OUAC_PT |
OUAC_A5_U5_WD OUAC_A5_U5_WD OUAC_A5_U5_WD |
HOUSING_INTEREST HOUSING_INTEREST HOUSING_INTEREST |
|
600 - Final or Interim |
OUAC_UAS_A OUAC_UAS_U |
OUAC_M2_WD OUAC_M2_WD |
TRNSCRPT_STATUS TRNSCRPT_STATUS |
|
755 - Last Session of Study at CEGEP |
OUAC_UAS_A OUAC_UAS_U |
OUAC_C1_WD OUAC_C1_WD |
EXT_TERM EXT_TERM |
|
765 - Session CEGEP Course Taken |
OUAC_UAS_A OUAC_UAS_U |
OUAC_C2_WD OUAC_C2_WD |
EXT_TERM EXT_TERM |
|
531 - Year Level |
OUAC_PT OUAC_TEA_A OUAC_TEA_U OUAC_UAS_A OUAC_UAS_U |
OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD |
EXT_ACAD_LEVEL EXT_ACAD_LEVEL EXT_ACAD_LEVEL EXT_ACAD_LEVEL EXT_ACAD_LEVEL |
|
533 - Diploma Received |
OUAC_LAW_A OUAC_LAW_U OUAC_PT OUAC_TEA_A OUAC_TEA_U OUAC_UAS_A OUAC_UAS_U |
OUAC_G2_H2_WD OUAC_G2_H2_WD OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD OUAC_PI_WD |
OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE |
|
665 - University/Program Desired |
OUAC_UAS_A OUAC_UAS_U |
OUAC_AR_WD OUAC_AR_WD |
ACAD_PROG ACAD_PROG |
|
670 - Enrollment 1 Offered |
OUAC_UAS_A OUAC_UAS_U |
OUAC_AR_WD OUAC_AR_WD |
ADMIT_TERM ADMIT_TERM |
|
840 - University/Program Code |
OUAC_TEA_A OUAC_TEA_U OUAC_TEA_U |
OUAC_A8_U8_WD OUAC_A8_U8_WD OUAC_D1_WD |
ACAD_PROG ACAD_PROG ACAD_PROG |
|
860 - Residence Information Requested |
OUAC_TEA_A OUAC_TEA_U |
OUAC_A8_U8_WD OUAC_A8_U8_WD |
HOUSING_INTEREST HOUSING_INTEREST |
|
685 - Year Level Offered |
OUAC_UAS_A OUAC_UAS_U |
OUAC_AR_WD OUAC_AR_WD |
ACADEMIC_LEVEL ACADEMIC_LEVEL |
|
1400 - Course Level |
OUAC_UAS_A OUAC_UAS_U OUAC_UAS_A OUAC_UAS_U |
OUAC_F2_WD OUAC_F2_WD OUAC_F3_WD OUAC_F3_WD |
COURSE_LEVEL COURSE_LEVEL COURSE_LEVEL COURSE_LEVEL |
|
825 - Degree Code |
OUAC_TEA_A OUAC_TEA_U |
OUAC_A8_U8_WD OUAC_A8_U8_WD |
OUAC_DIPLOMA_CODE OUAC_DIPLOMA_CODE |
This table lists the translates that the PeopleSoft system maintains as transaction processing (TP) converts:
|
OUAC ELEMENT |
Transactions |
TP Convert Name |
|
170 - Country of Current Citizenship |
A4 |
OUAC_CNTRY |
|
180 - Citizenship, Appendix 9.A.30 |
A4 |
OUAC_CNTRY |
|
190 - Country of Residence, Appendix 9.A.30 |
A4 |
OUAC_CNTRY |
|
200 - Province of Residence |
A4 |
OUAC_PROV |
|
220 - Immigration Status |
A4 |
CitznStat |
|
230 - Gender |
A4 |
Sex |
|
250 - Marital Status |
A4 |
MAR_STATUS |
|
270 - First Language |
A4 |
Accmpl-Lng |
|
542 - Country where attended English School |
A5 |
OUAC_CNTRY |
|
573 - Response to OSAP Question |
A5 |
OUAC_Y/N |
|
2174 - LSAT Misconduct Flag |
J1 |
OUAC_Y/N |
|
1080 - Country of Birth |
A5 |
OUAC_CNTRY |
|
280 - Language of Correspondence |
A4 |
Accmpl-Lng |
|
450 - Language of Instruction |
A5 |
Language |
|
581 - Language of Instruction |
M2 |
Language |
|
865 - Language of Instruction |
A8 |
Language |
|
430 - Previous Yr Applied to this Inst |
A5 |
Prior_Appl |
|
114 - Mailing Address Country |
B7 |
OUAC_FCTRY |
|
154 - Home Address Country |
B8 |
OUAC_FCTRY |
|
560 - Achievement of OSSD |
M1 |
Degr_Stat |
|
2168 - Plan to Write LSAT Future |
J1 |
OUAC_Y/N |
|
2106 - Emergency Contact Country |
B9 |
OUAC_FCTRY |
This table lists the translates that the PeopleSoft system maintains as translate tables:
|
OUAC ELEMENT |
Transactions |
Field Name |
|
2201 - LSAT Details irreg code |
J2, J3, J4 |
OUAC_LSAT_IRREG1 OUAC_LSAT_IRREG2 OUAC_LSAT_IRREG3 OUAC_LSAT_IRREG4 |
|
477 - Attended Postsecondary |
A5 |
OUAC_ATTND_PSTSCND |
|
475 - Authorization to Release Academic |
A5 |
OUAC_AUTH_RELEASE |
|
397 - Cooperative Education |
A5, D1 |
COOP_REQ |
|
507 - Authorization to Release Univ Performance to Sec School |
A9 |
OUAC_AUTH_RELEASE |
|
930 - Previously Dealt w/ University |
B1 |
OUAC_PRV_WITH_UNIV |
|
2020 - Ever Attended Law School |
B1 |
OUAC_ATTEND_LAW |
|
2145 - Fee Waiver Received |
G8 |
OUAC_WAIVER_RCVD (check box) |
|
2151 - All OLSAS Applications |
G8 |
OLSAS_OSGOODE_STAT OLSAS_OTTAWA_STAT OLSAS_QUEENS_STAT OLSAS_TORONTO_STAT OLSAS_WESTERN_STAT OLSAS_WINDSOR_STAT |
|
2095 - Authorization |
G3 |
OUAC_EMR_CNTCT_AUT |
|
295 - Mature Student Regulation |
A4 |
OUAC_MATURE_STDNT |
|
935 - Second Degree |
B1 |
OUAC_SECOND_DEGREE |
|
2173 - Ethnic Code |
J1 |
ETHNICITY_LSAC |
|
2286 - Type |
R2 |
OUAC_DEGREE_TYPE |
This table lists the translates that the PeopleSoft system maintains in tables:
|
OUAC ELEMENT |
Table Name |
|
532 - Program of Study, Appendix 9.A.65 |
EXT_SUBJECT_TBL |
|
332 - Subject of Major Interest, Appendix 9.A.80 |
EXT_SUBJECT_TBL |
|
845 - Teaching Subject 1, Appendix 9.A.85 850 - Teaching Subject 2, Appendix 9.A.85 |
OUAC_T_SUBJECT_TBL |
|
750 - Program Code Last Studied, Appendix 9.A.25 |
CEGEP_PROG_TBL |
|
525 - Advanced Standing Program, Appendix 9.A.95 |
OUAC_PROG_TBL |
|
2111 - Category, Appendix 9.A.50 |
OUAC_LAW_CAT_TB |
See Also
PeopleSoft Supported Integrated Technologies
Setting Up OUAC Law CategoriesThis section lists the page used to set up OAUC law categories.
Page Used to Set Up OUAC Law Categories
|
Page Name |
Object Name |
Navigation |
Usage |
|
OUAC_LAW_CAT_TBL |
Set Up SACR, Product Related, Recruiting and Admissions, OUAC, Law Categories |
Define OUAC law categories. Law categories are used on the OUAC Appl Law Cat (OUAC application law category) page. |
Setting Up Teaching Subjects and CEGEP ProgramsTo set up teaching subjects, use the OUAC Teaching Subject (OUAC_T_SUBJECTS) and CEGEP Programs (CEGEP_PROGRAMS) components.
This section lists the pages used to set up teaching subjects.
Pages Used to Set Up Teaching Subjects
|
Page Name |
Object Name |
Navigation |
Usage |
|
OUAC_T_SUBJECT_TBL |
Set Up SACR, Product Related, Recruiting and Admissions, OUAC, Teaching Subjects |
Define OUAC teaching subjects. Teaching subjects are used on the OUAC A8/U8 page. |
|
|
CEGEP_PROG_TBL |
Set Up SACR, Product Related, Recruiting and Admissions, OUAC, CEGEP Program Table |
Define programs for CEGEP. |
Setting Up OUAC OrganizationsBefore you can receive data from OUAC, you must define your OUAC organizations. Use the Organization Table component to define OUAC organizations.
This section discusses how to:
Add OUAC organizations.
Specify a primary contact and department for an OUAC organization.
Enter OUAC organization data.
Enter school data.
Assign grade point average (GPA) types to OUAC organizations.
Define school course classifications for OUAC.
Define the SECSCH (secondary school) comment category.
Pages Used to Set Up OUAC Organizations
|
Page Name |
Object Name |
Navigation |
Usage |
|
EXT_ORG_TABLE |
Campus Community, Organization, Create/Maintain Organizations, Organization Table, Organization Table |
Enter or update data about an organization. View and update information about the primary contact and department for the organization. |
|
|
EXT_ORG_TBL_REG |
Campus Community, Organization, Create/Maintain Organizations, Organization Table, Regional |
In the OUAC Organization Data group box, enter the Ministry of Education code, the OUAC institution code, and the current enrollment levels for the new organization. |
|
|
SCC_EXT_ORG_ADM |
Campus Community, Organization, Create/Maintain Organizations, Organization School Data |
Enter data that applies to an organization that offers courses. |
|
|
EXT_ORG_AFFLTN |
Campus Community, Organization, Create/Maintain Organizations, Organization Affiliation |
Identify details that are important to your institution in affiliation with an organization. |
|
|
SCHOOL_COURSES |
Campus Community, Organization, Create/Maintain Organizations, School Course Classification |
Record the specific course offerings for each subject area. |
|
|
CMNT_CATG_TABLE |
|
Set up comment categories that enable you to group comments for similar purposes. |
Adding OUAC OrganizationsAccess the Organization Table page.
Use the Organization Table page to add OUAC organizations. You can enter definitions for the organization, select an organization type, and select a location.
See Also
Adding Organizations to Your Database
Specifying a Primary Contact and Department for an OUAC OrganizationAccess the Organization Table page.
Use the Organization Table page to specify an organization's primary contact person or the department to contact in order to streamline your institution's communications with that organization.
See Also
Adding Organizations to Your Database
Entering OUAC Organization DataAccess the Regional page.
|
Mident Code |
Enter the Ontario Ministry of Education six-digit school code. |
|
OUAC Institution Code |
Enter the code that identifies OUAC institutions. When you post OUAC data, the process looks for this code to populate the EXT_ORG_ID field. |
|
Grade 9 (through 12) Enrollment |
Enter the current enrollment levels for the respective grades. |
|
OAC Enrollment |
Enter the total OUAC enrollment. |
Entering School Data
Access the School Data page.
Use the School Data page to enter school characteristics, school codes, and system default values.
See Also
Assigning GPA Types to OUAC OrganizationsAccess the Organization Affiliation page.
GPA type must have a value entered to populate a grading scheme on the Courses and Degrees page when OUAC transmissions are processed. This setup is important because grading scheme is a required field and—if it is not populated—the user cannot make any changes to that page without getting an error message. Use the Organization Affiliation page to define a GPA type for an organization.
See Also
Entering Affiliations with Organizations
Defining School Course Classifications for OUACAccess the School Course Classification page.
Use the School Course Classification page to define school course classifications for OUAC organizations. The values you enter on this page populate fields on the Courses and Degrees page when you post OUAC transmissions.
See Also
Setting Up External Subject Categories and Term Sessions
Defining the SECSCH Comment CategorySecondary school comments on the A9 transaction appear on the Comments pages. To view them, you must first set up the comment category SECSCH. You must also tie it to at least one 3C group. Use the Comment Category Table page to define the SECSCH comment category. Use the Comment 3C Groups page to tie the SECSCH comment category to a 3C group.
See Also