Usage
Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl
Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer
isValidKFSOrganizations(List of (kfsOrgCode, kfsChartCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 9052 |
| 1 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
DB Query
SELECT FIN_COA_CD, ORG_CD, ORG_ACTIVE_CD FROM CA_ORG_T a WHERE a.ORG_ACTIVE_CD <> 'N' AND ( (a.ORG_CD='9052' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9053' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='1111' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9054' AND a.FIN_COA_CD='XX') );
Result Schema: A list of following elements (OrganizationValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsOrgCode | KFS Organization Code | String(4) | 9052 |
| kfsChartCode | KFS Chart Code | String(2) | IR |
| isValid | Is the KFS Project Code valid? | boolean | true |
WS Example
Request
Response
Java Client Example
getValidKFSOrganizations(List of (kfsOrgCode, kfsChartCode))
This service is used retrieve valid KFS organizations and related attributes. Returns an XML result set with a list of organizations
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 9052 |
| 1 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
DB Query
SELECT FIN_COA_CD, ORG_CD, ORG_MGR_UNVL_ID, ORG_NM, RC_CD, ORG_PHYS_CMP_CD, ORG_TYP_CD, ORG_DFLT_ACCT_NBR, ORG_LN1_ADDR, ORG_LN2_ADDR, ORG_CITY_NM, ORG_STATE_CD, ORG_ZIP_CD, ORG_CNTRY_CD, ORG_BEGIN_DT, ORG_END_DT, RPTS_TO_FIN_COA_CD, RPTS_TO_ORG_CD, ORG_ACTIVE_CD, ORG_PLNT_ACCT_NBR, CMP_PLNT_ACCT_NBR, ORG_PLNT_COA_CD, CMP_PLNT_COA_CD FROM CA_ORG_T a WHERE a.ORG_ACTIVE_CD <> 'N' AND ( (a.ORG_CD='9052' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9053' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='1111' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9054' AND a.FIN_COA_CD='XX') );
Result Schema: A list of following elements (OrganizationDetails.java)
| DB Parameter | Java Parameter | Description | Data Type | Example |
|---|---|---|---|---|
| FIN_COA_CD | kfsChartCode | KFS Chart Code | String (2) | IR |
| ORG_CD | kfsOrgCode | KFS Organization Code | String (4) | 1234 |
| ORG_MGR_UNVL_ID | kfsOrgManagerId | KFS Organization Manager ID | String | |
| ORG_NM | kfsOrgName | KFS Organization Name | String | |
| RC_CD | kfsRCCode | KFS Responsibility Center Code | String | |
| ORG_PHYS_CMP_CD | kfsOrgCampusCode | KFS Organization Physical Campus Code | String | |
| ORG_TYP_CD | kfsOrgTypeCode | KFS Organization Type Code | String | |
| ORG_DFLT_ACCT_NBR | kfsOrgDefaultAcctNumber | KFS Default Account Number | String | |
| ORG_LN1_ADDR | kfsOrgAddr1 | KFS Address Line 1 | String | |
| ORG_LN2_ADDR | kfsOrgAddr2 | KFS Address Line 2 | String | |
| ORG_CITY_NM | kfsOrgCity | KFS Organization City Name | String | |
| ORG_STATE_CD | kfsOrgState | KFS Organization State Code | String | |
| ORG_ZIP_CD | kfsOrgZip | KFS Organization Zip Code | String | |
| ORG_CNTRY_CD | kfsOrgCountryCode | KFS Organization Country Code | String | |
| ORG_BEGIN_DT | kfsOrgBeginDate | KFS Organization Begin Date | String | |
| ORG_END_DT | kfsOrgEndDate | KFS Organization End Date | String | |
| RPTS_TO_FIN_COA_CD | kfsReportToChartCode | KFS Reports To Chart Code | String | |
| RPTS_TO_ORG_CD | kfsReportToOrgCode | KFS Reports To Organization Code | String | |
| ORG_ACTIVE_CD | kfsOrgActiveCode | KFS Organization Active Code | String | |
| ORG_PLNT_ACCT_NBR | kfsOrgPlantAcctNumber | KFS Organization Plant Account Number | String | |
| CMP_PLNT_ACCT_NBR | kfsCampusPlantAcctNumber | KFS Campus Plant Account Number | String | |
| ORG_PLNT_COA_CD | kfsOrgPlantChartCode | KFS Organization Plant Chart Code | String | |
| CMP_PLNT_COA_CD | kfsCampusPlantChartCode | KFS Campus Plant Chart Code | String |
WS Example
Request
Response
Java Client Example
getAllKFSOrganizations()
No input parameter, ALL active KFS organization details will be returned in result set.
DB Query
SELECT FIN_COA_CD, ORG_CD, ORG_MGR_UNVL_ID, ORG_NM, RC_CD, ORG_PHYS_CMP_CD, ORG_TYP_CD, ORG_DFLT_ACCT_NBR, ORG_LN1_ADDR, ORG_LN2_ADDR, ORG_CITY_NM, ORG_STATE_CD, ORG_ZIP_CD, ORG_CNTRY_CD, ORG_BEGIN_DT, ORG_END_DT, RPTS_TO_FIN_COA_CD, RPTS_TO_ORG_CD, ORG_ACTIVE_CD, ORG_PLNT_ACCT_NBR, CMP_PLNT_ACCT_NBR, ORG_PLNT_COA_CD, CMP_PLNT_COA_CD FROM CA_ORG_T WHERE ORG_ACTIVE_CD <> 'N';
Result Schema: SAME as getValidKFSOrganizations
WS Example
Request
Response
Java Client Example