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

Primary Key
Column Name Ordinal Position
FINDING_ID 1

Column Information
Name Type Discontinued?
1 FINDING_ID NUMERIC No
The unique identifier for the finding record
2 DENTAL_CALC_PRICE NUMERIC No
The price of a dental procedure as calculated by the Hospital Billing application
3 DENTAL_ADJ_PRICE NUMERIC No
The user-adjusted price of the dental procedure (Hospital Billing estimates only)
4 DENTAL_ADJ_REASON_C_NAME VARCHAR No
The 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
5 DENTAL_ADJ_COMMENT VARCHAR No
The comment for the price adjustment for a dental procedure (Hospital Billing estimates only)
6 DENTAL_ADJ_USER_ID VARCHAR No
The user that adjusted the estimate (Hospital Billing estimates only)
7 DENTAL_ADJ_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 DENTAL_PAT_PORTION NUMERIC No
The patient portion of a dental procedure's price (used for Hospital Billing estimates only)
9 DENTAL_OUTDATED_YN VARCHAR No
Stores whether the current estimate value is flagged as out of date and needs to be recalculated (used for Hospital Billing estimates only)
May contain organization-specific values: No
Category Entries:
No
Yes