Trapeze Insight DB Viewer

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.

FeedbackResponsibilities

InvestigatorActionTypes

InvestigatorDivDept

Investigators

MemoValues

RegisteredUserApplications

RegisteredUserComments

RegisteredUserGroups

RegisteredUsers

RegisteredUserSubscriptions

ReportGroupDeviceActivities

ReportGroupFeedbackSubtypes

ReportGroups

About CORE Tables

This section provides information for the following tables in CORE.

CoreIdentityLdapSearch

CoreIdentityMap

CoreIdentityWorkspace

PassClientSession_ACT

About FX Tables

This section provides information for the following tables in FX.

AccessibilityTypes

Agencies

BbConstraintParameters

BbParameterSituations

BbParameterTypes

BbParameterValuesCompressed

BbPersonalParameters

BbRunTypeBusTypes

BbRunTypeCategories

BbRunTypeCategoryValues

BbRunTypeGarages

BbRunTypeLineGroups

BbRunTypeLines

BbRunTypePercentageRules

ExceptionCombinations

FxRunReliefRestrictions

FxRuns

FxRunScenarios

FxTimedConnections

FxTripsScreenConfigCols

FxTripsScreenConfigs

FxUnattendedReliefNodes

InterlineRelationships

MasterExceptionCombinations

MasterRosterCostValue

RunReliefRestrictions

ServiceGroupExcCombos

StopPatternSpecialPoints

This section provides information for the following tables in INFO.

DeliveryMethodsTextEx

InfoFarePassengerType

InfoFareRule

InfoFareZoneClass

InfoFareZoneGroup

InfoFareZoneGroupClass

InfoLineCluster

InfoRemarkAttachments

InfoRemarkCategory

InfoRemarkContentTypes

InfoServiceAdjustment

ItineraryRestrictions

TI_Legacy_RemarkContext

Transfers

TransitNowActivityLog

TransitNowAlertAttributes

TransitNowDisplayPreferences

TransitNowSchedSubscriptions

TransitNowSentUserMessages

TransitNowUserMessages

TransitNowUserStops

TripPlanBatchRequest

TripPlanningParameterSets

TripPlanningSolutions

TripPlanningSolutionSets

TripPlanRequest

TripPlanRequestSolution

TripPlanResult

About IVR Tables

This section provides information for the following tables in IVR.

DeviceTokenValidation

DeviceTypes

DeviceUtilization

GeneralRSS

InfoSurveyApplications

InfoSurveyDescriptions

InfoSurveyGroups

InfoSurveyQnChoiceDescriptions

InfoSurveyQuestionChoices

InfoSurveyQuestionDescriptions

NotificationGroupItem

NotificationsForPASS

NotificationForTransitNow

NotificationStatusTextEx

NotificationSubCategoryTextEx

NotificationType

NotificationTypeDeviceSupport

NotificationWaitingArea

OfficeHours

OfficeHoursExceptions

RegisteredUserSurveyResponses

RegisteredUserSuspensions

SMSGateways

SubscribableItems

SubscribableItemsDelivMethods

SubscribableItemsTextEx

SubscribableItemTypes

SubscribableItemTypesTextEx

SubscribDeliveryMethods

SubscriptionPrintItems

About OPS Tables

This section provides information about OPS Tables.

BidDayExceptionTemplate

BidQuestions2Divisions

EmployeeAccrualImport

EmployeeCertification

EmployeeCertificationStatuses

EmployeeCertificationTypes

EmployeeDayOffMirror

EmployeeEquipment

EmployeeEscortLocation

EmployeeNotificationConfig

EmployeePositions

EmployeeRatePremiums

EmployeeRatePremTypes

EmployeeTrainingTypes

EmployeeTypes

EmployeeVolunteerStatus

EmployeeWorkPreferences

EmployeeWorkPreferencesDetail

OPSAbsenceApprovalImport

OPSAbsenceClaims

OPSAbsenceClaimsImport

OpsAbsenceRequests

OPSAccidentIncidentImport

OPSAccrualAdjustments

OPSAccrualAdjustmentTypes

OpsAccrualGrid

OPSAccrualHierarchy

OPSAccrualHierarchyDetails

OPSAccrualHoliday

OpsAccrualRules

OPSAltDivisionAssignments

OPSAltExtraboard

OPSAltRosterConfig

OPSAltRosterEmployees

OPSAltRosterHistory

OPSAltRosterScenarios

OPSBidHistoryEmployeeBidUnit

OPSBidHistoryEmployeeStatus

OPSBkBidDivisions2Units

OPSBkBidEmployees

OPSBkBidEmployeeStatus

OPSBkBidRosterScenarios

OPSBKManualMasterRoster

OPSBlockSchedulePeriods

OPSClientPayrollImport

OpsConsists

OpsConsistsConfig

OpsCustomAssignmentTypes

OPSDailyAbsences

OpsDailyActivityLog

OPSDailyActivityTypes

OPSDailyCharacteristicLog

OPSDailyEmployeeComments

OPSDailyEvent

OPSDailyNotification

OPSDailyRelief

OPSDailyScheduleBlocks

OPSDailyScheduleExtraWork

OPSDisplayBoardConfig

OPSEmployeeMessageTypes

OPSEmployeeOnTimeDetails

OPSEmployeeOnTimeSummary

OPSEmployeePicture

OPSEmployeeRotationRules

OPSEmployeeSkills

OPSEmployeeSkillsImport

OPSEmployeesSecurity

OPSEmployeeSupervisoryGroups

OpsEmployeeViolation

OpsEmployeeWaiver

OPSEvents

OPSExtraBoardBidConfig

OPSFinancialPenalty

OPSFMLACertifications

OPSFMLACertRestrictions

OPSIncidentAuthorities

OPSIncidentCitations

OPSIncidentClasses

OPSIncidentColumnGroups

OPSInvestigatorActionTypes

OPSLaborAllocationDetail

OPSLaborCost

OPSLine

OPSLineCosting

OPSLineCostingDetails

OPSMedicalTestResults

OPSOnTimeDetailsByLineGroup

OPSOpVacationReliefConfig

OPSOrgDivisions

OPSOrgUnit

OPSPattern

OPSPerfectAttendanceDetails

OPSPerfectAttendanceMatrix

OPSPerformance

OPSPerformanceAckReasons

OPSPerformanceActions

OPSPerformanceActionTypes

OPSPerformanceDetails

OPSPerformancePenalty

OPSPerformancePointBalance

OPSPerformanceSeverity

OPSRecipientMemoTypes

OPSRecipients

OpsRemarksImport

OPSRequiredCharacteristics

OPSRequiredCharDetails

OPSRequiredSkillDetails

OPSRequiredSkills

OpsReviewConfig

OpsReviewEmployeesCount

OPSRunSchedulePeriods

OPSSeniorityCalculationConfig

OPSShiftDefinition

OpsSignInLog

OPSSignUpImportSource

OPSTimeComponentDefaults

OPSTimekeepingAlertRuleDetail

OPSTimekeepingAlertRules

OPSTimekeepingAlerts

OPSTimekeepingAttributes

OPSTimekeepingAttributeTypes

OPSTimekeepingBidValue

OPSTimekeepingEmployeeFrozen

OPSTrainingCategories

OPSTrainingClasses

OPSTrainingClassStudents

OPSTrainingCourses

OPSTrainingLessons

OPSTrainingLessonStudents

OPSVehicleCharacteristics

OPSWkRosterWorkDetail

OpsWorkAssignmentRules

OPSWorkRefusalActivities

ParkingGridDefinition

TKAccrualBalanceCalendar

TKDailyVehicleAttributes

TkPayDisqualification

TkWorkAssignmentProfile

VehicleAssetWorksRequests

VehicleCharacteristicImport

VehicleDiagnosticsMapping

VehicleMaintenanceImport

VehicleMaintenanceTypes

This section provides information for the following tables in PASS.

AdvancedNoticeProfile

BookingActTransactionDetail

BookingEscort

BookingExternalTransactions

BookingLegs

BookingPaymentDetails

BookingPurpose

BookingSubtypes

BookingTags

BookingTagsDisplayDefaults

BookingTagsLogicValues

BookingTransactionDetail

CertificationAccTList

CertificationAccType

CertificationActivity

CertificationActivityType

CertificationAdaCond

CertificationAppt

CertificationApptHour

CertificationApptType

CertificationFacilities

CertificationInfoList

CertificationInfoRequest

CertificationLetterActivity

CertificationLetters

CertificationLog

CertificationParameters

ClientAccountTransaction

ClientAccountTransactionDetail

ClientAssistAssigned

ClientAutoTopup

ClientDataControlSystem

ClientInActiveStatusTypes

ClientLocationProgram

ClientMobilitySkills

ClientParaServices

ClientPassTypeRestrictions

ClientPasswordHistory

EventStringsStopRestrictions

EWalletPassPolygonSubsidy

EWalletPassTransaction

FundingSourceAllowance

JourneyPlannerParameters

LocationProgramActivity

MaximumClientBookings

MdtIgnorePendingSchedule

ParaAccessPointLoadTime

ParaRunsStopRestrictions

ParaSecurityRestrictions

ParaService

ParaServiceAreaPassTypeRules

ParaServiceAreaRoute

ParaServiceAreaRuleParameters

ParaServiceAreaRules

ParaServiceAreas

ParaServiceAttributeSets

PassChequeTransDetail

PassClientSession_ACT

PassFinancialTransaction

PassFinancialTransactionDetail

PassPaymentMonitorLog

PassPaymentTypeTransDetail

PassTypes

PassUuidLinks

PaymentMethods

PaymentTypePurchaseRules

ProviderContractQuota

ProviderContractType

ProviderCostBreakdown

ProviderCostValidity

ProviderFareExclusions

ProviderRunCostActivityExclude

Providers

ProvidersAndContracts

ServiceLineJourneyDetail

ServiceLineJourneyLinePara

ServiceLineJourneyParam

ServiceLineJourneyPolyPara

ServiceLineJourneyStop

ServiceLineMandatoryType

ServiceLineNetList

ServiceLinePattern

ServiceLinePatternExcept

ServiceLineRunRes

ServiceLineServiceType

ServiceLineStopTime

ServiceParameters

ServiceParameterVariation

ServiceParameterZones

TrackerDatabaseConfig

TrapezeConnectForeignKey

TrapMessenger

TrapMessengerGroupMembers

TrapMessengerGroups

TrapMessengerUsers

TripBrokerTransactions

This section provides information for the following tables in Plan.

DemogPTTI

RidCountExtTypes

RidershipCommentDetails

Deprecated Tables and Fields

A list of tables and fields that no longer exist in version 21 MMSData.