Data Model Name | Table Name | Generated Keys | Object Validation Batch Control | Referential Integrity Validation Batch Control | Key Assignment Batch Control | Insertion Batch Control |
Service Point | CI_SP | Yes CI_SP_K | CIPVSPPK | CIPVSPPI | ||
Characteristic | CI_SP_CHAR | No. The key is SP_ID plus an edate and a char type. | CIPVSPCV | CIPVSPCI | ||
Equipment (not applicable to Oracle Utilities Customer Care and Billing ) | CI_SP_EQ | No. The key is service point ID plus equipment (service point) ID. | CIPVSEQV | CIPVSEQI | ||
Geo Loc | CI_SP_GEO | No. The key is service point ID plus geo type. | CIPVSPGV | CIPVSPGI | ||
Unbadged Item | CI_SP_MULT_ITEM | No. The key is SP_ID plus edate. | CIPVSPMV | CIPVSPMI | ||
Item | CI_MULT_ITEM | No. The key is SP_ID, edate and item type. | CIPVSMIV | CIPVSMII | ||
SP Op Area | CI_SP_OP_AREA | No. The key is SP_ID plus field service classification code | CIPVSPOV | CIPVSPOI | ||
SA/SP | CI_SA_SP (note, this table really belongs to the SA object, it is included here for completeness) | Yes CI_SA_SP_K | CIPVSVAB | CIPVSAPV | CIPVSSPK | CIPVSAPI |