TI_Legacy_RemarkContext
Name: TI_Legacy_Remark Context
Type: Application
Modules: Info
Description: Stores the same information as InfoRemarkContext, but with the
RemarkContextString split into separate fields. Only four remark types are supported
currently: general, line, stop, and linestop.
Note: This table does not need to be
manipulated directly; triggers exist in InfoRemarkContext to maintain data.
| Field | Documentation |
|---|---|
| RemarkId | Remark identifier from InfoRemarks.RemarkId. |
| RemarkCategory | Remark category identifier from InfoRemarkCategory.RemarkCategory. |
| RemarkContextString | Separated strings (marked with '/') together with the Remark Category identify the 'info element' (Line, Stop, Pattern,) that the remark relates to. |
| Agency Id | TBD |
| LineIdConst | Line identifier from MasterLine.LineIdConst. References line across sign-up periods. If set to 0, this rule applies to all lines that do not have a record in the table (Generic Rule). |
| StopId | TBD |
| LineDirIdConst | Unique identifier of the line within a sign-up period. The same line in different sign-up periods has a different LineDirId but the same LineDirIdConst. |