Result Set 11 - Genealogy Event Components

Order

Field Name

Req

Values/Table Reference

0

Result Set Type

X

11

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

Event_Components (User_Id)

Users (User_Id). Allows a specific User_Id to be used and tracked. If not using a specific User_Id account then set it to 0 and the appropriate Service User_Id will be used.

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

Component Id

X*

Event_Components (Component_Id)

6

Event Id

X

Event_Components (Event_Id)

Events (Event_Id)

7

Source Event Id

X

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)

12

Start Coordinate X

Event_Components (Start_Coordinate_X)

13

Start Coordinate Y

Event_Components (Start_Coordinate_Y)

14

Start Coordinate Z

Event_Components (Start_Coordinate_Z)

15

Start Coordinate A

Event_Components (Start_Coordinate_A)

16

Start Time

Event_Components (Start_Time)

17

Timestamp

Event_Components (Timestamp)

18

Parent Component Id

Event_Components (Parent_Component_Id)

19

Entry On

Event_Components (Entry_On)

20

Extended Info

Event_Components (Extended_Info)

21

Production Excecution Input ID

Event_Components (PEI_Id)

22

ReportAsConsumption

Event_Components (Report_As_Consumption)

23

Child Unit ID

24

ESignature

Signature ID from the ESignature table