SA Interval Billing 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
TOU Map
CI_​TOU_​MAP
Yes CI_​TOU_​MAP_​K
CIPVTMAK
CIPVTMAI
TOU Map Lang
CI_​TOU_​MAP_​L
No. The key is TOU_​MAP_​ID plus language code.
CIPVTMLV
CIPVTMLI
Interval Profile
CI_​INTV_​PF
Yes CI_​INTV_​PF_​K
CIPVINPK
CIPVINPI
Interval Profile Lang
CI_​INTV_​PF_​L
No. The key is INTV_​PF_​ID plus language code
CIPVINLV
CIPVINLI
SA / Interval Profile
CI_​SA_​INTV_​PF
No. The key is service agreement ID plus INTV_​PF_​REL_​TYP_​CD plus START_​DTTM plus INTV_​PF_​ID
CIPVSIFV
CIPVSIPI
SA / TOU Map
CI_​SA_​TOU_​MAP
No. The key is service agreement ID plus TMAP_​REL_​TYPE_​CD plus START_​DTTM plus TOU_​MAP_​ID
CIPVSTMV
CIPVSTMI
TOU Contract Value
CI_​TOU_​CONT_​VAL
No. The key is service agreement ID plus CONTERM_​TYPE_​FLG plus START_​DT plus BF_​CD plus TOU_​GRP_​CD plus TOU_​CD
CIPVTCVV
CIPVTCVI