This chapter provides an overview of external applications from OUAC and discusses how to:
Pre-load OUAC data.
Load OUAC data through the EDI Manager.
Load additional data through an SQR process.
Review and edit OUAC transaction A/U staging tables.
Review and edit OUAC transaction B5 staging tables.
Review and edit OUAC transaction B/V-E staging tables.
Review and edit OUAC transaction F staging tables.
Review and edit OUAC transaction G/H staging tables.
Review and edit OUAC transaction J-N staging tables.
Review and edit OUAC transaction P-R staging tables.
Review and edit OUAC transaction T staging tables.
View search/match and OUAC processing statuses.
Post OUAC transaction data.
View OUAC messages.
Review overflow OUAC application information.
Universities in Ontario, Canada use the Ontario Universities Application Center (OUAC) throughout their undergraduate admissions process. The OUAC collects much of the undergraduate admissions data from various sources and electronically transmits the data to institutions in Ontario.
PeopleSoft developed the OUAC interface using EDI Manager. This tool enables you to load data that you receive electronically from OUAC into your PeopleSoft application. The system posts personal data, application data, academic history, and testing information to core tables in your database.
To process OUAC transactions, you run a pre-load process that prepares the OUAC file for EDI. Then you load the data from the OUAC file into staging tables in your application. While the data is in the staging tables you can view and edit the data. When you are ready, you post the data to tables in your application.
The OUAC defines the fields on these pages. Please refer to the OUAC Systems Manual for explanations of the individual fields on each page.
This section discusses how to pre-load OUAC data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_PRELOAD_PARMS |
Student Admissions, OUAC, Process, Pre Load Data Process |
Prepare the OUAC file for EDI. The OUAC pre load process adds control records to transaction groups and sends them to the output file. |
Access the OUAC Pre Load Parms (OUAC pre load parameters) page.
Input File |
Enter the full path and name of the OUAC file that you want to process. |
Output Des (output description) |
Enter the full path and name of the output file. |
Click the Run button to run the OUAC pre load process at user-defined intervals.
Use the Schedule Inbound EC Agent - Run Control Parameters page to load the OUAC data through EDI Manager. The Inbound EC Agent process (ECIN0001) translates the values in the flat file created by the OUAC pre-load process and loads them into staging tables. Set the run option parameter to single file and the force profile parameter to do not force.
See Also
Enterprise PeopleTools PeopleBook
This section discusses how to load additional data through an SQR process.
Page Name |
Object Name |
Navigation |
Usage |
PRCSRUNCNTL_AD_OL |
Student Admissions, OUAC, Processes, Load OUAC Data |
Translate OUAC data that EDI Manager is not equipped to handle (such as dates that are in YYMM format, name fields that need to be converted to the PeopleSoft format, and other character fields that need to be converted to mixed case). |
This section discusses how to use the OUAC Transactions A/U component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_A1_U1_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U |
Review and edit OUAC transaction data. |
|
OUAC_A2_U2_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A2/U2 |
Review and edit OUAC transaction data. |
|
OUAC_A3_U3_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A3/U3 |
Review and edit OUAC transaction data. |
|
OUAC_A4_U4_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A4/U4 |
Review and edit OUAC transaction data. |
|
OUAC_A5_U5_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A5/U5 |
Review and edit OUAC transaction data. |
|
OUAC_A6_U6_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A6/U6 |
Review and edit OUAC transaction data. |
|
OUAC_A7_U7_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A7/U7 |
Review and edit OUAC transaction data. |
|
OUAC_A8_U8_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A8/U8 |
Review and edit OUAC transaction data. |
|
OUAC_A9_U9_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC A9/U9 |
Review and edit OUAC transaction data. |
|
OUAC_AR_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC AR |
Review and edit OUAC transaction data. |
Access the OUAC A1/U1 page.
Access the OUAC A2/U2 page.
Access the OUAC A3/U3 page.
Access the OUAC A4/U4 page.
Access the OUAC A5/U5 page.
Access the OUAC A6/U6 page.
Access the OUAC A7/U7 page.
Access the OUAC A8/U8 page.
Define teaching subjects on the OUAC Teaching Subject Table page.
Access the OUAC A9/U9 page.
Access the OUAC AR page.
This section discusses how to use the OUAC B5 page to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_B5_PNL |
Student Admissions, OUAC, Transactions, Transactions A/U, OUAC B5 |
Review and edit OUAC transaction data. |
Access the OUAC B5 page.
This section discusses how to use the OUAC Transactions B/V-E component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_B1_V1_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E |
Review and edit OUAC transaction data. |
|
OUAC_B2_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC B2 |
Review and edit OUAC transaction data. |
|
OUAC_B7_V7_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC B7/V7 |
Review and edit OUAC transaction data. |
|
OUAC_B8_V8_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC B8/V8 |
Review and edit OUAC transaction data. |
|
OUAC_B9_V9_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC B9/V9 |
Review and edit OUAC transaction data. |
|
OUAC_C1_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC C1 |
Review and edit OUAC transaction data. |
|
OUAC_C2_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC C2 |
Review and edit OUAC transaction data. |
|
OUAC_D1_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC D1 |
Review and edit OUAC transaction data. |
|
OUAC_E1_PNL |
Student Admissions, OUAC, Transactions, Transactions B/V - E, OUAC E1 |
Review and edit OUAC transaction data. |
Access the OUAC B1/V1 page.
Access the OUAC B2 page.
Access the OUAC B7/V7 page.
Access the OUAC B8/V8 page.
Access the OUAC B9/V9 page.
Access the OUAC C1 page.
Access the OUAC C2 page.
Access the OUAC D1 page.
Access the OUAC E1 page.
This section discusses how to use the OUAC Transactions F component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_F1_PNL |
Student Admissions, OUAC, Transactions, Transactions F |
Review and edit OUAC transaction data. |
|
OUAC_F2_PNL |
Student Admissions, OUAC, Transactions, Transactions F, OUAC F2 |
Review and edit OUAC transaction data. |
|
OUAC_F3_PNL |
Student Admissions, OUAC, Transactions, Transactions F, OUAC F3 |
Review and edit OUAC transaction data. |
Access the OUAC F1 page.
Access the OUAC F2 page.
Access the OUAC F3 page.
This section discusses how to use the OUAC Transactions G/H component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_G1_H1_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H |
Review and edit OUAC transaction data. |
|
OUAC_G2_H2_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G2/H2 |
Review and edit OUAC transaction data. |
|
OUAC_G3_H3_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G3/H3 |
Review and edit OUAC transaction data. |
|
OUAC_G4_H4_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G4/H4 |
Review and edit OUAC transaction data. |
|
OUAC_G5_H5_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G5/H5 |
Review and edit OUAC transaction data. |
|
OUAC_G6_H6_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G6/H6 |
Review and edit OUAC transaction data. |
|
OUAC_G7_H7_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G7/H7 |
Review and edit OUAC transaction data. |
|
OUAC_G8_H8_PNL |
Student Admissions, OUAC, Transactions, Transactions G/H, OUAC G8/H8 |
Review and edit OUAC transaction data. |
Access the OUAC G1/H1 page.
Access the OUAC G2/H2 page.
Access the OUAC G3/H3 page.
Access the OUAC G4/H4 page.
Access the OUAC G5/H5 page.
Access the OUAC G6/H6 page.
Access the OUAC G7/H7 page.
Access the OUAC G8/H8 page.
This section discusses how to use the OUAC Transactions J-N component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_J_K_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J/K |
Review and edit OUAC transaction data. |
|
OUAC_J1_K1_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J1/K1 |
Review and edit OUAC transaction data. |
|
OUAC_J2_K2_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J2/K2 |
Review and edit OUAC transaction data. |
|
OUAC_J3_K3_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J3/K3 |
Review and edit OUAC transaction data. |
|
OUAC_J4_K4_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J4/K4 |
Review and edit OUAC transaction data. |
|
OUAC_J5_K5_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC J5/K5 |
Review and edit OUAC transaction data. |
|
OUAC_L1_N1_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC L1/N1 |
Review and edit OUAC transaction data. |
|
OUAC_M1_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC M1 |
Review and edit OUAC transaction data. |
|
OUAC_M2_PNL |
Student Admissions, OUAC, Transactions, Transaction J - N, OUAC M2 |
Review and edit OUAC transaction data. |
Access the OUAC J/K page.
Access the OUAC J1/K1 page.
Access the OUAC J2/K2 page.
Access the OUAC J3/K3 page.
Access the OUAC J4/K4 page.
Access the OUAC J5/K5 page.
Access the OUAC L1/N1 page.
Access the OUAC M1 page.
Access the OUAC M2 page.
This section discusses how to use the OUAC Transactions P-R component to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_PI_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R |
Review and edit OUAC transaction data. |
|
OUAC_R_S_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R, OUAC R/S |
Review and edit OUAC transaction data. |
|
OUAC_R1_S1_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R, OUAC R1/S1 |
Review and edit OUAC transaction data. |
|
OUAC_R2_S2_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R, OUAC R2/S2 |
Review and edit OUAC transaction data. |
|
OUAC_R3_S3_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R, OUAC R3/S3 |
Review and edit OUAC transaction data. |
|
OUAC_R4_S4_PNL |
Student Admissions, OUAC, Transactions, Transaction P- R, OUAC R4/S4 |
Review and edit OUAC transaction data. |
Access the OUAC PI page.
Access the OUAC R/S page.
Access the OUAC R1/S1 page.
Access the OUAC R2/S2 page.
Access the OUAC R3/S3 page.
Access the OUAC R4/S4 page.
This section discusses how to use the OUAC T1 page to review and edit OUAC transaction data.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_T1_PNL |
Student Admissions, OUAC, Transactions, Transactions T1 |
Review and edit OUAC transaction data. |
Access the OUAC T1 page.
You can use the OUAC Suspense page to view the status of an OUAC application record and to view messages that are generated by the posting process. This section discusses how to use the OUAC Suspense page.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_SUSP_PNL |
Student Admissions, OUAC, Processes, Suspense Data |
View the status of an OUAC application record, and to view messages when generated by the posting process. For example, you can determine if a record is waiting to be processed, if a record instigated a new person to be added to your database, or if any errors were encountered during the search/match or loading processes. |
Access the OUAC Suspense page.
Search/Match Processing Option |
Displays the status of the record after the Search/Match process. Complete: The process was completed without errors. Error: The process encountered errors. Perform: The process has not run yet. |
OUAC Process Status |
Select the status that you want for this record. Field values are delivered with your system as translate values. Do not modify these values in any way. Any modifications to these values require a substantial programming effort. The delivered values are EDI Loaded, Loaded, Posted, Reviewed, and Suspense. For example, if you change the status to Loaded, the next time that you run the post process, this record would post to the database—because the post process posts any file with a status of Loaded. If you do not want the record to remain in suspense status and do not want to post it to the database at a later date, select Reviewed. |
ID |
Enter an ID to merge this record with an existing ID type. If the system suspended the record after it performed the search and discovered a match for one ID, that ID displays here. If the system finds more than one match, the search order number appears and the number of matches appear in the Matches display-only field. |
This process picks up all the transactions in Loaded status and posts the data to the PS Core tables. It creates separate applications for each OUAC reference number/application number that is not a 101 applicant. For 101 applicants it creates separate program numbers.
To post OUAC transaction data:
Set search parameters for posting OUAC data.
Set OUAC post parameters.
Set defaults for posting OUAC data.
Set more post parameters.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_POST_PARMS |
Student Admissions, OUAC, Processes, Post OUAC Data, OUAC Post Parms |
Define default values for admit type, application center, academic career, and campus. |
|
OUAC_POST_PARMS2 |
Student Admissions, OUAC, Processes, Post OUAC Data, OUAC Post Parms2 |
Define application and transcript posting defaults. |
|
OUAC_POST_PARMS_BC |
Student Admissions, OUAC, Processes, Post OUAC Data, OUAC Post Parms BC |
Assign transcript status values. |
Use the Search Parms (search parameters) page to set up your search/match parameters for processing the OUAC staging tables.
See Also
Setting Up Search/Match Parameters
Access the OUAC Post Parms (OUAC post parameters) page.
Admit Type |
Select the default admit type for all OUAC transactions concerning each of the following categories of students: undergraduates (UAS), part-time (PTIM), teacher’s college (TEAS), and law (OLSAS). The admit type that you enter here is the default on the Application Data page (the ADM_APPL_DATA record). Define admit types on the Admit Types Table page. |
Application Center |
Select the default application center for all OUAC transactions concerning each of the following categories of students: undergraduates (UAS), part-time (PTIM), teacher’s college (TEAS), and law (OLSAS). The application center that you enter here is the default on the Application Data page (the ADM_APPL_DATA record). Define application centers on the Application Center Table page. |
Academic Career |
Select the default academic career for all OUAC transactions concerning each of the following categories of students: undergraduates (UAS), part-time (PTIM), teacher’s college (TEAS), and law (OLSAS). The academic career that you enter here is the default in the ADM_APP_CAR_SEQ record. Define academic careers on the Academic Career Table page. |
Campus |
Select the default campus for all OUAC transactions concerning each of the following categories of students: undergraduates (UAS), part-time (PTIM), teacher’s college (TEAS), and law (OLSAS). The campus that you enter here is the default on the Application Program page (the ADM_APPL_PROG record). If you do not select a campus here, the default is the default campus attached to the applicant’s academic program. Define campuses on the Campus Table page. |
Access the OUAC Post Parms2 (OUAC post parameters2) page.
Notification Plan |
Select the notification plan that you want entered for these applications during the posting process. A notification plan specifies whether this person should be on a regular or special notification track. Values for this field are delivered with your system as translate values. You can modify these translate values. Values are Early Admt (early admit), Regular, and Rolling. |
Application Method |
Select the application method that you want entered for these applications during the posting process. Application methods indicate how or in what form this application was received. Values for this field are delivered with your system as translate values. You can modify these translate values. Values are Appl Serv (application server), Diskette, EDI (electronic data interchange), Hard Copy, OUAC (Ontario Universities Application Center), Web Appl (web application). |
Fee Type |
Select the fee type you want entered for these applications during the posting process. Fee types enable you to charge varying user-defined application fees. Values for this field are delivered with your system as translate values. You can modify these translate values. Values are Internatnl (international) and Standard. |
Default Admit Term |
Select a default admit term for OUAC transactions that transmit term information without a term date. Term Date is a required field in PeopleSoft applications. |
Acad Load (academic load) |
Select the academic load that you want entered for these applications during the posting process. Values for this field are delivered with your system as translate values. You can modify these translate values. |
Acad Level (academic level) |
Select the academic level that you want entered for these applications during the posting process. Values for this field are delivered with your system as translate values. You can modify these translate values. |
Degree Date |
Select a default degree date for OUAC transactions that transmit degree information without a degree date. Degree Date is a required field in PeopleSoft applications. |
Grade Input |
Enter a default grade for OUAC transactions that transmit courses without a grade. Grade is a required field in PeopleSoft applications. |
Transcript Status |
Select a transcript status. The data source and data medium that you select is the default for the transcript status that you select here. Insert rows to add subsequent transcript statuses. |
Data Source |
Select a default data source for the transcript status in this row of data. |
Data Medium |
Select a default data medium for the transcript status in this row of data. |
Access the OUAC Post Parms BC (OUAC post parameters BC) page.
School % Crse Trans Stat (school % course translate status) |
Assign a transcript status to the final percentage assigned by the school. |
Prov. Exam % Trans Stat (province exam % translate status) |
Assign a transcript status to the exam percentage assigned by the province. |
Prov. Blended % Trans Stat (province blended % translate status) |
Assign a transcript status to the blended percentage. |
Prov Interim % Trans Stat (province interim % translate status) |
Assign a transcript status to the interim percentage assigned by the school. |
BC Honours Category |
Enter a default for applicants who have earned honors standing. Values for this field are delivered with your system as translate values. You can modify these translate values. The delivered values are Laude, Magna, None, and Summa. |
Note. If you assign the same transcript status to the percentage fields above, the incoming marks data does not create a new row, but, instead, overwrites the old one. Assigning a different transcript status to these fields ensures that marks are populated correctly.
This section discusses how to view OUAC messages.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_PRCS_MSG_TBL |
Develop Enrollment, Process External Data, Inquire, OUAC Messages, OUAC Process Message Table |
View errors generated during the posting process. |
Access the OUAC Process Message Table page.
Select the following criteria for which you want to search for OUAC process messages: Instance, Institution, ID, Appl Nbr (application number), OUAC Ref# (OUAC reference number) OUAC Appl Nbr (OUAC application number), and OUAC Identifier.
Use the OUAC Application Data component to view overflow OUAC data. The data that appears in this component has no natural home in PeopleSoft core tables — it therefore appears here. Thus, for students posted through OUAC, the OUAC Application Data component is an extension of their application.
This section discusses how to:
Review general OAUC application data.
Review OUAC law application information.
Review OUAC law categories.
Page Name |
Object Name |
Navigation |
Usage |
OUAC_APPL_DATA |
Student Admissions, OUAC, OUAC Application |
View overflow OUAC application data. |
|
OUAC_APPL_DATA_LAW |
Student Admissions, OUAC, OUAC Application, OUAC Law Application Data |
Review overflow OUAC law application data. |
|
OUAC_APPL_LAW_CAT |
Student Admissions, OUAC, OUAC Application, OUAC Appl Law Cat |
View OUAC law categories. |
Access the OUAC Application Data page.
Access the OUAC Law Application Data page.
Access the OUAC Appl Law Cat page.