org.kuali.kfs.module.endow.dataaccess
Interface TransactionArchiveDao

All Known Implementing Classes:

TransactionArchiveDaoOjb

public interface TransactionArchiveDao

Method Summary

Collection<TransactionArchive>	getAllTransactionArchives() Gets a collection of records from END_TRAN_ARCHV_T table
Collection<TransactionArchive>	getAllTransactionArchives(Date postedDate) Gets a collection of records from END_TRAN_ARCHV_T table.
TransactionArchive	getByPrimaryKey(String documentNumber, int lineNumber, String lineTypeCode) Gets a transactionArchive by primary keys.
List<TransactionArchive>	getTransactionArchiveByKemidsAndPostedDate(String kemid, String endowmentOption, Date beginningDate, Date endingDate, String closedIndicator, String transactionSubType) Gets a collection of TransactionArchive by kemids and posted dates
List<TransactionArchive>	getTransactionArchivesByKemid(String kemid, Date beginningDate, Date endingDate) Gets a collection of TransactionArchive by kemid and beginning and ending dates
long	getTransactionArchivesCountByBothIncomeAndPrincipal(FeeMethod feeMethod) Gets a count of total number of records from END_TRAN_ARCHV_T table
long	getTransactionArchivesCountByDocumentTypeName(String feeMethodCode, Date transactionPostedDate) Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM
long	getTransactionArchivesCountByDocumentTypeNameAndETranCode(String feeMethodCode, Date transactionPostedDate) Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM and TRAN_ETRAN_CD
long	getTransactionArchivesCountByETranCode(String feeMethodCode, Date transactionPostedDate) Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM
long	getTransactionArchivesCountByIncomeOrPrincipal(String IncomeOrPrincipalIndicator) Gets a count of total number of records from END_TRAN_ARCHV_T table for a given TRAN_IP_IND_CD
long	getTransactionArchivesCountForTransactions(FeeMethod feeMethod) Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM
HashMap<String,BigDecimal>	getTransactionArchivesIncomeAndPrincipalCashAmountForTransactions(FeeMethod feeMethod) Gets Income and principal cash amount from the selected records from END_TRAN_ARCHV_T table
BigDecimal	getTransactionArchivesIncomeCashAmountForTransactions(FeeMethod feeMethod) Gets principal income amount from the selected records from END_TRAN_ARCHV_T table
BigDecimal	getTransactionArchivesPrincipalCashAmountForTransactions(FeeMethod feeMethod) Gets principal cash amount from the selected records from END_TRAN_ARCHV_T table
BigDecimal	getTransactionArchivesTotalCashActivity(String kemid, String securityId) Gets total cash activity by adding income cash and principal cash amount from the selected records from END_TRAN_ARCHV_T table

Method Detail

getAllTransactionArchives

Collection<TransactionArchive> getAllTransactionArchives(Date postedDate)

Gets a collection of records from END_TRAN_ARCHV_T table. The data is sorted by DOC_TYP_NM, TRAN_SUB_TYP_CD, TRAN_IP_IND_CD, TRAN_KEMID, TRAN_ETRAN_CD

Parameters:

postedDate -

Returns:

transactionArchives

getAllTransactionArchives

Collection<TransactionArchive> getAllTransactionArchives()

Gets a collection of records from END_TRAN_ARCHV_T table

Returns:

transactionArchives

getByPrimaryKey

TransactionArchive getByPrimaryKey(String documentNumber,
                                   int lineNumber,
                                   String lineTypeCode)

Gets a transactionArchive by primary keys.

Parameters:

documentNumber, - lineNumber, lineTypeCode

Returns:

a transactionArchive

getTransactionArchivesCountForTransactions

long getTransactionArchivesCountForTransactions(FeeMethod feeMethod)

Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM

Parameters:

feeMethod - feeMethod object

Returns:

count of transactionArhives matching the criteria

getTransactionArchivesCountByDocumentTypeName

long getTransactionArchivesCountByDocumentTypeName(String feeMethodCode,
                                                   Date transactionPostedDate)

Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM

Parameters:

feeMethodCode, - transactionPostedDate

Returns:

count of transactionArhives matching the passed in parameters

getTransactionArchivesCountByETranCode

long getTransactionArchivesCountByETranCode(String feeMethodCode,
                                            Date transactionPostedDate)

Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM

Parameters:

feeMethodCode, - transactionPostedDate

Returns:

count of transactionArhives matching the passed in parameters

getTransactionArchivesCountByDocumentTypeNameAndETranCode

long getTransactionArchivesCountByDocumentTypeNameAndETranCode(String feeMethodCode,
                                                               Date transactionPostedDate)

Gets a count of total number of records from END_TRAN_ARCHV_T table for a given DOC_TYP_NM and TRAN_ETRAN_CD

Parameters:

feeMethodCode, - transactionPostedDate

Returns:

count of transactionArhives matching the passed in parameters

getTransactionArchivesCountByIncomeOrPrincipal

long getTransactionArchivesCountByIncomeOrPrincipal(String IncomeOrPrincipalIndicator)

Gets a count of total number of records from END_TRAN_ARCHV_T table for a given TRAN_IP_IND_CD

Parameters:

IncomeOrPrincipalIndicator -

Returns:

count of transactionArhives matching the passed in parameter

getTransactionArchivesCountByBothIncomeAndPrincipal

long getTransactionArchivesCountByBothIncomeAndPrincipal(FeeMethod feeMethod)

Gets a count of total number of records from END_TRAN_ARCHV_T table

Parameters:

feeMethod -

Returns:

count of transactionArhives based on the conditions in feeMethod object

getTransactionArchivesIncomeCashAmountForTransactions

BigDecimal getTransactionArchivesIncomeCashAmountForTransactions(FeeMethod feeMethod)

Gets principal income amount from the selected records from END_TRAN_ARCHV_T table

Parameters:

feeMethod - feeMethod object

Returns:

incomeCashAmount of transactionArhives matching the criteria

getTransactionArchivesPrincipalCashAmountForTransactions

BigDecimal getTransactionArchivesPrincipalCashAmountForTransactions(FeeMethod feeMethod)

Gets principal cash amount from the selected records from END_TRAN_ARCHV_T table

Parameters:

feeMethod - feeMethod object

Returns:

incomeCashAmount of transactionArhives matching the criteria

getTransactionArchivesIncomeAndPrincipalCashAmountForTransactions

HashMap<String,BigDecimal> getTransactionArchivesIncomeAndPrincipalCashAmountForTransactions(FeeMethod feeMethod)

Gets Income and principal cash amount from the selected records from END_TRAN_ARCHV_T table

Parameters:

feeMethod - feeMethod object

Returns:

Map with both income and principal cash amount of records matching the criteria

getTransactionArchivesTotalCashActivity

BigDecimal getTransactionArchivesTotalCashActivity(String kemid,
                                                   String securityId)

Gets total cash activity by adding income cash and principal cash amount from the selected records from END_TRAN_ARCHV_T table

Parameters:

kemid, - securityId

Returns:

totalCashActivity

getTransactionArchiveByKemidsAndPostedDate

List<TransactionArchive> getTransactionArchiveByKemidsAndPostedDate(String kemid,
                                                                    String endowmentOption,
                                                                    Date beginningDate,
                                                                    Date endingDate,
                                                                    String closedIndicator,
                                                                    String transactionSubType)

Gets a collection of TransactionArchive by kemids and posted dates

Parameters:

kemids -

endowmentOption -

beginningDate -

endingDate -

Returns:

getTransactionArchivesByKemid

List<TransactionArchive> getTransactionArchivesByKemid(String kemid,
                                                       Date beginningDate,
                                                       Date endingDate)

Gets a collection of TransactionArchive by kemid and beginning and ending dates

Parameters:

kemids -

beginningDate -

endingDate -

Returns:

List