Course data elements Data element description for the ONE Course catalog	Overview Data format

Overview

We have designed the data feed process to facilitate automated, easily reproducable extraction, transfer and importing of the data from the participating institutions into the catalog. Toward this end we're asking for a fixed-length-field ASCII text file from each institution. The feed will contain one line for each course that the institution wishes to offer in the catalog. Each feed will supercede all previous data from that institution. In addition to the Course offerings file feed there is "one-time" information needed from each participating institution, things like the URL for the institution home page, administrative contact information and so forth. Since this information will seldom be changed it shouldn't be necessary to automate transfer of it; before an institution can submit its first courses it'll have to email us the information and we'll populate the catalogue with it by hand. Thereafter it should only need to be resubmitted if it changes. A description of this type of information is available here.

Course Offerings Feed File

This is a table of the data elements that are in the course offerings feed. Note that many of the entries under the "Element Name" column are links to the Glossary of Terms. If an item has a revision history there will be a link to that under the "Notes" column. Reference number is merely for convenience and may not be in actual numeric order. Course Offerings Feed File Format Ref. # Element Name Field Length Field Position Valid Characters/ Field Format Searchable Required? Notes 4 Course Number 10 1-10 Text, left-justified space-filled   Y E.g., ENG 455. Revised 2/1/99 3 Course Title 60 11-70 Text, left-justified space-filled   Y Complete, unabbreviated name of course. Revised 2/27/99,4/30/99 5 Credit Hours 5 71-75 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary    Y  Revised 2/19/99, 4/30/99, 5/19/99 6 Type of Credit 1 76 Q, S, N, C    Y Quarter, Semester, Noncredit, CEU 7 Course Description 1500 77-1576 Text, left-justified space-filled    Y As in printed catalog. Revised 2/19/99, 6/11/99 9 Prerequisite Courses 100 1577-1676 Text, left-justified, space-filled    N List prerequisite course titles and numbers. Revised 4/30/99 2 Subject Areas 30 1677-1706 Text. See Subject Area Table, left-justified space-filled Y At least one, 6-digit subject code One or more (up to 5). Multiple subject areas need to be wedged directly together with no puncuation between. Revised 2/19/99, 4/30/99, 8/6/99 11 Level of Study 1 1707 Text. See Study Level Table Y Y   18 Enrollment Restrictions 400 1708-2107 Text, left-justified space-filled   N e.g., Must be RN. Revised 4/30/99 22 Degree/ Licensing/ Continuing Ed./ Certificate Program 200 2108-2307 Text, left-justified space-filled   N List distance learning programs that course is part of, e.g., AAOT, OSU Liberal Studies Program, etc. Revised 4/30/99 25 Attendance Requirements 100 2308-2407 Text, left-justified space-filled   N e.g., Proctored exams, orientation, on-campus lab Revised 4/30/99 26 Delivery Methods 20 2408-2427 See Delivery Method Table, left-justified space-filled Y At least one, 2-digit, method code Choose primary method add additional methods as needed, up to 10. Multiple codes need to be wedged together with no separating punctuation or whitespace. Revised 2/19/99, 8/6/99 28 Technology Requirements 40 2428-2467 See Technology Req. Table, left-justified, space-filled   N Enter all that apply. Multiple codes need to be wedged together with no separating punctuation or whitespace. Revised 8/6/99 36 CRN 8 2468-2475 Text, space-filled   N Added 4/30/99, Revised 5/19/99 10 Instructor Name 60 2476-2535 Text, left-justifed space-filled   N  Revised 4/30/99 12 Time of Day 20 2536-2555 Text, left-justified space-filled   N Fill in start time and end time Revised 4/30/99 13 Day(s) of Week Available 7 2556-2562 Text (M,T,W,R,F,S,U,A) Y N May contain up to 7 day designations or A for Asynchronous 14 Term/Semester Offered 4 2563-2566 See Term Table Y Y   23 Course Location 100 2567-2666 Text. "Anyplace", "Statewide" or "Limited" + list specific sites. Left-justifed space-filled.   N Description of Locations course is offered Revised 2/19/99, 4/30/99 35 Additional Course and Registration Information 100 2667-2766 Text, left-justified space-filled    N Revised 2/19/99, 2/27/99, 4/30/99 29 Tuition 1 7 2767-2773 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   Y Enter tuition dollar amount (i.e. 350, 350.00) Revised 4/30/99, 6/11/99 37 Tuition 1 Description 50  2774-2823 Text, left-justified space-filled   Y Enter Tuition 1 Description (i.e. "In-state Tuition") 38 Tuition/Fee 2 7  2824-2830 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   N Enter tuition or fee dollar amount 39 Tuition/Fee 2 Description 50 2831-2880 Text, left-justified space-filled   N Enter description of Tuition/Fee 2 40 Tuition/Fee 3 7  2881-2887 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   N Enter tuition or fee dollar amount 41 Tuition/Fee 3 Description 50 2888-2937  Text, left-justified space-filled   N Enter description of Tuition/Fee 3 42 Tuition/Fee 4 7  2938-2944 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   N Enter tuition or fee dollar amount 43 Tuition/Fee 4 Description 50  2945-2994 Text, left-justified space-filled   N Enter description of Tuition/Fee 4 44 Tuition/Fee 5 7  2995-3001 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   N Enter tuition or fee dollar amount 45 Tuition/Fee 5 Description 50  3002-3051 Text, left-justified space-filled   N Enter description of Tuition/Fee 5 46 Tuition/Fee 6 7 3052-3058 Numeric right-justified space-filled OR zero-filled, explicit decimal point necessary   N Enter tuition or fee dollar amount 47 Tuition/Fee 6 Description 50 3059-3108 Text, left-justified space-filled   N Enter description of Tuition/Fee 6 Subject Area Table   Subject Area CIP ranges Agriculture, Forestry 010000-019999, 020000-029999, 030500-030599 Architecture, Urban planning 040000-040999 Arts (music, art, dance, theater, etc.) 500000-509999 Basic Skills 320000-329999 Business 060000-069999, 520000-529999 Computer, Information Sciences 110000-119999 Communications, Journalism 090000-099999, 100000-109999 Criminal Justice/Law Enforcement 430000-439999 Education 130000-139999 Engineering/ Engineering Technologies 140000-149999, 150000-159999 English Language/ Literature/ Writing 230000-239999 Foreign Languages 160000-169999 Health Professions, Nursing/Pharmacy/Medicine 510000-519999 Home Economics, Foods/Nutrition 190000-199999 Law 220000-229999 Library Science 250000-259999 Liberal Arts and Humanities, General Studies 240000-249999, 050000-059999, 300000-309999, 380000-389999, 390000-399999 Mathematics/ Statistics 270000-279999 Physical Education, Recreation and Fitness 310000-319999, 080900-080999, 081100-081199 Social Services/ Social Work 440000-449999 Social Sciences (Psychology, Anthropology, Economics, History, etc.) 450000-459999, 420000-429999 Sciences (Biology, Physical Sciences, Environmental Sciences) 260000-269999, 400000-409999, 030102 Other Anything else, e.g. 999999 [Return to Course Offerings Table] Study Level Table   Level of Study Value Lower Division (100-200) L Upper Division (300-400) U Graduate Level G Noncredit N CEU C Professional Technical P Professional Development D Adult Learning Skills A K-12 K [Return to Course Offerings Table] Term/Semester Table   Term/Semester Value Open Enrollment OPEN Winter 2000 WI00 Spring 2000 SP00 Summer 2000 SU00 Fall 2000 FA00 Winter 2001 WI01 And so forth (TermYear) TTYY [Return to Course Offerings Table] Delivery Methods Table   Delivery Method Value Live Interactive Video (one-way or two-way) LV Telephone Conferencing TE Audiotape AU Videotape VT Telecourse (broadcast, cable, ITFS) TC Internet/Web-based IW CD-ROM CD Correspondence CO Intensive Course IN Face-to-Face, offsite FF Computer Conferencing CC [Return to Course Offerings Table] Student Technology Requirements Table   Technology Requirement Value Specialized Software SS E-mail Account EA Videotape Player VP Audiotape Player AP Audio CD Player AC Computer CM CDROM CD Access to Cable Channel in Receive-site Area CA Internet/Web Access IW [Return to Course Offerings Table]

| Contributor Home | Catalog Feed Schedule | Catalog feed instructions | Catalog data elements |
| Course Edit Tool | Data element glossary | Institutional Information | MS Access template | Degree data guidelines |