HSP_PRE_AR_TX
Description:
This table contains hospital billing temporary transaction information. 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
LINE 2

Column Information
Name Type Discontinued?
1 HTT_ID NUMERIC No
The unique identifier for the transaction record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CHARGE_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
4 TX_COMMENT VARCHAR No
The comment associated with the transaction line.
5 CHARGE_DESCRIPTION VARCHAR No
The description of the procedure associated with the transaction line.
6 HCPCS_CODE VARCHAR No
The HCPCS Code associated with the transaction line.
7 NDC_ID VARCHAR No
The medication ID associated with the transaction line.
8 NDC_ID_NDC_CODE VARCHAR No
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
9 HIPPS_CODE VARCHAR No
The HIPPS Code associated with the transaction line.
10 HIPPS_CODE_TYPE_C_NAME VARCHAR No
The HIPPS code type associated with the transaction line.
May contain organization-specific values: No
Category Entries:
Skilled Nursing Facility PPS
Home Health PPS
NY Medicaid EPS
Other
11 MODIFIERS VARCHAR No
This column stores the modifiers for a procedure.
12 HIPPS_CODE_DESC VARCHAR No
The HIPPS code description associated with the transaction line.
13 MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
14 REV_CODE_ID NUMERIC No
The revenue code associated with the transaction line.
15 REV_CODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
16 SUP_ID VARCHAR No
The Supply ID associated with the transaction line.
17 SUP_ID_SUPPLY_NAME VARCHAR No
The name of the inventory item.
18 SERVICE_DATE DATETIME No
The column displays the service date associated with the transaction line.
19 PAT_ENC_CSN_ID VARCHAR No
The patient contact associated with the transaction line.
20 PX_MED_NECESSITY_YN VARCHAR No
Flag denoting whether or not the procedure is medically necessary.
May contain organization-specific values: No
Category Entries:
Yes
No
21 QUANTITY NUMERIC No
Stores the number of units or days that this procedure was performed.
22 PROC_START_DTTM DATETIME (Local) No
Stores the start date and time of the procedure.
23 PROC_END_DTTM DATETIME (Local) No
Stores the date and time that the procedure stopped.
24 TX_AMOUNT NUMERIC No
The charge amount associated with the transaction line.
25 DEFAULT_PRICE NUMERIC No
The default price associated with the transaction line.
26 DFLT_REV_CODE_ID NUMERIC No
The default revenue code associated with the transaction line.
27 DFLT_REV_CODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
28 DURATION_MINUTES INTEGER No
Stores duration of service in minutes for the transaction line.
29 PANEL_ID_PROC_NAME VARCHAR No
The name of each procedure.
30 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
31 POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
32 RESEARCH_ID_RESEARCH_STUDY_NAME VARCHAR No
The name of the research study record.
33 RSH_STUDY_SRC_C_NAME VARCHAR No
The research study source associated with the transaction line.
May contain organization-specific values: No
Category Entries:
User Entry
Set by Import/Interface
Set from Order
Set by Charge Router Handler
Set by Beaker Charge Bundler
Set by Charge Router Message
Set by System Based on Patient Encounter
Set by System Based on Patient Research Timeline
Set by System Based on Treatment Plan
Set by System Based on Treatment Plan Without Billing Match
Set by System Based on Encounter Service
Set by System
34 RSH_MOD_TYPE_C_NAME VARCHAR No
Charge line's research billing modifier type. Normally, research charges with this value set should file to the patient account in order to be billed to insurance.
May contain organization-specific values: Yes
Category Entries:
Routine
Investigational/Device
35 RSH_CHG_ROUTE_C_NAME VARCHAR No
This column specifies where to route the research charge.
May contain organization-specific values: No
Category Entries:
File to Study
File to Patient
36 REFERENCE_AMT NUMERIC No
Holds the reference amount that is calculated based on the financial class for the charge. This is set by the system and is applicable only to charges.
37 REFERENCE_AMT_SRC_C_NAME VARCHAR No
Holds the source of the reference amount that is used in the calculation of the reference amount. This is set by the system and is applicable only to charges.
May contain organization-specific values: No
Category Entries:
Reference Amount Fee Schedule
Charge Price
External Price
Reference Amount Override
38 INST_PAT_NAME VARCHAR No
The institutional patient name associated with the transaction line.
39 INST_BIRTH_DATE DATETIME No
The institutional patient date of birth associated with the transaction line.
40 INST_EMP_NUMBER VARCHAR No
The institutional employee number associated with the transaction line.
41 INST_SEX_C_NAME VARCHAR No
The legal gender for the institutional patient associated with the transaction line.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
42 INST_COMMENT VARCHAR No
A comment stored in a charge transaction. If a hospital account's guarantor is of a type that is considered institutional, then certain pieces of institutional billing-related information can be stored in charges filed on that hospital account.
43 INSTI_LINK_PAT_SN INTEGER No
A linked patient serial number stored in a charge transaction. If a hospital account's guarantor is of a type that is considered institutional, then certain pieces of institutional billing-related information can be stored in charges filed on that hospital account. A linked patient serial number is one such piece of information. It is the patient serial number from which the data in the institutional billing-related information was pulled by the user while filling in those fields.
44 SERVICE_AUTH_ID NUMERIC No
The CoCM service decision authorization record associated with this charge.
45 PANEL_DT DATETIME No
The contact date of the panel procedure that is associated with this transaction.
46 PANEL_DAT FLOAT No
The contact date of the panel procedure that is associated with this transaction, in decimal format. Used to link with the CLARITY_EAP_OT table.
47 RESEARCH_ENROLL_ID NUMERIC No
Research study association per charge line.