Transferology Programs Import & Export File Format
Within Manage Programs, Transferology® Lab School Administrators and Program Administrators can add and import Program information to share with students and staff in Transferology® and the Transferology® Lab, respectively. Institutions can also export this data. This article details the file format required when importing Programs. It is also the same format that exported data will be presented in.
Import Programs
To import Programs, see Manage Programs: Import Programs. Use the File Format below when constructing the import file.
Export Programs
To export Programs, see Manage Programs: Export Programs. The exported data will be organized in the File Format below.
File Format
Data must be submitted in the format and order noted below.
- Where it says Required, fields must not be empty and must not contain only space characters. The field value length must be in the range specified by the length column.
- Where it says Optional, fields may be empty but a blank column/cell would still be required in each row. If the field is not empty, the field value length must be in the range specified by the length column.
Fields reserved for future use are not currently used by Transferology® in processing but may be used in the future.
Sample Import Line:
English - (BA) Creative Writing,V,ENG-CW,000000,999999,,23.1302,,,,B,C,,,,
| Field | Description | Required? | Length | Format | Pattern |
| Name | The Program name. | Required | 1-150 | Variable Char | |
| Status | Who can see Programs and run audits (if available) in Transferology® and the Transferology® Lab. Test = The Program is not displayed within Transferology or Transferology Lab outside of Manage Programs. Visible = The Program is visible to all users within Transferology and the Transferology Lab. If the LYT is current or in the future, a Program audit can be run (if available) where listed. If the LYT has passed, the audit will only be visible/can be run within Manage Programs. Program List Only: The Program will appear in the list of Programs within Transferology and the Transferology Lab, but audits will only be available to School or Program Administrators (if available) Regardless of Status, School and Program Administrators can view all Programs and run audits (if available) within the Manage Programs page. |
Required | 1 | Character | T=Test V=Visible P=Program List Only |
| Code | The degree program code as it is used in the degree audit system. | Required | 1-20 | Character | |
| FYT | Helps determine the year/term submitted with an audit request. (the first year/term offered is 0 or 000000, the beginning of time) |
Required | 1-6 | Character; 0 or a 4-digit value followed by 0-2 digits or letters | 0, 000000, YYYYTT |
| LYT | The last term in which an audit request can be generated. (the last year/term offered is 999999, the end of time) |
Required | 1-6 | Character; 0 or a 4-digit value followed by 0-2 digits or letters | YYYYTT |
| InstCD | uAchieve® schools only. If left blank, the 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 | 1-6 | Character | |
| CIP Code | The Classification of Instructional Programs (CIP) code that corresponds with the Program. A value of "01" would be entered as "01.0000". If CIP codes are not stored in this format within the Student Information System (SIS), the value will need to be modified to fit into this pattern before importing Programs. Reserved for future use. |
Optional | 6 | Numeric | NN.NNNN |
| URL | The URL linking to the program description on the school's website. | Recommended | 1-250 | Variable Char | |
| Description | A short description of the Program or a generic note to display to users on the Program details page and the Program Note of an audit. | Optional | 1-500 | Variable Char | |
| Questions | A unique identifier for the Questions set up in Transferology. If more than one Question is assigned to a Program, enter using the following format: "Description1,Description2,Description3,etc". (Quotation marks must be included around the entire group; use commas to separate the individual Question descriptions.) |
Optional | 1-128 | Variable Char | |
| Degree Type | A (Associate's) N (Minor) B (Bachelor's) C (Certificate) D (Diploma) M (Master's) P (Doctorate) O (Other) |
Required | 1 | Character | A, N, B, C, D M, P, O |
| College | DegreeWorks® institutions only; reserved for possible future audit integration development. Please leave the field blank if using a different degree audit system. |
Optional | 1-20 | Character | |
| Department | DegreeWorks institutions only; reserved for possible future audit integration development. Please leave the field blank if using a different degree audit system. |
Optional | 1-20 | Character | |
| Program Type | DegreeWorks institutions only; reserved for possible future audit integration development. Please leave the field blank if using a different degree audit system. |
Optional | 1-20 | Character | |
| Program Extension | DegreeWorks institutions only; reserved for possible future audit integration development. Please leave the field blank if using a different degree audit system. |
Optional | 1-20 | Character | |
| Delivery Type | How the program is offered. C: On Campus O: Online CO: On Campus and Online Blank (If left blank, the Delivery Type will default to "On Campus".) |
Optional | 0-2 | Character | C, O, CO |