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
Dental
Anesthesia
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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
12 | PROC_CODE_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
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_PROC_NAME | VARCHAR | No |
The name of each procedure.
16 | PROC_MED_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
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