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.