KFS Chart Web Services

WSDL location: http://localhost:8080/WebService/DWHServer?wsdl

Endpoint: http://localhost:8080/WebService/DWHServer

isValidKFSCharts(List of kfsChartCode)

...

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

...

DB Query:

Code Block

select distinct
'IR',
case when not exists (select * FROM dwhs_ods..ca_chart_t a  where a.fin_coa_cd= 'IR' 
                       AND a.FIN_COA_ACTIVE_CD <> 'N' )
then 'false'
else 'true'
end
 
SELECT FIN_COA_CD, FIN_COA_ACTIVE_CD FROM dwhs_ods..ca_chart_t WHERE fin_coa_cd IN ('IR', 'MC');

...

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	'IR'
isValid	Is the Chart Active for that Fiscal Period?	boolean	true

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:isValidKFSCharts>
         <!--Zero or more repetitions:-->
         <kfsChartCodeList>IR</kfsChartCodeList>
         <kfsChartCodeList>MC</kfsChartCodeList>
         <kfsChartCodeList>XX</kfsChartCodeList>
         <kfsChartCodeList>MC</kfsChartCodeList>
      </adc:isValidKFSCharts>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

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

...

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)

...

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>
         <!--Zero or more repetitions:-->
         <kfsChartCodeList>IR</kfsChartCodeList>
         <kfsChartCodeList>MC</kfsChartCodeList>
         <kfsChartCodeList>MC</kfsChartCodeList>
      </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>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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>MC</kfsChartCode>
            <kfsChartDescription>Medical Center</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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
      </ns2:getValidKFSChartsResponse>
   </soap:Body>
</soap:Envelope>

...

No input parameter, ALL charts will return in result set.

...

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'

...

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:getAllKFSCharts/>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSChartsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>FD</kfsChartCode>
            <kfsChartDescription>Foundation</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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>MC</kfsChartCode>
            <kfsChartDescription>Medical Center</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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>PL</kfsChartCode>
            <kfsChartDescription>Plant</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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <return>
            <kfsARObjCode>0052</kfsARObjCode>
            <kfsChartActiveCode>Y</kfsChartActiveCode>
            <kfsChartCode>SW</kfsChartCode>
            <kfsChartDescription>Systemwide</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>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
         <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>
            <kfsICRExpObjCode>3800</kfsICRExpObjCode>
            <kfsICRIncObjCode>3800</kfsICRIncObjCode>
            <kfsIntEncObjCode>9998</kfsIntEncObjCode>
            <kfsPreEncObjCode>9998</kfsPreEncObjCode>
            <kfsRptsToChartCode>UC</kfsRptsToChartCode>
         </return>
      </ns2:getAllKFSChartsResponse>
   </soap:Body>
</soap:Envelope>

...

Version	Old Version 18	New Version 19
Changes made by	Adam Chang	Adam Chang
Saved on	Jun 27, 2012	Jun 27, 2012

Versions Compared

Key

KFS Chart Web Services

WSDL location: http://localhost:8080/WebService/DWHServer?wsdl

Endpoint: http://localhost:8080/WebService/DWHServer

isValidKFSCharts(List of kfsChartCode)

DB Query:

WS Example

Request

Response

DB Query:

WS Example

Request

Response

DB Query:

WS Example

Request

Response

Page Comparison

Versions Compared

Key

KFS Chart Web Services

WSDL location: http://localhost:8080/WebService/DWHServer?wsdl

Endpoint: http://localhost:8080/WebService/DWHServer

isValidKFSCharts(List of kfsChartCode)

DB Query:

WS Example

Request

Response

DB Query:

WS Example

Request

Response

DB Query:

WS Example

Request

Response