BMP Geological Survey
Field Name |
Caption |
Mask |
Description |
Field Type |
GS_BA_ID |
BMP Asset Rec # |
nnnnnnnn |
Long Integer |
|
GS_BORE_DT |
Boring Date |
mm/dd/yyyy |
Boring Date |
Date/Time |
GS_BORE_TM |
Boring Time |
hh:mm am |
Boring Time |
Date/Time |
GS_BORECST |
Boring Cost |
nnnnnnnn.nn |
Boring Cost |
Double |
GS_BS_ID |
BMP Site Rec # |
nnnnnnnn |
Long Integer |
|
GS_CONT_CD |
Contractor |
10x |
Contractor |
Text |
GS_CONT_TY |
Contractor Text |
60x |
Contractor Text |
Text |
GS_CRT_BY |
Created By |
25x |
Created By |
Text |
GS_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
GS_DOC_FLG |
Document Available |
|
Document Flag: |
Boolean |
GS_FPC |
5' Perm Coeff |
nnnnnn.nn |
5' Perm Coeff |
Double |
GS_ID |
Geological Survey Rec # |
nnnnnnnn |
Geological Survey Rec # |
Long Integer |
GS_LATEST |
Most Recent Inspection |
|
Most Recent Inspection |
Boolean |
GS_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
GS_MOD_BY |
Last Mod By |
25x |
Last Modified By: |
Text |
GS_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date: |
Date/Time |
GS_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
GS_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
GS_PERM_DT |
Permeability Date |
mm/dd/yyyy |
Permeability Test Date |
Date/Time |
GS_PERM_TM |
Permeability Time |
hh:mm am |
Permeability Test Time |
Date/Time |
GS_PERMCST |
Permeability Cost |
nnnnnnnn.nn |
Permeability Cost |
Double |
GS_PURP_CD |
Purpose |
nnn |
Purpose |
Integer |
GS_PURP_TY |
Purpose Text |
25x |
Purpose Text |
Text |
GS_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
GS_RQ_ID |
Req Rec# |
nnnnnnnn |
Long Integer |
|
GS_SAMPLNO |
Sampling Number |
15x |
Sampling Number |
Text |
GS_TPC |
10' Perm Coeff |
nnnnnn.nn |
10' Perm Coeff |
Double |
GS_USER10 |
User 10 |
30x |
User 10 |
Text |
GS_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
GS_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
GS_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
GS_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
GS_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
GS_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
GS_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
GS_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
GS_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
GS_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
GS_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
GS_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
GS_USER21 |
User 21 |
|
User 21 |
Boolean |
GS_USER22 |
User 22 |
|
User 22 |
Boolean |
GS_USER23 |
User 23 |
|
User 23 |
Boolean |
GS_USER24 |
User 24 |
|
User 24 |
Boolean |
GS_USER25 |
User 25 |
|
User 25 |
Boolean |
GS_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
GS_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
GS_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
GS_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
GS_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
GS_USER4TY |
User 4 Text |
25x |
User 4 Text |
Text |
GS_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
GS_USER5TY |
User 5 Text |
25x |
User 5 Text |
Text |
GS_USER6 |
User 6 |
30x |
User 6 |
Text |
GS_USER7 |
User 7 |
30x |
User 7 |
Text |
GS_USER8 |
User 8 |
30x |
User 8 |
Text |
GS_USER9 |
User 9 |
30x |
User 9 |
Text |
GS_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |