ComSubject

Name: COM Subject

Type: Application

Modules: COM-Investigator, COM-Representative

Description: List of subjects in a feedback, includes all incident-related information.

Field Documentation
SubjectId Unique identifier for a COM subject.
FeedbackId Feedback identifier from ComFeedback.FeedbackID. References COM subject belongs to a specific feedback.
FeedbackTypeAbbr Feedback type identifier from FeedbackTypes.FeedbackTypeAbbr. References the type of a specific feedback subject.
FeedbackSubtypeAbbr Feedback subtype identifier from FeedbackSubtypes.FeedbackSubtypeAbbr. References the feedback subtype of a specific feedback subject.
FeedbackPriorityId Feedback priority identifier from FeedbackPriorities.FeedbackPriorityId. References the priority of a specific feedback subject.
TargetDate Target date for feedback closure. By default, this date is based on FeedbackPriorities.TurnRoundDays. Format: YYYYMMDD.
Location Location name from Locations.LocName. Indicates the location where the incident happened.
DepartmentAbbr Department identifier from Departments.DepartmentAbbr. References the department the specific feedback subject is assigned to.
DivisionId Division identifier from MasterDivisions.DivisionId. References the division the specific feedback subject is assigned to.
IsClosed Indicates whether or not the subject is closed.
Chargeable Indicates whether or not the subject is chargeable.
MisconductId Deprecated.
DateClosed Date when the subject was closed. Format: YYYYMMDD.
TimeClosed Time when the subject was closed. Value is in seconds from midnight.
ClosedBy Username of the person who closed the subject.
LocOfAlighting Location where the customer alights from the vehicle.
LocOfBoarding Location where the customer boards the vehicle.
TimeOfAlighting Time when the customer alights from the vehicle. Value is in seconds from midnight.
TimeOfBoarding Time when the customer boards the vehicle. Value is in seconds from midnight.
EmployeeDesc Description of the driver.
Gender Gender of the driver.
EthnicOrigin Ethnic origin of the driver.
EstimatedAge Estimated age of the driver.
EstimatedWeight Estimated weight of the driver.
HairColor Hair color of the driver.
Glasses Indicates whether or not the driver wears glasses.
FacialHair Facial hair description of the driver.
ResponseRequired If true, the customer requires a response.
TransportationModeAbbr Transportation mode identifier from TransportationModes.TransportationModeAbbr. References the transportation mode of the vehicle. For example: Fixed, Flex, Demand.
TransportType Transport type identifier from TransportationModes.TransportType. References the transport type of the vehicle.
OperatorDescription Details about the driver.
IncidentDate Date when the incident happened. Format: YYYYMMDD.
IncidentStartTime Time when the incident started. Value in seconds from midnight.
IncidentEndTime Time when the incident ended. Value in seconds from midnight.
SignId Sign-up period identified from SignUpPeriods.SignId. References the sign-up period that includes the incident date.
LineId Line identifier from MasterLine.LineId. References the line the vehicle is running.
LineDirId Line direction identifier from Line.LineDirId. References the line direction the vehicle is running.
LineDescription Description of the line on which the vehicle is running. Typically, the line name from MasterLine.LineName.
StopId Stop identifier from Stops.StopId. References the stop where the issue occurred.
StopDescription Description of the stop where the issue occurred. Typically, the stop name from Stops.StopName.
RunNum Number of the run. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, the value is from MasterRun.RunNum. If the property is set to 'ComDailyOperations', the value is from ComDailyOperations.RunNum.
RunDetails Detailed description of the run. Typically, includes the run ID. Can be customized by the context property 'COM/Customers Feedback settings/RunID Field'.
BlockNum Number of the block. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Trips.BlockNum. If the property is set to 'ComDailyOperations', the value is from ComDailyOperations.BlockNum.
EmployeeId Identifier for the driver. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Employees.EmployeeId. If the property is set to 'ComDailyOperations', the value is from ComDailyOperations.EmployeeId.
VehicleId Vehicle identifier from Vehicles.VehicleId. References the vehicle involved with the issue.
VehicleDescription Description of the vehicle. Typically, a formatted string that includes the vehicleId, vehicleNumber and license number.
SchTime Scheduled time for the vehicle to arrive at the stop. The value is from StopTimes.ETime.
BookingId Booking identifier from Booking.BookingId. References the PASS booking the subject is associated with.
ParaRun Pass run of the booking related to a specific subject.The value comes from EventStrings.EvStrName.
TripType Type of the booking related to a specific subject. The value comes from Booking.BookingType.
ParaStatus Booking status from Booking.SchedStatus.
BookedBy User name of the last person who modified the booking. The value comes from Booking.ModBy
ProviderId Provider identifier from Providers.ProviderId. References the provider the booking belongs to.
PassNegTime Time that was negotiated between the client and booker of the trip for the booking leg. The value is from BookingLegs.NegTime. Value is in seconds from midnight.
PassSchTime PASS schedule time that the trip event is scheduled for. The value is from Events.SchTime. Value is in seconds from midnight.
BookingSubTypeAbbr Abbreviation of the booking SubType from BookingSubTypes.SubtypeAbbr.
PassengerInformation Summary of the passenger information. Includes PassType, SpaceType and NumSpacesPu from BookingActivity table(if context property 'COM/PASS/Using Client Location Program' is false) or EventActivity table(if context property 'COM/PASS/Using Client Location Program' is true).
FundingSource All funding source names related to the booking. Sources separated by '-'.
LocationDetails Location detail for the start location of the booking leg.
SchLocation Location detail for the end location of the booking leg.
UserString1 User-defined string data, usually used as a supplementary field for a short string.
UserString2 User-defined string data, usually used as a supplementary field for a short string.
UserString3 User-defined string data, usually used as a supplementary field for a short string.
UserString4 User-defined string data, usually used as a supplementary field for a short string.
UserString5 User-defined string data, usually used as a supplementary field for a short string.
UserString6 User-defined string data, usually used as a supplementary field for a short string.
UserString7 User-defined string data, usually used as a supplementary field for a short string.
UserString8 User-defined string data, usually used as a supplementary field for a short string.
UserString9 User-defined string data, usually used as a supplementary field for a short string.
UserString10 User-defined string data, usually used as a supplementary field for a short string.
UserLongString1 User-defined string data, usually used as a supplementary field for a long string.
UserLongString2 User-defined string data, usually used as a supplementary field for a long string.
UserLongString3 User-defined string data, usually used as a supplementary field for a long string.
UserLongString4 User-defined string data, usually used as a supplementary field for a long string.
UserLongString5 User-defined string data, usually used as a supplementary field for a long string.
UserShort1 User-defined numeric data, usually used as a supplementary field for a small integer.
UserShort2 User-defined numeric data, usually used as a supplementary field for a small integer.
UserShort3 User-defined numeric data, usually used as a supplementary field for a small integer.
UserShort4 User-defined numeric data, usually used as a supplementary field for a small integer.
UserShort5 User-defined numeric data, usually used as a supplementary field for a small integer.
UserLong1 User-defined numeric data, usually used as a supplementary field for a large integer.
UserLong2 User-defined numeric data, usually used as a supplementary field for a large integer.
UserLong3 User-defined numeric data, usually used as a supplementary field for a large integer.
UserLong4 User-defined numeric data, usually used as a supplementary field for a large integer.
UserLong5 User-defined numeric data, usually used as a supplementary field for a large integer.
UserDouble1 User-defined numeric data, usually used as a supplementary field for a decimal value.
UserDouble2 User-defined numeric data, usually used as a supplementary field for a decimal value.
UserDouble3 User-defined numeric data, usually used as a supplementary field for a decimal value.
UserDouble4 User-defined numeric data, usually used as a supplementary field for a decimal value.
UserDouble5 User-defined numeric data, usually used as a supplementary field for a decimal value.
UpdateStamp Timestamp of when the subject was last modified.
PassActualArriveTime Actual arrival time of the vehicle when the PASS event was performed. Value is in seconds from midnight.
PassActualDepartTime Actual time that the vehicle departed after performing the PASS event. Value is in seconds from midnight.
PassDropoffLandmark Address name for the PASS booking drop off leg.
PassEstTime Estimated time that the PASS trip event will be performed. Value is in seconds from midnight.
PassPickupLandmark Address name for the PASS booking pickup leg.
LineAbbr Abbreviated name of the line. If context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from MasterLines.LineAbbr. If the property is set to ComDailyOperations, the value is from ComDailyOperations.LineAbbr.
EmployeeDetail Detailed information about the driver. Typically, a formatted string including the LastName, FirstName, BadgeNum and EmployeeId.
BadgeNum Badge number of the driver. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Employees.Badgenum. If the property is set to ComDailyOperations, the value is from ComDailyOperations.BadgeNum.
DirectionName Name of the line direction. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Line.DirectionName. If the property is set to ComDailyOperations, the value is from ComDailyOperations.DirectionName.
VehicleNumber Number of the vehicle. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Vehicles.VehicleNumber. If the property is set to ComDailyOperations, the value is from ComDailyOperations.VehicleNumber.
ReportGroupId Report group identifier from ReportGroups.ReportGroupId. References the report group the subject belongs to.
StopNum Stop number assigned to the stop where the issue occurred.
ReplyMethod Communication mode used to reply to the customer.
ServiceGroupId Service group identifier from ServiceGroup.ServiceGroupId.
BlockName Name of the block. If the context property 'COM/OPS/System' is set to Trapeze5 or Trapeze6, The value is from Trips.BlockName. If the property is set to ComDailyOperations, the value is from ComDailyOperations.BlockName.
Valid Indicates whether or not the subject is valid.
FileGroupId File group identifier from FileGroups.FileGroupId. References the subject's attachments.
PenaltyCostProcessed Penalty cost processed for the specific subject.
PenaltyCost Penalty cost for the specific subject.
PenaltyPoints Penalty points for the specific subject.
PenaltyPointsProcessed Penalty points processed for the specific subject.
TripId Trip identifier from Trips.TripId.
TripNum Trip number from Trips.TripNum.
CustomerContacted If true, the customer was contacted.
ContactDate Date when the customer was contacted.
PassReqTime Time that the booking leg was requested for. Value is in seconds from midnight.
CarNumber Car number of the vehicle.
AgencyId Agency identifier from Agencies.AgencyId.
SchId Schedule identifier from Schedules.SchId.
ClientLocationProgId Client location program identifier from ClientLocationProgram.LocationProgId. The field is set only if the context property 'COM/PASS/Using Client Location Program' is true.
VehicleServiceRequestId Vehicle service request identifier for the subject. If a vehicle service request is sent to the AssetWork system, this field is set.
stateDesc COM states for the subject. All available states are separated by ','.
workFlowId COM work flow identifier from COMWorkFlow.WorkFlowId.
SchDivisionId Division identifier from MasterDivisions.DivisionId. References the Schedule division that the specific feedback subject is related to.
BlockId Block ID from fixed route scheduling data.
Adherence Schedule adherence from fixed route scheduling data.
RunId When work Create From MasterRun,
OperatorDivisionId Division ID of operator from fixed route scheduling data.
OperatorDepartmentAbbr Department of operator from fixed route scheduling data.
OperatorDivisionAbbr Division abbreviation of operator from fixed route scheduling data.
VehicleDivisionId Division ID of vehicle from fixed route scheduling data.
VehicleDivisionAbbr Division abbreviation of vehicle from fixed route scheduling data.
IncidentId Incident identifier from OPSIncidents.IncidentId. References the associated incident.
StopAbbr Abbreviation of name of service.
IncidentDetails Incident details of a specific feedback subject.
CallTakerComments Comments from the call taker.
Summary Summary description of the issue.
InvestigatorLog The investigator log for a specific subject.
ResponseToCustomer The response to customer for a specific subject.
ResolutionOfIssue The resolution of issue for a specific subject.