STMT_PB_SKIP_TX_LIST

Description: |
This table stores the list of skipped Professional Billing transactions for a given statement.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PRINT_ID | NUMERIC | No |
The unique identifier for the statement print or detail bill 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 | TX_ID | NUMERIC | No |
The skipped Professional Billing transaction ID.
4 | STMT_HOLD_RSN_C_NAME | VARCHAR | No |
The reason why the account was held in Professional Billing statement processing.
May contain organization-specific values: Yes
Category Entries:
Minimum guarantor account balance not met
Credit balance on the guarantor account
Guarantor account already on another run
Guarantor account status not to bill
Minimum days between two statements not met
Address has no ZIP code
Charge Homing is turned on and guarantor account is not in its home
Skip guarantor account extension
No professional balance and no hospital account to bill
No hospital account to bill
Guarantor account has a hospital account with a self-pay payment/adjustment posted today
Guarantor account has a hospital account on payment plan that did not qualify
Form not found
Cannot demand if form requires importing images
Undistributed non self-pay credits
Undistributed self-pay payment
Zero Charge
Statement already processed this month for payment plan
SmartText and Classic forms cannot be included in the same run
Cannot send tickler to guarantor for paperless bill
Minimum days between guarantor detail bill and statement not met
Payment plan already paid for this month
Guarantor has a balance notification scheduled or recently sent
Payment plan is currently deferred, and guarantor has only plan balances
Guarantor billing status not to bill
Statement intervention
Guarantor does not have new activity
Guarantor does not have transactions to bill
Excluded during printing
Guarantor special billing status set to hold statements
Visit auto pay scheduled
Cannot send another statement before processing auto pay from the last statement
Payment plan processing in progress
Run level cap was exceeded
All balances on new auto pay payment plan
Voided transactions
Payor hold
Transaction skip function
Contested
Debit adjustments
Fully Paid Insurance Activity
Visit is not discharged
Posted Not Billed
Consolidated Balance
Pharmacy insurance transaction suppressed
Transaction skip extension
Service date range
Small balance write off
Client guarantor
Client next statement date is not before or equal to end batch date
5 | STMT_HOLD_RSN_TEXT | VARCHAR | No |
The free text information related to the reason why the transaction was held in statement processing.