MasterComments

Name: Master Comments

Type: Application

Modules: Fx-TpFxC, Shared-TrafficConditions, Exchange-DataImportLib, Fx-TransXChange, Legacy-Fx, OPS-Lib, OPS-Tps, Reports-Libus, Reports-WMATA

Description: Master list of comments throughout all tables.

Field Documentation
Symbol Used as a legend in reports.
CommentTextId Unique identifier for comments.
CommentAbbr Abbreviated name of the comment.
CommentText Body of the comment.
CommentType Comment type: 1 = System Wide, 2 = Route Dependent, 3 = Service Group Dependent.
CommentGroupId Comment group identifier from CommentGroups.CommentGroupId.
Val1 For route dependent comments: MasterLine.LineId. For service group dependent comments: MasterServiceGroup.ServiceGroupId.
Val2 For internal use.
Val3 For internal use.
Val4 For internal use.
ModBy Name of the user that last modified the comment.
ModDate Date on which the comment was last modified.
ModTime Time at which the comment was last modified. Value is in seconds from midnight.
CommentInfo For internal use.