Sewer IPT Categorical Codes Setup Table
Field Name |
Caption |
Mask |
Description |
Field Type |
CT_CAT |
Category |
20x |
Category |
Text |
CT_CRT_BY |
Created By |
25x |
Created By |
Text |
CT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CT_DESC |
Category Description |
254x |
Category Description |
Text |
CT_ID |
Categorical Rec # |
nnnnnnnn |
Categorical Record Number |
Long Integer |
CT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |