Conduit Inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
CI_ANG_INV |
Ang Rim/Inv (ft) |
nn.nn |
Angled Rim to Invert |
Double |
CI_CLN_CD |
Cleaning |
nnn |
Recommended Cleaning Code |
Integer |
CI_CLN_TY |
Cleaning Text |
25x |
Recommended Cleaning Text |
Text |
CI_CN_ID |
Conduit Rec # |
|
Long Integer |
|
CI_CO_ID |
|
|
Link to SMCOMMENT |
Long Integer |
CI_COND_CD |
Overall Condition |
nnn |
Overall Condition |
Integer |
CI_COND_TY |
Overall Condition Text |
25x |
Overall Condition Text |
Text |
CI_CONTSP |
Counter Stop |
15x |
Counter Stop |
Text |
CI_CONTST |
Counter Start |
15x |
Counter Start |
Text |
CI_CREW |
Inspection By |
30x |
Inspected By |
Text |
CI_CROWN |
Rim To Crown (ft) |
nn.nn |
Rim to Crown |
Double |
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_DEB_CD |
Debris Type |
nnn |
Debris Type Code |
Integer |
CI_DEB_DEP |
Debris Depth (in) |
nn.nn |
Debris Depth |
Double |
CI_DEB_TY |
Debris Type Text |
25x |
Debris Type Text |
Text |
CI_DIR_CD |
Conduit Dir |
nnn |
Conduit Direction Code |
Integer |
CI_DIR_TY |
Conduit Dir Text |
25x |
Conduit Direction Type |
Text |
CI_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
CI_DT_INSP |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
CI_FLO_DEP |
Flow Depth (in) |
nnn.nn |
Flow Depth |
Double |
CI_FLO_VEL |
Flow Velocity (fps) |
nn.nn |
Flow Velocity |
Double |
CI_ID |
Cond Insp Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
CI_IMG_FLG |
|
|
Image Available |
Boolean |
CI_INBY_CD |
Inspected By |
5x |
Inspected By |
Text |
CI_INBY_TY |
Inspected By Text |
50x |
Inspected By Text |
Text |
CI_INMAP |
|
|
Not Used |
Boolean |
CI_INST_CD |
Inspected Struct |
nnn |
Inspected Structure Code |
Integer |
CI_INST_TY |
Inspected Struc Text |
25x |
Inspected Structure Text |
Text |
CI_INTY_CD |
Inspection Type |
nnn |
Inspection Type Code |
Integer |
CI_INTY_TY |
Inspection Type Text |
25x |
Inspection Type Text |
Text |
CI_INVERT |
Rim To Invert (ft) |
nn.nn |
Rim to Invert |
Double |
CI_LATEST |
Most Recent Inspection |
|
Most Recent Inspection? |
Boolean |
CI_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
CI_MATPRCD |
Maint. Prior |
nnn |
Maintenance Prior Code |
Integer |
CI_MATPRTY |
Maint. Prior Type |
25x |
Maintenance Prior Text |
Text |
CI_MOD_BY |
Modified By |
25x |
Modified By |
Text |
CI_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
CI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CI_MOV_FLG |
|
|
Movie Available |
Boolean |
CI_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
CI_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy |
Next Inspection Date |
Date/Time |
CI_OFFSET |
Angled Offset (in) |
nnn.nn |
Angled Offset |
Double |
CI_PCNTFUL |
Percent Full |
nnn |
Percent Full |
Integer |
CI_PURP_CD |
Purpose |
nnn |
Purpose Code |
Integer |
CI_PURP_TY |
Purpose Type |
25x |
Purpose Text |
Text |
CI_RATCLN |
Cleaning Rating |
nnnn.nn |
Cleaning Rating (Field currently not used) |
Double |
CI_RATSTRC |
Structure Rating |
nnnn.nn |
Structure Rating (Field currently not used) |
Double |
CI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CI_RQ_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
CI_STRCFRM |
Struc Insp. From |
20x |
Structure Inspected From |
Text |
CI_TAPID |
Tape ID |
15x |
Tape ID or number |
Text |
CI_TM_INSP |
Inspection Time |
hh:mm am |
Time of Inspection |
Date/Time |
CI_TOTCLEN |
Total Cleaning # |
nnnn.nn |
Total Cleaning Number (Field currently not used) |
Double |
CI_TOTSTRC |
Total Structural # |
nnnn.nn |
Total Structural Number (Field currently not used) |
Double |
CI_TV_CD |
TV |
nnn |
TV Recommendation Code |
Integer |
CI_TV_TY |
TV Text |
25x |
TV Recommendation Text |
Text |
CI_TVDR_CD |
Inspec Dir |
nnn |
TV Direction Code |
Integer |
CI_TVDR_TY |
Inspec Dir Type |
25x |
TV Direction Text |
Text |
CI_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
CI_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CI_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
CI_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CI_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
CI_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CI_USER4 |
User 4 |
30x |
User 4 |
Text |
CI_USER5 |
User 5 |
30x |
User 5 |
Text |
CI_USER6 |
User 6 |
30x |
User 6 |
Text |
CI_USER7 |
User 7 |
nnnnnnnnn.nn |
User 7 |
Double |
CI_USER8 |
User 8 |
nnnnnnnnn.nn |
User 8 |
Double |
CI_USER9 |
User 9 |
nnnnnnnnn.nn |
User 9 |
Double |
CI_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
CI_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
CI_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
CI_USER13 |
User 13 |
|
User 13 |
Boolean |
CI_USER14 |
User 14 |
|
User 14 |
Boolean |
CI_USER15 |
User 15 |
|
User 15 |
Boolean |
CI_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
CI_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
CI_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
CI_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
CI_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
CI_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
CI_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
CI_USER19TY |
User 19 Text |
25x |
User 19 Text |
Text |
CI_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
CI_USER20TY |
User 20 Text |
25x |
User 20 Text |
Text |
CI_USER21 |
User 21 |
30x |
User 21 |
Text |
CI_USER22 |
User 22 |
30x |
User 22 |
Text |
CI_USER23 |
User 23 |
30x |
User 23 |
Text |
CI_USER24 |
User 24 |
30x |
User 24 |
Text |
CI_USER25 |
User 25 |
30x |
User 25 |
Text |
CI_USER26 |
User 26 |
nnnnnnnnn.nn |
User 26 |
Double |
CI_USER27 |
User 27 |
nnnnnnnnn.nn |
User 27 |
Double |
CI_USER28 |
User 28 |
nnnnnnnnn.nn |
User 28 |
Double |
CI_USER29 |
User 29 |
nnnnnnnnn.nn |
User 29 |
Double |
CI_USER30 |
User 30 |
nnnnnnnnn.nn |
User 30 |
Double |
CI_USER31 |
User 31 |
|
User 31 |
Boolean |
CI_USER32 |
User 32 |
|
User 32 |
Boolean |
CI_USER33 |
User 33 |
|
User 33 |
Boolean |
CI_USER34 |
User 34 |
|
User 34 |
Boolean |
CI_USER35 |
User 35 |
|
User 35 |
Boolean |
CI_USER36 |
User 36 |
|
User 36 |
Boolean |
CI_USER37 |
User 37 |
|
User 37 |
Boolean |
CI_USER38 |
User 38 |
|
User 38 |
Boolean |
CI_USER39 |
User 39 |
|
User 39 |
Boolean |
CI_USER40 |
User 40 |
|
User 40 |
Boolean |
CI_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
CI_WTHR_CD |
Weather |
nnn |
Weather Code |
Integer |
CI_WTHR_TY |
Weather Type |
25x |
Weather Text |
Text |