REG_HX_NOTES
Description:
This table contains information for tracking registration history event notes.

Primary Key
Column Name Ordinal Position
NOTE_ID 1

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier for the note record.
2 REG_HX_EVENT_C_NAME VARCHAR No
The Reg History event type category number for the Reg History event being tracked.
May contain organization-specific values: No
Category Entries:
Patient created
Patient encounter created
Patient encounter deleted
Visit hospital account assigned
Visit account assigned
Guarantor added to patient
Coverage added to patient
Guarantor removed from patient
Coverage removed from patient
Visit account removed
Visit coverage assigned
Visit coverage removed
Hospital account created
Patient verified
Encounter verified
Guarantor verified
Coverage verified
Coverage member verified
Hospital account verified
Hospital account verified - second stamp
Benefits verified for encounter
Coverage benefits verified for encounter
Guarantor created
Coverage added to guarantor
Coverage removed from guarantor
PB visit created
PB visit coverage list change
Coverage created
Coverage member line added
Coverage member line removed
Coverage effective date change
Professional filing order change
MSPQ filing order change
Hospital filing order change
Hospital account coverage list change
Member effective date change
Member lines merged
Address change
Confirmation error
3 REG_HX_OPEN_PAT_CSN NUMERIC No
The unique contact serial number for the contact of the open patient encounter at the time of the note creation.
4 REG_HX_ENTRY_DTTM DATETIME (UTC) No
The date and time when the note was created. If the date is null, the default value is 01/01/1900. If the time is null, the default value is 00:00.
5 REG_HX_USER_ID VARCHAR No
The unique ID of the user logged in when the note was generated.
6 REG_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 REG_HX_LOGIN_DEP_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
8 REG_HX_SRC_EAR_ID NUMERIC No
The unique ID of the account where an address change occurred in an address change event.
9 REG_HX_SRC_CVG_ID NUMERIC No
The unique ID of the coverage for which the subscriber's address changed in an address change event.
10 REG_HX_CITY_OLD VARCHAR No
The previous city for an address change event.
11 REG_HX_STATE_OLD_C_NAME VARCHAR No
The previous state for an address change event.
May contain organization-specific values: Yes
12 REG_HX_ZIP_OLD VARCHAR No
The previous ZIP/postal code for an address change event.
13 REG_HX_CNTRY_OLD_C_NAME VARCHAR No
The previous country for an address change event.
May contain organization-specific values: Yes
14 REG_HX_CNTY_OLD_C_NAME VARCHAR No
The previous county for an address change event.
May contain organization-specific values: Yes
15 REG_HX_HN_OLD VARCHAR No
The previous house number for an address change event.
16 REG_HX_DSTRCT_OLD_C_NAME VARCHAR No
The previous district for an address change event.
May contain organization-specific values: Yes
17 CONFRM_ERR_FINIS_YN VARCHAR No
Indicates whether the confirmation record that triggered a warning or error was a finish confirmation record.
May contain organization-specific values: No
Category Entries:
Yes
No
18 REG_HX_OLD_EFFFR_DT DATETIME No
The old effective-from date when a coverage-level effective date was changed. If the date is null, the default value is 01/01/1900.
19 REG_HX_NEW_EFFFR_DT DATETIME No
The new effective-from date when a coverage-level effective date was changed. If the date is null, the default value is 01/01/1900.
20 REG_HX_OLD_EFFTO_DT DATETIME No
The old effective-to date when a coverage-level effective date was changed. If the date is null, the default value is 01/01/1900.
21 REG_HX_NEW_EFFTO_DT DATETIME No
The new effective-to date when a coverage-level effective date was changed. If the date is null, the default value is 01/01/1900.
22 REG_HX_CITY_NEW VARCHAR No
The new city for an address change event.
23 REG_HX_STATE_NEW_C_NAME VARCHAR No
The new state for an address change event.
The category values for this column were already listed for column: REG_HX_STATE_OLD_C_NAME
24 REG_HX_ZIP_NEW VARCHAR No
The new ZIP/postal code for an address change event.
25 REG_HX_CNTRY_NEW_C_NAME VARCHAR No
The new country for an address change event.
The category values for this column were already listed for column: REG_HX_CNTRY_OLD_C_NAME
26 REG_HX_CNTY_NEW_C_NAME VARCHAR No
The new county for an address change event.
The category values for this column were already listed for column: REG_HX_CNTY_OLD_C_NAME
27 REG_HX_HN_NEW VARCHAR No
The new house number for an address change event.
28 REG_HX_DSTRCT_NEW_C_NAME VARCHAR No
The new district for an address change event.
The category values for this column were already listed for column: REG_HX_DSTRCT_OLD_C_NAME
29 REG_HX_VERF_ID NUMERIC No
The unique ID of the verification record associated with the verification event for this row. This column is frequently used to link to the VERIFICATION table.
30 REG_HX_FO_SOURCE_C_NAME VARCHAR No
The source of a filing order change.
May contain organization-specific values: No
Category Entries:
User Edit
MSPQ Responses
Manual Accept From WQ
Manual Reject From WQ
System Accept
System Reject
Manual Edit From WQ
Initial Population
Conversion
Hospital Account data push
Coverage updated at place of service
31 REG_HX_FO_REV_ACC_C_NAME VARCHAR No
The reason that a filing order change was accepted when it was reviewed.
May contain organization-specific values: Yes
Category Entries:
Other
Charges Not Triggered
Primary Coverage Unchanged
Self-Pay to Coverage
No Claims Sent to Original Payor
32 REG_HX_FO_REV_REJ_C_NAME VARCHAR No
The reason that a filing order change was rejected when it was reviewed.
May contain organization-specific values: Yes
Category Entries:
Not a Charge Transaction
Voided Transaction
Out Of Max Days Range
Already Retroadjudicated
Retroadjudication Not Needed
No Open System Batch
In Accepted Queue
In Rejected Queue
Orig Cvg Eff On Svc Dt
Same Cvg, Same Pln/Pln Grp
Same Payor
Supplemental Charge
CRNA Charge
Attached Insurance Payment/Adjustment
Patient Due and Paid Off
Same Payor, Same Plan
Retro Extension Error
Charge Bundled
Small Balance Due
Service Date Too Old
Small Insurance Due
Insufficient Security for Retro
Zero Charge
Matched Credit > 0
Invalid Acct Type
Reject All Chg Extension
Claim Submitted For Orig Payor
Do Not Bill Insurance Charge
Same Payor, Subscriber ID
Invalid Account Status
Dental Payment Plan Charge
Ambulatory Pharmacy Charge
Dental Predetermination Charge
No Effective Date
Bad Debt Transaction
Already Self-Pay
Charge Paid Off
Auto Profile Reject
Tax Charge
Auto Reject due to VFO Conversion
Home Infusion Adjudicated Charge
33 REG_HX_FO_RV_CER_ID VARCHAR No
The rule (CER) ID that an automatic filing order change was associated with.
34 REG_HX_FO_RV_CER_ID_RULE_NAME VARCHAR No
The name of the rule.
35 REG_HX_FO_WQ_ID VARCHAR No
The workqueue (WQF) ID that a filing order review change was associated with.
36 REG_HX_FO_WQ_ID_WORKQUEUE_NAME VARCHAR No
The name of the workqueue
37 REG_HX_FO_REV_CMT VARCHAR No
The free-text reason given by the user that a filing order change was made.