Conduit Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
CN_ACTIVE |
Active |
|
Active |
Boolean |
CN_AVE_DEP |
Average Depth |
nn.nn |
Average Depth of the Conduit |
Double |
CN_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
CN_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
CN_BASIN |
Basin |
10x |
Flow Basin |
Text |
CN_BED_CD |
Bedding Type |
nnn |
Bedding Type Code |
Integer |
CN_BED_TY |
Bedding Type Text |
25x |
Bedding Type Text |
Text |
CN_BOTWIDTH |
Bottom Width |
nnnnnn.nn |
Bottom Width |
Double |
CN_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
CN_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
CN_CAPAC |
Capacity (cfs) |
nnnnnn.nn |
Capacity (cfs) |
Double |
CN_CF_DINV |
Adj DS Inv Elev |
nnnn.nn |
DS Invert Elevation Adjustment |
Double |
CN_CF_DRIM |
Adj DS Rim Elev |
nnnn.nn |
DS Rim Elevation Adjustment |
Double |
CN_CF_UINV |
Adj US Inv Elev |
nnnn.nn |
US Invert Elevation Adjustment |
Double |
CN_CF_URIM |
Adj US Rim Elev |
nnnn.nn |
US Rim Elevation Adjustment |
Double |
CN_CFREQ |
Cleaning Freq |
nnn |
Cleaning Freq |
Integer |
CN_CFRQ_CD |
Cleaning Freq Units |
nnn |
Cleaning Freq Units |
Integer |
CN_CFRQ_TY |
Cleaning Freq Units Tex |
10x |
Cleaning Freq Units Tex |
Text |
CN_CO_ID |
|
|
Link to SMCOMMENT |
Long Integer |
CN_COF |
Consequence of Failure |
nnnn. |
Consequence of Failure |
Double |
CN_COND |
General Condition |
nnnnnnnn.nn |
General Condition |
Double |
CN_CONTNAM |
Contractor Name |
25x |
Contractor's name who constructed conduit |
Text |
CN_CREW |
Collected By |
30x |
Person collecting the information |
Text |
CN_CRT_BY |
Created By |
25x |
Created By |
Text |
CN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CN_DEPTH |
Depth |
nnnnnn.nn |
Depth |
Double |
CN_DESGNBY |
Designed By |
30x |
Designer of the Conduit |
Text |
CN_DIA |
Dia/Height (in) |
nnnn |
Diameter/Height (in) |
Integer |
CN_DIST_CD |
District |
nnn |
District Code |
Integer |
CN_DIST_TY |
District Text |
25x |
District Text |
Text |
CN_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
CN_DOWNTOP |
Down Top |
nnnnnn.nn |
Down Top |
Double |
CN_DS_INV |
DS Invert |
nnnn.nn |
Active DS Invert |
Double |
CN_DS_RIM |
DS Rim |
nnnn.nn |
Active DS Rim |
Double |
CN_DS_STA |
DS Stationing |
nnnnnn.nn |
DS Station |
Double |
CN_DS_STR |
DS Structure |
30x |
DS Structure Number |
Text |
CN_DSELEV |
Downstream Elevation |
nnnnnn.nn |
Downstream Elevation |
Double |
CN_DSID |
DS Struc Rec # |
nnnnnnnn |
Long Integer |
|
CN_DSINVO |
Record DS Invert |
nnnn.nn |
Record DS Invert |
Double |
CN_DSNFLOW |
Design Flow |
nnnn.nn |
Design Flow |
Double |
CN_DSPADT |
DS Last PACP Date |
mm/dd/yyyy |
Downstream TV Date |
Date/Time |
CN_DSPROM |
DS Pipe O&&M |
nnn.n |
DS PACP Pipe Ratings O&M |
Double |
CN_DSPRS |
DS Pipe Structural |
nnn.n |
DS PACP Pipe Ratings Structural |
Double |
CN_DSPRT |
DS Pipe Total |
nnn.n |
DS PACP Pipe Ratings Total |
Double |
CN_DSQROM |
DS Quick O&&M |
30x |
DS PACP Quick Rating O&M |
Text |
CN_DSQRS |
DS Quick Structural |
30x |
DS PACP Quick Rating Structural |
Text |
CN_DSQRT |
DS Quick Total |
30x |
DS PACP Quick Rating Total |
Text |
CN_DSRIMO |
Record DS Rim |
nnnn.nn |
Record DS Rim |
Double |
CN_DT_CONS |
Constructed Date |
mm/dd/yyyy |
Date Constructed |
Date/Time |
CN_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
CN_FTYP_CD |
From End Type |
nnn |
From End Type |
Integer |
CN_FTYP_TY |
From End Type Text |
25x |
From End Type Text |
Text |
CN_HGL_DS |
HGL DS Invert |
nnnn.nn |
DS Hydraulic Grade Line Elevation |
Double |
CN_HGL_US |
HGL US Invert |
nnnn.nn |
US Hydraulic Grade Line Elevation |
Double |
CN_ID |
Conduit Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
CN_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
CN_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
CN_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
CN_IMG_FLG |
|
|
Image Available |
Boolean |
CN_INDEXNO |
Index No. |
20x |
Index Number |
Text |
CN_INMAP |
In Map? |
|
GIS Subtype Text |
Boolean |
CN_INSN_DT |
Next Inspection |
mm/dd/yyyy |
Next Inspection Date |
Date/Time |
CN_INSP_CD |
Last Condition |
nnn |
Last Condition |
Integer |
CN_INSP_DT |
Last Inspection |
mm/dd/yyyy |
Last Inspection Date |
Date/Time |
CN_INSP_TY |
Last Condition Text |
25x |
Last Condition Text |
Text |
CN_JNT_CD |
Joint Material |
nnn |
Joint Material Code |
Integer |
CN_JNT_LEN |
Pipe Sec Length (ft) |
nnnn |
Joint Length (ft) |
Integer |
CN_JNT_TY |
Joint Material Text |
25x |
Joint Material Text |
Text |
CN_LCLN_DT |
Last Cleaning Date |
mm/dd/yyyy |
Last Cleaning Date |
Date/Time |
CN_LEFTSLOPE |
Left Slope |
nnnnnn.nn |
Left Slope |
Double |
CN_LEN_CD |
Length Status |
nnn |
Length Status Code |
Integer |
CN_LEN_CD |
Length Status |
nnn |
Length Status Code |
Integer |
CN_LEN_TY |
Length Status Text |
25x |
Length Status Text |
Text |
CN_LEN_TY |
Length Status Text |
25x |
Length Status Text |
Text |
CN_LENGTH |
Length |
nnnn.n |
Length (ft) |
Double |
CN_LINR_CD |
Liner |
nnn |
Liner Code |
Integer |
CN_LINR_TY |
Liner Text |
40x |
Liner Text |
Text |
CN_LOC_CD |
Location |
nnn |
Location Code |
Integer |
CN_LOC_TY |
Location Text |
40x |
Location Text |
Text |
CN_LOCK |
Elevation Lock |
|
Elevation Lock |
Boolean |
CN_LTS_HOR |
Lt Side Slope - H |
nn.nn |
Left Side Slope Horizontal |
Double |
CN_LTS_VER |
Lt Side Slope |
nn.nn |
Left Side Slope Vertical |
Double |
CN_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
CN_MANG_CD |
Managed By |
nnn |
Managed By |
Integer |
CN_MANG_TY |
Managed By Text |
25x |
Managed By Text |
Text |
CN_MANNING |
Manning's "n" |
n.nnn |
Manning's n: Manning's number for figuring capacity |
Double |
CN_MATR_CD |
Material |
nnn |
Material Code |
Integer |
CN_MATR_TY |
Material Text |
40x |
Material Text |
Text |
CN_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
CN_MOD_BY |
Modified By |
25x |
Modified By |
Text |
CN_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
CN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CN_MOV_FLG |
|
|
Movie Available |
Boolean |
CN_MTPLCON |
Multiple Conduit |
|
Is there Multiple Conduits? |
Boolean |
CN_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
CN_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
CN_NCLN_DT |
Next Cleaning Date |
mm/dd/yyyy |
Next Cleaning Date |
Date/Time |
CN_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
CN_NUMBER |
Alt Conduit ID |
61x |
Alt Conduit ID |
Text |
CN_OCOND_CD |
Overall Cond |
nnn |
Overall Cond |
Integer |
CN_OCOND_TY |
Overall Cond Text |
25x |
Overall Cond Text |
String |
CN_OWN_CD |
Owner |
nnn |
Owner Code |
Integer |
CN_OWN_TY |
Owner Text |
25x |
Owner Text |
Text |
CN_PA_ID_I |
Entering Plant |
nnnnnnnn |
Entering Plant: Link to EFPLANT.PA_ID |
Long Integer |
CN_PA_ID_O |
Leaving Plant |
nnnnnnnn |
Leaving Plant: Link to EFPLANT.PA_ID |
Long Integer |
CN_PIFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
CN_PIFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
CN_PIFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
CN_PINSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
DateTime |
CN_PNINSP_DT |
Next Inspection Date |
mm/dd/yyyy |
Next Inspection Date |
DateTime |
CN_PNINSP_DT |
Next Inspection Date: |
mm/dd/yyyy |
Next Inspection Date: |
DateTime |
CN_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
CN_PROJ_NO |
Project Number |
20x |
Project Number |
Text |
CN_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
CN_RATCLN |
Cleaning Rating |
nnnn.nn |
Cleaning Rating |
Double |
CN_RATSTRC |
Structure Rating |
nnnn.nn |
Structure Rating |
Double |
CN_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
CN_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
CN_RIGHTSLOPE |
Right Slope |
nnnnnn.nn |
Right Slope |
Double |
CN_RISK |
Risk |
nnnn. |
Risk - COF * POF |
Double |
CN_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
CN_ROW_CD |
Maintenance Area |
nnn |
Maintenance Area Code |
Integer |
CN_ROW_TY |
Maint Area Text |
25x |
Maintenance Area Text |
Text |
CN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CN_RTS_HOR |
Rt Side Slope - H |
nn.nn |
Right Side Slope Horizontal |
Double |
CN_RTS_VER |
Rt Side Slope |
nn.nn |
Right Side Slope Vertical |
Double |
CN_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
CN_S_T_R |
Sec-Twn-Rng |
10x |
Section-Township-Range |
Text |
CN_SEWSTRC |
Con. to Sewer |
|
Is the US structure sanitary? |
Boolean |
CN_SHAP_CD |
Pipe Shape |
nnn |
Shape Code |
Integer |
CN_SHAP_TY |
Pipe Shape Text |
40x |
Shape Text |
Text |
CN_SIDEMAT_CD |
Side Material |
nnn |
Side Material |
Integer |
CN_SIDEMAT_TY |
Side Material Text |
50x |
Side Material Text |
Text |
CN_SLOPE |
Slope % |
nn.nnn |
Slope % |
Double |
CN_SLP_LCK |
Slope Lock |
|
Slope Lock |
Boolean |
CN_ST_DINV |
DS Invert Status |
1x |
DS Invert Status |
Text |
CN_ST_DRIM |
DS Rim Status |
1x |
DS Rim Status |
Text |
CN_ST_UINV |
US Invert Status |
1x |
US Invert Status |
Text |
CN_ST_URIM |
US Rim Status |
1x |
US Rim Status |
Text |
CN_STAT_CD |
Status |
nnn |
Status |
Integer |
CN_STAT_TY |
Status Text |
25x |
Status Text |
Text |
CN_STYPE_CD |
Subtype |
nnn |
Flag indicating this feature is in the map |
Integer |
CN_STYPE_TY |
Subtype Text |
25x |
GIS Subtype Code |
Text |
CN_SUBAREA |
Sub Area |
15x |
Sub Area |
Text |
CN_SURF_CD |
Surface |
nnn |
Surface Code |
Integer |
CN_SURF_TY |
Surface Text |
25x |
Surface Text |
Text |
CN_TOPWIDTH |
Top Width |
nnnnnn.nn |
Top Width |
Double |
CN_TOTCLEN |
Total Cleaning # |
nnnn.nn |
Total Cleaning Number |
Double |
CN_TOTSTRC |
Total Structural # |
nnnn.nn |
Total Structural Number |
Double |
CN_TTYP_CD |
To End Type |
nnn |
To End Type |
Integer |
CN_TTYP_TY |
To End Type Text |
25x |
To End Type Text |
Text |
CN_TVDR_CD |
TV Direction Code |
nnn |
TV Direction Code |
Integer |
CN_TVDR_TY |
TV Direction Code Text |
25x |
TV Direction Text |
Text |
CN_TYPE_CD |
Type |
nnn |
Conduit Type Code |
Integer |
CN_TYPE_TY |
Type Text |
25x |
Conduit Type Text |
Text |
CN_UPTOP |
Up Top |
nnnnnn.nn |
Up Top |
Double |
CN_US_INV |
US Invert |
nnnn.nn |
Active US Invert |
Double |
CN_US_RIM |
US Rim |
nnnn.nn |
Active US Rim |
Double |
CN_US_STA |
US Stationing |
nnnnnn.nn |
US Station |
Double |
CN_US_STR |
US Structure |
30x |
US Structure Number |
Text |
CN_USE_CD |
Land Use |
nnn |
Land Use Code |
Integer |
CN_USE_TY |
Land Use Text |
25x |
Land Use Text |
Text |
CN_USELEV |
Upstream Elevation |
nnnnnn.nn |
Upstream Elevation |
Double |
CN_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
CN_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CN_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
CN_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CN_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
CN_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CN_USER4 |
User 4 |
30x |
User 4 |
Text |
CN_USER5 |
User 5 |
30x |
User 5 |
Text |
CN_USER6 |
User 6 |
30x |
User 6 |
Text |
CN_USER7 |
User 7 |
nnnnnnnnn.nn |
User 7 |
Double |
CN_USER8 |
User 8 |
nnnnnnnnn.nn |
User 8 |
Double |
CN_USER9 |
User 9 |
nnnnnnnnn.nn |
User 9 |
Double |
CN_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
CN_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
CN_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
CN_USER13 |
User 13 |
|
User 13 |
Boolean |
CN_USER14 |
User 14 |
|
User 14 |
Boolean |
CN_USER15 |
User 15 |
|
User 15 |
Boolean |
CN_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
CN_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
CN_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
CN_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
CN_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
CN_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
CN_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
CN_USER19TY |
User 19 Text |
25x |
User 19 Text |
Text |
CN_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
CN_USER20TY |
User 20 Text |
25x |
User 20 Text |
Text |
CN_USER21 |
User 21 |
30x |
User 21 |
Text |
CN_USER22 |
User 22 |
30x |
User 22 |
Text |
CN_USER23 |
User 23 |
30x |
User 23 |
Text |
CN_USER24 |
User 24 |
30x |
User 24 |
Text |
CN_USER25 |
User 25 |
30x |
User 25 |
Text |
CN_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
CN_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
CN_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
CN_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
CN_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
CN_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
Date/Time |
CN_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
Date/Time |
CN_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
Date/Time |
CN_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
Date/Time |
CN_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
Date/Time |
CN_USER36 |
User 36 |
|
User 36 |
Boolean |
CN_USER37 |
User 37 |
|
User 37 |
Boolean |
CN_USER38 |
User 38 |
|
User 38 |
Boolean |
CN_USER39 |
User 39 |
|
User 39 |
Boolean |
CN_USER40 |
User 40 |
|
User 40 |
Boolean |
CN_USER41CD |
User 41 |
10x |
User 41 |
String |
CN_USER41TY |
User 41 Text |
60x |
User 41 Text |
String |
CN_USER42CD |
User 42 |
10x |
User 42 |
String |
CN_USER42TY |
User 42 Text |
60x |
User 42 Text |
String |
CN_USER43CD |
User 43 |
10x |
User 43 |
String |
CN_USER43TY |
User 43 Text |
60x |
User 43 Text |
String |
CN_USER44CD |
User 44 |
10x |
User 44 |
String |
CN_USER44TY |
User 44 Text |
60x |
User 44 Text |
String |
CN_USER45CD |
User 45 |
10x |
User 45 |
String |
CN_USER45TY |
User 45 Text |
60x |
User 45 Text |
String |
CN_USID |
US Struc Rec # |
nnnnnnnn |
Long Integer |
|
CN_USINVO |
Record US Invert |
nnnn.nn |
Record US Invert |
Double |
CN_USPADT |
US Last PACP Date |
mm/dd/yyyy |
Upstream TV Date |
Date/Time |
CN_USPROM |
US Pipe O&&M |
nnn.n |
US PACP Pipe Ratings O&M |
Double |
CN_USPRS |
US Pipe Structural |
nnn.n |
US PACP Pipe Ratings Structural |
Double |
CN_USPRT |
US Pipe Total |
nnn.n |
US PACP Pipe Ratings Total |
Double |
CN_USQROM |
US Quick O&&M |
30x |
US PACP Quick Rating O&M |
Text |
CN_USQRS |
US Quick Structural |
30x |
US PACP Quick Rating Structural |
Text |
CN_USQRT |
US Quick Total |
30x |
US PACP Quick Rating Total |
Text |
CN_USRIMO |
Record US Rim |
nnnn.nn |
Record US Rim |
Double |
CN_WIDTH |
Width (in) |
nnnn |
Width (in) |
Integer |
CN_WO_COMM |
WO Comment |
255x |
This short comment gets copied to work orders |
Text |
CN_X |
X Coordinate |
nnnnnnnn.nn |
X Coordinate |
Double |
CN_Y |
Y Coordinate |
nnnnnnnn.nn |
Y Coordinate |
Double |
CN_YEARLINED |
Year Lined |
4x |
Year Lined |
Text |