EditLog

tblEditLog contains log of entries that alter the database.

DateTime, timestamp for time of entry SFuserID, integer, 2 bytes, identifier for species file signon that did the edit, special values -1 for a service pack, -2 for an editor from the software website SFSuserID, integer, 2 bytes, identifer for Species File Software signon that did the edit (except special codes for certain administrative procedures) -3 = change from a different species file (from species file merging process) -2 = change from the Species File Software website -1 = change from a service pack UnitName, text, 100 bytes maximum, program unit that generated the entry Description, text, 400 bytes maximum, description of change WhereClause, text, 200 bytes maximum, information used in the where clause of a SQL query DataSpecs, text, 400 bytes maximum, a listing of the data specifications as they appear in OldData and NewData OldData, text, 8000 bytes maximum, previously recorded data NewData, text, 8000 bytes maximum, newly recorded data