Page Comparison

...

This service is used to translate legacy FS balance sheet and income accounts to KFS object codes.

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

...

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, 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='270303')
		OR
		(UC_LOC_CD='9' AND UC_ACCT_NBR='118747')
		OR
		(UC_LOC_CD='9' AND UC_ACCT_NBR='112754')
	);

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

Parameter	Description	Data Type	Example
fsLocationCode	The FS location codeYes	String (2)	19
fsAccountCode	The FS accounts codeYes	String (6)	2112754
fsFundCodekfsFiscalYear	The FS fund codeYesKFS Fiscal Year	String (54)	2013

DB Query

Code Block

SELECT DISTINCT
 a.UC_LOC_CD,
 a.UC_ACCT_NBR,
 CONVERT(varchar(4),x.UNIV_FISCAL_YR) AS UNIV_FISCAL_YR,
 x.FIN_COA_CD,
 x.FIN_OBJECT_CD
FROM UC_ACCOUNT_T a
JOIN UCI_CA_OBJECT_CODE_XW_T x ON a.UC_LOC_CD = x.UC_LOC_CD
AND a.UC_ACCT_GRP_CD = x.ACCT_GRP_CD
AND a.FIN_COA_CD = x.FIN_COA_CD
WHERE 
(
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '100133') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '101695') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '101698')
);

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)	100133
kfsFiscalYear	The KFS Fiscal Year	String (4)	2012
kfsChartCode	KFS Chart Code	String (2)	IR
kfsObjCode	KFS Object Code	String (4)	4000

WS Example

Request

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

...

kfsChartCode	KFS Chart Code	String (2)	IR
kfsObjCode	KFS Object Code	String (4)	J321

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>270303</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>118747</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>112754</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
			</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>112754</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>J321</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>270303</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>S832</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>118747</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>L537</kfsObjCode>
			</return>
		</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>();
		
AccountTranslateParameters at90atp1 = new AccountTranslateParameters();
at90atp1.setFsLocationCode("9");
at90atp1.setFsAccountCode("100133"270303");
paramList.add(atp1);
		
AccountTranslateParameters at91atp2 = new AccountTranslateParameters();
at91atp2.setFsLocationCode("9");
at91atp2.setFsAccountCode("101695"118747");
paramList.add(atp2);
AccountTranslateParameters at92atp3 = new AccountTranslateParameters();
at92atp3.setFsLocationCode("9");
at92atp3.setFsAccountCode("101698112754");
pl9paramList.add(at90atp3);
pl9.add(at91);
pl9.add(at92);		
List<FsAccount2KFSObjectDetails> resultList9resultList = dsserver.translateFSAccountToKFSObject(pl9paramList);
if (resultList9resultList != null) {
	for (IteratorFsAccount2KFSObjectDetails ifod = resultList9.iterator(); i.hasNext();) {
		FsAccount2KFSObjectDetails element = (FsAccount2KFSObjectDetails) i.next(: resultList) {
		System.out.println("fsLocationCode   : " + fod.getFsLocationCode());
		System.out.println("\t"fsAccountCode  + element.getFsLocationCode() +: "/" + elementfod.getFsAccountCode()) + "/;
		System.out.println("kfsFiscalYear    : " + elementfod.getKfsFiscalYear()) + ";
		System.out.println("kfsChartCode     : " + elementfod.getKfsChartCode()) + "/;
		System.out.println("kfsObjectCode    : " + elementfod.getKfsObjCode());
		System.out.println("--------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 108	New Version 109
Changes made by	Jarrod Lannan	Jarrod Lannan
Saved on	Dec 13, 2012	Dec 13, 2012

Versions Compared

Key

Input Specifications

Input Specifications

DB Query

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

DB Query

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

WS Example

Request

Response

Java Client Example

WS Example

Request

Response

Java Client Example