Page Comparison

...

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

OLD:
SELECTSELECT 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 in= ('2012') andAND finFIN_coaCOA_cdCD IN= ('IR', 'MC') and AND FIN_OBJECT_CD IN= ('CASH');  OR NEW:
SELECT CONVERT(varchar(4),	(UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, = '2012' AND FIN_COA_CD, FIN_OBJECT_CD 
FROM 
dwhs_ods..ca_object_code_t 
WHERE (
	(UNIV_FISCAL_YR = '2012 = 'MC' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH1100') OR 
	(UNIV_FISCAL_YR = '20122013' AND FIN_COA_CD = 'MCIR' AND FIN_OBJECT_CD = '1100CASH')
OR 
	(UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR' AND FIN_OBJECT_CD = 'CASH')
);

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

);

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

...

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

...

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>true<<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> Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
StringArrayArrayList<ObjectParameters> sa90pl10 = new StringArrayArrayList<ObjectParameters>();
sa90.getItem().add
ObjectParameters op100 = new ObjectParameters();
op100.setKfsFiscalYear("2012");
sa90op100.getItemsetKfsChartCode().add("IRMC");
sa90op100.getItemsetKfsObjCode().add("CASH1100");
		
StringArray sa91ObjectParameters op101 = new StringArrayObjectParameters();
sa91.getItem().addop101.setKfsFiscalYear("2012");
sa91.getItem().addop101.setKfsChartCode("MCIR");
sa91.getItem().addop101.setKfsObjCode("1100CASH");
ObjectParameters op102 StringArray sa92 = new StringArrayObjectParameters();
sa92op102.getItemsetKfsFiscalYear("2013");
op102.addsetKfsChartCode("2013IR");
sa92op102.getItemsetKfsObjCode("CASH");
pl10.add("IR"op100);
sa92pl10.getItemadd(op101);
pl10.add("CASH"op102);


List<ObjectValidation> resultList9resultList10 = ds.isValidKFSObjects(Arrays.asList(sa90, sa91, sa92))pl10);
if (resultList9resultList10 != null) {
	for (Iterator i = resultList9resultList10.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))

...

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

...

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>IR<<kfsChartCode>MC</kfsChartCode>
            <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>
            <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsNextYearObjCode>0<<kfsHistoryObjCode>1100</kfsNextYearObjCode>kfsHistoryObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>CASH<<kfsObjCode>1100</kfsObjCode>
            <kfsObjCodeName>ACH BANK OF NEW YORK MELLON  BANK<<kfsObjCodeName>Mgmt/Supervisors</kfsObjCodeName>
            <kfsObjCodeShortName>ACH BNYM<<kfsObjCodeShortName>Mgmt/Superv</kfsObjCodeShortName>
            <kfsObjLevelCode>CASH<<kfsObjLevelCode>SUPP</kfsObjLevelCode>
            <kfsObjSubTypeCode>CA<<kfsObjSubTypeCode>SW</kfsObjSubTypeCode>
            <kfsObjTypeCode>CH<<kfsObjTypeCode>EX</kfsObjTypeCode>
            <kfsReportToChartCode>UC<<kfsReportToChartCode>IR</kfsReportToChartCode>
            <kfsReportToObjCode>9999<<kfsReportToObjCode>1100</kfsReportToObjCode>
         </return>
      </ns2:getValidKFSObjectsResponse>
  <return> </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
ArrayList<ObjectParameters> <kfsChartCode>MC</kfsChartCode>pl10 = new ArrayList<ObjectParameters>();
ObjectParameters op100 = new ObjectParameters();
op100.setKfsFiscalYear("2012");
op100.setKfsChartCode("MC");
op100.setKfsObjCode("1100");
ObjectParameters <kfsFObjBudgetAggrCode>C</kfsFObjBudgetAggrCode>op101 = new ObjectParameters();
op101.setKfsFiscalYear("2012");
op101.setKfsChartCode("IR");
op101.setKfsObjCode("CASH");
ObjectParameters op102 = new ObjectParameters();
 <kfsFObjMnxferElimCode>N</kfsFObjMnxferElimCode>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsHistoryObjCode>1100</kfsHistoryObjCode>
            <kfsNextYearObjCode>0</kfsNextYearObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>1100</kfsObjCode>
  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
  <kfsObjCodeName>Mgmt/Supervisors</kfsObjCodeName>    ,FIN_OBJ_CD_NM
        <kfsObjCodeShortName>Mgmt/Superv</kfsObjCodeShortName>,FIN_OBJ_CD_SHRT_NM
      ,FIN_OBJ_LEVEL_CD
     <kfsObjLevelCode>SWST</kfsObjLevelCode>
 ,RPTS_TO_FIN_COA_CD
      ,RPTS_TO_FIN_OBJ_CD
    <kfsObjSubTypeCode>SW</kfsObjSubTypeCode>  ,FIN_OBJ_TYP_CD
      ,FIN_OBJ_SUB_TYP_CD
   <kfsObjTypeCode>EX</kfsObjTypeCode>   ,HIST_FIN_OBJECT_CD
      ,FIN_OBJ_ACTIVE_CD
  <kfsReportToChartCode>IR</kfsReportToChartCode>    ,FOBJ_BDGT_AGGR_CD
      ,FOBJ_MNXFR_ELIM_CD
 <kfsReportToObjCode>1100</kfsReportToObjCode>     ,FIN_FED_FUNDED_CD
    </return>  ,NXT_YR_FIN_OBJ_CD
    </ns2:getValidKFSObjectsResponse>  ,RSCH_BDGT_CTGRY_CD
 </soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
System.out.println("\nWSClient--getValidKFSObjects()");
StringArray sa100 = new StringArray();
sa100.getItem().add("2012");
sa100.getItem().add("IR");
sa100.getItem().add("CASH");
		
StringArray sa101 = new StringArray();
sa101.getItem().add("2012");
sa101.getItem().add("MC");
sa101.getItem().add("1100");


StringArray sa102 = new StringArray();
sa102.getItem().add("2013");
sa102.getItem().add("IR");
sa102.getItem().add("CASH");
 
List<ObjectDetails> resultList10 = ds.getValidKFSObjects(Arrays.asList(sa100, sa101, sa102));
if (resultList10 != null) {
	for (Iterator i = resultList10.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"> ,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>
            <kfsFedFundedCode>N</kfsFedFundedCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsHistoryObjCode>1000<<kfsHistoryObjCode>1091</kfsHistoryObjCode>
            <kfsNextYearObjCode>0</kfsNextYearObjCode>
            <kfsObjActiveCode>Y</kfsObjActiveCode>
            <kfsObjCode>1000<<kfsObjCode>1091</kfsObjCode>
            <kfsObjCodeName>SALARIES &amp; WAGES ACADEMIC<<kfsObjCodeName>1991-92 FACULTY MERITS AND PROMOTION</kfsObjCodeName>
            <kfsObjCodeShortName>SALARIES &amp; W<<kfsObjCodeShortName>1991-92 FACU</kfsObjCodeShortName>
            <kfsObjLevelCode>SWAC<<kfsObjLevelCode>SGEN</kfsObjLevelCode>
            <kfsObjSubTypeCode>SW</kfsObjSubTypeCode>
            <kfsObjTypeCode>EX</kfsObjTypeCode>
            <kfsReportToChartCode>UC</kfsReportToChartCode>
            <kfsReportToObjCode>9999</kfsReportToObjCode>
         </return>
	 ...
	 ...
     <return> </ns2:getAllKFSObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds <kfsChartCode>IR</kfsChartCode>
= dss.getDWHServerPortCustom();

List<ObjectDetails> resultList11 = ds.getAllKFSObjects();
if (resultList11 != null) {
 <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.getDWHServerPortCustom();

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

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <fsSubCode>03</fsSubCode>
    <soap:Body>       <ns2:translateFSObjectsResponse xmlns:ns2="http://www.adcom.uci.edu"> <kfsChartCode>IR</kfsChartCode>
         <return>   <kfsFiscalYear>2012</kfsFiscalYear>
         <fiscalYear>2012</fiscalYear></fsObjectList>
         <fsObjectList>
            <fsLocationCode>9<<fsLocationCode>0</fsLocationCode>
            <fsObjectCode>8096<<fsObjectCode>0000</fsObjectCode>
            <fsSubCode>00</fsSubCode>
   <fsSubCode>03</fsSubCode>         <kfsChartCode>00</kfsChartCode>
            <kfsFiscalYear>0000</kfsFiscalYear>
         <kfsChartCode>IR<</kfsChartCode>fsObjectList>
      </adc:translateFSObjects>
   </soapenv:Body>
 <kfsObjCode>8160</kfsObjCode>
 </soapenv:Envelope>

Response

Code Block

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

Java Client Example

Code Block

DWHServerServiceArrayList<ObjectTranslateParameters> dsspl13 = new DWHServerServiceArrayList<ObjectTranslateParameters>();
DWHServerObjectTranslateParameters dsotp130 = dss.getDWHServerPortCustom();
 
StringArray sa330 = new StringArrayObjectTranslateParameters();
sa330otp130.getItemsetFsLocationCode().add("20129");
sa330otp130.getItemsetKfsFiscalYear().add("IR2012");
sa330.getItem().add("9");
sa330.getItem().add("8096otp130.setKfsChartCode("IR");
sa330otp130.getItemsetFsSubCode("03");
otp130.addsetFsObjectCode("038096");
ObjectTranslateParameters 
StringArray sa331otp131 = new StringArrayObjectTranslateParameters();
sa331otp131.getItemsetFsLocationCode().add("2012R");
sa331otp131.getItemsetKfsFiscalYear().add("IR2012");
sa331otp131.getItemsetKfsChartCode().add("RIR");
sa331otp131.getItemsetFsSubCode().add("809603");
sa331.getItem().addotp131.setFsObjectCode("038096");
ObjectTranslateParameters 
StringArray sa332otp132 = new StringArrayObjectTranslateParameters();
sa332otp132.getItemsetFsLocationCode("0");
otp132.addsetKfsFiscalYear("0000");
sa332otp132.getItemsetKfsChartCode("00");
otp132.addsetFsSubCode("00");
sa332otp132.getItemsetFsObjectCode().add("00000");
sa332pl13.getItemadd(otp130);
pl13.add("0000"otp131);
sa332pl13.getItem().add("00"otp132);
List<Fs2KFSObjectDetails> resultList33resultList13 = ds.translateFSObjects(Arrays.asList(sa330,sa331,sa332))pl13);
if (resultList33resultList13 != null) {
	for (Iterator i = resultList33resultList13.iterator(); i.hasNext();) {
		Fs2KFSObjectDetails element = (Fs2KFSObjectDetails) i.next();
		System.out.println("\t" + element.getFiscalYeargetKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getFsLocationCode() + "/" + element.getFsObjectCodegetFsObjCode() + "/" + element.getFsSubCode() + " : " + element.getkfsObjCodegetKfsObjCode()); 	}
} else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 38	New Version 39
Changes made by	Adam Chang	Adam Chang
Saved on	Sept 18, 2012	Sept 24, 2012

Versions Compared

Key

DB Query:

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

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

Java Client Example

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

Java Client Example

getAllKFSObjects()

DB Query:

Java Client Example

getAllKFSObjects()

DB Query:

Result Schema: SAME as getValidKFSObjects

WS Example

Request

Response

Result Schema: SAME as getValidKFSObjects

WS Example

Request

Response

Java Client Example

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

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

Response

Java Client Example