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            : " + av.isValid());
		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.ACCOUNT_NMACCT_IN_FP_CD
      ,a.ACCTBDGT_FSCREC_OFCLVL_UIDCD
      ,a.ACCT_SPVSRSF_UNVL_IDCD
      ,a.ACCT_MGRPND_UNVLSF_IDCD
      ,a.ORG_CD
      ,a.ACCT_TYPFIN_EXT_ENC_SF_CD
      ,a.ACCTFIN_INT_PHYSENC_CMPSF_CD
      ,a.SUBFIN_PRE_FUNDENC_GRPSF_CD
      ,a.ACCTFIN_FRNGOBJ_BNFTPRSCTRL_CD
      ,a.FINCG_HGH_ED_FUNC_CDCFDA_NBR
      ,a.ACCT_RSTRCOFF_STATCMP_CDIND
      ,a.ACCT_RSTRCCLOSED_STAT_DTIND
      ,a.CG_ACCT_CITYRESP_NMID
      ,ab.ACCTUC_STATELOC_CD
      ,ab.UC_ACCT_STREET_ADDRNBR
      ,ab.ACCTUC_ZIPFUND_CDNBR
      ,ab.RPTSUCI_TOCAPITAL_FIN_COACAT_CD
      ,a.RPTS_TO_ACCT_NBR
      ,a.ACCT_CREATE_DT
      ,a.ACCT_EFFECT_DT
      ,a.ACCT_EXPIRATION_DT
      ,a.CONT_e.UCINETID AS ACCT_FSC_OFC_UCINETID 
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 =    ,a.CONT_b.ACCOUNT_NBR)
LEFT OUTER JOIN dwhs_ppscurr..employee_basic e on ,(a.ENDOWACCT_FINFSC_COAOFC_CDUID =   e.CAMPUS_ID)
WHERE
  ,a.ENDOWACCT_ACCOUNTCLOSED_NBRIND <> 'Y'
  AND  ,(a.CONTRACCT_CTRL_FCOA_CD
 EXPIRATION_DT >= getdate() or a.ACCT_EXPIRATION_DT IS NULL)
   AND ,a.CONTRACCT_CTRLACCTEFFECT_NBRDT <= GETDATE()
    ,AND ((a.INCOME_FIN_COA_CD
      ,a.INCOME_='<kfsChartCode1>' AND ACCOUNT_NBR
      ,a.ACCT_ICR_TYP_CD='<kfsAcctNumber1>') OR 
        ,(a.ACFIN_CSTMCOA_ICREXCL_CD='<kfsChartCode2>' AND ACCOUNT_NBR='<kfsAcctNumber2>') OR
   ,a.FIN_SERIES_ID    .  . ,a.ICR_FIN_COA_CD
  etc
    ,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()
  AND ((a.FIN_COA_CD='<kfsChartCode1>' AND ACCOUNT_NBR='<kfsAcctNumber1>') OR 
       (a.FIN_COA_CD='<kfsChartCode2>' AND ACCOUNT_NBR='<kfsAcctNumber2>') OR
       . . . etc
      )
 

<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>
            <kfsAccountList><kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsAcctNumber>1000766<<kfsAcctOffCampusCode>N</kfsAcctNumber>kfsAcctOffCampusCode>
            <kfsChartCode>IR</kfsChartCode><kfsAcctPSFCode>N</kfsAcctPSFCode>
            </kfsAccountList><kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAccountList><kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctNumber>1008543<<kfsAcctState>CA</kfsAcctNumber>kfsAcctState>
            <kfsChartCode>IR</kfsChartCode><kfsAcctSupervisorId>000000111111</kfsAcctSupervisorId>
            </kfsAccountList><kfsAcctTypeCode>NA</kfsAcctTypeCode>
            <kfsAccountList><kfsAcctZip>92697</kfsAcctZip>
            <kfsAcctNumber>1234<<kfsBudgetLevelCode>C</kfsAcctNumber>kfsBudgetLevelCode>
            <kfsChartCode>XX<<kfsChartCode>IR</kfsChartCode>
          </kfsAccountList>  <kfsEESFCode>N</kfsEESFCode>
            <kfsAccountList><kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsAcctNumber>1234576<<kfsIESFCode>N</kfsAcctNumber>kfsIESFCode>
            <kfsChartCode>XX<<kfsObjPCCode>N</kfsChartCode>kfsObjPCCode>
         </kfsAccountList>   <kfsOrgCode>8820</kfsOrgCode>
   </adc:getValidKFSAccounts>    </soapenv:Body>
</soapenv:Envelope>

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

ArrayList<AccountParameters> <kfsAcctAddress>Campuspl3 Dr</kfsAcctAddress>= new ArrayList<AccountParameters>();
AccountParameters ap31 = new AccountParameters();
ap31.setKfsChartCode("IR");
ap31.setKfsAcctNumber("1000766");
AccountParameters ap32 = <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctCreateDate>2012-09-05</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000247608</kfsAcctManagerId>
            <kfsAcctName>D/NSF DMS-1001006 YI J53.0  221602-21602</kfsAcctName>
            <kfsAcctNumber>1008543</kfsAcctNumber>
            <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/">
	<soap:Body>
		<ns2:getKFSChildAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<kfsAcctAddress>Campus Dr</kfsAcctAddress>
				<kfsAcctCampusCode>IR</kfsAcctCampusCode>
				<kfsAcctCity>Irvine</kfsAcctCity>
				<kfsAcctClosedCode>N</kfsAcctClosedCode>
				<kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
                <kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
				<kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
				<kfsAcctManagerId>000000247608</kfsAcctManagerId>
				<kfsAcctName>ACADEMIC COMPUTING 407618-19900</kfsAcctName>
				<kfsAcctNumber>GF10074</kfsAcctNumber>
				<kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
				<kfsAcctPSFCode>N</kfsAcctPSFCode>
				<kfsAcctRestrictedCode>G</kfsAcctRestrictedCode>
				<kfsAcctSFCode>N</kfsAcctSFCode>
				<kfsAcctState>CA</kfsAcctState>
				<kfsAcctSupervisorId>000000089121</kfsAcctSupervisorId>
				<kfsAcctTypeCode>CF</kfsAcctTypeCode>
				<kfsAcctZip>92697</kfsAcctZip>
				<kfsBudgetLevelCode>C</kfsBudgetLevelCode>
				<kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
				<kfsCandGChartCode>IR</kfsCandGChartCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsEESFCode>N</kfsEESFCode>
				<kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
				<kfsIESFCode>N</kfsIESFCode>
				<kfsObjPCCode>N</kfsObjPCCode>
				<kfsOrgCode>8075</kfsOrgCode>
				<kfsPESFCode>N</kfsPESFCode>
				<kfsReportToAcctNumber>UC99999</kfsReportToAcctNumber>
				<kfsReportToChartCode>IR</kfsReportToChartCode>
				<kfsSubFundCode>401000</kfsSubFundCode>
				<kfsTPSFCode>Y</kfsTPSFCode>
				<ucAccountCode>407618</ucAccountCode>
				<ucFundCode>19900</ucFundCode>
				<ucLocationCode>9</ucLocationCode>
			</return>
			<return>
				<kfsAcctAddress>Campus Dr</kfsAcctAddress>
				<kfsAcctCampusCode>IR</kfsAcctCampusCode>
				<kfsAcctCity>Irvine</kfsAcctCity>
				<kfsAcctClosedCode>N</kfsAcctClosedCode>
				<kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
                <kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
				<kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
				<kfsAcctManagerId>000000247608</kfsAcctManagerId>
				<kfsAcctName>OAC-ECS INSTRUCTIONAL TECHN 407620-19900</kfsAcctName>
				<kfsAcctNumber>GF10115</kfsAcctNumber>
				<kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
				<kfsAcctPSFCode>N</kfsAcctPSFCode>
				<kfsAcctRestrictedCode>G</kfsAcctRestrictedCode>
				<kfsAcctSFCode>N</kfsAcctSFCode>
				<kfsAcctState>CA</kfsAcctState>
				<kfsAcctSupervisorId>000000089121</kfsAcctSupervisorId>
				<kfsAcctTypeCode>CF</kfsAcctTypeCode>
				<kfsAcctZip>92697</kfsAcctZip>
				<kfsBudgetLevelCode>C</kfsBudgetLevelCode>
				<kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
				<kfsCandGChartCode>IR</kfsCandGChartCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsEESFCode>N</kfsEESFCode>
				<kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
				<kfsIESFCode>N</kfsIESFCode>
				<kfsObjPCCode>N</kfsObjPCCode>
				<kfsOrgCode>8242</kfsOrgCode>
				<kfsPESFCode>N</kfsPESFCode>
				<kfsReportToAcctNumber>UC99999</kfsReportToAcctNumber>
				<kfsReportToChartCode>IR</kfsReportToChartCode>
				<kfsSubFundCode>401000</kfsSubFundCode>
				<kfsTPSFCode>Y</kfsTPSFCode>
				<ucAccountCode>407620</ucAccountCode>
				<ucFundCode>19900</ucFundCode>
				<ucLocationCode>9</ucLocationCode>
			</return>
			...
		</ns2:getKFSChildAccountsResponse>
	</soap:Body>
</soap: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>
            <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>

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

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getKFSAccountsByManagerResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
            <kfsAcctCity>Irvine</kfsAcctCity>
            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctFiscalOfficerId>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>test</kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000011111</kfsAcctManagerId>
            <kfsAcctName>40112 Test Acct Name</kfsAcctName>
            <return><kfsAcctNumber>GF12345</kfsAcctNumber>
            <kfsAcctNumber>1067496<<kfsAcctOffCampusCode>N</kfsAcctNumber>kfsAcctOffCampusCode>
            <kfsChartCode>IR</kfsChartCode><kfsAcctPSFCode>N</kfsAcctPSFCode>
            </return><kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <return><kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctNumber>1067497<<kfsAcctState>CA</kfsAcctNumber>kfsAcctState>
            <kfsChartCode>IR</kfsChartCode><kfsAcctSupervisorId>000000011111</kfsAcctSupervisorId>
            </return><kfsAcctTypeCode>CF</kfsAcctTypeCode>
            <return><kfsAcctZip>92611</kfsAcctZip>
            <kfsAcctNumber>1067498<<kfsBudgetLevelCode>C</kfsAcctNumber>kfsBudgetLevelCode>
            <kfsChartCode>IR</kfsChartCode><kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
            <<kfsCandGChartCode>IR</return>kfsCandGChartCode>
  	 ... 	 ...       </ns2:getAllKFSAccountsPKResponse><kfsChartCode>IR</kfsChartCode>
           </soap:Body> </soap: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());
			pl70.add(ap70);
		}
	}
	System.out.println("PK-elapsedfiscalOfficerUciNetId time (sec): " + ad.getKfsAcctFiscalOfficerUciNetId());
				System.out.currentTimeMillis() - start7) / 1000F);
} else {
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, CONVERT(varchar(4),='119850' and UNIV_FISCAL_YR) AS = '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, FIN_OBJECT_CD
FROM UCI_CA_OBJECT_CODE_XW_T
WHERE
	ACTIVE_IND <> 'N' AND
	(
		 = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='101193' and UNIV_FISCAL_YR ='270303')
		OR
		 '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='118747229344') 		OR
		(UC_LOC_CD='9and UNIV_FISCAL_YR = '2013' AND UCFIN_ACCTCOA_NBRCD = '112754IR')
	);

DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
				<kfsObjCode>L537</kfsObjCode>
			</return>
		</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>