Schema Changes Version 2017R02

 

The following table lists changes made to the MoversSuite database for this release.

 

Table

Change

LaborType

Added IsSystemType. New administrative setting that controls whether the description associated to a Labor Type Setup records can be changed (System Type) or not. This flag appears as a read-only flag titled Is System Type within Labor Type Setup. (6742)

MobileSetup

Added FuturePunchSeconds. This field stores the value entered for the Allowed Future Punch Time (in seconds) field within Mobile Api Setup. This is the time allowed that a MoversSuiteCrew Mobile Application user can enter a time to punch into a future service, based on service time assigned to the service. The system defaults this setting to 300 seconds (or five minutes). This setting allows for a gap in time between the user’s mobile device and the time of the service. (8511)

MobileCrewTime

New table storing the crew time information for a MoversSuiteCrew Mobile Application user. This data includes service identifier, start and stop times, whether the service was approved and any comments made. (8511)

MobileCrewTimeActivity

New administrative table storing the values available for assignment to activities associated to a MoversSuiteCrew Mobile Application user for their crew time activities. The options are defined within the Crew Activity Setup. (8511)

MobileCrewTimeAudit

New table storing the information regarding the inspection or modification of the crew time associated to a MoversSuiteCrew Mobile Application user. (8511)

MobileCrewTimeLastPunch

New table storing the information of when a MoversSuiteCrew Mobile Application user last punched into a crew time. (8511)

 

View MoversSuite Database Tables (2017R02)