Page Comparison

Table of Contents

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

...

No input parameter, ALL active charts/accounts will return KFS account details will be returned in result set.

DB Query

Code Block

SELECT a.FIN_COA_CD
      ,a.ACCOUNT_NBR
      ,a.ACCOUNT_NM
      ,a.ACCT_FSC_OFC_UID
      ,a.ACCT_SPVSR_UNVL_ID
      ,a.ACCT_MGR_UNVL_ID
      ,a.ORG_CD
      ,a.ACCT_TYP_CD
      ,a.ACCT_PHYS_CMP_CD
      ,a.SUB_FUND_GRP_CD
      ,a.ACCT_FRNG_BNFT_CD
      ,a.FIN_HGH_ED_FUNC_CD
      ,a.ACCT_RSTRC_STAT_CD
      ,a.ACCT_RSTRC_STAT_DT
      ,a.ACCT_CITY_NM
      ,a.ACCT_STATE_CD
      ,a.ACCT_STREET_ADDR
      ,a.ACCT_ZIP_CD
      ,a.RPTS_TO_FIN_COA_CD
      ,a.RPTS_TO_ACCT_NBR
      ,a.ACCT_CREATE_DT
      ,a.ACCT_EFFECT_DT
      ,a.ACCT_EXPIRATION_DT
      ,a.CONT_FIN_COA_CD
      ,a.CONT_ACCOUNT_NBR
      ,a.ENDOW_FIN_COA_CD
      ,a.ENDOW_ACCOUNT_NBR
      ,a.CONTR_CTRL_FCOA_CD
      ,a.CONTR_CTRLACCT_NBR
      ,a.INCOME_FIN_COA_CD
      ,a.INCOME_ACCOUNT_NBR
      ,a.ACCT_ICR_TYP_CD
      ,a.AC_CSTM_ICREXCL_CD
      ,a.FIN_SERIES_ID
      ,a.ICR_FIN_COA_CD
      ,a.ICR_ACCOUNT_NBR
      ,a.ACCT_IN_FP_CD
      ,a.BDGT_REC_LVL_CD
      ,a.ACCT_SF_CD
      ,a.ACCT_PND_SF_CD
      ,a.FIN_EXT_ENC_SF_CD
      ,a.FIN_INT_ENC_SF_CD
      ,a.FIN_PRE_ENC_SF_CD
      ,a.FIN_OBJ_PRSCTRL_CD
      ,a.CG_CFDA_NBR
      ,a.ACCT_OFF_CMP_IND
      ,a.ACCT_CLOSED_IND
      ,CG_ACCT_RESP_ID
      ,b.UC_LOC_CD
      ,b.UC_ACCT_NBR
      ,b.UC_FUND_NBR

       FROM ca_account_t a
 LEFT OUTER JOIN uci_ca_account_xw_t b on (a.FIN_COA_CD = b.FIN_COA_CD and a.ACCOUNT_NBR = b.ACCOUNT_NBR)
 WHERE
  a.ACCT_CLOSED_IND <> 'Y'
  AND (a.ACCT_EXPIRATION_DT >= getdate() or a.ACCT_EXPIRATION_DT IS NULL)
  AND (a.ACCT_EFFECT_DT <= GETDATE())

...

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
List<AccountDetails> resultList5 = ds.getAllKFSAccounts();
if (resultList5 != null) {
	//for (Iterator i = resultList5.iterator(); i.hasNext();) {
	//	AccountDetails element = (AccountDetails)i.next();
	//	System.out.println("Result List key: " + element.toString());
	//}
	System.out.println("total size: " + resultList5.size());
	System.out.println("the 1st item ChartCode / AcctNumber: " + (AccountDetails)resultList5.get(0)).getKfsChartCode() + " / " + ((AccountDetails)resultList5.get(0)).getKfsAcctNumber()); 
} else {
	System.out.println("something bad happened...please check your query");
}

...

getAllKFSAccountsPK()

No input parameter, ALL active KFS account with chart code and account number only will be returned in result set.

DB Query

Code Block

SELECT a.FIN_COA_CD,a.ACCOUNT_NBR 
FROM ca_account_t a
LEFT OUTER JOIN uci_ca_account_xw_t b on (a.FIN_COA_CD = b.FIN_COA_CD and a.ACCOUNT_NBR = b.ACCOUNT_NBR)
WHERE
  a.ACCT_CLOSED_IND <> 'Y'
  AND (a.ACCT_EXPIRATION_DT >= getdate() or a.ACCT_EXPIRATION_DT IS NULL)
  AND (a.ACCT_EFFECT_DT <= GETDATE())

Result Schema: SAME as getValidKFSAccounts

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:getAllKFSAccountsPK/>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSAccountsPKResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1067496</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <kfsAcctNumber>1067497</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <kfsAcctNumber>1067498</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>

	 ...
	 ...
      </ns2:getAllKFSAccountsPKResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

...

translateFSAccountFunds(List of (fsLocationCode, fsAccountCode, fsFundCode))

...

Parameter	Description	Required?	Data Type (max length)
fsLocationCode	The FS location code	Yes	String (2)
fsAccountCode	The FS accounts code	Yes	String (6)
fsFundCode	The FS fund code	Yes	String (5)

DB Query

Code Block

Old:
SELECT a.fin_coa_cd, 
a.account_nbr,
FROM KFSINT.UCI_CA_ACCOUNT_XW_T a
WHERE a.ACTIVE_IND <> 'N'
AND a.UC_LOC_CD = 'pLocationCode'
AND a.UC_ACCT_NBR = 'pAccountCode'
AND a.UC_FUND_NBR = 'pFundCode'
 
New:
SELECT a.UC_LOC_CD, UC_ACCT_NBR, a.UC_FUND_NBR, a.FIN_COA_CD, a.ACCOUNT_NBR
FROM UCI_CA_ACCOUNT_XW_T a
WHERE a.ACTIVE_IND <> 'N'AND 
(
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '110001' AND a.UC_FUND_NBR = '18888') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '18213') OR
  (a.UC_LOC_CD = '9' AND a.UC_ACCT_NBR = '111200' AND a.UC_FUND_NBR = '182')
);

...

Parameter	Description	Data Type	Example
fsLocationCode	The FS location code	String (2)	9
fsAccountCode	The FS accounts code	String (6)	110001
fsFundCode	The FS fund code	String (5)	111200
kfsChartCode	KFS Chart Code	String (2)	'IR'
kfsAcctNumber	KFS Account Number	String (7)	'1234567'

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:translateFSAccountFunds>
         <fsAccountList>
            <item>9</item>
            <item>110001</item>
            <item>18888</item>
         </fsAccountList>
         <fsAccountList>
            <item>9</item>
            <item>111200</item>
            <item>18213</item>
         </fsAccountList>
         <fsAccountList>
            <item>9</item>
            <item>111200</item>
            <item>182</item>
         </fsAccountList>
         <fsAccountList>
            <item></item>
            <item></item>
            <item></item>
         </fsAccountList>
      </adc:translateFSAccountFunds>
   </soapenv:Body>
</soapenv:Envelope>

Response

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <fsAccountCode>110001</fsAccountCode>
            <fsFundCode>18888</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1000785</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
      </ns2:translateFSAccountFundsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
StringArray sa60 = new StringArray();
sa60.getItem().add("9");
sa60.getItem().add("110001");
sa60.getItem().add("18888");


StringArray sa61 = new StringArray();
sa61.getItem().add("9");
sa61.getItem().add("111200");
sa61.getItem().add("18213");


StringArray sa62 = new StringArray();
sa62.getItem().add("9");
sa62.getItem().add("111200");
sa62.getItem().add("182");


StringArray sa63 = new StringArray();
sa63.getItem().add("");
sa63.getItem().add("");
sa63.getItem().add("");
		
List<Fs2KFSAccountDetails> resultList6 = ds.translateFSAccountFunds(Arrays.asList(sa60,sa61,sa62,sa63));
if (resultList6 != null) {
	for (Iterator i = resultList6.iterator(); i.hasNext();) {
		Fs2KFSAccountDetails element = (Fs2KFSAccountDetails)i.next();
		System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsAccountCode() + "/" + element.getFsFundCode() + " : " + element.getKfsChartCode() + "/" + element.getKfsAcctNumber());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Version	Old Version 70	New Version 71
Changes made by	Adam Chang	Adam Chang
Saved on	Jul 11, 2012	Jul 11, 2012

Versions Compared

Key

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

DB Query

getAllKFSAccountsPK()

DB Query

Result Schema: SAME as getValidKFSAccounts

WS Example

Request

Response

Java Client Example

translateFSAccountFunds(List of (fsLocationCode, fsAccountCode, fsFundCode))

DB Query

WS Example

Request

Response

Java Client Example