Transferology Programs Import Record Format

Last updated
Save as PDF
Share
1. Share
2. Share
3. Tweet
4. Share

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

For legacy u.select imports/exports, see the Legacy u.select Programs Import/Export Schema page.

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.	Required
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.	Optional
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	Char	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

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 isn't 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,,,,