FRONT_END_PMT_COLL_HX
Description:
This table stores information about front-end collection actions taken through point of sale (POS) payment posting or refund workflows.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 COLL_INSTANT_UTC_DTTM DATETIME (UTC) No
The instant that this event occurred.
5 COLL_WORKFLOW_TYPE_C_NAME VARCHAR No
The workflow in which this event took place.
May contain organization-specific values: No
Category Entries:
Other
Registration
Pre-Admission
Admission
Discharge
Sign-In
Check-In
Check-Out
Update Admission
Update Discharge
HOV
Scheduling Registration
L&D Assessment
L&D Update Admission
ED Update Admission
Newborn Admission
Newborn Update Admission
ED Admission
ED Discharge
6 LOGIN_DEPARTMENT_ID NUMERIC No
The unique ID of the department which a user was logged into at the time of this event.
7 ENC_DEPARTMENT_ID NUMERIC No
The unique ID of the encounter department associated with this event.
8 RSN_NON_COLL_AMT_C_NAME VARCHAR No
The non-collection reason category ID for this event.
May contain organization-specific values: Yes
Category Entries:
Other (Requires Comment)
Unable to Pay
Refused To Pay
Payment Processing Error
Disputed Amount
Needed Urgent Care
Eligibility Issue
Financial Assistance
Requested Bill
Unavailable for Payment
Has Secondary Insurance
Waived Amount
Visit Auto Pay Declined
Payment Plan
9 RSN_NON_COLL_AMT_COMMENT VARCHAR No
The free text non-collection comment explaining why some portion of a due amount was not collected.
10 GUARANTOR_ACCOUNT_ID NUMERIC No
The unique ID of the guarantor who is associated with this event.
11 EVENT_TYPE_C_NAME VARCHAR No
The event type category ID that defines the type of payment event data that is stored in this row.
May contain organization-specific values: No
Category Entries:
Collection Event
Reason Storage Line
Give-Back
Reversal
Visit Auto Pay Cancellation
12 PB_COPAY_COLL NUMERIC No
The amount of professional billing copay that a user collected during this event.
13 PB_COPAY_PAID NUMERIC No
The amount of professional billing copay that had already been paid towards an encounter at the time of this event.
14 PB_COPAY_DUE NUMERIC No
The total amount of professional billing copay that is required for this visit at the time of this event.
15 HB_COPAY_COLL NUMERIC No
The amount of hospital billing copay that a user collected during this event.
16 HB_COPAY_PAID NUMERIC No
The amount of hospital billing copay that had already been paid towards an encounter at the time of this event.
17 HB_COPAY_DUE NUMERIC No
The total amount of hospital billing copay that is required for this visit at the time of this event.
18 PB_PREPAY_COLL NUMERIC No
The amount of professional billing prepayment that a user collected.
19 PB_PREPAY_PAID NUMERIC No
The amount of professional billing prepayment that had already been paid towards an encounter at the time of this event.
20 PB_PREPAY_DUE NUMERIC No
The total amount of professional billing prepayment that is required for this visit at the time of this event.
21 HB_PREPAY_COLL NUMERIC No
The amount of hospital billing prepayment that a user collected during this event.
22 HB_PREPAY_PAID NUMERIC No
The amount of hospital billing prepayment that had already been paid towards an encounter at the time of this event.
23 HB_PREPAY_DUE NUMERIC No
The total amount of hospital billing prepayment that is required for this visit at the time of this event.
24 PB_PREV_BAL_COLL NUMERIC No
The amount of professional billing previous balance that a user collected during this event.
25 PB_PREV_BAL_PAID NUMERIC No
The amount of professional billing previous balance that had already been paid towards this guarantor's outstanding balance during the day of this event.
26 PB_PREV_BAL_DUE NUMERIC No
The amount of self-pay professional billing outstanding balance that a guarantor owed at the time of this event.
27 HB_PREV_BAL_COLL NUMERIC No
The amount of hospital billing previous balance that a user collected during this event.
28 HB_PREV_BAL_PAID NUMERIC No
The amount of hospital billing previous balance that had already been paid towards this guarantor's outstanding balance during the day of this event.
29 HB_PREV_BAL_DUE NUMERIC No
The amount of self-pay hospital billing outstanding balance that a guarantor owed at the time of this event.
30 PREPAY_DISCOUNT_OFFERED NUMERIC No
The total amount of the prepay discount that was offered for this visit at the time of this event.
31 VIS_BAL_COLL NUMERIC No
The amount of visit balance that a user collected during this event.
32 VIS_BAL_PAID NUMERIC No
The amount of the visit balance that had already been paid towards an encounter at the time of this event.
33 VIS_BAL_DUE NUMERIC No
The total amount of the visit balance that is required for this visit at the time of this event.