BEN Extract Audit

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Extract Audit Report (XML)
Short Name: BENXAUDT_XML
DB package: BEN_BENXAUDT_XMLP_PKG
SELECT b.name record_name,
       a.business_group_id,
       a.request_id,
       b.ext_rcd_id,
       d.name data_elmt_name,
       c.seq_num,
       a.person_id,
       a.prmy_sort_val,
       a.scnd_sort_val,
       a.trans_seq_num,
       a.rcrd_seq_num,
       a.ext_rslt_dtl_id, 
	BEN_BENXAUDT_XMLP_PKG.business_nameformula(a.business_group_id) business_name, 
	BEN_BENXAUDT_XMLP_PKG.valueformula(b.ext_rcd_id, a.ext_rslt_dtl_id, c.seq_num) value
FROM   ben_ext_rslt_dtl a,
       ben_ext_rcd b,
       ben_ext_data_elmt d,
       ben_ext_data_elmt_in_rcd c
WHERE  a.ext_rcd_id = b.ext_rcd_id
AND    a.ext_rslt_id = :p_request_id
AND    b.ext_rcd_id = c.ext_rcd_id
AND    c.ext_data_elmt_id = d.ext_data_elmt_id
order by a.prmy_sort_val,
              a.scnd_sort_val,
              a.thrd_sort_val,
              c.seq_num
Parameter NameSQL textValidation
Request ID
 
LOV Oracle
Record From
 
Number
Record To
 
Number
Download
Related Blitz Reports
BEN Extract Layout PQP TP MDC Reconciliation Report - Excel Output PQP TP MDC Reconciliation Report - PDF Output BEN Extract Summary BEN Life Events Summary BEN Benefits Confirmation and Summary BEN HIPAA Letter BEN Reconciliation of Premium Contributions to Element Entries BEN COBRA Benefit Initial Information
Blitz Report™