...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | managerUciNetId | Account Manager Uci Net Id | Yes | String | mpleetest |
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 ,CONVERT(VARCHAR(2), a.CG_ACCT_RESP_ID) AS CG_ACCT_RESP_ID ,b.UC_LOC_CD ,b.UC_ACCT_NBR ,b.UC_FUND_NBR ,b.UCI_CAPITAL_CAT_CD ,e.UCINETID AS ACCT_FSC_OFC_UCINETID FROM ca_account_t a LEFT JOIN ca_account_ext_t b ON ( a.FIN_COA_CD = b.FIN_COA_CD AND a.ACCOUNT_NBR = b.ACCOUNT_NBR ) INNER JOIN dwhs_ppscurr..employee_basic e ON (a.ACCT_FSC_OFC_UID = e.CAMPUS_ID) 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()) AND e.ucinetid = 'mpleetest' ); |
Result Schema: SAME as getdKFSAccounts
...
| Code Block |
|---|
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
List<AccountDetails> resultList = server.getKFSAccountsByManager("mcdaveetest");
if (resultList != null) {
for (AccountDetails ad : resultList) {
System.out.println("kfsChartCode : " + ad.getKfsChartCode());
System.out.println("kfsAccountNumber : " + ad.getKfsAcctNumber());
System.out.println("fiscalOfficerUciNetId : " + ad.getKfsAcctFiscalOfficerUciNetId());
System.out.println("--------------------------");
}
}
else {
System.out.println("something bad happened...please check your query");
} |
...
| Code Block |
|---|
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>();
AccountTranslateParameters atp1 = new AccountTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("400753");
atp1.setFsFundCode("19933");
paramList.add(atp1);
AccountTranslateParameters atp2 = new AccountTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("400755");
atp2.setFsFundCode("19900");
paramList.add(atp2);
AccountTranslateParameters atp3 = new AccountTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("270303");
atp3.setFsFundCode("70003");
paramList.add(atp3);
AccountTranslateParameters atp4 = new AccountTranslateParameters();
atp4.setFsLocationCode("9");
atp4.setFsAccountCode("270010");
atp4.setFsFundCode("70000");
paramList.add(atp4);
List<Fs2KFSAccountDetails> resultList = server.translateFSAccountFunds(paramList);
if (resultList != null) {
for (Fs2KFSAccountDetails fad : resultList) {
System.out.println("kfsChartCode : " + fad.getKfsChartCode());
System.out.println("kfsAccountNumber : " + fad.getKfsAcctNumber());
System.out.println("fsLocationCode : " + fad.getFsLocationCode());
System.out.println("fsAccountCode : " + fad.getFsAccountCode());
System.out.println("fsFundCode : " + fad.getFsFundCode());
System.out.println("------------------------------");
}
}
else {
System.out.println("something bad happened...please check your query");
} |
...
translateFSAccountToKFSObject(List of (fsLocationCode, fsAccountCode, kfsChartCode, kfsFiscalYear))
This service is used to translate legacy FS balance sheet and income accounts to KFS object codes.
...
| Index | Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|---|
| 0 | fsLocationCode | The FS location code | Yes | String (2) |
| 1 | fsAccountCode | The FS accounts code | Yes | String (6) |
| 2 | fsFundCodekfsChartCode | The FS fund KFS chart code | Yes | String (2) |
| 3 | kfsFiscalYear | The KFS fiscal year | Yes | String (54) |
DB Query
| Code Block |
|---|
SELECT
UC_LOC_CD, UC_SUB_CD, UC_OBJECT_CD, UC_ACCT_NBR, CONVERT(varchar(4), UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD
FROM UCI_CA_OBJECT_CODE_XW_T
WHERE
ACTIVE_IND <> 'N' AND
(
(UC_LOC_CD='9' AND UC_ACCT_NBR='119850' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
OR
(UC_LOC_CD='9' AND UC_ACCT_NBR='115181' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
OR
(UC_LOC_CD='9' AND UC_ACCT_NBR='101193' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
OR
(UC_LOC_CD='9' AND UC_ACCT_NBR='229344' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
); |
...