DENTAL_HB_EST_HX

Description: |
Dental procedure estimates history as calculated from the Hospital Billing (HB) estimates application programming interface (API).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique identifier for the finding record
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | DENT_HX_CALC_PRICE | NUMERIC | No |
The historical price of a dental procedure as calculated by the Hospital Billing application
4 | DENT_HX_ADJ_PRICE | NUMERIC | No |
The historical user-adjusted price of the dental procedure (Hospital Billing estimates only)
5 | DENT_HX_ADJ_REASN_C_NAME | VARCHAR | No |
The historical reason for a price adjustment for a dental procedure (Hospital Billing estimates only)
May contain organization-specific values: Yes
Category Entries:
Overridden from Enterprise Billing
Preserved from Previous Estimate
6 | DENT_HX_ADJ_COMMENT | VARCHAR | No |
The historical comment for the price adjustment for a dental procedure (Hospital Billing estimates only)
7 | DENT_HX_ADJ_USER_ID | VARCHAR | No |
Historical user that adjusted the estimate (Hospital Billing estimates only)
8 | DENT_HX_ADJ_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | DENT_HX_PAT_PORTION | NUMERIC | No |
Stores the historical patient portion of a dental procedure's price (used for Hospital Billing estimates only)
10 | DENT_HX_OUTDATED_YN | VARCHAR | No |
Stores whether a historical estimate value is flagged as out of date (used for Hospital Billing estimates only)
May contain organization-specific values: No
Category Entries:
No
Yes