Versions Compared

Version Old Version 116 New Version Current
Changes made by

Jarrod Lannan

Jarrod Lannan

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: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>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>vcesario<<kfsAcctFiscalOfficerUciNetId></kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000247608<<kfsAcctManagerId>000000111111</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>000000111111</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>0000000111111</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>

...

IndexParameterDescriptionRequired?Data Type (max length)Example
0managerUciNetIdAccount Manager Uci Net IdYesStringmpleetest

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
	,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 = 'mpleetest' );

Result Schema: SAME as getdKFSAccounts

...

Code Block
<?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>mcdavee<<managerUciNetId>test</managerUciNetId>
		</ns2:getKFSAccountsByManager>
	</S:Body>
</S:Envelope>

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
 	  <soap:Body>
		      <ns2:getKFSAccountsByManagerResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				
         <return>
            <kfsAcctAddress>Campus Dr</kfsAcctAddress>
				            <kfsAcctCampusCode>IR</kfsAcctCampusCode>
				            <kfsAcctCity>Irvine</kfsAcctCity>
				<kfsAcctClosedCode>N</kfsAcctClosedCode>
				<kfsAcctFiscalOfficerId>000000076277</kfsAcctFiscalOfficerId>
				<kfsAcctFiscalOfficerUciNetId>mcdavee</kfsAcctFiscalOfficerUciNetId>
				<kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
				<kfsAcctManagerId>000000076277</kfsAcctManagerId>
				<kfsAcctName>407680-19900 ACADEMIC AFFAIRS RENOVATION</kfsAcctName>
				<kfsAcctNumber>GF11503</kfsAcctNumber>
				<kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
				<kfsAcctPSFCode>N</kfsAcctPSFCode>
				<kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
				<kfsAcctSFCode>N</kfsAcctSFCode>
				<kfsAcctState>CA</kfsAcctState>
				<kfsAcctSupervisorId>000000000899</kfsAcctSupervisorId>
				<kfsAcctTypeCode>CF</kfsAcctTypeCode>
				<kfsAcctZip>92697</kfsAcctZip>
				<kfsBudgetLevelCode>C</kfsBudgetLevelCode>
				<kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
				<kfsCandGChartCode>IR</kfsCandGChartCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsEESFCode>N</kfsEESFCode>
				<kfsHigherEduFundCode>ACAD</kfsHigherEduFundCode>
				<kfsIESFCode>N</kfsIESFCode>
				<kfsObjPCCode>N</kfsObjPCCode>
				<kfsOrgCode>8542</kfsOrgCode>
				<kfsPESFCode>N</kfsPESFCode>
				<kfsSubFundCode>401000</kfsSubFundCode>
				<kfsTPSFCode>Y</kfsTPSFCode>
				<ucAccountCode>407680</ucAccountCode>
				<ucFundCode>19900</ucFundCode>
				<ucLocationCode>9</ucLocationCode>
			</return>
			<return>
				<kfsAcctAddress>Campus Dr</kfsAcctAddress>
				<kfsAcctCampusCode>IR</kfsAcctCampusCode>
				<kfsAcctCity>Irvine</kfsAcctCity>
				<kfsAcctClosedCode>N</kfsAcctClosedCode>
				<kfsAcctFiscalOfficerId>000000076277</kfsAcctFiscalOfficerId>
				<kfsAcctFiscalOfficerUciNetId>mcdavee</kfsAcctFiscalOfficerUciNetId>
				<kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
				<kfsAcctManagerId>000000076277</kfsAcctManagerId>
				<kfsAcctName>407682-09535 ACADEMIC SUPPORT - UNALLOCA</kfsAcctName>
				<kfsAcctNumber>EP10428</kfsAcctNumber>
				<kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
				<kfsAcctPSFCode>N</kfsAcctPSFCode>
				<kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
				<kfsAcctSFCode>N</kfsAcctSFCode>
				<kfsAcctState>CA</kfsAcctState>
				<kfsAcctSupervisorId>000000000899</kfsAcctSupervisorId>
				<kfsAcctTypeCode>CF</kfsAcctTypeCode>
				<kfsAcctZip>92697</kfsAcctZip>
				<kfsBudgetLevelCode>C</kfsBudgetLevelCode>
				<kfsCandGAcctNumber>UC09535</kfsCandGAcctNumber>
				<kfsCandGChartCode>IR</kfsCandGChartCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsEESFCode>N</kfsEESFCode>
				<kfsHigherEduFundCode>ACAD</kfsHigherEduFundCode>
				<kfsIESFCode>N</kfsIESFCode>
				<kfsObjPCCode>N</kfsObjPCCode>
				<kfsOrgCode>8542</kfsOrgCode>
				<kfsPESFCode>N</kfsPESFCode>
				<kfsSubFundCode>407220</kfsSubFundCode>
				<kfsTPSFCode>Y</kfsTPSFCode>
				<ucAccountCode>407682</ucAccountCode>
				<ucFundCode>09535</ucFundCode>
				<ucLocationCode>9</ucLocationCode>
			</return>
      ...            <kfsAcctClosedCode>N</kfsAcctClosedCode>
            <kfsAcctFiscalOfficerId>000000011111</kfsAcctFiscalOfficerId>
            <kfsAcctFiscalOfficerUciNetId>test</kfsAcctFiscalOfficerUciNetId>
            <kfsAcctFringeBenefitCode>Y</kfsAcctFringeBenefitCode>
            <kfsAcctManagerId>000000011111</kfsAcctManagerId>
            <kfsAcctName>40112 Test Acct Name</kfsAcctName>
            <kfsAcctNumber>GF12345</kfsAcctNumber>
            <kfsAcctOffCampusCode>N</kfsAcctOffCampusCode>
            <kfsAcctPSFCode>N</kfsAcctPSFCode>
            <kfsAcctRestrictedCode>U</kfsAcctRestrictedCode>
            <kfsAcctSFCode>N</kfsAcctSFCode>
            <kfsAcctState>CA</kfsAcctState>
            <kfsAcctSupervisorId>000000011111</kfsAcctSupervisorId>
            <kfsAcctTypeCode>CF</kfsAcctTypeCode>
            <kfsAcctZip>92611</kfsAcctZip>
            <kfsBudgetLevelCode>C</kfsBudgetLevelCode>
            <kfsCandGAcctNumber>UC19900</kfsCandGAcctNumber>
            <kfsCandGChartCode>IR</kfsCandGChartCode>
            <kfsChartCode>IR</kfsChartCode>
            <kfsEESFCode>N</kfsEESFCode>
            <kfsHigherEduFundCode>TEST</kfsHigherEduFundCode>
            <kfsIESFCode>N</kfsIESFCode>
            <kfsObjPCCode>N</kfsObjPCCode>
            <kfsOrgCode>8542</kfsOrgCode>
            <kfsPESFCode>N</kfsPESFCode>
            <kfsSubFundCode>401000</kfsSubFundCode>
            <kfsTPSFCode>Y</kfsTPSFCode>
            <ucAccountCode>407680</ucAccountCode>
            <ucFundCode>19900</ucFundCode>
            <ucLocationCode>9</ucLocationCode>
         </return>
		</ns2:getKFSAccountsByManagerResponse>
	</soap:Body>
</soap:Envelope>

...

Code Block
		DWHServerService service = new DWHServerService();
		DWHServer server = service.getDWHServerPort();
		
		List<AccountDetails> resultList = server.getKFSAccountsByManager("mcdaveetest");
		
		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");
		}

...

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

 

...

translateFSAccountToKFSObject(List of (fsLocationCode, fsAccountCode, kfsChartCode, kfsFiscalYear))

This service is used to translate legacy FS balance sheet and income accounts to KFS object codes.

...

IndexParameterDescriptionRequired?Data Type (max length)
0fsLocationCodeThe FS location codeYesString (2)
1fsAccountCodeThe FS accounts codeYesString (6)
2fsFundCodekfsChartCodeThe FS fund KFS chart codeYesString (2)
3kfsFiscalYearThe KFS fiscal yearYesString (54)

DB Query

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

...