ID Verification Data Fields

The purpose of this Identification Verification data crosswalk is to provide colleges with data element definitions and values to interpret the ID Verification options and status change notification vehicles.

On this page:

1 About ID Verification Status
2 ID Verification Data Fields
3 ID Verification Status Change Report Data
4 Events Table Fields & Payload Data (SuperGlue)

About ID Verification Status

The processes available to students to verify their identity as they enter the California Community Colleges system are presented to new students following the OpenCCC Account creation process and before they submit a CCCApply application. Completing the verification process at account creation is strongly encouraged; however, students are able to decline the process at this point and return to complete the process at any time. In addition to completing the process, a student’s verification status could change over time or based on specific changes made to their OpenCCC Account Profile. For a complete breakdown of the different status changes:

For students verified with ID.me: see Verification Status Changes in the ID.me Identity Verification Integration document
For students verified with DMV Wallet: see Verification Status Changes in the DMV Wallet Verification Integration document.

To keep colleges informed of student verification status changes, event-driven notifications are delivered to colleges in a new Events table via SuperGlue, and/or colleges may request a daily or weekly report detailing change information configured to their college MIS code. Both of these formats deliver the same change notifications using different variations of the same primary data fields.

ID Verification Data Fields

Below are the data fields that are collected during the ID verification processes by users and passed to the college with the student’s CCCApply submitted application data.

Fields with ID.me in the title or field name only apply to students who verified through ID.me. The other fields, such as verification_optin_timestamp, will hold data for students who verify with DMV Wallet, and in the future, it will also hold ID.me data so that the ID.me-specific fields can be deprecated.

Data Dictionary Name	Data Field Name	Description

Data Dictionary Name	Data Field Name	Description
ID.me Opt-in Timestamp	`idme_optin_timestamp`	Indicates the date and time that the student opted in to the ID.me verification process.
ID.me Confirmation Timestamp	`idme_confirmation_timestamp`	Indicates the date and time that the student’s identity is successfully verified by the ID.me vendor.
ID.me Workflow Status	`idme_workflow_status`	Indicates the current status of the student's ID.me identity verification.
Verification Opt-In Timestamp	`verification_optin_timestamp`	Indicates the date and time that the student opted in to a verification process.
Verification Confirmation Timestamp	`verification_confirmation_timestamp`	Indicates the date and time that the student’s identity is successfully verified by an identity vendor.
Verification Workflow Status	`verification_workflow_status`	Indicates the current status of the student's identity verification.
Verification Source Identity	`verification_source_identity`	Indicates the source vendor for identity verification. Currently the options are ID.me (`idme`) or DMV (`dmv`).

The ID Workflow Status Field Values

The ID Verification Workflow Status fields indicate the student’s identity (verification) status at the time the student’s CCCApply Application is submitted. The field values are shown below:

Value	Definition
`blank/null`	The student has never verified their identity through an CCC identity verification vendor. (Blank/Null would only appear in the `previous_idme_status` or `prev_verification_workflow_status` field in the Events table.)
`verified`	The student’s identity was successfully Verified by a vendor and is current.
`staff_verified`	The student’s identity was verified by a college staff member at the time the student’s OpenCCC account was created.
`unverified`	The student’s identity was previously verified but has become Unverified due to a change made in the student’s OpenCCC account profile.
`expired`	One year (365 days) has elapsed since the student’s previous Verified or Staff Verified status.

More About ID Verification Workflows & Status Changes

Which Status Change Notification Format?

When a change occurs that affects a student’s identity verification status, the college can be notified via two different formats: 1) ID Verification Status Change Report and 2) direct delivery via SuperGlue to the Events Table. Regardless of the method, the status field values are the same.

When a student’s identity status changes, it is reported in these places:

Report Type

Field that gets updated

Field which shows the student’s previous verification status

Status Change Report

current_idme_workflow_status *

latest_app_idme_workflow_status*

Superglue Events Table

idme_status*

verification_workflow_status

prev_idme_status*

prev_verification_workflow_status

*ID.me verifications only, DMV Wallet verifications will be added to the Status Change Report in a future release.

ID Verification Status Change Report Data

The Identity Verification Status Change Report provides status change notifications in a user-friendly report format geared for college staff such as Admissions & Records and Financial Aid officers. The report will include rows/instances where an student’s verification status has changed in relation to the student’s CCCID and their last application submitted. Applications submitted where the Workflow Status is null (blank) are not included in the report. Only valid workflow changes will be included in the report.

Students who verify with ID.me will have slightly different data sets than students who verify with DMV Wallet.

See More:

Data Dictionary Name	Field Name	Description	Type	Max Length	Field Values	Allows Null

Data Dictionary Name	Field Name	Description	Type	Max Length	Field Values	Allows Null
College MIS Code	`mis_code`	The CCCCO MIS identification code for the California Community College.	text	3	3-digit code	No
California Community College ID (CCCID)	`ccc_id`	The unique identifier for a single California Community College student.	text	8		No
Latest Application ID	`latest_app_id`	The Application ID `app_id` of the latest (most recent) CCCApply application submitted to the college.	number	16		No
Latest Application Submit Timestamp	`latest_app_tstmp_submit`	The date and time of the latest (most recent) CCCApply application submitted to the college.	date time	16		No
Latest Application Status	ID.me: `latest_app_idme_workflow_status` DMV Wallet: `latest_app_verification_workflow_status`	Indicates the Workflow Status at the date and time of the student’s latest (most recently) submitted CCCApply application to the college.	text	16	See the Verification Workflow Status for values.	Yes
Latest Application ID.me Opt-In Timestamp	ID.me: `latest_app_idme_optin_timestamp` DMV Wallet: `latest_app_verification_optin_status`	Indicates the Opt-In Timestamp (date and time) of the student’s latest (most recent) submitted CCCApply application submitted to the college.	date time	16		Yes
Latest Application IDme Confirmation Timestamp	ID.me: `latest_app_idme_confirmation_timestamp` DMV Wallet: `latest_app_verification_status`	Indicates the Confirmation Timestamp (date and time) of the student’s latest (most recent) submitted CCCApply application to the college.	date time	16		Yes
Current IDme Status	ID.me:`current_idme_workflow_status` DMV Wallet: `current_verification_workflow_status`	Indicates the student’s current Workflow Status at the date/time the report is run or an ID.me workflow status change is set.	date time	16	See the ID.me Workflow Status for values.	Yes
Current IDme Status Change Timestamp	ID.me:`current_idme_workflow_status_change_timestamp` DMV Wallet: `current_verification_workflow_status_change_timestamp`	Indicates the date and time of the most recent change made to the student’s Verification Workflow Status at the time the report is run or status change is made.	date time	16	See the ID.me Workflow Status for values.	Yes
Current IDme Opt-In Timestamp	ID.me:`current_idme_optin_timestamp` DMV Wallet: `current_verification_optin_timestamp`	Indicates the student’s current Verification Opt-In Timestamp at the date/time that the report is run or a workflow status change is set. *Displays on the report upon request.	date time	16		Yes
Current IDme Confirmation Timestamp	ID.me:`current_idme_confirmation_timestamp` DMV Wallet: `current_verification_confirmation_timestamp`	Indicates the student’s confirmation timestamp at the date/time that the report is run or an ID.me workflow status change is set. *Displays on the report upon request.	date time	16		Yes

Events Table Fields & Payload Data (SuperGlue)

The Events table receives change notifications in a staging table or directly to your college SIS system. These are the same ID.me (verification) workflow status changes that occur post application submission or when a student makes a change to their account profile that changes their identity verification.

Despite the optional eventType values of ‘UPDATE_PROFILE’ and ‘FEDERATED_IDENTITY_LINK’, CCCTC systems will solely deliver this event payload to college staging tables if or when the previous_idme_status field contains a different value from the idme_status current value. It is theoretically possible that a student modifies the first name (or other field) in such a way that does not change their verification status. In that case, no event would be sent to the college.

See the Events Table document complete details on the Events Table fields and payload data.

Table: Events

Table Field Name	Data Dictionary Name	Field Name	Description	Type	Length	Field Values	Allows Null

Table Field Name	Data Dictionary Name	Field Name	Description	Type	Length	Field Values	Allows Null
Event ID	Event ID	`eventId`	The unique id of an event.	Text	32		No
Event Payload Fields
Event Payload	Event Payload	`eventPayload`	The Json Payload containing various fields based on the Event Type	Text	2000		No
	CCCID	`cccid`	The unique California Community Colleges identifier for the user.	String	9		No
	First Name	`firstName`	The updated first name of the user.	String	100		Yes
	Previous First Name	`previous_firstName`	The previous first name of the user, if applicable.	String	100		Yes
	Last Name	`lastName`	The updated last name of the user.	String	100		Yes
	Previous Last Name	`previous_lastName`	The previous last name of the user, if applicable.	String	100		Yes
	Email	`email`	The updated email address for the user.	String	256		Yes
	Previous Email	`previous_email`	The previous email address for the user, if applicable.	String	256		Yes
	Verification Status	ID.me: `idme_status` DMV Wallet: `verification_workflow_status`	The current status of the user's ID verification.	String	50	Verified Unverified Expired	No
	Previous Verification Status	ID.me: `previous_idme_status` DMV Wallet: `prev_workflow_status`	The previous status of the user’s ID verification, if applicable.	String	50	Blank/Null Verified Unverified Expired	Yes
	ID.me Confirmation Timestamp	ID.me: `idme_confirmation_timestamp` DMV Wallet: `verification_confirmation_timestamp`	Date with UTC time the user’s current ID verification was confirmed, if applicable.	Date with UTC Time			Yes
Event Type	Event Type	`eventType`	The coded identifying name used to identify the schema of the Event Payload.	Text