Page Comparison

...

Parameter	Description	Required?	Data Type (max length)
kfsChartCode	The KFS chart of accounts code	Yes	String (2)

DB Query

Code Block

Old:
select distinct
'IR',
case when not exists (select * FROM SELECT 
FIN_COA_CD, 
FIN_COA_ACTIVE_CD 
FROM 
dwhs_ods..ca_chart_tt 
a  where a.fin_coa_cd= 'IR' 
                       AND a.FIN_COA_ACTIVE_CD <> 'N' )
then 'false'
else 'true'
end

New:
SELECT FIN_COA_CD, FIN_COA_ACTIVE_CD FROM dwhs_ods..ca_chart_t WHERE fin_coa_cd IN ('IR', 'MC');

...

WHERE 
FIN_COA_ACTIVE_CD <> 'N' AND 
FIN_COA_CD IN ('IR', 'MC', 'UC', 'XX', 'X', 'I');

Result Schema: A list of following element (ChartValidation.java)

...

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidKFSCharts>
         <!--Zero<kfsChartList>
or more repetitions:-->          <kfsChartCodeList>IR<<kfsChartCode>UC</kfsChartCodeList>kfsChartCode>
         <kfsChartCodeList>MC</kfsChartCodeList></kfsChartList>
         <kfsChartList>
  <kfsChartCodeList>XX</kfsChartCodeList>          <kfsChartCodeList>MC</kfsChartCodeList><kfsChartCode>IR</kfsChartCode>
         </adc:isValidKFSCharts>kfsChartList>
   </soapenv:Body> </soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">    <soap:Body><kfsChartList>
      <ns2:isValidKFSChartsResponse xmlns:ns2="http://www.adcom.uci.edu">          <return>
            <kfsChartCode>XX<<kfsChartCode>MC</kfsChartCode>
            <valid>false</valid></kfsChartList>
         </return><kfsChartList>
         <return>   <kfsChartCode>XX</kfsChartCode>
         <kfsChartCode>IR<</kfsChartCode>kfsChartList>
      </adc:isValidKFSCharts>
     <valid>true</valid></soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      </return><ns2:isValidKFSChartsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsChartCode>MC<<kfsChartCode>UC</kfsChartCode>
            <valid>true</valid>
         </return>
       </ns2:isValidKFSChartsResponse>  <return>
   </soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService(); DWHServer ds = dss.getDWHServerPortCustom(); <kfsChartCode>XX</kfsChartCode>
  List<ChartValidation> resultList0 = ds.isValidKFSCharts(Arrays.asList(new String[]{"IR", "MC", "XX"}));
for (Iterator i = resultList0.iterator(); i.hasNext();) {
	ChartValidation element = (ChartValidation)i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.isValid());
}

getValidKFSCharts(List of kfsChartCode)

This service is used retrieve valid KFS chart codes and related attributes. Returns an XML result set with a list of charts (example getAllValidKFSCharts result).

Input Specifications

Parameter	Description	Required?	Data Type (max length)
kfsChartCodeList	A list of KFS chart of accounts code	Yes	A List of String (2)

DB Query

Code Block

SELECT FIN_COA_CD     <valid>false</valid>
         </return>
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <valid>true</valid>
       ,FIN_COA_DESC   </return>
   ,FIN_COA_ACTIVE_CD       ,FIN_CASH_OBJ_CD<return>
       ,FIN_AP_OBJ_CD     <kfsChartCode>MC</kfsChartCode>
 ,INCBDGT_ELIMOBJ_CD       ,EXPBDGT_ELIMOBJ_CD    <valid>true</valid>
  ,RPTS_TO_FIN_COA_CD       ,FIN_AR_OBJ_CD</return>
      ,FIN_INT_ENC_OBJ_CD</ns2:isValidKFSChartsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService  ,FIN_EXT_ENC_OBJ_CD
      ,FIN_PRE_ENC_OBJ_CD
      ,ICR_INC_FIN_OBJ_CD
      ,ICR_EXP_FIN_OBJ_CD
      ,FND_BAL_OBJ_CD
  FROM ca_chart_t
WHERE FIN_COA_ACTIVE_CD <> 'N' 
AND FIN_COA_CD IN ('<kfsChartCode1>', '<kfsChartCode2>', etc)

Result Schema: A list of following element (ChartDetails.java)

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	'IR'
kfsChartDescription	KFS Chart Description	String (40)	'Irvine'
kfsChartActiveCode	KFS Chart Active Code ('Y' for yes, 'N' for no)	String (1)	'Y'
kfsFinCashObjCode	KFS Cash Object Code	String (4)	'0000'
kfsFinAPObjCode	KFS Accounts Payable Object Code	String (4)	'0000'
kfsIncBdgtElimObjCode	KFS Income Budget Elimination Object Code	String (4)	'0000'
kfsExpBdgtElimObjCode	KFS Expense Budget Elimination Object Code	String (4)	'0000'
kfsRptsToChartCode	KFS Reports to Chart Code	String (2)	'MC'
kfsARObjCode	KFS Accounts Receivable Object Code	String (4)	'0000'
kfsIntEncObjCode	KFS Internal Encumbrances Object Code	String (4)	'0000'
kfsExtEncObjCode	KFS External Encumbrances Object Code	String (4)	'0000'
kfsPreEncObjCode	KFS Pre Encumbrances Object Code	String (4)	'0000'
kfsICRIncObjCode	KFS Indirect Cost Recovery Income Object Code	String (4)	'0000'
kfsICRExpObjCode	KFS Indirect Cost Recovery Expense Object Code	String (4)	'0000'
kfsFundBalObjCode	KFS Fund Balance Object Code	String (4)	'0000'

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:getValidKFSCharts>dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
 
ArrayList<ChartParameters> pl0 = new ArrayList<ChartParameters>();
ChartParameters cp01 = new ChartParameters();
cp01.setKfsChartCode("UC");
ChartParameters cp02 = new ChartParameters();
cp02.setKfsChartCode("MC");
ChartParameters cp03 = new ChartParameters();
cp03.setKfsChartCode("IR");
ChartParameters cp04 = new ChartParameters();
cp04.setKfsChartCode("XX");
ChartParameters cp05 = new ChartParameters();
cp05.setKfsChartCode("X");
ChartParameters cp06 = new ChartParameters();
cp06.setKfsChartCode("I");
pl0.add(cp01);
pl0.add(cp02);
pl0.add(cp03);
pl0.add(cp04);
pl0.add(cp05);
pl0.add(cp06);
List<ChartValidation> resultList0 = ds.isValidKFSCharts(pl0);
System.out.println("\nWSClient--isValidKFSCharts()");
for (Iterator i = resultList0.iterator(); i.hasNext();) {
	ChartValidation element = (ChartValidation)i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.isValid());
}

...

getValidKFSCharts(List of kfsChartCode)

This service is used retrieve valid KFS chart codes and related attributes. Returns an XML result set with a list of charts (example getAllValidKFSCharts result).

Input Specifications

Parameter	Description	Required?	Data Type (max length)
kfsChartCodeList	A list of KFS chart of accounts code	Yes	A List of String (2)

DB Query

Code Block

SELECT FIN_COA_CD
      ,FIN_COA_DESC
      ,FIN_COA_ACTIVE_CD
      ,FIN_CASH_OBJ_CD
      ,FIN_AP_OBJ_CD
      ,INCBDGT_ELIMOBJ_CD
      ,EXPBDGT_ELIMOBJ_CD
      ,RPTS_TO_FIN_COA_CD
      ,FIN_AR_OBJ_CD
      ,FIN_INT_ENC_OBJ_CD
      ,FIN_EXT_ENC_OBJ_CD
      ,FIN_PRE_ENC_OBJ_CD
      ,ICR_INC_FIN_OBJ_CD
      ,ICR_EXP_FIN_OBJ_CD
      ,FND_BAL_OBJ_CD
  FROM ca_chart_t
WHERE FIN_COA_ACTIVE_CD <> 'N' 
AND FIN_COA_CD IN ('<kfsChartCode1>', '<kfsChartCode2>', etc)

Result Schema: A list of following element (ChartDetails.java)

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	'IR'
kfsChartDescription	KFS Chart Description	String (40)	'Irvine'
kfsChartActiveCode	KFS Chart Active Code ('Y' for yes, 'N' for no)	String (1)	'Y'
kfsFinCashObjCode	KFS Cash Object Code	String (4)	'0000'
kfsFinAPObjCode	KFS Accounts Payable Object Code	String (4)	'0000'
kfsIncBdgtElimObjCode	KFS Income Budget Elimination Object Code	String (4)	'0000'
kfsExpBdgtElimObjCode	KFS Expense Budget Elimination Object Code	String (4)	'0000'
kfsRptsToChartCode	KFS Reports to Chart Code	String (2)	'MC'
kfsARObjCode	KFS Accounts Receivable Object Code	String (4)	'0000'
kfsIntEncObjCode	KFS Internal Encumbrances Object Code	String (4)	'0000'
kfsExtEncObjCode	KFS External Encumbrances Object Code	String (4)	'0000'
kfsPreEncObjCode	KFS Pre Encumbrances Object Code	String (4)	'0000'
kfsICRIncObjCode	KFS Indirect Cost Recovery Income Object Code	String (4)	'0000'
kfsICRExpObjCode	KFS Indirect Cost Recovery Expense Object Code	String (4)	'0000'
kfsFundBalObjCode	KFS Fund Balance Object Code	String (4)	'0000'

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:getValidKFSCharts>
         <kfsChartList>
            <kfsChartCode>UC</kfsChartCode>
         </kfsChartList>
         <kfsChartList>
            <kfsChartCode>IR</kfsChartCode>
         </kfsChartList>
         <kfsChartList>
            <kfsChartCode>MC</kfsChartCode>
         </kfsChartList>
         <kfsChartList>
            <kfsChartCode>XX</kfsChartCode>
         </kfsChartList>
      </adc:getValidKFSCharts>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSChartsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>UC</kfsChartCode>
            <kfsChartDescription>University of California</kfsChartDescription>
            <kfsExtEncObjCode>9998</kfsExtEncObjCode>
            <kfsFinAPObjCode>0051</kfsFinAPObjCode>
            <kfsFinCashObjCode>CASH</kfsFinCashObjCode>
            <kfsFundBalObjCode>0000</kfsFundBalObjCode>
            <!--Zero or more repetitions:--><kfsICRExpObjCode>3800</kfsICRExpObjCode>
            <kfsChartCodeList>IR</kfsChartCodeList><kfsICRIncObjCode>3800</kfsICRIncObjCode>
            <kfsChartCodeList>MC</kfsChartCodeList><kfsIntEncObjCode>9998</kfsIntEncObjCode>
            <kfsChartCodeList>MC<<kfsPreEncObjCode>9998</kfsChartCodeList>kfsPreEncObjCode>
      </adc:getValidKFSCharts>    </soapenv:Body> </soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
 <kfsRptsToChartCode>UC</kfsRptsToChartCode>
  <soap:Body>       <ns2:getValidKFSChartsResponse xmlns:ns2="http://www.adcom.uci.edu"></return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsChartDescription>UC Irvine</kfsChartDescription>
            <kfsExtEncObjCode>9998</kfsExtEncObjCode>
            <kfsFinAPObjCode>0051</kfsFinAPObjCode>
            <kfsFinCashObjCode>CASH</kfsFinCashObjCode>
            <kfsFundBalObjCode>0000</kfsFundBalObjCode>
            <kfsICRExpObjCode>3800</kfsICRExpObjCode>
            <kfsICRIncObjCode>3800</kfsICRIncObjCode>
            <kfsIntEncObjCode>9998</kfsIntEncObjCode>
            <kfsPreEncObjCode>9998</kfsPreEncObjCode>kfsPreEncObjCode>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
      <kfsRptsToChartCode>UC</kfsRptsToChartCode>      <kfsChartCode>MC</kfsChartCode>
   </return>         <kfsChartDescription>Medical <return>Center</kfsChartDescription>
            <kfsARObjCode>0052<<kfsExtEncObjCode>9998</kfsARObjCode>kfsExtEncObjCode>
            <kfsChartActiveCode>Y<<kfsFinAPObjCode>0051</kfsChartActiveCode>kfsFinAPObjCode>
            <kfsChartCode>MC<<kfsFinCashObjCode>CASH</kfsChartCode>kfsFinCashObjCode>
            <kfsChartDescription>Medical Center<<kfsFundBalObjCode>0000</kfsChartDescription>kfsFundBalObjCode>
            <kfsExtEncObjCode>9998<<kfsICRExpObjCode>3800</kfsExtEncObjCode>kfsICRExpObjCode>
            <kfsFinAPObjCode>0051<<kfsICRIncObjCode>3800</kfsFinAPObjCode>kfsICRIncObjCode>
            <kfsFinCashObjCode>CASH<<kfsIntEncObjCode>9998</kfsFinCashObjCode>kfsIntEncObjCode>
            <kfsFundBalObjCode>0000<<kfsPreEncObjCode>9998</kfsFundBalObjCode>kfsPreEncObjCode>
            <kfsICRExpObjCode>3800<<kfsRptsToChartCode>UC</kfsICRExpObjCode>kfsRptsToChartCode>
         </return>
    <kfsICRIncObjCode>3800</kfsICRIncObjCode>
  </ns2:getValidKFSChartsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds <kfsIntEncObjCode>9998</kfsIntEncObjCode>
            <kfsPreEncObjCode>9998</kfsPreEncObjCode>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
      </ns2:getValidKFSChartsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
List<ChartDetails> resultList= dss.getDWHServerPort();
ArrayList<ChartParameters> pl0 = new ArrayList<ChartParameters>();
ChartParameters cp01 = new ChartParameters();
cp01.setKfsChartCode("UC");
ChartParameters cp02 = new ChartParameters();
cp02.setKfsChartCode("MC");
ChartParameters cp03 = new ChartParameters();
cp03.setKfsChartCode("IR");
ChartParameters cp04 = new ChartParameters();
cp04.setKfsChartCode("XX");
ChartParameters cp05 = new ChartParameters();
cp05.setKfsChartCode("X");
ChartParameters cp06 = new ChartParameters();
cp06.setKfsChartCode("I");
pl0.add(cp01);
pl0.add(cp02);
pl0.add(cp03);
pl0.add(cp04);
pl0.add(cp05);
pl0.add(cp06);

List<ChartDetails> resultList1 = ds.getValidKFSCharts(Arrays.asList(new String[]{"IR", "MC", "XX"})pl0);
System.out.println("\nWSClient--getValidKFSCharts()");
for (Iterator i = resultListresultList1.iterator(); i.hasNext();) {
	ChartDetails element = (ChartDetails) i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.getKfsChartDescription());
}

...

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustomgetDWHServerPort();
 
List<ChartDetails> resultList1 = ds.getAllKFSCharts();
for (Iterator i = resultList1.iterator(); i.hasNext();) {
	ChartDetails element = (ChartDetails)i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.getKfsChartDescription());
}

Version	Old Version 29	New Version Current
Changes made by	Adam Chang	Adam Chang
Saved on	Aug 31, 2012	Oct 24, 2012

Versions Compared

Key

DB Query

Result Schema: A list of following element (ChartValidation.java)

Response

Response

Java Client Example

getValidKFSCharts(List of kfsChartCode)

Input Specifications

DB Query

Java Client Example

Result Schema: A list of following element (ChartDetails.java)

WS Example

Request

getValidKFSCharts(List of kfsChartCode)

Input Specifications

DB Query

Result Schema: A list of following element (ChartDetails.java)

WS Example

Request

Response

Response

Java Client Example

Java Client Example