|
Name |
Type |
Discontinued? |
|
| 1 |
COMM_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the Communication Tracking record. |
|
|
| 2 |
USER_ID |
VARCHAR |
No |
|
|
|
| The user who entered the communication. |
|
|
| 3 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 4 |
COMM_INSTANT_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The date and time of the communication, stored in UTC format. |
|
|
| 5 |
COMM_COMMENT |
VARCHAR |
No |
|
|
|
| A comment to go with the communication. |
|
|
| 6 |
CALLER_NAME |
VARCHAR |
No |
|
|
|
| For incoming calls, this item stores the name of the caller. For outgoing calls, it stores the name of the person who was contacted for this logged communication. |
|
|
| 7 |
PHONE_NUMBER |
VARCHAR |
No |
|
|
|
| Phone number for the communication. |
|
|
| 8 |
CONTACT_ACCT_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the guarantor account that is associated with the communication. |
|
|
| 9 |
REF_DOCUMENT_ID |
VARCHAR |
No |
|
|
|
| If there is a scanned document related to the communication, this field will contain the ID of the document's DCS record. |
|
|
| 10 |
COMM_CMT_NOTE_ID |
VARCHAR |
No |
|
|
|
| Note record containing comment about communication |
|
|
| 11 |
CONTACT_PHR_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the pharmacy that is associated with the communication. |
|
|
| 12 |
CONTACT_PHR_ID_PHARMACY_NAME |
VARCHAR |
No |
|
|
|
| The name of the pharmacy. |
|
|
| 13 |
EXTERNAL_ID |
VARCHAR |
No |
|
|
|
| This item stores the external identifier for this contact. This may be populated when the contact was automatically generated. |
|
|
| 14 |
COMM_IN_CMT_NOTE_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the note that is associated with the lab comment. |
|
|
| 15 |
CONTACT_WORKER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the hospital service employee that is associated with this communication. |
|
|
| 16 |
CONTACT_WORKER_PAGER_C_NAME |
VARCHAR |
No |
|
|
|
| The pager this communication was sent to. |
| May contain organization-specific values: Yes |
|
|
| 17 |
MESSAGE_SUBJECT |
VARCHAR |
No |
|
|
|
| The subject line of a message sent to a pager. |
|
|
| 18 |
MESSAGE_AD_HOC_YN |
VARCHAR |
No |
|
|
|
| Indicates whether or not the message was ad hoc (entered by a user in Hyperspace) rather than a system-generated message triggered by some kind of action. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 19 |
TC_REQ_COMM_CONTACT_IDENTIFIER |
INTEGER |
No |
|
|
|
| This item stores the identifier for the entry in the contact log of the associated Transfer Center request that corresponds with the contact on the communication. |
|
|
| 20 |
CONTACT_SUBMITTER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the laboratory submitter that is associated with the communication. |
|
|
| 21 |
CONTACT_SUBMITTER_ID_RECORD_NAME |
VARCHAR |
No |
|
|
|
| The name of the submitter record. |
|
|
| 22 |
SOURCE_COMM_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the communication record that this communication was copied from when it was moved to a different transfer center request. |
|
|
| 23 |
CONTACT_REP_GUID |
VARCHAR |
No |
|
|
|
| This is the line identifier for the representative of the member being contacted as part of this communication. The line identifier corresponds to the coverage responsible person line identifier (MEMBER_RESP_PERSON.MEM_RESP_GUID). |
|
|
| 24 |
MESSAGE_PREFERRED_LANGUAGE_C_NAME |
VARCHAR |
No |
|
|
|
| The preferred language of the message recipient, if not the native language for the environment. |
| May contain organization-specific values: Yes |
|
|
