Jump to main content
Expand All
Collapse All
About Insight DB Viewer
The Insight DB Viewer provides definitions of tables and fields used in Trapeze products.
New Tables and Fields
The following are new tables and fields added to MMS version 19 database.
This section provides information for the following tables in COM.
This section provides information for the following tables in CORE.
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
GarageRestrictions
Garages
Holidays
InterlineRelationships
Line
LineGroup
LineLocations
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
This section provides information for the following tables in INFO.
This section provides information for the following tables in ITS.
This section provides information for the following tables in IVR.
This section provides information for the following tables in OPS.
AbsenceQuotaConfig
AbsenceQuotas
AbsenceQuotaTypes
AbsenceReasons
AbsenceRelationships
AbsenceTypes
AccrualCalendar
AccrualTypes
AllowanceSubtypes
AllowanceTypes
AncillaryGroupDetail
AncillaryGroups
BidAbsenceMatrix
BidAccrualBalance
BidBid
BidBidPeriods
BidDayExceptionTemplate
BidDayoffQuota
BiddingRequests
BidDivisions2Units
BidEmployees
BidEmployeeSection
BidEmployeeStatus
BidHolidays
BidHolidayService
BidLine
BidLineAnswers
BidLineDayOff
BidLineVacationRelief
BidLock
BidLineWork
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
EmployeeRatePermiums
EmployeeRatePremTypes
EmployeeReview
EmployeeReviewDetail
Employees
EmployeeStatus
EmployeeStatusType
EmployeeTrainingTypes
EmployeeTypes
EmployeeVolunteerStatus
EmployeeWorkPreferences
EmployeeWorkPreferencesDetail
EquipmentTypes
ExchangeSettings
ExtraBoardType
ExtraPayReasons
ExtraPayTypes
ExtraWorkImport
ExtraWorkTrips
ExtraWorkTripTimes
GroupEmployees
GroupFiles
MedicalTestTypes
OPSAbsenceAlerts
OPSAbsenceAlertTypes
OPSAbsenceApprovalImport
OPSAbsenceClaims
OPSAbsenceClaimsImport
OpsAbsenceRequests
OPSAccidentIncidentImport
OPSAccrualAdjustments
OPSAccrualAdjustmentTypes
OpsAccrualGrid
OPSAccrualHierarchy
OPSAccrualHierarchyDetails
OPSAccrualHoliday
OpsAccrualRules
OPSAltDivisionAssignments
OPSAltExtraboard
OPSAltRosterConfig
OPSAltRosterEmployees
OPSAltRosterHistory
OPSAltRosterScenarios
OPSAltRosterWork
OPSBatchConfig
OPSBatchJobs
OPSBiddingDates
OPSBiddingTimes
OPSBidHistory
OPSBidHistoryDayOff
OPSBidHistoryEmployeeBidUnit
OPSBidHistoryEmployeeStatus
OPSBidHistoryRelief
OPSBidHistoryWork
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
OpsConsists
OpsConsistsConfig
OpsCustomAssignmentTypes
OPSDailyAbsences
OpsDailyActivityLog
OPSDailyActivityTypes
OPSDailyCharacteristicLog
OPSDailyEmployeeComments
OPSDailyEvent
OPSDailyNotification
OPSDailyRelief
OPSDailyScheduleBlocks
OPSDailyScheduleExtraWork
OPSDailyScheduleRuns
OPSDailySkillLog
OPSDailyVehicle
OpsDispatchReason
OPSDisplayBoardConfig
OpsDivisions
OPSDriverBlocks
OPSDriverBlockTrips
OpsEmployeeBanking
OPSEmployeeDayType
OpsEmployeeMessage
OPSEmployeeMessageTypes
OPSEmployeeOnTimeDetails
OPSEmployeeOnTimeSummary
OPSEmployeeSkills
OPSEmployeeSkillsImport
OPSEmployeesSecurity
OPSEmployeeSupervisoryGroups
OpsEmployeeViolation
OpsEmployeeWaiver
OPSEvents
OPSExpirationDateConfig
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
OPSLineValidity
OPSMasterBidRun
OPSMasterLine
OPSMasterLineGroup
OPSMasterLineStop
OPSMasterPattern
OpsMasterRoster
OPSMasterRun
OPSMedicalTestResults
OPSMemos
OPSMemoTypes
OPSMissedTrips
OPSOnTimeDetailsByLineGroup
OPSOpBid
OPSOpBidEmployees
OPSOpBidPeriods
OPSOpBidRequests
OPSOpBidWork
OPSOpenRunBidConfig
OPSOrgDivisions
OPSOrgUnit
OPSPattern
OPSPerfectAttendanceMatrix
OPSPerformance
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
OPSRun
OPSRunSchedulePeriods
OPSRunSchedules
OpsRunTypes
OPSRunValidity
OPSSection
OPSSeniorityCalculationConfig
OPSShiftDefinition
OpsSignInLog
OPSSignUpImportSource
OPSSignUpPeriods
OPSSIT
OPSSITGroup
OPSSITParameters
OPSSkillTypes
OPSStopPattern
OPSStopTimes
OPSSupervisoryGroups
OPSTimekeepingAlertRuleDetail
OPSTimekeepingAlertRules
OPSTimekeepingAlerts
OPSTimekeepingAttributes
OPSTimekeepingAttributeTypes
OPSTimekeepingBidValue
OPSTimekeepingEmployeeFrozen
OPSTrainingCategories
OPSTrainingClasses
OPSTrainingClassStudents
OPSTrainingCourses
OPSTrainingLessons
OPSTrainingLessonStudents
OPSTrainingRequired
OPSTrainingResults
OPSTrainingTemplates
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
TkPayExtraBoard
TKPayInterface
TkPayRule
TKPaySection15
TKPaySection15Supp
TKPaySupplementary
TKReportingGroups
TKWork
TkWorkActivities
TKWorkAssignmentLog
TkWorkAssignmentProfile
TkWorkAssignOrder
TkWorkCostOrder
TransportationModes
VacationGroups
VehicleAssetWorksRequests
VehicleCharacteristicImport
VehicleDiagnosticsMapping
VehicleFuelDetails
VehicleFuelImport
VehicleGroups
VehicleImport
VehicleMaintenance
VehicleMaintenanceImport
VehicleMaintenanceTypes
VehicleParkingImport
Vehicles
VehicleStatus
VehicleStatusType
VehicleTypes
Vendors
VolunteerRegions
VolunteerType
WorkSubtype
This section provides information for the following tables in PASS.
ActiveLanguages
AdaTypes
Address
AddressTypes
AdmUnit
AdvancedNoticeProfile
Alerts
AlertsContext
AlertTypes
ATISParameters
BatchSearchInputs
BatchSearchSortOrder
BatchSearchResults
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
ClientAssistAssigned
ClientAutoTopup
ClientDataControlSystem
ClientEligConditions
ClientEntitlement
ClientEscort
ClientFundingSource
ClientGroupBooking
ClientInActiveStatusTypes
ClientLocationProgram
ClientParaServices
ClientMobilitySkills
ClientPassTypeRestrictions
ClientPasswordHistory
ClientPaymentProfile
ClientPaymentType
ClientProviders
Clients
ClientStats
ClientStatsGroup
ClientStatsPeriod
ClientSuspension
ClientType
CliPhotoInterface
CLP_Legs
ConditionProgram
ContactCategory
ContactInfo
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
FundingByLocations
FundingSourceAllowance
FundingSources
GroupBooking
InAvl
InCannedMsg
InMessage
JourneyPlannerParameters
LoadTimeMatrix
LocationActivity
LocationAlias
LocationCapacity
LocationProgram
LocationProgramActivity
LocationProgramStops
Locations
LocationTimes
LPOpenTimes
MasterProviderCap
MaximumClientBookings
MaxOBTFactor
MdtAutosendSchedule
MdtFlagStops
MdtFxEntities
MdtManifest
MdtMessageLog
MdtSettings
MDTSupervisorLog
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
PassCmnOAuthTokens
PassCmnTNCAdminInfo
PassCmnTNCTripInfo
PassColorIndicators
PassDataDictionary
PassFinancialTransaction
PassFinancialTransactionDetail
PassPaymentTypeTransDetail
PassTypes
PaymentTypePurchaseRules
PaymentTypes
PriceIndex
ProductFeatureAccess
ProviderBookingCost
ProviderContract
ProviderContractQuota
ProviderContractType
ProviderCostBreakdown
ProviderCostValidity
ProviderFareExclusions
ProviderFares
ProviderRunCost
ProviderRunCostActivityExclude
Providers
ProvidersAndContracts
RTTChannels
RTVsets
RunItineraryStates
SchedLog
ScheduleLoad
SchedulePeriodDates
ScheduleRule
ScheduleRuleType
Schedules
ScheduleSolutions
ScheduleTypes
SchMultiParameters
SchParameters
SchParameterSet
SchViolations
SchViolationSet
SequenceValues
ServiceLineServiceType
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
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 19 MMS data.