View: dbo.Bank_View | |||
View definition | |||
CREATE VIEW dbo.Bank_View AS SELECT Bank.bank_KEY , Bank.bank_name , Bank.routing_number , Bank.fractional_routing_number , Bank.comments , Bank.contact_KEY , Bank.record_status_KEY , Bank.is_international_bank , Bank.restrict_bank_client_access -- NOT Bank.existing_bad_data , CT.primary__contact_phone_type_KEY AS contact__primary__contact_phone_type_KEY , CT.primary__contact_address_type_KEY AS contact__primary__contact_address_type_KEY , CT.mailing__contact_address_type_KEY AS contact__mailing__contact_address_type_KEY , CT.contact_type_KEY AS contact__contact_type_KEY , CT.primary__contact_email_type_KEY AS contact__primary__contact_email_type_KEY , Record_Status.description AS record_status__description -- Column added to match with the Active_Status View for Status Filter. -- Null value suggests that the row is virtually deleted. , CASE WHEN Bank.record_status_KEY = 1 THEN 1 WHEN Bank.record_status_KEY = 2 THEN 2 ELSE NULL END AS active_status_KEY FROM dbo.Bank AS Bank LEFT OUTER JOIN dbo.Contact AS CT ON CT.contact_KEY = Bank.contact_KEY LEFT OUTER JOIN dbo.Record_Status AS Record_Status ON Record_Status.record_status_KEY = Bank.record_status_KEY ; | |||