Street Light Circuit Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
CI_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
CI_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
CI_BRKR_CD |
Breaker |
nnn |
Breaker |
Integer |
CI_BRKR_TY |
Breaker Text |
25x |
Breaker Text |
Text |
CI_CRT_BY |
Created By |
25x |
Created By |
Text |
CI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CI_DESG_CD |
Designation |
nnn |
Designation |
Integer |
CI_DESG_TY |
Designation Text |
25x |
Designation Text |
Text |
CI_ID |
Circuit Rec # |
nnnnnnnn |
Circuit Record No |
Long Integer |
CI_INMAP |
In Map |
|
Last Modified Date |
Boolean |
CI_LC_ID |
Contrl Centr Rec # |
nnnnnnnn |
Long Integer |
|
CI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CI_NUM |
Circuit Name |
20x |
Circuit Name |
Text |
CI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CI_STAT_CD |
Status |
nnn |
Status |
Integer |
CI_STAT_TY |
Status Text |
25x |
Status Text |
Text |
CI_VOLT_CD |
Voltage |
nnn |
Voltage |
Integer |
CI_VOLT_TY |
Voltage Text |
25x |
Voltage Text |
Text |
CI_X |
X Coordinate |
nnnnnnnn.nn |
X Coordinate |
Double |
CI_Y |
Y Coordinate |
nnnnnnnn.nn |
Y Coordinate |
Double |