Storm BMP Site Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
BS_15ML_DT |
15 Month Letter |
mm/dd/yyyy |
15 Month Letter Date |
Date/Time |
BS_ABLT_DT |
As Built Date |
mm/dd/yyyy |
As Built Date |
Date/Time |
BS_ACTIVE |
Active Site |
|
Active Site |
Boolean |
BS_AREA |
Area |
nnnnnnn.n |
Area |
Double |
BS_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
BS_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
BS_BEXP_DT |
Bond Expiration Date |
mm/dd/yyyy |
Bond Expiration Date |
Date/Time |
BS_BPD_DT |
Bond Pull Date |
mm/dd/yyyy |
Bond Pull Date |
Date/Time |
BS_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
BS_BR_TY |
Default WO Cat Text |
60x |
Default Category Code |
Text |
BS_BREL_DT |
Bond Release Date |
mm/dd/yyyy |
Bond Release Date |
Date/Time |
BS_CAB_DT |
Check As Built Date |
mm/dd/yyyy |
Check As Built Date |
Date/Time |
BS_CADDR1 |
Contact Address |
50x |
Mailing Address |
Text |
BS_CADDR2 |
Contact Address 2 |
50x |
Contract Address 2 |
Text |
BS_CAT_CD |
Category |
nnn |
Category |
Integer |
BS_CAT_TY |
Category Text |
30x |
Category Text |
Text |
BS_CBUS |
Contact Business |
50x |
Business |
Text |
BS_CCITY |
Contact City |
30x |
City |
Text |
BS_CDIST |
Commercial District |
25x |
Commercial District |
Text |
BS_CEMAIL |
Contact Email |
150x |
Contact Email |
Text |
BS_CFAX |
Contact Fax Phone |
25x |
Contact Fax |
Text |
BS_CITY_CD |
City |
nnn |
City |
Integer |
BS_CITY_TY |
City Text |
30x |
City Text |
Text |
BS_CLET_CD |
Credit Letter |
nnn |
Credit Letter |
Integer |
BS_CLET_TY |
Credit Letter Text |
30x |
Credit Letter Text |
Text |
BS_CMOBILE |
Contact Cell Phone |
25x |
Contact Mobile/Cell Phone |
Text |
BS_CNOT_CD |
Notification |
nnn |
Notification |
Integer |
BS_CNOT_DT |
Notification Date |
mm/dd/yyyy |
Notification Date |
Date/Time |
BS_CNOT_TY |
Notification Text |
30x |
Notification Text |
Text |
BS_CNTY_CD |
County |
nnn |
County |
Integer |
BS_CNTY_TY |
County Text |
30x |
County Text |
Text |
BS_COMM_CD |
Communication |
nnn |
Desired Communication Process |
Integer |
BS_COMM_TY |
Communication Text |
30x |
Desired Communication Process Text |
Text |
BS_COND_CD |
Overall Condition Code from Inspection |
nnn |
Overall Condition Code from Inspection |
Integer |
BS_COND_TY |
Overall Condition Text from Inspection |
25x |
Overall Condition Text from Inspection |
String |
BS_CPCRED |
CP Credit |
nnnnnnn.nn |
CP Credit |
Double |
BS_CPHONE |
Contact Phone |
25x |
Contact Phone |
Text |
BS_CPOSTAL |
Contact Zip Code |
15x |
Zip Code |
Text |
BS_CRT_BY |
Created By |
25x |
Created By |
Text |
BS_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BS_CSTATE |
Contact State |
30x |
State |
Text |
BS_CSUR_DT |
Contact Surety Ext |
mm/dd/yyyy |
Contact Surety Extension Date |
Date/Time |
BS_CTYP_CD |
Contact Type |
nnn |
Contact Type |
Integer |
BS_CTYP_TY |
Contact Type Text |
30x |
Contact Type Text |
Text |
BS_DAREA |
Drainage Area |
nnnnnnn.n |
Drainage Area |
Double |
BS_DBOOK |
Deed Book |
25x |
Deed Book |
Text |
BS_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
BS_EASE_DT |
Easement Date |
mm/dd/yyyy |
Easement Date |
Date/Time |
BS_EBOOK |
Easement Book |
25x |
Easement Book |
Text |
BS_EPAGE |
Easement Page |
25x |
Easement Page |
Text |
BS_FINS_DT |
Final Inspection |
mm/dd/yyyy |
Final Inspection |
Date/Time |
BS_FIRST |
Contact Name |
30x |
First Name |
Text |
BS_FMON |
Flow Monitoring |
|
Flow Monitoring |
Boolean |
BS_FPLAT_DT |
Final Plat Date |
mm/dd/yyyy |
Final Plat Date |
Date/Time |
BS_HPERMIT |
Historic Permit |
25x |
Historic Permit |
Text |
BS_ID |
Site Record No |
nnnnnnnn |
BMP Site Record # |
Long Integer |
BS_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
BS_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
BS_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
BS_INMAP |
In Map? |
|
Flag indicating this feature is in the map |
Boolean |
BS_INSP_DT |
Last Inspected Date |
mm/dd/yyyy |
Last Inspected Date |
DateTime |
BS_LAST |
Contact Last Name |
30x |
Last Name |
Text |
BS_LOCATE |
General Location |
100x |
General Location |
Text |
BS_LUSE_CD |
Land Use |
nnn |
Land Use |
Integer |
BS_LUSE_TY |
Land Use Text |
30x |
Land Use Text |
Text |
BS_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
BS_MAGR_DT |
Maintenance Agreement |
mm/dd/yyyy |
Maintenace Agreement Date |
Date/Time |
BS_MAR_DT |
Maint Agreement Recv'd |
mm/dd/yyyy |
Maint Agreement Received Date |
Date/Time |
BS_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
BS_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
BS_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BS_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
BS_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
BS_NAM_MI |
Contact Middle Initial |
1x |
Middle Initial |
Text |
BS_NAM_SAL |
Contact Salutation |
6x |
Salutation Text |
Text |
BS_NAM_SFX |
Contact Suffix |
5x |
Suffix |
Text |
BS_NAME |
Site Name |
50x |
Site Name |
Text |
BS_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy |
Next Inspection Date |
DateTime |
BS_NONUM |
Without Number |
25x |
Without Number |
Text |
BS_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
BS_NUMBER |
Site Number |
30x |
Site Number |
Text |
BS_OADDR1 |
Owner Address 1 |
50x |
Owner Address 1 |
Text |
BS_OADDR2 |
Owner Address 2 |
50x |
Owner Address 2 |
Text |
BS_OADDR3 |
Owner Address 3 |
50x |
Owner Address 3 |
Text |
BS_OBUS |
Owner Business |
50x |
Owner Business |
Text |
BS_OEMAIL |
Owner Email |
150x |
Owner Email |
Text |
BS_OMR |
Orig Maint Resp |
50x |
Orig Maint Resp |
Text |
BS_ONAME |
Owner Name |
50x |
Owner Name |
Text |
BS_ONSITE |
On-Site Contact |
|
On-Site Contact |
Boolean |
BS_OPHONE1 |
Owner Phone 1 |
25x |
Owner Phone 1 |
Text |
BS_OPHONE2 |
Owner Phone 2 |
25x |
Owner Phone 2 |
Text |
BS_OPHONE3 |
Owner Phone 3 |
25x |
Owner Phone 3 |
Text |
BS_OPHONE4 |
Owner Phone 4 |
25x |
Owner Phone 4 |
Text |
BS_OSCEMAIL |
Onsite Contact Email |
150x |
Onsite Contact Email |
String |
BS_OWNR_CD |
Owner |
nnn |
Owner |
Integer |
BS_OWNR_TY |
Owner Text |
30x |
Owner Text |
Text |
BS_PAGE |
Page |
25x |
Page |
Text |
BS_PAPP_DT |
Permit Approval |
mm/dd/yyyy |
Permit Approval Date |
Date/Time |
BS_PARCEL |
Parcel |
25x |
Parcel |
Text |
BS_PCIC_DT |
Post-Cons Install Cert |
mm/dd/yyyy |
Post Construction Installation Certification Date |
Date/Time |
BS_PCTCMPL |
Percent Complete |
nnnn.nn |
Percent Complete |
Double |
BS_PERMIT |
Permitted |
|
Permitted |
Boolean |
BS_PERMITN |
Permit Number |
30x |
Permit Number |
Text |
BS_PEXP_DT |
Permit Expiration |
mm/dd/yyyy |
Permit Expiration Date |
Date/Time |
BS_PFCRED |
PF Credit |
nnnnnnn.nn |
PF Credit |
Double |
BS_POSTAL |
Zip Code |
15x |
Zip Code |
Text |
BS_PRE |
Plan Review Engineer |
50x |
Plan Review Engineer |
Text |
BS_PROJ_CD |
Projects |
nnn |
Projects |
Integer |
BS_PROJ_TY |
Projects Text |
30x |
Projects Text |
Text |
BS_PRVW_DT |
Plan Review Date |
mm/dd/yyyy |
Plan Review Date |
Date/Time |
BS_REC_DT |
File Received Date |
mm/dd/yyyy |
File Received Date |
Date/Time |
BS_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BS_RSTR_CD |
Receiving Stream |
10x |
Receiving Stream |
Text |
BS_RSTR_TY |
Receiving Stream Text |
60x |
Receiving Stream Text |
Text |
BS_SAGR_DT |
Sup Agreement |
mm/dd/yyyy |
Sup Agreement Date |
Date/Time |
BS_SDIV_CD |
Subdivision |
10x |
Subdivision |
Text |
BS_SDIV_TY |
Subdivision Text |
60x |
Subdivision Text |
Text |
BS_SRNUM |
SR Number |
25x |
SR Number |
Text |
BS_ST_ID |
Facility Site Record No. |
nnnnnnnn |
Long Integer |
|
BS_STAT_CD |
Status |
nnn |
Status |
Integer |
BS_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
BS_STAT_TY |
Status Text |
30x |
Status Text |
Text |
BS_STYPE_CD |
Subtype |
nnn |
GIS Subtype Code |
Integer |
BS_STYPE_TY |
Subtype Text |
25x |
GIS Subtype Text |
Text |
BS_TIER_CD |
Tier |
nnn |
Tier |
Integer |
BS_TIER_TY |
Tier Text |
30x |
Tier Text |
Text |
BS_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
BS_USER1TY |
User 1 Text |
30x |
User 1 Text |
Text |
BS_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
BS_USER2TY |
User 2 Text |
30x |
User 2 Text |
Text |
BS_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
BS_USER3TY |
User 3 Text |
30x |
User 3 Text |
Text |
BS_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
BS_USER4TY |
User 4 Text |
30x |
User 4 Text |
Text |
BS_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
BS_USER5TY |
User 5 Text |
30x |
User 5 Text |
Text |
BS_USER6 |
User 6 |
30x |
User 6 |
Text |
BS_USER7 |
User 7 |
30x |
User 7 |
Text |
BS_USER8 |
User 8 |
30x |
User 8 |
Text |
BS_USER9 |
User 9 |
30x |
User 9 |
Text |
BS_USER10 |
User 10 |
30x |
User 10 |
Text |
BS_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
BS_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
BS_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
BS_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
BS_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
BS_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
BS_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
BS_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
BS_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
BS_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
BS_USER21 |
User 21 |
|
User 21 |
Boolean |
BS_USER22 |
User 22 |
|
User 22 |
Boolean |
BS_USER23 |
User 23 |
|
User 23 |
Boolean |
BS_USER24 |
User 24 |
|
User 24 |
Boolean |
BS_USER25 |
User 25 |
|
User 25 |
Boolean |
BS_USER26CD |
User 26 |
10x |
User 26 |
String |
BS_USER26TY |
User 26 Text |
60x |
User 26 Text |
String |
BS_USER27CD |
User 27 |
10x |
User 27 |
String |
BS_USER27TY |
User 27 Text |
60x |
User 27 Text |
String |
BS_USER28CD |
User 28 |
10x |
User 28 |
String |
BS_USER28TY |
User 28 Text |
60x |
User 28 Text |
String |
BS_USER29CD |
User 29 |
10x |
User 29 |
String |
BS_USER29TY |
User 29 Text |
60x |
User 29 Text |
String |
BS_USER30CD |
User 30 |
10x |
User 30 |
String |
BS_USER30TY |
User 30 Text |
60x |
User 30 Text |
String |
BS_WQCRED |
WQ Credit |
nnnnnnn.nn |
WQ Credit |
Double |
BS_WQM |
Water Quality Monitoring |
|
Water Quality Monitoring |
Boolean |
BS_WSHED |
Watershed |
30x |
Watershed |
Text |
BS_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
BS_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |
BS_Z |
Elevation |
nnnnnnnnn.nn |
Elevation |
Double |