Usage
Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl
Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer
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
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='1000766' AND fin_object_cd = 'CASH' AND fin_sub_obj_cd = 'CASH') OR (univ_fiscal_yr = '2012' AND fin_coa_cd='IR' AND account_nbr='1000766' AND fin_object_cd = 'CASH' 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
Response
Java Client Example
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
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= '1000766' AND a.fin_object_cd = 'CASH' AND a.fin_sub_obj_cd = 'CASH') OR (a.univ_fiscal_yr = '2012' AND a.fin_coa_cd='IR' AND a.account_nbr='1000766' AND a.fin_object_cd = 'CASH' 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
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: Same as getValidKFSSubObjects()
WS Example
Request
Response
Java Client Example