FIN_ASST_CASE_DOCS_HX
Description:
This Clarity table contains changes made to FA case documents.

Primary Key
Column Name Ordinal Position
FIN_ASST_CASE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FIN_ASST_CASE_ID NUMERIC No
The unique identifier (.1 item) for the case 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 DOCS_HX_INSTANT_DTTM DATETIME (UTC) No
The instant when the document was changed
4 DOCS_HX_USER_ID VARCHAR No
The unique ID of the user who modified the document
5 DOCS_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 DOCS_HX_DOCUMENT_ID VARCHAR No
The unique ID of the document that was changed
7 DOCS_HX_DOC_INFO_TYPE_C_NAME VARCHAR No
The display name of the document type
May contain organization-specific values: Yes
Category Entries:
Other
Waveform Strip
Annotation
Advance Directives and Living Will
Power of Attorney
HIPAA Notice of Privacy
National POLST Form
Clinical Unknown
Patient Photo
Study Attachment for Report
Study Attachment
DICOM Study
DICOM Series
DICOM Image
ECG
Spirometry
Holter
Authorization to Release Protected Health Information
HIM Release of Information Output
Kanta Informing
Kanta Consent to Data Sharing
Kanta Denial of Consent to Data Sharing
Kanta PikaXML CHF
Kanta GWN Disclosure Auth
Kanta Secondary Use Prohibition
Generated Form
Organ Donation Will
Living Will
Consent Form
Vaccine Information Statement
ABN Waiver
Discharge Instruction
Release of Information
Behavior Contract
Clinical References Attachment
External Medication Information Consent
After Visit Summary
Summary of Care
CMS IM for Patient Signature
CMS IM Copy of Signed
Detailed Notice of Discharge
Communication Verbal Consent
Referral Implied Consent
Unverified Proxy Video Visit After Visit Summary
Lab Result Scan
Lab Requisition Scan
Lab Result Document
Lab Managed Result Scan
Lab Managed Requisition Scan
Lab Instrument Image
Lab External Image
Encounter Dictation
History Dictation
Order Dictation
Clinician Jot
Clinical Note Import
View Private Medications Consent
FMK Med Card PDF
FMK Dose Dispensing PDF
Research Consent
Research Data Capture
Plan of Care E-Sig Form
Plan of Care Snapshot
CCAPS Profile Report PDF
Safety Plan
Hospice Election
EOB
Payment / Check
Historic Transaction
Historic Correspondence
Billing Correspondence
My Files Document
PDF Report
PDF Letter
Prov Comm E-Letter PDF
Prospective Auth
Dental Tooth Chart
Dental Baseline
Dental Perio Chart
Member Attachment
Coverage Attachment
Coverage ID Card
Coverage Enrollment Application
Coverage COB Information
AP Claim Attachment
AP Claim Image
Vendor Contract Attachment
Vendor Attachment
Benefit Plan Attachment
CRM Attachment
Appeal or Grievance Attachment
PB Account Attachment
Referral Attachment
Referral Notification Document
Authorization Notification Document
Payer Notification Document
Provider Attachment
Employer Group Attachment
Case Management Attachment
Broadcast Message Attachment
Member Appointment of Representative Form
Tapestry Payer Exchange Clinical Attachment
Managed Care Periodic Explanation of Benefits
Managed Care Periodic Summary EOB
Biometric Enrollment
PDR Authorization
PDR Disclaimer
MOON
Obsolete Type 1
Community Upload
Account Request Attachment
HH Care Summary
Proof of Assets
Proof of Expenses
Patient Entered Attachment
Patient Entered Drawing
MyChart COVID-19 Vaccination Record Document
MyChart Test Results Record Document
Electronic Prior Authorization Attachment
Sent via Secure Chat
MDS CMS PDF
Unused
Self-Pay Consent
Estimate
Visit Auto Pay Consent
Financial Arrangement
Endoscopy Image
Endoscopy Anatomical Diagram
Child Resistant Cap Waiver
Rx Prescription
Rx Prescription Sale E-Signature
Rx Prescription Dispense Customer ID
Rx Dispense Prep Image
Rx CNR Image
ED Patient Billing Extract
Imaging Order
Key Image Object
Screening Form
Annotated Cardiology Image
Archived Procedural Result
IRF-PAI
THL Form Filler
Derm Clinical Image
Pedigree Image
Occ Med Form
CE Point of Care Auth
CE Prospective Auth
CE Persistent Point of Care Auth
CE Auth Form (Scanned)
System-Retrieved CE Auth Form
E-Signed CE Auth Form
PDF CE Auth Form
CE Attachment
MyChart-Signed CE Auth Form
Document Generation Template
External Administration
External Clinical
External Billing
External Insurance Card
External Insurance-Related Form
External Patient Consent
External ROI / HIM Consent
External Legal Document
External Living Will
External DNR
External Power of Attorney
External Legal Letter
External Driver's License
External Birth Certificate
External Death Certificate
External Misc Administration
External Medication
External Medication Order Report
External Medication Reconciliation
External Prescription List
External Radiology and Imaging
External Cardiology Imaging
External Endoscopy Imaging
External OB/GYN Imaging
External Dental Imaging
External Oncology Imaging
External Lab
External Procedure
External Referral Request / Referral Report
External Other Order
External Note
External Consult Note
External H&P Note
External Progress Note
External Procedure Note
External Operative Note
External Nurse Note
External ED Note
External Cardiology Note
External GI Note
External Oncology Note
External Behavior Health Note
External Referral Note
External Physical Therapy Note
External Occupational Therapy Note
External OB/GYN Note
External Clinical Consent
External Procedure Consent
External Anesthesia Consent
External Surgical Consent
External Abortion Consent
External Sterilization Consent
External Organ Donation Consent
External Research Consent
External Photographic Image
External Wound Care Image
External Dermatology Image
External Plastic Surgery Image
External Flowsheet
External Physician Letter
External Patient Summary
External Discharge Summary
External Transfer Summary
External Immunization Summary
External Labor and Delivery Summary
External Physical Therapy Summary
External Occupational Therapy Summary
External After Visit Summary
External Patient Reported Information
External Questionnaire
External Patient Upload
External Patient History
External Patient Education and Instructions
External Discharge Instructions
External Evaluation and Plan
External Transplant Evaluation
External Risk Assessment
External Physical Therapy Treatment Plan
External Occupational Therapy Treatment Plan
External Oncology Treatment Plan
External Case Management
External Episode Summary
External Surgical Treatment Plan
External Misc Clinical
Auto-filled Result Image
Waiver of Liability for Claim Appeal
AN Patient Billing Extract
Hospice Non-Covered Documentation
Face Sheet Capture
Patient-Created Image
Patient-Created Audio
Patient-Created Video
Patient-Created Text
Continuing Care Options
Continuing Care Preferences
Dental Soft Tissue
Obsolete Type 2
8 DOCS_HX_ACTION_C_NAME VARCHAR No
The action category ID that was taken on the document.
May contain organization-specific values: No
Category Entries:
User created a document
Patient created and submitted a document via patient portal
Verified a patient-submitted document
Rejected a patient-submitted document
Removed a document from the case
Attached a preexisting document to the case
Detached a document from the case
Changed the attachment level (patient or case)
Changed the document status
Patient e-signed a document