AUTHORIZATIONS

Description:

This table contains information about authorization records. This includes links to the patient, referral, and coverage/payer.

Primary Key

Column Name	Ordinal Position
AUTH_ID	1

Column Information

	Name	Type	Discontinued?
1	AUTH_ID	NUMERIC	No
	The authorization ID for the authorization record.
2	AUTH_FROM_DT	DATETIME	No
	Authorization start date
3	AUTH_TO_DT	DATETIME	No
	Authorization end date
4	PAT_ID	VARCHAR	No
	The patient for whom the authorization record was created. This column is frequently used to link to the PATIENT table.
5	REFERRAL_ID	NUMERIC	No
	Referral associated with this authorization. If this is a UM owned service-level authorization, this column is not populated and, instead, column UM_REFERRAL_ID will be populated. This column is frequently used to link to the REFERRAL table.
6	AUTH_TYPE_C_NAME	VARCHAR	No
	Authorization type category value May contain organization-specific values: No Category Entries: Procedure Bed Days Shell Pharmacy
7	NUM_SVCS_APPROVED	INTEGER	No
	Number of services, units or visits approved.
8	NUM_SVCS_REQUESTED	INTEGER	No
	Number of services, units, or visits requested.
9	CVG_ID	NUMERIC	No
	Linked coverage record. This column is frequently used to link to the COVERAGE table.
10	AUTH_NUM	VARCHAR	No
	Authorization number
11	AUTH_COMMENTS	VARCHAR	No
	Free text authorization comment.
12	RECORD_CREATION_DT	DATETIME	No
	Record creation date.
13	CHARGE_COUNTS	INTEGER	No
	Keeps track of number of counts used by charges.
14	AUTH_REF_NUMBER	VARCHAR	No
	The reference number given to us by the payer for this service-level authorization (AUT).
15	AP_CLAIM_COUNT	INTEGER	No
	Number of services, units, or visits used for AP Claims.
16	INTER_NUM_SVCS_APRV	INTEGER	No
	The number of services approved for each interval.
17	INTER_NUM_SVCS_REQ	INTEGER	No
	The number of services requested for each interval.
18	INTER_APRV_FREQ_ID	VARCHAR	No
	The ID of the associated Frequency Record for the approved recurring authorization.
19	INTER_APRV_FREQ_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
20	INTER_REQ_FREQ_ID	VARCHAR	No
	The ID of the associated Frequency Record for the requested recurring authorization.
21	INTER_REQ_FREQ_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
22	INTER_NUM_APRV	INTEGER	No
	The number of times the interval has been approved to repeat.
23	INTER_NUM_REQ	INTEGER	No
	The number of times the interval has been requested to repeat.
24	PARENT_AUTH_ID	NUMERIC	No
	The Parent Authorization that this authorization (AUT) inherits from.
25	AP_CLAIM_COUNT_METHOD_C_NAME	VARCHAR	No
	The counting method for the AP Claim counts. May contain organization-specific values: No Category Entries: Counts not tracked Once per day By service quantity
26	UM_STATUS_C_NAME	VARCHAR	No
	The utilization management authorization decision status for the requested service. May contain organization-specific values: No Category Entries: Authorized Partially Authorized Pending Review Withdrawn Denied Dismissed No Authorization Required Closed Pending External Review
27	UM_APPROVED_RSN_C_NAME	VARCHAR	No
	The reason the authorized status was assigned to this service. May contain organization-specific values: Yes Category Entries: Overturned on Appeal
28	UM_PART_APRV_RSN_C_NAME	VARCHAR	No
	The reason the partial authorization status was assigned to this service. May contain organization-specific values: Yes
29	UM_DENIED_RSN_C_NAME	VARCHAR	No
	The reason the denied status was assigned to this service. May contain organization-specific values: Yes Category Entries: Upheld on Appeal
30	UM_DISMISSED_RSN_C_NAME	VARCHAR	No
	The reason the dismissed status was assigned to this service. May contain organization-specific values: Yes Category Entries: Appeal Dismissed
31	UM_NOT_REQUIRED_RSN_C_NAME	VARCHAR	No
	The reason the no auth required status was assigned to this service. May contain organization-specific values: Yes
32	UM_PENDING_RSN_C_NAME	VARCHAR	No
	The reason the pending status was assigned to this service. May contain organization-specific values: Yes Category Entries: Appeal Under Review Requires Appeal Effectuation
33	UM_CANCELED_RSN_C_NAME	VARCHAR	No
	The reason the canceled/withdrawn status was assigned to this service. May contain organization-specific values: Yes
34	UM_DECISION_DTTM	DATETIME (Local)	No
	The date and time the authorization decision was set on the service level authorization. Note that if a service's status changes from a finalized status to another after the entire authorization request has been finalized, this column does not update with the new instant and will instead reflect the original decision instant.
35	NON_UM_AUTH_ID	NUMERIC	No
	Service authorizations that are created as part of UM workflows will only appear in UM workflows. If the authorization details are needed outside the UM department, then corresponding non-UM service-level authorizations are created. This separation is required to ensure non-UM staff cannot alter authorization decisions rendered by UM staff. This column provides a link between the UM service authorizations and non-UM service-level authorizations. There is a 1-to-1 link between UM and non-UM service-level authorizations.
36	UM_AUTH_REQUEST_ID	NUMERIC	No
	If this is a UM-owned service authorization, this column serves as the pointer to the authorization request record. UM-owned service authorizations do not have direct pointers to referral and coverage. They must be accessed through the authorization request.
37	NON_UM_ORDER_ID	NUMERIC	No
	This is a link between a UM service authorization and an order on the referral.
38	ORDER_ENTRY_ORDER_ID	NUMERIC	No
	When the service is created as part of order entry, this column will be populated as a pointer back to the order.
39	UM_CLOSED_RSN_C_NAME	VARCHAR	No
	The reason the closed status was assigned to this service. May contain organization-specific values: Yes Category Entries: Moved To Another Auth Request
40	UM_FINALIZE_USER_ID	VARCHAR	No
	The unique ID associated with the user record that finalized this authorization. This column is frequently used to link to the CLARITY_EMP table.
41	UM_FINALIZE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
42	FINAL_UM_STATUS_CHANGE_SRC_C_NAME	VARCHAR	No
	The change source category ID that resulted in the finalized status of the service. May contain organization-specific values: No Category Entries: Manual Update Auto Status Assignment Imported 278N 278R INTERNAL PRIOR AUTH Auto Status Assignment Pre-Check
43	AUTH_STATUS_C_NAME	VARCHAR	No
	The provider-side authorization status category ID for the service. May contain organization-specific values: No Category Entries: Authorized No Auth Required Pending Canceled Denied
44	UM_MED_DIR_REV_USER_ID	VARCHAR	No
	The user who set the pending review status reason for a medical director review.
45	UM_MED_DIR_REV_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
46	UM_PEND_MED_DIRECTOR_DTTM	DATETIME (Local)	No
	The local date and time of when the authorization pended for review with a reason of medical director review.
47	UM_PEND_MED_DIRECTOR_UTC_DTTM	DATETIME (UTC)	No
	The date and time in UTC of when the authorization pended for review with a reason of medical director review.
48	FIRST_PAT_ENC_CSN_ID	NUMERIC	No
	Ths CSN of the encounter linked to the service level authorization with the earliest encounter instant. If the service level authorization doesn't have any encounters linked directly, it will search the linked referral or auth/cert.
49	LAST_PAT_ENC_CSN_ID	NUMERIC	No
	The CSN of the encounter linked to the service level authorization with the latest encounter instant. If the service level authorization doesn't have any encounters linked directly, it will search the linked referral or auth/cert.
50	APPEALED_SERVICE_AUTH_ID	NUMERIC	No
	The ID of the service that this service was created to appeal.
51	LAST_CVG_GUIDANCE_C_NAME	VARCHAR	No
	When we receive a Coverage Requirements Discovery response message pertaining to this authorization, this item will store the coverage guidance value from that message. May contain organization-specific values: No Category Entries: No Guidance Not Covered No Auth Required Auth Required Clinical Info Needed Administrative Info Needed
52	UM_CVG_GUIDANCE_SOURCE_C_NAME	VARCHAR	No
	The coverage guidance source category ID for the coverage guidance request. May contain organization-specific values: No Category Entries: Payer Platform Payer Internal Request Link Portal Request Provider Internal Request Cost Calculator
53	UM_CVG_GDNC_REALTIME_TX_CSN_ID	NUMERIC	No
	The unique contact serial number of the real-time transaction that originated the Coverage Requirements Discovery request.
54	UM_CVG_GUIDANCE_PA_SVC_LN_IDNT	INTEGER	No
	The line number of the service from the real-time transaction that originated the Coverage Requirements Discovery service request.
55	UM_CVG_GUIDANCE_C_NAME	VARCHAR	No
	The coverage guidance determination category ID for the requested service. The category values for this column were already listed for column: LAST_CVG_GUIDANCE_C_NAME
56	UM_CVG_GUIDANCE_FROM_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
57	UM_CVG_GUIDANCE_REQ_DATE	DATETIME	No
	The date of the requested service for which guidance is being requested. If no date was provided with the request, the date of the request creation is used.
58	UM_CVG_GUIDANCE_REQ_LOC_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
59	UM_CVG_GUIDANCE_REQ_VENDOR_ID_VENDOR_NAME	VARCHAR	No
	The name of the vendor.
60	UM_CVG_GUIDANCE_REQ_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
61	UM_CVG_GUIDANCE_REQUEST_NOTE	VARCHAR	No
	The free-text note text associated with the coverage guidance request.
62	UM_CVG_GUIDANCE_LOB_ID	VARCHAR	No
	The unique ID of the line of business associated with the requested coverage guidance.
63	UM_CVG_GUIDANCE_LOB_ID_LOB_NAME	VARCHAR	No
	The name of the line of business record.
64	UM_CVG_GUIDANCE_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
65	UM_CVG_GUIDANCE_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
66	UM_CVG_GUIDANCE_CREATE_USER_ID	VARCHAR	No
	The unique ID of the user who created the coverage guidance request, if known.
67	UM_CVG_GUIDANCE_CREATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
68	DENIAL_REASON_C_NAME	VARCHAR	No
	If this authorization's status is Denied, then this item will contain the rationale given for that denial. May contain organization-specific values: No Category Entries: Not Medically Necessary Retroactive Referral Request Not a Covered Benefit Not in Network Duplicate Referral Request System Automatically Denied Does Not Meet 3rd Party Guidelines DOES NOT MEET INTERNAL GUIDELINES Member not covered Authorized Quantity Exceeded Exceeds Plan Maximums No Prior Approval Requested Information Not Received Service Inconsistent With Diagnosis Pre-Existing Condition Patient is Restricted to Specific Provider Plan/Contractual Guidelines Not Followed Plan/Contractual Geographic Restriction Inappropriate Facility Type Once in a Lifetime Restriction Applies Transport Request Denied Errors in the Request Excluded Benefit Appeal Denied Not Primary Care Physician Level of Care Not Appropriate Denial Response Needs Review Requires Medical Review Experimental Service or Procedure Peer to Peer Needed Time Limits not Met
69	AUTH_BED_DAY_TYPE_ID	NUMERIC	No
	The type of day (TOD record) approved by the payer.
70	AUTH_BED_DAY_TYPE_ID_BED_DAY_TYPE_NAME	VARCHAR	No
	The name of the bed day type record (i.e. ICU or non-authorized.)
71	NUM_DAYS_APPROVED	INTEGER	No
	The number of days approved by the payer for a bed day type. This is calculated as End Date - Start Date + 1.
72	NUM_NIGHTS_APPROVED	INTEGER	No
	The number of nights approved by the payer for a bed day type. This is calculated as : End Date - Start Date.
73	EXT_SVC_MSG	VARCHAR	No
	Service-level MSG data received by Payer Platform from an external system.
74	EXT_SVC_REF_NUM	VARCHAR	No
	the administrative reference number received by Payer Platform from an external system for this service
75	EXT_SVC_AUTH_NUM	VARCHAR	No
	the authorization number received by Payer Platform from an external system for this service
76	UM_CVG_GUIDANCE_RESP_AGENCY_ID	VARCHAR	No
	The unique ID of the responsible entity for determining coverage guidance for the requested service.
77	UM_CVG_GUIDANCE_RESP_AGENCY_ID_AGENCY_NAME	VARCHAR	No
	The name of the agency.
78	AUTH_BED_DAY_TX_STATUS_C_NAME	VARCHAR	No
	Indicates the current transaction status for this bed day May contain organization-specific values: No Category Entries: New Submitted Waiting on Payer Waiting on Provider Finalized
79	UM_REQ_RX_QTY	NUMERIC	No
	The requested quantity limit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
80	UM_REQ_RX_DISP_QTYUNIT_C_NAME	VARCHAR	No
	The requested quantity limit unit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe. May contain organization-specific values: Yes Category Entries: mL L mg g Units mmol mEq mcg % Int'l Units Million Units kcal ng mg PE milli-units pg KBq MBq GBq mcL mL/min L/min mg/min g/min Units/min mmol/min mEq/min mcg/min kJ/min Int'l Units/min Million Units/min kcal/min ng/min mg PE/min milli-units/min pg/min KBq/min MBq/min GBq/min mcL/min mL/hr L/hr mg/hr g/hr Units/hr mmol/hr mEq/hr mcg/hr kJ/hr Int'l Units/hr Million Units/hr kcal/hr ng/hr mg PE/hr milli-units/hr pg/hr KBq/hr MBq/hr GBq/hr mcL/hr mL/day L/day mg/day g/day Units/day mmol/day mEq/day mcg/day kJ/day Int'l Units/day Million Units/day kcal/day ng/day mg PE/day milli-units/day pg/day Inch/day KBq/day MBq/day GBq/day mcL/day IR/day BAU/day PFU/day Million PFU/day Million Int'l Units/day Kilo Int'l Units/day EIN/day Million EIN/day mL/kg L/kg mg/kg g/kg Units/kg mmol/kg mEq/kg mcg/kg kJ/kg Int'l Units/kg Million Units/kg kcal/kg ng/kg mg PE/kg milli-units/kg pg/kg mg/kg (Actual) Each/kg Puff/kg Package/kg Drop/kg Inch/kg KBq/kg MBq/kg GBq/kg mcL/kg IR/kg BAU/kg Million Int'l Units/kg mcmol/kg 1e12 Vector Genomes/kg Vector Genomes/kg Dose/kg mcg DFE/kg Kilo Int'l Units/kg 1e11 Vector Genomes/kg 1e13 Vector Genomes/kg 1e14 Vector Genomes/kg 1e15 Vector Genomes/kg EIN/kg IR/min BAU/min Million Int'l Units/min Kilo Int'l Units/min IR/hr BAU/hr Million Int'l Units/hr Kilo Int'l Units/hr mL/mL L/mL mg/mL g/mL Units/mL mmol/mL mEq/mL mcg/mL kJ/mL Int'l Units/mL Million Units/mL kcal/mL ng/mL mg PE/mL milli-units/mL pg/mL KBq/mL MBq/mL GBq/mL mcL/mL IR/mL BAU/mL PFU/mL Million PFU/mL Million Int'l Units/mL mcmol/mL 1e12 Vector Genomes/mL Vector Genomes/mL Kilo Int'l Units/mL 1e11 Vector Genomes/mL 1e13 Vector Genomes/mL 1e14 Vector Genomes/mL 1e15 Vector Genomes/mL millicurie/mL mL/L L/L mg/L g/L Units/L mmol/L mEq/L mcg/L kJ/L Int'l Units/L Million Units/L kcal/L ng/L mg PE/L milli-units/L pg/L KBq/L MBq/L GBq/L mcL/L IR/L BAU/L Million Int'l Units/L Kilo Int'l Units/L mL/m2 L/m2 mg/m2 g/m2 Units/m2 mmol/m2 mEq/m2 mcg/m2 kJ/m2 Int'l Units/m2 Million Units/m2 kcal/m2 ng/m2 mg PE/m2 milli-units/m2 pg/m2 mg/m2 (Actual) Each/m2 Puff/m2 Package/m2 Drop/m2 KBq/m2 MBq/m2 GBq/m2 mcL/m2 IR/m2 BAU/m2 Million Int'l Units/m2 mcmol/m2 1e12 Vector Genomes/m2 Vector Genomes/m2 Kilo Int'l Units/m2 1e11 Vector Genomes/m2 1e13 Vector Genomes/m2 1e14 Vector Genomes/m2 1e15 Vector Genomes/m2 mL/1.7m2 L/1.7m2 mg/1.7m2 g/1.7m2 Units/1.7m2 mmol/1.7m2 mEq/1.7m2 mcg/1.7m2 kJ/1.7m2 Int'l Units/1.7m2 Million Units/1.7m2 kcal/1.7m2 ng/1.7m2 mg PE/1.7m2 milli-units/1.7m2 pg/1.7m2 Each/1.7m2 KBq/1.7m2 MBq/1.7m2 GBq/1.7m2 mcL/1.7m2 IR/1.7m2 BAU/1.7m2 Million Int'l Units/1.7m2 Kilo Int'l Units/1.7m2 mL/kg (IDL) L/kg (IDL) mg/kg (IDL) g/kg (IDL) Units/kg (IDL) mmol/kg (IDL) mEq/kg (IDL) mcg/kg (IDL) Int'l Units/kg (IDL) Million Units/kg (IDL) Kcal/kg (IDL) ng/kg (IDL) mg PE/kg (IDL) milli-units/kg (IDL) pg/kg (IDL) mg/m2 (IDL) mL/kg (ADJ) L/kg (ADJ) mg/kg (ADJ) g/kg (ADJ) Units/kg (ADJ) mmol/kg (ADJ) mEq/kg (ADJ) mcg/kg (ADJ) Int'l Units/kg (ADJ) Million Units/kg (ADJ) Kcal/kg (ADJ) ng/kg (ADJ) mg PE/kg (ADJ) milli-units/kg (ADJ) pg/kg (ADJ) mg/m2 (ADJ) mL/100 mL L/100 mL mg/100 mL g/100 mL Units/100 mL mmol/100 mL mEq/100 mL mcg/100 mL kJ/100 mL Int'l Units/100 mL Million Units/100 mL kcal/100 mL ng/100 mL mg PE/100 mL milli-units/100 mL pg/100 mL KBq/100 mL MBq/100 mL GBq/100 mL mcL/100 mL IR/100 mL BAU/100 mL Million Int'l Units/100 mL Kilo Int'l Units/100 mL mL/oz L/oz mg/oz g/oz Units/oz mmol/oz mEq/oz mcg/oz kJ/oz Int'l Units/oz Million Units/oz kcal/oz ng/oz mg PE/oz milli-units/oz pg/oz KBq/oz MBq/oz GBq/oz mcL/oz IR/oz BAU/oz Million Int'l Units/oz Kilo Int'l Units/oz mL/kg/min L/kg/min mg/kg/min g/kg/min Units/kg/min mmol/kg/min mEq/kg/min mcg/kg/min kJ/kg/min Int'l Units/kg/min Million Units/kg/min kcal/kg/min ng/kg/min mg PE/kg/min milli-units/kg/min pg/kg/min KBq/kg/min MBq/kg/min GBq/kg/min mcL/kg/min mL/kg/min (IDL) L/kg/min (IDL) mg/kg/min (IDL) g/kg/min (IDL) Units/kg/min (IDL) mmol/kg/min (IDL) mEq/kg/min (IDL) mcg/kg/min (IDL) Int'l Units/kg/min (IDL) Million Units/kg/min (IDL) Kcal/kg/min (IDL) ng/kg/min (IDL) mg PE/kg/min (IDL) milli-units/kg/min (IDL) pg/kg/min (IDL) mL/kg/min (ADJ) L/kg/min (ADJ) mg/kg/min (ADJ) g/kg/min (ADJ) Units/kg/min (ADJ) mmol/kg/min (ADJ) mEq/kg/min (ADJ) mcg/kg/min (ADJ) Int'l Units/kg/min (ADJ) Million Units/kg/min (ADJ) Kcal/kg/min (ADJ) ng/kg/min (ADJ) mg PE/kg/min (ADJ) milli-units/kg/min (ADJ) pg/kg/min (ADJ) IR/kg/min BAU/kg/min Million Int'l Units/kg/min Kilo Int'l Units/kg/min mL/m2/min L/m2/min mg/m2/min g/m2/min Units/m2/min mmol/m2/min mEq/m2/min mcg/m2/min kJ/m2/min Int'l Units/m2/min Million Units/m2/min kcal/m2/min ng/m2/min mg PE/m2/min milli-units/m2/min pg/m2/min KBq/m2/min MBq/m2/min GBq/m2/min mcL/m2/min mL/1.7m2/min L/1.7m2/min mg/1.7m2/min g/1.7m2/min Units/1.7m2/min mmol/1.7m2/min mEq/1.7m2/min mcg/1.7m2/min kJ/1.7m2/min Int'l Units/1.7m2/min Million Units/1.7m2/min kcal/1.7m2/min ng/1.7m2/min mg PE/1.7m2/min milli-units/1.7m2/min pg/1.7m2/min KBq/1.7m2/min MBq/1.7m2/min GBq/1.7m2/min mSv mGy mcL/1.7m2/min mcSv Sv mcGy cGy Gy mRAD RAD mg of pseudoephedrine mg of ephedrine IR/m2/min BAU/m2/min Million Int'l Units/m2/min Kilo Int'l Units/m2/min IR/1.7m2/min BAU/1.7m2/min Million Int'l Units/1.7m2/min Kilo Int'l Units/1.7m2/min mL/kg/hr L/kg/hr mg/kg/hr g/kg/hr Units/kg/hr mmol/kg/hr mEq/kg/hr mcg/kg/hr kJ/kg/hr Int'l Units/kg/hr Million Units/kg/hr kcal/kg/hr ng/kg/hr mg PE/kg/hr milli-units/kg/hr pg/kg/hr KBq/kg/hr MBq/kg/hr GBq/kg/hr mcL/kg/hr mL/kg/hr (IDL) L/kg/hr (IDL) mg/kg/hr (IDL) g/kg/hr (IDL) Units/kg/hr (IDL) mmol/kg/hr (IDL) mEq/kg/hr (IDL) mcg/kg/hr (IDL) Int'l Units/kg/hr (IDL) Million Units/kg/hr (IDL) Kcal/kg/hr (IDL) ng/kg/hr (IDL) mg PE/kg/hr (IDL) milli-units/kg/hr (IDL) pg/kg/hr (IDL) mL/kg/hr (ADJ) L/kg/hr (ADJ) mg/kg/hr (ADJ) g/kg/hr (ADJ) Units/kg/hr (ADJ) mmol/kg/hr (ADJ) mEq/kg/hr (ADJ) mcg/kg/hr (ADJ) Int'l Units/kg/hr (ADJ) Million Units/kg/hr (ADJ) Kcal/kg/hr (ADJ) ng/kg/hr (ADJ) mg PE/kg/hr (ADJ) milli-units/kg/hr (ADJ) pg/kg/hr (ADJ) IR/kg/hr BAU/kg/hr Million Int'l Units/kg/hr Kilo Int'l Units/kg/hr mL/m2/hr L/m2/hr mg/m2/hr g/m2/hr Units/m2/hr mmol/m2/hr mEq/m2/hr mcg/m2/hr kJ/m2/hr Int'l Units/m2/hr Million Units/m2/hr kcal/m2/hr ng/m2/hr mg PE/m2/hr milli-units/m2/hr pg/m2/hr KBq/m2/hr MBq/m2/hr GBq/m2/hr mcL/m2/hr mL/1.7m2/hr L/1.7m2/hr mg/1.7m2/hr g/1.7m2/hr Units/1.7m2/hr mmol/1.7m2/hr mEq/1.7m2/hr mcg/1.7m2/hr kJ/1.7m2/hr Int'l Units/1.7m2/hr Million Units/1.7m2/hr kcal/1.7m2/hr ng/1.7m2/hr mg PE/1.7m2/hr milli-units/1.7m2/hr pg/1.7m2/hr KBq/1.7m2/hr MBq/1.7m2/hr GBq/1.7m2/hr mcL/1.7m2/hr IR/1.7m2/hr BAU/1.7m2/hr Million Int'l Units/1.7m2/hr Kilo Int'l Units/1.7m2/hr IR/m2/hr BAU/m2/hr Million Int'l Units/m2/hr Kilo Int'l Units/m2/hr mL/kg/day L/kg/day mg/kg/day g/kg/day Units/kg/day mmol/kg/day mEq/kg/day mcg/kg/day kJ/kg/day Int'l Units/kg/day Million Units/kg/day kcal/kg/day ng/kg/day mg PE/kg/day milli-units/kg/day pg/kg/day Inch/kg/day KBq/kg/day MBq/kg/day GBq/kg/day mL/kg/day (IDL) L/kg/day (IDL) mg/kg/day (IDL) g/kg/day (IDL) Units/kg/day (IDL) mmol/kg/day (IDL) mEq/kg/day (IDL) mcg/kg/day (IDL) Int'l Units/kg/day (IDL) Million Units/kg/day (IDL) Kcal/kg/day (IDL) ng/kg/day (IDL) mg PE/kg/day (IDL) milli-units/kg/day (IDL) pg/kg/day (IDL) mL/kg/day (ADJ) L/kg/day (ADJ) mg/kg/day (ADJ) g/kg/day (ADJ) Units/kg/day (ADJ) mmol/kg/day (ADJ) mEq/kg/day (ADJ) mcg/kg/day (ADJ) Int'l Units/kg/day (ADJ) Million Units/kg/day (ADJ) Kcal/kg/day (ADJ) ng/kg/day (ADJ) mg PE/kg/day (ADJ) milli-units/kg/day (ADJ) pg/kg/day (ADJ) mcL/kg/day IR/kg/day BAU/kg/day Million Int'l Units/kg/day mL/m2/day L/m2/day mg/m2/day g/m2/day Units/m2/day mmol/m2/day mEq/m2/day mcg/m2/day kJ/m2/day Int'l Units/m2/day Million Units/m2/day kcal/m2/day ng/m2/day mg PE/m2/day milli-units/m2/day pg/m2/day KBq/m2/day MBq/m2/day GBq/m2/day mcL/m2/day mL/1.7m2/day L/1.7m2/day mg/1.7m2/day g/1.7m2/day Units/1.7m2/day mmol/1.7m2/day mEq/1.7m2/day mcg/1.7m2/day kJ/1.7m2/day Int'l Units/1.7m2/day Million Units/1.7m2/day kcal/1.7m2/day ng/1.7m2/day mg PE/1.7m2/day milli-units/1.7m2/day pg/1.7m2/day KBq/1.7m2/day MBq/1.7m2/day GBq/1.7m2/day mcL/1.7m2/day mL/oz/day L/oz/day mg/oz/day g/oz/day Units/oz/day mmol/oz/day mEq/oz/day mcg/oz/day kJ/oz/day Int'l Units/oz/day Million Units/oz/day kcal/oz/day ng/oz/day mg PE/oz/day milli-units/oz/day pg/oz/day KBq/oz/day MBq/oz/day GBq/oz/day mcL/oz/day IR/m2/day BAU/m2/day Million Int'l Units/m2/day Kilo Int'l Units/m2/day IR/1.7m2/day BAU/1.7m2/day Million Int'l Units/1.7m2/day Kilo Int'l Units/1.7m2/day IR/oz/day BAU/oz/day Million Int'l Units/oz/day Kilo Int'l Units/oz/day kJ/30 mL kcal/30 mL Gy-cm2 mcGy-cm2 mGy-cm2 cGy-cm2 dGy-cm2 mcGy-m2 mGy-m2 cGy-m2 dGy-m2 Gy-m2 mRAD-cm2 RAD-cm2 mL/cm2 mg/cm2 mOsmol each tablet capsule drop tsp puff suppository spray Squirt inch patch Act ampule Bar Bottle Can Device enema Gallon Inhaler kit lb lozenge oz packet Stick strip Tbsp Tube vial Wafer Container Syringe Package applicator cm Applicatorful Troche millicurie Intra Uterine Device Part m Film Million Cells Dose mm IR BAU kg cm2 Imperial Gallon kJ PFU Piece Million PFU Doses/Fill Cartridge Thousand Units Lipoprotein Lipase Releasing Unit Scoop Million Int'l Units mm2 Pump fluid ounce Product Bag mcmol 1e12 Vector Genomes Vector Genomes millicurie/kg millicurie/m2 millicurie/1.7m2 microcurie microcurie/kg microcurie/m2 microcurie/1.7m2 Canister mcg DFE Billion Cells Application Box Capful Inhalation Lancet Needle Pad Pen Piece of gum Ring Swab Sachet Implant Insert Pools Kilo Int'l Units Kilo Int'l Units/kg/day 1e11 Vector Genomes 1e13 Vector Genomes 1e14 Vector Genomes 1e15 Vector Genomes Cells EIN Million EIN EIN/kg/day mGy-cm cGy-cm dGy-cm Gy-cm mGy-m cGy-m dGy-m Gy-m Hounsfield Units None / Other
81	UM_REQ_RX_DAYS	NUMERIC	No
	The requested quantity limit number for days of the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
82	REQ_UM_MED_TIER_C_NAME	VARCHAR	No
	The requested tier for the current medication item. May contain organization-specific values: Yes
83	UM_MEDICATION_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
84	UM_NDC_ID	VARCHAR	No
	The NDC of the current medication item.
85	UM_NDC_ID_NDC_CODE	VARCHAR	No
	The external code for the National Drug Code (NDC). An NDC represents packages of medications.
86	UM_APRV_RX_QTY	NUMERIC	No
	The approved quantity limit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
87	UM_APRV_RX_DISP_QTYUNIT_C_NAME	VARCHAR	No
	The approved quantity limit unit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe. The category values for this column were already listed for column: UM_REQ_RX_DISP_QTYUNIT_C_NAME
88	UM_APRV_RX_DAYS	NUMERIC	No
	The approved quantity limit number for days of the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
89	APRV_UM_MED_TIER_C_NAME	VARCHAR	No
	The approved tier for the current medication item. The category values for this column were already listed for column: REQ_UM_MED_TIER_C_NAME
90	UM_CVG_GUIDANCE_POS_TYPE_C_NAME	VARCHAR	No
	The place of service type category ID for the coverage guidance request. May contain organization-specific values: Yes Category Entries: Telehealth - Provided in Patient's Home Office Home Assisted Living Facility Group Home Mobile Unit Temporary Lodging Walk-in Retail Health Clinic Place of Employment - Worksite Off Campus - Outpatient Hospital Urgent Care Facility Inpatient Hospital On Campus - Outpatient Hospital Emergency Room - Hospital Ambulatory Surgical Center Birthing Center Military Treatment Facility Outreach Site/Street Skilled Nursing Facility Nursing Facility Custodial Care Facility Hospice Adult Living Care Facility Ambulance - Land Ambulance - Air or Water Independent Clinic Federally Qualified Health Center Inpatient Psychiatric Facility Psychiatric Facility - Partial Hospitalization Community Mental Health Center Intermediate Care Facility/ Individuals with Intellectual Disabilities Residential Substance Abuse Treatment Facility Psychiatric Residential Treatment Center Non-residential Substance Abuse Treatment Facility Non-residential Opioid Treatment Facility Mass Immunization Center Comprehensive Inpatient Rehabilitation Facility Comprehensive Outpatient Rehabilitation Facility End-Stage Renal Disease Treatment Facility Programs of All-Inclusive Care for the Elderly (PACE) Center Public Health Clinic Rural Health Clinic Independent Laboratory Other Place of Service Pharmacy Telehealth - Provided Other than in Patient's Home School Homeless Shelter Indian Health Service Free-standing Facility Indian Health Service Provider-based Facility Tribal 638 Free-standing Facility Tribal 638 Provider-based Facility Prison/Correctional Facility
91	UM_FORMULARY_QL_QUANTITY	NUMERIC	No
	The formulary quantity limit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
92	UM_FORMULARY_QL_DISP_QTYUNIT_C_NAME	VARCHAR	No
	The formulary quantity limit unit for the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe. The category values for this column were already listed for column: UM_REQ_RX_DISP_QTYUNIT_C_NAME
93	UM_FORMULARY_QL_DAYS	NUMERIC	No
	The formulary quantity limit number for days of the current medication item. Quantity limit refers to the maximum amount of medication that can be dispensed to a patient within a specific timeframe.
94	UM_FORMULARY_UM_MED_TIER_C_NAME	VARCHAR	No
	The formulary tier for the current medication item. The category values for this column were already listed for column: REQ_UM_MED_TIER_C_NAME
95	UM_CVG_GDNC_CVRD_MEM_BENEFIT_C_NAME	VARCHAR	No
	The benefit check result from the requested coverage guidance. May contain organization-specific values: No Category Entries: Not Covered Covered Potentially Covered – Criteria Not Met