Versions Compared

Key

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

...

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
      ,b.UCI_CAPITAL_CAT_CD
      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 = b.ACCOUNT_NBR)
LEFT OUTER 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 ((a.FIN_COA_CD='<kfsChartCode1>' AND ACCOUNT_NBR='<kfsAcctNumber1>') OR 
       (a.FIN_COA_CD='<kfsChartCode2>' AND ACCOUNT_NBR='<kfsAcctNumber2>') OR
       . . . etc
      )
 

...

DB ParameterJava ParameterDescriptionData TypeExample
FIN_COA_CDkfsChartCodeKFS Chart CodeString (2)'IR'
ACCOUNT_NBRkfsAcctNumberKFS Account NumberString (7)

'1234567'

ACCOUNT_NMkfsAcctNameKFS Account NameString (40) 
ACCT_FSC_OFC_UIDkfsAcctFiscalOfficerIdKFS Account Fiscal Officer IDString  
ACCT_SPVSR_UNVL_IDkfsAcctSupervisorIdKFS Account Supervisor IDString  
ACCT_MGR_UNVL_IDkfsAcctManagerIdKFS Account Manager IDString  
ORG_CDkfsOrgCodeKFS Organization CodeString  
ACCT_TYP_CDkfsAcctTypeCodeKFS Account Type CodeString  
ACCT_PHYS_CMP_CDkfsAcctCampusCodeKFS Account Campus CodeString  
SUB_FUND_GRP_CDkfsSubFundCodeKFS Sub Fund Group CodeString  
ACCT_FRNG_BNFT_CDkfsAcctFringeBenefitCodeKFS Account Fringe Benefit CodeString  
FIN_HGH_ED_FUNC_CDkfsHigherEduFundCodeKFS Higher Education Function CodeString  
ACCT_RSTRC_STAT_CDkfsAcctRestrictedCodeKFS Account Restricted Status CodeString  
ACCT_RSTRC_STAT_DTkfsAcctRestrictedDateKFS Account Restricted Status DateString  
ACCT_CITY_NMkfsAcctCityKFS Account City NameString  
ACCT_STATE_CDkfsAcctStateKFS Account State CodeString  
ACCT_STREET_ADDRkfsAcctAddressKFS Account Street AddressString  
ACCT_ZIP_CDkfsAcctZipKFS Account Zip CodeString  
RPTS_TO_FIN_COA_CDkfsReportToChartCodeKFS Reports To Chart CodeString  
RPTS_TO_ACCT_NBRkfsReportToAcctNumberKFS Reports To Account NumberString  
ACCT_CREATE_DTkfsAcctCreateDateKFS Account Create DateString  
ACCT_EFFECT_DTkfsAcctEffectiveDateKFS Account Effective DateString  
ACCT_EXPIRATION_DTkfsAcctExpDateKFS Account Expiration DateString  
CONT_FIN_COA_CDkfsContChartCodeKFS Continuation Chart CodeString  
CONT_ACCOUNT_NBRkfsContAcctNumberKFS Continuation Account NumberString  
ENDOW_FIN_COA_CDkfsEndowChartCodeKFS Endowment Chart CodeString  
ENDOW_ACCOUNT_NBRkfsEndowAcctNumberKFS Endowment Account NumberString  
CONTR_CTRL_FCOA_CDkfsCandGChartCodeKFS C&G Control Chart CodeString  
CONTR_CTRLACCT_NBRkfsCandGAcctNumberKFS C&G Control Account NumberString  
INCOME_FIN_COA_CDkfsIncomeChartCodeKFS Income Stream Chart CodeString  
INCOME_ACCOUNT_NBRkfsIncomeAcctNumberKFS Income Stream Account NumberString  
ACCT_ICR_TYP_CDkfsICRTypeCodeKFS ICR Type CodeString  
AC_CSTM_ICREXCL_CDkfsCustomICRCodeKFS Custom ICR CodeString  
FIN_SERIES_IDkfsICRRateCodeKFS ICR Rate CodeString  
ICR_FIN_COA_CDkfsICRChartCodeKFS ICR Credit Chart CodeString  
ICR_ACCOUNT_NBRkfsICRAcctNumberKFS ICR Credit Account NumberString  
ACCT_IN_FP_CDkfsTPSFCodeKFS Transaction Processing Sufficient Funds Check CodeString  
BDGT_REC_LVL_CDkfsBudgetLevelCodeKFS Budget Recording Level CodeString  
ACCT_SF_CDkfsAcctSFCodeKFS Account Sufficient Fund Check CodeString  
ACCT_PND_SF_CDkfsAcctPSFCodeKFS Account Pending Sufficient Fund Check CodeString  
FIN_EXT_ENC_SF_CDkfsEESFCodeKFS External Encumbrance Sufficient Fund Check CodeString  
FIN_INT_ENC_SF_CDkfsIESFCodeKFS Internal Encumbrance Sufficient Fund Check CodeString  
FIN_PRE_ENC_SF_CDkfsPESFCodeKFS Pre-Encumbrance Sufficient Fund Check CodeString  
FIN_OBJ_PRSCTRL_CDkfsObjPCCodeKFS Object Presence Control CodeString  
CG_CFDA_NBRkfsCGCFDANumberKFS CG CFDA numberString  
ACCT_OFF_CMP_INDkfsAcctOffCampusCodeKFS Account Off Campus Indicator CodeString  
ACCT_CLOSED_INDkfsAcctClosedCodeKFS Account Closed Indicator CodeString  
CG_ACCT_RESP_IDkfsAcctRespIdKFS Account Responsibility IDString  
UC_LOC_CDucLocationCodeFS Location Code (legacy)String(1) 
UC_ACCT_NBRucAccountCodeFS Account Code (legacy)String(6) 
UC_FUND_NBRucFundCodeFS Fund Code (legacy)String(5) 
ACCT_FSC_OFC_UCINETIDkfsAcctFiscalOfficerUciNetIdKFS Account Fiscal Officer UCInetIDString 

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

...

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-09-05</kfsAcctCreateDate>
            <kfsAcctEffectiveDate>2011-07-01</kfsAcctEffectiveDate>
            <kfsAcctFiscalOfficerId>000000060345</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>vcesario</kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000247608</kfsAcctManagerId>
            <kfsAcctName>INSTITUTIONAL/LATE CHARGE I 102168-03440</kfsAcctName>
            <kfsAcctNumber>1000766</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000089121</kfsAcctSupervisorId>
            <kfsAcctTypeCode>NA</kfsAcctTypeCode>
            <kfsAcctZip>92697</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>NA</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>8820</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>SRC001</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>102168</ucAccountCode>
            <ucFundCode>03440</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
         <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>000000060345</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>vcesario</kfsAcctFiscalOfficerUciNetId>
            <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>

...

Code Block
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)
 

...

DB ParameterJava ParameterDescriptionData TypeExample
ORG_COA_CDkfsOrgChartKFS Chart Code (the chart that the org belongs to)String(2)'IR'
ORG_CDkfsOrgCodeKFS Organization Code (the org the account belongs to)String(4)'1234'
FIN_COA_CDkfsChartCodeKFS Chart Code (the chart that the account belongs to)String (2)'IR'
ACCOUNT_NBRkfsAcctNumberKFS Account NumberString (7)

'1234567'

ACCOUNT_NMkfsAcctNameKFS Account NameString (40) 
ACCT_FSC_OFC_UIDkfsAcctFiscalOfficerIdKFS Account Fiscal Officer IDString  
ACCT_SPVSR_UNVL_IDkfsAcctSupervisorIdKFS Account Supervisor IDString  
ACCT_MGR_UNVL_IDkfsAcctManagerIdKFS Account Manager IDString  
ORG_CDkfsOrgCodeKFS Organization CodeString  
ACCT_TYP_CDkfsAcctTypeCodeKFS Account Type CodeString  
ACCT_PHYS_CMP_CDkfsAcctCampusCodeKFS Account Campus CodeString  
SUB_FUND_GRP_CDkfsSubFundCodeKFS Sub Fund Group CodeString  
ACCT_FRNG_BNFT_CDkfsAcctFringeBenefitCodeKFS Account Fringe Benefit CodeString  
FIN_HGH_ED_FUNC_CDkfsHigherEduFundCodeKFS Higher Education Function CodeString  
ACCT_RSTRC_STAT_CDkfsAcctRestrictedCodeKFS Account Restricted Status CodeString  
ACCT_RSTRC_STAT_DTkfsAcctRestrictedDateKFS Account Restricted Status DateString  
ACCT_CITY_NMkfsAcctCityKFS Account City NameString  
ACCT_STATE_CDkfsAcctStateKFS Account State CodeString  
ACCT_STREET_ADDRkfsAcctAddressKFS Account Street AddressString  
ACCT_ZIP_CDkfsAcctZipKFS Account Zip CodeString  
RPTS_TO_FIN_COA_CDkfsReportToChartCodeKFS Reports To Chart CodeString  
RPTS_TO_ACCT_NBRkfsReportToAcctNumberKFS Reports To Account NumberString  
ACCT_CREATE_DTkfsAcctCreateDateKFS Account Create DateString  
ACCT_EFFECT_DTkfsAcctEffectiveDateKFS Account Effective DateString  
ACCT_EXPIRATION_DTkfsAcctExpDateKFS Account Expiration DateString  
CONT_FIN_COA_CDkfsContChartCodeKFS Continuation Chart CodeString  
CONT_ACCOUNT_NBRkfsContAcctNumberKFS Continuation Account NumberString  
ENDOW_FIN_COA_CDkfsEndowChartCodeKFS Endowment Chart CodeString  
ENDOW_ACCOUNT_NBRkfsEndowAcctNumberKFS Endowment Account NumberString  
CONTR_CTRL_FCOA_CDkfsCandGChartCodeKFS C&G Control Chart CodeString  
CONTR_CTRLACCT_NBRkfsCandGAcctNumberKFS C&G Control Account NumberString  
INCOME_FIN_COA_CDkfsIncomeChartCodeKFS Income Stream Chart CodeString  
INCOME_ACCOUNT_NBRkfsIncomeAcctNumberKFS Income Stream Account NumberString  
ACCT_ICR_TYP_CDkfsICRTypeCodeKFS ICR Type CodeString  
AC_CSTM_ICREXCL_CDkfsCustomICRCodeKFS Custom ICR CodeString  
FIN_SERIES_IDkfsICRRateCodeKFS ICR Rate CodeString  
ICR_FIN_COA_CDkfsICRChartCodeKFS ICR Credit Chart CodeString  
ICR_ACCOUNT_NBRkfsICRAcctNumberKFS ICR Credit Account NumberString  
ACCT_IN_FP_CDkfsTPSFCodeKFS Transaction Processing Sufficient Funds Check CodeString  
BDGT_REC_LVL_CDkfsBudgetLevelCodeKFS Budget Recording Level CodeString  
ACCT_SF_CDkfsAcctSFCodeKFS Account Sufficient Fund Check CodeString  
ACCT_PND_SF_CDkfsAcctPSFCodeKFS Account Pending Sufficient Fund Check CodeString  
FIN_EXT_ENC_SF_CDkfsEESFCodeKFS External Encumbrance Sufficient Fund Check CodeString  
FIN_INT_ENC_SF_CDkfsIESFCodeKFS Internal Encumbrance Sufficient Fund Check CodeString  
FIN_PRE_ENC_SF_CDkfsPESFCodeKFS Pre-Encumbrance Sufficient Fund Check CodeString  
FIN_OBJ_PRSCTRL_CDkfsObjPCCodeKFS Object Presence Control CodeString  
CG_CFDA_NBRkfsCGCFDANumberKFS CG CFDA numberString  
ACCT_OFF_CMP_INDkfsAcctOffCampusCodeKFS Account Off Campus Indicator CodeString  
ACCT_CLOSED_INDkfsAcctClosedCodeKFS Account Closed Indicator CodeString  
CG_ACCT_RESP_IDkfsAcctRespIdKFS Account Responsibility IDString  
UC_LOC_CDucLocationCodeFS Location Code (legacy)String(1) 
UC_ACCT_NBRucAccountCodeFS Account Code (legacy)String(6) 
UC_FUND_NBRucFundCodeFS Fund Code (legacy)String(5) 
ACCT_FSC_OFC_UIDkfsAcctFiscalOfficerUciNetIdKFS Account Fiscal Officer UCInetIDString 

WS Example

Request
Code Block
<?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>

...

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

...