Data Elements for the Financial Data Set

Domain

Data Elements

Definition

Ready for Prototype

Unique Identifiers

Payer or sponsor identifier

Unique identification number for the entity who is funding (providing payment for) the coverage. This could include a private employer, government (Medicare, Medicaid), self-pay, union, etc.

No

 

Payee identifier

Unique identification number for the entity who receives payment for the service delivered.

No

 

Organization identifier(s)

Unique identification numbers for all entities involved in the financial transactions

No

 

Individual covered by payment identifier

Unique identification number for the consumer.

Yes

Person-level Data Elements

Consumer copayment

An out-of-pocket payment made by or charged to the consumer at the time of visit or discharge.

Yes*

 

Consumer payment towards deductible

Total copayments made that are counted toward a deductible. Once a deductible amount is met, copayments generally decline or are zero.

Yes*

 

Third party payment

Payment made by an insurer or other payer (e.g., Medicaid).

Yes*

*dollar amount

Person-level Data Elements Continued

Method of third party payment (if any)

Describes the financial incentives: fee-for-service, salary, capitation, case rate, DRG, per diem are the principal examples.

No

 

Compensation method

This is different from method of third party payment if the clinician does not contract directly with the third party – e.g., is in a group practice.

Yes

 

Date of payment

Date on which claim or prospective payment is made.

Yes

 

Time period covered by payment (e.g., capitation payments often cover one month)

Dates over which payment is intended to cover average costs (if fee-for-service, then point in time).

Yes

Organization-level Data Elements

Current assets

  • Cash—funds on hand and in the organization’s bank account
  • Marketable securities—holdings of short-term notes, stocks, and bonds held for their return and which can be readily sold
  • Accounts receivable—amounts owed to the organization
  • Allowance for doubtful accounts (bad debts—an estimate of the amount of accounts receivables that will not be collected
  • Other current assets—current assets other than cash and accounts receivable that are to be converted into cash within a year, e.g., inventories and prepaid items such as rent and insurance

No

Organization-level Data Elements, Continued

Non-current assets

Unlike current assets, non-current assets are not expected to be converted into cash within a year.

  • Furniture and equipment—tangible assets other than buildings and land owned by the organization and used in the course of business, depreciated over time
  • Buildings—those being purchased or already owned by the organization and used in the bourse of business, depreciated over time
  • Land—land such as building sites, used in the course of business and which is being purchased or owned by the organization, not depreciated
  • Other non-current assets—all non-current assets other than land, buildings, furniture, and equipment used in the course of business, such as long-term investments, franchises, and other intangible assets

No

 

Total assets

The total of all current and non-current assets as a dollar value.

No

 

Current liabilities

A dollar value for the debts that require payment within a year (wages payable, accounts payable, interest payable, etc.)

No

 

Non-current liabilities

A dollar value for the long-term obligations to be paid beyond a year (mortgages, bonds payable, notes payable, etc.)

No

Organization-level Data Elements, Continued

Total liabilities

The total of current and non-current liabilities as a dollar value.

No

Operating revenue and support: first and third-party revenue by program element

A dollar figure for each category should be provided for each program element operated by the organization.

  • Consumer revenue (revenue earned from the delivery of services paid by the consumer or a responsible party other than third party payers)
  • Insurance revenue, including CHAMPUS (revenue paid by an insurance carrier for services delivered)
  • Medicare revenue
  • Medicaid revenue (Federal and State)
  • Total first- and third-party revenue by program element

No

 

Operating revenue and support: all other sources

A dollar figure for all categories should be provided for each program element operated by the organization.

  • State mental health agency support
  • Other State agency support
  • Federal Block Grant support
  • Other Federal support
  • Municipality, county, and other local support
  • Other operating revenue and support

No

Organization-level Data Elements Continued

Non-operating revenue

A dollar amount for the income the organization receives that is not related to the delivery of mental health services (investments such as interest, business income, capital gains, gifts and contributions of cash or liquid assets, bequests and charitable contributions, and research support).

No

 

Total revenue and support

The sum of operating and non-operating revenue and support as a dollar value.

No

 

In-kind contributions and volunteers

The estimated dollar value of benefits received by an organization where no funds are exchanged (examples include the fair market value minus actual rent for a building or value of staff assigned to the organization by other entities who are on the payroll of those entities).

No

 

Operating expenses by program element

Expenses related to the delivery of mental health services broken out by program element. Operating expenses include rent, salaries, supplies, insurance, and utilities.

No

 

Non-operating expenses

A dollar amount for the expenses of the organization that is not related to the delivery of mental health services (e.g. interest on loans).

No

Organization-level Data Elements Continued

Total expenses

The sum of operating and non-operating expenses as a dollar value.

No