Page Comparison

Name

Required?

Major Field Configuration Notes

CSV Column Heading
Note: case sensitive!

Required?

Important CSV File Configuration Notes

Header Row

Required for the CSV file

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.

Header Row

YES

IMPORTANT: The file header row containing the column headings is required for your .csv file to import correctly successfully and for the values to be stored properly by the CCCApply Administrator.
The column heading labels MUST NOT BE CHANGED. If the heading changes 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 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

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.

• 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 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 on the Enrollment page of the application and displays all your categories.

• Each Category value has a limit of 100 characters.Click the “x” icon to .

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

• To remove a category from the Add/Edit 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 , click the “x” icon included with each individual category.

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

category

NO

• OPTIONAL field.

If you opt-in to implement Major Categories…

• Each Category value has a limit of 100 characters.

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

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

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

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

• Does not appear to the end user.

Award Type

YES

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

On the Add/Edit Major screen:

• Select the Award Type option 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 / Major Transfer Majors Filter.

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

• Required.

• Setting the Application Type is

  • AA_T

  • AS_T

  • AA_degree

  • AS_degree

  • BA_degree

  • BS_degree

  • Certificate

  • Other

  • None

Application Type

applicationType

YES

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

• INTERNATIONAL APP: You can leave this value/column Defaults to Standard if accidentally left blank in the International Application ONLYCSV.

• REMINDER: You cannot combine the CCCStandard Standard 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