View: dbo.Client_Processing_Note_View
View definition
create view dbo.Client_Processing_Note_View
as
select
client_processing_note_KEY = PN.processing_note_KEY,
client_KEY = PN.client_KEY,
note = PN.note,
created_date = PN.created_date,
created_date__staff_KEY = PN.created_date__staff_KEY,
edited_date = PN.edited_date,
edited_date__staff_KEY = PN.edited_date__staff_KEY,
processing_note_category_KEY = PN.processing_note_category_KEY,
engagement_item_note_KEY = PN.engagement_item_note_KEY,
processing_note_type_KEY = PN.processing_note_type_KEY,
sequence_number = PN.sequence_number
from
dbo.Processing_Note as PN
where
PN.processing_note_type_KEY = 2