Page Comparison

...

CSV Column Heading

Required

Important Configuration Notes

HEADER ROW

YES

IMPORTANT: The header row is required in order for your .csv file to import correctly and the values to be stored properly by the CCCApply Administrator.

Application

YES

The Application column identifies the CCCApply application that these majors pertain to;
The Application data is system-generated and should not be changed.
When adding new Majors to your file, ensure the application is correct and in all caps.
Do not mix APPLY and INTERNATIONAL application majors in one .csv file at this time.
Do not remove or change this column.

Note

The Application column value must be in ALL CAPS and be either:

APPLY (for CCCApply application majors), OR,
INTERNATIONAL (for International application majors)

You cannot mix APPLY and INTERNATIONAL application majors in one .csv file at this time.

Major Code

YES

The “Code” column displays the required Major Code identifier that you have listed in your existing list of majors.
Adds a row to the Majors database table identifying a unique Major
Must be formatted based on layout in the Data Dictionary

Major Description

YES

The “Description” is required
Can be edited/modified by an authorized college/district user
Must be formatted based on layout in the Data Dictionary
Provides a text description of the active major to the end-user
*This is the text that appears to the end user in the "Intended Major or Program of Study" menu in CCCApply Standard and International applications

Category

NO

The “Category” column is optional. See detailed notes about adding your custom categories to this column in the section above.

TOP Code

NO

The “Top Code” is an Optional field, but can be added by the college if desired.
Top Codes should be aligned to each individual Major
Does not appear to the end user

Program Control Number

NO

The “Program Control Number” is an optional field, but can be added by the college if desired.
Program Control Numbers should be aligned to each individual major
Does not appear to the end user

Award Type (AwardType)

YES

The Award Type (AwardType) field values are slightly different in the new Admin 2.0 system. The following notes pertain to implementing this field in the new system:

When importing majors using the CSV file, you MUST include a value in the awardType column on your import file. If you do not have an aligned award type for one or more majors, please enter “None”.
The award type values must not contain any spaces and MUST be one of the following allowed values:
- AA_degree
- AS_degree
- AA_T
- AS_T
- Certificate
- Other
- None
The “Award Type” is an optional field, but can be added by the college, if desired.
Aligned to each individual Major
Does not appear to the end user
The Award Type field is required in the new system. All imported majors, and majors migrated from the Admin 1.0 system, must include a value in this field. If you do not have an aligned award type for one or more majors, please enter “None”

Warning

Though the Award Type value does not display to the end-user in the CCCApply applications, and has been an optional field in the legacy Admin 1.0 system, having a value in this field/column is REQUIRED in the Admin 2.0 system. All imported majors, and majors migrated from the legacy Admin 1.0 system, must include a value in this field. If you do not have award types aligned to your majors in Admin 1.0, please ensure "None" is populated in the field in Admin 2.0.

Note

If you are working with your Admin 1.0 Export Majors file, you'll notice that the Award Types export a single character numerical value. This format also works as an accepted The award type values must not contain any spaces and MUST be one of the following allowed values:

1 = AA_degree

2 = AS_degree

5 = AA_T

6 = AS_T

3 = Certificate

4 = Other

X = BA_degree

Y = BS_degree

0 = None

When importing majors using the CSV file, please include a value in the awardType column on your import file. If you do not have an aligned award type for one or more majors, please enter “None”

CIP Code

NO

The “CIP Code” is an optional field, but can be added by the college, if desired.
Aligned to each individual major
Does not appear to the end user

Education Goals (eduGoals) NOT APPLICABLE in this version

NO

Warning

VERY IMPORTANT: Though the “EduGoal” field and filter is not applicable in this release, the "eduGoal" column MUST NOT BE REMOVED from your Majors CSV file, and the entire column must be left BLANK in your CSV file.

NOTE: Until further notice, do not enter ANY data or values in the EduGoals column in your Majors CSV file. If any values accidentally get entered into the column, your students may not be able to select a Major in CCCApply.

Warning
The Education Goals filter is OUT OF SCOPE for the first version of the CCCApply Admin 2.0. This filter was removed from the code prior to the September 2018 release. However, the column remains in the table for future development. This column must NOT BE REMOVED from your CSV file. It must remain EMPTY in your Import Majors CSV file.

Start Date

YES

End Date

YES

Create Date

NOVERY IMPORTANT: The “Create” column is a system generated date field that MUST remain blank when completing your CSV import file.

Warning
VERY IMPORTANT: The “EduGoal” and the "Created" columns do not pertain to this version of the Majors module in Admin 2.0 - BUT the data columns MUST remain in your Import Majors file and should be left BLANK in your CSV file.

...

Versions Compared

Old Version 19

New Version 20

Key