
			select
				e.Evn_id as "Evn_id"
				,e.Evn_pid as "Evn_pid"
				,e.Evn_rid as "Evn_rid"
				,to_char(e.Evn_setDT, 'yyyy-mm-dd hh24:mi:ss') as "Evn_setDT"
				,e.EvnClass_SysNick as "EvnClass_SysNick"
				,coalesce(e.Evn_IsSigned, 1) as "Evn_IsSigned"
				,e.Person_id as "Person_id"
				,e.Lpu_id as "Lpu_id"
			from v_Evn e
			where  e.Evn_rid = '500801005615816'
			union 
			select
				e.Evn_id as "Evn_id"
				,e.Evn_pid as "Evn_pid"
				,e.Evn_rid as "Evn_rid"
				,to_char(e.Evn_setDT, 'yyyy-mm-dd hh24:mi:ss') as "Evn_setDT"
				,e.EvnClass_SysNick as "EvnClass_SysNick"
				,coalesce(e.Evn_IsSigned, 1) as "Evn_IsSigned"
				,e.Person_id as "Person_id"
				,e.Lpu_id as "Lpu_id"
			from v_Evn e
			where  e.Evn_pid = '500801005615816'
			union 
			select
				e.Evn_id as "Evn_id"
				,e.Evn_pid as "Evn_pid"
				,e.Evn_rid as "Evn_rid"
				,to_char(e.Evn_setDT, 'yyyy-mm-dd hh24:mi:ss') as "Evn_setDT"
				,e.EvnClass_SysNick as "EvnClass_SysNick"
				,coalesce(e.Evn_IsSigned, 1) as "Evn_IsSigned"
				,e.Person_id as "Person_id"
				,e.Lpu_id as "Lpu_id"
			from v_Evn pe
			inner join v_Evn e on e.Evn_pid = pe.Evn_id
			where pe.Evn_pid = '500801005615816'
			union 
			select
				e.Evn_id as "Evn_id"
				,e.Evn_pid as "Evn_pid"
				,e.Evn_rid as "Evn_rid"
				,to_char(e.Evn_setDT, 'yyyy-mm-dd hh24:mi:ss') as "Evn_setDT"
				,e.EvnClass_SysNick as "EvnClass_SysNick"
				,coalesce(e.Evn_IsSigned, 1) as "Evn_IsSigned"
				,e.Person_id as "Person_id"
				,e.Lpu_id as "Lpu_id"
			from v_Evn e
			where e.Evn_id = '500801005615816'
		
