...
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 the 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 the IDme Workflow Status for values. | Yes |
Current IDme Opt-In Status Change Timestamp | current_idme_workflow_status_optinchange_timestamp | Indicates the student’s current IDme Opt-In Timestamp at the date/time that date and time of the most recent change made to the student’s IDme Workflow Status at the time the report is run or an IDme workflow status change is setmade. | date time | 16 | See the IDme Workflow Status for values. | Yes |
Current IDme Confirmation Opt-In Timestamp | current_idme_confirmationoptin_timestamp | Indicates the student’s IDme Confirmation timestamp 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 Workflow Status Change Confirmation Timestamp | current_idme_workflow_status_changeconfirmation_timestamp | Indicates the date and time of the most recent change made to the student’s IDme Workflow StatusConfirmation timestamp at the date/time that the report is run or an IDme workflow status change is madeset. | date time | 16See the IDme Workflow Status for values. | Yes |
Events Table Fields & Payload Data (Superglue)
...