ccc_id

cccId

The user’s unique CCCID for Federated Identity.

The unique identifier for a single user’s account. This identifier is assigned during account creation in OpenCCC.

VarChar 8

The format of the ccc_id is:

Positions 1 - 3:   AAA thru ZZZ (Sequentially assigned beginning with AAA)

Positions 4 – 7:  0001 thru 9999 (Sequentially assigned beginning with 0001 for each value in positions 1-3)

Position 8:  For future expansion if all values become exhausted.

Note:  In positions 1-3, “I” and “O” are not used to avoid confusion with “0” and “1”.

No.  This is a system assigned field and is not entered by the user.

System assigned.

Populates the CCCApply applications from the applicant's OpenCCC Account at the time of submission.

System-generated unique identifier.

System will support expansion of CCCID to 8 characters (XXXXNNNN).

This field is passed as part of a submitted application to each college and is stored in the college Student Information System (SIS).  This field can be used for student authentication when a student signs in at a college.  It can be passed as an attribute to student statewide services so the service can verify the student has an OpenCCC account and perform automatic sign in.  This field will also be passed as an MIS field. 

accepted_terms

acceptedTerms

Acknowledgment by the user of acceptance of the OpenCCC student account Terms of Use.

Boolean

True / False

If email address is verified during account creation, then display the terms disclaimer that pertains to contact by email.

If mobile phone is verified during account creation, then display the terms disclaimer that pertains to contact by phone and/or text message.

No

Default = True

Stored with date and timestamp in database at time of account creation.

Required response; else error message, ”You must agree to the Terms of Use.”
ES: “Debe aceptar los Términos de uso.”

Acknowledge Terms of Use

[ checkbox ] (Email): “I agree to the Terms of Use and to receive emails at any email address I have provided or may provide in the future, from any entity associated with my application process, including but not limited to my designated schools and programs.”

(Phone): “I agree to the Terms of Use and to receive calls and/or texts and emails at any phone number and/or email I have provided or may provide in the future, including any wireless number, from any entity associated with my application process, including but not limited to my designated schools and programs.”

Terms of Use

DELIVERED via SuperGlue for Apply.

accepted_terms_timestamp

acceptedTermsTimestamp

Date and time of user’s acceptance of the Terms of Use.

date timestamp with time zone

 No

Stored with <accepted_terms> at time of account creation.  SuperGlue delivery only.

DELIVERED via SuperGlue for Apply.

address_validation_override

addressValidationOverride

Indicates that the USPS address validation service. does not recognize the address as provided by the user and has suggested an alternative to the user.

VarChar 20

True / False

Yes

If no suggested address is returned by the USPS address validation service, a null value is stored.

Address override is stored as True or False.

IF user accepts a USPS “suggested address” displayed, then <addressValidationOverride> is stored as True; otherwise it is stored as False.

If USPS address validation returns a notice of Invalid address, then user must override the response (True) or return to the address fields and edit their entry (False).

Invalid Address message box:
“We are unable to validate your address with the USPS Postal Service. Please review the address below and review or edit.”
[Button] “I verify my address”
[Button] “Edit my address”

Verify Address message box:
”To ensure an accurate address we suggest the one below. Would you like to use the suggested address?”
[Button] “Yes”
[Button] “No”

For a Suggested Address: “To ensure an accurate address we suggest the one below. Would you like to use the suggested address?”

After all required address fields have been entered in the Contact Information section of the Account Profile, the USPS address verification service is run to check if the address exists, and whether the address meets USPS address standards.

Indicates that the user has accepted an address alternative provided by the USPS address validation service does not recognize the address as provided by the user and has suggested an alternative to the user.

DELIVERED via SuperGlue for Apply.

address_validation_override_timestamp

addressValidationOverrideTimestamp

Date and time that the user chose to override a suggested address that meets USPS format, or s of the address validation override.

date and time with time zone

 Stored with <address_validation_override> at time of account creation. SuperGlue delivery only.

Yes

DELIVERED via SuperGlue for Apply.

birthdate

birthdate

User’s date of birth.

date, 10

Provided in this format: yyyy-mm-dd

Valid date

No

None

Storage: Stored in database (with leading zeros as appropriate) for use in auto-population. Included in Account Profile.

Usage: Birthdate is used in the admission application to calculate age, to identify applicants who are too young to transact business online per COPPA (Child Online Privacy Protection Act —under age 13), and to identify minors for residency calculation and collection of parent or guardian contact information. OCR acknowledges that collection of birth date is allowed under California State law.

For residency and minor identification, the applicant’s age is calculated as of the day before the term_start date <ResidencyDeterminationDate>.

Used for residency and minor identification, the applicant’s age is calculated as of the day before term_start date <ResidencyDeterminationDate>.

Date of birth is required; else error message, “Valid date of birth is required.”

Confirm date of birth is required; else error message, “Valid Confirm Date of Birth is required.”

Both entries must match exactly; else error message, “Date of Birth entries do not match.”
(ES: “Las entradas de la fecha de nacimiento no coinciden.”)

Must be a valid date (‘dd’ must be appropriate for ‘mm’ and ‘yyyy’, for example, 02/29/2009 would not be a valid date); else error message, “Invalid date. Please enter the date in the format MM/DD/YYYY.”

Date must be after 01/01/1901; else error message, “Must be on or after 01/01/1901.”

Date must be before <current_date>; else error message, “Must be before <current_date>.”

Must not edit or update birthdate and full legal name at the same time; else error message, “Do not update your name (first, middle or last) and birth date at the same time.”
ES: “No actualice su Nombre (primer, segundo o apellido) y fecha de naciemiento a la mismo tiempo.”

“Please enter your birth date”.

Date of Birth* [textbox + calendar widget]
(ES: “Fecha de Nacimiento”)

Confirm Date of Birth* [textbox + calendar widget]
(ES: “Confirmar fecha de nacimiento”)

MIS DED SB03

Birthdate is sensitive information protected by federal law and the Office of Civil Rights (with regards to age discrimination). Any change to the text, prompt, access, or transmission of this data item must be approved by the Legal Counsel of the CCC Chancellor’s Office and the Office of Civil Rights.

Date of birth information may not be provided to staff in the capacity of making a decision to admit an applicant until after the applicant is admitted—that is, uniformly enabled to register for classes.

Users cannot change their legal name and date of birth at the same time to ensure two or more users cannot share an account (prevent duplicate accounts).

OCR acknowledges that collection of date of birth is allowed under California State law.

email

User’s email address.

Character varying, 254

Two fields; each up to 254 characters, alphanumeric plus ‘@’ and ‘.’

Text string in valid email address format.

No

No

Used in account creation as a method to verify identity. Can be set as the user’s preferred method of contact by the California Community Colleges or an authorized partner.

Only one field is stored in database. Included in Edit Account Profile.

Must contain one ‘@’ symbol and one “.” (the “@” symbol cannot be the first character).

Required user response. Must be unique.
Email address and Confirm Email inputs must be identical and must meet validation checks; else error message, “Your Email Address is invalid or absent. You must enter a valid Email Address”.

Create Account:

Required response else error message: “Email address is required.”
(ES: “Se requiere Correo Electrónico.”)

Must meet validation check; else error message,“Please enter a valid email address.” (ES: “Por favor, introduzca una dirección de correo electrónico válida.”)

Must be unique; else error message: “Your email address is already in use. Please enter a different Email Address.”

Sign In:

Required response unless phone number is entered; else error message, “Email or mobile phone required.” (ES: Se requiere correo electrónico o teléfono móvil.)

Must meet validation check; else error message, “Your mobile number, email or password is not recognized by our system. Need Help? Contact Support”
ES: “Nuestro sistema no reconoce su número de teléfono móvil, correo electrónico o contraseña.”

Legacy User Sign In:

Email address must be unique and meet format validation checks; else error message, “Your Email address is already in use. Please enter a different Email address, or contact a support representative.”

Create & Verify Account:

Email [textbox]

Create Account (Contact Information):

Email Address [textbox]

Confirm Email Address [textbox]

Sign In: Email or mobile phone* [textbox]

”Enter your email address to begin creating your California Community Colleges student account. You will receive a code via email to verify your identity and keep your account secure.

ES: “Entra tu dirección de correo electrónico para comenzar a crear su cuenta. Recibirás un código a través de correo electrónico para verificar su identidad y mantener su cuenta segura.”

A valid email address is required from each user and must be unique.

If the email address is verified during account creation, the system will pre-populate the <email> field in the Contact Information section and it doesn’t need to be entered again in Confirm Email). The pre-populated field will be disabled to prevent edits until the account creation process is complete.

Edits or changes to Email Address must go through verification process again.

If a mobile phone is verified during account creation, the user is required to enter their Email address on the Contact Information page; else error message, “Your Email Address is invalid or absent. You must enter a valid Email Address.”

DELIVERED via SuperGlue for Apply.

email_verified

emailVerified

Indicates that a valid email address has been verified with security code.

Boolean

True / False

Value stored in Account database with timestamp.

Email verified

ES: Correo Electrónico ha sido Verificado

If email address has been verified, an asterisk is displayed on the Email field label in the user’s Account Profile.

At least one method of contact must be verified.

DELIVERED via SuperGlue for Apply.

email_verified_timestamp

emailVerifiedTimestamp

Date and time of the verification of user’s email address.

date timestamp with time zone

Stored with <email_verified> at time of account creation.

DELIVERED via SuperGlue for Apply.

ssn

ssn

Applicant’s Social Security number or Taxpayer Identification Number.

text, 2147483647

Two fields; each 11 characters, numeric plus: format nnn-nn-nnnn Hyphens are not required in input but will be inserted in stored value.

Null or numeric string with hyphens. Encrypted

Yes. If applicant selects the check box indicating they do not have a social security number or taxpayer identification number or decline to provide one, then the ssn field stores null.

None

Only one field is stored in database

Required user response IF <ssn_no> = “Yes, I have a Social Security number or Taxpayer Identification number”, else error message, “You must provide your social security number or taxpayer identification number, or select the option indicating you don’t have a social security number or taxpayer identification number, or you decline to provide one at this time.”

Two SSN/TIN entries must match; else error message, “Your social security number or taxpayer identification number entries do not match.  Please try again.”