Segment assets
This table shows the names of the fields that you must add to the geodatabase to synchronize with segment asset records in the Operations and Regulations database.
Note: Be sure to specify the name of each field, not the alias.
| 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 |
| COMPTYPE | SHORT INTEGER | 4 |
| COMPKEY | LONG INTEGER | 9 |
| PARLINENO | TEXT | 1 |