Data Model Name | Table Name | Generated Keys | Object Validation Batch Control | Referential Integrity Validation Batch Control | Key Assignment Batch Control | Insertion Batch Control |
Service Agreement | CI_SA | Yes CI_SA_K | CIPVSVAK | CIPVSVAI | ||
Characteristic | CI_SA_CHAR | No. The key is SA_ID plus an edate and a char type. | CIPVSACV | CIPVSACI | ||
Contract Quantity Edate | CI_SA_CONT_QTY | No. The key is service agreement ID plus quantity type plus edate. | CIPVSAQV | CIPVSAQI | ||
Message | CI_SA_MSG | No. The key is service agreement ID plus Bill message code. | CIPVSMGV | CIPVSMGI | ||
Recurring Charge | CI_SA_RCHG_HIST | No. The key is service agreement ID plus edate. | CIPVSARV | CIPVSARI | ||
SA Relationship | CI_SA_REL | Yes CI_SA_REL_K | CIPVSRLV | CIPVSRLK | CIPVSRLI | |
Rate History | CI_SA_RS_HIST | No. The key is service agreement ID plus edate. | CIPVSAHV | CIPVSAHI | ||
SA/SP | CI_SA_SP | Yes CI_SA_SP_K | CIPVSAPV | CIPVSSPK | CIPVSAPI | |
SA/SP Characteristic | CI_SA_SP_CHAR | No. The key is SA/SP Id plus char type plus effective date. | CIPVSSCV | CIPVSSCI | ||
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 service agreement 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 service agreement 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 service agreement ID plus CONTERM_TYPE_FLG plus BF_CD plus START_DT | CIPVSAOV | CIPVSAOI | ||
SA/Consumer Contract Product | C1_SA_CONT_PROD | No. This key is service agreement ID plus CONT_PROD_ID plus EFF_DT. | CIPVSCTV | CIPVSCTI |