Table: dbo.Magnetic_Media_File
Columns
NameTypeConstraintsDescription
magnetic_media_file_KEYint (4)NOT NULLKey for the magnetic media file
period_end_datesmalldatetime (4)NOT NULLPeriod end date for the file.
magnetic_media_file_status_KEYint (4)NOT NULLKey for the status of the magnetic media file.
creation_datedatetime (8, 3)NOT NULLThe date and time that the file was created.
tax_form_KEYint (4)NOT NULLForeign key to the tax form this file is for.
staff_KEYint (4)The staff member that created or queued the file, or null if files aren't being saved by staff
magnetic_media_file_guiduniqueidentifier (16)NOT NULLA unique identifer for each magnetic media file row.
is_correctedbit (1)NOT NULLWhether or not the file is a corrected 1099 file.
last_modifieddatetime (8, 3)NOT NULLThe date and time that the file was last modified.
batch_numberint (4)The assigned file batch number if it exists, null if it doesn't exist.
separate_client_filesbit (1)NOT NULLColumn 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
NameColumnsDescription
PK_Magnetic_Media_Filemagnetic_media_file_KEY
Unique constraints
NameColumnsDescription
UK_Magnetic_Media_File$magnetic_media_file_guidmagnetic_media_file_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Magnetic_Media_File__Magnetic_Media_File_Status__magnetic_media_file_status_KEYmagnetic_media_file_status_KEYMagnetic_Media_File_Status (magnetic_media_file_status_KEY)
FK_Magnetic_Media_File__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
FK_Magnetic_Media_File__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Magnetic_Media_File_Client__Magnetic_Media_File__magnetic_media_file_KEYmagnetic_media_file_KEYMagnetic_Media_File_Client
FK_Magnetic_Media_File_Record__Magnetic_Media_File__magnetic_media_file_KEYmagnetic_media_file_KEYMagnetic_Media_File_Record
FK_Magnetic_Media_File_N_Tax_Agent__Magnetic_Media_File__magnetic_media_file_KEYmagnetic_media_file_KEYMagnetic_Media_File_N_Tax_Agent

Schema diagram