Obligation

Obligation Data Model

The following data model illustrates the obligation object.

Obligation Data Model

Obligation Table Names

*Data Model Name*	*Table Name*	*Generated Keys*	*Object Validation Batch Control*	*Referential Integrity Validation Batch Control*	*Key Assignment Batch Control*	*Insertion Batch Control*
Obligation	CI_SA	Yes CI_SA_K	VAL-OBLG		CIPVSVAK Has dependencies	CIPVSVAI See Optional FK Note below.
Characteristic	CI_SA_CHAR	No. The key is obligation ID plus an edate and a char type.		CIPVSACV		CIPVSACI
Contract Quantity Edate	CI_SA_CONT_QTY	No. The key is obligation ID plus quantity type plus edate.		CIPVSAQV		CIPVSAQI
Message	CI_SA_MSG	No. The key is obligation ID plus Bill message code.		CIPVSMGV		CIPVSMGI
Recurring Charge	CI_SA_RCHG_HIST	No. The key is obligation ID plus edate.		CIPVSARV		CIPVSARI
Rate History	CI_SA_RS_HIST	No. The key is obligation ID plus edate.		CIPVSAHV		CIPVSAHI
Tax Exempt	CI_SA_CONTERM - this table is also used for the next 2 entities, the key contains CONTERM_TYPE_FLG that controls the entity	No. This key is obligation ID plus CONTERM_TYPE_FLG plus BF_CD plus START_DT		CIPVSAOV		CIPVSAOI
Contract Rider	CI_SA_CONTERM - this table is also used for the previous and next entities, the key contains CONTERM_TYPE_FLG that controls the entity	No. This key is obligation ID plus CONTERM_TYPE_FLG plus BF_CD plus START_DT		CIPVSAOV		CIPVSAOI
Contract Value	CI_SA_CONTERM - this table is also used for the previous 2 entities, the key contains CONTERM_TYPE_FLG that controls the entity	No. This key is obligation ID plus CONTERM_TYPE_FLG plus BF_CD plus START_DT		CIPVSAOV		CIPVSAOI

Obligation Suggestions

This maintenance object includes a character large object field that your organization may be using to capture implementation specific data as defined by your business objects. For records of this type, the process to insert the records to the staging table is responsible for populating the data in this CLOB as per the record's business object schema.

Optional FK Note

Account has an optional foreign key CHAR_PREM_ID to the Location (CI_PREM) table and an optional foreign key TAX_ROLE_ID to the Tax Role (CI_TAX_ROLE) table. If your implementation is planning to convert obligations, but not locations or tax roles, the key generation programs for Location and Tax Role must still be run. Refer to The Big Picture of Key Assignment for more information.