Page Comparison

...

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 a.UC_LOC_CD, UC_ACCT_NBR, a.UC_FUND_NBR, a.FIN_COA_CD, a.ACCOUNT_NBR
FROM UCI_CA_ACCOUNT_XW_T
a
WHERE a.ACTIVE_IND <> 'N' AND

(	   (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '110001400753' AND a.UC_FUND_NBR = '1888819933') OR
	  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200400755' AND a.UC_FUND_NBR = '1821319900')
UNION
OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '182')
);SELECT ae.UC_LOC_CD, ae.UC_ACCT_NBR, 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')

Result Schema: A list of following elements (FS2KFSAccountDetails.java)

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

WS Example

Request

Code Block

<soapenv<?xml version="1.0" ?>
<S:Envelope xmlns:soapenvS="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:translateFSAccountFunds xmlns:adcns2="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSAccountFunds>
         <fsAccountList>
            <fsAccountCode>110001</fsAccountCode>
            <fsFundCode>18888</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>182</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
      </adc:translateFSAccountFunds>
   </soapenv:Body>
</soapenv			<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>110001</fsAccountCode>
            <fsFundCode>18888</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1061114</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1060532</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
      </ns2:translateFSAccountFundsResponse>
   ">
			<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>

...

Code Block

DWHServerService dssservice = new DWHServerService();
DWHServer dsserver = dssservice.getDWHServerPort();
 
ArrayList<AccountTranslateParameters> pl8
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>();
		
AccountTranslateParameters atp1 = new ArrayList<AccountTranslateParameters>();AccountTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("400753");
atp1.setFsFundCode("19933");
paramList.add(atp1);
		
AccountTranslateParameters at80atp2 = new AccountTranslateParameters();
at80atp2.setFsLocationCode("9");
at80atp2.setFsAccountCode("110001400755");
at80atp2.setFsFundCode("18888"("19900");
paramList.add(atp2);
		
AccountTranslateParameters at81atp3 = new AccountTranslateParameters();
at81atp3.setFsLocationCode("9");
at81atp3.setFsAccountCode("111200270303");
at81atp3.setFsFundCode("18213"70003");
paramList.add(atp3);
		
AccountTranslateParameters at82atp4 = new AccountTranslateParameters();
at82atp4.setFsLocationCode("9");
at82atp4.setFsAccountCode("111200270010");
at82atp4.setFsFundCode("18270000");
pl8paramList.add(at80atp4);
pl8.add(at81);
pl8.add(at82);		
List<Fs2KFSAccountDetails> resultList8resultList = dsserver.translateFSAccountFunds(pl8paramList);
if (resultList8resultList != null) {
	for (Iterator i = resultList8.iterator(); i.hasNext();) {
		Fs2KFSAccountDetails element = (Fs2KFSAccountDetails) i.next()Fs2KFSAccountDetails fad : resultList) {
		System.out.println("kfsChartCode     : " + fad.getKfsChartCode());
		System.out.println("kfsAccountNumber : " + fad.getKfsAcctNumber());
		System.out.println("fsLocationCode   : " + fad.getFsLocationCode());
		System.out.println("\t"fsAccountCode  + element.getFsLocationCode() +: "/" + elementfad.getFsAccountCode()) + "/" + element.getFsFundCode() + ";
		System.out.println("fsFundCode       : " + elementfad.getKfsChartCodegetFsFundCode()) + "/" + element.getKfsAcctNumber();
		System.out.println("------------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

...

Version	Old Version 106	New Version 107
Changes made by	Jarrod Lannan	Jarrod Lannan
Saved on	Dec 06, 2012	Dec 12, 2012

Versions Compared

Key

DB Query

Result Schema: A list of following elements (FS2KFSAccountDetails.java)

WS Example

Request

Response