Transferology Programs Import Record Format

Both School Administrators and Program Administrators can import and/or export programs in the Transferology format.

The Transferology Programs Import Record Format is the same as the Transferology Programs Export Record Format.

Field

Format

Length

Pattern

Description

Required?

Program Name Variable Char 1-150 This will be your program name. Required
Status Character 1 T=Test
V=Visible
P=Program Only
Transferology statuses:
Test = Only visible to administrators at your school
Visible = Visible to all Transferology users
Program Only = Program will be shown in list of programs for your school. Users will be able to view program details (name, description, URL, etc), but will not be able to run audits with the program
Required
Program Code Character 1-20 The program's unique identifier in your school's degree audit system Required
FYT Character 1-6 CCYYMM The first year/term this program is available Required
LYT Character 1-6 CCYYMM The last year/term this program is available Optional
COM table override Character 1-6 [DARwin/uAchieve Only] the COM Table used for this program rather than the default (your UNIQ value) Optional
CIP Code Numeric 6 NN.NNNN Reserved for future use.
The Classification of Instructional Programs code that corresponds with this program

We have chosen to use 6-digit codes. So a value of "01" would be entered as "01.0000". If you do not store CIP codes using this format in your SIS you will need to modify the value to fit this pattern before importing your programs.
URL for program Variable Char 1-250 URL to link to more information about this program on your school's website Recommended
Description for program Variable Char 1-500 A note to users displayed in the view audit page's header and on the program details screen Optional
Question Description Variable Char 1-128 A unique identifier for the questions you've set up in Transferology. 
If you have more than one question assigned to a program you should enter those in the following format:
"Description1,Description2,Description3,etc"
 (make sure you put quotation marks around the entire group and commas between the individual question descriptions)
Optional
Degree Type Character 1 B, A, C, D, M, P, or O Reserved for future use
B (Bachelor)
A (Associate)
C (Certificate)
D (Diploma)
M (Masters)
P (Doctorate)
O (Other)
Required
College Code Character 1-20 DegreeWorks Audits Only-please leave field blank for other audit systems Optional
Department Code Character 1-20 DegreeWorks Audits Only-please leave field blank for other audit systems Optional
Program Type Character 1-20   DegreeWorks Audits Only-please leave field blank for other audit systems Optional
Program Ext Name Character 1-20   DegreeWorks Audits Only-please leave field blank for other audit systems Optional
Delivery Method Character 0-2 Possible values indicate location of program offerings, including:C: on campusO: onlineCO: both on campus and online
Blank
Only added to the Transferology format, not u.select Optional

Legend

Required: field must not be empty and must not contain only space characters. The length of the field value must be in the range specified by the length column.

Optional: field may be empty. If the field is not empty, the length of the field value must be in the range specified by the length column.

Reserved for future use: the field is not currently used by Transferology but may be used in the future

Sample Import Line:

English - (BA) Creative Writing,V,ENG-CW,000000,999999,,23.1302,,,,B,C,,,,