Table Description
: The link between a Fund and its Budgets and Expenditures for a specific fiscal year. A fund has budgets, obligations and expenditures that are associated with specific fiscal years. An organization defines specific budgets for its Welfare fund for Federal Fiscal Year 2010. A Child care service is authorized to charge its expenditures against the fund, and when the service is authorized the expected amount is added to the obligated amount for the Fiscal Year Fund record.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::FundPM::Service Layer::Fund Fiscal Year::Entity::FundFiscalYear
Controlling File: FundPM\model\Packages\Service Layer\Fund Fiscal Year\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fundFiscalYearIDkeynoUnique reference number assigned by the system to a FundFiscalYear record.FUND_FISCAL_YEAR_ID SVR_INT64
programFundIDdetailsnoUnique reference number assigned by the system to the Funds associated with the Fiscal Year.INTERNAL_ID SVR_INT64
fiscalYearIDdetailsnoUnique reference number assigned by the system to a Fiscal Year associated with the Fund.INTERNAL_ID SVR_INT64
totalObligatedAmountdetailsnoThe total amount obligated against the Fund in the Fiscal Year. It represents the sum of all Obligation Fund Line Items, associated with the Fund for the Fiscal Year. CURAM_AMOUNT SVR_MONEY
commentsdetailsyesComments recorded by Fund Manager relating to the fund fiscal year.COMMENTS SVR_STRING<300>
statusdetailsno FUND_FISCAL_YEAR_STATUSFundFiscalYearStatusSVR_STRING<10>
recordStatusdetailsnoCode value to denote the status of the FundFiscalYear record.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
FundFiscalYear.fiscalYearIDFiscalYear.fiscalYearID
FundFiscalYear.programFundIDProgramFund.programFundID
FundFclYrLineItem.fundFiscalYearIDFundFiscalYear.fundFiscalYearID
Obligation.fundFiscalYearIDFundFiscalYear.fundFiscalYearID
Indices (2)
Index NameAttributes
FFYFsclYrIDIdxfiscalYearID
FFYFundIDIdxprogramFundID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fundFiscalYearID
AUTO_ID_KEY: FUNDPMKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchFundFiscalYearByProgramFundIDreadmulti   
readByProgramFundIDAndEffectiveDatens This method retrieves the fiscal year record for the given fundID and effective date. We expect only one fiscal year to be active for a fund at any given time. SQL
searchByRelatedIDAndStartAndEndDatensmulti This methods retrieves all the records for the given relatedID and startDate and endDate for the select and evaluate fund operationSQL
searchFundFiscalYearByFiscalYearIDreadmulti   
searchFundFiscalYearByCurrentDateAndStatusnsmulti  SQL
searchByFundIDAndObligationPeriodnsmulti Searches fund fiscal year details by the fund ID and the obligation period.SQL
searchByBusinessProcessingDateAndStatusnsmulti Retrieves all the fund fiscal years with the given status and whose end date is before the given processing date.SQL
Related Pages (23)