...
IDme verification status change data fields that have been created specifically for tracking status changes (via the reports and Superglue data delivery currently under-development) are documented and published in the CCCApply Public Documentation space. listed below.
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 | 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 | latest_app_idme_workflow_status | Indicates the IDme Workflow Status at the date and time of the student’s latest (most recently) submitted CCCApply application to the college. | text | 16 | See IDme Workflow Status for values. | Yes |
Latest Application | latest_app_idme_optin_timestamp | Indicates the IDme 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 | latest_app_idme_confirmation_timestamp | Indicates the IDme Confirmation Timestamp (date and time) of the student’s latest (most recent) submitted CCCApply application to the college. | date time | 16 | Yes | |
Current IDme Workflow Status | current_idme_workflow_status | Indicates the student’s current IDme Workflow Status at the date/time the report is run or an IDme workflow status change is set. | date time | 16 | See IDme Workflow Status for values | Yes |
Current IDme Opt-In Timestamp | current_idme_optin_timestamp | Indicates the student’s current IDme Opt-In Timestamp at the date/time that the report is run or an IDme workflow status change is set. | date time | 16 | Yes | |
Current IDme Confirmation Timestamp | current_idme_confirmation_timestamp | Indicates the student’s IDme Confirmation timestamp at the date/time that the report is run or an IDme workflow status change is set. | date time | 16 | Yes | |
Current IDme Workflow Status Change Timestamp | current_idme_workflow_status_change_timestamp | Indicates the date and time of the most recent change made to the student’s IDme Workflow Status at the time the report is run or status change is made. | date time | 16 | See IDme Workflow Status for values | Yes |
...