EDI Mapping

 

130 UWO Business Document Layout (Outbound)

Row Descr

Data Elements

Start Pos.

Length

X12 Ref

Example

Header Line
- transaction data

 

 

 

 

 

 

 

Row ID

1

3

 

HDR

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Trans. Purpose Code 34 2 BGN01 “01” – cancelled
Send Date 36 8 BGN03 CCYYMMDD
Time 44 8 BGN04 HHMMSSdd
Time Code 52 2 BGN05 “ET” Eastern
Trans Type Code 54 2 ERP01 constant “PS” – “post secondary”
Status Reason Code 56 3 ERP02 blank or “INF”
Send. Entity Identifier 59 3 N101 AS “ – “Sending Institution”
Name(Agency) 62 60 N102 “University of Western Ont.”
Inst. Code Qualifier 122 2 N103 “CS” – Stats Canada Univ USIS Code
Institutional Code 124 6 N104 nnnnnn; “351211” – > UWO
Receiv. Entity Identifier 130 3 N101 AT “ – “Receiving Institution”
Name(Agency) 133 60 N102 “OUAC”
- student identification/
demographic data
Entity Type Qualifier 193 1 IN101
 “1”
Name Type Code 194 2 IN102 “04”
Surname 196 30 IN202 Make IN201 = ‘05’
Given Name 226 50 IN202 Make IN201 = ‘02’
OUAC Ref Nbr 276 11 REF02 CCYYNNNNNNK (REF01 code: “48”)
Student Id 1 (LR) 287 11 REF02 Student Id Nbr (REF01 code: “LR”)
Date of Births 298 8 DMG02 MMDD (DMG01 “MD” X12 date format)

NTE header segment

Special Instructions
- this row could repeat multiple times within HDR loop depending on how many special instructions will be sent

Row ID

1

3

 

“NTE”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
NTE Seq Nbr 34 15   additional key field
Special Instr. Identifier 49 16 NTE02 First 16 characters from NTE02
“LEGEND”
“BASIS”
Special Instr. Data 65 64 NTE02 Characters 17-80 from NTE02

ATV Segment
Student Awards
- this row could repeat multiple times within HDR loop

Row ID

1

3



“ATV”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
ATV Seq Nbr 34 15   additional key
Award Description 49 132 ATV03 name of award

DTP Segment

Student Award Date
- this row could repeat multiple times within ATV loop

Row ID

1

3

 

“DTP”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
ATV Seq Nbr 34 15   additional key field
DTP Seq Nbr 49 15   additional key field
Date/Time Qualifier 64 3 DTP01  “103” – “Award Date”
Award Date 67 8 DTP03 CCYY format; make DTP02 = “CY”

SES/SSE segment
- this row could repeat multiple times

 

Row ID

1

3



“SSE”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
Term Begin Date 42 8 SES01 CCYYMM
Session Seq Nbr 50 2 SES02 “1” or “2”
Term Descr 52 60 SES05 “Winter 2000..”
Status reason code 112 3 SES14 “EB3” – student has withdrawn
Date 115 8 SSE02 CCYYMMDD Optional – Used in conjunction with SES14 = ‘EB3’, otherwise do not create SSE segment

NTE SES segment 

Special Instructions
- this row could repeat multiple times within SES loop depending on how many special instructions will be sent

Row ID

1

3

 

“NTS”
CCYYMMDDnnnnn

Trans. Ref Nbr 4 30 BGN02  
Term 34 4   additional key field
Academic Career 38 4   additional key field
NTE Seq Nbr 42 15   additional key field
Special Instr. Identifier 57 16 NTE02 First 16 characters from NTE02
“DECISION”
Special Instr. Data 73 64 NTE02 Characters 17-80 from NTE02

CRS/N1 segment
Course Record
- this row could repeat multiple times within SES loop

 

 

Row ID 1 3   “CRS”
Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
CRS Seq Nbr 42 15   additional key field
Basis for acad credit CD 57 1 CRS01 “R” – regular; “T” – transfer credit
Credit Type 58 1 CRS02 “U” –units
Units Taken 59 6 CRS03 “0.50” - Blank sent in this field should translate to “nothing sent”, and CRS03 should not be populated in ANSI X12 file
Grade Qualifier 65 3 CRS05 “73” – percentage; “89” – numeric
Grade 68 3 CRS06 ‘093”
Course Repeat Code 71 1 CRS09 “N” – repeated (Not incl. in GPA)
Subject 72 60 CRS14 “ENGLISH”
Course Nbr 132 30 CRS15 “1100”
Course Title 162 60 CRS16 “HISTORY OF MEDICINE”
Transfer Credit Indicator 222 2 CRS20 “TC” – letter of permission
 “IA” – exchange
Entity Identifier 224 3 N101 “OS” – override institution
**If this field is empty do not populate N1 segment
Agency Name 227 60 N102 Free text name
Institution Code Tbl Idnt 287 2 N103 Won’t be used for now
Institution Code 289 80 N104 Won’t be used for now
Credits Earned 369 15 CRS04 Won’t be used for now
Grade or Course Level 384 2 CRS08 Won’t be used for now
Drop Date 386 8 CRS19 Won’t be used for now

NTE CRS segment 

Special Instructions
- this row could repeat multiple times within CRS loop depending on how many special instructions will be sent

 

Row ID

1


3





 

 

 

“NTC”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
CRS Seq Nbr 42 15   additional key field
NTE Seq Nbr 57 15   additional key field
Special Instr. Identifier 72 16 NTE02 First 16 characters from NTE02
“COURSE SUBTITLE”
“NOTATION”
Special Instr. Data 88 64 NTE02 Characters 17-80 from NTE02

MKS  segment  Special Instructions
- this row could repeat multiple times within CRS

** THIS ENTIRE SEGMENT NEEDS TO BE MAPPED, BUT WILL NOT BE SENT FOR NOW

Row ID

1

3

 

 

 



“MKS”







Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
CRS Seq Nbr 42 15   additional key field
MKS Seq Nbr 57 15   additional key field
Mark Code Type 72 2 MKS01 ‘4’ – Supplemental Mark
Grade Qualifier 74 3 MKS02 “73” – percentage; “89” – numeric
Grade 77 3 MKS03 ‘093”

DEG  segment
Degree Record
- this row could repeat multiple times within SES loop

 

Row ID

1

3



“DEG”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
DEG Seq Nbr 42 15   additional key field
Degree Code 57 3 DEG01  “2.0” – undergraduate non-degree
Degree DateDegree 60 8 DEG03 CCYYMM date or blank if degree not awarded yet; Make DEG02 = “CM
Descr 68 80 DEG04 Degree description.
Degree Honors Code 148 3 DEG05 “B35” – Highest Honors
“B36” – Second Highest Honors
“B37” – Third Highest Honors

FOS segment
Field of Study
- this row could repeat multiple times within DEG loop

 

Row ID

1

3




“FOS”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
DEG Seq Nbr 42 15   additional key field
FOS Seq Nbr 57 15   additional key field
Field of Study Type/Lvl 72 1 FOS01 “M” – minor
Field of Study Code Set 73 2 FOS02 “CC” – StatsCan USIS Curriculum
Field of Study Code 75 80 FOS03 USIS code value
Field of Study(free-form) 155 80 FOS04 Free form desription
Field of Study Honors (free-form) 235 80 FOS05 Probably sub plan description

NTE DEG segment 

Special Instructions
- this row could repeat multiple times within DEG loop depending on how many special instructions will be sent

Row ID

1

3

 

“NTD”

Trans. Ref Nbr 4 30 BGN02 CCYYMMDDnnnnn
Term 34 4   additional key field
Academic Career 38 4   additional key field
DEG Seq Nbr 42 15   additional key field
NTE Seq Nbr 57 15   additional key field
Special Instr. Identifier 72 16 NTE02 First 16 characters from NTE02
“INSTITUTION”
“LEVEL”
Special Instr. Data 88 64 NTE02 Characters 17-80 from NTE02

Search Western

Also of interest:

Western provides the best student experience among Canada's leading research-intensive universities.