EVENT_MASTER
As the name indicates this is the master table which most tables are depended on. The primary purpose of EVENT_MASTER is to control the status of a job. The secondary role of the table is to provide user defined classification, grouping, labeling etc. This is made possible with a number of generic fields in different types. EVENT_MASTER delete is cascaded in all related tables.
| Column | Required (not Null) | Type | Values | Comments |
| gKey | Yes | Uniqueidentifier | ||
| Created_By | Yes | Varchar (50) | ||
| Created_On | Yes | Datetime | Auto generated | |
| Status | Yes | Integer | -1 = In progress 0 = Ready for processing |
Default value for the field is -1 i.e. in progress. |
| Source | Integer | User defined field. Recommended to be used to indicate the application source for the outgoing message | ||
| Int1 | Integer | User Defined Field | ||
| Int2 | Integer | User Defined Field | ||
| Int3 | Integer | User Defined Field | ||
| Int4 | Integer | User Defined Field | ||
| Int5 | Integer | User Defined Field | ||
| Int6 | Integer | User Defined Field | ||
| Int7 | Integer | User Defined Field | ||
| Int8 | Integer | User Defined Field | ||
| Int9 | Integer | User Defined Field | ||
| Str1 | Varchar (250) | User Defined Field | ||
| Str2 | Varchar (250) | User Defined Field | ||
| Str3 | Varchar (250) | User Defined Field | ||
| Str4 | Varchar (250) | User Defined Field | ||
| Str5 | Varchar (250) | User Defined Field | ||
| Dte1 | Datetime | User Defined Field | ||
| Dte2 | Datetime | User Defined Field | ||
| Dte3 | Datetime | User Defined Field | ||
| Dte4 | Datetime | User Defined Field | ||
| Dte5 | Datetime | User Defined Field | ||
| Flt1 | Float | User Defined Field | ||
| Flt2 | Float | User Defined Field | ||
| Flt3 | Float | User Defined Field | ||
| Flt4 | Float | User Defined Field | ||
| Flt5 | Float | User Defined Field | ||
| Uid1 | Uniqueidentifier | User Defined Field | ||
| Uid2 | Uniqueidentifier | User Defined Field | ||
| Uid3 | Uniqueidentifier | User Defined Field | ||
| Uid4 | Uniqueidentifier | User Defined Field | ||
| Uid5 | Uniqueidentifier | User Defined Field |