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

Old:
SELECT a.fin_coa_cd, 
a.account_nbr,
FROM KFSINT.UCI_CA_ACCOUNT_XW_T a
WHERE a.ACTIVE_IND <> 'N'
AND a.UC_LOC_CD = 'pLocationCode'
AND a.UC_ACCT_NBR = 'pAccountCode'
AND a.UC_FUND_NBR = 'pFundCode'
 
New:
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 = '110001' AND a.UC_FUND_NBR = '18888') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '18213') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '182')
);

...

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSAccountFunds>
         <fsAccountList>
            <item>9<<fsAccountCode>110001</item>fsAccountCode>
            <item>110001<<fsFundCode>18888</item>fsFundCode>
            <item>18888<<fsLocationCode>9</item>fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <item>9<<fsAccountCode>111200</item>fsAccountCode>
            <item>111200<<fsFundCode>18213</item>fsFundCode>
            <item>18213<<fsLocationCode>9</item>fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <item>9<<fsAccountCode>111200</item>fsAccountCode>
            <item>111200<<fsFundCode>182</item>fsFundCode>
            <item>182<<fsLocationCode>9</item>fsLocationCode>
         </fsAccountList>
      </adc:translateFSAccountFunds>
   </soapenv:Body>
</soapenv:Envelope>

...

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>1000766<<kfsAcctNumber>1061114</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1000785<<kfsAcctNumber>1060532</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
      </ns2:translateFSAccountFundsResponse>
   </soap:Body>
</soap:Envelope>

...

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
StringArrayArrayList<AccountTranslateParameters> sa60pl8 = new StringArrayArrayList<AccountTranslateParameters>();
sa60.getItem().add
AccountTranslateParameters at80 = new AccountTranslateParameters();
at80.setFsLocationCode("9");
sa60at80.getItemsetFsAccountCode().add("110001");
sa60.getItem().addat80.setFsFundCode("18888");
AccountTranslateParameters 
StringArrayat81 sa61 = new StringArrayAccountTranslateParameters();
sa61.getItem().addat81.setFsLocationCode("9");
sa61.getItem().addat81.setFsAccountCode("111200");
sa61.getItem().addat81.setFsFundCode("18213");
AccountTranslateParameters 
StringArray sa62at82 = new StringArrayAccountTranslateParameters();
sa62at82.getItemsetFsLocationCode("9");
at82.addsetFsAccountCode("9111200");
sa62at82.getItemsetFsFundCode("182");
pl8.add("111200"at80);
sa62pl8.getItemadd(at81);
pl8.add("182"at82);

	
List<Fs2KFSAccountDetails> resultList6resultList8 = ds.translateFSAccountFunds(Arrays.asList(sa60,sa61,sa62))pl8);
if (resultList6resultList8 != null) {
	for (Iterator i = resultList6resultList8.iterator(); i.hasNext();) {
		Fs2KFSAccountDetails element = (Fs2KFSAccountDetails) i.next();
		System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsAccountCode() + "/" + element.getFsFundCode() + " : " + element.getKfsChartCode() + "/" + element.getKfsAcctNumber());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Take a row in UC_ACCOUNT_T to get the corresponding row(s) from UCI_CA_OBJECT_CODE_XW_T.

(uc_loc_cd, uc_acct_nbr, uc_sau_cd) are the composite PK for UC_ACCOUNT_T but uc_sau_cd is almost always 0. There are some rows with uc_sau_cd is NOT 0, but (uc_loc_cd, uc_acct_nbr) are not overlapped. Only uc_loc_cd and uc_acct_nbr are the input parameters which may result multiple KFSObjCode back.

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)

...

WS Example

Request

Code Block

Response

Code Block

Java Client Example

Code Block

 <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSAccountToKFSObject>
         <fsAccountList>
            <fsAccountCode>100133</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <fsAccountCode>101695</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
         <fsAccountList>
            <fsAccountCode>101698</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
         </fsAccountList>
      </adc:translateFSAccountToKFSObject>
   </soapenv:Body>
</soapenv: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>101695</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0727</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>101698</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0727</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>100133</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0731</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>101695</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0732</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>101698</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0732</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>101695</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0733</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>101698</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0733</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>100133</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0521</kfsObjCode>
         </return>
         <return>
            <fsAccountCode>100133</fsAccountCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0523</kfsObjCode>
         </return>
      </ns2:translateFSAccountToKFSObjectResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

ArrayList<AccountTranslateParameters> pl9 = new ArrayList<AccountTranslateParameters>();
AccountTranslateParameters at90 = new AccountTranslateParameters();
at90.setFsLocationCode("9");
at90.setFsAccountCode("100133");
AccountTranslateParameters at91 = new AccountTranslateParameters();
at91.setFsLocationCode("9");
at91.setFsAccountCode("101695");
AccountTranslateParameters at92 = new AccountTranslateParameters();
at92.setFsLocationCode("9");
at92.setFsAccountCode("101698");
pl9.add(at90);
pl9.add(at91);
pl9.add(at92);
List<FsAccount2KFSObjectDetails> resultList9 = ds.translateFSAccountToKFSObject(pl9);
if (resultList9 != null) {
	for (Iterator i = resultList9.iterator(); i.hasNext();) {
		FsAccount2KFSObjectDetails element = (FsAccount2KFSObjectDetails) i.next();
		System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsAccountCode() + "/" + element.getKfsFiscalYear() + " : " + element.getKfsChartCode() + "/" + element.getKfsObjCode());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 98	New Version 99
Changes made by	Adam Chang	Adam Chang
Saved on	Sept 24, 2012	Sept 24, 2012

Versions Compared

Key

DB Query

Input Specifications

WS Example

Request

Response

Java Client Example

Response

Java Client Example