Setting Up EDI Manager for OUAC Transactions
Electronic 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
Product documentation for PeopleTools: Supported Integration Technologies