BEN Life Events Summary

Description
Categories: BI Publisher, Human Resources
Columns: Per In Ler Id1, Per Id Rep3, Pername3, Perssn3, Loc Id Plan Rep3, Perloc3, Ler Id Plan Rep3, Lername3, Lestat3, Lertype3 ...
Application: Advanced Benefits
Source: Life Events Summary Report (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
select 
	distinct pil.per_in_ler_id PER_IN_LER_ID1,
	pil.person_id per_id_rep3,
	per.full_name PERNAME3,
	per.national_identifier PERSSN3,
	loc.location_id loc_id_plan_rep3,
	loc_tl.location_code PERLOC3,
	pil.ler_id ler_id_plan_rep3,
	ler_tl.name LERNAME3,
	hr_general.decode_lookup('BEN_PER_IN_LER_STAT', per_in_ler_stat_cd) LESTAT3,
	hr_general.decode_lookup('BEN_LER_TYP', ler.typ_cd) LERTYPE3,
	pil.lf_evt_ocrd_dt LEOCRDDT3,
	pil.ntfn_dt ntfn_dt_plan_rep3,
	pln.pl_id pl_id_plan_rep3,
	pln.name pl_name_plan_rep3,
	attr.counter COUNTER1, 
	dff1.form_left_prompt segment_prompt_text1,
	attr.col_name col_name1, 
	decode(attr.counter, 
			1,PIL.PIL_ATTRIBUTE1 ,
			2,PIL.PIL_ATTRIBUTE2 , 
			3,PIL.PIL_ATTRIBUTE3 ,
			4,PIL.PIL_ATTRIBUTE4 ,
			5,PIL.PIL_ATTRIBUTE5 , 
			6,PIL.PIL_ATTRIBUTE6 ,
			7,PIL.PIL_ATTRIBUTE7 ,
			8,PIL.PIL_ATTRIBUTE8 , 
			9,PIL.PIL_ATTRIBUTE9 ,
			10,PIL.PIL_ATTRIBUTE10 ,
			11,PIL.PIL_ATTRIBUTE11 ,
			12,PIL.PIL_ATTRIBUTE12 , 
			13,PIL.PIL_ATTRIBUTE13 ,
			14,PIL.PIL_ATTRIBUTE14 ,
			15,PIL.PIL_ATTRIBUTE15 , 
			16,PIL.PIL_ATTRIBUTE16 ,
			17,PIL.PIL_ATTRIBUTE17 ,
			18,PIL.PIL_ATTRIBUTE18 , 
			19,PIL.PIL_ATTRIBUTE19 ,
			20,PIL.PIL_ATTRIBUTE20 ,
			21,PIL.PIL_ATTRIBUTE21 ,
			22,PIL.PIL_ATTRIBUTE22 , 
			23,PIL.PIL_ATTRIBUTE23 ,
			24,PIL.PIL_ATTRIBUTE24 ,
			25,PIL.PIL_ATTRIBUTE25 , 
			26,PIL.PIL_ATTRIBUTE26 ,
			27,PIL.PIL_ATTRIBUTE27