Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

 

Table of Contents

isValidKFSObjects(List of (kfsFiscalYear, kfsChartCode,  kfsObjCode))

...

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
 
ArrayList<ObjectParameters> pl10 = new ArrayList<ObjectParameters>();
ObjectParameters op100 = new ObjectParameters();
op100.setKfsFiscalYear("2012");
op100.setKfsChartCode("MC");
op100.setKfsObjCode("1100");
ObjectParameters op101 = new ObjectParameters();
op101.setKfsFiscalYear("2012");
op101.setKfsChartCode("IR");
op101.setKfsObjCode("CASH");
ObjectParameters op102 = new ObjectParameters();
op102.setKfsFiscalYear("2013");
op102.setKfsChartCode("IR");
op102.setKfsObjCode("CASH");
pl10.add(op100);
pl10.add(op101);
pl10.add(op102);
List<ObjectValidation> resultList10 = ds.isValidKFSObjects(pl10);
if (resultList10 != null) {
	for (Iterator i = resultList10.iterator(); i.hasNext();) {
		ObjectValidation element = (ObjectValidation) i.next();
		System.out.println("isValidObj-FiscalYr / ChartCode / ObjCode : isValid" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsObjCode() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

isValidForOOE(originationCode, kfsChartCode,  kfsObjectCode))

This service is used to validate KFS object codes by origination code. Returns an XML result set with a value of true or false (example isValidForOOEResult) 

Input Specifications:

IndexParameterDescriptionRequired?Data Type (max length)
0originationCodeThe origination code (e.g. FM)YesString (4)
1kfsChartCodeThe KFS chart codeYesString (2)
2kfsObjectCodeThe KFS object codeYesString (4)


Result Schema: 

ParameterDescriptionData TypeExample
validValid for OOE Rulesbooleanfalse
matchingRuleIdThe ruleId matched (could match on success or failure)Integer

23

WS Example

Request SOAP
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidForOOE>
         <originationCode>FM</originationCode>
         <kfsChartCode>IR</kfsChartCode>
         <kfsObjectCode>3900</kfsObjectCode>
      </adc:isValidForOOE>
   </soapenv:Body>
</soapenv:Envelope>
Response SOAP
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidForOOEResponse xmlns:ns2="http://www.adcom.uci.edu" xmlns:ns3="uri:ultima:thule">
         <return>
            <valid>true</valid>
            <matchingRuleId>105</matchingRuleId>
         </return>
      </ns2:isValidForOOEResponse>
   </soap:Body>
</soap:Envelope>
Request REST
Code Block
WebServices/DWHRESTServer/rest/ooe/validate?originationCode=FM&kfsChartCode=IR&kfsObjectCode=3900
Response REST JSON
Code Block
{"valid":true,"matchingRuleId":105}

...

isValidForGOE(kfsChartCode, kfsAccountNumber,  kfsObjectCode))

This service is used to validate KFS object code - account number combinations. Returns an XML result set with a value of true or false (example isValidForOOEResult) 

Input Specifications:

IndexParameterDescriptionRequired?Data Type (max length)
1kfsChartCodeThe KFS chart codeYesString (2)
2kfsAccountNumberThe KFS account numberYesString(7)
3kfsObjectCodeThe KFS object codeYesString (4)


Result Schema: 

ParameterDescriptionData TypeExample
validValid for GOE Rulesbooleanfalse
matchingRuleIdThe ruleId matched (could match on success or failure)Integer

23

WS Example

Request SOAP
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidForGOE>
         <kfsChartCode>IR</kfsChartCode>
         <kfsAccountNumber>SS11828</kfsAccountNumber>
         <kfsObjectCode>ASTS</kfsObjectCode>
      </adc:isValidForGOE>
   </soapenv:Body>
</soapenv:Envelope>
Response SOAP
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidForGOEResponse xmlns:ns2="http://www.adcom.uci.edu" xmlns:ns3="uri:ultima:thule">
         <return>
            <valid>true</valid>
            <matchingRuleId>0</matchingRuleId>
         </return>
      </ns2:isValidForGOEResponse>
   </soap:Body>
</soap:Envelope>
Request REST
Code Block
WebServices/DWHRESTServer/rest/goe/validate?kfsChartCode=IR&kfsAccountNumber=SS11828&kfsObjectCode=ASTS
Response REST JSON
Code Block
{"valid":true,"matchingRuleId":0}

...

getValidKFSObjects(List of (kfsFiscalYear, kfsChartCode,  kfsObjCode))

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

Input Specifications:

IndexParameterDescriptionRequired?Data Type (max length)
0kfsFiscalYearThe KFS Fiscal Year (e.g. 2013)YesString (4)
1kfsChartCodeThe KFS chart of accounts codeYesString (2)
2kfsObjCodeThe KFS object codeYesString (4)

...

DB ParameterJava ParameterDescriptionData TypeExample
UNIV_FISCAL_YR
kfsFiscalYearKFS Fiscal YearString (4)2012
FIN_COA_CD
kfsChartCodeKFS Chart CodeString (2)'IR'
FIN_OBJECT_CD
kfsObjCodeKFS Object CodeString (4)'CASH'
FIN_OBJ_CD_NM
kfsObjCodeNameKFS Object Code NameString (40) 
FIN_OBJ_CD_SHRT_NM
kfsObjCodeShortNameKFS Object Code Short NameString (12) 
FIN_OBJ_LEVEL_CD
kfsObjLevelCodeKFS Object Level CodeString (4) 
RPTS_TO_FIN_COA_CD
kfsReportToChartCodeKFS Reports To Chart CodeString (2) 
RPTS_TO_FIN_OBJ_CD
kfsReportToObjCode

KFS Reports To Object Code

String (4) 
FIN_OBJ_TYP_CD
kfsObjTypeCodeKFS Object Type CodeString (2) 
FIN_OBJ_SUB_TYP_CD
kfsObjSubTypeCodeKFS Object Sub Type CodeString (2) 
HIST_FIN_OBJECT_CD
kfsHistoryObjCodeKFS History Object CodeString (4) 
FIN_OBJ_ACTIVE_CD
kfsObjActiveCodeKFS Object Active CodeString (1) 
FOBJ_BDGT_AGGR_CD

kfsFObjBudgetAggrCode

KFS FObject Budget Aggregation CodeString (1) 
FOBJ_MNXFR_ELIM_CD
kfsFObjMnxferElimCodeKFS FObject Minimum Transfer Elimination CodeString (1) 
FIN_FED_FUNDED_CD
kfsFedFundedCodeKFS Federal Funded CodeString (1) 
NXT_YR_FIN_OBJ_CD
kfsNextYearObjCodeKFS Next Year Object CodeString (4) 
RSCH_BDGT_CTGRY_CD
kfsResearchBudgetCatCodeKFS Research Budget Category CodeString (3) 
RSCH_OBJ_CD_DESC
kfsResearchObjCodeDescKFS Research Object Code DescriptionString (200) 
RSCH_ON_CMP_IND
kfsResearchOnCampusCodeKFS Research On Campus IndicatorString (1) 

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:getValidKFSObjects>
         <kfsObjectList>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
         </kfsObjectList>
         <kfsObjectList>
            <kfsChartCode>MC</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>1100</kfsObjCode>
         </kfsObjectList>
         <kfsObjectList>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2013</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
         </kfsObjectList>
      </adc:getValidKFSObjects>
   </soapenv:Body>
</soapenv:Envelope> 

...

Result Schema: SAME as getValidKFSObjects

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

...

ParameterDescriptionData TypeExample
kfsFiscalYearThe KFS Fiscal YearString (4)2012
kfsChartCodeThe KFS Chart CodeString (2)IR
fsLocationCodeThe FS location codeString (2)9
fsSubCodeThe FS Sub CodeString (2)03
fsObjectCodeThe FS Object CodeString (4)8096
kfsObjCodeThe KFS Object CodeString (4)8160

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:translateFSObjects>
         <fsObjectList>
            <fsLocationCode>9</fsLocationCode>
            <fsObjectCode>8096</fsObjectCode>
            <fsSubCode>03</fsSubCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
         </fsObjectList>
         <fsObjectList>
            <fsLocationCode>R</fsLocationCode>
            <fsObjectCode>8096</fsObjectCode>
            <fsSubCode>03</fsSubCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
         </fsObjectList>
         <fsObjectList>
            <fsLocationCode>0</fsLocationCode>
            <fsObjectCode>0000</fsObjectCode>
            <fsSubCode>00</fsSubCode>
            <kfsChartCode>00</kfsChartCode>
            <kfsFiscalYear>0000</kfsFiscalYear>
         </fsObjectList>
      </adc:translateFSObjects>
   </soapenv:Body>
</soapenv:Envelope>

...

This service is used retrieve valid KFS object codes and related attributes for income and balance sheet accounts. Returns an XML result set with a list of objects.

Input Specifications:

IndexParameterDescriptionRequired?Data Type (max length)
0kfsFiscalYearThe KFS Fiscal Year (e.g. 2013)YesString (4)
1kfsChartCodeThe KFS chart of accounts codeYesString (2)
2fsLocationCodeThe FS Location CodeYesString (1)

...

DB ParameterJava ParameterDescriptionData TypeExample
UC_LOC_CD
fsLocationCodeFS Location CodeString(1)9
UC_SUB_CD
fsSubCodeFS Sub CodeString(2)9H
UC_OBJECT_CD
fsObjCodeFS Object CodeString(4)3800
UC_ACCT_NBR
fsAccountCodeFS Account NumberString(6)803000
UNIV_FISCAL_YR
kfsFiscalYearKFS Fiscal YearString (4)2013
FIN_COA_CD
kfsChartCodeKFS Chart CodeString (2)IR
FIN_OBJECT_CD
kfsObjCodeKFS Object CodeString (4)3800

 

WS Example

Request
Code Block
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:getAllFSAccountToKFSObject xmlns:ns2="http://www.adcom.uci.edu">
			<accountToObjectTranslateParameters>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</accountToObjectTranslateParameters>
		</ns2:getAllFSAccountToKFSObject>
	</S:Body>
</S:Envelope>

...