REG_EVENT_LOGGING
Description:
This table holds information related to event logging in Registration.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 REG_EVENT_LOG_C_NAME VARCHAR No
Reg Event. This holds the type of Reg event, like Patient Creation, HAR Creation etc.
May contain organization-specific values: Yes
Category Entries:
Patient Creation
Reg Contact Creation
HAR Creation
Guarantor Added
Coverage Added
ADT Contact Creation
4 REG_EVENT_TIME_DTTM DATETIME (Local) No
Date/time when the Reg Event occurred.
5 REG_EVNT_JUMP_FRM_C_NAME VARCHAR No
The user's activity before the Reg Event occurred.
May contain organization-specific values: Yes
Category Entries:
Scheduling
Professional Billing
Registration
OpTime Case Check In
Charge Entry (PB)
Payment Posting (PB)
Account Maintenance (PB)
Claim Edit (PB)
Retro Review Workqueue (PB)
Newborn Admission
Registration New Patient Wizard
Case Edit/Creation (PB)
Registration Copy Patient Wizard
Registration MSP Wizard
Scheduling Account Selection
Admission
Preadmission
ED Arrival
L&D Assessment
Hospital Outpatient Visit
Transfer
Update Admission
Discharge
ED Roomed
ED Update Admission
L&D Update Admission
L&D Newborn Update Admission
Requisition Entry
Registration Family Lookup Utility
Charge Router Charge Editor
Combined Reg Report
Update Discharge
COMMENTED REGISTRATION REPORT
Demographics Change Report
Incomplete Registration Report
Inactive Coverages Report
New Patient Report
Unassociated Visits Report
Registration Status Report
UCL Charge Capture
ED Module Admit
ED Module Discharge
Patient Identity Change Report
Claims
ADT Contract Registration
ADT ED Dismiss
Pre-Check In
Account Edit (PB)
Guarantor Identity Change Report
Task-based Registration
EMPI Reports
Registration Check In
Scheduling Before Appointment Entry
Registration Sign In
Registration Check Out
OB Module Discharge
Hospital Outpatient Discharge
ED Temp Pt Update
Scheduling After Appointment Entry
Home Health Intake
Hospice Intake
Hospice Discharge
Hospice Update
Leave of Absence Out
Leave of Absence Return
Registration Detailed View
Registration Walk In
Registration Benefits Collection
Billing Encounter
Outpatient Appointment Waiting List
Surgical Admit Waiting List
Day Admit Waiting List
Non-Surgical Admit Waiting List
Account Maintenance (HB)
Registration - Visit (PB)
Referral Entry
Appointment Request Registration
Pre-Sign In
Pre-Check Out
Patient Contact Registration
Home Infusion
Leave of Absence Update
OpTime Registration
OpTime ABN
Update HOV Discharge
Home Infusion Billing
Home Infusion Episode Update
MyChart Proxy Creation
Professional Billing Exchange Network
ADT Update ED Dismiss
6 REG_EVNT_CNCT_DAT FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the 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.