HSP_ACCT_STMT_HX

Description: |
This table contains hospital account statement history information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
2 | LINE | INTEGER | No |
This column stores the line number in the results of a query. Because multiple statements and detail bills can be sent for one hospital account, each statement or detail bill will have a unique line number. Note: This table includes information on demand statements and detail bills. Detail bills are sent at the hospital account level. Statements can be sent at the guarantor or hospital account level. When statements are sent at the guarantor level, a statement entry is made for each hospital account for which the guarantor is responsible.
3 | STMT_HX_DATE | DATETIME | No |
The date on which a statement or detail bill was sent.
4 | TOTAL_PAYMENTS | NUMERIC | No |
The total payments that appeared on a statement or detail bill.
5 | NEW_PAYMENTS | NUMERIC | No |
The total new payments that appeared on a statement. This column does not apply to detail bills.
6 | TOTAL_ADJUSTMENTS | NUMERIC | No |
The total adjustments that appeared on a statement or detail bill.
7 | TOTAL_DUE | NUMERIC | No |
The total due that appeared on a statement or detail bill.
8 | ACCT_SLFPYST_HA_C_NAME | VARCHAR | No |
The self pay status of the hospital account.
May contain organization-specific values: No
Category Entries:
Full Self-Pay Due
Review
Payment Plan
Pre-collection
Bad Debt
Prorated
9 | TOTAL_BALANCE | NUMERIC | No |
The total hospital account balance that appeared on this statement or detail bill.
10 | PREV_INS_BAL | NUMERIC | No |
This item stores the previous insurance balance for this hospital account shown on a statement.
11 | CUR_INS_BAL | NUMERIC | No |
This item holds the current insurance balance for this hospital account shown on a statement.
12 | PB_PREV_BAL | NUMERIC | No |
This column stores the previous professional patient balance that appeared on a statement. This column only applies if single billing office is enabled. This column does not apply to detail bills.
13 | PB_TOTAL_CHARGES | NUMERIC | No |
This column stores the total professional charges that appeared on a statement or detail bill. This column only applies if single billing office is enabled.
14 | PB_NEW_CHARGES | NUMERIC | No |
This column stores the total new professional charges that appeared on a statement. This column only applies if single billing office is enabled. This column does not apply to detail bills.
15 | PB_TOTAL_PAYMENTS | NUMERIC | No |
This column stores the total professional payments that appeared on a statement or detail bill. This column only applies if single billing office is enabled.
16 | PB_NEW_PAYMENTS | NUMERIC | No |
This column stores the total new professional payments that appeared on a statement. This column only applies if single billing office is enabled. This column does not apply to detail bills.
17 | PB_TOTAL_ADJSTMNTS | NUMERIC | No |
This column stores the total professional adjustments that appeared on a statement or detail bill. This column only applies if single billing office is enabled.
18 | PB_NEW_ADJUSTMENTS | NUMERIC | No |
This column stores the total new professional adjustments that appeared on a statement. This column only applies if single billing office is enabled. This column does not apply to detail bills.
19 | PB_TOTAL_DUE | NUMERIC | No |
This column stores the total professional amount due that appeared on a statement or detail bill. This column only applies if single billing office is enabled.
20 | PB_TOTAL_BALANCE | NUMERIC | No |
This column stores the total professional patient balance that appeared on a statement or detail bill. This column only applies if single billing office is enabled.
21 | PB_PREV_INS_BAL | NUMERIC | No |
This item stores the previous professional insurance balance for this hospital account shown on a statement. This column only applies if single billing office is enabled.
22 | PB_CUR_INS_BAL | NUMERIC | No |
This item stores the current professional insurance balance for this hospital account shown on a statement. This column only applies if single billing office is enabled.
23 | STMT_DET_BILL_FLG_C_NAME | VARCHAR | No |
Denotes whether a document sent was a statement or a detail bill.
May contain organization-specific values: Yes
Category Entries:
Hospital Account Detail Bill
Statement
Guarantor Detail Bill
Claim Detail Bill
24 | STMT_COLL_STS_C_NAME | VARCHAR | No |
Stores the collection status of the hospital account on a particular statement.
May contain organization-specific values: No
Category Entries:
Active AR
External AR
Bad Debt
Outsourced
Received Self-Pay Active AR
Received Self-Pay External AR
Received Self-Pay Bad Debt
25 | STMT_COLL_AGENCY_ID | NUMERIC | No |
Stores the collection agency of the hospital account on a particular statement.
26 | STMT_COLL_AGENCY_ID_COLL_AGENCY_NAME | VARCHAR | No |
The name of the collection agency.
27 | STMT_DVRY_MTD_C_NAME | VARCHAR | No |
Stores how the statement/detail bill was delivered.
May contain organization-specific values: No
Category Entries:
Paper, No Electronic Notification
Paperless, No Electronic Notification
Paper and Electronic Notification
Paperless, Electronic Notification
28 | STMT_HX_CNTST_BAL | NUMERIC | No |
Stores the contested balance on the statement.