Result Set 12 - Genealogy Input Events

The following table lists the parameters used in a Genealogy Input Events Result Set.

Order	Field Name	Req	Values/Table Reference
0	Result Set Type	X	12
1	Update Type	X	0 - Post-Update. Data already in database and sent to clients only. 1 - Pre-Update. Database Manager writes to database and sends to client.
2	User Id	X	PrdExec_Input_Event (User_Id) Users (User_Id)
3	Transaction Type	X	1 = Add 2 = Update 3 = Delete
4	Transaction Number	X	0 – Update fields that are not null to the new values. 2 – Update all fields of Event_Details to the values in Result Set. Values of 0 for dimensions are set to null.
5	Timestamp	X	PrdExec_Input_Event (TimeStamp)
6	Entry On		PrdExec_Input_Event (Entry_On)
7	Comment Id		PrdExec_Input_Event (Comment_Id) Comments (Comment_Id)
8	Production Event Input Id		PrdExec_Input_Event (PEI_Id) PrdExec_Inputs (PEI_Id)
9	Production Event Input Position Id		PrdExec_Input_Event (PEIP_Id) PrdExec_Input_Positions (PEIP_Id)
10	Event Id		PrdExec_Input_Event (Event_Id) Events (Event_Id)
11	Dimension X		PrdExec_Input_Event (Dimension_X)
12	Dimension Y		PrdExec_Input_Event (Dimension_Y)
13	Dimension Z		PrdExec_Input_Event (Dimension_Z)
14	Dimension A		PrdExec_Input_Event (Dimension_A)
15	Unloaded		PrdExec_Input_Event (Unloaded)
16	ESignature		Signature ID from the ESignature table