IPT Facility Conversations
Field Name |
Caption |
Mask |
Description |
Field Type |
IO_AREP_CD |
Agency Rep |
nnn |
Agency Representative |
Integer |
IO_AREP_TY |
Agency Rep Text |
30x |
Agency Representative Text |
Text |
IO_CDIR_CD |
Contact Direction |
nnn |
Contact Direction |
Integer |
IO_CDIR_TY |
Contact Direction Text |
30x |
Contact Direction Text |
Text |
IO_CONTACT |
Contact |
50x |
Contact |
Text |
IO_CONV_DT |
Conversation Date |
mm/dd/yyyy |
Conversation Date |
Date/Time |
IO_CONV_TM |
Conversation Time |
hh:mm am |
Conversation Time |
Date/Time |
IO_CRT_BY |
Created By |
25x |
Created By |
Text |
IO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IO_DESC |
Short Description |
254x |
Short Description |
Text |
IO_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
IO_ID |
Conversation Record No |
nnnnnnnn |
Unique ID |
Long Integer |
IO_IF_ID |
Facility Record No |
nnnnnnnn |
Long Integer |
|
IO_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
IO_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
IO_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
IO_PHONE |
Phone |
25x |
Phone |
Text |
IO_REC_DT |
Date Recorded |
mm/dd/yyyy |
Recorded Date |
Date/Time |
IO_REC_TM |
Time Recorded |
hh:mm am |
Recorded Time |
Date/Time |
IO_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |