Jump to main content
Expand All
Collapse All
New Tables and Fields
The following are new tables and fields added to MMSData version 21.
About COM Tables
This section provides information for the following tables in COM.
About CORE Tables
This section provides information for the following tables in CORE.
About FX Tables
This section provides information for the following tables in FX.
AccessibilityTypes
Agencies
BbConstraintParameters
BbConstraints
BbParameterGroups
BbParameterList
BbParameters
BbParameterSituations
BbParameterTypes
BbParameterValuesCompressed
BbPersonalParameters
BbRunTypeBusTypes
BbRunTypeCategories
BbRunTypeCategoryValues
BbRunTypeGarages
BbRunTypeLineGroups
BbRunTypeLines
BbRunTypePercentageRules
BbRunTypes
BusTypeParameters
BusTypes
Calendar
ContractRule
DayServiceGroup
Deadheads
DeadheadTrace
DefaultRunExceptions
Divisions
ExceptionCombinations
Exceptions
FxBlockEvents
FxBlockGroups
FxBlockLayovers
FxBlocks
FxDataAccess
FxMasterRoster
FxNodeParameters
FxProcessCategories
FxProcessLog
FxProcessLogEvents
FxPtAttributes
FxPtAttributeValues
FxPtPoints
FxPtTypes
FxPtTypesAttributes
FxRoster
FxRosterScenarios
FxRunExtraPieces
FxRunPieces
FxRunReliefRestrictions
FxRuns
FxRunScenarios
FxTimedConnections
FxTripsScreenConfigCols
FxTripsScreenConfigs
FxUnattendedReliefNodes
FxUserRunScenarios
FxWaysideConfig
Garages
Holidays
InterlineRelationships
Line
LineGroup
LineStop
LineStopLabel
LineTrace
LineTypes
LocationTypes
MasterComments
MasterDivisions
MasterExceptionCombinations
MasterLine
MasterLineGroup
MasterPattern
MasterRoster
MasterRosterCostValue
MasterRosterType
MasterRun
MasterRunCostValue
MasterRunTimes
MasterRunType
MasterServiceGroup
MasterStopClusters
NodeBreaks
Nodes
NodeToNode
NodeToNodeTrace
Pattern
PatternTrace
PeakServiceGroup
ReportTypes
Roster
RosterContractRule
RosterCostConstant
RosterRotationOrder
RosterType
RosterTypeRunTypes
Run
RunCostConstant
RunCostValue
RunReliefRestrictions
RunTimes
RunType
Service
ServiceGroup
ServiceGroupExcCombos
SignUpPeriods
StopClusters
StopPattern
StopPatternFlags
StopPatternSpecialPoints
StopPatternStrings
Stops
StopTimes
SupFieldDescription
SupFieldStyles
ThroughRoutingLines
TraceMap
TravelLegs
Travels
TravelTrace
Trips
TripTimes
WaitsAndTravels
About INFO Tables
This section provides information for the following tables in INFO.
About IVR Tables
This section provides information for the following tables in IVR.
About OPS Tables
This section provides information about OPS Tables.
AbsenceQuotaConfig
AbsenceQuotas
AbsenceQuotaTypes
AbsenceReasons
AbsenceRelationships
AbsenceTypes
AccrualCalendar
AccrualTypes
AllowanceSubtypes
AllowanceTypes
AncillaryGroupDetail
AncillaryGroups
BidAbsenceMatrix
BidAccrualBalance
BidBid
BidBidPeriods
BidDayExceptionTemplate
BidDayoffQuota
BiddingRequests
BidDivisions2Units
BidEmployees
BidEmployeeSection
BidEmployeeStatus
BidHolidays
BidHolidaysService
BidLine
BidLineAnswers
BidLineWork
BidLock
BidPeriodDates
BidPeriods
BidQuestions
BidQuestions2Divisions
BidQuotaList
BidQuotaUsed
BidRosterScenarios
BidSectionQuota
BidUnitList
BidUnits
BinaryContents
Customers
DailyBlocks
DayTypes
DispatchOrderTypes
EmployeeAccrualImport
EmployeeAddress
EmployeeAllowance
EmployeeBankTypes
EmployeeBidUnit
EmployeeCertification
EmployeeCertificationStatuses
EmployeeCertificationTypes
EmployeeDayOffMirror
EmployeeEquipment
EmployeeEscortLocation
EmployeeFMLAImport
EmployeeGroups
EmployeeImport
EmployeeMedicalTest
EmployeeNotificationConfig
EmployeePositions
EmployeeRatePremiums
EmployeeRatePremTypes
EmployeeReview
EmployeeReviewDetail
Employees
EmployeeStatus
EmployeeStatusType
EmployeeTrainingTypes
EmployeeTypes
EmployeeVolunteerStatus
EmployeeWorkPreferences
EmployeeWorkPreferencesDetail
EquipmentTypes
ExtraBoardType
ExtraPayReasons
ExtraPayTypes
ExtraWorkImport
ExtraWorkTrips
ExtraWorkTripTimes
Garages
GroupEmployees
GroupFiles
Holidays
MedicalTestTypes
OPSAbsenceAlerts
OPSAbsenceAlertTypes
OPSAbsenceApprovalImport
OPSAbsenceClaims
OPSAbsenceClaimsImport
OpsAbsenceRequests
OPSAccidentIncidentImport
OPSAccrualAdjustments
OPSAccrualAdjustmentTypes
OpsAccrualGrid
OPSAccrualHierarchy
OPSAccrualHierarchyDetails
OPSAccrualHoliday
OpsAccrualRules
OPSAltDivisionAssignments
OPSAltExtraboard
OPSAltRosterConfig
OPSAltRosterEmployees
OPSAltRosterHistory
OPSAltRosterScenarios
OPSAltRosterWork
OPSBannedPassengers
OPSBatchConfig
OPSBatchJobs
OPSBiddingDates
OPSBiddingTimes
OPSBidHistory
OPSBidHistoryDayOff
OPSBidHistoryEmployeeBidUnit
OPSBidHistoryEmployeeStatus
OPSBidHistoryRelief
OPSBidHistoryWork
OPSBidWork
OPSBkBidBid
OPSBkBidBidPeriods
OPSBkBidDayOffQuota
OPSBkBidDivisions2Units
OPSBkBidEmployees
OPSBkBidEmployeeStatus
OPSBkBidHolidays
OPSBkBidLine
OPSBkBidLineWork
OPSBkBidPeriodDates
OPSBkBidPeriods
OPSBkBidQuotaUsed
OPSBkBidRosterScenarios
OPSBkBidUnitList
OPSBkBinaryContents
OPSBKExtraWork
OPSBkGroupFiles
OPSBKManualMasterRoster
OPSBKManualRoster
OPSBkMemoValues
OPSBKRosterScenarios
OpsBlockActivityLog
OPSBlockConsists
OPSBlocks
OPSBlockSchedulePeriods
OPSBlockSchedules
OpsBlockTrips
OPSBulletins
OPSClientFile
OPSClientPayroll
OPSClientPayrollImport
OpsConsists
OpsConsistsConfig
OpsCustomAssignmentTypes
OPSDailyAbsences
OpsDailyActivityLog
OPSDailyActivityTypes
OPSDailyCharacteristicLog
OPSDailyEmployeeComments
OPSDailyEvent
OPSDailyNotification
OPSDailyRelief
OPSDailyScheduleBlocks
OPSDailyScheduleExtraWork
OPSDailyScheduleRuns
OPSDailySkillLog
OPSDailyVehicle
OpsDispatchReason
OPSDisplayBoardConfig
OpsDivisions
OPSDocuments
OPSDocumentTypes
OPSDriverBlocks
OPSDriverBlockTrips
OpsEmployeeBanking
OPSEmployeeDayType
OpsEmployeeMessage
OPSEmployeeMessageTypes
OPSEmployeeOnTimeDetails
OPSEmployeeOnTimeSummary
OPSEmployeePicture
OPSEmployeeRotationRules
OPSEmployeeSkills
OPSEmployeeSkillsImport
OPSEmployeesSecurity
OPSEmployeeSupervisoryGroups
OpsEmployeeViolation
OpsEmployeeWaiver
OPSEvents
OPSExtraBoardBidConfig
OPSFinancialPenalty
OPSFMLACertifications
OPSFMLACertRestrictions
OpsGarageCapacity
OPSHoldDownBidConfig
OPSHolidays
OPSIncidentAncillary
OPSIncidentAuthorities
OPSIncidentCitations
OPSIncidentClasses
OPSIncidentColumnGroups
OPSIncidentParties
OPSIncidents
OPSIncidentTypes
OPSIncidentWitnesses
OPSInvestigations
OPSInvestigatorActionTypes
OpsJobClasses
OpsLaborAcctConfig
OpsLaborAccts
OPSLaborAllocation
OPSLaborAllocationDetail
OPSLaborCost
OPSLine
OPSLineCosting
OPSLineCostingDetails
OPSLineGroup
OPSLineStopDetail
OPSLineStopLabel
OPSLineValidity
OPSMasterBidRun
OPSMasterLine
OPSMasterLineGroup
OPSMasterLineStop
OPSMasterPattern
OpsMasterRoster
OPSMasterRun
OPSMedicalTestResults
OPSMemos
OPSMemoTypes
OPSMissedTrips
OPSNodes
OPSOnTimeDetailsByLineGroup
OPSOpBid
OPSOpBidEmployees
OPSOpBidPeriods
OPSOpBidRequests
OPSOpBidWork
OPSOpenRunBidConfig
OPSOpVacationReliefConfig
OPSOrgDivisions
OPSOrgUnit
OPSPattern
OPSPerfectAttendanceDetails
OPSPerfectAttendanceMatrix
OPSPerformance
OPSPerformanceAckReasons
OPSPerformanceActions
OPSPerformanceActionTypes
OPSPerformanceDetails
OPSPerformancePenalty
OPSPerformancePointBalance
OPSPerformanceSeverity
OPSPerformanceTypes
OPSPriorPayLog
OPSPriorPayLogDetail
OpsProcessLog
OPSPublishedWork
OPSRealTimeParking
OPSRecipientMemoTypes
OPSRecipients
OpsRemarksImport
OPSRequiredCharacteristics
OPSRequiredCharDetails
OPSRequiredSkillDetails
OPSRequiredSkills
OpsReviewConfig
OpsReviewEmployeesCount
OPSReviewGrade
OPSRFindConsist
OpsRoster
OpsRosterBidUnit
OpsRosterScenarios
OpsRosterType
OPSRosterValidity
OPSRun
OPSRunSchedulePeriods
OPSRunSchedules
OpsRunTypes
OPSRunValidity
OPSSafteFastResponse
OPSSection
OPSSeniorityCalculationConfig
OPSShiftDefinition
OpsSignInLog
OPSSignUpImportSource
OPSSignUpPeriods
OPSSIT
OPSSITGroup
OPSSITLog
OPSSITParameters
OPSSkillTypes
OPSStopPattern
OPSStopTimes
OPSSupervisoryGroups
OPSTimeComponentDefaults
OPSTimekeepingAlertRuleDetail
OPSTimekeepingAlertRules
OPSTimekeepingAlerts
OPSTimekeepingAttributes
OPSTimekeepingAttributeTypes
OPSTimekeepingBidValue
OPSTimekeepingEmployeeFrozen
OPSTrainingCategories
OPSTrainingClasses
OPSTrainingClassStudents
OPSTrainingCourses
OPSTrainingLessons
OPSTrainingLessonStudents
OPSTrainingRequired
OPSTrainingResults
OPSTrainingTemplates
OPSTravels
OPSTripDetails
OPSTrips
OPSVehicleChangeOut
OPSVehicleCharacteristics
OPSVehicleCharTypes
OPSVehicleWorkOrder
OPSWebGroup
OPSWebLog
OPSWebParameters
OPSWkRosterConfig
OPSWkRosterWeek
OPSWkRosterWork
OPSWkRosterWorkDetail
OpsWorkAssignmentRules
OPSWorkforceBudgets
OPSWorkGroup
OPSWorkGroupDetail
OPSWorkGroupTypes
OPSWorkNameSeries
OpsWorkNotifyLog
OPSWorkRefusalActivities
OPSWorkRefusalLog
OPSWorkTypeMapping
OPSYardMovements
Parking
ParkingGridDefinition
ParkingLayouts
PayCodes
PayGrid
PayrollCodes
ReportWorkSpace
Rota
RotaLine
RotaLineEmployee
RotaLineWork
ScheduleImportDetail
ScheduleImportInfo
Titles
TKAbsences
TKAccrualBalance
TKAccrualBalanceCalendar
TKAccrualBalanceLog
TKAccrualBanking
TKAccrualSellbacks
TKAdminActionTypes
TKCalendar
TKDailyVehicleAttributes
TKDispatchLog
TkDispatchOrders
TKExtraEmployees
TKExtraPay
TKExtraWork
TKExtraWorkStatus
TkLaborInterface
TKPay
TkPayAccessory
TkPayAccessoryGroup
TkPayDisqualification
TkPayEmployeeVersion
TkPayExtraBoard
TKPayInterface
TkPayRule
TKPaySection15
TKPaySection15Supp
TKPaySupplementary
TKReportingGroups
TKWork
TkWorkActivities
TKWorkAssignmentLog
TkWorkAssignmentProfile
TkWorkAssignOrder
TkWorkCostOrder
TransportationModes
VacationGroups
VehicleAssetWorksRequests
VehicleCharacteristicImport
VehicleDiagnosticsMapping
VehicleFuelDetails
VehicleFuelImport
VehicleImport
VehicleMaintenance
VehicleMaintenanceImport
VehicleMaintenanceTypes
VehicleParkingImport
Vehicles
VehicleStatus
VehicleStatusType
VehicleTypes
Vendors
VolunteerRegions
VolunteerType
VRPackage
VRPackageDetail
WorkSubtype
About PASS Tables
This section provides information for the following tables in PASS.
ActiveLanguages
AdaTypes
Address
AddressTypes
AdmUnit
AdvancedNoticeProfile
Alerts
AlertsContext
AlertTypes
ATISParameters
BatchSearchInputs
BatchSearchResults
BatchSearchSortOrder
BatchSortOrder
BICTypes
Booking
BookingActivity
BookingActTransactionDetail
BookingEscort
BookingExternalTransactions
BookingLegs
BookingPaymentDetails
BookingPurpose
BookingSubtypes
BookingTags
BookingTagsDisplayDefaults
BookingTagsLogicValues
BookingTransactionDetail
CancelCodes
CancelCodesDefined
CancelPrepay
Capacities
CapacityLIFO
CapacityTypes
CertificationAccTList
CertificationAccType
CertificationActivity
CertificationActivityType
CertificationAdaCond
CertificationAppt
CertificationApptHour
CertificationApptType
CertificationBtravel
CertificationCdocs
CertificationClients
CertificationExpList
CertificationFacilities
CertificationInfoList
CertificationInfoRequest
CertificationLetterActivity
CertificationLetters
CertificationLog
CertificationParameters
CertificationRequest
CertificationResults
CertificationStatus
CertificationUsers
CertificationWorker
CheckAnswers
ChecklistAnswers
CheckListPictures
CheckListQuestions
CheckListResults
CheckLists
CheckQuestions
ClientAccountTransaction
ClientAccountTransactionDetail
ClientAssistAssigned
ClientAutoTopup
ClientDataControlSystem
ClientEligConditions
ClientEntitlement
ClientEscort
ClientFundingSource
ClientGroupBooking
ClientInActiveStatusTypes
ClientLocationProgram
ClientMobilitySkills
ClientParaServices
ClientPassTypeRestrictions
ClientPasswordHistory
ClientPaymentProfile
ClientPaymentType
ClientProviders
Clients
ClientStats
ClientStatsGroup
ClientStatsPeriod
ClientSuspension
ClientTCLog
ClientType
CliPhotoInterface
CLP_Legs
ConditionProgram
ContactCategory
ContactInfo
ContactRules
ContextMsg
CostBreakdown
Counties
CountryRegistration
DailyProviderCap
DateIntervals
DateIntervalSummary
DCESCache2
DCESZonalCache
DisabilityTypes
DriverTripComments
EligConditions
EligibilityPolygons
EligRules
EligStatusCodes
EligTests
EmployeeLoadFactors
EmployeeSpeedZones
Entitlement
Ethnicity
EventActivity
Events
EventsOld
EventStringCluster
EventStringEmployee
EventStringPoly
EventStrings
EventStringService
EventStringsStopRestrictions
EWalletLocation
EWalletLocationType
EWalletLocationUser
EWalletPass
EWalletPassFareType
EWalletPassPolygonSubsidy
EWalletPassTransaction
EWalletPassType
EWalletReason
FareCost
FareCostClass
FareDistance
FareFundingSources
FarePassengerType
FarePolygon
FareRule
FareTransactionTypes
FareTypeDateInterval
FareTypes
FareTypeVariation
FareZoneClass
FareZoneGroup
FareZoneGroupClass
FerryLine
FerryTripTimes
FuelType
FundingByLocations
FundingSourceAllowance
FundingSources
GroupBooking
InAvl
InCannedMsg
InMessage
JourneyPlannerParameters
LoadTimeMatrix
LocationActivity
LocationAlias
LocationCapacity
LocationProgram
LocationProgramActivity
LocationProgramStops
Locations
LocationTimes
LPOpenTimes
MasterProviderCap
MaximumClientBookings
MaxOBTFactor
MdtAutosendSchedule
MdtFlagStops
MdtFxEntities
MdtGenMsg
MdtGroup
MdtIgnorePendingSchedule
MdtManifest
MdtMessageLog
MdtSettings
MDTSupervisorLog
MdtTripInfo
MdtVehStatus
MedicaldLog
MobilityAid
MobilityAidInventory
MobilitySkills
NetMessageQueue
OutAvlTxtCmd
OutCannedMsg
OutTrip
ParaAccessPointLoadTime
ParaDispRunGroupRuns
ParaDispRunGroups
ParaMasterLine
ParaPolyTransfer
ParaRunBreakRule
ParaRunCategory
ParaRunCluster
ParaRunEmployee
ParaRunPoly
ParaRuns
ParaRunService
ParaRunsStopRestrictions
ParaSecurityRestrictions
ParaService
ParaServiceAreaPassTypeRules
ParaServiceAreaRoute
ParaServiceAreaRuleParameters
ParaServiceAreaRules
ParaServiceAreas
ParaServiceAttributeSets
ParaServiceLoadTime
PassAgentLog
PassBookingRules
PassCardTransDetail
PassChequeTransDetail
PassClientSession_ACT
PassCmnOAuthTokens
PassCmnTNCAdminInfo
PassCmnTNCTripInfo
PassColorIndicators
PassDataDictionary
PassFinancialTransaction
PassFinancialTransactionDetail
PassPaymentMonitorLog
PassPaymentTypeTransDetail
PassTypes
PassUuidLinks
PaymentMethods
PaymentTypePurchaseRules
PaymentTypes
PriceIndex
ProductFeatureAccess
ProviderActivityCost
ProviderBookingCost
ProviderContract
ProviderContractQuota
ProviderContractType
ProviderCostBreakdown
ProviderCostValidity
ProviderFareExclusions
ProviderFares
ProviderMobAidCost
ProviderPeriod
ProviderRateProfile
ProviderRunCost
ProviderRunCostActivityExclude
Providers
ProvidersAndContracts
ProviderSegmentCost
ProviderTourCost
ProviderTripCost
ProviderTripsQuota
RTTChannels
RTVsets
RTVSharedSets
RunItineraryStates
SchedLog
ScheduleLoad
SchedulePeriodDates
ScheduleRule
ScheduleRuleType
Schedules
ScheduleSolutions
ScheduleTypes
SchMultiParameters
SchParameters
SchParameterSet
SchViolations
SchViolationSet
SequenceValues
ServiceLine
ServiceLineJourney
ServiceLineJourneyDetail
ServiceLineJourneyLinePara
ServiceLineJourneyParam
ServiceLineJourneyPolyPara
ServiceLineJourneyStop
ServiceLineMandatoryType
ServiceLineNetList
ServiceLinePattern
ServiceLinePatternExcept
ServiceLineRunRes
ServiceLineServiceType
ServiceLineStopTime
ServiceParameters
ServiceParameterVariation
ServiceParameterZones
SmartCardHistory
SmartCardTypes
SpeedDistFactors
SpeedTimeFactors
StatusTypes
SupervisorVehicles
SuspensionBaseCodes
SuspensionCodes
SuspensionDetail
SuspensionFile
SuspensionLetters
SuspensionParams
ToDoActionLog
ToDoItems
TraceLog
TrackerActionLog
TrackerActions
TrackerCodes
TrackerDatabaseConfig
TrackerDatabaseLog
TransferPattern
TrapezeAccessLocks
TrapezeApplications
TrapezeConnectForeignKey
TrapMessenger
TrapMessengerGroupMembers
TrapMessengerGroups
TrapMessengerUsers
TripBrokerTransactions
TripPlanBatch
UnitStatus
VersionLog
About PLAN Tables
This section provides information for the following tables in Plan.
Deprecated Tables and Fields
A list of tables and fields that no longer exist in version 21 MMSData.