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
ANSI X12 275
Routed Through Payer Platform
Tapestry Link
ANSI 278R Response Automatic Trigger
UM Response Automatic Trigger
UM PA Attachment
Provider Guideline Review
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.