Building Exterior Sources (Observations)
Field Name |
Caption |
Mask |
Description |
Field Type |
BO_BLDGID |
Building Rec # |
|
Long Integer |
|
BO_COMMENT1 |
Long Note |
|
Long Note |
Memo |
BO_CRT_BY |
Created By |
25x |
Created By |
Text |
BO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BO_DIR_CD |
Turn Direction |
nnn |
Turn Direction Code |
Integer |
BO_DIR_TY |
Turn Direction Text |
25x |
Turn Direction Text |
Text |
BO_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
BO_DY_CREW |
Dye Test Crew |
30x |
Dye Test Crew |
Text |
BO_DY_DATE |
Dye Test Date |
mm/dd/yyyy |
Dye Test Date |
Date/Time |
BO_DYEND |
|
|
Dye End Time |
Date/Time |
BO_DYETST_TM |
Dye Test Time |
mm/dd/yyyy hh:mm am |
Dye Test Time |
DateTime |
BO_DYPICT |
Dye Test Pict # (s) |
8x |
Dye Test Pict # (s) |
Text |
BO_DYRESCD |
Dye Test Results |
nnn |
Dye Test Results Code |
Integer |
BO_DYRESTY |
Dye Test Res Text |
25x |
Dye Test Res Text |
Text |
BO_DYROLL |
Dye Test Roll # |
5x |
Dye Test Roll # |
Text |
BO_DYSTART |
|
|
Dye Start Time |
Date/Time |
BO_END_TM |
Dye End Time |
hh:mm am |
Dye End Time |
Date/Time |
BO_FLO_LCK |
Flow Rate Lock |
|
Flow Rate Lock |
Boolean |
BO_FRM_CD |
Measured From |
nnn |
Distance Measured From Code |
Integer |
BO_FRM_TY |
Measured From Type |
25x |
Distance Measured From Text |
Text |
BO_FT1 |
Length (ft) |
nnnn.n |
Drainage area Length (ft) |
Double |
BO_FT2 |
Width (ft) |
nnnn.n |
Drainage area Width (ft) |
Double |
BO_GPM |
Flow Rate (gpm) |
nnn.nn |
Flow Rate (gpm) |
Double |
BO_GPM_REM |
Remaining GPM |
nnnn.nn |
Remaining GPM |
Double |
BO_IMG_FLG |
|
|
Image Available |
Boolean |
BO_MNDIST |
Distance |
nnnn.n |
Distance from Upstream Manhole |
Double |
BO_MOD_BY |
Modified By |
25x |
Modified By |
Text |
BO_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
BO_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BO_MOV_FLG |
|
|
Movie Available |
Boolean |
BO_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
BO_OBS_ID |
Bldg Obs Rec # |
|
Unique ID |
Long Integer |
BO_OBS_NO |
Observation # |
nnn |
Observation # |
Integer |
BO_OFFDIST |
Turn Distance |
nnnn.n |
Perpendicular Distance from Main Line |
Double |
BO_PER_REM |
% I/I Removed |
nnn |
% I/I Removed |
Integer |
BO_PICT |
Pict # (s) |
8x |
Picture # (s) |
Text |
BO_ROLL |
Roll # |
5x |
Roll # (s) |
Text |
BO_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BO_RUNOFF |
Runoff Factor |
nn |
Runoff Factor |
Integer |
BO_SRCE_CD |
Source |
nnn |
Source Code |
Integer |
BO_SRCE_TY |
Source Text |
25x |
Source Text |
Text |
BO_STAT_CD |
Results |
nnn |
Results Code |
Integer |
BO_STAT_TY |
Results Text |
25x |
Results Text |
Text |
BO_STRT_TM |
Dye Start Time |
hh:mm am |
Dye Start Time |
Date/Time |
BO_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
BO_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
BO_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
BO_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
BO_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
BO_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
BO_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
BO_USER5 |
User 5 |
30x |
User 5 |
Text |
BO_USER6 |
User 6 |
|
User 6 |
Boolean |
BO_USER7 |
User 7 |
|
User 7 |
Boolean |
BO_USER8 |
User 8 |
|
User 8 |
Boolean |
BO_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
BO_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
BO_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
BO_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
BO_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
BO_USER14 |
User 14 |
30x |
User 14 |
Text |
BO_USER15 |
User 15 |
30x |
User 15 |
Text |
BO_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
BO_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
BO_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
BO_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
BO_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
BO_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
BO_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
BO_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
BO_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
BO_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
BO_USER21 |
User 21 |
50x |
User 21 |
String |
BO_USER22 |
User 22 |
50x |
User 22 |
String |
BO_USER23 |
User 23 |
50x |
User 23 |
String |
BO_USER24 |
User 24 |
50x |
User 24 |
String |
BO_USER25 |
User 25 |
50x |
User 25 |
String |
BO_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
BO_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
BO_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
BO_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
BO_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
BO_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
BO_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
BO_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
BO_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
BO_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
BO_USER36 |
User 36 |
|
User 36 |
Boolean |
BO_USER37 |
User 37 |
|
User 37 |
Boolean |
BO_USER38 |
User 38 |
|
User 38 |
Boolean |
BO_USER39 |
User 39 |
|
User 39 |
Boolean |
BO_USER40 |
User 40 |
|
User 40 |
Boolean |
BO_WINS_CD |
Work Employee |
20x |
Work Employee |
String |
BO_WINS_TY |
Work Employee Text |
40x |
Work Employee Text |
String |
BO_WO_ID |
WO Rec # |
nnnnnnnn |
Long Integer |
|
BO_WONUMB |
Work Order # |
25x |
Work Order # |
String |
BO_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
Observation X Coordinate |
Double |
BO_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Observation Y Coordinate |
Double |
Related Tables
Tables this table links to
Target Table |
Target Field |
Linking Field |
Purpose |
BD_BLDGID |
BO_BLDGID |
Links the observation to the building inspection. |