Genealogy Event Components

Order Field Name Values/Table Reference
0 Result Set Type 11
1 Update Type
  • 0 = Pre-Update
  • 1 = Post-Update
2 User Id Event_Components.User_Id

Users.User_Id
3 Transaction Type
  • 1 = Add
  • 2 = Update
  • 3 = Delete
4 Transaction Number
5 Component Id Event_Components.Component_Id
6 Event Id Event_Components.Event_Id

Events.Event_Id
7 Source Event Id Event_Components.Source_Event_Id

Events.Event_Id
8 Dimension X Event_Components.Dimension_X
9 Dimension Y Event_Components.Dimension_Y
10 Dimension Z Event_Components.Dimension_Z
11 Dimension A Event_Components.Dimension_A

If the Transaction Number is set to a ‘0’, it means that a value of ‘0’ returned for any dimension fields will be set to NULL in the database. If the Transaction Number is set to a ‘2’, it means that a value of ‘0’ returned for any dimension fields will be set to ‘0’ in the database.

Example


DECLARE @EventComponents TABLE ( 
      ResultSetType	int DEFAULT 11,
      PreUpdate	    int DEFAULT 0,
      UserId	       int NULL,
      TransType	    int DEFAULT 1,
      TransNum	     int NULL,
      ComponentId	  int NULL,
      EventId	      int NULL,
      SourceEventId	int NULL,
      DimensionX	  float NULL,
      DimensionY	  float NULL,
      DimensionZ	  float NULL,
      DimensionA	  float NULL)