org.kuali.kfs.gl.dataaccess
Interface LedgerEntryBalancingDao

All Known Implementing Classes:

EntryDaoOjb, LaborLedgerEntryDaoOjb

public interface LedgerEntryBalancingDao

DAO interface for the balancing process of ledger entries

Method Summary

Integer	findCountGreaterOrEqualThan(Integer year) Finds the count of rows for >= fiscal year passed in.
Object[]	findEntryByGroup(Integer universityFiscalYear, String chartOfAccountsCode, String financialObjectCode, String financialBalanceTypeCode, String universityFiscalPeriodCode, String transactionDebitCreditCode) Does a group by query on the parameters passed in and returns an object array with the count as first parameter and sum of TRANSACTION_LEDGER_ENTRY_AMOUNT of the second.

Method Detail

findEntryByGroup

Object[] findEntryByGroup(Integer universityFiscalYear,
                          String chartOfAccountsCode,
                          String financialObjectCode,
                          String financialBalanceTypeCode,
                          String universityFiscalPeriodCode,
                          String transactionDebitCreditCode)

Does a group by query on the parameters passed in and returns an object array with the count as first parameter and sum of TRANSACTION_LEDGER_ENTRY_AMOUNT of the second.

Parameters:

universityFiscalYear - the given university fiscal year

chartOfAccountsCode - the given chart of account code

financialObjectCode - the given object code

financialBalanceTypeCode - the given balance type code

universityFiscalPeriodCode - the given university fiscal period code

transactionDebitCreditCode - the given transaction debit or credit code

Returns:

object array with [0] being count(*) and [1] sum(TRANSACTION_LEDGER_ENTRY_AMOUNT). Returns null if data was not found

findCountGreaterOrEqualThan

Integer findCountGreaterOrEqualThan(Integer year)

Finds the count of rows for >= fiscal year passed in.

Parameters:

the - given university fiscal year

Returns:

count