CSE_METER_READINGS_INT
The open interface entity that holds all the physical attributes of the meter readings.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CSE_METER_READINGS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row Identifier. The primary key column of this table. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk. | ||
| INTERFACE_BATCH_ID | NUMBER | 18 | Interface Batch Identifier. This is the foreign key to the Interface Batch entity. | ||
| INTERFACE_BATCH_CODE | VARCHAR2 | 30 | The interface batch code. The user key to the interface batch entity. | ||
| PARTITION_NUMBER | NUMBER | 18 | For parallel processing, the internal logic uses this column to stripe the bunch of meter readings in to a partition. | ||
| INTERFACE_RECORD_NUMBER | VARCHAR2 | 18 | Interface Record Number. This is the user key to link the child interface entities together. | ||
| ACTION_CODE | VARCHAR2 | 30 | The various actions that can be performed via the import functionality at the meter reading level. | ||
| METER_CODE | VARCHAR2 | 30 | The unique user identifier for the meter. It is unique across the system. | ||
| METER_ID | NUMBER | 18 | The foreign key to the instantiated meter. | ||
| ASSET_NUMBER | VARCHAR2 | 80 | An user identifier for the asset object. This is the user primary key for the asset. | ||
| ASSET_ID | NUMBER | 18 | Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator | ||
| SUBSCRIPTION_PRODUCT_PUID | VARCHAR2 | 120 | The subscription product public unique identifier. | ||
| METER_READING_ID | NUMBER | 18 | Unique identifier and Primary Key for the meter reading entity. | ||
| READING_DATE | TIMESTAMP | The date when the reading is captured. | |||
| READING_TYPE_CODE | VARCHAR2 | 30 | When reading is captured for the meter that has the meter reading type of both (absolute or change), at the capture time, user must say whether the value is absolute or change. | ||
| RESET_FLAG | VARCHAR2 | 1 | Flag indicating wheter the reading was created as a result of a meter reset. | ||
| ROLLOVER_FLAG | VARCHAR2 | 1 | Flag indicating whether the reading was created as a result of the rollover settings in the meter instance or meter definition. | ||
| READING_VALUE | NUMBER | The numeric reading value that is captured for the meter. | |||
| READING_NET_CHANGE | NUMBER | Computed programatically. Typically it will be = new reading – net of last reading, but there are some different formulas involved. | |||
| NET_VALUE | NUMBER | Computed programmatically. Typically it will be = new reading + net of last reading, but there are some different formulas involved. | |||
| DISPLAYED_VALUE | NUMBER | The numeric reading value that is displayed in the user interface after computing the value that the user entered. | |||
| COMMENTS | VARCHAR2 | 240 | Free format comment field used to capture any notes, etc while the reading is being captured. | ||
| WORK_ORDER_ID | NUMBER | 18 | The work order where this meter reading is captured upon completion of the work order. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_METER_READINGS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |
| CSE_METER_READINGS_INT_N01 | Non Unique | Default | PARTITION_NUMBER |