Name

Required

Important Configuration Notes

CSV Column Heading
Note: case sensitive!

Required

Important Configuration Notes

Header Row

HEADER ROW

YES

IMPORTANT: The header row is required for your .csv file to import correctly and the values to be stored properly by the CCCApply Administrator.
The column heading labels MUST NOT BE CHANGED. If the heading changes case, the file will be rejected.

Application

application

YES

• 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 application majors), OR,

  • INTERNATIONAL (for International application majors)

• 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.

Major Code

YES

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

DO NOT EDIT AN EXISTING MAJOR CODE

code

YES

• 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 layout in the Data Dictionary

Major Description

YES

Enter your college’s description for a particular major, in 100 characters or less.

description

YES

• The “description” column field is required.

• Provides a text description of the active major to the end-user.

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

• Must be formatted based on layout in the Data Dictionary

• *This is the text that appears to the student in the "Intended Major or Program of Study" question dropdown in the appropriate CCCApply application.

Major Category

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.

• You may create multiple category values (pressing Enter after each entry) which can be associated with multiple majors. There is no limit to the number of categories you can add.

• Each Categories value has a limit of 100 characters.

• Click the “x” icon to remove a category from the Add Major screen.

• When adding categories manually via the Add Major screen, you must hit ENTER after each correctly spelled category.

• If used, the creation of one category will enable the Major Category Filter and display the Category drop down menu in the application.

• If used, the applicant is required to select a category first, then select a major.

category

NO

• The “category” column is optional.  See notes about adding your custom categories to this column in the section below.

• See Configuring Major Categories below for further details.

TOP Code

• 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).

topCode

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 #

OPTIONAL field.

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

programControlNumber

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

REQUIRED for implementing the Ed Goal / Major Transfer Filter.

• Select the Award Type option that best aligns to each major.

• Not a deliverable field.

awardType

YES*

• REQUIRED in the Majors CSV import file.

• REQUIRED for implementing the Ed Goal/Major Transfer Filter.

• The <awardType> column values must not contain any spaces and MUST be one of the following allowed values:

  • AA_T

  • AS_T

  • AA_degree

  • AS_degree

  • BA_degree

  • BS_degree

  • Certificate

  • Other

  • None

Application Type

applicationType

YES

• Required.

• Setting the Application Type is

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

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

• INTERNATIONAL APP: You can leave this value/column blank in the International Application ONLY.

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

CIP Code

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

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

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

• The “start” date is required.

• The start date data in this column identifies the date when the Major should begin to display to students 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 or the associated term's Term End date, else error message will display;

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

Major End Date

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.

end

YES

• The “end” column identifies the major’s End Date which is the date the major stops displaying in the "Intended Major or Program of Study" menu in CCCApply applications;

• The End Date is required, else error message.

• 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

• The End Date must be configured in the following format:  mm/dd/yyyy

• The End Date can be configured manually by clicking on "Add Major" or "Edit Major" by an authorized user

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

• Cannot be before the Major Start Date, else error message else error message will display

• Can be added by the Import Majors process via a properly formatted .csv file with all required Majors data fields

• 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

• If user selects, "Major has end date" - THEN a valid end date must be provided in the CSV file , else error message should display

Major has no end date
check box

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.

Created Date

created

NO

Header Row

YES

IMPORTANT: The header row is required for your .csv file to import correctly and the values to be stored properly by the CCCApply Administrator.
The column heading labels MUST NOT BE CHANGED. If the heading changes case, the file will be rejected.

Application

application

YES

• 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 application majors), OR,

  • INTERNATIONAL (for International application majors)

• 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.

Major Code

code

YES

• 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 layout in the Data Dictionary

Major Description

description

YES

• The “description” column field is required.

• Provides a text description of the active major to the end-user.

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

• Must be formatted based on layout in the Data Dictionary

• *This is the text that appears to the student in the "Intended Major or Program of Study" question dropdown in the appropriate CCCApply application.

Category

category

NO

• The “category” column is optional.  See notes about adding your custom categories to this column in the section below.

TOP Code

topCode

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

programControlNumber

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 field must be populated in the system. If you are adding or editing an individual major using the Add/Edit Major screen, you can bypass selecting a value in the dropdown menu; however, if you do this a value of “None” will be system-generated and stored as the Award Type for that major.

The Award Type field/column is:

• REQUIRED when implementing the Ed Goal/Major Transfer Filter (new spring 2024).

• REQUIRED when importing majors using the CSV file.

• The <awardType> column values must not contain any spaces and MUST be one of the following allowed values:

  • AA_T

  • AS_T

  • AA_degree

  • AS_degree

  • BA_degree

  • BS_degree

  • Certificate

  • Other

  • None

Application Type

applicationType

YES

• Required.

• Setting the Application Type is

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

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

• INTERNATIONAL APP: You can leave this value/column blank in the International Application ONLY.

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

CIP Code

cipCode

NO

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

• Does not appear to the end user

Education Goals
NOT USED for 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.

Start Date

start

YES

• The “start” date is required.

• The start date data in this column identifies the date when the Major should begin to display to students 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 or the associated term's Term End date, else error message will display;

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

End Date

end

YES

• The “end” column identifies the major’s End Date which is the date the major stops displaying in the "Intended Major or Program of Study" menu in CCCApply applications;

• The End Date is required, else error message.

• 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

• The End Date must be configured in the following format:  mm/dd/yyyy

• The End Date can be configured manually by clicking on "Add Major" or "Edit Major" by an authorized user

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

• Cannot be before the Major Start Date, else error message else error message will display

• Can be added by the Import Majors process via a properly formatted .csv file with all required Majors data fields

• 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

• If user selects, "Major has end date" - THEN a valid end date must be provided in the CSV file , else error message should display

Create Date

created

NO