BEN Dependent Eligibility Audit Log

Description
Categories: BI Publisher
Columns: Person Id1, Dpnt Pgm Name, Dpnt Pl Name, Dpnt Opt Name, Dpnt Name, Dpnt Strt Dt, Dpnt Thru Dt, Date Of Birth, Relationship, Student Status ...
Application: Advanced Benefits
Source: Dependent Eligibility Audit Log (XML)
Short Name: BENDEAUD_XML
DB package: BEN_BENDEAUD_XMLP_PKG
            select
            a.person_id person_id1,
            pgm.name dpnt_pgm_name,
            pl.name dpnt_pl_name,
            opt.name dpnt_opt_name,
            b.full_name  dpnt_name,
            a.enrt_cvg_strt_dt dpnt_strt_dt,
            a.enrt_cvg_thru_dt dpnt_thru_dt,
            b.date_of_birth date_of_birth,
            HR_GENERAL.DECODE_LOOKUP('CONTACT',a.contact_typ_cd) relationship,
            HR_GENERAL.DECODE_LOOKUP('STUDENT_STATUS',b.student_status) student_status,
            hrl3.meaning disability_status
            from
                    per_all_people_f b,
                    ben_pgm_f pgm,
                    ben_pl_f pl,
                    ben_oipl_f oipl