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.