New Tables and Fields
The following are new tables and fields added to MMS version 19 database.
New tables added to MMS v19 database
| Product | Table |
|---|---|
| CORE | CoreLicenseInfo |
| OPS | OPSAccrualAdjustments OPSAccrualAdjustmentTypes OPSBidHistoryEmployeeStatus OPSBkBidBid OPSBkBidBidPeriods OPSBkBidDayOffQuota OPSBkBidDivisions2Units OPSBkBidEmployees OPSBkBidEmployeeStatus OPSBkBidHolidays OPSBkBidLine OPSBkBidLineWork OPSBkBidPeriodDates OPSBkBidPeriods OPSBkBidQuotaUsed OPSBkBidRosterScenarios OPSBKBidUnitList OPSBkBinaryContents OPSBKExtraWork OPSBkGroupFiles OPSBKManualMasterRoster OPSBKManualRoster OPSBkMemoValues OPSBKRosterScenarios OPSTrainingCategories OPSTrainingClasses OPSTrainingClassStudents OPSTrainingCourses OPSTrainingLessons OPSTrainingLessonStudents OPSTrainingResults OPSTrainingTemplates OPSDisplayBoardConfig OPSEmployeeDayType OPSEmployeeSecurity OPSBatchConfig OPSBatchJobs OPSRecipientMemoTypes OPSRecipients |
| PASS | ClientDataControlSystem DriverTripComments ParaServiceAreaPassTypeRules ParaServiceAreaRuleParameters ProviderCostValidity |
| PLAN | RidTripsRpt |
New fields added to tables in MMS v19 database
| Table | Field |
|---|---|
| CoreAudit | DbSessionId |
| CoreIdentity | MobilePhoneNumber PasswordExpires |
| Table | Field |
|---|---|
| AbsenceTypes | FutureRequestThresholdMin FutureRequestThresholdMax |
| OPSHolidays | HolidayIdSrc |
| OPSDailyActivityTypes | InstructorActivity |
| OpsAccrualRules | RefDateExclude |
| BidUnits | SharedWorkDivisionGroup |
| OPSSIT | WorkSignOnAllowed SITAutoAssignVehicle SITAutoAssignVehicleOption |
| Table | Field |
|---|---|
| ClientParaServices | AccessPoint |
| ParaService | LogoImage InActive AccessPoint |
| ClientAutoTopup | DailyFailures ConsecutiveFailingDays LastFailingDate |
| ProviderContract | ContractParameters |
| ProviderBookingCost | FromTime FromDistance |
| Clients | IsIVRDisabled |
| RTVsets | IsShared |
| Booking | MaxObtDirectTravelTime |
| PassServiceAreaRules | PassTypeRulesApply |
| ClientAccountTransaction | paymentId |
| EWalletPassTransaction | paymentId |
| PassCardTransDetail | paymentId |
| PaymentTypes | RefundCalcRule RefundValue InActive |
| Locations | ResourceSite |
| ActiveLanguages | Rfc5646Tag |
| Table | Field |
|---|---|
| BusTypes | BusTypeLetter |
| FxBlockScenarios | Favorite |
| Table | Field |
|---|---|
| NotificationsForPASS | LastTriggered NotificationGroupId |