AUT_PROC_DETAILS

Description:

This table contains procedure-level details about authorizations. The associated authorization information for the procedure can be found in the AUTHORIZATIONS table by joining the tables on the AUTH_ID columns. Child table AUT_PROC_MODS contains multiple rows of additional information related to each row in this table. You may join to this table on the AUTH_ID columns and AUT_PROC_DETAILS.LINE = GROUP_LINE from that table.

Primary Key

Column Name	Ordinal Position
AUTH_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	AUTH_ID	NUMERIC	No
	The authorization ID for the authorization record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	PROC_TYPE_C_NAME	VARCHAR	No
	Type of procedure information being authorized. A procedure authorization may be collected for a specific code, a code range, or a procedure component. May contain organization-specific values: No Category Entries: Group Free Text Range CPT(R)/HCPCS Discipline Default Authorization Level of Care
4	PROC_FREE_TEXT	VARCHAR	No
	Procedure (free text) being authorized.
5	PROC_RNG_START	VARCHAR	No
	Starting code of the code range
6	PROC_RNG_END	VARCHAR	No
	Ending code of the code range
7	PROC_COMP_ID	VARCHAR	No
	Procedure component being authorized. This column is frequently used to link to the CL_CMP table.
8	PROC_COMP_ID_COMPONENT_NAME	VARCHAR	No
	The name of the component
9	REV_CODE_ID	NUMERIC	No
	Procedure revenue code. This column is frequently used to link to the CL_UB_REV_CODE table.
10	REV_CODE_ID_REVENUE_CODE_NAME	VARCHAR	No
	The name of the revenue code.
11	PROC_PROV_ID	VARCHAR	No
	Provider associated with the authorization. This column is frequently used to link to the CLARITY_SER table.
12	PROC_CODE_ID	NUMERIC	No
	Item to track authorized Current Procedural Terminology (CPT)/Healthcare Common Procedure Coding System (HCPCS) codes.
13	PROC_DISCIPLINE_C_NAME	VARCHAR	No
	The Home Health and Hospice discipline category ID for the authorization. May contain organization-specific values: Yes
14	PROC_LEVELOFCARE_C_NAME	VARCHAR	No
	This column stores the hospice level of care that is authorized by this authorization period. This level of care is sourced from the hospice place of service table and is derived from the Medicare-defined list of hospice levels of care. May contain organization-specific values: No Category Entries: Routine Home Care Continuous Home Care Inpatient Respite Care General Inpatient Care Routine Home Care (Days 61+)
15	SRC_PROC_ID	NUMERIC	No
	Source procedure from which the authorization record has been created.
16	PROC_MED_ID	NUMERIC	No
	Stores the medication corresponding with the specified medication billing procedure.
17	PROC_SVC_TYPE_CODE_C_NAME	VARCHAR	No
	Procedure level service type override. May contain organization-specific values: No Category Entries: Medical Care Surgical Consultation Diagnostic X-Ray Diagnostic Lab Radiation Therapy Anesthesia Surgical Assistance Other Medical Blood Charges Used Durable Medical Equipment Durable Medical Equipment Purchase Ambulatory Service Center Facility Renal Supplies in the Home Alternate Method Dialysis Chronic Renal Disease (CRD) Equipment Pre-Admission Testing Durable Medical Equipment Rental Pneumonia Vaccine Second Surgical Opinion Third Surgical Opinion Social Work Diagnostic Dental Periodontics Restorative Endodontics Maxillofacial Prosthetics Adjunctive Dental Services Health Benefit Plan Coverage Plan Waiting Period Chiropractic Chiropractic Office Visits Dental Care Dental Crowns Dental Accident Orthodontics Prosthodontics Oral Surgery Routine (Preventive) Dental Home Health Care Home Health Prescriptions Home Health Visits Hospice Respite Care Hospital Hospital - Inpatient Hospital - Room and Board Hospital - Outpatient Hospital - Emergency Accident Hospital - Emergency Medical Hospital - Ambulatory Surgical Long Term Care Major Medical Medically Related Transportation Air Transportation Cabulance Licensed Ambulance General Benefits In-vitro Fertilization MRI/CAT Scan Donor Procedures Acupuncture Newborn Care Pathology Smoking Cessation Well Baby Care Maternity Transplants Audiology Exam Inhalation Therapy Diagnostic Medical Private Duty Nursing Prosthetic Device Dialysis Otological Exam Chemotherapy Allergy Testing Immunizations Routine Physical Family Planning Infertility Abortion AIDS Emergency Services Cancer Pharmacy Free Standing Prescription Drug Mail Order Prescription Drug Brand Name Prescription Drug Generic Prescription Drug Podiatry Podiatry - Office Visits Podiatry - Nursing Home Visits Professional (Physician) Anesthesiologist Professional (Physician) Visit - Office Professional (Physician) Visit - Inpatient Professional (Physician) Visit - Outpatient Professional (Physician) Visit - Nursing Home Professional (Physician) Visit - Skilled Nursing Facility Professional (Physician) Visit - Home Psychiatric Psychiatric - Room and Board Psychotherapy Psychiatric - Inpatient Psychiatric - Outpatient Rehabilitation Rehabilitation - Room and Board Rehabilitation - Inpatient Rehabilitation - Outpatient Occupational Therapy Physical Medicine Speech Therapy Skilled Nursing Care Skilled Nursing Care - Room and Board Substance Abuse Alcoholism Drug Addiction Vision (Optometry) Frames Routine Exam Lenses Nonmedically Necessary Physical Experimental Drug Therapy Burn Care Brand Name Prescription Drug - Formulary Brand Name Prescription Drug - Non-Formulary Independent Medical Evaluation Partial Hospitalization (Psychiatric) Day Care (Psychiatric) Cognitive Therapy Massage Therapy Pulmonary Rehabilitation Cardiac Rehabilitation Pediatric Nursery Skin Orthopedic Cardiac Lymphatic Gastrointestinal Endocrine Neurology Eye Invasive Procedures Gynecological Obstetrical Obstetrical/Gynecological Mail Order Prescription Drug: Brand Name Mail Order Prescription Drug: Generic Physician Visit - Office: Sick Physician Visit - Office: Well Coronary Care Private Duty Nursing - Inpatient Private Duty Nursing - Home Surgical Benefits - Professional (Physician) Surgical Benefits - Facility Mental Health Provider - Inpatient Mental Health Provider - Outpatient Mental Health Facility - Inpatient Mental Health Facility - Outpatient Substance Abuse Facility - Inpatient Substance Abuse Facility - Outpatient Screening X-ray Screening laboratory Mammogram, High Risk Patient Mammogram, Low Risk Patient Flu Vaccination Eyewear and Eyewear Accessories Case Management Dermatology Durable Medical Equipment Diabetic Supplies Generic Prescription Drug - Formulary Generic Prescription Drug - Non-Formulary Allergy Intensive Care Mental Health Neonatal Intensive Care Oncology Physical Therapy Pulmonary Renal Residential Psychiatric Treatment Transitional Care Transitional Nursery Care Urgent Care
18	MED_DIRECTOR_REV_REQ_YN	VARCHAR	No
	Does the procedure require a medical director review? May contain organization-specific values: No Category Entries: No Yes