Table Description
: A twelve month period over which an organization budgets its funds. A fiscal year is manually defined by the fund administrator to represent the budgeting periods utilized by the organization. An organization may have budget sources associated with different fiscal years from multiple sources. For example, an organization my have access to Federal, State and Municipal funds where the Federal Fiscal year runs from October to September, the State fiscal Year runs from July to June and the Municipal Fiscal Year runs from January to December. Funding Stream Budgets are associated with funds for a specific fiscal year period.
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::Fiscal Year::Entity::FiscalYear
Controlling File: FundPM\model\Packages\Service Layer\Fiscal Year\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fiscalYearIDkeynoUnique reference number assigned by the system to a Fiscal Year record.INTERNAL_ID SVR_INT64
yearNamedetailsnoDisplay name given by the fund administrator to the fiscal year period. (e.g. Federal 2010)FISCAL_YEAR_NAMEFiscalYearNameSVR_STRING<10>
categorydetailsnoCode value to denote the category of the fiscal year. (e.g. Federal, State, Municipal)FISCAL_YEAR_CATEGORYFiscalYearCategorySVR_STRING<10>
startDatedetailsnoStart Date of the Fiscal Year.CURAM_DATE SVR_DATE
endDatedetailsnoEnd Date of the Fiscal Year.CURAM_DATE SVR_DATE
recordStatusdetailsnoCode value to denote the status of the Fiscal Year record.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FundFiscalYear.fiscalYearIDFiscalYear.fiscalYearID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fiscalYearID
AUTO_ID_KEY: FUNDPMKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
readAllnkreadmultiORDER_BY: startDate
This method will return all the Fiscal Years available. 
searchByFiscalYearCategoryreadmulti This method will search a Fiscal Year record by the Fiscal Year Category. 
searchFiscalYearNamesByStatusnsmulti Searches all unique fiscal year names by the given record status.SQL
Related Pages (26)