Questions and Answers Import Record Format

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

Rcredit Field

For pseudo course answers:

• The export format is the same: a number with 5 digits after the decimal point.
• Any valid number is allowed on import.

For non-pseudo courses answers:

• u.select format will export 0.0000 and Transferology format will leave the field blank.
• This field is ignored when a non-pseudo course answer is imported.

Pflag Field

For pseudo course answers:

• u.select format uses "True" and "False" for imports and exports.
• Transferology format uses "Y" and "N".

For non-pseudo course answers:

• u.select always exports "False".
• Transferology leaves the field blank.
• This field is also ignored when a non-pseudo course answer is imported.

The legacy u.select Questions Import Schema is the same as the legacy u.select Questions Export Schema.

Questions

TABLE

Answers

Fields that are required, regardless of what you are adding with your answer:

Field	Format	Length	Pattern	Description	Required
Import Type	Character		ANSWER	Identifies the line as an answer.	Required
Associated Question Description	Variable Character	128 max		The question description of the question to which this is an answer.	Required
Answer Number	Numeric	2	1,2,3,4, etc	The number that represents the order in which the answer will display to users.	Required
Followup Question Description	Variable Character	128 max		The question description of the question users will be asked as a followup to this answer.
The Answer	Variable Character	255 max		The answer as it will appear to users.	Required
Action Type	Character	1	M, C or N	Action to take when this answer is chosen by a user. M = Marker, C = Pseudo Course, N = Nothing	Required
Pseudo Course Flag	Variable Character		N or Y	Indicates whether or not the course is a true pseudo course.	Required

Fields that are needed for adding a PSEUDO course with your answer

 

Field	Format	Length	Pattern	Description	Required
InstIDQ	Numeric	2	71, 72, 73 or 74	The InstID Qualifier used for your Pseudo course.	Required
InstID	Variable Character	4-6		The institution ID that corresponds with the IDQ used.	Required
InstCD	Variable Character	3		The institution CD associated with the course.	Required
Pseudo Course Department	Variable Character	15		The department of the course that's being added.	Required
Pseudo Course Number	Numeric	15		The course number of the course being added.	Optional
Pseudo Course Y/M	Numeric	6	CCYYMM	The year to be added for the course.	Required
Pseudo Course Title	Variable Character	29		The title of the course as it will be displayed on the plan.	Optional
Pseudo Course Hours	Numeric	1-8		The credit hours associated with the course.	Optional
Pseudo Course Grade	Character	1-4		The grade to be assigned the course.	Required

Fields that needed for adding a MARKER with your answer

 

Field	Format	Length	Pattern	Description	Required
Marker Requirement Name	Variable Character	1-9		The requirement name as found in the degree audit system. Value will begin with a $	Required
Marker Type	Character	1	R or D	Identifies what type of marker is added. R = Marker Requirement. D = Marker List	Required
Marker Req/List Value	Variable Character	1 - 9		The replacement requirement name to be included in the degree audit. Value replaces the $Marker.	Required
Catalog Y/T	Numeric	4 digits followed by 0-2 alphanumeric characters	CCYYMM	The catalog year for the marker requirement/list if a specific y/t is to be used rather than the y/t selected by the user when creating their plan.	Optional
School Code	Numeric	1-3		The InstCD value if different from the InstCD defined for your institution in Transferology.	Optional
Control Code	Numeric	1-2		The exception control code.	Required