tbl1_sync_log

Description

This table has a log of when the Solutions sync with CSS was performed. It is viewable in the Solutions Control Center “css sync” log tab

Relation

one-to-many relation with tbl1_sync_messages where tbl1_sync_log.id = tbl1_sync_messages.sync_id

Columns

id int(8) NOT NULL

Options

display="true", null="true", search="false", type=""

the_semester varchar(45) DEFAULT NULL

Description

Fall, Spring or Summer

Options

display="true", null="true", search="false", type=""

the_year int(8) DEFAULT NULL

Description

semester year

Options

display="true", null="true", search="false", type=""

sync_notes varchar(255) DEFAULT NULL

Description

notes (is this used?)

Options

display="true", null="true", search="false", type=""

last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

display="true", null="true", search="false", type=""

num_changes_flagged int(8) DEFAULT 0

Description

Number of discrepancies detected and reported in sync report

Options

display="true", null="true", search="false", type=""

sync_timestamp datetime DEFAULT NULL

Options

display="true", null="true", search="false", type=""