myAvatar Cal-PM Data Trail tables

► Client Management

► Call Intake

SYSTEM.call_intake_financial_inv
SYSTEM.call_intake_history
SYSTEM.patient_current_demographics
SYSTEM.patient_demographic_history
SYSTEM.site_specific_call_intake

► Pre Admit

SYSTEM.admission_data
SYSTEM.admission_practitioner
SYSTEM.admission_preadmit_data
SYSTEM.episode_history
SYSTEM.patient_current_demographics
SYSTEM.patient_demographic_history
SYSTEM.site_specific_pre_admission

► Pre Admit Discharge

SYSTEM.discharge_data
SYSTEM.patient_current_demographics

► Admission

SYSTEM.admission_data
SYSTEM.admission_data_other
SYSTEM.admission_practitioner
SYSTEM.discharge_alert_data
SYSTEM.episode_history
SYSTEM.history_attending_practitioner
SYSTEM.history_bed_assignment
SYSTEM.history_partial_hosp
SYSTEM.patient_current_demographics
SYSTEM.patient_demographic_history
SYSTEM.site_specific_admission

► Admission (Outpatient)

SYSTEM.admission_data
SYSTEM.admission_data_other
SYSTEM.admission_practitioner
SYSTEM.discharge_alert_data
SYSTEM.episode_history
SYSTEM.history_attending_practitioner
SYSTEM.history_bed_assignment
SYSTEM.history_partial_hosp
SYSTEM.patient_current_demographics
SYSTEM.patient_demographic_history
SYSTEM.site_specific_admission

► Discharge

SYSTEM.discharge_data
SYSTEM.patient_current_demographics

► Account Management

Financial Eligibility

SYSTEM.billing_guar_comments
SYSTEM.billing_guar_data
SYSTEM.billing_guar_emp_data
SYSTEM.billing_guar_order_cur_ep
SYSTEM.billing_guar_subs_data
SYSTEM.billing_plan_assigned

Managed Care Authorizations

SYSTEM.history_managed_care_auths

► Patient Notification Menu

Patient Notification

SYSTEM.user_patient_notifications

Emergency Contact Information

SYSTEM.user_emergency_contact_informa

Parent/Guardian Information

SYSTEM.user_parent_guardian_informati

Next Of Kin

SYSTEM.user_next_of_kin

Other Practitioner Assignment

SYSTEM.user_practitioner_assignment

► Family and UMDAP Management

Family Registration

SYSTEM.family_current_demographics
SYSTEM.family_membership_information
SYSTEM.family_umdap_info
SYSTEM.site_specific_family

► Client Information

Update Client Data

SYSTEM.patient_current_demographics

Diagnosis

SYSTEM.history_diagnosis

Outside Providers

SYSTEM.user_outside_providers

Patient Conditions

SYSTEM.user_patient_conditions

Substance Abuse History

SYSTEM.user_substance_abuse_history

Previous HealthCare Services

SYSTEM.user_previous_healthcare_tx

► Practitioner

► Practitioner Registration

Practitioner Enrollment

SYSTEM.site_specific_staff_enrollment
SYSTEM.staff_enrollment_history

Practitioner Termination

SYSTEM.site_specific_staff_term
SYSTEM.staff_termination_history

► Practitioner Information

Offices Held

SYSTEM.user_staff_offices

CME Activities

SYSTEM.user_staff_cme

Dues Payments

SYSTEM.user_staff_dues

► Services

► Ancillary/Ambulatory Services

Client Charge Input

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

Client Charge Input (Charge Fee Access)

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

Client Charge Input With Diagnosis Entry

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

Client Charge Input (Charge Fee Access and Diagnosis Entry)

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

Edit Service Information

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

Edit Service Information (Charge Fee Access)

SYSTEM.billing_tx_history
SYSTEM.site_specific_tx_history
SYSTEM.staff_tx_history

► Billing

► Bill Production

Electronic Re-Billing Service Assignment

SYSTEM.billing_rebill_tx_assign

Inhibit Billing By Service

SYSTEM.billing_tx_history

► Remittance Processing

Claim Follow-Up

SYSTEM.claim_follow_up
SYSTEM.claim_follow_up_data

► System Maintenance

► Client Maintenance

Wait List Management

SYSTEM.wait_list

► System Definition

Benefit Plans

SYSTEM.billing_plan_table
SYSTEM.billing_plan_table_levels

Guarantors/Payors

SYSTEM.billing_guar_table

Service Codes

SYSTEM.billing_tx_master_table
SYSTEM.billing_tx_xref_table

Service Fee/Cross Reference Maintenance

SYSTEM.billing_tx_max_liab_by_guar
SYSTEM.billing_tx_master_fee_table

Program Maintenance

SYSTEM.table_program_definition