operatorPriorities log
{ts '2025-02-25 08:51:59'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:52:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:52:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:53:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:53:19'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:55:36'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:55:39'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:55:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:56:04'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:56:18'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:56:30'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:58:12'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:58:15'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 08:58:38'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:00:54'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:01:04'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:01:27'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:02:05'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:02:21'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:05:04'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:05:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:05:21'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:05:33'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:05:43'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:00'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:10'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:20'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:30'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:32'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:46'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:06:56'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:14'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:22'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:34'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:47'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:54'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:07:59'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:09'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:15'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:45'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:55'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:57'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:58'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:57:59'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:00'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:02'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:05'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:06'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:09'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:11'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 09:58:14'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:37:01'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:37:04'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:37:11'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:37:20'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:37:24'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:43:45'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:43:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:43:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO

{ts '2025-02-25 10:44:06'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with priorities as (

    select cp.priorityId, cp.priorityCode, cp.profileRequirementConfig, cp.callFreqThresholdWks
	from tbl_OPR_CLientPriorities cp with (nolock)
    where ownerId = @ownerId
	and ownerType = @ownerType
    and active = 'Y'

    )

    


, priorities_mappedData as (

	select *
		
	  from priorities

)

, priorities_preData as (

	
	select *
	  from priorities_mappedData with (nolock)

	
	
	where [priorityCode] = '?' 


	)

	, priorities_data as (

		select * 
		        
		  from priorities_preData
		  

	)



	, priorities_return as (
		select * from priorities_data
		where 1 = 1


	order by priorityCode
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, priorities_result as (
		select ( select count(*) from priorities_data ) as totalCount, 
			   
		       ( select * from priorities_return for json auto, include_null_values ) as data
		)


	select * from priorities_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 496
-- CHO