Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColor#F4F5F7

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.

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

id

bigint

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