Name

Required?

Major Field Configuration Notes

CSV Column Heading
Note: case sensitive!

Required?

Important CSV File Configuration Notes

Header Row

Yes.

The header row pertains to the Majors CSV file only.
The header row must be included in the file correctly to ensure a successful import.

Required for the CSV file

Header Row

YES

IMPORTANT: The file header row containing the column headings is required for your .csv file to import successfully and for the values to be stored correctly in the admin system.

• DO NOT CHANGE the column heading labels that were exported.

• The field name format must matches what is shown in the yellow column in this table.

• The column heading labels are case sensitive.

• If the headings change case, the file will be rejected.

Application

Yes

System-generated based on which CCCApply application you are exporting from in the Administrator.

For the CCCApply Standard & Noncredit applications, export your majors file from the CCCApply application in the Administrator.

For the CCCApply International application, export and import your majors CSV file from the International application in the Administrator.

application

YES

• REQUIRED field.

• The Application column identifies the CCCApply application that the majors pertain to. The value must be in ALL CAPS and either be:

  • APPLY (for CCCApply & Noncredit application), OR,

  • INTERNATIONAL (for International application)

• Do not mix APPLY and INTERNATIONAL application majors in one .csv file.

• 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 remove or change this column.

Major Code

Yes

Enter your unique college code for each major, up to 30 characters.

DO NOT EDIT AN EXISTING MAJOR CODE

code

YES

• REQUIRED field.

• Maximum characters is 30.

• The “code” column displays theMajor Code identifier as defined in your existing list of majors.

• Adds a row to the Majors database table identifying a unique Major

• Must be formatted based on <major_code> layout in the Data Dictionary.

• This is not the <major_id> field. That field is N/A.

Major Description

Yes

Enter the name or description for a particular major in 100 characters or less.

The major description is the name or title of the major which displays alphabetically to the end-user in the application.

description

YES

• REQUIRED field.

• The “description” is a text field (max 100 characters).

• The “description” is the name or title of the major that appears to the end-user (student) in the application.

• Can be edited/modified by an authorized college/district user.

• If the Ed Goal/Majors Filter is NOT enabled, all majors display alphabetically by their “description”, regardless of award type.

• If the Ed Goal/Majors Filter is enabled and the student selects “Obtain an associate degree and transfer to a 4-year institution” as their Education Goal, the major descriptions display alphabetically by <awardType>, in the following order: AA-T, AS-T, AA_degree, AS_degree. All other awardTypes do not display when this Education Goal is selected.

Major Category

No

OPTIONAL field.

• Major categories may be added, edited or removed by the college to filter or group your list of majors. Major categories are defined by each college.

• Be aware: By adding one or more categories, you are opting/choosing to implement the Major Category Filter - which adds a Category drop down menu to the Enrollment page of the application, displaying your custom categories.

• If no categories are created, the Category drop down is hidden and your list of Majors will display alphabetically in one list.

• Each Category value has a limit of 100 characters.

• You may create multiple categories (pressing Enter after each entry) which can be associated with multiple majors.

• There is no limit to the number of categories you can add.

• To remove a category from the Add/Edit Major screen, click the “x” icon included with each individual category.

category

NO

• OPTIONAL field.

If your college has opted to implement Major Categories, then…

• Each Category value has a limit of 100 characters.

• Multiple categories associated with the same major should be comma separated in the “category” column.

• The “category” column may be blank; however keep in mind that the major will not be included one of your custom categories and will only appear in the default All Majors category.

• If no categories are created (the Major Category filter is not implemented and the Category drop down menu is hidden on the application. Without categories configured, your list of Majors will display alphabetically in the Intended Major or Program of Study drop down.

TOP Code

No

• OPTIONAL field.

• Not delivered with submitted applications.

• If used, enter the major’s six-character Taxonomy of Programs (TOP) code from the CCCCO (Chancellor’s Office).

• Does not appear to the end user.

topCode

NO

• OPTIONAL field.

• Not delivered with submitted applications.

• If used, enter the major’s six-character Taxonomy of Programs (TOP) code from the CCCCO (Chancellor’s Office).

• Does not appear to the end user.

Program Control Number

No

OPTIONAL field.

If used, enter the CCCCO Program Control Number code for each major from the Chancellor’s office.

programControlNumber

NO

• OPTIONAL field.

• Not delivered with submitted applications.

• Does not appear to the end user.

Award Type

Yes

REQUIRED if implementing the Ed Goal / Majors Filter for Associate Degrees.

On the Add/Edit Major screen:

• Select the Award Type option from the drop down menu that best aligns to each major.

• DOES NOT APPEAR TO THE STUDENT in the application.

• Not a deliverable field.

awardType

YES*

• REQUIRED field in the Majors CSV import file.

• REQUIRED for implementing the Ed Goal / Majors Filter.

• The <awardType> column values must not contain any spaces and MUST be one of the allowable values shown below:

  • AA_T

  • AS_T

  • AA_degree

  • AS_degree

  • BA_degree

  • BS_degree

  • Certificate

  • Other

  • None

Application Type

Yes

• REQUIRED if using the CCCApply Noncredit Application.

• Identifies which CCCApply application the major will be available in.

• Must be set with one of the following values:

  • Standard (major will display in the Standard app only)

  • Noncredit (major will display in the Noncredit app only)

  • Both (major will display in both applications)

• Defaults to the Standard app value.

applicationType

YES

• REQUIRED field.

• Identifies which CCCApply application the major will be available in.

  • Enter "Standard" in your CSV file for the Standard application.

  • Enter "Noncredit" in your CSV file for the Noncredit application.

• Defaults to Standard if accidentally left blank in the CSV.

• REMINDER: You cannot combine the Standard or Noncredit major codes in the same CSV with the International application major codes. 

CIP Code

No

OPTIONAL field. 

If you choose to populate the CIP Code field, enter the Classification of Instructional Programs (CIP) code.

cipCode

NO

• Optional field. May be added by the college, if desired.

• Does not appear to the end user

EduGoals

No

NOT APPLICABLE. Currently not part of the Ed Goal/Majors Filter.

eduGoals

NO

Leave this column in place and LEAVE IT EMPTY.

Do not enter ANY data or values in the EduGoals column. If any values accidentally get entered into the column, your students may not be able to select a Major in CCCApply.

Major Start Date

Yes

Enter the date when this major will start being available for selection by an applicant in either the CCCApply or International application(s)’ Intended Major or Program of Study drop-down list.

start

YES

• REQUIRED field.

• The “start” date data in this column identifies the date and time that the Major should start appearing to end-users in the "Intended Major or Program of Study" menu in CCCApply applications.

• The start date MUST BE configured in the following format:  MM/DD/YYYY

• Cannot be after the major’s End Date (“end”) or the associated term's Term End date, else an error message will display/

• Must be a valid calendar date (i.e., cannot be February 30, etc.)

Major End Date

Yes*

Every major must either have an end date or the Major has no end date checkbox must be checked.

Enter the date in which this major will no longer be available for selection by an applicant in either the CCCApply or International application(s)’ Intended Major or Program of Study drop-down list.

For a major to appear in the application’s drop-down list, the current date must be between ‘major:date_start’ and ‘major: date_end’ (inclusive).

If you do not want to end-date your major, you must select the Major has no end date check box.

If user selects "Major has no end date" THEN  the Major will ALWAYS display in the "Intended Major or Program of Study" menu in CCCApply

end

YES*

• REQUIRED = Must have a date or left blank for no end date.

• The “end” column identifies the date in which the major is no longer available and will no longer display in the "Intended Major or Program of Study" drop down menu in the application(s);

• The major must be setup with one of the following settings:  

  • Major has no end date (in the CSV file, leave this column blank)

  • Major has an end date (must be formatted: mm/dd/yyyy

• Must be a valid calendar date, i.e., cannot be February 30, etc. (else error message appears)

• Cannot be before the Major start date <start>, else error message else error message will display during Import.

• If your major has end date - THEN a valid end date must be included in the CSV file , else error message should display

Major has no end date
check box

No

Select this check box if the major will have no end date. When this check box is selected, the Major End Date field becomes hidden.

No

(If your major has no end date - leave the “end” column BLANK in the CSV file.)

Created Date

Yes

created

YES