Service Lateral TV inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
SS_ADDID |
Address Rec # |
|
Long Integer |
|
SS_ANG_INV |
Angled Rim/Inv (ft) |
nnn.nn |
Angled Rim/Inv Measurement |
Double |
SS_CLN_CD |
Cleaning |
nnn |
Cleaning Code |
Integer |
SS_CLN_RTG |
Total Clean Rating |
nnnnn.n |
Total Cleaning Rating |
Double |
SS_CLN_TY |
Cleaning Text |
25x |
Cleaning Text |
Text |
SS_COMMENT |
Comments |
|
Comments |
Long Integer |
SS_COMMENT1 |
Long Note |
|
Long Note |
Memo |
SS_CONDCD |
Struct Condition |
nnn |
Structure Condition Code |
Integer |
SS_CONDTY |
Structure Cond Text |
25x |
Structure Condition Text |
Text |
SS_CREW |
Inspection Crew |
30x |
Inspection Crew |
Text |
SS_CROWN |
Rim to Crown (ft) |
nnn.nn |
Rim to Crown Measurement |
Double |
SS_CRT_BY |
Created By |
25x |
Created By |
Text |
SS_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SS_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
SS_DPO_CD |
Deposition |
nnn |
Deposition Code |
Integer |
SS_DPO_DEP |
Depos Depth (in) |
nnn.nn |
Deposition Depth |
Double |
SS_DPO_TY |
Deposition Text |
25x |
Deposition Text |
Text |
SS_DT_INSP |
Inspection Date |
mm/dd/yyyy |
Date Inspected |
Date/Time |
SS_FLO_DEP |
Flow Depth (in) |
nnn.nn |
Flow Depth |
Double |
SS_FLO_VEL |
Flow Velocity (fps) |
nn.nn |
Flow Velocity |
Double |
SS_GPM_REM |
Remaining GPM |
nnn.nnn |
Remaining GPM |
Double |
SS_ID |
Service Insp Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
SS_IMG_FLG |
|
|
Images Available |
Boolean |
SS_INBY_CD |
Inspected By |
5x |
Inspected By |
Text |
SS_INBY_TY |
Inspected By Text |
30x |
Inspected By Text |
Text |
SS_INDR_CD |
Inspect Direction |
nnn |
Inspection Direction Code |
Integer |
SS_INDR_TY |
Inspec. Dir. Text |
25x |
Inspection Direction Text |
Text |
SS_INF_RTG |
Total Flow Rating |
nnn.nnn |
Total Infiltration Rating |
Double |
SS_INMAP |
|
|
Not Used |
Boolean |
SS_INSP_CD |
Inspection Type |
nnn |
Inspection Type Code |
Integer |
SS_INSP_TM |
Time Televised |
hh:mm am |
Time Televised: |
Date/Time |
SS_INSP_TY |
Inspection Type Text |
25x |
Inspection Type Text |
Text |
SS_INVERT |
Rim to Inv (ft) |
nnn.nn |
True Rim to Invert Measurement |
Double |
SS_LATEST |
Most Recent Inspect |
|
Most Recent Inspection |
Boolean |
SS_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
SS_MAX_FT |
Max Obs Len (ft) |
nnnn.n |
Maximum Observation Length (ft) |
Double |
SS_MAX_OBS |
Max Obs # |
nnn |
Maximum Observation # |
Integer |
SS_MNTP_CD |
Maintance Prior |
nnn |
Maintenance Prior to Inspection Code |
Integer |
SS_MNTP_TY |
Maint. Prior Text |
25x |
Maintenance Prior to Inspection Text |
Text |
SS_MOD_BY |
Modified By |
25x |
Modified By |
Text |
SS_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
SS_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
SS_MOV_FLG |
|
|
Movies Available |
Boolean |
SS_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
SS_OFFSET |
Angled Offset (in) |
nnnn.n |
Angled Offset |
Double |
SS_REQNUMB |
Request # |
25x |
Request # |
String |
SS_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
SS_RQ_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
SS_SERVID |
Service Rec # |
nnnnnnnn |
Long Integer |
|
SS_STR_RTG |
Total Struc Rating |
nnnnn.n |
Total Structure Rating |
Double |
SS_STRCDEP |
Struct Depth (ft) |
nnn.n |
Structure Depth |
Double |
SS_SVDR_CD |
Service Direction |
nnn |
Service Direction Code |
Integer |
SS_SVDR_TY |
Service Dir. Text |
25x |
Service Direction Text |
Text |
SS_TOT_CLN |
Total Cleaning |
nnnn |
Total Cleaning |
Integer |
SS_TOT_INF |
Total Infiltration |
nnnn.nnn |
Total Infiltration |
Double |
SS_TOT_STR |
Total Structure |
nnnn |
Total Structure |
Integer |
SS_USER1CD |
User 1 |
nnn |
User 1 Code |
Integer |
SS_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
SS_USER2CD |
User 2 |
nnn |
User 2 Code |
Integer |
SS_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
SS_USER3CD |
User 3 |
nnn |
User 3 Code |
Integer |
SS_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
SS_USER4 |
User 4 |
30x |
User 4 |
Text |
SS_USER5 |
User 5 |
30x |
User 5 |
Text |
SS_USER6 |
User 6 |
30x |
User 6 |
Text |
SS_USER7 |
User 7 |
nnnnnnnnn.nn |
User 7 |
Double |
SS_USER8 |
User 8 |
nnnnnnnnn.nn |
User 8 |
Double |
SS_USER9 |
User 9 |
nnnnnnnnn.nn |
User 9 |
Double |
SS_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
SS_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
SS_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
SS_USER13 |
User 13 |
|
User 13 |
Boolean |
SS_USER14 |
User 14 |
|
User 14 |
Boolean |
SS_USER15 |
User 15 |
|
User 15 |
Boolean |
SS_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
SS_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
SS_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
SS_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
SS_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
SS_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
SS_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
SS_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
SS_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
SS_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
SS_USER21 |
User 21 |
50x |
User 21 |
String |
SS_USER22 |
User 22 |
50x |
User 22 |
String |
SS_USER23 |
User 23 |
50x |
User 23 |
String |
SS_USER24 |
User 24 |
50x |
User 24 |
String |
SS_USER25 |
User 25 |
50x |
User 25 |
String |
SS_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
SS_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
SS_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
SS_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
SS_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
SS_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
SS_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
SS_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
SS_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
SS_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
SS_USER36 |
User 36 |
|
User 36 |
Boolean |
SS_USER37 |
User 37 |
|
User 37 |
Boolean |
SS_USER38 |
User 38 |
|
User 38 |
Boolean |
SS_USER39 |
User 39 |
|
User 39 |
Boolean |
SS_USER40 |
User 40 |
|
User 40 |
Boolean |
SS_WINS_CD |
Work Employee |
20x |
Work Employee |
String |
SS_WINS_TY |
Work Employee Text |
40x |
Work Employee Text |
String |
SS_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
SS_WONUMB |
Work Order # |
25x |
Work Order # |
String |