...
No input parameter, ALL active KFS account details will be returned in result set.
USE WITH CAUTION since it may be returned a huge list of objects that consumes huge size of memory.
The best practice is using getAllKFSAccountsPK() and getValidKFSAccount() combined. Please see example in getAllKFSAccountsPK() section.
DB Query
| Code Block |
|---|
SELECT a.FIN_COA_CD
,a.ACCOUNT_NBR
,a.ACCOUNT_NM
,a.ACCT_FSC_OFC_UID
,a.ACCT_SPVSR_UNVL_ID
,a.ACCT_MGR_UNVL_ID
,a.ORG_CD
,a.ACCT_TYP_CD
,a.ACCT_PHYS_CMP_CD
,a.SUB_FUND_GRP_CD
,a.ACCT_FRNG_BNFT_CD
,a.FIN_HGH_ED_FUNC_CD
,a.ACCT_RSTRC_STAT_CD
,a.ACCT_RSTRC_STAT_DT
,a.ACCT_CITY_NM
,a.ACCT_STATE_CD
,a.ACCT_STREET_ADDR
,a.ACCT_ZIP_CD
,a.RPTS_TO_FIN_COA_CD
,a.RPTS_TO_ACCT_NBR
,a.ACCT_CREATE_DT
,a.ACCT_EFFECT_DT
,a.ACCT_EXPIRATION_DT
,a.CONT_FIN_COA_CD
,a.CONT_ACCOUNT_NBR
,a.ENDOW_FIN_COA_CD
,a.ENDOW_ACCOUNT_NBR
,a.CONTR_CTRL_FCOA_CD
,a.CONTR_CTRLACCT_NBR
,a.INCOME_FIN_COA_CD
,a.INCOME_ACCOUNT_NBR
,a.ACCT_ICR_TYP_CD
,a.AC_CSTM_ICREXCL_CD
,a.FIN_SERIES_ID
,a.ICR_FIN_COA_CD
,a.ICR_ACCOUNT_NBR
,a.ACCT_IN_FP_CD
,a.BDGT_REC_LVL_CD
,a.ACCT_SF_CD
,a.ACCT_PND_SF_CD
,a.FIN_EXT_ENC_SF_CD
,a.FIN_INT_ENC_SF_CD
,a.FIN_PRE_ENC_SF_CD
,a.FIN_OBJ_PRSCTRL_CD
,a.CG_CFDA_NBR
,a.ACCT_OFF_CMP_IND
,a.ACCT_CLOSED_IND
,CG_ACCT_RESP_ID
,b.UC_LOC_CD
,b.UC_ACCT_NBR
,b.UC_FUND_NBR
FROM ca_account_t a
LEFT OUTER JOIN uci_ca_account_xw_t b on (a.FIN_COA_CD = b.FIN_COA_CD and a.ACCOUNT_NBR = b.ACCOUNT_NBR)
WHERE
a.ACCT_CLOSED_IND <> 'Y'
AND (a.ACCT_EXPIRATION_DT >= getdate() or a.ACCT_EXPIRATION_DT IS NULL)
AND (a.ACCT_EFFECT_DT <= GETDATE())
|
...
Java Client Example
| Code Block |
|---|
// get all the accounts primary key List<AccountDetails> resultList7 = ds.getAllKFSAccountsPK(); if (resultList7 != null) { StringArray sa70 = new StringArray(); // get details for each KFSAccount in a chunk of 1000 for (int i = 0; i < resultList7.size(); i++) { // 1000 record batch details if (i % 1000 == 0) { sa70 = new StringArray(); start71 = System.currentTimeMillis(); List<AccountDetails> resultList70 = ds.getValidKFSAccounts(Arrays.asList(sa70)); // do whatever with the 1000 record resultList70 } else { // building arguments for getValidKFSAccounts sa70.getItem().add(resultList7.get(i).getKfsChartCode()); sa70.getItem().add(resultList7.get(i).getKfsAcctNumber()); } } } else { System.out.println("something bad happened...please check your query"); } |
...
translateFSAccountFunds(List of (fsLocationCode, fsAccountCode, fsFundCode))
...