ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3093869E053B46B63588994Y select purt1.attribute5 ASSG1, replace(purt1.attribute9,'-') SSN1, --select purt1.attribute5 ASSG, -- replace(purt1.attribute9,'-') SSN, sum(purt1.value2) RA_GRA_PLAN_BY_INST1, sum(purt1.value3) RA_GRA_PLAN_REDUCT1, sum(purt1.value4) RA_PLAN_DEDUCT1, sum(purt1.value5) RA_ADDL_REDUCT1, sum(purt1.value6) RA_ADDL_DEDUCT1, sum(purt1.value7) SRA_GSRA_REDUCT1, PAY_PAYUSTIM_XMLP_PKG.cf_ra_gra_plan_by_instformula(sum ( purt1.value2 )) CF_RA_GRA_PLAN_BY_INST, PAY_PAYUSTIM_XMLP_PKG.cf_ra_gra_plan_reductformula(sum ( purt1.value3 )) CF_RA_GRA_PLAN_REDUCT, PAY_PAYUSTIM_XMLP_PKG.cf_ra_plan_deductformula(sum ( purt1.value4 )) CF_RA_PLAN_DEDUCT, PAY_PAYUSTIM_XMLP_PKG.cf_ra_addl_reductformula(sum ( purt1.value5 )) CF_RA_ADDL_REDUCT, PAY_PAYUSTIM_XMLP_PKG.cf_ra_addl_deductformula(sum ( purt1.value6 )) CF_RA_ADDL_DEDUCT, PAY_PAYUSTIM_XMLP_PKG.cf_sra_gsra_reductformula(sum ( purt1.value7 )) CF_SRA_GSRA_REDUCT from pay_us_rpt_totals purt1 where purt1.tax_unit_id = :pactid and purt1.attribute1 <> 'TIAA-CREF' and purt1.attribute12 = :payment_mode and purt1.attribute14 is null and purt1.attribute5=:Assg group by purt1.attribute5, replace(purt1.attribute9,'-') PAY PAYUSTIM_XML US PAY TIAA CREF Transmission Report (ASCII) Application: Payroll Source: TIAA CREF Transmission Report (ASCII) (XML) Short Name: PAYUSTIM_XML DB package: PAY_PAYUSTIM_XMLP_PKG BI Publisher :assg :chnkno :cp_business_group_name :cp_consolidation_set_name :cp_gre_name :cp_payroll_name :cp_print_set_payroll_name :des_type :no_copies :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_debug :p_dimension_name :p_end_date :p_gre_id :p_payroll_id :p_report_title :p_sort1 :p_sort2 :p_sort3 :p_start_date :pactid :payment_mode :ppa_finder :t_end_date :t_start_date 1 10 :ppa_finder Char Y US PPA_FINDER 2 20 :des_type Char US DES_TYPE