Storm BMP Asset Violation Corrective Actions
Field Name |
Caption |
Mask |
Description |
Field Type |
BZ_AI_ID |
Asset Inspection Rec # |
nnnnnnnn |
Long Integer |
|
BZ_BA_ID |
Asset Rec # |
nnnnnnnn |
Long Integer |
|
BZ_BS_ID |
Site Rec # |
nnnnnnnn |
Long Integer |
|
BZ_BV_ID |
Notice Rec # |
nnnnnnnn |
Long Integer |
|
BZ_CACTION |
Corrective Action |
20x |
Corrective Action |
Text |
BZ_COMP |
Completed |
|
Completed |
Boolean |
BZ_COMP_DT |
Completed Date |
mm/dd/yyyy |
Completed Date |
Date/Time |
BZ_CRT_BY |
Created By |
25x |
Created By |
Text |
BZ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BZ_DDESC |
Detailed Description |
999x |
Detailed Description |
Text |
BZ_DESC |
Corrective Action Desc |
254x |
Corrective Actionn Description |
Text |
BZ_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
BZ_DUE_DT |
Due Date |
mm/dd/yyyy |
Due Date |
Date/Time |
BZ_ID |
Corrective Rec # |
nnnnnnnn |
Violation Corrective Action Record Number |
Long Integer |
BZ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
BZ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
BZ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BZ_NOT_DT |
Notification Date |
mm/dd/yyyy |
Notification Date |
Date/Time |
BZ_NOTES |
Notes |
254x |
Notes |
Text |
BZ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |