Page Comparison

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:isValidKFSExpenseAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<kfsAcctNumber>FG14577</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
				<valid>false</valid>
			</return>
			<return>
				<kfsAcctNumber>FG11955</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
				<valid>true</valid>
			</return>
			<return>
				<kfsAcctNumber>GF12646</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
				<valid>true</valid>
			</return>
			<return>
				<kfsAcctNumber>UC00370</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
				<valid>false</valid>
			</return>
		</ns2:isValidKFSExpenseAccountsResponse>
	</soap:Body>
</soap:Envelope>

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
		
List<AccountParameters> apList = new ArrayList<AccountParameters>();
		
AccountParameters ap = new AccountParameters();
ap.setKfsAcctNumber("FG11955");
ap.setKfsChartCode("IR");
apList.add(ap);
		
AccountParameters ap2 = new AccountParameters();
ap2.setKfsAcctNumber("GF12646");
ap2.setKfsChartCode("IR");
apList.add(ap2);
		
// account effective date 07/01/2012
AccountParameters ap3 = new AccountParameters();
ap3.setKfsAcctNumber("FG14577");
ap3.setKfsChartCode("IR");
ap3.setEffectiveDate("20120630");
apList.add(ap3);
		
AccountParameters ap4 = new AccountParameters();
ap4.setKfsAcctNumber("UC00370");
ap4.setKfsChartCode("IR");
apList.add(ap4);
		
List<AccountValidation> resultList = server.isValidKFSExpenseAccounts(apList);
if (resultList != null) {
	for (AccountValidation av : resultList) {
		System.out.println("kfsChartCode       : " + av.getKfsChartCode());
		System.out.println("kfsAccountNumber   : " + av.getKfsAcctNumber());
		System.out.println("isValid            : " <kfsAcctNumber>1053222</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <valid>true</valid>
  + av.isValid());
		System.out.println("--------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

SELECT a.FIN_COA_CD
      </return>,a.ACCOUNT_NBR
      ,a.ACCOUNT_NM
  <return>    ,a.ACCT_FSC_OFC_UID
        <kfsAcctNumber>1234</kfsAcctNumber>,a.ACCT_SPVSR_UNVL_ID
      ,a.ACCT_MGR_UNVL_ID
     <kfsChartCode>XX</kfsChartCode>
 ,a.ORG_CD
      ,a.ACCT_TYP_CD
    <valid>false</valid>  ,a.ACCT_PHYS_CMP_CD
       </return>,a.SUB_FUND_GRP_CD
      ,a.ACCT_FRNG_BNFT_CD
   <return>   ,a.FIN_HGH_ED_FUNC_CD
      ,a.ACCT_RSTRC_STAT_CD
  <kfsAcctNumber>1000766</kfsAcctNumber>    ,a.ACCT_RSTRC_STAT_DT
      ,a.ACCT_CITY_NM
 <kfsChartCode>IR</kfsChartCode>     ,a.ACCT_STATE_CD
       <valid>false</valid>
 ,a.ACCT_STREET_ADDR
      ,a.ACCT_ZIP_CD
       </return>,a.RPTS_TO_FIN_COA_CD
       </ns2:isValidKFSExpenseAccountsResponse>,a.RPTS_TO_ACCT_NBR
    </soap:Body> </soap:Envelope>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSAccounts>
         <kfsAccountList>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </kfsAccountList>
         <kfsAccountList>
            <kfsAcctNumber>1008543</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
         </kfsAccountList>
         <kfsAccountList>
            <kfsAcctNumber>1234</kfsAcctNumber>
            <kfsChartCode>XX</kfsChartCode>
         </kfsAccountList>
         <kfsAccountList>
            <kfsAcctNumber>1234576</kfsAcctNumber>
            <kfsChartCode>XX</kfsChartCode>
         </kfsAccountList>
      </adc:getValidKFSAccounts>
   </soapenv:Body>
</soapenv:Envelope>

<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-09-05</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId></kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000111111</kfsAcctManagerId>
            <kfsAcctName>INSTITUTIONAL/LATE CHARGE I 102168-03440</kfsAcctName>
            <kfsAcctNumber>1008543<<kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsChartCode>IR<<kfsAcctOffCampusCode>N</kfsChartCode>kfsAcctOffCampusCode>
         </kfsAccountList>   <kfsAcctPSFCode>N</kfsAcctPSFCode>
      <kfsAccountList>      <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
      <kfsAcctNumber>1234</kfsAcctNumber>      <kfsAcctSFCode>N</kfsAcctSFCode>
      <kfsChartCode>XX</kfsChartCode>      <kfsAcctState>CA</kfsAcctState>
   </kfsAccountList>          <kfsAccountList><kfsAcctSupervisorId>000000111111</kfsAcctSupervisorId>
            <kfsAcctNumber>1234576<<kfsAcctTypeCode>NA</kfsAcctNumber>kfsAcctTypeCode>
            <kfsChartCode>XX<<kfsAcctZip>92697</kfsChartCode>kfsAcctZip>
          </kfsAccountList>  <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
       </adc:getValidKFSAccounts>    </soapenv:Body> </soapenv:Envelope>

DWHServerService dss = new DWHServerService();
DWHServer ds  <kfsAcctNumber>1008543</kfsAcctNumber>= dss.getDWHServerPort();

ArrayList<AccountParameters> pl3 = new ArrayList<AccountParameters>();
AccountParameters ap31 = new AccountParameters();
 <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000089121</kfsAcctSupervisorId>
            <kfsAcctTypeCode>IN</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>6046</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>SRC001</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>221602</ucAccountCode>
            <ucFundCode>21602</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
      </ns2:getValidKFSAccountsResponse>
   </soap:Body>
</soap:Envelope>

WITH ChildOrgList As (
	SELECT
		ChildOrg.[CHART_CD], ChildOrg.[ORG_CD], ChildOrg.[ORG_PARENT_ORG_CD]
	FROM [dwhs_ods].[dbo].[kfs_d_org] as ChildOrg
	WHERE ChildOrg.CHART_CD = 'IR' and ChildOrg.ORG_CD = '9014'
	UNION ALL
	SELECT
		ChildOrg.[CHART_CD], ChildOrg.[ORG_CD], ChildOrg.[ORG_PARENT_ORG_CD]
	FROM [dwhs_ods].[dbo].[kfs_d_org] as ChildOrg
		INNER JOIN ChildOrgList as Child ON ChildOrg.[ORG_PARENT_ORG_CD] = Child.ORG_CD
			AND ChildOrg.[ORG_PARENT_CHART_CD] = Child.CHART_CD
)
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, a.CG_ACCT_RESP_ID,
	e.UC_LOC_CD, e.UC_ACCT_NBR, e.UC_FUND_NBR, e.UCI_CAPITAL_CAT_CD, emp.UCINETID AS ACCT_FSC_OFC_UCINETID
FROM CA_ACCOUNT_T a
	LEFT OUTER JOIN CA_ACCOUNT_EXT_T e on (a.FIN_COA_CD = e.FIN_COA_CD and a.ACCOUNT_NBR = e.ACCOUNT_NBR)
    LEFT OUTER JOIN dwhs_ppscurr..employee_basic emp on (a.ACCT_FSC_OFC_UID = emp.CAMPUS_ID)
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()
	AND EXISTS 
		(select 1 from ChildOrgList o WHERE o.CHART_CD = a.FIN_COA_CD and o.org_cd = a.ORG_CD)
 

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

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
xmlns:adc="	<soap:Body>
		<ns2:getKFSChildAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<kfsAcctAddress>Campus  <soapenv:Header/>
   <soapenv:Body>Dr</kfsAcctAddress>
				<kfsAcctCampusCode>IR</kfsAcctCampusCode>
				<kfsAcctCity>Irvine</kfsAcctCity>
				<kfsAcctClosedCode>N</kfsAcctClosedCode>
				<kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
       <adc:getAllKFSAccounts/>    </soapenv:Body> </soapenv:Envelope>

ObjectFactory objectFactory = new ObjectFactory();
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
OrganizationParameters orgParameters = objectFactory.createOrganizationParameters();
orgParameters.setKfsChartCode("IR");
orgParameters.setKfsOrgCode("9014"); //OIT

List<AccountDetails> accountDetailList = server.getKFSChildAccounts(orgParameters);
if (accountDetailList != null) {
	for (AccountDetails accountDetails : accountDetailList) {
		System.out.println("kfsChartCode:    " + accountDetails.getKfsChartCode());
		System.out.println("kfsAccount:      " + accountDetails.getKfsAcctNumber());
		System.out.println("kfsAccountName:  " + accountDetails.getKfsAcctName());
		System.out.println("kfsOrgCode:      " + accountDetails.getKfsOrgCode());
		System.out.println("------------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

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
      ,b.UCI_CAPITAL_CAT_CD
FROM ca_account_t a
LEFT OUTER JOIN ca_account_ext_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())

<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>

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
 
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");
}

SELECT a.FIN_COA_CD,a.ACCOUNT_NBR 
FROM ca_account_t a
LEFT OUTER JOIN ca_account_ext_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())

<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>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSAccountsPKResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
  <fsLocationCode>9</fsLocationCode>          <<kfsAcctNumber>1067496</fsAccountList>kfsAcctNumber>
         <fsAccountList>   <kfsChartCode>IR</kfsChartCode>
         <fsAccountCode>111200<</fsAccountCode>return>
         <return>
  <fsFundCode>182</fsFundCode>          <kfsAcctNumber>1067497</kfsAcctNumber>
  <fsLocationCode>9</fsLocationCode>          <<kfsChartCode>IR</fsAccountList>
kfsChartCode>
     </adc:translateFSAccountFunds>    </soapenv:Body>
</soapenv:Envelope>

long start7 = System.currentTimeMillis();
System.out.println("\nWSClient--getAllKFSAccountsPK(), starting time: " + start7);
// get all the accounts primary key
List<AccountDetails> resultList7 = ds.getAllKFSAccountsPK();
if (resultList7 != null) {
	System.out.println("PK-total size: " + resultList7.size());
	System.out.println("PK-the 1st item ChartCode / AcctNumber: " + ((AccountDetails) resultList7.get(0)).getKfsChartCode() + " / " + ((AccountDetails) resultList7.get(0)).getKfsAcctNumber());
	ArrayList<AccountParameters> pl70 = new ArrayList<AccountParameters>();
	long start71 = System.currentTimeMillis();
	// get details for each KFSAccount in a chunk of 1000
	for (int i = 0; i < resultList7.size(); i++) {
		// single record detail
		if (i != 0 && i % 1000 == 0) {
			start71 = System.currentTimeMillis();
			List<AccountDetails> resultList70 = ds.getValidKFSAccounts(pl70);
			System.out.println(i);
			System.out.println("PK-elapsed after " + i + " item time (sec): " + (System.currentTimeMillis() - start71) / 1000F);
			// do whatever with the 1000 records in resultList70
			System.out.println("result size: " + resultList70.size());
			System.out.println("1st item details, acctname: " + resultList70.get(0).getKfsAcctName() + ", addr: " + resultList70.get(0).getKfsAcctAddress());
			// once hit multiple of 1000, reset argument list
			pl70.clear();
		} else {
			// building arguments list for getValidKFSAccounts()
			AccountParameters ap70 = new AccountParameters();
			ap70.setKfsChartCode(resultList7.get(i).getKfsChartCode());
			ap70.setKfsAcctNumber(resultList7.get(i).getKfsAcctNumber());
			pl70.add(ap70);
		}
	}
	System.out.println("PK-elapsed time (sec): " + (System.currentTimeMillis() - start7) / 1000F);
} else {
	System.out.println("something bad happened...please check your query");
}

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
	,CONVERT(VARCHAR(2), a.CG_ACCT_RESP_ID) AS CG_ACCT_RESP_ID
	,b.UC_LOC_CD
	,b.UC_ACCT_NBR
	,b.UC_FUND_NBR
	,b.UCI_CAPITAL_CAT_CD
	,e.UCINETID AS ACCT_FSC_OFC_UCINETID
FROM ca_account_t a
LEFT JOIN ca_account_ext_t b ON (
		a.FIN_COA_CD = b.FIN_COA_CD
		AND a.ACCOUNT_NBR = b.ACCOUNT_NBR
		)
INNER JOIN dwhs_ppscurr..employee_basic e ON (a.ACCT_FSC_OFC_UID = e.CAMPUS_ID)
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())
	AND e.ucinetid = 'test' );

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:getKFSAccountsByManager xmlns:ns2="http://www.adcom.uci.edu">
			<managerUciNetId>test</managerUciNetId>
		</ns2:getKFSAccountsByManager>
	</S:Body>
</S:Envelope>

		DWHServerService service = new DWHServerService();
		DWHServer server = service.getDWHServerPort();
		
		List<AccountDetails> resultList = server.getKFSAccountsByManager("test");
		
		if (resultList != null) {
			for (AccountDetails ad : resultList) {
				System.out.println("kfsChartCode           : " + ad.getKfsChartCode());
				System.out.println("kfsAccountNumber       : " + ad.getKfsAcctNumber());
				System.out.println("fiscalOfficerUciNetId  : " + ad.getKfsAcctFiscalOfficerUciNetId());
				System.out.println("--------------------------");
			}
		}
		else {
			System.out.println("something bad happened...please check your query");
		}

SELECT UC_LOC_CD, UC_ACCT_NBR, UC_FUND_NBR, FIN_COA_CD, ACCOUNT_NBR
FROM UCI_CA_ACCOUNT_XW_T
WHERE ACTIVE_IND <> 'N' AND
	  ((UC_LOC_CD='9' AND UC_ACCT_NBR='400753' AND UC_FUND_NBR='19933') OR
	  (UC_LOC_CD='9' AND UC_ACCT_NBR='400755' AND UC_FUND_NBR='19900'))
UNION
SELECT DISTINCT ae.UC_LOC_CD, '-----', ae.UC_FUND_NBR, ae.FIN_COA_CD, ae.ACCOUNT_NBR
FROM CA_ACCOUNT_T a LEFT OUTER JOIN CA_ACCOUNT_EXT_T ae on
	 (a.ACCOUNT_NBR = ae.ACCOUNT_NBR AND a.FIN_COA_CD = ae.FIN_COA_CD)
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() AND
	  a.ACCT_TYP_CD = 'CA' AND
	  ((ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70003') OR
	  (ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70000'))

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:translateFSAccountFunds xmlns:ns2="http://www.adcom.uci.edu">
			<fsAccountList>
				<fsAccountCode>400753</fsAccountCode>
				<fsFundCode>19933</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>400755</fsAccountCode>
				<fsFundCode>19900</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>270303</fsAccountCode>
				<fsFundCode>70003</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>270010</fsAccountCode>
				<fsFundCode>70000</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
		</ns2:translateFSAccountFunds>
	</S:Body>
</S:Envelope>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:translateFSAccountFundsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<fsAccountCode>270010</fsAccountCode>
				<fsFundCode>70000</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>UC70000</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>270303</fsAccountCode>
				<fsFundCode>70003</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>UC70003</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>400753</fsAccountCode>
				<fsFundCode>19933</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>GF10414</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
			<return>
				<fsAccountCode>400755</fsAccountCode>
				<fsFundCode>19900</fsFundCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsAcctNumber>GF10420</kfsAcctNumber>
				<kfsChartCode>IR</kfsChartCode>
			</return>
		</ns2:translateFSAccountFundsResponse>
	</soap:Body>
</soap:Envelope>

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>();
		
AccountTranslateParameters atp1 = new AccountTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("400753");
atp1.setFsFundCode("19933");
paramList.add(atp1);
		
AccountTranslateParameters atp2 = new AccountTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("400755");
atp2.setFsFundCode("19900");
paramList.add(atp2);
		
AccountTranslateParameters atp3 = new AccountTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("270303");
atp3.setFsFundCode("70003");
paramList.add(atp3);
		
AccountTranslateParameters atp4 = new AccountTranslateParameters();
atp4.setFsLocationCode("9");
atp4.setFsAccountCode("270010");
atp4.setFsFundCode("70000");
paramList.add(atp4);
		
List<Fs2KFSAccountDetails> resultList = server.translateFSAccountFunds(paramList);
if (resultList != null) {
	for (Fs2KFSAccountDetails fad : resultList) {
		System.out.println("kfsChartCode     : " + fad.getKfsChartCode());
		System.out.println("kfsAccountNumber : " + fad.getKfsAcctNumber());
		System.out.println("fsLocationCode   : " + fad.getFsLocationCode());
		System.out.println("fsAccountCode    : " + fad.getFsAccountCode());
		System.out.println("fsFundCode       : " + fad.getFsFundCode());
		System.out.println("------------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

SELECT
	UC_LOC_CD, UC_SUB_CD, UC_OBJECT_CD, UC_ACCT_NBR, CONVERT(varchar(4), UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD
FROM UCI_CA_OBJECT_CODE_XW_T
WHERE
	ACTIVE_IND <> 'N' AND
	(
		(UC_LOC_CD='9' AND UC_ACCT_NBR='119850' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='115181' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='101193' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='229344' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
	);

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:translateFSAccountToKFSObject xmlns:ns2="http://www.adcom.uci.edu">
			<fsAccountList>
				<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2014</kfsFiscalYear>
			</fsAccountList>
		</ns2:translateFSAccountToKFSObject>
	</S:Body>
</S:Envelope>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:translateFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>R010</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>L231</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N004</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N013</kfsObjCode>
			</return>
		</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountToObjectTranslateParameters> paramList = new ArrayList<AccountToObjectTranslateParameters>();
		
AccountToObjectTranslateParameters atp1 = new AccountToObjectTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("119850");
atp1.setKfsChartCode("IR");
atp1.setKfsFiscalYear("2013");
paramList.add(atp1);
		
AccountToObjectTranslateParameters atp2 = new AccountToObjectTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("115181");
atp2.setKfsChartCode("IR");
atp2.setKfsFiscalYear("2013");
paramList.add(atp2);
		
AccountToObjectTranslateParameters atp3 = new AccountToObjectTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("101193");
atp3.setKfsChartCode("IR");
atp3.setKfsFiscalYear("2013");
paramList.add(atp3);
		
AccountToObjectTranslateParameters atp4 = new AccountToObjectTranslateParameters();
atp4.setFsLocationCode("9");
atp4.setFsAccountCode("229344");
atp4.setKfsChartCode("IR");
atp4.setKfsFiscalYear("2013");
paramList.add(atp4);
		
AccountToObjectTranslateParameters atp5 = new AccountToObjectTranslateParameters();
atp5.setFsLocationCode("9");
atp5.setFsAccountCode("229344");
atp5.setKfsChartCode("IR");
atp5.setKfsFiscalYear("2014");
paramList.add(atp5);

List<FsAccount2KFSObjectDetails> resultList = server.translateFSAccountToKFSObject(paramList);
if (resultList != null) {
	for (Iterator i = resultList9.iterator(); i.hasNext();) {
		FsAccount2KFSObjectDetails element = (FsAccount2KFSObjectDetails) i.next(FsAccount2KFSObjectDetails fod : resultList) {
		System.out.println("fsLocationCode   : " + fod.getFsLocationCode());
		System.out.println("fsSubCode   : " + fod.getFsSubCode());
		System.out.println("fsObjCode   : " + fod.getFsObjCode());
		System.out.println("\t"fsAccountCode  + element.getFsLocationCode() +: "/" + elementfod.getFsAccountCode()) + "/;
		System.out.println("kfsFiscalYear    : " + elementfod.getKfsFiscalYear()) + ";
		System.out.println("kfsChartCode     : " + elementfod.getKfsChartCode()) + "/;
		System.out.println("kfsObjectCode    : " + elementfod.getKfsObjCode());
		System.out.println("--------------------------");
	}
}
else {
	System.out.println("something bad happened...please check your query");
}