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.