Work Building Permit Inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
BI_BP_ID |
Building Permit Rec # |
nnnnnnnn |
Long Integer |
|
BI_COMMENT1 |
Long Note |
|
Long Note |
Memo |
BI_CRT_BY |
Created By |
25x |
Created By |
Text |
BI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BI_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
BI_ID |
Bldg Permit Inspection # |
nnnnnnnn |
Building Permit Inspection Rec # |
Long Integer |
BI_INSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
Date/Time |
BI_INSP_TM |
Inspection Time |
hh:mm am |
Inspection Time |
Date/Time |
BI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
BI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
BI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BI_STAT_CD |
Status |
nnn |
Status |
Integer |
BI_STAT_TY |
Status Text |
25x |
Status Text |
Text |
BI_TYPE_CD |
Inspection Type |
nnn |
Inspection Type |
Integer |
BI_TYPE_TY |
Inspection Type Text |
25x |
Inspection Type Text |
Text |
BI_USER10CD |
User 10 |
10x |
User 10 |
Text |
BI_USER10TY |
User 10 Text |
60x |
User 10 Text |
Text |
BI_USER11 |
User 11 |
30x |
User 11 |
Text |
BI_USER12 |
User 12 |
30x |
User 12 |
Text |
BI_USER13 |
User 13 |
30x |
User 13 |
Text |
BI_USER14 |
User 14 |
30x |
User 14 |
Text |
BI_USER15 |
User 15 |
30x |
User 15 |
Text |
BI_USER16 |
User 16 |
nnnnnnnnn.nn |
User 16 |
Double |
BI_USER17 |
User 17 |
nnnnnnnnn.nn |
User 17 |
Double |
BI_USER18 |
User 18 |
nnnnnnnnn.nn |
User 18 |
Double |
BI_USER19 |
User 19 |
nnnnnnnnn.nn |
User 19 |
Double |
BI_USER1CD |
User 1 |
nnnn |
User 1 |
Integer |
BI_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
BI_USER20 |
User 20 |
nnnnnnnnn.nn |
User 20 |
Double |
BI_USER21 |
User 21 |
mm/dd/yyyy |
User 21 |
Date/Time |
BI_USER22 |
User 22 |
mm/dd/yyyy |
User 22 |
Date/Time |
BI_USER23 |
User 23 |
mm/dd/yyyy |
User 23 |
Date/Time |
BI_USER24 |
User 24 |
mm/dd/yyyy |
User 24 |
Date/Time |
BI_USER25 |
User 25 |
mm/dd/yyyy |
User 25 |
Date/Time |
BI_USER26 |
User 26 |
|
User 26 |
Boolean |
BI_USER27 |
User 27 |
|
User 27 |
Boolean |
BI_USER28 |
User 28 |
|
User 28 |
Boolean |
BI_USER29 |
User 29 |
|
User 29 |
Boolean |
BI_USER2CD |
User 2 |
nnnn |
User 2 |
Integer |
BI_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
BI_USER30 |
User 30 |
|
User 30 |
Boolean |
BI_USER3CD |
User 3 |
nnnn |
User 3 |
Integer |
BI_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
BI_USER4CD |
User 4 |
nnnn |
User 4 |
Integer |
BI_USER4TY |
User 4 Text |
25x |
User 4 Text |
Text |
BI_USER5CD |
User 5 |
nnnn |
User 5 |
Integer |
BI_USER5TY |
User 5 Text |
25x |
User 5 Text |
Text |
BI_USER6CD |
User 6 |
10x |
User 6 |
Text |
BI_USER6TY |
User 6 Text |
60x |
User 6 Text |
Text |
BI_USER7CD |
User 7 |
10x |
User 7 |
Text |
BI_USER7TY |
User 7 Text |
60x |
User 7 Text |
Text |
BI_USER8CD |
User 8 |
10x |
User 8 |
Text |
BI_USER8TY |
User 8 Text |
60x |
User 8 Text |
Text |
BI_USER9CD |
User 9 |
10x |
User 9 |
Text |
BI_USER9TY |
User 9 Text |
60x |
User 9 Text |
Text |