org.kuali.kfs.module.cab.batch
Class ExtractStep

java.lang.Object
  extended by org.kuali.kfs.sys.batch.AbstractStep
      extended by org.kuali.kfs.module.cab.batch.ExtractStep
All Implemented Interfaces:
Step, org.springframework.beans.factory.BeanNameAware

public class ExtractStep
extends AbstractStep


Constructor Summary
ExtractStep()
           
 
Method Summary
 boolean execute(String jobName, Date jobRunDate)
          CAB Extract Steps Find all GL transactions created after last extract time matching CAB filter parameters For each GL line perform the following steps Check GL lines belongs to a PO or Not If not PO related, then check for duplicate in CB_GL_ENTRY_T, if not duplicate insert into CB_GL_ENTRY_T If PO related, check against PURAP Account Line Revision History for respective PREQ or CM document If sum of amounts matches grouped by fields "univ_fiscal_yr, fin_coa_cd, account_nbr, sub_acct_nbr, fin_object_cd, fin_sub_obj_cd, univ_fiscal_prd_cd, fdoc_nbr, fdoc_ref_nbr" then it is a valid one, else ignore the GL lines for the document and write to the reconciliation report If CB_PUR_DOC entry doesn't exist, insert new record else update active indicator Insert into CB_PUR_ITM_AST_T when record not exists or inactive, if active exact match found then skip Insert one/multiple entries into CB_PUR_LN_AST_ACCT_T, amount should match exact from account line history
 BatchExtractReportService getBatchExtractReportService()
          Gets the batchExtractReportService attribute.
 BatchExtractService getBatchExtractService()
          Gets the batchExtractService attribute.
 org.kuali.rice.kns.service.DateTimeService getDateTimeService()
          Gets the dateTimeService attribute.
 void setBatchExtractReportService(BatchExtractReportService batchExtractReportService)
          Sets the batchExtractReportService attribute value.
 void setBatchExtractService(BatchExtractService batchExtractService)
          Sets the batchExtractService attribute value.
 void setDateTimeService(org.kuali.rice.kns.service.DateTimeService dateTimeService)
          Sets the dateTimeService attribute value.
 
Methods inherited from class org.kuali.kfs.sys.batch.AbstractStep
getName, getParameterService, interrupt, isInterrupted, setBeanName, setInterrupted, setParameterService
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ExtractStep

public ExtractStep()
Method Detail

execute

public boolean execute(String jobName,
                       Date jobRunDate)
                throws InterruptedException
CAB Extract Steps
  • Find all GL transactions created after last extract time matching CAB filter parameters
  • For each GL line perform the following steps
  • Check GL lines belongs to a PO or Not
  • If not PO related, then check for duplicate in CB_GL_ENTRY_T, if not duplicate insert into CB_GL_ENTRY_T
  • If PO related, check against PURAP Account Line Revision History for respective PREQ or CM document
  • If sum of amounts matches grouped by fields "univ_fiscal_yr, fin_coa_cd, account_nbr, sub_acct_nbr, fin_object_cd, fin_sub_obj_cd, univ_fiscal_prd_cd, fdoc_nbr, fdoc_ref_nbr" then it is a valid one, else ignore the GL lines for the document and write to the reconciliation report
  • If CB_PUR_DOC entry doesn't exist, insert new record else update active indicator
  • Insert into CB_PUR_ITM_AST_T when record not exists or inactive, if active exact match found then skip
  • Insert one/multiple entries into CB_PUR_LN_AST_ACCT_T, amount should match exact from account line history
  • Parameters:
    jobName - the name of the job running the step
    jobRunDate - the time/date the job is executed
    Returns:
    true if successful and continue the job, false if successful and stop the job
    Throws:
    InterruptedException
    See Also:
    org.kuali.kfs.batch.Step#execute(java.lang.String, java.util.Date)

    getBatchExtractService

    public BatchExtractService getBatchExtractService()
    Gets the batchExtractService attribute.

    Returns:
    Returns the batchExtractService.

    setBatchExtractService

    public void setBatchExtractService(BatchExtractService batchExtractService)
    Sets the batchExtractService attribute value.

    Parameters:
    batchExtractService - The batchExtractService to set.

    getDateTimeService

    public org.kuali.rice.kns.service.DateTimeService getDateTimeService()
    Gets the dateTimeService attribute.

    Overrides:
    getDateTimeService in class AbstractStep
    Returns:
    Returns the dateTimeService.

    setDateTimeService

    public void setDateTimeService(org.kuali.rice.kns.service.DateTimeService dateTimeService)
    Sets the dateTimeService attribute value.

    Overrides:
    setDateTimeService in class AbstractStep
    Parameters:
    dateTimeService - The dateTimeService to set.

    getBatchExtractReportService

    public BatchExtractReportService getBatchExtractReportService()
    Gets the batchExtractReportService attribute.

    Returns:
    Returns the batchExtractReportService.

    setBatchExtractReportService

    public void setBatchExtractReportService(BatchExtractReportService batchExtractReportService)
    Sets the batchExtractReportService attribute value.

    Parameters:
    batchExtractReportService - The batchExtractReportService to set.


    Copyright © 2005-2012 The Kuali Foundation. All Rights Reserved.