EVENT_MASTER

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