FA_NOTES_QUERY_RESP

Description:

Query data for the Financial Information Query.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1
LINE	2

Column Information

	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.