CallActions - Details of actions  that have been taken been taken on a specific call. Child table of Calls table



ColumnTypeNotes
CK_CallNoTEXTTugger created column combining:
CallNo, CallActionNumber
CallActionNumberWHOLE NUMBER
CallNumberWHOLE NUMBER
EngineerHoursDECIMAL NUMBER
EngineerTEXT
FinishedDateTimeDATETIME
FinishedDateDATETIME
FinishedTimeTIME
HoursOnSiteWHOLE NUMBER
MinutesOnSiteWHOLE NUMBER
StartedDateDATETIME
StartedTimeTIME
TravelTimeTIME
LastEditDateDATETIME
DeletedBINARY