|
Name |
Type |
Discontinued? |
|
| 1 |
ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the patient estimate record. |
|
|
| 2 |
MATCHING_TREATMENT_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| This items stores the treatment estimate matched to the associated visit grouper estimate. It is only populated for dental estimates. |
|
|
| 3 |
PREPAY_UPDATE_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| The source of prepay amount for the estimate. |
| May contain organization-specific values: No |
| Category Entries: |
| System Calculated |
| User Override |
| Copy From Visit |
| Template |
| Matched Treatment Estimate |
| Parent Estimate |
| Copy Amounts |
| Video Visit Maximum |
| Calculated by Visit Auto Pay |
|
|
| 4 |
PREPAY_UPDATE_USER_ID |
VARCHAR |
No |
|
|
|
| The user that last updated the prepay amount. |
|
|
| 5 |
PREPAY_UPDATE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 6 |
PREPAY_UPDATE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant at which the prepay amount was last updated. |
|
|
| 7 |
VAP_PROPOSED_AMT |
NUMERIC |
No |
|
|
|
| The proposed consent amount for visit auto pay that should be applied to the encounter. |
|
|
| 8 |
VAP_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| The source of the visit auto pay proposed amount value. If the source is set to 1 - System Calculated - Visit, the visit auto pay amount is calculated based on configuration when the estimate is finalized. A user may override the visit auto pay amount at that point as well. If the source is set to 2 - User Override, a user specified an amount to use as the visit auto pay consent amount for the estimate's encounter. |
| May contain organization-specific values: No |
| Category Entries: |
| System Calculated - Visit |
| User Override |
|
|
| 9 |
VAP_PROPOSAL_USER_ID |
VARCHAR |
No |
|
|
|
| The last user who updated the visit auto pay proposal on the estimate. |
|
|
| 10 |
VAP_PROPOSAL_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 11 |
VAP_PROPOSAL_DTTM |
DATETIME (Attached) |
No |
|
|
|
| The last instant the visit auto pay proposal associated with the estimate was updated, formatted with time zone attached. |
|
|
| 12 |
GROUP_NUMBER |
VARCHAR |
No |
|
|
|
| The group number for the coverage associated with this estimate. |
|
|
| 13 |
PAT_SEX_C_NAME |
VARCHAR |
No |
|
|
|
| The patient's legal sex. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Female |
| Male |
| Unknown |
| Nonbinary |
| X |
| Other |
|
|
| 14 |
PAT_BIRTH_DATE |
DATETIME |
No |
|
|
|
| Date of birth of the patient. |
|
|
| 15 |
HB_SP_DSCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all hospital billing self-pay discount amounts on an estimate. |
|
|
| 16 |
PB_SP_DSCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all professional billing self-pay discount amounts on an estimate. |
|
|
| 17 |
TOT_SP_DSCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all self-pay discount amounts on an estimate. |
|
|
| 18 |
HB_FIN_ASST_AMT |
NUMERIC |
No |
|
|
|
| The total of all hospital billing financial assistance discount amounts on an estimate. |
|
|
| 19 |
PB_FIN_ASST_AMT |
NUMERIC |
No |
|
|
|
| The total of all professional billing financial assistance discount amounts on an estimate. |
|
|
| 20 |
TOT_FIN_ASST_AMT |
NUMERIC |
No |
|
|
|
| The total of all financial assistance discount amounts on an estimate. |
|
|
| 21 |
MYCHART_REQ_LOC_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
| The name of the revenue location. |
|
|
| 22 |
MYCHART_REQ_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 23 |
NOTIF_CONTENT_C_NAME |
VARCHAR |
No |
|
|
|
| Stores what notification content was available when they are sent after an estimate was finalized. |
| May contain organization-specific values: No |
| Category Entries: |
| No notification sent |
| Notification sent with no hyperlinks |
| Notification sent with view estimate hyperlink only |
| Notification sent with prepay hyperlink only |
| Notification sent with both estimate and prepay hyperlinks |
| Notification sent with letter hyperlink |
| Notification sent with letter and prepay hyperlinks |
|
|
| 24 |
IS_EXTERNAL_ADJUDICATION_YN |
VARCHAR |
No |
|
|
|
| Whether the estimate was adjudicated by an external payer or not. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 25 |
PRIMARY_CVG_ORGANIZATION_ID |
NUMERIC |
No |
|
|
|
| Stores the organization record associated with the primary coverage on the estimate. |
|
|
| 26 |
PRIMARY_CVG_ORGANIZATION_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| Organization's external name used as the display name on forms and user interfaces. |
|
|
| 27 |
VARIANCE_WO_SKIP_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| The reason that an estimate is not eligible for an automatic variance write-off. |
| May contain organization-specific values: No |
| Category Entries: |
| Excluded by skip rule |
| Exceeded maximum write-off amount |
| Estimated services billed separately |
| Secondary services estimated |
| Multiple estimated services on account |
| Estimate coverage does not match account coverage |
| No write-off needed |
| Excluded by eligibility rule |
| Estimate finalized after service |
| Billed charges do not match estimate billing system |
|
|
