HSP_ACCT_VALU_HAR
Description:
This table contains hospital account value 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 value codes can be stored in one hospital account, each value code will have a unique line number.
3 VALUE_CODE_C_NAME VARCHAR No
A value code stored in the hospital account.
May contain organization-specific values: Yes
4 VALUE_AMOUNT VARCHAR No
The monetary amount associated with a value code stored in the hospital account.