Table: dbo.Elf_Transmission
Columns
Name | Type | Constraints | Description
elf_transmission_KEY | int (4) | NOT NULL | Key for the Elf Transmission
elf_file_KEY | int (4) | NOT NULL | Key into the associated ELF File table for the current row
elf_transmission_status_KEY | int (4) | NOT NULL | The current transmission status
status_change_date | datetime (8, 3) | NOT NULL | The date that the status of the file has changed.
ack_data_xml | nvarchar (-1) |  | The data from the acknowledgement file.
connect_event_id | bigint (8) | NOT NULL | The associated event id from Connect. This connect_event_id will be used to determine the chronological order of events when multiple events take place at the same time.
submission_id | nvarchar (-1) | NOT NULL | The submission id that corresponds to this transmission event. Not all events will have a submission id. This will be the empty string for events without a submission id.

Primary key
Name | Columns | Description
PK_Elf_Transmission | elf_transmission_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Elf_Transmission__Elf_File__elf_file_KEY | elf_file_KEY | Elf_File (elf_file_KEY) |
FK_Elf_Transmission__Elf_Transmission_Status__elf_transmission_status_KEY | elf_transmission_status_KEY | Elf_Transmission_Status (elf_transmission_status_KEY) |