Page Comparison

isValidKFSSubObjects

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsFiscalYear	KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	KFS Chart Code	Yes	String (2)
2	kfsAcctNumber	KFS Account Number	Yes	String (7)	'1234567'
3	kfsObjectCode	KFS Object Code	Yes	String (4)
4	kfsSubObjectCode	KFS SubObject Code	Yes	String (4)

DB Query

Code Block

SELECT 
CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, 
FIN_COA_CD, 
ACCOUNT_NBR, 
FIN_OBJECT_CD, 
FIN_SUB_OBJ_CD, 
FIN_SUBOBJ_ACTV_CD
FROM CA_SUB_OBJECT_CD_T 
WHERE FIN_SUBOBJ_ACTV_CD <> 'N' AND 
(
 (univ_fiscal_yr = '2012' AND 
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '4400' AND 
  fin_sub_obj_cd = 'BRM1') OR 
 (univ_fiscal_yr = '2012' AND 
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '4400' AND 
  fin_sub_obj_cd = 'ITM1') OR
 (univ_fiscal_yr = '2012' AND
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '0000' AND 
  fin_sub_obj_cd = 'XXXX')
);

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	'2013'
kfsChartCode	The KFS chart of accounts code	String (2)	'IR'
kfsAcctNumber	KFS Account Number	String(7)	'1234567'
kfsObjCode	KFS Object Code	String (4)	'CASH'
kfsSubObjCode	KFS SubObject Code	String (4)	'CASH'
isValid	Is the SubObject 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:isValidKFSSubObjects>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>BRM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>ITM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>0000</item>
            <item>XXXX</item>
         </kfsSubObjectList>
      </adc:isValidKFSSubObjects>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSSubObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsSubObjCode>BRM1</kfsSubObjCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsSubObjCode>ITM1</kfsSubObjCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>0000</kfsObjCode>
            <kfsSubObjCode>XXXX</kfsSubObjCode>
            <valid>false</valid>
         </return>
      </ns2:isValidKFSSubObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

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

System.out.println("\nWSClient-isValidKFSSubObjects()");
StringArray sa220 = new StringArray();
sa220.getItem().add("2012");
sa220.getItem().add("IR");
sa220.getItem().add("1000211");
sa220.getItem().add("4400");
sa220.getItem().add("BRM1");
StringArray sa221 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("4400");
sa221.getItem().add("ITM1");
StringArray sa222 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("0000");
sa221.getItem().add("XXXX");
List<SubObjectValidation> resultList22 = ds.isValidKFSSubObjects(Arrays.asList(sa220, sa221, sa222));
if (resultList22 != null) {
	for (Iterator i = resultList22.iterator(); i.hasNext();) {
		SubObjectValidation element = (SubObjectValidation)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

getValidKFSSubObjects

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsFiscalYear	KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	KFS Chart Code	Yes	String (2)
2	kfsAcctNumber	KFS Account Number	Yes	String (7)	'1234567'
3	kfsObjectCode	KFS Object Code	Yes	String (4)
4	kfsSubObjectCode	KFS SubObject Code	Yes	String (4)

DB Query

Code Block

SELECT 
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd, 
a.account_nbr, 
a.fin_object_cd, 
b.fin_obj_cd_nm, 
a.fin_sub_obj_cd, 
a.fin_sub_obj_cd_nm 
FROM CA_SUB_OBJECT_CD_T a, CA_OBJECT_CODE_T b 
WHERE a.fin_object_cd = b.fin_object_cd AND a.FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'BRM1') OR 
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'ITM1') OR
 (a.univ_fiscal_yr = '2012' AND
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '0000' AND 
  a.fin_sub_obj_cd = 'XXXX')
);

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

DB Parameter	Java Parameter	Description	Data Type
UNIV_FISCAL_YR	kfsFiscalYear	KFS Fiscal Year	String (4)	2012
FIN_COA_CD	kfsChartCode	KFS Chart Code	String (2)	'IR'
ACCOUNT_NBM	kfsAcctNumber	KFS Account Number	String (7)	'1234567'
FIN_OBJECT_CD	kfsObjCode	KFS Object Code	String (4)	'CASH'
FIN_OBJ_CD_NM	kfsObjCodeName	KFS Object Code Name	String (40)
FIN_SUB_OBJ_CD	kfsSubObjCode	KFS SubObject Code	String (4)	'CASH'
FIN_SUB_OBJ_CD_NM	kfsSubObjCodeName	KFS SubObject Code Name	String (40)

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:getValidKFSSubObjects>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>BRM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>ITM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>0000</item>
            <item>XXXX</item>
         </kfsSubObjectList>      
      </adc:getValidKFSSubObjects>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSSubObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsObjCodeName>METERED MAIL</kfsObjCodeName>
            <kfsSubObjCode>BRM1</kfsSubObjCode>
            <kfsSubObjCodeName>BUSINESS REPLY MAIL</kfsSubObjCodeName>
         </return>
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsObjCodeName>METERED MAIL</kfsObjCodeName>
            <kfsSubObjCode>ITM1</kfsSubObjCode>
            <kfsSubObjCodeName>INTERNATIONAL MAIL</kfsSubObjCodeName>
         </return>
      </ns2:getValidKFSSubObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

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

System.out.println("\nWSClient-getValidKFSSubObjects()");
StringArray sa230 = new StringArray();
sa230.getItem().add("2012");
sa230.getItem().add("IR");
sa230.getItem().add("1000211");
sa230.getItem().add("4400");
sa230.getItem().add("BRM1");
StringArray sa231 = new StringArray();
sa231.getItem().add("2012");
sa231.getItem().add("IR");
sa231.getItem().add("1000211");
sa231.getItem().add("4400");
sa231.getItem().add("ITM1");
StringArray sa232 = new StringArray();
sa232.getItem().add("2012");
sa232.getItem().add("IR");
sa232.getItem().add("1000211");
sa232.getItem().add("0000");
sa232.getItem().add("XXXX");
List<SubObjectDetails> resultList23 = ds.getValidKFSSubObjects(Arrays.asList(sa230, sa231, sa232));
if (resultList23 != null) {
	for (Iterator i = resultList23.iterator(); i.hasNext();) {
		SubObjectDetails element = (SubObjectDetails)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.getKfsSubObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Version	Old Version 11	New Version 12
Changes made by	Adam Chang	Adam Chang
Saved on	Aug 31, 2012	Aug 31, 2012

Versions Compared

Key

Table of Contents

isValidKFSSubObjects

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getValidKFSSubObjects

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example