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 Payer
COB/Reg/Eligibility Denial From Original Payer
Filing Order Incorrectly Entered
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 Payer
Supplemental Charge
CRNA Charge
Attached Insurance Payment/Adjustment
Patient Due and Paid Off
Same Payer, 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 Payer
Do Not Bill Insurance Charge
Same Payer, 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
Plan Swap
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.