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 | |||