HSP_DOC_PROV

Description:

This table contains hospital account transaction documentation provider information from the Hospital Permanent Transactions (HTR) master file.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	This column stores the unique identifier for the charge transaction.
2	LINE	INTEGER	No
	This column stores the line number in the results of a query. As multiple documentation providers can be associated with one charge, each charge will have a unique line number.
3	POST_DATE	DATETIME	No
	The post date of the charge.
4	SERV_AREA_ID	NUMERIC	No
	This column stores the unique identifier for the service area that is associated with the charge.
5	DOC_PROV_ID	VARCHAR	No
	This column stores the unique identifier for the documentation provider that is stored in the charge.
6	DOC_PRV_FUNC_HA_C_NAME	VARCHAR	No
	The function of the documentation provider that is stored in the charge. May contain organization-specific values: Yes Category Entries: Supervised Performed Assisted Observed Billing Provider Surrogate Provider Ordering Provider