Table: dbo.Elf_File
Holds Electronic file records. These records are stored outside the database and also transmitted to the Connect server.
Columns
NameTypeConstraintsDescription
elf_file_KEYint (4)NOT NULLKey for the elf file
client_KEYint (4)NOT NULLThe client id for this client record
period_end_datesmalldatetime (4)NOT NULLPeriod end date for the file.
payment_datesmalldatetime (4)Payment date for the file format.
form_data_xmlnvarchar (-1)The column descriptor for the form data xml column.
tax_form_KEYint (4)NOT NULLForeign key to the tax form this file is for.
file_namenvarchar (200)NOT NULLThe external file name that is used by Connect and returned in the acknowledgement data stream. Empty filename means that the record was created before this column was added.
filing_numberint (4)Filing Number - nth number of return for 1099 MISC and NEC and for others forms value is NULL
federal_tinnvarchar (22)NOT NULLThe Federal TIN or SSN for the Client at the time the electronic file was generated.
account_numbernvarchar (-1)NOT NULLThe Account number at the time the electronic file was generated.
is_correctedbit (1)NOT NULL1 when the file is a corrected 1099 file, 0 otherwise
Primary key
NameColumnsDescription
PK_Elf_Fileelf_file_KEY
Unique constraints
NameColumnsDescription
UK_Elf_File$client_KEY$period_end_date$tax_form_KEY$filing_numberclient_KEY, period_end_date, tax_form_KEY, filing_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Elf_File__Client__client_KEYclient_KEYClient (client_KEY)
FK_Elf_File__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Elf_Transmission__Elf_File__elf_file_KEYelf_file_KEYElf_Transmission
FK_Payable_Transaction_N_Elf_File__Elf_File__elf_file_KEYelf_file_KEYPayable_Transaction_N_Elf_File

Schema diagram