MyPath Data Element Dictionary
Data from MyPath is available in the CCC Data Warehouse. MyPath data is segmented by MIS code to assure that colleges may access data associated with their college, while districts may access data associated with their colleges.
- 1 reminder2statustime
- 2 reminder3status
- 3 miscode
- 4 reminder3statustime
- 5 reminder1status
- 6 reminder1statustime
- 7 completed_timestamp
- 8 reminder2status
- 9 state
- 10 timestamp
- 11 username
- 12 createdby
- 13 miscode
- 14 card_title
- 15 task_title
- 16 card_order
- 17 task_order
- 18 has_reminder
- 19 event_type
- 20 miscode
- 21 created_timestamp
- 22 originator
- 23 target
MyPath Data Tables
MyPath data consists of the following tables:
Advisor card reminder data
Advisor usage data
Audit table
Advisor Card Reminder Fields
Table: advisorcard_reminders
Data Field | Type | Length |
|---|---|---|
id | bigint |
|
reminder2statustime | TIMESTAMP |
|
reminder3status | VARCHAR |
|
miscode | VARCHAR |
|
reminder3statustime | TIMESTAMP |
|
reminder1status | VARCHAR |
|
reminder1statustime | TIMESTAMP |
|
completed_timestamp | TIMESTAMP |
|
reminder2status | VARCHAR |
|
Advisor Card Usage Data Fields
Table: advisorcard_usage
Data Field | Type | Length |
|---|---|---|
id | bigint |
|
state | VARCHAR |
|
timestamp | TIMESTAMP |
|
username | VARCHAR |
|
createdby | VARCHAR |
|
miscode | VARCHAR |
|
card_title | VARCHAR |
|
task_title | VARCHAR |
|
card_order | INTEGER |
|
task_order | INTEGER |
|
has_reminder | BOOLEAN |
|
Audit Data Fields
Table: audit
Data Field | Type | Length |
|---|---|---|
event_type | varchar |
|
miscode | varchar |
|
created_timestamp | timestamp |
|
originator | varchar |
|
target | varchar |
|