Table Description
Obligation: An obligation is a type of fund fiscal year transaction which, when created, impacts the budgeted balance. An obligation is a type of fund fiscal year transaction which, when created, impacts the budgeted balance of the fund fiscal year by the value of the obligation amount.
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::Obligation::Entity::Obligation
Controlling File: FundPM\model\Packages\Service Layer\Obligation\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
obligationIDkeynoUnique identifier assigned by the system to the Obligation record.INTERNAL_ID SVR_INT64
transactionTypedetailsnoThe type of transaction, such as Obligation or Obligation adjustment.OBLIGATION_TRANSACTION_TYPEObligationTransactionTypeSVR_STRING<10>
debitCreditTypedetailsnoThis indicates if the obligation increases or decreases the fund fiscal year Remaining Budgeted Balance, and the Obligated Total.CREDIT_DEBIT_CODECreditDebitSVR_STRING<10>
amountdetailsnoThe financial amount associated with the obligation.CURAM_AMOUNT SVR_MONEY
creationDatedetailsnoThe date the record was created.CURAM_DATE SVR_DATE
relatedTypedetailsnoThe type of financial transaction which caused the obligation to be created, such as a Product Delivery or Planned ItemOBLIGATION_RELATED_TYPEObligationRelatedTypeSVR_STRING<10>
relatedIDdetailsnoThe unique reference number of the related financial transaction which caused the obligation to be created, such as a Product Delivery or Planned Item.INTERNAL_ID SVR_INT64
startDatedetailsnoStart date of the period the obligation relates to.CURAM_DATE SVR_DATE
endDatedetailsnoEnd date of the period the obligation relates to.CURAM_DATE SVR_DATE
fundFiscalYearIDdetailsnoUnique identifier assigned by the system to the fund fiscal year.FUND_FISCAL_YEAR_ID SVR_INT64
Foreign Keys (2)
ChildParent
Obligation.fundFiscalYearIDFundFiscalYear.fundFiscalYearID
ObligationHistory.obligationIDObligation.obligationID
Indices (2)
Index NameAttributes
obgnRelatedIDIdxrelatedID
IND_1458133340fundFiscalYearID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: obligationID
Creates a new row on Obligation table.  
readread Reads a row of data from Obligation table.  
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Obligation table. 
searchByFundFiscalYearreadmulti Reads all the obligation records for a fund fiscal year. 
searchByRelatedIDAndRelatedTypereadmultiWHERE: relatedID = :relatedID AND relatedType = :relatedType
Searches and returns all the records for the combination of related ID and related type. 
searchByProgramFundIDandObligationRelatedTypensmulti  SQL
searchByFundedItemRulesLinkPeriodAndRelatedIDnsmulti  SQL
searchByRelatedIDObligationRelatedTypeForServiceOfferingnsmulti  SQL
searchByRelatedIDObligationRelatedTypeForProductnsmulti  SQL
Related Pages (9)