INFO_REQ_CNCT_INFO_TYPES
Description:
This table contains information about the types of information requested in an Additional Information Contact.

Primary Key
Column Name Ordinal Position
INFO_REQ_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 INFO_REQ_ID NUMERIC No
The unique identifier (.1 item) for the Additional Information Request record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 INFO_REQ_INFO_TYPE_C_NAME VARCHAR No
The types of information that were requested or received on this Additional Information Contact.
May contain organization-specific values: Yes
Category Entries:
Report Justifying Treatment Beyond Utilization Guidelines
Drugs Administered
Treatment Diagnosis
Initial Assessment
Functional Goals
Plan of Treatment
Progress Report
Continued Treatment
Chemical Analysis
Certified Test Report
Justification for Admission
Recovery Plan
Social Security Benefit Letter
Rental Agreement
Benefit Letter
Support Data for Verification
Allergies/Sensitivities Document
Autopsy Report
Ambulance Certification
Admission Summary
Purchase Order Attachment
Prescription
Physician Order
Benchmark Testing Results
Baseline
Blanket Test Results
Chiropractic Justification
Consent Form(s)
Drug Profile Document
Dental Models
Durable Medical Equipment Prescription
Diagnostic Report
Discharge Monitoring Report
Discharge Summary
Family Medical History Document
Health Certificate
Health Clinic Records
Immunization Record
State School Immunization Records
Laboratory Results
Medical Record Attachment
Nursing Notes
Operative Note
Oxygen Content Averaging Report
Orders and Treatments Document
Objective Physical Examination (including vital signs) Document
Oxygen Therapy Certification
Pathology Report
Patient Medical History Document
Periodontal Charts
Periodontal Reports
Parenteral or Enteral Certification
Physical Therapy Notes
Prosthetics or Orthotic Certification
Paramedical Results
Physician’s Report
Physical Therapy Certification
Cause and Corrective Action Report
Quality Report
Radiology Films
Radiology Reports
Report of Tests and Analysis Report
Renewable Oxygen Content Averaging Report
Symptoms Document
Death Notification
Photographs
5 INFO_DETAIL_TXT VARCHAR No
Additional description which further clarifies the type of information that was requested or received on this Additional Information Contact.