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
)