Versions Compared

Version Old Version 67 New Version 68
Changes made by

Adam Chang

Adam Chang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidFSAAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1000767</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsAcctNumber>1000768</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>false</valid>
         </return>
         <return>
            <kfsAcctNumber>1234</kfsAcctNumber>
            <kfsChartCode>XX</kfsChartCode>
            <valid>false</valid>
         </return>
         <return>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>true</valid>
         </return>
      </ns2:isValidFSAAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
 

 

...

isValidKFSExpenseAccounts(List of (kfsChartCode, kfsAccountCode, effectiveDate))

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSExpenseAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1008543</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>true</valid>
         </return>
         <return>
            <kfsAcctNumber>1234</kfsAcctNumber>
            <kfsChartCode>XX</kfsChartCode>
            <valid>false</valid>
         </return>
         <return>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>false</valid>
         </return>
      </ns2:isValidKFSExpenseAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 

 

...

getValidKFSAccounts(List of (kfsChartCode, kfsAccountCode))

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctCreateDate>2012-05-13</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000066894</kfsAcctManagerId>
            <kfsAcctName>CA-BOA- CAMPUS - 1233-12007 110001-18888</kfsAcctName>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000960010</kfsAcctSupervisorId>
            <kfsAcctTypeCode>BS</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsCandGAcctNumber>9975430</kfsCandGAcctNumber>
            <kfsCandGChartCode>MC</kfsCandGChartCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsContAcctNumber>0</kfsContAcctNumber>
            <kfsContChartCode>0</kfsContChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsEndowChartCode>0</kfsEndowChartCode>
            <kfsFringeBenefitAcct>0</kfsFringeBenefitAcct>
            <kfsFringeBenefitChart>0</kfsFringeBenefitChart>
            <kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsICRTypeCode>0</kfsICRTypeCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsIncomeAcctNumber>0</kfsIncomeAcctNumber>
            <kfsIncomeChartCode>0</kfsIncomeChartCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>0922</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>STC&amp;G</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>110001</ucAccountCode>
            <ucFundCode>18888</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctCreateDate>2012-05-13</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000061717</kfsAcctFiscalOfficerId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000121170</kfsAcctManagerId>
            <kfsAcctName>MERAGE/DEAN'S OFFICE/EDUCAT 400100-09535</kfsAcctName>
            <kfsAcctNumber>1008543</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000082229</kfsAcctSupervisorId>
            <kfsAcctTypeCode>EX</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsCandGAcctNumber>9975430</kfsCandGAcctNumber>
            <kfsCandGChartCode>MC</kfsCandGChartCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsContAcctNumber>0</kfsContAcctNumber>
            <kfsContChartCode>0</kfsContChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsEndowChartCode>0</kfsEndowChartCode>
            <kfsFringeBenefitAcct>0</kfsFringeBenefitAcct>
            <kfsFringeBenefitChart>0</kfsFringeBenefitChart>
            <kfsHigherEduFundCode>INST</kfsHigherEduFundCode>
            <kfsICRTypeCode>0</kfsICRTypeCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsIncomeAcctNumber>0</kfsIncomeAcctNumber>
            <kfsIncomeChartCode>0</kfsIncomeChartCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>0049</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>OPPFNO</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>400100</ucAccountCode>
            <ucFundCode>09535</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
      </ns2:getValidKFSAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

 

getAllKFSAccounts()

No input parameter, ALL active charts/accounts will return 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_FUNCDWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
 
StringArray sa40 = new StringArray();
sa40.getItem().add("IR");
sa40.getItem().add("1000766");
StringArray sa41 = new StringArray();
sa41.getItem().add("IR");
sa41.getItem().add("1008543");
StringArray sa42 = new StringArray();
sa42.getItem().add("XX");
sa42.getItem().add("1234");
StringArray sa43 = new StringArray();
sa43.getItem().add("IR");
sa43.getItem().add("1234567");
	
List<AccountDetails> resultList4 = ds.getValidKFSAccounts(Arrays.asList(sa40, sa41,sa42,sa43));
if (resultList4 != null) {
	for (Iterator i = resultList4.iterator(); i.hasNext();) {
		AccountDetails element = (AccountDetails)i.next();
		System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + " : " + element.getKfsAcctName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

getAllKFSAccounts()

No input parameter, ALL active charts/accounts will return in result set.

DB Query

Code Block
SELECT a.FIN_COA_CD
      ,a.ACCT_RSTRC_STAT_CDACCOUNT_NBR
      ,a.ACCOUNT_NM
      ,a.ACCT_RSTRCFSC_STATOFC_DTUID
      ,a.ACCT_SPVSR_CITYUNVL_NMID
      ,a.ACCT_MGR_STATEUNVL_CDID
      ,a.ACCTORG_STREET_ADDRCD
      ,a.ACCT_ZIPTYP_CD
      ,a.RPTSACCT_TOPHYS_FIN_COACMP_CD
      ,a.RPTSSUB_TOFUND_ACCTGRP_NBRCD
      ,a.ACCT_CREATEFRNG_BNFT_DTCD
      ,a.ACCT_EFFECT_DTFIN_HGH_ED_FUNC_CD
      ,a.ACCT_RSTRC_EXPIRATIONSTAT_DTCD
      ,a.CONTACCT_FINRSTRC_COASTAT_CDDT
      ,a.CONTACCT_ACCOUNTCITY_NBRNM
      ,a.ENDOWACCT_FIN_COASTATE_CD
      ,a.ENDOWACCT_ACCOUNTSTREET_NBRADDR
      ,a.CONTRACCT_CTRL_FCOAZIP_CD
      ,a.CONTR_CTRLACCT_NBR
      ,a.INCOMERPTS_TO_FIN_COA_CD
      ,a.INCOMERPTS_TO_ACCOUNTACCT_NBR
      ,a.ACCT_ICRCREATE_TYP_CDDT
      ,a.ACACCT_CSTMEFFECT_ICREXCL_CDDT
      ,a.FINACCT_SERIESEXPIRATION_IDDT
      ,a.ICRCONT_FIN_COA_CD
      ,a.ICRCONT_ACCOUNT_NBR
      ,a.ACCTENDOW_INFIN_FPCOA_CD
      ,a.BDGTENDOW_RECACCOUNT_LVL_CDNBR
      ,a.ACCTCONTR_CTRL_SFFCOA_CD
      ,a.ACCTCONTR_PNDCTRLACCT_SF_CDNBR
      ,a.INCOME_FIN_EXT_ENC_SFCOA_CD
      ,a.FININCOME_INT_ENC_SF_CDACCOUNT_NBR
      ,a.FINACCT_PREICR_ENCTYP_SF_CD
      ,a.FINAC_OBJCSTM_PRSCTRLICREXCL_CD
      ,a.CGFIN_CFDASERIES_NBRID
      ,a.ACCTICR_OFFFIN_CMPCOA_INDCD
      ,a.ACCTICR_CLOSEDACCOUNT_INDNBR
      ,CGa.ACCT_ACCTIN_RESPFP_IDCD
      ,ba.UCBDGT_REC_LOCLVL_CD
      ,ba.UCACCT_ACCTSF_NBRCD
      ,ba.UCACCT_PND_FUNDSF_NBRCD
        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>,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
       <adc:getAllKFSAccounts/> FROM ca_account_t a
 LEFT OUTER JOIN uci_ca_account_xw_t b on  </soapenv:Body>
</soapenv:Envelope>
Response (See getValidKFSAccounts)

...

(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:getAllKFSAccounts/>
   </soapenv:Body>
</soapenv:Envelope>
Response (See getValidKFSAccounts)

Java Client Example

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");
}

 

...

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

...

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>
   <soapenv:Body>       <adc:translateFSAccountFunds></fsAccountList>
         <fsAccountList>
            <item>9</item>
            <item>110001<<item>111200</item>
            <item>18888<<item>18213</item>
         </fsAccountList>
         <fsAccountList>
            <item>9</item>
            <item>111200</item>
            <item>18213<<item>182</item>
         </fsAccountList>
         <fsAccountList>
            <item></item>
      <item>9<      <item></item>
            <item>111200<<item></item>
         </fsAccountList>
      </adc:translateFSAccountFunds>
   </soapenv:Body>
</soapenv:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
<item>182</item>          </fsAccountList><ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <fsAccountList><return>
            <item><<fsAccountCode>110001</item>fsAccountCode>
            <item><<fsFundCode>18888</item>fsFundCode>
            <item><<fsLocationCode>9</item>fsLocationCode>
         </fsAccountList>
      </adc:translateFSAccountFunds>
   </soapenv:Body>
</soapenv:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">   <kfsAcctNumber>1000766</kfsAcctNumber>
    <soap:Body>       <ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu"> <kfsChartCode>IR</kfsChartCode>
         </return>
         <return>
            <fsAccountCode>110001<<fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18888<<fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1000766<<kfsAcctNumber>1000785</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
      </ns2:translateFSAccountFundsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds  </return>
         <return>
            <fsAccountCode>111200</fsAccountCode>
            <fsFundCode>18213</fsFundCode>
            <fsLocationCode>9</fsLocationCode>
            <kfsAcctNumber>1000785</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </return>
      </ns2:translateFSAccountFundsResponse>
   </soap:Body>
</soap:Envelope>

...

= 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");
}

 

...