Table: dbo.Magnetic_Media_File
Columns
Name | Type | Constraints | Description
magnetic_media_file_KEY | int (4) | NOT NULL | Key for the magnetic media file
period_end_date | smalldatetime (4) | NOT NULL | Period end date for the file.
magnetic_media_file_status_KEY | int (4) | NOT NULL | Key for the status of the magnetic media file.
creation_date | datetime (8, 3) | NOT NULL | The date and time that the file was created.
tax_form_KEY | int (4) | NOT NULL | Foreign key to the tax form this file is for.
staff_KEY | int (4) |  | The staff member that created or queued the file, or null if files aren't being saved by staff
magnetic_media_file_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each magnetic media file row.
is_corrected | bit (1) | NOT NULL | Whether or not the file is a corrected 1099 file.
last_modified | datetime (8, 3) | NOT NULL | The date and time that the file was last modified.
batch_number | int (4) |  | The assigned file batch number if it exists, null if it doesn't exist.
separate_client_files | bit (1) | NOT NULL | Column is dependent on the value present in magnetic_media_file_status_KEY column. For Queued status - It indicates that whether or not separate internet files will be created for each client. 1 means that separate internet files will be created for each client; 0 means that a single internet file (bulk file) will be created for selected clients. For Completed or Created status - It indicates that whether or not separate internet files were created for each client. 1 means that separate internet files were created for each client; 0 means that a single internet file (bulk file) was created for selected clients. For Deleted status - This column is ignored for Deleted status.

Primary key
Name | Columns | Description
PK_Magnetic_Media_File | magnetic_media_file_KEY |
Unique constraints
Name | Columns | Description
UK_Magnetic_Media_File$magnetic_media_file_guid | magnetic_media_file_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Magnetic_Media_File__Magnetic_Media_File_Status__magnetic_media_file_status_KEY | magnetic_media_file_status_KEY | Magnetic_Media_File_Status (magnetic_media_file_status_KEY) |
FK_Magnetic_Media_File__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |
FK_Magnetic_Media_File__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Magnetic_Media_File_Client__Magnetic_Media_File__magnetic_media_file_KEY | magnetic_media_file_KEY | Magnetic_Media_File_Client |
FK_Magnetic_Media_File_Record__Magnetic_Media_File__magnetic_media_file_KEY | magnetic_media_file_KEY | Magnetic_Media_File_Record |
FK_Magnetic_Media_File_N_Tax_Agent__Magnetic_Media_File__magnetic_media_file_KEY | magnetic_media_file_KEY | Magnetic_Media_File_N_Tax_Agent |