Page Comparison

...

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();

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, fsHierarchyCode))

...

getKFSAccountManagersByOrg(String kfsChartCode, String kfsOrgCode, boolean traverseAllChildOrgs)

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	fsLocationCodekfsChartCode	FS Location KFS Chart Code	Yes	String(12)	9IR
1	fsHierarchyCodekfsOrgCode	FS KFS Organization Code	NoYes	String(4)2000	9017
2	traverseAllChildOrgs	Traverse children of KFS Organization provided in parameter	Yes	boolean	false

DB Query

Code Block

SELECT 
WITH ChildOrgList AS ( 
SELECT ChildOrg.ORG_CD, ChildOrg.FIN_COA_CD,  ChildOrg.ORG_CDNM, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD  0 AS ORG_LEVEL 
FROM UCI_CA_ORG_XW_T T WHERE UC_HIERARCHY_TYPE_CD='O' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='2000') OR 
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='3000') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') 
);

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)	9022
fsHierarchyType	FS Hierarchy Type	String	O
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	2000

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSOrganizations>
         <fsOrganizationList>
            <fsHierarchyCode>2000</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>3000</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSOrganizations>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http:AS ChildOrg 
WHERE ChildOrg.FIN_COA_CD = 'IR' AND ChildOrg.ORG_CD = '9017'
UNION ALL 
SELECT ChildOrg.ORG_CD, ChildOrg.FIN_COA_CD, ChildOrg.ORG_NM, ORG_LEVEL + 1 AS ORG_LEVEL 
FROM CA_ORG_T AS ChildOrg 
INNER JOIN ChildOrgList AS Child ON ChildOrg.RPTS_TO_FIN_COA_CD = Child.FIN_COA_CD and ChildOrg.RPTS_TO_ORG_CD = Child.ORG_CD 
) 
SELECT distinct o.*, a.ACCOUNT_NBR, a.ACCOUNT_NM, e.ucinetid, e.first_name, e.last_name, e.primary_title_code, e.primary_title, e.ph_title, e.phone, 
       p.postalAddress line_address, p.l as city, p.st as state, p.postalCode as zip, p.uciZotCode 
FROM ChildOrgList o 
INNER JOIN CA_ACCOUNT_T a on (a.FIN_COA_CD = o.FIN_COA_CD and a.ORG_CD = o.ORG_CD) 
INNER JOIN dwhs_ppscurr..employee_basic e on (a.ACCT_MGR_UNVL_ID = e.CAMPUS_ID) 
INNER JOIN dwhs_ppscurr..ldap_people p on (p.uid = e.ucinetid) 
where o.ORG_LEVEL = 0

Result Schema: SAME as getValidKFSOrganizations

WS Example

Request

Code Block

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:getKFSAccountManagersByOrg xmlns:ns2="http://www.adcom.uci.edu">
			<kfsChartCode>IR</kfsChartCode>
			<kfsOrgCode>9017</kfsOrgCode>
			<traverseAllChildOrgs>false</traverseAllChildOrgs>
		</ns2:getKFSAccountManagersByOrg>
	</S:Body>
</S:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   	<soap:Body>
      		<ns2:translateFSOrganizationsResponsegetKFSAccountManagersByOrgResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsHierarchyCode>2000</fsHierarchyCode>
            <fsHierarchyType>O</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9022</kfsOrgCode>
         </return>
         <return>
            <fsHierarchyCode>3000</fsHierarchyCode>
            <fsHierarchyType>O</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9002</kfsOrgCode>			<return>
				<acctMgrCity>Irvine</acctMgrCity>
				<acctMgrFirstNme>FIRST</acctMgrFirstNme>
				<acctMgrLastName>LAST</acctMgrLastName>
				<acctMgrLineAddress>1400 Biological Sciences III</acctMgrLineAddress>
				<acctMgrPhTitle>Director Accounting Systems</acctMgrPhTitle>
				<acctMgrPhone>(949) 824-1234</acctMgrPhone>
				<acctMgrPrimaryTitle>DIR</acctMgrPrimaryTitle>
				<acctMgrPrimaryTitleCode>0245</acctMgrPrimaryTitleCode>
				<acctMgrState>CA</acctMgrState>
				<acctMgrUciZotCode>1050</acctMgrUciZotCode>
				<acctMgrZip>92697</acctMgrZip>
				<acctName>407618-19906 ACADEMIC COMPUTING</acctName>
				<acctNumber>GF11482</acctNumber>
				<orgChartCode>IR</orgChartCode>
				<orgCode>9017</orgCode>
				<orgName>OFFICE OF INFORMATION TECHNOLOGY</orgName>
			</return>
			...
		</ns2:getKFSAccountManagersByOrgResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();

List<AccountManagerDetails> resultList = server.getKFSAccountManagersByOrg("IR", "9017", false);

if (resultList != null) {
for (AccountManagerDetails amd : resultList) {
System.out.println("Account Manager Details" + amd);
}
}
else {
System.out.println("something bad happened...please check your query");
}

...

translateFSOrganizations(List of (fsLocationCode, fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS Organization Code	No	String(4)	2000

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='O' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='2000') OR 
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='3000') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000') 
);

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)	9022
fsHierarchyType	FS Hierarchy Type	String	O
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	2000

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSOrganizations>
         <fsOrganizationList>
            <fsHierarchyCode>2000</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>3000</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSOrganizations>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSOrganizationsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsHierarchyCode>2000</fsHierarchyCode>
            <fsHierarchyType>O</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9022</kfsOrgCode>
         </return>
         <return>
            <fsHierarchyCode>3000</fsHierarchyCode>
            <fsHierarchyType>O</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9002</kfsOrgCode>
         </return>
      </ns2:translateFSOrganizationsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl20 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp200 = new OrganizationTranslateParameters();
otp200.setFsHierarchyCode("2000");
otp200.setFsLocationCode("9");
OrganizationTranslateParameters otp201 = new OrganizationTranslateParameters();
otp201.setFsHierarchyCode("3000");
otp201.setFsLocationCode("9");
OrganizationTranslateParameters otp202 = new OrganizationTranslateParameters();
otp202.setFsHierarchyCode("0000");
otp202.setFsLocationCode("0");
pl20.add(otp200);
pl20.add(otp201);
pl20.add(otp202);
List<Fs2KFSOrganizationDetails> resultList20 = ds.translateFSOrganizations(pl20);
if (resultList20 != null) {
	for (Iterator i = resultList20.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");
}

...

translateFSDivisions(List of (fsLocationCode, fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS Division Code	Yes	String(4)	1015

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='V' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1015') OR 
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1100') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	9006
fsHierarchyType	FS Hierarchy Type	String	V
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	1015

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSDivisions>
         <fsOrganizationList>
 </return>       </ns2:translateFSOrganizationsResponse>    </soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl20 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp200 = new OrganizationTranslateParameters();
otp200.setFsHierarchyCode("2000");
otp200.setFsLocationCode("9");
OrganizationTranslateParameters otp201 = new OrganizationTranslateParameters();
otp201.setFsHierarchyCode("3000");
otp201.setFsLocationCode("9");
OrganizationTranslateParameters otp202 = new OrganizationTranslateParameters();
otp202.setFsHierarchyCode("0000");
otp202.setFsLocationCode("0");
pl20.add(otp200);
pl20.add(otp201);
pl20.add(otp202);
List<Fs2KFSOrganizationDetails> resultList20 = ds.translateFSOrganizations(pl20);
if (resultList20 != null) {
	for (Iterator i = resultList20.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");
}

translateFSDivisions(List of (fsLocationCode, fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS Division Code	Yes	String(4)	1015

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='V' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1015') OR 
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1100') OR 
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	9006
fsHierarchyType	FS Hierarchy Type	String	V
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	1015

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv<fsHierarchyCode>1015</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>1100</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSDivisions>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSDivisions>.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSDivisionsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsHierarchyCode>1015</fsHierarchyCode>
            <fsHierarchyType>V</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9006</kfsOrgCode>
         </return>
         <return>
            <fsOrganizationList><fsHierarchyCode>1100</fsHierarchyCode>
            <fsHierarchyCode>1015<<fsHierarchyType>V</fsHierarchyCode>fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
           </fsOrganizationList> <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9012</kfsOrgCode>
         <fsOrganizationList></return>
      </ns2:translateFSDivisionsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss <fsHierarchyCode>1100</fsHierarchyCode>= new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl21 = new  <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSDivisions>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSDivisionsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsHierarchyCode>1015</fsHierarchyCode>
            <fsHierarchyType>V</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9006</kfsOrgCode>
         </return>
         <return>
            <fsHierarchyCode>1100</fsHierarchyCode>
            <fsHierarchyType>V</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9012</kfsOrgCode>ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp210 = new OrganizationTranslateParameters();
otp210.setFsHierarchyCode("1015");
otp210.setFsLocationCode("9");
OrganizationTranslateParameters otp211 = new OrganizationTranslateParameters();
otp211.setFsHierarchyCode("1100");
otp211.setFsLocationCode("9");
OrganizationTranslateParameters otp212 = new OrganizationTranslateParameters();
otp212.setFsHierarchyCode("0000");
otp212.setFsLocationCode("0");
pl21.add(otp210);
pl21.add(otp211);
pl21.add(otp212);
List<Fs2KFSOrganizationDetails> resultList21 = ds.translateFSDivisions(pl21);
if (resultList21 != null) {
	for (Iterator i = resultList21.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");
}

...

translateFSSubDivisions(List of (fsLocationCode,fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS SubDivisionCode	Yes	String(4)	1300

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='S' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1300') OR
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1350') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	9004
fsHierarchyType	FS Hierarchy Type	String	S
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	1300

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSSubDivisions>
         <fsOrganizationList>
 </return>       </ns2:translateFSDivisionsResponse>    <<fsHierarchyCode>1300</soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl21 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp210 = new OrganizationTranslateParameters();
otp210.setFsHierarchyCode("1015");
otp210.setFsLocationCode("9");
OrganizationTranslateParameters otp211 = new OrganizationTranslateParameters();
otp211.setFsHierarchyCode("1100");
otp211.setFsLocationCode("9");
OrganizationTranslateParameters otp212 = new OrganizationTranslateParameters();
otp212.setFsHierarchyCode("0000");
otp212.setFsLocationCode("0");
pl21.add(otp210);
pl21.add(otp211);
pl21.add(otp212);
List<Fs2KFSOrganizationDetails> resultList21 = ds.translateFSDivisions(pl21);
if (resultList21 != null) {
	for (Iterator i = resultList21.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");
}

translateFSSubDivisions(List of (fsLocationCode,fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS SubDivisionCode	Yes	String(4)	1300

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='S' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1300') OR
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='1350') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	9004
fsHierarchyType	FS Hierarchy Type	String	S
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	1300

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenvfsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>1350</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSSubDivisions>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSSubDivisionsResponse xmlns:adcns2="http://www.adcom.uci.edu">
   <soapenv:Header/>    <soapenv:Body>  <return>
    <adc:translateFSSubDivisions>        <fsHierarchyCode>1300</fsHierarchyCode>
 <fsOrganizationList>             <fsHierarchyCode>1300<<fsHierarchyType>S</fsHierarchyCode>fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>          <fsOrganizationList>
            <fsHierarchyCode>1350</fsHierarchyCode><kfsChartCode>IR</kfsChartCode>
            <fsLocationCode>9<<kfsOrgCode>9004</fsLocationCode>kfsOrgCode>
         </fsOrganizationList>return>
         <fsOrganizationList>
            <fsHierarchyCode>0000</fsHierarchyCode>
         <return>
  <fsLocationCode>0</fsLocationCode>          <<fsHierarchyCode>1350</fsOrganizationList>fsHierarchyCode>
       </adc:translateFSSubDivisions>    </soapenv:Body> </soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><fsHierarchyType>S</fsHierarchyType>
    <soap:Body>       <ns2:translateFSSubDivisionsResponse xmlns:ns2="http://www.adcom.uci.edu"> <fsLocationCode>9</fsLocationCode>
         <return>   <kfsChartCode>IR</kfsChartCode>
         <fsHierarchyCode>1300</fsHierarchyCode>   <kfsOrgCode>9010</kfsOrgCode>
         <fsHierarchyType>S<</fsHierarchyType>return>
      </ns2:translateFSSubDivisionsResponse>
     <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9004</kfsOrgCode>
         </return>
         <return>
            <fsHierarchyCode>1350</fsHierarchyCode>
            <fsHierarchyType>S</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9010</kfsOrgCode>
         </return>
      </ns2:translateFSSubDivisionsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl22 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp220 = new OrganizationTranslateParameters();
otp220.setFsHierarchyCode("1300");
otp220.setFsLocationCode("9");
OrganizationTranslateParameters otp221 = new OrganizationTranslateParameters();
otp221.setFsHierarchyCode("1350");
otp221.setFsLocationCode("9");
OrganizationTranslateParameters otp222 = new OrganizationTranslateParameters();
otp222.setFsHierarchyCode("0000");
otp222.setFsLocationCode("0");
pl22.add(otp220);
pl22.add(otp221);
pl22.add(otp222);
List<Fs2KFSOrganizationDetails> resultList22 = ds.translateFSSubDivisions(pl22);
if (resultList22 != null) {
	for (Iterator i = resultList22.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");
}

translateFSDepartments(List of (fsLocationCode, fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS DepartmentCode	Yes	String(4)	0302

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='D' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='0302') OR
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='0003') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	0302
fsHierarchyType	FS Hierarchy Type	String	D
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	0302

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSDepartments></soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();

ArrayList<OrganizationTranslateParameters> pl22 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp220 = new OrganizationTranslateParameters();
otp220.setFsHierarchyCode("1300");
otp220.setFsLocationCode("9");
OrganizationTranslateParameters otp221 = new OrganizationTranslateParameters();
otp221.setFsHierarchyCode("1350");
otp221.setFsLocationCode("9");
OrganizationTranslateParameters otp222 = new OrganizationTranslateParameters();
otp222.setFsHierarchyCode("0000");
otp222.setFsLocationCode("0");
pl22.add(otp220);
pl22.add(otp221);
pl22.add(otp222);
List<Fs2KFSOrganizationDetails> resultList22 = ds.translateFSSubDivisions(pl22);
if (resultList22 != null) {
	for (Iterator i = resultList22.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");
}

...

translateFSDepartments(List of (fsLocationCode, fsHierarchyCode))

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	fsLocationCode	FS Location Code	Yes	String(1)	9
1	fsHierarchyCode	FS DepartmentCode	Yes	String(4)	0302

DB Query

Code Block

SELECT 
FIN_COA_CD, 
ORG_CD, 
UC_LOC_CD, 
UC_HIERARCHY_CD, 
UC_HIERARCHY_TYPE_CD 
FROM UCI_CA_ORG_XW_T 
WHERE UC_HIERARCHY_TYPE_CD='D' AND 
(
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='0302') OR
(UC_LOC_CD='9' AND UC_HIERARCHY_CD='0003') OR
(UC_LOC_CD='0' AND UC_HIERARCHY_CD='0000')
);

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)	0302
fsHierarchyType	FS Hierarchy Type	String	D
fsLocationCode	FS Location Code	String	9
fsHierarchyCode	FS Hierarchy Code	String	0302

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:translateFSDepartments>
         <fsOrganizationList>
            <fsHierarchyCode>0003</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0302</fsHierarchyCode>
            <fsLocationCode>9</fsLocationCode>
         </fsOrganizationList>
         <fsOrganizationList>
            <fsHierarchyCode>0003<<fsHierarchyCode>0000</fsHierarchyCode>
            <fsLocationCode>9<<fsLocationCode>0</fsLocationCode>
         </fsOrganizationList>
      </adc:translateFSDepartments>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
<fsOrganizationList>             <fsHierarchyCode>0302</fsHierarchyCode><ns2:translateFSDepartmentsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
  <fsLocationCode>9</fsLocationCode>          <<fsHierarchyCode>0003</fsOrganizationList>fsHierarchyCode>
         <fsOrganizationList>   <fsHierarchyType>D</fsHierarchyType>
         <fsHierarchyCode>0000</fsHierarchyCode>    <fsLocationCode>9</fsLocationCode>
        <fsLocationCode>0</fsLocationCode>          </fsOrganizationList><kfsChartCode>IR</kfsChartCode>
      </adc:translateFSDepartments>    </soapenv:Body> </soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
 <kfsOrgCode>9027</kfsOrgCode>
  <soap:Body>       <ns2:translateFSDepartmentsResponse xmlns:ns2="http://www.adcom.uci.edu"></return>
         <return>
            <fsHierarchyCode>0003<<fsHierarchyCode>0302</fsHierarchyCode>
            <fsHierarchyType>D</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>9027<<kfsOrgCode>8075</kfsOrgCode>
         </return>
      </ns2:translateFSDepartmentsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
 
ArrayList<OrganizationTranslateParameters> pl23 = new ArrayList<OrganizationTranslateParameters>();
OrganizationTranslateParameters otp230  <return>
            <fsHierarchyCode>0302</fsHierarchyCode>
            <fsHierarchyType>D</fsHierarchyType>
            <fsLocationCode>9</fsLocationCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsOrgCode>8075</kfsOrgCode>
         </return>
      </ns2:translateFSDepartmentsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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= 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() + "/ " + elementmedCompAccount.getKfsOrgCodegetKfsAcctNumber());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Version	Old Version 38	New Version Current
Changes made by	Jarrod Lannan	Jarrod Lannan
Saved on	Mar 08, 2013	Sept 18, 2014

Page Comparison

Versions Compared

Key

DB Query

Result Schema: A list of following elements (OrganizationDetails.java)

translateFSOrganizations(List of (fsLocationCode, fsHierarchyCode))

getKFSAccountManagersByOrg(String kfsChartCode, String kfsOrgCode, boolean traverseAllChildOrgs)

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Response

Result Schema: SAME as getValidKFSOrganizations

WS Example

Request

Response

Java Client Example

translateFSOrganizations(List of (fsLocationCode, fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Response

Java Client Example

translateFSDivisions(List of (fsLocationCode, fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Java Client Example

translateFSDivisions(List of (fsLocationCode, fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Response

Java Client Example

Response

translateFSSubDivisions(List of (fsLocationCode,fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Java Client Example

translateFSSubDivisions(List of (fsLocationCode,fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Response

Response

Java Client Example

translateFSDepartments(List of (fsLocationCode, fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Java Client Example

translateFSDepartments(List of (fsLocationCode, fsHierarchyCode))

Input Specifications

DB Query

Result Schema: A list of following elements (FS2KFSOrganizationDetails.java)

WS Example

Request

Response

Response

Java Client Example

Java Client Example

translateMedCompKFSOrgToKFSAccount(kfsChartCode, kfsOrganizationCode)

Input Specifications

DB Query

Result Schema: A list of following elements (MedCompAccount.java)

WS Example