HSP_ACCT_SPAN_HAR

Description:

This table contains account claim pan codes information from the Hospital Account Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_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 occurrence span codes can be stored in one hospital account, each code will have a unique line number.
3	OCCURRENCE_SPAN_C_NAME	VARCHAR	No
	An occurrence span code stored in the hospital account. May contain organization-specific values: Yes
4	OCCUR_SPAN_F_DATE	DATETIME	No
	The date from which the occurrence span code stored in the hospital account applies.
5	OCCUR_SPAN_T_DATE	DATETIME	No
	The date until which the occurrence span code stored in the hospital account applies.