Page Comparison

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer

...

isValidKFSSubObjects (List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

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	kfsObjectCodekfsObjCode	KFS Object Code	Yes	String (4)
4	kfsSubObjectCodekfsSubObjCode	KFS SubObject Sub Object Code	Yes	String (4)

DB Query

Code Block

SELECT 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 FINWHERE FIN_SUBOBJ_ACTV_CD <> 'N' AND 
(
 (univ_fiscal_yr = '2012' AND AND 
  fin_coa_cd='IR' AND AND 
  account_nbr='10007661000211' AND AND 
  fin_object_cd = 'CASH4400' AND AND 
  fin_sub_obj_cd = 'CASHBRM1') 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='10007661000211' AND 
  fin_object_cd = 'CASH0000' 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

Response

Code Block

Java Client Example

...

Code Block

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

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(List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

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	kfsObjectCodekfsObjCode	KFS Object Code	Yes	String (4)
4	kfsSubObjectCodekfsSubObjCode	KFS SubObject Sub Object Code	Yes	String (4)

DB Query

Code Block

SELECT 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, LEFT OUTER JOIN CA_OBJECT_CODE_T b 
WHEREON a.fin_object_cd = b.fin_object_cd AND 
WHERE 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= '10007661000211' AND 
  a.fin_object_cd = 'CASH4400' AND 
  a.fin_sub_obj_cd = 'CASHITM1') OR
 (a.univ_fiscal_yr = '2012' AND
  a.fin_coa_cd='IR' AND 
  a.account_nbr='10007661000211' AND 
  a.fin_object_cd = 'CASH0000' 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

Response

Code Block

Java Client Example

Code Block

getAllKFSSubObjects

...

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

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

...

getAllKFSSubObjects()

Input Specifications

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, LEFT OUTER JOIN CA_OBJECT_CODE_T b 
WHEREON a.fin_object_cd = b.fin_object_cd  AND
WHERE a.FIN_SUBOBJ_ACTV_CD <> 'N';

Result Schema:

...

Same as

...

getValidKfsObjects

WS Example

Request

Code Block

Response

Code Block

Java Client Example

Code Block

...

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

System.out.println("\nWSClient-getAllKFSSubObjects()");
List<SubObjectDetails> resultList24 = ds.getAllKFSSubObjects();
if (resultList24 != null) {
	for (Iterator i = resultList24.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 7	New Version Current
Changes made by	Adam Chang	Adam Chang
Saved on	Jul 26, 2012	Oct 24, 2012

Versions Compared

Key

Table of Contents

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer

isValidKFSSubObjects (List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getValidKFSSubObjects(List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

Input Specifications

DB Query

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

WS Example

Request

Response

Java Client Example

getAllKFSSubObjects

getAllKFSSubObjects()

Input Specifications

DB Query

Result Schema:

Same as

getValidKfsObjects

WS Example

Request

Response

Java Client Example