Confidential - For Authorized California Community Colleges Staff Use Only. Do not distribute externally.

Overview & Tool Purpose

The OpenCCC Administrator tool enables California Community Colleges administrators and staff to create and verify a CCCID account on behalf of a student. This service is provided strictly to authorized college staff for the purpose of supporting students who are unable to complete the standard self-service processes such as incarcerated or formerly incarcerated students, unhoused students, and/or students with limited technology / internet access.

Using this tool, staff can:

Create CCCID accounts on behalf of one or more students,
Search and review existing CCCID accounts,
Manually ID verify one or more student identities.

It is important to implement business and security processes for collecting, handling, and storing the personal data when using the OpenCCC Administrator. Recommendations for some of these processes are provided in the OpenCCC Administrator: College Recommendations & Best Practices.

Policy Note: Administrative intervention in areas such as account creation, identity verification, and application submission should only be utilized for students who cannot complete the standard self-service workflow processes or when identity flags require administrative resolution.

User Authorization

Access to the OpenCCC Administrator is restricted to authorized CCC college and district staff to ensure the privacy and security of student data.

Requesting Access: To request authorized access, submit an email request to CCCTC Staff Support with the information below. Upon approval, you will be contacted by the Staff Support team for additional information.

College or District name
Staff user’s name and title
College V.P. or Department Director/Supervisor Name
Staff user’s (.edu) email address

Using the Account Creation Tool

Prevent Duplicate Accounts: Before creating a new account on behalf of a student, check to see if they have an existing account already by searching for their CCCID, SSN, or Email address on the Account Verification screen. Learn how in the Student ID Verification section.

Single Account Creation

Use the Add OpenCCC User process to create an OpenCCC account and generate a unique CCCID on behalf of an individual student.

Navigate to the CCC Administrator > Applications > OpenCCC Administrator and select the Account Creation link from the menu bar. The Add OpenCCC User screen will display for single account creation.
Complete all required fields using the student's personal and contact information. Whenever possible, confirm the student’s information through legal documentation and/or physical presence, if available.
Click Save to create the new account or Cancel to quit the process.

Reminder: Upon saving, the system will create the account and generate a unique CCCID on behalf of the user, with the temporary password and/or proxy email address.

Add OpenCCC User Screen

Account Data Fields

Wherever possible, use the student’s valid information, including their email address (if available), phone number and other required information.

Field	Notes / Recommendations

Field	Notes / Recommendations
^{Required fields are shown in bold.}*
Email Address /* Confirm Email Address*	Must be a valid email address that can be accessed by the account creator or the account user.
Primary Phone Number	Recommend using the main phone number for the college or institution. This field is not required.
Phone Type	Phone type should always be landline if the main phone number for college or institution is used. This field is not required.
Address: Homeless	Homeless flag should always be “No”.
Country*	Enter the Country of the new user or the college or institution.
State*	Enter the State of the new user or the college or institution.
Street Address 1*	Enter the Street Address of the new user or the college or institution.
Street Address 2	Enter the Street Address 2 of the new user or the college or institution. This field is not required.
City*	Enter the City of the new user or the college or institution.
Postal Code*	Enter the Postal Code of the new user or the college or institution.
Legal First Name	Enter the new user’s Legal First Name. This field is not required but highly recommended.
Legal Middle Name	Enter the new user’s Legal Middle Name. This field is not required.
Legal Last Name*	Enter the new user’s Legal Last Name.
Preferred Name	Enter the new user’s preferred first name, if applicable. This field is not required.
Suffix	Enter a Suffix for the new user. This field is not required.
Date of Birth/ Confirm Date of Birth	Important! Enter the new user’s actual Date of Birth for account recovery purposes. Confirm the user’s actual Date of Birth.
SSN No	Social Security Type: None
SSN Exception	Social Security Number: Other Exception
SSN Type	Social Security Number Type (SSN or TIN)
SSN Display	Last four digits of SSN for display
SSN^*	Social Security Number
Password* / Confirm Password*	Password requires at least 8 characters, one uppercase letter, one lowercase letter, one number, one special character (!, @, #, $, %, ^, & or *), and may not contain your name. Passwords MUST be unique and non-predictable. Recommended: Use a unique password that follows the CCCITC security guidelines described in the link below. Note: The “use temporary password” field - a backend setting - defaults to TRUE when using the single account creation process.
Terms of Use Agreement*	Important: The Terms of Use agreement must be accepted to complete the process and save the new account.

Important: The “use temporary password” field - a backend setting - defaults to TRUE when using the single account creation process.

Multi-Account Creation

The multi-account creation process allows the college to upload a list of students information using the template. Each row represents one student. When the spreadsheet is imported, the tool will either generate a new student account and CCCID or identify if an account already exists in the system with the matching information. If an account exists, - a new account will not be created and the response will include the user’s CCCID.
Note: Colleges may include an internal student ID or other unique college identifier in the Notes column for additional matching in their systems.

Step-by-Step Process

Click the Multi Account Creation link in the OpenCCC Administrator.
First time process: Click the Download Template button to download the bulkAccountCreateTemplate.csv formatted template.

Multi Account Creation Screen

Populate the file rows with the required information, ensuring strict adherence to the formatting guidelines (detailed below). Save the file to a local drive.

The Multi Account Creation Upload Template

When you’re done adding details in the spreadsheet, click the Upload File button to import the file. The system will process the records asynchronously.
Once the process is finished, click the Download Results button to retrieve the processed file of new and/or updated accounts.

When creating an account on behalf of a student, use as much of their current, actual information to support the most efficient account recovery.

To prevent the additional password reset requirement following the initial Sign in, set the “use-temp-password” field in the upload file to FALSE.

Multi Account Creation Data Fields

Account Field	Column Header	Notes and Recommendations

Account Field	Column Header	Notes and Recommendations
Email Address*	email	Must be a verified email account that can be accessed by the account creator. Unlike the single account creation process, the multi account creation sheet does not require the email address to be confirmed and entered twice.
Legal First Name	first	Enter the user’s Legal First Name in the first field.. This field is not required but highly recommended.
Legal Last Name*	last	Enter the new user’s Legal Last Name. Required field.
Legal Middle Name	middle	Enter the new user’s Legal Middle Name. This field is not required.
Suffix	suffix	Enter a Suffix for the new user. This field is not required.
Preferred Name	preferred	Enter the new user’s preferred first name, if applicable. This field is not required.
Date of Birth*	dob YYYY-MM-DD	Important: Enter the new user’s actual Date of Birth for account recovery purposes. The DOB is entered once only. Unlike the single account creation process. Important: The DOB entered must comply with the YYYY-MM-DD format. This may require some manipulation of the cell format if you are using a MS Excel file.
Accepted Terms of Use*	accepted-terms	The Terms of Use agreement must be accepted to complete the process and save the new account. You must enter “TRUE” in the accepted-terms field to avoid an error.
Address: Homeless	homeless	You must enter “FALSE” in the homeless field to avoid an error.
Street Address 1*	street1	You must enter a valid street address in the street1 field to avoid an error.
Street Address 2*	street2	The street2 field is optional and can be left blank. However, if you do enter a value for street2, you must enter a valid street address.
City*	city	Enter the City of the new user or the college or institution.
State*	state	Enter the State of the new user or the college or institution.
Postal Code*	postal	Enter the Postal Code of the new user or the college or institution.
Country*	country	Enter “US” for United States citizens.
Primary Phone Number	phone-number	You must enter a valid phone number in the phone-number field. See the proper format in the example above. Recommend using the main phone number for the college or institution. This field is not required.
Phone Type	phone-type	Phone type should always be landline if using the main phone number for the college or institution is used. This field is not required.
Password	password	Important: Enter a unique Password that follows the security guidelines described below. Passwords MUST be unique and non-predictable.
Temporary Password	use_temp_password	Set this field to FALSE to prevent a password reset change immediately following sign-in. FALSE = a verified password was used during account creation, supporting college staff submitting applications on behalf of special population students. Set this field to TRUE to trigger a password reset by the user immediately following sign-in. TRUE = a temporary password was used during account creation, requiring the user to reset their password the first time they sign-in.
Status	status	LEAVE THIS FIELD BLANK
CCCID	cccid	LEAVE THIS FIELD BLANK
Message	message	LEAVE THIS FIELD BLANK
SSN No	ssn_no	NO COLUMN - Value set to True by default in database.
SSN Exception	ssn_exception	NO COLUMN - Value set to False by default in database.
SSN Type	ssn_type	NO COLUMN - Value set to Null by default in database.
SSN Display	ssn_last4	NO COLUMN - Value set to Null by default in database.
SSN	ssn	NO COLUMN - Value set to Null by default in database.
Notes	notes	Content entered in the Notes column will not be validated and will appear unmodified in the file that is returned to the user by the bulk upload tool.

Note: To prioritize security and privacy of student personal identity information, SSN data default values are added for all new accounts created via the multi-account creation process following SSN integration with OpenCCC in September 2025.

About the Upload Process

What happens during the upload process?

Each row in the bulkAccountCreateTemplate.csv file should represent a single, unique student user. The personal information provided must be as true and accurate as possible, and all OpenCCC account requirements must be included. The data column order is important and noted in the header row.

All columns must be populated except the columns named ‘status’, ‘message’, and ‘cccid’; those columns should be empty upon upload.
As each row of user data input is processed, the ‘status’, ‘message’, and ‘cccid’ columns will be set.
If there is an error, then the ‘status’ column will display ‘Failure’; otherwise the ‘status’ column will display ‘Success’.

Upload file rules and processes

For the purpose of processing the bulkAccountCreateTemplate.csv file multiple times, the following rules and procedures may apply:

The “use temporary password” field currently does not override a previously processed upload.
Skip input row if cccid has a value, which indicates an account has already been created for the user. Note: This allows the administrator to “fix” a CSV file for failed rows and then re-submit the same document.
If a CCCID is present for a row, then new account creation is bypassed. This allows the administrator to edit the results file and re-submit (upload) again.

Staff Tip: If staff is creating an account and submitting an application on behalf of a student, set the “use-temporary-password” to False to avoid an immediate password reset when you sign in after account creation. This can only be set to False using the multi-account upload process.

Error Messages

After the upload process is complete and the results are downloaded, the ‘message’ column will display an error message if the account creation failed. One message will be returned per user row, for example:

Status	Example “Message” (one per row)	Message Notes

Status	Example “Message” (one per row)	Message Notes
Success	Successfully added user	User created
Failure	A user already exists with email (example): winnie@test.com	Change the email or ask the student to recover their account based on that email.
Failure	Multiple users match on (firstname, lastname, date-of-birth), please contact support.	Contact support
Failure	A user already exists for the given firstname, lastname, date-of-birth, please contact support.	Contact support
Failure	`errorCode:missing.value,field:address.postal_code`	Fill in the postal code field
Failure	Invalid number of columns found!	The number of columns of filled out data is incorrect. Usually this is the result of having a blank row at the end of the file. Or it could be due to using an out-of-date template.
Failure	A user already exists with username: hpotter12345	Change the email since the email is used as the username. If not, probably best to contact support.Note: Username field is scheduled to be deprecated from account creation tool process in upcoming Spring 2024 release.

OpenCCC Administrator User Guide