BMP Site Milestones
Field Name |
Caption |
Mask |
Description |
Field Type |
AE_ACT_CD |
Activity Type |
5x |
Activity Type |
String |
AE_ACT_DT |
Activity Date |
mm/dd/yyyy |
Activity Date |
DateTime |
AE_ACT_TY |
Activity Type Text |
30x |
Activity Type Text |
String |
AE_ACTIVI |
Activity |
200x |
Activity |
String |
AE_BS_ID |
BMP Site Rec # |
nnnnnnnn |
Long Integer |
|
AE_COMPBY |
Completed By |
50x |
Completed By |
String |
AE_CRT_BY |
Created By |
25x |
Created By |
String |
AE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
AE_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
AE_END_DT |
Activity Finish Date |
mm/dd/yyyy |
Activity Finish Date |
DateTime |
AE_ID |
Site Milestone Rec # |
nnnnnnnn |
Site Milestone Rec # |
Long Integer |
AE_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
AE_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
DateTime |
AE_MOD_TM |
Modified Time |
hh:mm am |
Modified Time |
DateTime |
AE_NOTES |
Notes |
1000x |
Notes |
String |
AE_PAPP_CD |
Process Approval Code |
10x |
Process Approval Code |
String |
AE_PAPP_TY |
Process Approval Text |
60x |
Process Approval Text |
String |
AE_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
AE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
AE_USER1TY |
User 1 Text |
50x |
User 1 Text |
String |
AE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
AE_USER2TY |
User 2 Text |
50x |
User 2 Text |
String |
AE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
AE_USER3TY |
User 3 Text |
50x |
User 3 Text |
String |
AE_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
AE_USER4TY |
User 4 Text |
50x |
User 4 Text |
String |
AE_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
AE_USER5TY |
User 5 Text |
50x |
User 5 Text |
String |
AE_USER6 |
User 6 |
50x |
User 6 |
String |
AE_USER7 |
User 7 |
50x |
User 7 |
String |
AE_USER8 |
User 8 |
50x |
User 8 |
String |
AE_USER9 |
User 9 |
50x |
User 9 |
String |
AE_USER10 |
User 10 |
50x |
User 10 |
String |
AE_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
AE_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
AE_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
AE_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
AE_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
AE_USER16 |
User 16 |
mm/dd/yyyy hh:mm am |
User 16 |
DateTime |
AE_USER17 |
User 17 |
mm/dd/yyyy hh:mm am |
User 17 |
DateTime |
AE_USER18 |
User 18 |
mm/dd/yyyy hh:mm am |
User 18 |
DateTime |
AE_USER19 |
User 19 |
mm/dd/yyyy hh:mm am |
User 19 |
DateTime |
AE_USER20 |
User 20 |
mm/dd/yyyy hh:mm am |
User 20 |
DateTime |
AE_USER21 |
User 21 |
|
User 21 |
Boolean |
AE_USER22 |
User 22 |
|
User 22 |
Boolean |
AE_USER23 |
User 23 |
|
User 23 |
Boolean |
AE_USER24 |
User 24 |
|
User 24 |
Boolean |
AE_USER25 |
User 25 |
|
User 25 |
Boolean |