Web Services - KFS Organization

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

Parameter	Description	Required?	Data Type (max length)	Example
kfsOrgCode	KFS Organization Code	Yes	String(4)	9052
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

DB Query

SELECT a.FIN_COA_CD as \"Chart Code\", ");
sql.append(" a.org_cd as \"Organization Code \", ");
sql.append(" a.org_nm as \"Organization Name \", ");
sql.append(" a.RPTS_TO_FIN_COA_CD as \"Reports to Chart Code\", ");

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 RC 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	kfsDfltAcctNumber	KFS DFLT 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	kfsReportsToChartCode	KFS Reports To Chart Code	String
RPTS_TO_ORG_NBR	kfsReportsToOrgNumber	KFS Reports To Organization Number	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.