/
MyPath Data Element Dictionary
MyPath Data Element Dictionary
- Patricia Donohue
Owned by Patricia Donohue
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 |
|
, multiple selections available,
Related content
Data Dictionaries
Data Dictionaries
Read with this
Release 2024.CCCData.2.7.0
Release 2024.CCCData.2.7.0
More like this
Data Warehouse Report Server User Guide
Data Warehouse Report Server User Guide
Read with this
Accessing In-Progress Application Data in the CCC Data Warehouse
Accessing In-Progress Application Data in the CCC Data Warehouse
More like this