|
Name |
Type |
Discontinued? |
|
| 1 |
NOTE_ID |
VARCHAR |
No |
|
|
|
| The unique identifier for the note 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 |
QRY_INCOME_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the type of income (I FNC 131) the patient or patient contact has. |
| May contain organization-specific values: Yes |
|
|
| 4 |
QRY_EXPENSE_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the type of expense (I FNC 151) the patient or patient contact has. |
| May contain organization-specific values: Yes |
|
|
| 5 |
QRY_ASSET_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the type of asset (I FNC 171) the patient or patient contact has. |
| May contain organization-specific values: Yes |
|
|
| 6 |
QRY_FREQUENCY_C_NAME |
VARCHAR |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the frequency at which the amount applies to the patient or patient contact. |
| May contain organization-specific values: No |
| Category Entries: |
| Hourly |
| Weekly |
| Biweekly |
| Monthly |
| Annually |
|
|
| 7 |
QRY_AMOUNT |
NUMERIC |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the monetary amount. |
|
|
| 8 |
QRY_NUM_HOURS |
INTEGER |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the number of hours the patient or patient contact works. This is used to calculate hourly income. |
|
|
| 9 |
QRY_PAT_ID |
VARCHAR |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the patient the financial data pertains to. |
|
|
| 10 |
QRY_PAT_REL_ID |
NUMERIC |
No |
|
|
|
| Stores data that was received in response to a financial information query from Financial Assistance. This is the patient contact the financial data pertains to. |
|
|
| 11 |
QRY_ERR_CODE |
VARCHAR |
No |
|
|
|
| Stores an error code that was received in response to a financial information query from Financial Assistance. |
|
|
| 12 |
QRY_ERR_MSG |
VARCHAR |
No |
|
|
|
| Stores the description of the error that was received in response to a financial information query from Financial Assistance. |
|
|
