org.kuali.ole.gl.dataaccess

Interface LedgerEntryBalancingDao

All Known Implementing Classes:

EntryDaoOjb

public interface LedgerEntryBalancingDao

DAO interface for the balancing process of ledger entries

Method Summary

Methods

Modifier and Type	Method and Description
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