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
| 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
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
| 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
(
(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
| 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' |
Result Schema: A list of following elements (Validation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
WS Example
Request
Response
Java Client Example
...