OPSBulletins

Name: OPS Bulletins

Type: Application

Modules: OPS-Dispatch, OPS-Web

Description: Stores bulletins that need to be broadcasted to employees based on their division and/or work details.

Field Documentation
BulletinId Bulletin identification.
FromDate The from date of the date range for this bulletin.
ToDate The to date of the date range for this bulletin.
WeekTemplate Indicates the days of the week during which the bulletin is valid.
DivisionList The comma delimited division list for which the bulletin is valid.
EmployeeTypeList The comma delimited employee type list for which the document bulletin is valid.
BulletinType The type of bulletin. 1 - Generic 2 - Detour 3 - Document
DetourType The type of detour. 1 - Line 2 - Line Group 3 - Work
BulletinMessage The body of the bulletin message to be broadcast.
LineAbbr The line for which the bulletin is applicable.
LineGroupAbbr The line group for which the bulletin is applicable.
WorkName.OPSBulletins The work name for which the bulletin is applicable.
FileGroupId The file group identifier associated with the bulletin.
ModBy Last time the record was modified.
ModDate The date the row was last modified.
ModTime The time the row was last modified.
ModAction TBD