tbl1_sync_messages¶
- Description
Messages generated from Solutions sync with CSS for discrepancies found
- Relation
many-to-one relation with tbl1_sync_log where tbl1_sync_log.id = tbl1_sync_messages.sync_id
Columns¶
id int(8) NOT NULL
- Options
display="true", null="true", search="false", type=""
sync_id int(8) NOT NULL
- Description
sync id
- Relation
relates to tbl1_sync_log.id
- Options
display="true", null="true", search="false", type=""
change_type int(8) NOT NULL
- Description
a code indicating type of change that was detected
- Footnote
see solutions mod_declarations for more details
- Options
display="true", null="true", search="false", type=""
before_value varchar(255) DEFAULT NULL
- Description
value in Solutions before a change was automatically made
- Options
display="true", null="true", search="false", type=""
after_value varchar(255) DEFAULT NULL
- Description
value in Solutions after a change was automatically made
- Options
display="true", null="true", search="false", type=""
recommended_action varchar(255) DEFAULT NULL
- Description
Detail on what office staff should do based on the discreapancy found, viewable on sync report
- Options
display="true", null="true", search="false", type=""
action_taken varchar(255) DEFAULT NULL
- Description
summary message of whatever action Solutions automatically performed
- Options
display="true", null="true", search="false", type=""
change_message longtext DEFAULT NULL
- Description
Message logged in tbl1_Schedule_Data change message field
- Options
display="true", null="true", search="false", type=""
unit varchar(5) DEFAULT NULL
- Description
01 or 16
- Options
display="true", null="true", search="false", type=""
subject varchar(15) DEFAULT NULL
- Description
subeject code of course
- Options
display="true", null="true", search="false", type=""
course varchar(15) DEFAULT NULL
- Description
3-digit course code of course
- Options
display="true", null="true", search="false", type=""
index varchar(45) DEFAULT NULL
- Description
5-digit course index number
- Options
display="true", null="true", search="false", type=""
mode varchar(45) DEFAULT NULL
- Description
meeting mode of course row (L for lecture, etc)
- Options
display="true", null="true", search="false", type=""
section varchar(45) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Description
section number
- Options
display="true", null="true", search="false", type=""