Master Project Employee Tracking Table
Field Name |
Caption |
Mask |
Description |
Field Type |
TE_BY |
Tracked By |
25x |
Tracked User |
Text |
TE_CRT_BY |
Created By |
25x |
Created By |
Text |
TE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TE_DESC |
Description |
999x |
Tracked Description |
Text |
TE_DT |
Tracked Date |
mm/dd/yyyy |
Tracked Date |
Date/Time |
TE_ID |
AutoNumber |
nnnnnnnn |
Unique ID |
Long Integer |
TE_MOD_BY |
Modified By |
25x |
Last Modified By |
Text |
TE_MOD_DT |
Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TE_MOD_TM |
Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TE_MP_ID |
Link To Master Project |
nnnnnnnn |
Long Integer |
|
TE_REASON |
Tracked Reason |
999x |
Tracked Description |
Text |
TE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TE_TM |
Tracked Time |
hh:mm am |
Tracked Time |
Date/Time |