Electric Conduit and Ducts Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
CD_BDEPTH |
Buried Depth |
30x |
Depth from top of conduit to ground line |
Text |
CD_BR_CD |
Default WO Cat |
10x |
Default WO Category Code |
Text |
CD_BR_TY |
Default WO Cat Text |
60x |
Default WO Category Type |
Text |
CD_CONFIG |
Configuration |
254x |
Stores information about duct or position layout within the conduit |
Text |
CD_CRT_BY |
Created By |
25x |
Created By |
Text |
CD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CD_DOC_FLG |
Doc Available |
|
Doc Available: Doc Flag |
Boolean |
CD_DSIZE |
Duct Size |
nnnnnn.nn |
Duct Size |
Double |
CD_ENCA_CD |
Encasement Type |
nnnn |
Encasement Type |
Integer |
CD_ENCA_TY |
Encasement Type Text |
25x |
Encasement Type Text |
Text |
CD_HEIGHT |
Height |
nnnnnn.nn |
Height |
Double |
CD_ID |
Conduit Rec # |
nnnnnnnn |
Conduit Rec ID |
Long Integer |
CD_INMAP |
In Map Flag |
|
In Map Flag |
Boolean |
CD_INST_DT |
Installation Date |
mm/dd/yyyy |
Installation Date |
Date/Time |
CD_LENGTH |
Length |
nnnnnn.nn |
Length |
Double |
CD_LSI |
Length Source Indicator |
30x |
Length Source Indicator |
Text |
CD_LTEXT |
Label Text |
30x |
Stores a string to label conduit on map |
Text |
CD_MANU_CD |
Manufacturer |
10x |
Manufacturer |
Text |
CD_MANU_TY |
Manufacturer Text |
60x |
Manufacturer Text |
Text |
CD_MAT_CD |
Material |
nnnn |
Material |
Integer |
CD_MAT_TY |
Material Text |
40x |
Material Text |
Text |
CD_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CD_MODEL |
Model |
30x |
Model |
Text |
CD_NADUCTS |
No of Available Ducts |
nnn |
Number of Available Ducts |
Integer |
CD_NDUCTS |
Number of Ducts |
nnn |
Number of Ducts |
Integer |
CD_NOWORK |
No WO/PM/Req |
|
Not to be used in Work Orders PMs or Requests |
Boolean |
CD_NUMBER |
Conduit Number |
30x |
Conduit Number |
Text |
CD_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
CD_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
CD_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
CD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CD_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
CD_SRCE_CD |
Length Source |
nnnn |
Length Source |
Integer |
CD_SRCE_TY |
Length Source Text |
25x |
Length Source Text |
Text |
CD_STAT_CD |
Status |
nnnn |
Status |
Integer |
CD_STAT_TY |
Status Text |
25x |
Status Text |
Text |
CD_STYPE_CD |
GIS SubType |
nnnn |
Sub-Type |
Integer |
CD_STYPE_TY |
GIS SubType Text |
40x |
Sub-Type Text |
Text |
CD_TRENCH |
Trench |
30x |
Trench |
Text |
CD_TYPE_CD |
Type |
nnnn |
Type |
Integer |
CD_TYPE_TY |
Type Text |
40x |
Type Text |
Text |
CD_UN1_ID |
From UG Struct Rec # |
nnnnnnnn |
Link to ELUNDG.UN_ID - From Structure |
Long Integer |
CD_UN2_ID |
To UG Struct Rec # |
nnnnnnnn |
Link to ELUNDG.UN_ID - To Structure |
Long Integer |
CD_USER10CD |
User 10 |
10x |
User 10 |
Text |
CD_USER10TY |
User 10 Text |
60x |
User 10 Text |
Text |
CD_USER11 |
User 11 |
30x |
User 11 |
Text |
CD_USER12 |
User 12 |
30x |
User 12 |
Text |
CD_USER13 |
User 13 |
30x |
User 13 |
Text |
CD_USER14 |
User 14 |
30x |
User 14 |
Text |
CD_USER15 |
User 15 |
30x |
User 15 |
Text |
CD_USER16 |
User 16 |
nnnnnnnnn.nn |
User 16 |
Double |
CD_USER17 |
User 17 |
nnnnnnnnn.nn |
User 17 |
Double |
CD_USER18 |
User 18 |
nnnnnnnnn.nn |
User 18 |
Double |
CD_USER19 |
User 19 |
nnnnnnnnn.nn |
User 19 |
Double |
CD_USER1CD |
User 1 |
nnnn |
User 1 |
Integer |
CD_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CD_USER20 |
User 20 |
nnnnnnnnn.nn |
User 20 |
Double |
CD_USER21 |
User 21 |
mm/dd/yyyy |
User 21 |
Date/Time |
CD_USER22 |
User 22 |
mm/dd/yyyy |
User 22 |
Date/Time |
CD_USER23 |
User 23 |
mm/dd/yyyy |
User 23 |
Date/Time |
CD_USER24 |
User 24 |
mm/dd/yyyy |
User 24 |
Date/Time |
CD_USER25 |
User 25 |
mm/dd/yyyy |
User 25 |
Date/Time |
CD_USER26 |
User 26 |
|
User 26 |
Boolean |
CD_USER27 |
User 27 |
|
User 27 |
Boolean |
CD_USER28 |
User 28 |
|
User 28 |
Boolean |
CD_USER29 |
User 29 |
|
User 29 |
Boolean |
CD_USER2CD |
User 2 |
nnnn |
User 2 |
Integer |
CD_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CD_USER30 |
User 30 |
|
User 30 |
Boolean |
CD_USER3CD |
User 3 |
nnnn |
User 3 |
Integer |
CD_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CD_USER4CD |
User 4 |
nnnn |
User 4 |
Integer |
CD_USER4TY |
User 4 Text |
25x |
User 4 Text |
Text |
CD_USER5CD |
User 5 |
nnnn |
User 5 |
Integer |
CD_USER5TY |
User 5 Text |
25x |
User 5 Text |
Text |
CD_USER6CD |
User 6 |
10x |
User 6 |
Text |
CD_USER6TY |
User 6 Text |
60x |
User 6 Text |
Text |
CD_USER7CD |
User 7 |
10x |
User 7 |
Text |
CD_USER7TY |
User 7 Text |
60x |
User 7 Text |
Text |
CD_USER8CD |
User 8 |
10x |
User 8 |
Text |
CD_USER8TY |
User 8 Text |
60x |
User 8 Text |
Text |
CD_USER9CD |
User 9 |
10x |
User 9 |
Text |
CD_USER9TY |
User 9 Text |
60x |
User 9 Text |
Text |
CD_WIDTH |
Width |
nnnnnn.nn |
Width |
Double |
CD_WO_COMM |
WO Comment |
250x |
WO Comment |
Text |
CD_X1 |
X Coordinate 1 |
-nnnnnnnnn.nnnnnnnn |
Beginning X Coordinate |
Double |
CD_X2 |
X Coordinate 2 |
-nnnnnnnnn.nnnnnnnn |
Ending X Coordinate |
Double |
CD_Y1 |
Y Coordinate 1 |
-nnnnnnnnn.nnnnnnnn |
Beginning Y Coordinate |
Double |
CD_Y2 |
Y Coordinate 2 |
-nnnnnnnnn.nnnnnnnn |
Ending Y Coordinate |
Double |
CD_Z1 |
Z Elevation 1 |
nnnnnnnnn.nn |
Beginning Z Elevation |
Double |
CD_Z2 |
Z Elevation 2 |
nnnnnnnnn.nn |
Ending Z Elevation |
Double |