|
Name |
Type |
Discontinued? |
|
| 1 |
ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the price estimate record. |
|
|
| 2 |
ESTIMATE_CREATE_DT |
DATETIME |
No |
|
|
|
| The date the estimate was created. |
|
|
| 3 |
USER_ID |
VARCHAR |
No |
|
|
|
| User who created the estimate |
|
|
| 4 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 5 |
SERV_AREA_ID |
NUMERIC |
No |
|
|
|
| The service area associated with the price estimate. |
|
|
| 6 |
SERVICE_DATE |
DATETIME |
No |
|
|
|
| The service date specified in the price estimate. |
|
|
| 7 |
ESTIMATE_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The price estimate's status within the estimate workflow. |
| May contain organization-specific values: No |
| Category Entries: |
| Pending |
| Finalized |
| Completed |
| Voided |
| Replaced |
| Expired |
|
|
| 8 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The patient requesting the price estimate. |
|
|
| 9 |
CONTACT_NAME |
VARCHAR |
No |
|
|
|
| The person requesting a price estimate, if they do not currently have a patient record (EPT). If the person requesting the estimate does have a patient record, use PAT_ID to find their contact information. |
|
|
| 10 |
CONTACT_CITY |
VARCHAR |
No |
|
|
|
| The city of the contact person's address. Used only if the person requesting the estimate does not currently have a patient record. |
|
|
| 11 |
CONTACT_ZIP_CODE |
VARCHAR |
No |
|
|
|
| The zip code of the contact person's address. Used only if the person requesting the price estimate does not currently have a patient record (EPT). |
|
|
| 12 |
CONTACT_STATE_C_NAME |
VARCHAR |
No |
|
|
|
| The state of the contact person's address. Used only if the person requesting the price estimate does not currently have a patient record (EPT). |
| May contain organization-specific values: Yes |
|
|
| 13 |
CONTACT_COUNTRY_C_NAME |
VARCHAR |
No |
|
|
|
| The country of the contact person's address. Used only if the person requesting the estimate does not currently have a patient record (EPT). |
| May contain organization-specific values: Yes |
|
|
| 14 |
CONTACT_PHONE_NUM |
VARCHAR |
No |
|
|
|
| The phone number of the person requesting the price estimate. Used only if that person does not have a patient record (EPT). |
|
|
| 15 |
CONTACT_ALT_PHONE |
VARCHAR |
No |
|
|
|
| The alternate phone number of the person requesting the price estimate. Used only if that person does not have a patient record (EPT). |
|
|
| 16 |
COVERAGE_ID |
NUMERIC |
No |
|
|
|
| The primary coverage of the patient specified in the estimate. |
|
|
| 17 |
BENEFITS_INFO_ID |
NUMERIC |
No |
|
|
|
| Benefit information record (BEN) that is linked to the estimate. |
|
|
| 18 |
PAYOR_ID |
NUMERIC |
No |
|
|
|
| The payor (EPM) associated with the patient's primary coverage. This can be used to determine contracts and other pricing factors. If the person requesting the estimate does not have a patient record (EPT), the user may still enter a payor for pricing purposes. |
|
|
| 19 |
BENEFIT_PLAN_ID |
NUMERIC |
No |
|
|
|
| The benefit plan (EPP) associated with the patient's primary coverage. This can be used to determine contracts and other pricing factors in the price estimate. If the person requesting the estimate does not have a patient record (EPT), the user may still enter the benefit plan for pricing purposes. |
|
|
| 20 |
REQUIRED_PREPAY_AMT |
NUMERIC |
No |
|
|
|
| Required patient prepayment amount. |
|
|
| 21 |
PARENT_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| Reference to the record from which this record was created as a copy. |
|
|
| 22 |
CONTACT_COUNTY_C_NAME |
VARCHAR |
No |
|
|
|
| The county of the person requesting the price estimate. Used only if that person does not have a patient record (EPT) |
| May contain organization-specific values: Yes |
|
|
| 23 |
EXTERNAL_ID |
VARCHAR |
No |
|
|
|
| This items stores the external ID for the record. |
|
|
| 24 |
ACCOUNT_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the guarantor account associated with the estimate. This can be populated if the patient has an existing guarantor account in the service area associated with the estimate, and will not be populated for prospective patients (when PAT_ID is blank). |
|
|
| 25 |
OVERALL_PERCENT_DISCOUNT |
NUMERIC |
No |
|
|
|
| Stores percent discount for the entire estimate. If set, this overrides all system-calculated discounts. |
|
|
| 26 |
AMOUNT_DUE_OVERRIDE |
NUMERIC |
No |
|
|
|
| Stores amount due for the entire estimate. If set, this overrides all system-calculated discounts. |
|
|
| 27 |
CONTACT_HOUSE_NUM |
VARCHAR |
No |
|
|
|
| The house number of the contact person's address. Used only if the value has been manually specified in the estimate. |
|
|
| 28 |
CONTACT_DISTRICT_C_NAME |
VARCHAR |
No |
|
|
|
| The district of the contact person's address. Used only if the value has been manually specified in the estimate. |
| May contain organization-specific values: Yes |
|
|
| 29 |
CREATE_MYPT_ID |
VARCHAR |
No |
|
|
|
| The original MyChart user that created this estimate. |
|
|
| 30 |
HB_TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB charge amounts on an estimate. |
|
|
| 31 |
PB_TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB charge amounts on an estimate. |
|
|
| 32 |
TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total charge amount on an estimate. On Resolute estimates, this does not include external provider charges. |
|
|
| 33 |
HB_SYS_TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total of the HB system-calculated charge amounts on an estimate. |
|
|
| 34 |
PB_SYS_TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total of the PB system-calculated charge amounts on an estimate. |
|
|
| 35 |
SYS_TTL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The total of all system-calculated charge amounts on an estimate. |
|
|
| 36 |
HB_TTL_ALLOW_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB allowed amounts on an estimate. |
|
|
| 37 |
PB_TTL_ALLOW_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB allowed amounts on an estimate. |
|
|
| 38 |
TTL_ALLOW_AMT |
NUMERIC |
No |
|
|
|
| The total of all allowed amounts on an estimate. |
|
|
| 39 |
HB_SYS_TTL_ALLOW |
NUMERIC |
No |
|
|
|
| The total of all Hospital Billing (HB) system-calculated allowed amounts on an estimate. |
|
|
| 40 |
PB_SYS_TTL_ALLOW |
NUMERIC |
No |
|
|
|
| The total of all Professional Billing system-calculated allowed amounts on an estimate. |
|
|
| 41 |
SYS_TTL_ALLOW_AMT |
NUMERIC |
No |
|
|
|
| The total of all system-calculated allowed amounts on an estimate. |
|
|
| 42 |
HB_TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB self-pay amounts on an estimate. |
|
|
| 43 |
PB_TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB self-pay amounts on an estimate. |
|
|
| 44 |
TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total self-pay amount on an estimate. On Resolute estimates, this does not include external provider self-pay amounts. |
|
|
| 45 |
HB_SYS_TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB system-calculated self-pay amounts on an estimate. |
|
|
| 46 |
PB_SYS_TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB system-calculated self-pay amounts on an estimate. |
|
|
| 47 |
SYS_TTL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total of all system-calculated self-pay amounts on an estimate. |
|
|
| 48 |
HB_TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB discount amounts on an estimate. |
|
|
| 49 |
PB_TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB discount amounts on an estimate. |
|
|
| 50 |
TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all discount amounts on an estimate. |
|
|
| 51 |
HB_SYS_TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB system-calculated discount amounts on an estimate. |
|
|
| 52 |
PB_SYS_TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB system-calculated discount amounts on an estimate. |
|
|
| 53 |
SYS_TTL_DISCNT_AMT |
NUMERIC |
No |
|
|
|
| The total of all system-calculated discount amounts on an estimate. |
|
|
| 54 |
HB_TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB tax amounts on an estimate. |
|
|
| 55 |
PB_TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB tax amounts on an estimate. |
|
|
| 56 |
TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all tax amounts on an estimate. |
|
|
| 57 |
HB_SYS_TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all HB system-calculated tax amounts on an estimate. |
|
|
| 58 |
PB_SYS_TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all PB system-calculated tax amounts on an estimate. |
|
|
| 59 |
SYS_TTL_TAX_AMT |
NUMERIC |
No |
|
|
|
| The total of all system-calculated tax amounts on an estimate. |
|
|
| 60 |
SOURCE_VISIT_CSN |
NUMERIC |
No |
|
|
|
| The contact serial number of the patient contact associated with the visit when the estimate was created, if applicable. |
|
|
| 61 |
FOLLOW_UP_REASON_C_NAME |
VARCHAR |
No |
|
|
|
| The reason this estimate requires follow-up. |
| May contain organization-specific values: No |
| Category Entries: |
| Needs billing review |
|
|
| 62 |
SOURCE_DETAIL_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates where the information on this estimate originated from. |
| May contain organization-specific values: No |
| Category Entries: |
| Scheduled Order |
| Emergency Visit |
| Surgical Case |
| Telehealth |
| Coded Procedure - Hospital Encounter |
| Coded Procedure - Appointment |
| Lab Requisition |
| Lab Visit |
| Other Encounter |
| Appointment |
| Dental Treatment Plan |
| Dental Visit |
| Dental Refresh |
| Dental Visit (HB) |
| Orthodontic Treatment |
| Shopper - Patient |
| Shopper - Prospective Patient |
| Order Entry |
| Residential Hospital Account |
| Managed Care Staff |
| Member |
| External System |
|
|
| 63 |
ADJUDICATION_SRC_C_NAME |
VARCHAR |
No |
|
|
|
| The adjudication source category ID for the estimate. |
| May contain organization-specific values: No |
| Category Entries: |
| Resolute |
| Payer |
|
|
| 64 |
CUR_ACTIVE_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| This column stores the currently active estimate in a replacement chain for any given estimate. If the estimate is not in a replacement chain, this item will match the estimate ID. |
|
|
| 65 |
EMAIL_ADDRESS |
VARCHAR |
No |
|
|
|
| Stores the email address of the patient or guest (shopper). |
|
|
| 66 |
ALTERNATES_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| Link to the estimate that holds the alternate procedures. |
|
|
| 67 |
OUTSTANDING_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| Link to the estimate that holds the outstanding procedures. |
|
|
| 68 |
HB_TTL_INS_PAID_AMT |
NUMERIC |
No |
|
|
|
| The total of all Hospital Billing (HB) insurance paid amounts on an estimate. |
|
|
| 69 |
PB_TTL_INS_PAID_AMT |
NUMERIC |
No |
|
|
|
| The total of all Professional Billing (PB) insurance paid amounts on an estimate. |
|
|
| 70 |
TTL_INS_PAID_AMT |
NUMERIC |
No |
|
|
|
| The total of all insurance paid amounts on an estimate. |
|
|
| 71 |
EST_SPAN_C_NAME |
VARCHAR |
No |
|
|
|
| This item defines an estimate as a single or multi-visit type record: 0 - single visit estimate, 1 - multiple visit, treatment (parent) level estimate, 2 - multiple visit, visit (child) level estimate, 3 - outstanding, holds outstanding procedures, 4 - alternate, holds alternate procedures. |
| May contain organization-specific values: No |
| Category Entries: |
| Single Visit |
| Visit Grouper |
| Grouped Visit |
| Outstanding |
| Alternate |
|
|
| 72 |
HB_TOTAL_PMT_AMT |
NUMERIC |
No |
|
|
|
| The total of all estimated HB insurance and patient payment amounts. |
|
|
| 73 |
PB_TOTAL_PMT_AMT |
NUMERIC |
No |
|
|
|
| The total of all estimated PB insurance and patient payment amounts. |
|
|
| 74 |
TOTAL_PAYMENT_AMT |
NUMERIC |
No |
|
|
|
| The total of all estimated insurance and patient payment amounts. |
|
|
| 75 |
TOTAL_COPAY_AMT |
NUMERIC |
No |
|
|
|
| The total copay amount passed on to the patient. For treatment estimates, this is the total copay amount passed on to the patient for all visits within the treatment. |
|
|
| 76 |
TOTAL_COINS_AMT |
NUMERIC |
No |
|
|
|
| The total coinsurance amount passed on to the patient. For treatment estimates, this is the total coinsurance amount passed on to the patient for all visits within the treatment. |
|
|
| 77 |
TOTAL_DEDUCTIBLE_AMT |
NUMERIC |
No |
|
|
|
| The total deductible amount passed on to the patient. For treatment estimates, this is the total deductible amount passed on to the patient for all visits within the treatment. |
|
|
| 78 |
TOTAL_ADDL_SP_AMT |
NUMERIC |
No |
|
|
|
| The total self-pay passed on to the patient due to reaching the insurance maximum. For treatment estimates, this is the total excess self-pay due to reaching the insurance maximum for all visits within the treatment. |
|
|
| 79 |
TOTAL_UPGRADE_SP_AMT |
NUMERIC |
No |
|
|
|
| The total upgrade amount passed on to the patient. For treatment estimates, this is the total upgrade amount passed on to the patient for all visits within the treatment. This only shows a value for PB dental estimates. |
|
|
| 80 |
TOTAL_DOWNGRADE_SP_AMT |
NUMERIC |
No |
|
|
|
| The total downgrade amount passed on to the patient. For treatment estimates, this is the total downgrade amount passed on to the patient for all visits within the treatment. This only shows a value for PB dental estimates. |
|
|
| 81 |
TOTAL_HMO_COPAY_AMT |
NUMERIC |
No |
|
|
|
| The total HMO copay amount passed on to the patient. For treatment estimates, this is the total HMO copay amount passed on to the patient for all visits within the treatment. This only shows a value for PB dental estimates. |
|
|
| 82 |
TOT_NON_COVERED_AMT |
NUMERIC |
No |
|
|
|
| The total noncovered amount passed on to the patient. For treatment estimates, this is the total noncovered amount passed on to the patient for all visits within the treatment. |
|
|
| 83 |
VISIT_GROUPER_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| If this is a visit-level estimate record on a multi-visit estimate, this item stores the grouper estimate record containing this visit estimate. |
|
|
| 84 |
FINALIZED_USER_ID |
VARCHAR |
No |
|
|
|
| Returns the user who finalized the estimate. |
|
|
| 85 |
FINALIZED_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 86 |
EST_REPLACE_REASON_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the primary reason that this estimate's parent was automatically replaced. This item will only be set if this is an automatic replacement estimate. |
| May contain organization-specific values: No |
| Category Entries: |
| Visits added or removed |
| Procedure change |
| Coverage change |
| Charge amount change |
| Allowed amount change |
| Benefit change |
| Discount change |
| Other patient portion change |
|
|
