...
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
| Code Block |
|---|
SELECTSELECT CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN 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') ) |
...
| 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= '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') ) |
...