ORDER_AUTH_INFO
Description:
This table holds information about prior authorization for medications in certain workflows. It is currently only used when communicating with eClaimLink for authorizations.

Primary Key
Column Name Ordinal Position
ORDER_ID 1

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
2 MED_AUTH_RESULT_C_NAME VARCHAR No
Holds the medication authorization result.
May contain organization-specific values: No
Category Entries:
Approved
Denied
3 MED_AUTH_NUM VARCHAR No
Holds the authorization ID returned by the payer.
4 AUTH_DENY_RSN_ID NUMERIC No
Holds the authorization denial reason.
5 AUTH_DENY_RSN_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.
6 AUTH_START_UTC_DTTM DATETIME (UTC) No
This item holds the instant the authorization is valid from.
7 AUTH_END_UTC_DTTM DATETIME (UTC) No
This item holds the instant the authorization is valid to.
8 AUTH_LIMIT NUMERIC No
Holds the medication authorization limit.