Database Table: ObligationHistory
| Obligation History:
A history of the changes made to an individual obligation. These changes result when a calling system (UoFPM) initiates the update of an obligation.
A history of the changes made to an individual obligation. A record is inserted to this entity when user modifies the obligation period and/or obligation amount which is non-zero value. |
|
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
|
| Location in Model: | Logical View::MetaModel::Curam::FundPM::Service Layer::Obligation::Entity::ObligationHistory |
| Controlling File: | FundPM\model\Packages\Service Layer\Obligation\Entity\Entity_cat.efx |
| Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
| obligationHistoryID | key | no | Unique identifier assigned by the system to the Obligation History record. | INTERNAL_ID | | SVR_INT64 |
| amount | details | | The financial amount associated with the obligation. | CURAM_AMOUNT | | SVR_MONEY |
| obligationID | details | no | Unique identifier assigned by the system to the Obligation record. | INTERNAL_ID | | SVR_INT64 |
| startDate | details | | Start date of the period the obligation relates to. | CURAM_DATE | | SVR_DATE |
| endDate | details | | End date of the period the obligation relates to. | CURAM_DATE | | SVR_DATE |
| debitCreditType | details | no | This indicates if the obligation increases or decreases the fund fiscal year Remaining Budgeted Balance, and the Obligated Total. | CREDIT_DEBIT_CODE | CreditDebit | SVR_STRING<10> |
|
| Index Name | Attributes |
| IND__1702846558 | obligationID |
|
| Operation | Stereotype | Options | Description | SQL |
| insert | insert | AUTO_ID: obligationHistoryID
| Creates a new row on Obligation History table. | |
| searchByObligationID | readmulti | | Reads all the obligation historyrecords for an obligation. | |
|
