Table Description
Fund Fiscal Year Line Item: A Fund Fiscal Year Line Item contains details of monies available from a funding source for a fund for a given fiscal year. A Fund Fiscal Year Line Item contains details of monies available from a funding source for a fund for a given fiscal year.
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 Line Item::Entity::FundFclYrLineItem
Controlling File: FundPM\model\Packages\Service Layer\Fund Fiscal Year Line Item\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fundFclYrLineItemIDkeynoUnique identifier assigned by the system to the Fund Fiscal Line Item record.INTERNAL_ID SVR_INT64
fundFiscalYearIDdetailsnoUnique identifier assigned by the system to the Fund Fiscal Year record.FUND_FISCAL_YEAR_ID SVR_INT64
lineItemRefNodetailsnoUnique identifier assigned by the Organization for a Fund Fiscal Year Line Item.REFERENCE_NUMBER SVR_STRING<20>
budgetAllocatedTotaldetailsnoThe total amount allocated for the Fund in the Fiscal Year.OPTIONAL_POSITIVE_MONEY SVR_MONEY
paymentAllocationPrioritydetailsyesThe priority of the payment allocation for a fund in the fiscal year.PRIORITY SVR_INT32
typedetailsnoThe source of the funding, for example Federal, State.FUND_FISCAL_YEAR_LINE_ITEM_TYPEFndFclYrLineItemTypeSVR_STRING<10>
paymentTotaldetailsyesThe total amount paid from the Fund Fiscal Year Line Item. It represents the sum of payment transactions for the Fund Fiscal Year Line Item.CURAM_AMOUNT SVR_MONEY
startDatedetailsnoStart Date of the Fund Fiscal Year Line Item.CURAM_DATE SVR_DATE
endDatedetailsnoEnd Date of the Fund Fiscal Year Line Item.CURAM_DATE SVR_DATE
commentsdetails Comments recorded by Fund Administrator relating to the Fund Fiscal Year Line Item.COMMENTS SVR_STRING<300>
recordStatusdetailsnoThe status of the Fund Fiscal Year Line Item is used to indicate if the Fund Fiscal Year Line Item has been logically deleted.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FundFclYrLineItem.fundFiscalYearIDFundFiscalYear.fundFiscalYearID
Indices (1)
Index NameAttributes
IND_22582096fundFiscalYearID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fundFclYrLineItemID
Inserts a Fund Fiscal Year Line Item record. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a Fund Fiscal Year Line Item record. 
readread Reads a Fund Fiscal Year Line Item record. 
searchByFundFiscalYearreadmultiORDER_BY: type
Reads all Fund Fiscal Year Line Items for a Fund Fiscal Year. 
searchByFundFiscalYearAndPriorityreadmulti Searches and returns all the Fund Fiscal Year Line Items for a Fund Fiscal Year with the given priority. 
Related Pages (17)