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.