View: dbo.Enter_Transaction_Data_Entry_Session_View | |||
View definition | |||
CREATE VIEW dbo.Enter_Transaction_Data_Entry_Session_View AS ( SELECT gl_transaction_KEY = x.gl_transaction_KEY, -- we need the staff key to be based off of the 'client access' field here. That way we're sure to -- keep the 'data entry session' concept seperate for a given staff member based on what program -- was running when this record was created: Acs or Client Access. staff_KEY = case when x.only_for_client_access = 1 then -x.staff_KEY else x.staff_KEY end FROM dbo.Enter_Transaction_Data_Entry_Session_Element as x ) | |||