Transferology Programs Import & Export File Format
Programs can be imported into, or exported out, of Transferology Lab by users with either the School Administrator or Program Administrator role. The format for both imported and exported data is the same, as follows:
Field |
Format |
Length |
Pattern |
Description |
Required? |
---|---|---|---|---|---|
Name | Variable Char | 1-150 | Your program name | Required | |
Status | Character | 1 | T=Test V=Visible P=Program Only |
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 |
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 | Required |
InstCD | Character | 1-6 | DARwin/uAchieve Only If left blank, your institution's default COM (UNIQ value) will be used when running a program audit. A UNIQ value is a short string of characters assigned to your institution to help identify it in processing. If a COM other than the default should be used, enter it here. The default COM will be overridden, and this value will be used instead. |
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. |
Optional |
URL | Variable Char | 1-250 | URL to link to more information about this program on your school's website | Recommended | |
Description | Variable Char | 1-500 | A note to users displayed in the view audit page's header and on the program details screen | Optional | |
Questions | 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 | A, N, B, C, D, M, P, O | A (Associate's) N (Minor) B (Bachelor's) C (Certificate) D (Diploma) M (Master's) P (Doctorate) O (Other) |
Required |
College | Character | 1-20 | DegreeWorks Audits Only-please leave field blank for other audit systems | Optional | |
Department | 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 Extension | Character | 1-20 | DegreeWorks Audits Only-please leave field blank for other audit systems | Optional | |
Delivery Type | Character | 0-2 | C, O, CO | Possible values indicate delivery method of program offerings: C: On Campus O: Online CO: On Campus and Online Blank (If left blank, the Delivery Type will default to "On Campus") |
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,,,,