Account Information
Module: Customer Insights
Type: Dimension
ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | True | Record Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| ACTIVE_RATE_CODES | VARCHAR2 | 1000 | Active rate codes | ||||
| HAS_ACTIVE_ACCOUNT | VARCHAR2 | 20 | Has active account | ||||
| HAS_AMI_METER | VARCHAR2 | 20 | Has AMI meter | ||||
| NUM_ACTIVE_ELEC_METERS_BUCKET | VARCHAR2 | 20 | Active electric meters | ||||
| NUM_ACTIVE_GAS_METERS_BUCKET | VARCHAR2 | 20 | Active gas meters | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |