INFO_REQUEST
Description:
This table contains information about Additional Information Request records. This includes links to the patient, referrals, communications, and documents.

Primary Key
Column Name Ordinal Position
INFO_REQ_ID 1

Column Information
Name Type Discontinued?
1 INFO_REQ_ID NUMERIC No
The unique identifier (.1 item) for the Additional Information Request record.
2 RECORD_STATUS_2_C_NAME VARCHAR No
The record status of this Additional Information Request (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 EXTERNAL_IDENTIFIER VARCHAR No
The Additional Information Request's external ID number.
4 INFO_REQUEST_CONTEXT_C_NAME VARCHAR No
The request context category ID for the Additional Information Request record.
May contain organization-specific values: No
Category Entries:
Prior Authorization
Delegated Prior Authorization
5 INFO_REQ_ACTV_USE_STAT_C_NAME VARCHAR No
The active use status category ID for the Additional Information Request record.
May contain organization-specific values: No
Category Entries:
In Progress
Finalized
Canceled
6 CREATION_UTC_DTTM DATETIME (UTC) No
The UTC instant this Additional Information Request was created.
7 CREATION_DTTM DATETIME (Local) No
The instant this Additional Information Request was created.
8 LAST_UPD_UTC_DTTM DATETIME (UTC) No
The UTC instant this Additional Information Request was last updated.
9 LAST_UPD_DTTM DATETIME (Local) No
The instant this Additional Information Request was last updated.
10 COMPLETION_UTC_DTTM DATETIME (UTC) No
The UTC instant this Additional Information Request record was finalized or canceled.
11 COMPLETION_DTTM DATETIME (Local) No
The instant this Additional Information Request record was finalized or canceled.
12 COMPLETION_USER_ID VARCHAR No
The ID of user who finalized or canceled this Additional Information Request.
13 COMPLETION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
14 INFO_REQ_ORG_ROLE_C_NAME VARCHAR No
The organization role for your organization in this Additional Information Request.
May contain organization-specific values: No
Category Entries:
Provider
Payer
15 PAT_ID VARCHAR No
The patient or member around whom all communication in this Additional Information Request is based.
16 PA_REFERRAL_ID NUMERIC No
The prior authorization referral record ID which this Additional Information Request belongs to.
17 PA_AUTH_REQUEST_ID NUMERIC No
The authorization request ID of the prior authorization which this Additional Information Request belongs to.