TrackerActionLog

Name: Tracker Action Log

Type: Ancillary

Modules: Reporting

Description: Hold all actions performed by a logged-in user based on defined tracker actions.

Field Documentation
TrackAction Value representing the type of action being logged (from the TrackerActions table).
TrackCode Value of the tracker code used when the action was logged (from the TrackerActions table).
ActionDate Date the log entry was added.
ActionTime Time the action was logged. Value is in seconds from midnight.
TraceTime Full military time of when the message was created. It may be different than the ActionTime if the action was performed by a user, an application, etc.
LoginName Entity name (e.g., user, application, device) that added the log entry.
UserDomain Name and location of the entity that created the log entry (e.g., TOR-CC1713/SCHSRV).
TrackComment Hard-coded comment string about the log entry (e.g., Out:From U to S on P14, MDT AutoSend Manager).
TrackParameters List of parameter values pasted to a method that is tracked (e.g., Auto or batch scheduling calls the SchEvent method and passes ClientID, ReqTime, etc.).
BookingId Numeric identifier of the booking that the log entry is about (from the Bookings table).
ClientId Numeric identifier of the client that the log entry is about (from the Clients table).
SchId Numeric identifier of the schedule date of the booking that the entry is about (from the Schedules table).
EvId Numeric identifier of the event that the log entry is about (from the Events table).
EvStrId Internal numeric identifier of the live run that the event is on (from the EventStrings table).
StopId Numeric identifier of the stop that the log entry is about (from the Stops table).
ClientLocationProgId Numeric identifier of the client location program that the log entry is about (from the ClientLocationProgram table).
EmployeeId Numeric identifier of the employee that the log entry is about (from the Employess table).