...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
| 1 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 9052 |
...
| 8282 |
| Code Block |
|---|
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') ); |
DB Query
Result Schema: A list of following elements (OrganizationDetails.java)
...
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
ArrayList<OrganizationTranslateParameters> pl23 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp230 = new OrganizationTranslateParameters();
otp230.setFsHierarchyCode("0003");
otp230.setFsLocationCode("9");
OrganizationTranslateParameters otp231 = new OrganizationTranslateParameters();
otp231.setFsHierarchyCode("0302");
otp231.setFsLocationCode("9");
OrganizationTranslateParameters otp232 = new OrganizationTranslateParameters();
otp232.setFsHierarchyCode("0000");
otp232.setFsLocationCode("0");
pl23.add(otp230);
pl23.add(otp231);
pl23.add(otp232);
List<Fs2KFSOrganizationDetails> resultList23 = ds.translateFSDepartments(pl23);
if (resultList23 != null) {
for (Iterator i = resultList23.iterator(); i.hasNext();) {
Fs2KFSOrganizationDetails element = (Fs2KFSOrganizationDetails) i.next();
System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsHierarchyCode() + "/" + element.getFsHierarchyType() + " : " + element.getKfsChartCode() + "/" + element.getKfsOrgCode());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
translateMedCompKFSOrgToKFSAccount(kfsChartCode, kfsOrganizationCode)
This service is used to translate a KFS Organization to a KFS Account (used by Labor Ledger feed). Returns an XML result set with a KFS Account and KFS Chart if found.
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
| 1 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 8282 |
DB Query
| Code Block |
|---|
SELECT KFS_COA_CD, KFS_ACCOUNT_NBR
FROM UCI_LD_MED_COMP_XW_T
WHERE PPS_COA_CD = 'IR' AND PPS_ORG_CD = '8282' |
Result Schema: A list of following elements (MedCompAccount.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsChartCode | KFS Chart Code | String(2) | IR |
| kfsAcctNumber | KFS Account Number | String(4) | SS11574 |
WS Example
Request
| Code Block |
|---|
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:translateMedCompKFSOrgToKFSAccount xmlns:ns2="http://www.adcom.uci.edu">
<kfsOrganization>
<kfsChartCode>IR</kfsChartCode>
<kfsOrgCode>8282</kfsOrgCode>
</kfsOrganization>
</ns2:translateMedCompKFSOrgToKFSAccount>
</S:Body>
</S:Envelope> |
Response
| Code Block |
|---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:translateMedCompKFSOrgToKFSAccountResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsAcctNumber>SS11574</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
</return>
</ns2:translateMedCompKFSOrgToKFSAccountResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
| Code Block |
|---|
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
OrganizationParameters orgParam = new OrganizationParameters();
orgParam.setKfsChartCode("IR");
orgParam.setKfsOrgCode("8282");
MedCompAccount medCompAccount = server.translateMedCompKFSOrgToKFSAccount(orgParam);
if (medCompAccount != null) {
System.out.println(medCompAccount.getKfsChartCode() + " " + medCompAccount.getKfsAcctNumber());
}
else {
System.out.println("something bad happened...please check your query");
} |
...