| Table of Contents |
|---|
...
getKFSActiveFiscalPeriods(date)
This service is used to determine the active fiscal period periods 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.
...
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | date | The date to search for active fiscal period | No (default is today's date) | String(8) YYYYMMDD | '20120701' |
DB Query
| 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 <= '1213' AND univ_fscpd_end_dt >= convert(DATETIME, '2013062520130715', 112) ORDER BY univ_fiscal_yr, univ_fiscal_prd_cd |
Result Schema: A list of following elements (
...
FiscalPeriodDetails)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsFiscalYear | KFS Fiscal Year | Integer | 2014 |
| kfsFiscalPeriod | KFS Fiscal Period | String (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"); } |
...