...
Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer
...
isValidKFSOrganizations(List of (kfsOrgCode, kfsChartCode))
...
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
StringArray sa120 = new StringArray();
sa120.getItem().add("IR");
sa120.getItem().add("9052");
StringArray sa121 = new StringArray();
sa121.getItem().add("IR");
sa121.getItem().add("9053");
StringArray sa122 = new StringArray();
sa122.getItem().add("IR");
sa122.getItem().add("1111");
StringArray sa123 = new StringArray();
sa123.getItem().add("XX");
sa123.getItem().add("9054");
List<OrganizationValidation> resultList12 = ds.isValidKFSOrganizations(Arrays.asList(sa120, sa121, sa122, sa123));
if (resultList12 != null) {
for (Iterator i = resultList12.iterator(); i.hasNext();) {
OrganizationValidation element = (OrganizationValidation)i.next();
System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsOrgCode() + " : " + element.isValid());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
getValidKFSOrganizations(List of (kfsOrgCode, kfsChartCode))
...
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
StringArray sa130 = new StringArray();
sa130.getItem().add("IR");
sa130.getItem().add("9052");
StringArray sa131 = new StringArray();
sa131.getItem().add("IR");
sa131.getItem().add("9053");
StringArray sa132 = new StringArray();
sa132.getItem().add("IR");
sa132.getItem().add("1111");
StringArray sa133 = new StringArray();
sa133.getItem().add("XX");
sa133.getItem().add("9054");
List<OrganizationDetails> resultList13 = ds.getValidKFSOrganizations(Arrays.asList(sa130, sa131,sa132,sa133));
if (resultList13 != null) {
for (Iterator i = resultList13.iterator(); i.hasNext();) {
OrganizationDetails element = (OrganizationDetails)i.next();
System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsOrgCode() + " : " + element.getKfsOrgName());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
getAllKFSOrganizations()
No input parameter, ALL active KFS organization details will be returned in result set.
...
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
List<OrganizationDetails> resultList14 = ds.getAllKFSOrganizations();
if (resultList14 != null) {
//for (Iterator i = resultList14.iterator(); i.hasNext();) {
// OrganizationDetails element = (OrganizationDetails)i.next();
//}
System.out.println("total size: " + resultList14.size());
System.out.println("the 1st item ChartCode / OrgCode: OrgName" + ((OrganizationDetails)resultList14.get(0)).getKfsChartCode() + " / " + ((OrganizationDetails)resultList14.get(0)).getKfsOrgCode() + " : " + ((OrganizationDetails)resultList14.get(0)).getKfsOrgName());
} else {
System.out.println("something bad happened...please check your query");
} |
...
translateFSOrganizations(List of (fsLocationCode, fsOrganizationCode
...
))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
| 1 | fsOrganizationCode | FS Organization Code | No | String(4) | 10009030 |
DB Query
| Code Block |
|---|
selectSELECT FIN_COA_CD, ORG_CD from, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T whereWHERE ucUC_locLOC_cd CD= '9' andAND ucUC_hierarchyHIERARCHY_cd CD= '03029030' andAND ucUC_hierarchyHIERARCHY_typeTYPE_cd CD= 'O'; |
Result Schema: A list of following elements (OrganizationValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4)9052 | 9903 |
| fsHierarchyType | FS Hierarchy Type | String | O |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 9030 |
WS Example
Request
| Code Block |
|---|
|
Response
| Code Block |
|---|
|
Java Client Example
| Code Block |
|---|
|
...
translateFSDivisions(List of (fsLocationCode, fsDivsionCode))
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
| 1 | fsDivsionCode | FS Division Code | Yes | String(4) | 12001003 |
DB Query
| Code Block |
|---|
selectSELECT FIN_COA_CD, ORG_CD from, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T whereWHERE ucUC_locLOC_cd CD= '9' andAND ucUC_hierarchyHIERARCHY_cd CD= '03021003' andAND ucUC_hierarchyHIERARCHY_typeTYPE_cd CD= 'V'; |
Result Schema: A list of following elements (OrganizationValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
...
| 9801 | |||
| fsHierarchyType | FS Hierarchy Type | String | V |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 1003 |
WS Example
Request
| Code Block |
|---|
|
Response
| Code Block |
|---|
|
Java Client Example
| Code Block |
|---|
|
...
translateFSSubDivisions(List of (fsLocationCode, fsSubDivisionCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
| 1 | fsSubDivisionCode | FS SubDivisionCode | No | String(4) | 12501003 |
DB Query
| Code Block |
|---|
selectSELECT FIN_COA_CD, ORG_CD, from UCI_UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T whereWHERE ucUC_locLOC_cd CD= '9' andAND ucUC_hierarchyHIERARCHY_cd CD= '03021003' andAND ucUC_hierarchyHIERARCHY_typeTYPE_cd CD= 'S'; |
Result Schema: A list of following elements (OrganizationValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
...
| 9001 | |||
| fsHierarchyType | FS Hierarchy Type | String | S |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 1003 |
WS Example
Request
| Code Block |
|---|
|
Response
| Code Block |
|---|
|
Java Client Example
| Code Block |
|---|
|
...
translateFSDepartments(List of (fsLocationCode, fsDepartmentCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
| 1 | fsDepartmentCode | FS DepartmentCode | No | String(4) | 0302 |
DB Query
| Code Block |
|---|
selectSELECT FIN_COA_CD, ORG_CD from UCI_CA_, UC_LOC_CD, UC_HIERARCHY_CD, UC_HIERARCHY_TYPE_CD FROM UCI_CA_ORG_XW_T whereWHERE ucUC_locLOC_cd CD= '9' andAND ucUC_hierarchyHIERARCHY_cd CD= '0302' andAND ucUC_hierarchyHIERARCHY_typeTYPE_cd CD= 'D' ; |
Result Schema: A list of following elements (
...
FS2KFSOrganizationDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
...
| 0302 | |||
| fsHierarchyType | FS Hierarchy Type | String | D |
| fsLocationCode | FS Location Code | String | 9 |
| fsHierarchyCode | FS Hierarchy Code | String | 0302 |
WS Example
Request
| Code Block |
|---|
|
Response
| Code Block |
|---|
|
Java Client Example
| Code Block |
|---|
|
...
fsHierarchyCodeFS Hierarchy CodeString