HSP_GUAR_SYS_ACT_REPL

Description: |
This table contains hospital guarantor system action history information.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | GUAR_ACCOUNT_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 | SYSTEM_ACTION_C_NAME | VARCHAR | No |
The system action category ID.
May contain organization-specific values: No
Category Entries:
Send Letter to Guarantor
Queue Guarantor Statement
Send SmartText Letter to Guarantor
Resolve Payment Plan Discrepancy
Guarantor Note
Guarantor Extension
Send Letter to Payor
Next Responsible Party
Claim Denial
Resubmit Claim
Debit Balance Write Off Bucket
Send Letter to Account Guarantor
Transfer to Self-Pay
Submit Claim Status Request to Payor
Credit Balance Write Off Bucket
Bucket Note
Send SmartText Letter for Bucket
Remove Bucket from Claim Queue
Update Follow-up Records
Reevaluate Self-Pay Allowances
Reevaluate Expected Reimbursement
Stamp Settlement Numbers
Bucket Extension
Send Letter to Account
Pre-Collect
Send to Bad Debt
Self-pay Debit Balance Write Off Account
Change Review Notification Date
Queue Account for Detail Bill
Queue Account for Statements
Date Range Billing
Late Charge Processing
Account Note
Combine Accounts
Add Stop Bill to Account
Outsource Account
Return from Outsource agency
Change Agency
Replace Billing Indicator
Clear Billing Indicator
Send SmartText Letter
Add Billing Indicator
Self-pay Credit Balance Write Off Account
Undo All Billing Action
Send to External Agency A/R
Return from External Agency A/R
Mark for Separate Service Area Billing
Send Account to Separate Service Area
Return to Self-pay
Admission Day Billing
Change Self-pay Follow-up Level
Increment Self-pay Follow-up Level
Initiate Notice of Hospice Election
Decrement Self-pay Follow-up Level
Rebill Unbilled Date Ranges
Remove Stop Bill
Send MyChart Tickler
Enable Paperless Billing
Disable Paperless Billing
Consecutive Account Charge Transfer
Send Eligibility Query
Add Guarantor Status
Remove Guarantor Status
Post Insurance Refund
Post Self-Pay Refund
Initiate Billing
Add to Existing Payment Plan
Undo NRP Back to Selected Bucket
Initiate Informational Claim
Undo Bucket
Cancel Claim
Redistribute Self-Pay Credit Balance
Interim Billing
Undo NRP
Terminate Payment Plan
Queue Guarantor for Detail Bill
Initiate SNF No-Pay Claim
Initiate SNF Exhaust Claim
Initiate Home Health No-Pay RAP
Distribute Bundled Payments
Initiate Home Health Notice of Admission
Account Extension
4 | ACTION_DATE | DATETIME | No |
The date of the system action.
5 | ACTION_DATA | VARCHAR | No |
The data for the system action.
6 | ACTION_COMMENT | VARCHAR | No |
The comment for the system action.
7 | IS_SYS_ACT_SUCC_YN | VARCHAR | No |
This column stores whether the system action is successful.
May contain organization-specific values: No
Category Entries:
Yes
No
8 | ACTION_UTC_DTTM | DATETIME (UTC) | No |
The instant when the system action was attempted.