Page Comparison

...

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctCreateDate>2012-09-05</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000060345<<kfsAcctFiscalOfficerId>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>vcesario<<kfsAcctFiscalOfficerUciNetId></kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000247608<<kfsAcctManagerId>000000111111</kfsAcctManagerId>
            <kfsAcctName>INSTITUTIONAL/LATE CHARGE I 102168-03440</kfsAcctName>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000089121<<kfsAcctSupervisorId>000000111111</kfsAcctSupervisorId>
            <kfsAcctTypeCode>NA</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>8820</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>SRC001</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>102168</ucAccountCode>
            <ucFundCode>03440</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctCreateDate>2012-09-05</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000060345<<kfsAcctFiscalOfficerId>0000000111111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>vcesario</kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000247608</kfsAcctManagerId>
            <kfsAcctName>D/NSF DMS-1001006 YI J53.0  221602-21602</kfsAcctName>
            <kfsAcctNumber>1008543</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000089121</kfsAcctSupervisorId>
            <kfsAcctTypeCode>IN</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>6046</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>SRC001</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>221602</ucAccountCode>
            <ucFundCode>21602</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
      </ns2:getValidKFSAccountsResponse>
   </soap:Body>
</soap:Envelope>

...

Code Block

long start7 = System.currentTimeMillis();
System.out.println("\nWSClient--getAllKFSAccountsPK(), starting time: " + start7);
// get all the accounts primary key
List<AccountDetails> resultList7 = ds.getAllKFSAccountsPK();
if (resultList7 != null) {
	System.out.println("PK-total size: " + resultList7.size());
	System.out.println("PK-the 1st item ChartCode / AcctNumber: " + ((AccountDetails) resultList7.get(0)).getKfsChartCode() + " / " + ((AccountDetails) resultList7.get(0)).getKfsAcctNumber());
	ArrayList<AccountParameters> pl70 = new ArrayList<AccountParameters>();
	long start71 = System.currentTimeMillis();
	// get details for each KFSAccount in a chunk of 1000
	for (int i = 0; i < resultList7.size(); i++) {
		// single record detail
		if (i != 0 && i % 1000 == 0) {
			start71 = System.currentTimeMillis();
			List<AccountDetails> resultList70 = ds.getValidKFSAccounts(pl70);
			System.out.println(i);
			System.out.println("PK-elapsed after " + i + " item time (sec): " + (System.currentTimeMillis() - start71) / 1000F);
			// do whatever with the 1000 records in resultList70
			System.out.println("result size: " + resultList70.size());
			System.out.println("1st item details, acctname: " + resultList70.get(0).getKfsAcctName() + ", addr: " + resultList70.get(0).getKfsAcctAddress());
			// once hit multiple of 1000, reset argument list
			pl70.clear();
		} else {
			// building arguments list for getValidKFSAccounts()
			AccountParameters ap70 = new AccountParameters();
			ap70.setKfsChartCode(resultList7.get(i).getKfsChartCode());
			ap70.setKfsAcctNumber(resultList7.get(i).getKfsAcctNumber());
			pl70.add(ap70);
		}
	}
	System.out.println("PK-elapsed time (sec): " + (System.currentTimeMillis() - start7) / 1000F);
} else {
	System.out.println("something bad happened...please check your query");
}

...

getKFSAccountsByManager()

This service is used to translate legacy FS accounts to KFS account codes. Returns retrieve valid KFS account by the account manager uciNetId. Returns an XML result set with a KFS chart/account (example isValidKFSAccounts result) for each FS location/accountlist of accounts.

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	fsLocationCode	The FS location codemanagerUciNetId	Account Manager Uci Net Id	Yes	String (2)
1	fsAccountCode	The FS accounts code	Yes	String (6)
2	fsFundCode	The FS fund code	Yes	String (5)
	test

DB Query

Code Block

SELECT UCa.FIN_LOCCOA_CD,
UC_ACCT_NBR, UC_FUND	,a.ACCOUNT_NBR,
FIN_COA_CD, 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 = 'test' );

Result Schema: SAME as getdKFSAccounts

WS Example

Request

Code Block

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:getKFSAccountsByManager xmlns:ns2="http://www.adcom.uci.edu">
			<managerUciNetId>test</managerUciNetId>
		</ns2:getKFSAccountsByManager>
	</S:Body>
</S:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getKFSAccountsByManagerResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctFiscalOfficerId>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>test</kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000011111</kfsAcctManagerId>
            <kfsAcctName>40112 Test Acct Name</kfsAcctName>
            <kfsAcctNumber>GF12345</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000011111</kfsAcctSupervisorId>
            <kfsAcctTypeCode>CF</kfsAcctTypeCode>
            <kfsAcctZip>92611</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
            <kfsCandGChartCode>IR</kfsCandGChartCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>TEST</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>8542</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>401000</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>407680</ucAccountCode>
            <ucFundCode>19900</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
		</ns2:getKFSAccountsByManagerResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

		DWHServerService service = new DWHServerService();
		DWHServer server = service.getDWHServerPort();
		
		List<AccountDetails> resultList = server.getKFSAccountsByManager("test");
		
		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");
		}

translateFSAccountFunds(List of (fsLocationCode, fsAccountCode, fsFundCode))

This service is used to translate legacy FS accounts to KFS account codes. Returns an XML result set with a KFS chart/account (example isValidKFSAccounts result) for each FS location/account

Input Specifications

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	fsFundCode	The FS fund code	Yes	String (5)

DB Query

Code Block

SELECT UC_LOC_CD, UC_ACCT_NBR, UC_FUND_NBR, FIN_COA_CD, ACCOUNT_NBR
FROM UCI_CA_ACCOUNT_XW_T
WHERE ACTIVE_IND <> 'N' AND
	  ((UC_LOC_CD='9' AND UC_ACCT_NBR='400753' AND UC_FUND_NBR='19933') OR
	  (UC_LOC_CD='9' AND UC_ACCT_NBR='400755' AND UC_FUND_NBR='19900'))
UNION
SELECT DISTINCT ae.UC_LOC_CD, '-----', ae.UC_FUND_NBR, ae.FIN_COA_CD, ae.ACCOUNT_NBR
FROM CA_ACCOUNT_T a LEFT OUTER JOIN CA_ACCOUNT_EXT_T ae on
	 (a.ACCOUNT_NBR = ae.ACCOUNT_NBR AND a.FIN_COA_CD = ae.FIN_COA_CD)
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
	  a.ACCT_TYP_CD = 'CA' AND
	  ((ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70003') OR
	  (ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70000'))

...

Parameter	Description	Data Type	Example
fsLocationCode	The FS location code	String (2)	9
fsAccountCode	The FS accounts code	String (6)	270010
fsFundCode	The FS fund code	String (5)	70000
kfsChartCode	KFS Chart Code	String (2)	IR
kfsAcctNumber	KFS Account Number	String (7)	UC70000

WS Example

Request

Code Block

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:translateFSAccountFunds xmlns:ns2="http://www.adcom.uci.edu">
			<fsAccountList>
				<fsAccountCode>400753</fsAccountCode>
				<fsFundCode>19933</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>400755</fsAccountCode>
				<fsFundCode>19900</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>270303</fsAccountCode>
				<fsFundCode>70003</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>270010</fsAccountCode>
				<fsFundCode>70000</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
		</ns2:translateFSAccountFunds>
	</S:Body>
</S:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<fsAccountCode>270010</fsAccountCode>
				<fsFundCode>70000</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>UC70000</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>270303</fsAccountCode>
				<fsFundCode>70003</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>UC70003</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>400753</fsAccountCode>
				<fsFundCode>19933</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>GF10414</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>400755</fsAccountCode>
				<fsFundCode>19900</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>GF10420</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
		</ns2:translateFSAccountFundsResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

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.

Input Specifications

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 (52)
3	kfsFiscalYear	The KFS fiscal year	Yes	String (4)

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')
	);

...

Parameter	Description	Data Type	Example
fsLocationCode	The FS location code	String (2)	9
fsSubCode	The FS Sub code	String(2)	9H
fsObjCode	The FS Object Code	String(4)	3879
fsAccountCode	The FS accounts code	String (6)	112756
kfsFiscalYear	The KFS Fiscal Year	String (4)	2013
kfsChartCode	KFS Chart Code	String (2)	IR
kfsObjCode	KFS Object Code	String (4)	J323

WS Example

Request

Code Block

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:translateFSAccountToKFSObject xmlns:ns2="http://www.adcom.uci.edu">
			<fsAccountList>
				<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2014</kfsFiscalYear>
			</fsAccountList>
		</ns2:translateFSAccountToKFSObject>
	</S:Body>
</S:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:translateFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>R010</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>L231</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N004</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N013</kfsObjCode>
			</return>
		</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountToObjectTranslateParameters> paramList = new ArrayList<AccountToObjectTranslateParameters>();
		
AccountToObjectTranslateParameters atp1 = new AccountToObjectTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("119850");
atp1.setKfsChartCode("IR");
atp1.setKfsFiscalYear("2013");
paramList.add(atp1);
		
AccountToObjectTranslateParameters atp2 = new AccountToObjectTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("115181");
atp2.setKfsChartCode("IR");
atp2.setKfsFiscalYear("2013");
paramList.add(atp2);
		
AccountToObjectTranslateParameters atp3 = new AccountToObjectTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("101193");
atp3.setKfsChartCode("IR");
atp3.setKfsFiscalYear("2013");
paramList.add(atp3);
		
AccountToObjectTranslateParameters atp4 = new AccountToObjectTranslateParameters();
atp4.setFsLocationCode("9");
atp4.setFsAccountCode("229344");
atp4.setKfsChartCode("IR");
atp4.setKfsFiscalYear("2013");
paramList.add(atp4);
		
AccountToObjectTranslateParameters atp5 = new AccountToObjectTranslateParameters();
atp5.setFsLocationCode("9");
atp5.setFsAccountCode("229344");
atp5.setKfsChartCode("IR");
atp5.setKfsFiscalYear("2014");
paramList.add(atp5);

List<FsAccount2KFSObjectDetails> resultList = server.translateFSAccountToKFSObject(paramList);
if (resultList != null) {
	for (FsAccount2KFSObjectDetails fod : resultList) {
		System.out.println("fsLocationCode   : " + fod.getFsLocationCode());
		System.out.println("fsSubCode   : " + fod.getFsSubCode());
		System.out.println("fsObjCode   : " + fod.getFsObjCode());
		System.out.println("fsAccountCode    : " + fod.getFsAccountCode());
		System.out.println("kfsFiscalYear    : " + fod.getKfsFiscalYear());
		System.out.println("kfsChartCode     : " + fod.getKfsChartCode());
		System.out.println("kfsObjectCode    : " + fod.getKfsObjCode());
		System.out.println("--------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 115	New Version Current
Changes made by	Jarrod Lannan	Jarrod Lannan
Saved on	Feb 26, 2013	Mar 14, 2017

Versions Compared

Key

getKFSAccountsByManager()

Input Specifications

DB Query

Result Schema: SAME as getdKFSAccounts

WS Example

Request

Response

Java Client Example

translateFSAccountFunds(List of (fsLocationCode, fsAccountCode, fsFundCode))

Input Specifications

DB Query

WS Example

Request

Response

Java Client Example

translateFSAccountToKFSObject(List of (fsLocationCode, fsAccountCode, kfsChartCode, kfsFiscalYear))

Input Specifications

DB Query

WS Example

Request

Response

Java Client Example