Versions Compared

Version Old Version 2 New Version 3
Changes made by

Jarrod Lannan

Jarrod Lannan

Saved on

Key

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

Table of Contents

...

getKFSActiveFiscalPeriods(date)

This service is used to determine the active fiscal period for a given date. Returns an XML result set with the fiscal period and fiscal yeara list of (kfsFiscalYear, kfsFiscalPeriod).

  • date has to be valid.  Null will be returned otherwise.

...

Code Block
SELECT TOP 1 univ_fiscal_yr, univ_fiscal_prd_cd
FROM sh_acct_period_t
WHERE row_actv_ind <> 'N'
	AND univ_fiscal_prd_cd <= '12'
	AND univ_fscpd_end_dt >= convert(DATETIME, '20130625', 112)
ORDER BY univ_fiscal_yr, univ_fiscal_prd_cd

Result Schema: A list of following elements (

...

FiscalPeriodDetails)

ParameterDescriptionData TypeExample
kfsFiscalYearKFS Fiscal YearInteger2014
kfsFiscalPeriodKFS Fiscal PeriodString (2)

'01'

...

Code Block
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
	<S:Body>
		<ns2:getKFSActiveFiscalPeriodgetKFSActiveFiscalPeriods xmlns:ns2="http://www.adcom.uci.edu">
			<date>20130625<<date>20130715</date>
		</ns2:getKFSActiveFiscalPeriod>getKFSActiveFiscalPeriods>
	</S:Body>
</S:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:getKFSActiveFiscalPeriodResponsegetKFSActiveFiscalPeriodsResponse xmlns:ns2="http://www.adcom.uci.edu">
			<return>
				<kfsFiscalPeriod>13</kfsFiscalPeriod>
				<kfsFiscalYear>2013</kfsFiscalYear>
			</return>
			<return>
				<kfsFiscalPeriod>01</kfsFiscalPeriod>
				<kfsFiscalYear>2014</kfsFiscalYear>
			</return>
		</ns2:getKFSActiveFiscalPeriodResponse>getKFSActiveFiscalPeriodsResponse>
	</soap:Body>
</soap:Envelope>

...

Code Block
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
FiscalPeriodDetailsList<FiscalPeriodDetails> fpDetailsfpDetailsList = server.getKFSActiveFiscalPeriodgetKFSActiveFiscalPeriods("2013062520130715");

if (fpDetailsfpDetailsList != null) {
	for (FiscalPeriodDetails fpDetails : fpDetailsList) {
		System.out.println(fpDetails.getKfsFiscalYear() + " " + fpDetails.getKfsFiscalPeriod());
	}
}
else {
	System.out.println("something bad happened...please check your query");
}

...