Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

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

  • No labels