View: dbo.Magnetic_Media_File_View
View definition
-- Create the Magnetic Media Files View
CREATE VIEW dbo.Magnetic_Media_File_View
AS
SELECT
MMF.magnetic_media_file_KEY
, MMF.period_end_date
, MMF.magnetic_media_file_status_KEY
, MMF.creation_date
, MMF.last_modified
, MMF.tax_form_KEY
, MMF.staff_KEY
, MMF.magnetic_media_file_guid
, CONVERT(INT, TF.ste_state_code_KEY) AS state_KEY -- table doesn't allow null so don't worry about it here.
, MMF.is_corrected
, MMF.batch_number
, MMF.separate_client_files
FROM
dbo.Magnetic_Media_File AS MMF
INNER JOIN
dbo.Tax_Form AS TF ON TF.tax_form_KEY = MMF.tax_form_KEY;