HSP_PRE_AR_SESSION

Description:

This table stores single response items for temporary hospital billing transactions. This table is limited to charge temporary transactions that have not yet been posted to the account.

Primary Key

Column Name	Ordinal Position
HTT_ID	1

Column Information

	Name	Type	Discontinued?
1	HTT_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	TX_TYPE_HA_C_NAME	VARCHAR	No
	This item indicates the type of temporary transaction record. This is used by the Hospital Billing filer to determine how to process the record. May contain organization-specific values: No Category Entries: Charge Payment Debit Adjustment Credit Adjustment Placeholder - Not Used Action - Initiate Billing Action - Undo Billing Action - Late Charge Replacement Action - Next Responsible Party Action - Undo Next Responsible Party Action - Late Charge Write Off Action - Interim Billing Action - Late Charge Addition Action - Transfer to Self Pay Action - Undo NRP and TTSP Action - Initiate Homing Action - Interim Homing Action - Initiate RAP Action - Undo all Billing, NRP, and TTSP actions Action - Send to Separate Billing Service Area Action - Return from Separate Billing Service Area Action - Initiate Notice of Hospice Election Action - Initiate Notice of Hospice Revocation Action - Split Mixed HAR Action - Admission Day Billing Action - Secondary RAP Action - Duplicate and Send Charges Action - Run HB Pricing Contracts Action - Undo NRP Back to Selected Bucket Action - DBC Send Partial Denial to Self-Pay Action - DBC Ignore Partial Denial Action - Evaluate Bad Debt/External AR for Bucket Action - Automate Coverage Change Action - Undo Billing and Sync Guarantor Coverages Action - Undo Billing and Refresh Guarantor Coverages
3	TX_SOURCE_C_NAME	VARCHAR	No
	This item contains the source for this transaction. May contain organization-specific values: No Category Entries: Transaction Import Interface EpicCare Daily Charge Bed Charge Batch Charge Entry Unit Charge Entry Payment Posting Adjustment Posting Post Adjustment - Account Maintenance Reverse Transaction - Account Maintenance Reversal and Repost Charge Correction Order Trigger Transfer Transaction Combine Accounts Electronic Remittance HB Only Quick Payment Posting Account Maintenance - Actions Revenue Reclassification - Account Class Change Revenue Reclassification - Financial Class Change Claims Accept - Bucket Split Small Balance Write-Off System Auto Action Hourly Charge Expected Not-Allwd-Auto Write-Off Claim Denial Payment Willow Inpatient Refund - Account Maintenance OpTime Radiant MyChart Web EpicCare Inpatient Resolute Professional Billing Emergency Dept Home Health Lab Cohort Enterprise Payment Posting Charge Router Charge Entry Self-Pay Discount Payment Collection Late Fee Tx Report - Add Corresponding Charge Patient Refund Welcome Cardiology Obstetrics Handheld Late Charge Write-Off Hospice Per Diem Hospice Surcharge Adjustment Import DBC Product DBC Accepted Invoice Willow Ambulatory Anesthesia Reverse Transaction - Tx Report Billing Activity Web Service HB Coding Auto Pay Payment Plan Distribution Claim Accept - Balancing Adjustment Duplicated Charge Billing Charge Write-Off Transaction Classification Balancing Financial Assistance Cumulative Billing MyChart Mobile Pay as Guest Unbilled Expected Write-Off DBC Denied Invoice Bundle Payment Distribution DBC Denied Invoice - Ignored Balance Transfer In Balance Transfer Out Balance Correct In Balance Correct Out Visit Auto Pay Trust Transfer Trust Recurring Payment Notification Billing Advance Billing Two-Way SMS Linked Procedure Coverage Automation - Plan Change Estimate Variance Write-Off Multi-Instance Consolidated Balances Beans Compass Rose
4	SERV_AREA_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
5	HSP_ACCOUNT_ID	NUMERIC	No
	Stores the hospital account associated with the transaction.
6	PAT_ENC_CSN_ID	NUMERIC	No
	Patient CSN associated with the transaction.
7	RESEARCH_STUDY_ID_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
8	RSH_CHG_ORIG_HSP_ACCOUNT_ID	NUMERIC	No
	Stores the hospital account for the patient enrolled in the research study, which the charges were generated from before being billed to the study account.
9	SERVICE_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
10	BILLING_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
11	COST_CENTER_ID	NUMERIC	No
	Stores the cost center to which this transaction is being attributed.
12	COST_CENTER_ID_COST_CENTER_NAME	VARCHAR	No
	The name of the cost center.
13	SERVICE_DATE	DATETIME	No
	The date of service or deposit associated with the transaction.
14	REFUND_AP_DATE	DATETIME	No
	Stores the date on which the A/P system processed the transaction.
15	REFUND_AP_STATUS_C_NAME	VARCHAR	No
	Stores the action taken by the A/P system when it processed the transaction. May contain organization-specific values: No Category Entries: Approved Rejected
16	ACCT_CLASS_HA_C_NAME	VARCHAR	No
	Holds the account class of the account when offsetting system adjustments are created. For all other transactions, this item is not set and instead the corresponding posted transaction values are calculated at the time of filing. May contain organization-specific values: Yes
17	ACCT_FIN_CLASS_C_NAME	VARCHAR	No
	Holds the financial class of the account when offsetting system adjustments are created. May contain organization-specific values: Yes Category Entries: Commercial Medicare Medicaid Self-Pay Worker's Comp Tricare Champva Group Health Plan FECA Black Lung Blue Shield Medigap Other DK Regional Client Received Self-Pay Sent to Consolidated Self-Pay Patient Assistance Program
18	PRIMARY_COVERAGE_ID	NUMERIC	No
	Holds the primary coverage of the account when offsetting system adjustments are created.
19	PRIMARY_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
20	PRIMARY_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
21	TOTAL_CHARGE_AMT	NUMERIC	No
	Stores the total price amount for the charges in this session.
22	ORDER_ID	NUMERIC	No
	Stores the ID of the order associated with the charge.
23	TREATMENT_PLAN_CSN	NUMERIC	No
	The contact serial number of the treatment plan that generated this charge session and order.
24	TREATMENT_DAY_CSN	NUMERIC	No
	The contact serial number of the treatment day that generated this charge session's order.
25	OPTIME_LOG_ID	VARCHAR	No
	Stores the identifier of the OpTime Log associated with this charge.
26	SYS_RECLASS_RSN_C_NAME	VARCHAR	No
	Stores the reclassification reason for a transaction reposted for system reasons. May contain organization-specific values: No Category Entries: Financial Class Change Account Class Change Primary Payor or Plan Change Mark/Unmark Account for Seperate SA Billing Surcharge Recalculation Pricing Contract Reprice Forced Repost Rev Code/Non-Covered Flag/Price Change Bundled Episode Change Register Number Change Fee Decision Change Coverage Automation Plan Change Service Decision Change
27	REVERSAL_RSN_C_NAME	VARCHAR	No
	Holds the reversal reason. This is set for all transaction types. May contain organization-specific values: Yes Category Entries: CCI Edit No Supporting Documentation Service Not Performed Self-Pay Reconciliation Across Systems Payment Received Returned Mail Other Duplicate Posted in Error Wrong Code Give Back
28	CONTEST_RSN_C_NAME	VARCHAR	No
	Stores the contested reason. This is set only for charges. May contain organization-specific values: Yes Category Entries: Account Has Contested Charges Patient Not Seen Bankruptcy Legal Deceased Not Informed Service Not Covered Service Not Provided Insurance Appeal Patient Grievance Other
29	CONTEST_RESOLUTION_RSN_C_NAME	VARCHAR	No
	Stores the resolution reason. This is set only for charges. May contain organization-specific values: Yes Category Entries: Transfer All Charges Resolved Contested in Error Confirmed Billed Correctly Patient No Longer Contesting Insurance Issue Resolved Problem Fixed
30	NO_PAY_CLAIM_TYPE_C_NAME	VARCHAR	No
	If this charge was posted to drive no-pay claims to be generated, this charge is intended to file and bill immediately. These claims will have different types/purposes. This column defines the type of claim that should be generated for the bucket that holds this charge. May contain organization-specific values: No Category Entries: SNF No-Pay Claim SNF Exhaust Claim HH No-Pay RAP HH Notice of Admission
31	BAD_DEBT_FLAG_YN	VARCHAR	No
	This column marks the account's A/R as belonging to bad debt. 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
32	POS_SESSION_IDENT	VARCHAR	No
	Point of Sale session ID.
33	POS_TX_IDENT	VARCHAR	No
	Point of Sale transaction ID.
34	POS_TX_LINENUM	INTEGER	No
	Point of Sale transaction line number.
35	TAX_EFFECTIVE_DATE	DATETIME	No
	Stores the date used in the system that determine when this tax line went into effect.
36	TAXABLE_AMT	NUMERIC	No
	This column stores the amount that the tax is applied to.
37	TAX_PERCENT	NUMERIC	No
	Percent used to calculate the tax amount.
38	TAX_AMOUNT	NUMERIC	No
	This column stores the amount used for the tax.
39	SURCHARGE_CLAIM_PRINT_ID	NUMERIC	No
	The unique identifier of the claim print record associated with the surcharge amount of this transaction.
40	TAX_RATE_DEF_CSN	NUMERIC	No
	The tax rate definition CSN used in the tax calculation.
41	DEFAULT_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
42	POS_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
43	EXTERN_AR_FLAG_YN	VARCHAR	No
	This column marks the account's A/R as belonging to an agency. The category values for this column were already listed for column: BAD_DEBT_FLAG_YN