PAY TIAA CREF Transmission Report (ASCII)

Description
Categories: BI Publisher
Columns: Assg1, Ssn1, Ra Gra Plan By Inst1, Ra Gra Plan Reduct1, Ra Plan Deduct1, Ra Addl Reduct1, Ra Addl Deduct1, Sra Gsra Reduct1, Cf Ra Gra Plan By Inst, Cf Ra Gra Plan Reduct ...
Application: Payroll
Source: TIAA CREF Transmission Report (ASCII) (XML)
Short Name: PAYUSTIM_XML
DB package: PAY_PAYUSTIM_XMLP_PKG
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,'-')
Parameter Name SQL text Validation
PPA_FINDER
 
DES_TYPE