New Tables and Fields

The following are new tables and fields added to MMSData version 21.

New MMSData v21 Database Tables

Product Table
CORE
  • CoreMobileGateway
OPS
  • OPSBannedPassengers
  • OPSBidWork
  • OPSClientPayroll
  • OPSClientPayrollImport
  • OPSDocuments
  • OPSDocumentTypes
  • OPSEmployeePicture
  • OPSEmployeeRotationRules
  • OPSEmployeesSecurity
  • OPSLineStopLabel
  • OPSOpVacationReliefConfig
  • OPSNodes
  • OPSPerformanceAckReasons
  • OPSTimeComponentDefaults
  • OPSTravels
  • VRPackage
  • VRPackageDetail
  • OpsPerfectAttendanceDetails
  • OpsSafteFastResponse
  • OPSSITLog
PASS
  • ClientAccountTransactionDetail
  • ClientTCLog
  • ContactRules
  • FerryLine
  • FerryTripTimes
  • FuelType
  • MdtGenMsg
  • MdtGroup
  • MdtIgnorePendingSchedules
  • MdtTripInfo
  • MdtVehStatus
  • PassClientSession_ACT
  • PassPaymentMonitorLog
  • PassUuidLinks
  • PaymentMethods
  • ProviderActivityCost
  • ProviderMobAidCost
  • ProviderPeriod
  • ProviderRateProfile
  • ProviderSegmentCost
  • ProviderTourCost
  • ProviderTripCost
  • ProviderTripsQuota
  • RTVSharedSets
  • ServiceLine
  • ServiceLineJourney
  • ServiceLineJourneyDetail
  • ServiceLineJourneyLinePara
  • ServiceLineJourneyParam
  • ServiceLineJourneyPolyPara
  • ServiceLineJourneyStop
  • ServiceLineMandatoryType
  • ServiceLineNetList
  • ServiceLinePattern
  • ServiceLinePatternExcept
  • ServiceLineRunRes
  • ServiceLineStopTime
  • ServiceParameters
  • ServiceParameterVariation
  • ServiceParameterZones

New MMSData v21 Database Fields

Table 1. CORE
Table Field
CoreIdentity MobilePhoneNumber
CoreIdentity MobileCarrierId
CoreIdentity PasswordExpires
CoreIdentity VerificationCode
CoreIdentity VerificationCodeTimestamp
CoreIdentity VerificationCodeCount
CoreIdentity VerificationSuccessTimestamp
Table 2. OPS
Table Field
AbsenceTypes PostCreationProcess
AbsenceTypes AccrualHierarchyList
AncillaryGroupDetail Dependant2
BidEmployees BidRqFromDateSecondPass
BidEmployees BidRqFromTimeSecondPass
BidEmployees BidRqToDateSecondPass
BidEmployees BidRqToTimeSecondPass
EmployeeImport NextPhysicalDate
EmployeeReview Status
Employees HashedPinNumber
Employees IdentityName
ExtraPayTypes RequireApproval
OPSAbsenceRequests AccrualHierarchyId
OPSBiddingDates PassNumber
OPSBidHistoryRelief BidId
OPSBidHistoryRelief DivisionId
OPSBidHistoryRelief QuotaListId
OPSBulletins ReferenceSource
OPSBulletins ReferenceID
OpsConsists BusTypeId
OpsCustomAssignmentTypes ListType
OPSDailyRelief DivisionId
OpsEmployeeBanking MaxTime
OPSMasterRun FinishTime
OPSMasterRun PrepTime
OPSMasterRun StartStandBy
OPSMasterRun EndStandBy
OPSOpBid DivisionList
OPSOpBidWork AvailableWeek
OPSOpBidWork EmployeeId
OPSPerformanceActions CrossedOut
OPSPerformanceActions CrossedOutReason
OPSPerformanceActions SignatureCollected
OPSPerformanceActions EmpSignTimeStamp
OPSPerformanceActions SupSignTimeStamp
OPSPerformanceActions UnionSignTimeStamp
OPSPerformanceActions UnionCommentsMemoId
OPSPerformanceActions UnionEmployeeId
OPSPerformanceActions Stage
OPSPerformanceActions AcknowledgeReasonId
OPSPerformanceActionTypes AdminActionTypeColor
OPSPublishedWork ReportTime
OPSPublishedWork PrepTime
OPSPublishedWork FinishTime
OPSPublishedWork ClearTime
OPSPublishedWork StartStandBy
OPSPublishedWork EndStandBy
OPSRun PrepTime
OPSRun FinishTime
OPSRun StartStandBy
OPSRun EndStandBy
OpsSignInLog SITReceiptData
OPSSIT isVirtualKiosk
OPSSIT geoFenceLat
OPSSIT geoFenceLon
OPSSIT geoFenceRadius
OPSSIT SITAutoAssignVehicle
OPSSIT SITAutoAssignVehicleOption
OPSTrainingClasses InstructorEmployeeId
OPSTrainingClasses NumberNeeded
OPSTrainingClasses Status
OPSTrainingClassStudents MemoId
OPSTrainingLessons Description
OPSTrainingLessons TrainingLessonId
OPSTrainingLessonStudents TrainingLessonId
OPSTrainingLessonStudents MemoId
OPSTrainingResults Passed
OPSTrips ServiceId
PayCodes DisplayMethod
PayrollCodes DisplayMethod
TKAbsences AccrualHierarchyId
TKAccrualBanking WorkTime
TKExtraEmployees UserLong1
TKExtraEmployees UserLong2
TKExtraEmployees UserLong3
TKExtraPay DecisionStatus
TKExtraPay DecisionDate
TKExtraPay DecisionTime
TKExtraPay EmployeeComments
TKExtraPay SupervisorComments
TKExtraPay DecisionBy
TKExtraWork FinishTime
TKExtraWork PrepTime
TKExtraWork StartStandBy
TKExtraWork EndStandBy
TKExtraWork ReportTime
TKExtraWork ClearTime
TKExtraWork SignOnNodeId
TKExtraWork SignOffNodeId
TKExtraWork StartEventType
TkPayRule PieceOnly
TkWork PrepTime
TkWork FinishTime
TkWork StartStandBy
TkWork EndStandBy
TkWork UserLong5
VolunteerType EnforceFullWeek
WorkSubtype AllowReportTime
WorkSubtype AllowPrepTime
WorkSubtype AllowFinishTime
WorkSubtype AllowTravelTimes
WorkSubtype AllowClearTime
WorkSubtype AllowWaitTimes
WorkSubtype AllowShiftLayover
WorkSubtype AllowMakeupTime
WorkSubtype AllowStandbyTimes
WorkSubtype AllowBreakActTimeShift
WorkSubtype StartShiftingTime
WorkSubtype EndShiftingTime
AncillaryGroupDetail WorkPublishStatus
EmployeeImport PinNumber
OPSPerfectAttendanceMatrix BonusTime
TKDailyVehicleAttributes Colour
TKPay WorkPublishStatus
TkPayAccessory WorkPublishStatus
TKPaySection15 WorkPublishStatus
Table 3. PASS
Table Field
AdaTypes Conditional
Address StopId
Booking FaringInterfaceStatus
BookingExternalTransaction ExternalBookingId

TransactionId

FailureReason
BookingLegs StopId
CancelPrepay PassType
ClientFundingSource UserString1

UserString2

UserString3

UserString4

UserString5

UserLong1

UserLong2
ClientPassTypeRestrictions SpaceType

FareTypeId
Clients EZWalletDisabled
DateIntervals Id
DCESZonalCache VarTimePeriods
Events MultimodalWalking

EstBeginTime

AutoArriveTime

AutoDepartTime
EventsOld MultimodalWalking

EstBeginTime

AutoArriveTime

AutoDepartTime
EWalletPass NotForSale

AdvancePurchase
EWalletPassTransaction ValidFromDate
FareTypes Progressive
FundingSources CreBy

CreTime

CreDate

ModBy

ModTime

ModDate

UserLong1

UserLong2

UserLong3

UserLong4

UserLong5

UserString1

UserString2

UserString3

UserString4

UserString5
InAvl Id
PassCmnOAuthTokens ProfileId
PassCmnTNCTripInfo Message
PassFinancialTransaction TransactionStatus
PassPaymentTypeTransDetail Balance
Providers AllowedSpaceTypes
SchMultiParameters ParaServiceId
TrackerActionLog TrackerActionLogId
Table 4. Fx
Table Field
FxBlockScenarioTrips VehicleBlockNum
FxRuns Layover
MasterLine GTFSExport
Master Service Group GtfsServiceIdSrc
Service GTFSServiceIdSrc
Sign-Up Periods IsFrozen
Travels BonusPayTime

BlockOptimizerTime
Table 5. PLAN
Table Field
RidStopCounts RidFareAmount
RidTrips StopNum
Table 6. INFO
Table Field
InfoTransfers IgnoreTransferDistance
Table 7. COM
Table Field
RegisteredUsers LockedTimeStamp