Legacy u.select Program Import/Export Schema

First Category

Variable Char

100

This will be your program name.

Required

Second Category

Variable Char

1-60

This field should be empty, it is NOT used by Transferology.

Third Category

Variable Char

1-60

This field should be empty, it is NOT used by Transferology.

Status for 1st Category

Character

1

H=Plan Only

T=Test

V=Visible

space=Visible

P=Program Only

Transferology statuses:

Visible

u.select statuses:

Plan Only = Hide this category from the Programs by School area. This category will only be available when creating a Plan.

Test = Only visible to administrators at your school.

Visible = Visible to all u.select users.

Space = Visible to all u.select users.

Program Only = Hide this category from the Create a Plan area. This will only be available when using Find a Program or Programs by School.

Required

Status for 2nd Category

Character

1

Status for 3rd Category

Character

1

This field should be empty since the data is no longer used.

Program Code

Character

1-15

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 Only The COM Table used for this program rather than the default (your UNIQ value)

Optional

CIP Code

Numeric

6

NN.NNNN

The Classification of Instructional Programs code that corresponds with this program. An entry in this field is required if you want your programs to display in the Find a Program section. 

Per the CIP website, CIP code values are displayed "in the following formats for 2-, 4-, and 6-digit codes: 01, 01.01, and 01.0101." For consistencies sake, 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 into the Transferology Lab.

Recommended

URL for program

Variable Char

1-250

URL to link to more information about this program on your school's website.

Recommended

Note for program

Variable Char

1-250

A note to users that will appear on the top of your audit.

Optional

Question Description

Variable Char

1-128

A unique identifier for the questions you've set up in u.select. 
If you have more than one question assigned to a program you should enter those in the following format "Description1,Description2,Description3,etc" 
(so making sure you put quotation marks around the enter group and commas between the individual question descriptions.)

Optional

Degree Type

Variable Char

1

B, A, C, D, M, P, or O

Used in the Find a Program area. Allows users to filter their search by degree type. 
B (Bachelor), 
A (Associate), 
C (Certificate), 
D (Diploma), 
M (Masters), 
P (Doctorate),

Required

Delivery Types

Variable Character

1-4

See below*

Select one or more of these delivery types (see example below): 
C (On Campus), 
O (Online), 
X (Other) - a program that is delivered by a method that is neither on campus nor online, 
M (Multiple) - a program offered by some combination of delivery methods

Required

College Code

Character

1-2

DegreeWorks Audits Only

Department Code

Character

1-2

DegreeWorks Audits Only

English - (BA) Creative Writing,,, , , ,ENG-CW,000000,999999,,23.1302,,,,B,C,,,

English - (BA) Creative Writing,,, , , ,ENG-CW,000000,999999,,23.1302,,,,B,COXM,,,