Page Comparison

...

Table of Contents

isValidKFSObjects(List of (kfsFiscalYear, kfsChartCode,

...

kfsObjCode))

This service is used retrieve valid to validate KFS object codes and related attributes for income and balance sheet accounts. Returns an XML result set with a list of objects.value of true or false (example isValidKFSCharts result) for each chart

Input Specifications:

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	The KFS chart of accounts code	Yes	String (2)
2	fsLocationCodekfsObjCode	The FS Location CodeKFS object code	Yes	String (14)

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
dwhs_ods..ca_object_code_t 
WHERE 	ACTIVE_IND <> 'N' AND
	(
	(UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH') OR 
	(UNIV_FISCAL_YR = '20132012' AND 	FIN_COA_CD = 'IRMC' AND 	UCFIN_LOCOBJECT_CD = '9'

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

...

UC_LOC_CD

...

UC_ACCT_NBR

...

UNIV_FISCAL_YR

...

1100') OR 
	(UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH')
);

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	'2013'
FIN_COA_CD	kfsChartCode	KFS Chart CodeThe KFS chart of accounts code	String (2)	IR	FIN_OBJECT_CD 'IR'
kfsObjCode	The KFS Object Code	String (4)	3800

...

	'CASH'
isValid	Is the Object Active?	boolean	true

WS Example

Request

Code Block

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

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidKFSObjects>
         <kfsObjectList>
            <kfsChartCode>MC</kfsChartCode>
<return>             <kfsChartCode>MC<<kfsFiscalYear>2012</kfsChartCode>kfsFiscalYear>
            <kfsFObjBudgetAggrCode>C<<kfsObjCode>1100</kfsFObjBudgetAggrCode>kfsObjCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode></kfsObjectList>
          <kfsObjectList>
 <kfsFedFundedCode>N</kfsFedFundedCode>             <kfsFiscalYear>2012<<kfsChartCode>IR</kfsFiscalYear>kfsChartCode>
            <kfsHistoryObjCode>1100<<kfsFiscalYear>2012</kfsHistoryObjCode>kfsFiscalYear>
            <kfsObjActiveCode>Y<<kfsObjCode>CASH</kfsObjActiveCode>kfsObjCode>
            <kfsObjCode>1100</kfsObjCode></kfsObjectList>
         <kfsObjectList>
  <kfsObjCodeName>Mgmt/Supervisors</kfsObjCodeName>             <kfsObjCodeShortName>Mgmt/Superv</kfsObjCodeShortName><kfsChartCode>IR</kfsChartCode>
            <kfsObjLevelCode>SUPP<<kfsFiscalYear>2013</kfsObjLevelCode>kfsFiscalYear>
            <kfsObjSubTypeCode>SW<<kfsObjCode>CASH</kfsObjSubTypeCode>kfsObjCode>
            <kfsObjTypeCode>EX</kfsObjTypeCode></kfsObjectList>
      </adc:isValidKFSObjects>
   </soapenv:Body>
 <kfsReportToChartCode>IR</kfsReportToChartCode></soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
        <kfsReportToObjCode>1100</kfsReportToObjCode><ns2:isValidKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
 </return>       </ns2:getValidKFSObjectsResponse>    <<kfsChartCode>IR</soap:Body>
</soap:Envelope>

Java Client Example

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<ObjectDetails> resultList11 = ds.getValidKFSObjects(pl10);
if (resultList10 != null) {
	for (Iterator i = resultList11.iterator(); i.hasNext();) {
		ObjectDetails element = (ObjectDetails) i.next();
		System.out.println("getValidObj-FiscalYr / ChartCode / ObjCode : ObjCodeName" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsObjCode() + " : " + element.getKfsObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

Table of Contents

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

This service is used to validate KFS object codes. Returns an XML result set with a value of true or false (example isValidKFSCharts result) for each chart

Input Specifications:

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	The KFS chart code	Yes	String (2)
2	kfsObjCode	The KFS object code	Yes	String (4)

DB Query:

Code Block

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD 
FROM 
dwhs_ods..ca_object_code_t 
WHERE (
	(UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH') OR 
	(UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'MC' AND FIN_OBJECT_CD = '1100') OR 
	(UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH')
);

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	'2013'
kfsChartCode	The KFS chart of accounts code	String (2)	'IR'
kfsObjCode	The KFS Object Code	String (4)	'CASH'
isValid	Is the Object Active?	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:isValidKFSObjects>
         <kfsObjectList>
            <kfsChartCode>MC</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>1100</kfsObjCode>
         </kfsObjectList>
         <kfsObjectList>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
         </kfsObjectList>
         <kfsObjectList>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2013</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
         </kfsObjectList>
      </adc:isValidKFSObjects>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
            <valid>false</valid>
         </return>
         <return>
            <kfsChartCode>MC</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>1100</kfsObjCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2013</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
            <valid>false</valid>
         </return>
      </ns2:isValidKFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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");
}

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:

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	The KFS chart of accounts code	Yes	String (2)
2	kfsObjCode	The KFS object code	Yes	String (4)

DB Query:

Code Block

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR
      ,FIN_COA_CD
      ,FIN_OBJECT_CD
      ,FIN_OBJ_CD_NM
      ,FIN_OBJ_CD_SHRT_NM
      ,FIN_OBJ_LEVEL_CD
      ,RPTS_TO_FIN_COA_CD
      ,RPTS_TO_FIN_OBJ_CD
      ,FIN_OBJ_TYP_CD
      ,FIN_OBJ_SUB_TYP_CD
      ,HIST_FIN_OBJECT_CD
      ,FIN_OBJ_ACTIVE_CD
      ,FOBJ_BDGT_AGGR_CD
      ,FOBJ_MNXFR_ELIM_CD
      ,FIN_FED_FUNDED_CD
      ,NXT_YR_FIN_OBJ_CD
      ,RSCH_BDGT_CTGRY_CD
      ,RSCH_OBJ_CD_DESC
      ,RSCH_ON_CMP_IND
  FROM dwhs_ods..ca_object_code_t
  WHERE FIN_OBJ_ACTIVE_CD <> 'N' AND 
  ((UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH') OR 
   (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'MC' AND FIN_OBJECT_CD = '1100') OR 
   (UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH'));

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

DB Parameter	Java Parameter	Description	Data Type	Example
UNIV_FISCAL_YR	kfsFiscalYear	KFS Fiscal Year	String (4)	2012
FIN_COA_CD	kfsChartCode	KFS Chart Code	String (2)	'IR'
FIN_OBJECT_CD	kfsObjCode	KFS Object Code	String (4)	'CASH'
FIN_OBJ_CD_NM	kfsObjCodeName	KFS Object Code Name	String (40)
FIN_OBJ_CD_SHRT_NM	kfsObjCodeShortName	KFS Object Code Short Name	String (12)
FIN_OBJ_LEVEL_CD	kfsObjLevelCode	KFS Object Level Code	String (4)
RPTS_TO_FIN_COA_CD	kfsReportToChartCode	KFS Reports To Chart Code	String (2)
RPTS_TO_FIN_OBJ_CD	kfsReportToObjCode	KFS Reports To Object Code	String (4)
FIN_OBJ_TYP_CD	kfsObjTypeCode	KFS Object Type Code	String (2)
FIN_OBJ_SUB_TYP_CD	kfsObjSubTypeCode	KFS Object Sub Type Code	String (2)
HIST_FIN_OBJECT_CD	kfsHistoryObjCode	KFS History Object Code	String (4)
FIN_OBJ_ACTIVE_CD	kfsObjActiveCode	KFS Object Active Code	String (1)
FOBJ_BDGT_AGGR_CD	kfsFObjBudgetAggrCode	KFS FObject Budget Aggregation Code	String (1)
FOBJ_MNXFR_ELIM_CD	kfsFObjMnxferElimCode	KFS FObject Minimum Transfer Elimination Code	String (1)
FIN_FED_FUNDED_CD	kfsFedFundedCode	KFS Federal Funded Code	String (1)
NXT_YR_FIN_OBJ_CD	kfsNextYearObjCode	KFS Next Year Object Code	String (4)
RSCH_BDGT_CTGRY_CD	kfsResearchBudgetCatCode	KFS Research Budget Category Code	String (3)
RSCH_OBJ_CD_DESC	kfsResearchObjCodeDesc	KFS Research Object Code Description	String (200)
RSCH_ON_CMP_IND	kfsResearchOnCampusCode	KFS Research On Campus Indicator	String (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>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSObjectsResponse xmlns:ns2kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
            <valid>false</valid>
         </return>
         <return>
            <kfsChartCode>MC</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>1100</kfsObjCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2013</kfsFiscalYear>
            <kfsObjCode>CASH</kfsObjCode>
            <valid>false</valid>
         </return>
      </ns2:isValidKFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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");
}

...

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:

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	The KFS chart of accounts code	Yes	String (2)
2	kfsObjCode	The KFS object code	Yes	String (4)

DB Query:

Code Block

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR
      ,FIN_COA_CD
      ,FIN_OBJECT_CD
      ,FIN_OBJ_CD_NM
      ,FIN_OBJ_CD_SHRT_NM
      ,FIN_OBJ_LEVEL_CD
      ,RPTS_TO_FIN_COA_CD
      ,RPTS_TO_FIN_OBJ_CD
      ,FIN_OBJ_TYP_CD
      ,FIN_OBJ_SUB_TYP_CD
      ,HIST_FIN_OBJECT_CD
      ,FIN_OBJ_ACTIVE_CD
      ,FOBJ_BDGT_AGGR_CD
      ,FOBJ_MNXFR_ELIM_CD
      ,FIN_FED_FUNDED_CD
      ,NXT_YR_FIN_OBJ_CD
      ,RSCH_BDGT_CTGRY_CD
      ,RSCH_OBJ_CD_DESC
      ,RSCH_ON_CMP_IND
  FROM dwhs_ods..ca_object_code_t
  WHERE FIN_OBJ_ACTIVE_CD <> 'N' AND 
  ((UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH') OR 
   (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'MC' AND FIN_OBJECT_CD = '1100') OR 
   (UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH'));

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

DB Parameter	Java Parameter	Description	Data Type	Example
UNIV_FISCAL_YR	kfsFiscalYear	KFS Fiscal Year	String (4)	2012
FIN_COA_CD	kfsChartCode	KFS Chart Code	String (2)	'IR'
FIN_OBJECT_CD	kfsObjCode	KFS Object Code	String (4)	'CASH'
FIN_OBJ_CD_NM	kfsObjCodeName	KFS Object Code Name	String (40)
FIN_OBJ_CD_SHRT_NM	kfsObjCodeShortName	KFS Object Code Short Name	String (12)
FIN_OBJ_LEVEL_CD	kfsObjLevelCode	KFS Object Level Code	String (4)
RPTS_TO_FIN_COA_CD	kfsReportToChartCode	KFS Reports To Chart Code	String (2)
RPTS_TO_FIN_OBJ_CD	kfsReportToObjCode	KFS Reports To Object Code	String (4)
FIN_OBJ_TYP_CD	kfsObjTypeCode	KFS Object Type Code	String (2)
FIN_OBJ_SUB_TYP_CD	kfsObjSubTypeCode	KFS Object Sub Type Code	String (2)
HIST_FIN_OBJECT_CD	kfsHistoryObjCode	KFS History Object Code	String (4)
FIN_OBJ_ACTIVE_CD	kfsObjActiveCode	KFS Object Active Code	String (1)
FOBJ_BDGT_AGGR_CD	kfsFObjBudgetAggrCode	KFS FObject Budget Aggregation Code	String (1)
FOBJ_MNXFR_ELIM_CD	kfsFObjMnxferElimCode	KFS FObject Minimum Transfer Elimination Code	String (1)
FIN_FED_FUNDED_CD	kfsFedFundedCode	KFS Federal Funded Code	String (1)
NXT_YR_FIN_OBJ_CD	kfsNextYearObjCode	KFS Next Year Object Code	String (4)
RSCH_BDGT_CTGRY_CD	kfsResearchBudgetCatCode	KFS Research Budget Category Code	String (3)
RSCH_OBJ_CD_DESC	kfsResearchObjCodeDesc	KFS Research Object Code Description	String (200)
RSCH_ON_CMP_IND	kfsResearchOnCampusCode	KFS Research On Campus Indicator	String (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>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsChartCode>MC</kfsChartCode>
            <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsHistoryObjCode>1100</kfsHistoryObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>1100</kfsObjCode>
            <kfsObjCodeName>Mgmt/Supervisors</kfsObjCodeName>
            <kfsObjCodeShortName>Mgmt/Superv</kfsObjCodeShortName>
            <kfsObjLevelCode>SUPP</kfsObjLevelCode>
            <kfsObjSubTypeCode>SW</kfsObjSubTypeCode>
            <kfsObjTypeCode>EX</kfsObjTypeCode>
            <kfsReportToChartCode>IR</kfsReportToChartCode>
            <kfsReportToObjCode>1100</kfsReportToObjCode>
         </return>
      </ns2:getValidKFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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<ObjectDetails> resultList11 = ds.getValidKFSObjects(pl10);
if (resultList10 != null) {
	for (Iterator i = resultList11.iterator(); i.hasNext();) {
		ObjectDetails element = (ObjectDetails) i.next();
		System.out.println("getValidObj-FiscalYr / ChartCode / ObjCode : ObjCodeName" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsObjCode() + " : " + element.getKfsObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

getAllKFSObjects()

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

DB Query:

Code Block

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR
      ,FIN_COA_CD
      ,FIN_OBJECT_CD
      ,FIN_OBJ_CD_NM
      ,FIN_OBJ_CD_SHRT_NM
      ,FIN_OBJ_LEVEL_CD
      ,RPTS_TO_FIN_COA_CD
      ,RPTS_TO_FIN_OBJ_CD
      ,FIN_OBJ_TYP_CD
      ,FIN_OBJ_SUB_TYP_CD
      ,HIST_FIN_OBJECT_CD
      ,FIN_OBJ_ACTIVE_CD
      ,FOBJ_BDGT_AGGR_CD
      ,FOBJ_MNXFR_ELIM_CD
      ,FIN_FED_FUNDED_CD
      ,NXT_YR_FIN_OBJ_CD
      ,RSCH_BDGT_CTGRY_CD
      ,RSCH_OBJ_CD_DESC
      ,RSCH_ON_CMP_IND
  FROM dwhs_ods..ca_object_code_t
  WHERE FIN_OBJ_ACTIVE_CD <> 'N'

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>
 <return>     <adc:getAllKFSObjects/>
   </soapenv:Body>
   <kfsChartCode>MC</kfsChartCode></soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
        <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode><ns2:getAllKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
  <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>             <kfsFedFundedCode>N</kfsFedFundedCode><kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012<<kfsFObjBudgetAggrCode>C</kfsFiscalYear>kfsFObjBudgetAggrCode>
            <kfsHistoryObjCode>1100<<kfsFObjMnxferElimCode>N</kfsHistoryObjCode>kfsFObjMnxferElimCode>
            <kfsObjActiveCode>Y<<kfsFedFundedCode>N</kfsObjActiveCode>kfsFedFundedCode>
            <kfsObjCode>1100<<kfsFiscalYear>2012</kfsObjCode>kfsFiscalYear>
            <kfsObjCodeName>Mgmt<kfsHistoryObjCode>1000</Supervisors</kfsObjCodeName>kfsHistoryObjCode>
            <kfsObjCodeShortName>Mgmt<kfsNextYearObjCode>0</Superv</kfsObjCodeShortName>kfsNextYearObjCode>
            <kfsObjLevelCode>SUPP<<kfsObjActiveCode>Y</kfsObjLevelCode>kfsObjActiveCode>
            <kfsObjSubTypeCode>SW</kfsObjSubTypeCode><kfsObjCode>1000</kfsObjCode>
            <kfsObjCodeName>SALARIES &amp; WAGES <kfsObjTypeCode>EX<ACADEMIC</kfsObjTypeCode>kfsObjCodeName>
            <kfsObjCodeShortName>SALARIES &amp; <kfsReportToChartCode>IR<W</kfsReportToChartCode>kfsObjCodeShortName>
            <kfsReportToObjCode>1100</kfsReportToObjCode><kfsObjLevelCode>SWAC</kfsObjLevelCode>
            <<kfsObjSubTypeCode>SW</return>kfsObjSubTypeCode>
        </ns2:getValidKFSObjectsResponse>    <<kfsObjTypeCode>EX</soap:Body>
</soap:Envelope>

Java Client Example

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<ObjectDetails> resultList11 = ds.getValidKFSObjects(pl10);
if (resultList10 != null) {
	for (Iterator i = resultList11.iterator(); i.hasNext();) {
		ObjectDetails element = (ObjectDetails) i.next();
		System.out.println("getValidObj-FiscalYr / ChartCode / ObjCode : ObjCodeName" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsObjCode() + " : " + element.getKfsObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

getAllKFSObjects()

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

DB Query:

Code Block

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR
      ,FIN_COA_CD
      ,FIN_OBJECT_CD
      ,FIN_OBJ_CD_NM
      ,FIN_OBJ_CD_SHRT_NM
      ,FIN_OBJ_LEVEL_CD
      ,RPTS_TO_FIN_COA_CD
      ,RPTS_TO_FIN_OBJ_CD
      ,FIN_OBJ_TYP_CD
      ,FIN_OBJ_SUB_TYP_CD
      ,HIST_FIN_OBJECT_CD
      ,FIN_OBJ_ACTIVE_CD
      ,FOBJ_BDGT_AGGR_CD
      ,FOBJ_MNXFR_ELIM_CD
      ,FIN_FED_FUNDED_CD
      ,NXT_YR_FIN_OBJ_CD
      ,RSCH_BDGT_CTGRY_CD
      ,RSCH_OBJ_CD_DESC
      ,RSCH_ON_CMP_IND
  FROM dwhs_ods..ca_object_code_t
  WHERE FIN_OBJ_ACTIVE_CD <> 'N'

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>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsHistoryObjCode>1000</kfsHistoryObjCode>
            <kfsNextYearObjCode>0</kfsNextYearObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>1000</kfsObjCode>
            <kfsObjCodeName>SALARIES &amp; WAGES ACADEMIC</kfsObjCodeName>
            <kfsObjCodeShortName>SALARIES &amp; W</kfsObjCodeShortName>
            <kfsObjLevelCode>SWAC</kfsObjLevelCode>
            <kfsObjSubTypeCode>SW</kfsObjSubTypeCode>
            <kfsObjTypeCode>EX</kfsObjTypeCode>
            <kfsReportToChartCode>UC</kfsReportToChartCode>
            <kfsReportToObjCode>9999</kfsReportToObjCode>
         </return>
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
 kfsObjTypeCode>
            <kfsReportToChartCode>UC</kfsReportToChartCode>
            <kfsReportToObjCode>9999</kfsReportToObjCode>
         </return>
         <return>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsHistoryObjCode>1091</kfsHistoryObjCode>
            <kfsNextYearObjCode>0</kfsNextYearObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>1091</kfsObjCode>
            <kfsObjCodeName>1991-92 FACULTY MERITS AND PROMOTION</kfsObjCodeName>
            <kfsObjCodeShortName>1991-92 FACU</kfsObjCodeShortName>
            <kfsObjLevelCode>SGEN</kfsObjLevelCode>
            <kfsObjSubTypeCode>SW</kfsObjSubTypeCode>
            <kfsObjTypeCode>EX</kfsObjTypeCode>
            <kfsReportToChartCode>UC</kfsReportToChartCode>
            <kfsReportToObjCode>9999</kfsReportToObjCode>
         </return>
	 ...
	 ...
      </ns2:getAllKFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

List<ObjectDetails> resultList11 = ds.getAllKFSObjects();
if (resultList11 != null) {
	System.out.println("getAllObj-total size: " + resultList11.size());
	System.out.println("getAllObj-1st item FiscalYr / ChartCode / ObjCode: " + ((ObjectDetails)resultList11.get(0)).getKfsFiscalYear() + " / " + ((ObjectDetails)resultList11.get(0)).getKfsChartCode() + " / " + ((ObjectDetails)resultList11.get(0)).getKfsObjCode());
} else {
	System.out.println("something bad happened...please check your query");
}

translateFSObjects(List of (kfsFiscalYear, kfsChartCode, fsLocationCode, fsSubCode, fsObjectCode))

This service is used to translate legacy FS object to KFS object codes.

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year	Yes	String (4)
1	kfsChartCode	The KFS Chart Code	Yes	String (2)
2	fsLocationCode	The FS Location Code	Yes	String (2)
3	fsObjectCode	The FS Object Code	Yes	String (4)
4	fsSubCode	The FS Sub Code	Yes	String (2)

DB Query

Code Block

SELECT UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD, UC_LOC_CD, UC_OBJECT_CD, UC_SUB_CD
FROM uci_ca_object_code_xw_t
WHERE ACTIVE_IND <> 'N' AND
(
  (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND UC_LOC_CD = '9' AND UC_OBJECT_CD = '8096' AND UC_SUB_CD = '03') OR
  (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND UC_LOC_CD = 'R' AND UC_OBJECT_CD = '8088' AND UC_SUB_CD = '03') OR
  (UNIV_FISCAL_YR = '0000' AND FIN_COA_CD = '00' AND UC_LOC_CD = '0' AND UC_OBJECT_CD = '0000' AND UC_SUB_CD = '00')
)

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	2012
kfsChartCode	The KFS Chart Code	String (2)	IR
fsLocationCode	The FS location code	String (2)	9
fsSubCode	The FS Sub Code	String (2)	03
fsObjectCode	The FS Object Code	String (4)	8096
kfsObjCode	The KFS Object Code	String (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>
<kfsFedFundedCode>N</kfsFedFundedCode>             <kfsFiscalYear>2012<<fsLocationCode>9</kfsFiscalYear>fsLocationCode>
            <kfsHistoryObjCode>1091<<fsObjectCode>8096</kfsHistoryObjCode>fsObjectCode>
            <kfsNextYearObjCode>0<<fsSubCode>03</kfsNextYearObjCode>fsSubCode>
            <kfsObjActiveCode>Y<<kfsChartCode>IR</kfsObjActiveCode>kfsChartCode>
            <kfsObjCode>1091<<kfsFiscalYear>2012</kfsObjCode>kfsFiscalYear>
         </fsObjectList>
  <kfsObjCodeName>1991-92   FACULTY MERITS AND PROMOTION</kfsObjCodeName> <fsObjectList>
           <kfsObjCodeShortName>1991-92 FACU<<fsLocationCode>R</kfsObjCodeShortName>fsLocationCode>
            <kfsObjLevelCode>SGEN<<fsObjectCode>8096</kfsObjLevelCode>fsObjectCode>
            <kfsObjSubTypeCode>SW<<fsSubCode>03</kfsObjSubTypeCode>fsSubCode>
            <kfsObjTypeCode>EX<<kfsChartCode>IR</kfsObjTypeCode>kfsChartCode>
            <kfsReportToChartCode>UC<<kfsFiscalYear>2012</kfsReportToChartCode>kfsFiscalYear>
         </fsObjectList>
  <kfsReportToObjCode>9999</kfsReportToObjCode>       <fsObjectList>
  </return> 	 ... 	 ...       <<fsLocationCode>0</ns2:getAllKFSObjectsResponse>fsLocationCode>
   </soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService(); DWHServer ds = dss.getDWHServerPort(); <fsObjectCode>0000</fsObjectCode>
 List<ObjectDetails> resultList11 = ds.getAllKFSObjects(); if (resultList11 != null) { 	System.out.println("getAllObj-total size: "<fsSubCode>00</fsSubCode>
+ resultList11.size()); 	System.out.println("getAllObj-1st item FiscalYr / ChartCode / ObjCode: " + ((ObjectDetails)resultList11.get(0)).getKfsFiscalYear() + " / " + ((ObjectDetails)resultList11.get(0)).getKfsChartCode() + " / " + ((ObjectDetails)resultList11.get(0)).getKfsObjCode());
} else {
	System.out.println("something bad happened...please check your query");
}

translateFSObjects(List of (kfsFiscalYear, kfsChartCode, fsLocationCode, fsSubCode, fsObjectCode))

This service is used to translate legacy FS object to KFS object codes.

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year	Yes	String (4)
1	kfsChartCode	The KFS Chart Code	Yes	String (2)
2	fsLocationCode	The FS Location Code	Yes	String (2)
3	fsObjectCode	The FS Object Code	Yes	String (4)
4	fsSubCode	The FS Sub Code	Yes	String (2)

DB Query

Code Block

SELECT UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD, UC_LOC_CD, UC_OBJECT_CD, UC_SUB_CD
FROM uci_ca_object_code_xw_t
WHERE ACTIVE_IND <> 'N' AND
(
  (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND UC_LOC_CD = '9' AND UC_OBJECT_CD = '8096' AND UC_SUB_CD = '03') OR
  (UNIV_FISCAL_YR = '2012' AND FIN_COA_CD = 'IR' AND UC_LOC_CD = 'R' AND UC_OBJECT_CD = '8088' AND UC_SUB_CD = '03') OR
  (UNIV_FISCAL_YR = '0000' AND FIN_COA_CD = '00' AND UC_LOC_CD = '0' AND UC_OBJECT_CD = '0000' AND UC_SUB_CD = '00')
)

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	2012
kfsChartCode	The KFS Chart Code	String (2)	IR
fsLocationCode	The FS location code	String (2)	9
fsSubCode	The FS Sub Code	String (2)	03
fsObjectCode	The FS Object Code	String (4)	8096
kfsObjCode	The KFS Object Code	String (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>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsLocationCode>9</fsLocationCode>
            <fsObjCode>8096</fsObjCode>
            <fsSubCode>03</fsSubCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>8160</kfsObjCode>
         </return>
      </ns2:translateFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

ArrayList<ObjectTranslateParameters> pl13 = new ArrayList<ObjectTranslateParameters>();
ObjectTranslateParameters otp130 = new ObjectTranslateParameters();
otp130.setFsLocationCode("9");
otp130.setKfsFiscalYear("2012");
otp130.setKfsChartCode("IR");
otp130.setFsSubCode("03");
otp130.setFsObjectCode("8096");
ObjectTranslateParameters otp131 = new ObjectTranslateParameters();
otp131.setFsLocationCode("R");
otp131.setKfsFiscalYear("2012");
otp131.setKfsChartCode("IR");
otp131.setFsSubCode("03");
otp131.setFsObjectCode("8096");
ObjectTranslateParameters otp132 = new ObjectTranslateParameters();
otp132.setFsLocationCode("0");
otp132.setKfsFiscalYear("0000");
otp132.setKfsChartCode("00");
otp132.setFsSubCode("00");
otp132.setFsObjectCode("0000");
pl13.add(otp130);
pl13.add(otp131);
pl13.add(otp132);
List<Fs2KFSObjectDetails> resultList13 = ds.translateFSObjects(pl13);
if (resultList13 != null) {
	for (Iterator i = resultList13.iterator(); i.hasNext();) {
		Fs2KFSObjectDetails element = (Fs2KFSObjectDetails) i.next() <kfsChartCode>00</kfsChartCode>
            <kfsFiscalYear>0000</kfsFiscalYear>
         </fsObjectList>
      </adc:translateFSObjects>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsLocationCode>9</fsLocationCode>
            <fsObjCode>8096</fsObjCode>
            <fsSubCode>03</fsSubCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>8160</kfsObjCode>
         </return>
      </ns2:translateFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

ArrayList<ObjectTranslateParameters> pl13 = new ArrayList<ObjectTranslateParameters>();
ObjectTranslateParameters otp130 = new ObjectTranslateParameters();
otp130.setFsLocationCode("9");
otp130.setKfsFiscalYear("2012");
otp130.setKfsChartCode("IR");
otp130.setFsSubCode("03");
otp130.setFsObjectCode("8096");
ObjectTranslateParameters otp131 = new ObjectTranslateParameters();
otp131.setFsLocationCode("R");
otp131.setKfsFiscalYear("2012");
otp131.setKfsChartCode("IR");
otp131.setFsSubCode("03");
otp131.setFsObjectCode("8096");
ObjectTranslateParameters otp132 = new ObjectTranslateParameters();
otp132.setFsLocationCode("0");
otp132.setKfsFiscalYear("0000");
otp132.setKfsChartCode("00");
otp132.setFsSubCode("00");
otp132.setFsObjectCode("0000");
pl13.add(otp130);
pl13.add(otp131);
pl13.add(otp132);
List<Fs2KFSObjectDetails> resultList13 = ds.translateFSObjects(pl13);
if (resultList13 != null) {
	for (Iterator i = resultList13.iterator(); i.hasNext();) {
		Fs2KFSObjectDetails element = (Fs2KFSObjectDetails) i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getFsLocationCode() + "/" + element.getFsObjCode() + "/" + element.getFsSubCode() + " : " + element.getKfsObjCode()); }
} else {
	System.out.println("something bad happened...please check your query");
}

...

getAllFSAccountToKFSObject(kfsFiscalYear, kfsChartCode, fsLocationCode))

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:

Index	Parameter	Description	Required?	Data Type (max length)
0	kfsFiscalYear	The KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	The KFS chart of accounts code	Yes	String (2)
2	fsLocationCode	The FS Location Code	Yes	String (1)

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
	UNIV_FISCAL_YR = '2013' AND
	FIN_COA_CD = 'IR' AND
	UC_LOC_CD = '9'

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

DB Parameter	Java Parameter	Description	Data Type	Example
UC_LOC_CD	fsLocationCode	FS Location Code	String(1)	9
UC_ACCT_NBR	fsAccountCode	FS Account Number	String(6)	803000
UNIV_FISCAL_YR	kfsFiscalYear	KFS Fiscal Year	String (4)	2013
FIN_COA_CD	kfsChartCode	KFS Chart Code	String (2)	IR
FIN_OBJECT_CD	kfsObjCode	KFS Object Code	String (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>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:getAllFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<fsAccountCode>223609</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>R010</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>223610</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>R010</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>223611</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>R010</kfsObjCode>
			</return>
			...
		</ns2:getAllFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
		
AccountToObjectTranslateParameters atop = new AccountToObjectTranslateParameters();
atop.setFsLocationCode("9");
atop.setKfsFiscalYear("2013");
atop.setKfsChartCode("IR");
		
List<FsAccount2KFSObjectDetails> resultList = server.getAllFSAccountToKFSObject(atop);
if (resultList != null) {
	for (FsAccount2KFSObjectDetails fod : resultList) {
		System.out.println("fsLocationCode   : " + fod.getFsLocationCode());
		System.out.println("fsAccountCode    : " + fod.getFsAccountCode());
		System.out.println("\tkfsFiscalYear    : " + elementfod.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getFsLocationCode() + "/" + element.getFsObjCode() + "/" + element.getFsSubCode() + ");
		System.out.println("kfsChartCode     : " + fod.getKfsChartCode());
		System.out.println("kfsObjectCode    : " + elementfod.getKfsObjCode());
		System.out.println("--------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 42	New Version 43
Changes made by	Jarrod Lannan	Jarrod Lannan
Saved on	Jan 07, 2013	Jan 07, 2013

Page Comparison

Versions Compared

Key

isValidKFSObjects(List of (kfsFiscalYear, kfsChartCode,

kfsObjCode))

Input Specifications:

DB Query:

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

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

WS Example

Request

Response

Response

Java Client Example

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

Input Specifications:

DB Query:

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

WS Example

Request

Response

Java Client Example

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

Input Specifications:

DB Query:

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

WS Example

Request

Response

Java Client Example

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

Input Specifications:

DB Query:

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

WS Example

Request

Response

Java Client Example

getAllKFSObjects()

DB Query:

Result Schema: SAME as getValidKFSObjects

WS Example

Request

Response

Java Client Example

getAllKFSObjects()

DB Query:

Result Schema: SAME as getValidKFSObjects

WS Example

Request

Response

Java Client Example

translateFSObjects(List of (kfsFiscalYear, kfsChartCode, fsLocationCode, fsSubCode, fsObjectCode))

Input Specifications

DB Query

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

WS Example

Request

Java Client Example

translateFSObjects(List of (kfsFiscalYear, kfsChartCode, fsLocationCode, fsSubCode, fsObjectCode))

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

Response

Java Client Example

getAllFSAccountToKFSObject(kfsFiscalYear, kfsChartCode, fsLocationCode))

Input Specifications:

DB Query:

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

WS Example

Request

Response

Java Client Example