Network assets
This table shows the names of the fields that you must add to the geodatabase to synchronize with network asset records in the Operations and Regulations database.
Note: Be sure to specify the name of each field, not the alias.
Network assets, such as sewer or water mains, require additional columns because a main in Operations and Regulations is identified as the stretch of pipe between two other assets, such as two manholes. Thus, in addition to the COMPKEY and COMPTYPE of the network asset itself, the table for a network asset requires columns for the COMPTYPE and UNITID of each endpoint.
| Column | SQL type | Length |
|---|---|---|
| UNITID | TEXT | 50 |
| UNITID2 | TEXT | 50 |
| UNITTYPE (Optional. If included, UNITTYPE is included in the comparison of primary fields.) | TEXT | 10 |
| MAINCOMP1 | SHORT INTEGER | 4 |
| MAINCOMP2 | SHORT INTEGER | 4 |
| COMPTYPE | SHORT INTEGER | 4 |
| COMPKEY | LONG INTEGER | 9 |
| PARLINENO (if used) | TEXT | 1 |