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 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
| Field | Description | Required? | Length | Format | Pattern |
| Name | Program name | Required | 1-150 | Variable Char | |
| Status | Who can see Programs and run audits (if available) in Transferology® and Transferology® Lab Test = Program is not displayed within Transferology or Transferology Lab outside of Manage Programs Visible = Program is visible to all users within Transferology and 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: Program will appear in the list of Programs within Transferology and Transferology Lab, but audits will only be available to School or Program Administrators (if available) Regardless of Status, all programs can be viewed and audits run (if available) within the Manage Programs page by School and Program Administrators. |
Required | 1 | Character | T=Test V=Visible P=Program List Only |
| Code | 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 000000, the beginning of time) |
Required | 1-6 | Character | CCYYTT |
| 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 | CCYYTT |
| 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 | 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 | URL linking to the program description on the school's website | Recommended | 1-250 | Variable Char | |
| Description | 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 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 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 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 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 |
Legend
Required: field 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.
Optional: field may be empty. If the field is not empty, the field value length must be in the range specified by the length column.
Reserved for future use: the field is 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,,,,