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	NUMERIC	No
	The procedure code associated with the transaction line.
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	NUMERIC	No
	The medication ID associated with the transaction line.
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	VARCHAR	No
	Stores the ID for the associated panel.
30	DEPARTMENT_ID	NUMERIC	No
	The department override associated with the transaction line.
31	POS_ID	NUMERIC	No
	The charge place of service associated with the transaction line.
32	RESEARCH_ID	VARCHAR	No
	The research study associated with the transaction line.
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.