|
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 |
|
|