HSP_ACCT_OCUR_HAR
Description:
This table contains the Occurrence Codes and Occurrence Dates for a Hospital Accounts Receivable (HAR) record.

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 codes can be stored in one hospital account, each code will have a unique line number.
3 OCCURRENCE_CODE_C_NAME VARCHAR No
An occurrence code stored in the hospital account.
May contain organization-specific values: Yes
4 OCCURRENCE_DATE DATETIME No
The date associated with an occurrence code stored in the hospital account.