HSP_ACCT_RFV_LIST
Description:
This table contains hospital account reason for visit diagnosis 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
The ID number of the hospital account.
2 LINE INTEGER No
The line number for the reason for visit diagnosis. Multiple reason for visit diagnoses can occur on one hospital account, so each diagnosis has a unique line number.
3 RFV_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.