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.
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. Then you can 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 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 for the destination objects in your database (such as ADMIT_TERM). 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. Lastly, 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 PeopleTools documentation.
The elements that are school specific are:
|
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 |
The translates PeopleSoft maintains as TP Coverts are:
|
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 |
The translates PeopleSoft maintain as translate tables are:
|
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 |
The translates PeopleSoft maintain in tables are:
|
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 discusses how 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 discusses how to set up teaching subjects.
Page 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 first define your OUAC organizations. Use the Organization Table OUAC component to define OUAC organizations.
To set up OUAC organizations:
Add OUAC organizations.
Enter OUAC organization data.
Specify a primary contact and department for an OUAC organization.
Enter school data.
Assign GPA types to OUAC organizations.
Define school course classifications for OUAC.
Define the SECSCH comment category.
Page Used to Set Up OUAC Organizations
|
Page Name |
Object Name |
Navigation |
Usage |
|
EXT_ORG_TABLE |
Campus Community, Organization, Create/Maintain Organizations, Organization Table OUAC |
Enter or update an organization. |
|
|
EXT_ORG_TABLE_OUAC |
Campus Community, Organization, Create/Maintain Organizations, Organization Table OUAC, Ouac Organization Data |
Enter the Ministry of Education code, the OUAC institution code, and the current enrollment levels for the new organization. |
|
|
EXT_ORG_PRIM_INFO |
Campus Community, Organization, Create/Maintain Organizations, Organization Table OUAC, Prim Contact and Dept. |
Identify the department and person that your institution should contact for an organization. |
|
|
EXT_ORG_SCHL_DATA |
Campus Community, Organization, Create/Maintain Organizations, Organization Table OUAC, School Data |
Enter data that applies to the organizations that offer 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, elect an organization type and a location.
See Also
Adding Organizations to Your Database
Entering OUAC Organization DataAccess the Ouac Organization Data 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. |
Specifying a Primary Contact and Department for an OUAC OrganizationAccess the Primary Contact and Department page.
Use the Primary Contact and Department page to specify an organization's primary contact person or the department to contact, to help streamline your institution's communication with that organization.
See Also
Adding Organizations to Your Database
Entering School DataAccess 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 External Courses page when OUAC transmissions are processed. This is important because grading scheme is a required field on external courses and if it is not populated the user can not 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
PeopleSoft Campus Community Fundamentals PeopleBook, “Maintaining Organization Data,” 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 External Courses 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