INFO_REQUEST_CONTACT

Description: |
This table contains a snapshot of information about an individual outreach or response within an Additional Information Request record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INFO_REQ_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INFO_REQ_ID | NUMERIC | No |
The unique identifier (.1 item) for the Additional Information Request record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | INFO_REQUEST_TX_TYPE_C_NAME | VARCHAR | No |
The Transmission Type of this Additional Information Contact.
May contain organization-specific values: No
Category Entries:
Request
Response
4 | INFO_REQ_TX_DIRECTION_C_NAME | VARCHAR | No |
The Transmission Direction of this Additional Information Contact.
May contain organization-specific values: No
Category Entries:
Incoming
Outgoing
5 | INFO_REQ_CNCT_SRC_C_NAME | VARCHAR | No |
The Entry Source of this Additional Information Contact.
May contain organization-specific values: No
Category Entries:
Manual Entry
Electronic Auth Review Attachment
Routed Through Payer Platform
Tapestry Link
Electronic Auth Response Automatic Trigger
UM Response Automatic Trigger
UM PA Attachment
Provider Guideline Review
Da Vinci PAS Response Automatic Trigger
Da Vinci PAS Attachment
Rule Guidance Response
6 | CNCT_CREATE_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant this Additional Information Contact was created.
7 | CNCT_CREATE_DTTM | DATETIME (Local) | No |
The instant this Additional Information Contact was created.
8 | CNCT_CREATE_USER_ID | VARCHAR | No |
The unique ID of the user who created this Additional Information Contact.
9 | CNCT_CREATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | INFO_REQUEST_TX_STATUS_C_NAME | VARCHAR | No |
The Transmission Status of this Additional Information Contact.
May contain organization-specific values: No
Category Entries:
Waiting To File
Waiting to Generate
Filed
Generated
Errored
Canceled
11 | GENERATED_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when a notification was generated for this Additional Information Contact.
12 | GENERATED_DTTM | DATETIME (Local) | No |
The instant when a notification was generated for this Additional Information Contact.
13 | FILED_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when this Additional Information Contact was filed.
14 | FILED_DTTM | DATETIME (Local) | No |
The instant when this Additional Information Contact was filed.
15 | COMM_ID | VARCHAR | No |
The communication record which documents the communication involved in this Additional Information Contact.
16 | INSTANT_OF_ENTRY_DTTM | DATETIME (Attached) | No |
The UTC instant when this Additional Information Contact was entered.
17 | INSTANT_OF_ENTRY_UTC_DTTM | DATETIME (UTC) | No |
The instant when this Additional Information Contact was entered.
18 | IS_CORR_YN | VARCHAR | No |
Indicates if this Additional Information Contact was a correction of a previous contact.
May contain organization-specific values: No
Category Entries:
No
Yes
19 | GUIDELINE_CRITERIA_REVIEW_ID | NUMERIC | No |
The guideline review that was sent to the provider as part of this additional information request, or completed by the provider as part of this additional information response.
20 | RESPONSE_NEEDED_BY_DATE | DATETIME | No |
Stores the date when the payer is expected to get a response by from the provider.