|
Name |
Type |
Discontinued? |
|
| 1 |
HSP_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the hospital account with associated collection agency information. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number in the results of a query. Each collection agency history will have its own line number. |
|
|
| 3 |
AGNCY_HST_DT_OF_CH |
DATETIME |
No |
|
|
|
| Date hospital account was either assigned to or withdrawn from the collection agency. |
|
|
| 4 |
AGNC_HST_CHG_TP_C_NAME |
VARCHAR |
No |
|
|
|
| Change in the collection agency status. 1-Assign to agency 2-Withdraw from agency |
| May contain organization-specific values: No |
| Category Entries: |
| Assign |
| Withdraw |
|
|
| 5 |
AGNCY_HST_AGNCY_ID |
NUMERIC |
No |
|
|
|
| ID of collection agency hospital account has been assigned to. |
|
|
| 6 |
AGNCY_HST_AGNCY_ID_COLL_AGENCY_NAME |
VARCHAR |
No |
|
|
|
| The name of the collection agency. |
|
|
| 7 |
AGN_HST_COL_ACT_C_NAME |
VARCHAR |
No |
|
|
|
| This column stores the type of collection action done on the hospital account: 1-Send Letter, 2-Pre-Collect, 3-Bad Debt, 4-Return to Self-Pay, 5-Write Off, 6-Create Billing Note, 7-Change Notification Date, 8-Add to Queue, 10- Outsource Account, 11- Return from Outsource, 12-Change Agency, 13-Set Billing Indicator, or 14-Send SmartText Letter. |
| May contain organization-specific values: No |
| Category Entries: |
| Send Letter |
| Pre-Collect |
| Send to Bad Debt |
| Return to Self-Pay |
| Write Off |
| Create Billing Note |
| Change Notification Date |
| Add to Queue |
| Account Note |
| Outsource Account |
| Return from Outsource Agency |
| Change Agency |
| Modify Billing Indicator |
| Send SmartText Letter |
| Change Self-Pay Follow-up Date |
| Send to External Agency A/R |
| Return from External Agency A/R |
| Set Tickler |
| Pre-Collect to Bad Debt |
| Outsource to Bad Debt |
| Outsource to External Agency A/R |
| External Agency A/R to Bad Debt |
| Bad Debt to External Agency A/R |
|
|
| 8 |
AGNCY_HST_ACCT_BAL |
NUMERIC |
No |
|
|
|
| Account balance on the hospital account that was sent to collections. |
|
|
| 9 |
AGNCY_HST_CHG_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| This column contains the reason why the account was placed or withdrawn from the agency. Refer to the AGNC_HST_CHG_TP_C to know whether this was related to an assign or withdraw. |
| May contain organization-specific values: Yes |
|
|
