Legacy u.select Program Import/Export Schema
Both School Administrators and Program Administrators can import programs in the legacy u.select format. Only superusers can export programs in the legacy u.select format.
- For Transferology imports/exports, see the Programs Import/Export Schema page.
The legacy u.select Programs Import Schema is the same as the legacy u.select Programs Export Schema.
Field
|
Format
|
Length
|
Pattern
|
Description
|
Required?
|
---|---|---|---|---|---|
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 |
|
This field should be empty since the data is no longer used.
|
|
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. |
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. |
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. |
Required |
Delivery Types |
Variable Character |
1-4 |
See below* |
Select one or more of these delivery types (see example below): |
Required |
College Code |
Character |
1-2 |
|
DegreeWorks Audits Only |
|
Department Code |
Character |
1-2 |
|
DegreeWorks Audits Only |
|
Program Type | Character | 1-2 | DegreeWorks Audits Only | ||
Program Ext Name | Character | 1-2 | DegreeWorks Audits Only |
*Delivery Type: You can select multiple values in this field. If you opt to set more than one delivery type per program do not place commas between entries.
Example of a single Delivery Type:
|
Example of a multiple Delivery Types:
|