Master Project Activity History table
Field Name |
Caption |
Mask |
Description |
Field Type |
AH_AT_ID |
Project Activity Rec # |
nnnnnnnn |
Long Integer |
|
AH_CHNG_BY |
Changed By |
25x |
Change Made By |
Text |
AH_CHNG_DT |
Change Date |
mm/dd/yyyy |
Change Made on this date |
Date/Time |
AH_CRT_BY |
Created By |
25x |
Created By |
Text |
AH_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AH_ID |
Project Activ Hist Rec # |
nnnnnnnn |
Project Activity Rec # |
Long Integer |
AH_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
AH_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
AH_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AH_NEND_DT |
New Finish Date |
mm/dd/yyyy |
New End Activity Date |
Date/Time |
AH_NSTR_DT |
New Activity Date |
mm/dd/yyyy |
New Start Activity Date |
Date/Time |
AH_PEND_DT |
Previous Finish Date |
mm/dd/yyyy |
Previous End Activity Date |
Date/Time |
AH_PSTR_DT |
Previous Start Date |
mm/dd/yyyy |
Previous Start Activity Date |
Date/Time |
AH_REAS_CD |
Reason |
nnn |
Change Reason |
Integer |
AH_REAS_TY |
Reason Text |
25x |
Change Reason Text |
Text |
AH_REASON |
Modifed Reason |
254x |
Reason for Date Modification |
Text |
AH_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |