| Holds Electronic file records. These records are stored outside the database and also transmitted to the Connect server. |
| elf_file_KEY | int (4) | NOT NULL | Key for the elf file |
| client_KEY | int (4) | NOT NULL | The client id for this client record |
| period_end_date | smalldatetime (4) | NOT NULL | Period end date for the file. |
| payment_date | smalldatetime (4) | | Payment date for the file format. |
| form_data_xml | nvarchar (-1) | | The column descriptor for the form data xml column. |
| tax_form_KEY | int (4) | NOT NULL | Foreign key to the tax form this file is for. |
| file_name | nvarchar (200) | NOT NULL | The 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_number | int (4) | | Filing Number - nth number of return for forms that support multiple filings. NULL if the form does not support multiple filings. |
| federal_tin | nvarchar (22) | NOT NULL | The Federal TIN or SSN for the Client at the time the electronic file was generated. |
| account_number | nvarchar (-1) | NOT NULL | The Account number at the time the electronic file was generated. |
| is_corrected | bit (1) | NOT NULL | 1 when the file is a corrected 1099 file, 0 otherwise |