Versions Compared

Old Version 1

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version Current

changes.mady.by.user Patricia Donohue

Saved on

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.

Table of Contents
minLevel3
maxLevel3
outlinefalse
stylesquare
typelist
printablefalse

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

Table of Contents
minLevel2
maxLevel2
outlinefalse
styledefault
typelist
printablefalse