EPA_INFO

Description:

This table holds information about electronic prior authorization requests.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique identifier for the referral record.
2	EPA_REF_ID	VARCHAR	No
	This item holds the reference ID for electronic prior authorization. It is generated by the system and used for linking a referral record to an electronic prior authorization message. This value will not change during an electronic prior authorization interaction.
3	PA_PAT_NOTIFIED_YN	VARCHAR	No
	This item specifies whether the patient has been notified about the status of the prior authorization. May contain organization-specific values: No Category Entries: Yes No
4	PA_APPROVAL_SRC_C_NAME	VARCHAR	No
	This item records the entry source of the outpatient prescription prior authorization details. If an authorization was completed using both electronic and manual entry, this will be based on how the most recent data was entered. May contain organization-specific values: No Category Entries: Electronic Manual
5	MED_EPA_UPD_UTC_DTTM	DATETIME (UTC)	No
	This holds the instant that ePA information was last updated on this referral.
6	EPA_RFL_ORD_ID	NUMERIC	No
	This virtual item holds the order ID associated with an outpatient prescription medication prior authorization request.
7	PAT_EPA_ENC_CSN_ID	NUMERIC	No
	This item holds the CSN of the encounter the prior authorization was requested in.
8	EPA_PHR_ID	NUMERIC	No
	This item stores the pharmacy that initiated prior authorization.
9	EPA_PHR_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.
10	EPA_REQ_TYPE_C_NAME	VARCHAR	No
	This item records the type of the outpatient prescription prior authorization request. 1-Prospective is a request that was initiated at the time of signing the order. 2-Retrospective is a request that was initiated after the order was signed. 3-Retrospective-RxChange is a retrospective request that was initiated by an electronic RxChange message from the pharmacy. 4-Renewal is a request that was initiated on a signed order that already had a prior authorization request linked to it. 5-Renewal-RxChange is a renewal that was initiated by an electronic RxChange message from the pharmacy. 6-Retrospective-Willow Ambulatory is a retrospective request that was initiated from within the Willow Ambulatory application. 7-Renewal-Willow Ambulatory is a renewal that was initiated from within the Willow Ambulatory application. May contain organization-specific values: No Category Entries: Prospective Retrospective Retrospective-RxChange Renewal Renewal-RxChange Retrospective-Willow Ambulatory Renewal-Willow Ambulatory Renewal-Payer
11	CUR_EPA_STATUS_C_NAME	VARCHAR	No
	This item holds the current status of the outpatient prescription prior authorization request. May contain organization-specific values: No Category Entries: Approved Denied Canceled Appeal Approved Appeal Denied Payer Waiting for Response Waiting for Payer Response Waiting for Auth Details Closed Error
12	EPA_HRS_FINAL_STAT	INTEGER	No
	This column holds the numbers of hours that the outpatient prescription prior authorization request was in progress. For requests that were initiated, but no other actions have taken place, the count returned will be 0. For other requests, the count returned will be the hours between the initiation of the request and the last action performed on the request.