Web Services - KFS Sub Object (Draft)

Usage

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

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

isValidKFSSubObject

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

SELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD 
FROM CA_SUB_OBJECT_CD_T 
WHERE FIN_SUBOBJ_ACTV_CD <> 'N' AND 
(
 (univ_fiscal_yr = 'pFiscalYear' AND 
  fin_coa_cd='pChartCode' AND 
  account_nbr='pKFSAccountCode' AND 
  fin_object_cd = 'pKFSObjectCode' AND 
  fin_sub_obj_cd = 'pKFSSubObject') OR 
 ()
)

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

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	'IR'
kfsAcctNumber	KFS Account Number	String (7)	'1234567'
isValid	Is the Chart/Account Active for that effective date (or today)?	boolean	true

WS Example

Request

Response

Java Client Example

getValidKFSSubObjects

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0
1

DB Query

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
(
(univ_fiscal_yr = 'pFiscalYear' AND 
  fin_coa_cd='pChartCode' AND 
  account_nbr='pKFSAccountCode' AND 
  fin_object_cd = 'pKFSObjectCode' AND 
  fin_sub_obj_cd = 'pKFSSubObject') OR 
()
)

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

Parameter	Description	Data Type	Example

WS Example

Request

Response

Java Client Example

getAllKFSSubObjects

No input parameter, ALL active KFS sub object details will be returned in result set.

DB Query

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'

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

Parameter	Description	Data Type	Example