HSP_ACCT_DLY_CHGS

Description:

This table contains hospital account daily charge information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_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. As multiple daily charges can be performed on one hospital account, each daily charge will have a unique line number.
3	DLY_CHG_STS_HA_C_NAME	VARCHAR	No
	The status of a daily charge associated with the hospital account. Choices are Scheduled, Active, Completed, or Cancelled. May contain organization-specific values: No Category Entries: Scheduled Active Complete Cancelled
4	DLY_CHG_START_DATE	DATETIME	No
	The start date of a daily charge associated with the hospital account.
5	DLY_CHG_END_DATE	DATETIME	No
	The end date of a daily charge associated with the hospital account.
6	DLY_CHG_PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
7	DLY_CHG_PROC_DESC	VARCHAR	No
	The description of a daily charge associated with the hospital account.
8	DLY_CHG_QUANTITY	INTEGER	No
	The quantity of a daily charge associated with the hospital account. This is the quantity of a single procedure that the system will post each day for which the procedure is scheduled as a daily charge.
9	DLY_CHG_AMOUNT	NUMERIC	No
	The monetary amount of a daily charge associated with the hospital account.
10	DLY_CHG_COMMENT	VARCHAR	No
	A comment on a daily charge associated with the hospital account.