|
Name |
Type |
Discontinued? |
|
| 1 |
ACCT_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the guarantor 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 |
HB_PRINT_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for this hospital detail bill in detail bill history. |
|
|
| 4 |
EB_PRINT_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for this enterprise detail bill record in detail bill history. |
|
|
| 5 |
BILL_RUN_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The run type for this detail bill. |
| May contain organization-specific values: No |
| Category Entries: |
| Statement |
| Hospital Account Detail Bill |
| Guarantor Detail Bill |
| Claim Detail Bill |
| Client Statement |
|
|
| 6 |
IS_DEMAND_DB_YN |
VARCHAR |
No |
|
|
|
| Flag to indicate whether this detail bill was produced on demand or as part of the batch. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 7 |
ACCEPT_DT |
DATETIME |
No |
|
|
|
| The date the detail bill record was created. |
|
|
| 8 |
END_BATCH_DT |
DATETIME |
No |
|
|
|
| The batch date of the detail bill. |
|
|
| 9 |
DB_DVRY_MTHD_C_NAME |
VARCHAR |
No |
|
|
|
| Stores how the detail bill was delivered. |
| May contain organization-specific values: No |
| Category Entries: |
| Paper, No Electronic Notification |
| Paperless, No Electronic Notification |
| Paper and Electronic Notification |
| Paperless, Electronic Notification |
|
|
| 10 |
USER_ID |
VARCHAR |
No |
|
|
|
| The user who created the detail bill. |
|
|
| 11 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 12 |
TOTAL_CHG_AMT |
NUMERIC |
No |
|
|
|
| The sum of all charges on the detail bill. |
|
|
| 13 |
TOTAL_PMT_AMT |
NUMERIC |
No |
|
|
|
| The sum of all payments on the detail bill. |
|
|
| 14 |
TOTAL_ADJ_AMT |
NUMERIC |
No |
|
|
|
| The sum of all adjustments on the detail bill. |
|
|
| 15 |
CUR_INS_BAL_AMT |
NUMERIC |
No |
|
|
|
| The total amount of the detail bill that is currently with insurance. |
|
|
| 16 |
CUR_PAT_BAL_AMT |
NUMERIC |
No |
|
|
|
| The total amount of the detail bill that is currently in self-pay. |
|
|
| 17 |
TOTAL_AMT_DUE |
NUMERIC |
No |
|
|
|
| The total amount due for this detail bill. |
|
|
| 18 |
DB_IS_MYC_NOTIF_YN |
VARCHAR |
No |
|
|
|
| Stores if the detail bill notification was sent via MyChart. |
| The category values for this column were already listed for column: IS_DEMAND_DB_YN |
|
|
| 19 |
DB_PAPER_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the reason why the detail bill was sent via paper. |
| May contain organization-specific values: No |
| Category Entries: |
| Paperless Billing is disabled for the service area |
| User specified |
| Forced to paper because of self-pay follow-up level |
| Forced to paper because of guarantor rule |
| Forced to paper because of hospital account rule |
| Guarantor declined paperless billing |
| Financial Assistance Program Not Allowed In MyChart |
| Not self-pay correspondence |
| Form is not allowed to be displayed in MyChart |
| Guarantor missing associated patient or MyChart account |
| Guarantor is not MyChart active |
| Guarantor is not available in MyChart |
| No access to billing features in MyChart |
| MyChart tickler could not be sent |
| Professional billing letter not marked as Sent |
| Patient is not active on MyChart |
| Queued for printing based on estimate rule |
| Patient is deceased |
|
|
| 20 |
INVOICE_NUMBER |
VARCHAR |
No |
|
|
|
| Invoice number for a detail bill. |
|
|
