The values stored in this table indicate any isolation blocks that will also be isolated when a given isolation block is isolated from the network. It is noted that there may be multiple records in Table 4 for a single isolation block. The number of records in Table 4 will vary in accordance with the structure of the network; that is, the table is dependent on the number of dead-end blocks or dead-end branches that are present in the network.
A summary of the fields included in all four of these tables follows:
|
Table |
HxGN EAM Table Name |
Field |
Field Description |
|---|---|---|---|
|
1 |
r5mainisolationmains |
mip_mainid |
A unique ID number for each individual main feature. [VARCHAR2(30)] |
|
mip_gisobjid |
The unique GISOBJID associated with each main GIS feature (GISOBJID is assigned during integration process to create corresponding EAM equipment record. [NUMBER(38)] |
||
|
mip_blockid |
An ID number for isolation block within which each main feature is located. [NUMBER(18)] |
||
|
2 |
r5mainisolationvalves |
miv_valveid |
A unique ID number for each individual valve feature. [VARCHAR2(30)] |
|
mid_gisobjid |
The unique GISOBJID associated with each valve GIS feature. [NUMBER(38)] |
||
|
miv_blockid1 |
An ID number indicating one of the two isolation block(s) to which the valve feature is associated. [NUMBER(18)] |
||
|
miv_blockid2 |
An ID number indicating the other isolation block within which the valve feature is associated. [NUMBER(18)] |
||
|
3 |
r5mainisolationblocks |
mib_blockid |
A unique ID number representing each individual isolation block that would be represented by the user’s GIS network. [NUMBER(18)] |
|
mib_hydrants |
Number of hydrants impacted by an isolation of the specific isolation block. NUMBER(9) |
||
|
mib_customers |
Number of customers impacted by an isolation of the specific isolation block. NUMBER(9) |
||
|
mib_volume |
Volume of consumption interrupted by an isolation of the specific isolation block. NUMBER(9) |
||
|
4 |
r5mainisolationdepblocks |
mid_blockid |
The ID number of a block having a dependent block (i.e. the upstream block). [NUMBER(18)] |
|
mid_depblockid |
The ID number for dependent block (i.e. the corresponding downstream block). [NUMBER(18)] |