 |
 |
 |
  |
|||||
 |
 |
 |
 |
 |
 |
|
|
|
||||||||||
| ||||||||||||
Scientific Data Documentation
Home Health Care and Equipment Purchases, 1987*SEE NMES HOME HEALTH CARE DATASET NAMES FOR DSN DATA PURCHASE AND USE AGREEMENT For use with the 1987 National Medical Expenditure Survey Data Individual identifiers have been removed from the micro-data tapes available from the Agency for Health Care Policy and Research through NTIS. Nevertheless, under sections 308(d) and 903(c) of the Public Health Service Act (42 U.S.C. 242m and 42 U.S.C. 299 a-1), data collected by the Agency for Health Care Policy and Research may not be used for any purpose other than the purpose for which it was supplied. The information on the micr data tapes available for purchase was supplied to the Agency for statistic and health services research. It is necessary, therefore, that the indi such micro-data tapes sign the following assurance: The user gives assurance that individual elementary unit data on the micro-data tapes being ordered will be used solely for statistical summaries and health services research. BACKGROUND General Information This documentation describes one in a series of public use tapes issued by the Agency for Health Care Policy and Research with data from the National Medical Expenditure Survey. This survey provides extensive information on health expenditures by or on behalf of families and individuals, the financing of these expenditures, and each person's use of services. The National Medical Expenditure Survey (NMES) is a research project of the Center for General Health Services Intramural Research, Agency for Health Care Policy and Research. Since the 1970s the intramural research program has given particular emphasis to studies of the use and financing of health services. The first series of studies (NMES-1) employed data collected in the 1977 National Medical Care Expenditure Survey. NMES-1 produced information on a broad range of issues such as the number and characteristics of the uninsured and the underinsured, the tax implications of excluding employer-paid premiums for health insurance from employee income, and the differences among socioeconomic and demographic groups with respect to the use of health services. A new series of studies (NMES-2) was initiated in the 1980s. These studies also involve a major data collection effort - the 1987 National Medical Expenditure Survey. Like its predecessor, NMES-2 provides information about the non-institutionalized population. In addition and in contrast to the earlier studies, NMES-2 also provides extensive information on the population residing in or admitted to nursing homes and facilities for the mentally retarded. The Household Component of NMES-2 is based on a national probability sample of the civilian, noninstitutionalized population living in the community. The sample is designed to provide a larger representation of population groups of special policy interest to the Federal Government than would have been obtained from a random sample. These groups include poor and low income families, the elderly, the functionally impaired, and black and Hispanic minorities. A Survey of American Indians and Alaska Natives includes a separate sample of American Indians and Alaska Natives living on or near Federal reservations and eligible to receive care provided or supported by the Indian Health Service. The Institutional Population Component includes a sample of persons residing in or admitted to nursing and personal care homes and facilities for the mentally retarded during 1987. A separate Medicare Records Component provides claims data on all Medicare beneficiaries included in the household and institutional samples. Together, the major components of NMES-2 contain information to make national estimates of health status, use of health services, insurance coverage, expenditures, and sources of payment for the civilian population of the United States during the period from January 1 to December 31, 1987. Oversampling of population groups of special interest makes possible in-depth studies of these groups. The database can also be used to assess the implications of recent or proposed changes in public or private health care benefits, methods of financing both health care and insurance coverage, various public and private subsidies for health care, and employee compensation arrangements. Household Survey Each family in the Household Survey was interviewed four times over a period of 16 months to obtain information about the family's health and health care during calendar year 1987. Baseline data on household composition, employment, and insurance were updated at each interview, and information was obtained on illnesses, use of health services, and health expenditures for each family member. A fifth round of interviews was conducted in the spring of 1988 to obtain information on the tax filing and medical deductions of each household. A long term care supplement was administered during the first and fourth rounds of interviewing to permit estimates of persons with functional disabilities and the use of formal services or long term care provided by family or friends. In order to verify and supplement the information provided by household respondents, the Household Component of NMES-2 included two additional surveys. The Medical Provider Survey obtained information from the physicians, hospitals, outpatient clinics, emergency rooms, and home health agencies used by the household sample during 1987. The Health Insurance Plan Survey obtained information on the private insurance of persons in the household sample, including premiums paid by all sources and the provisions of their coverage. Survey of American Indians and Alaska Natives (SAIAN) This component was conducted with the same data collection instruments and interview procedures as the Household Component and covered the same reference period, calendar year 1987. SAIAN also included follow-up surveys to medical providers and health insurers. Consequently, the data can be used to compare American Indians and Alaska Natives eligible for care from the Indian Health Service and the general U.S. population with regard to such issues as health status, use of health services, and access to care. Information was obtained on services provided outside the Indian Health Service and on other sources of health care financing available for persons eligible for care from the IHS. Institutional Population Component The Institutional Population Component of NMES-2 included persons resident in or admitted to nursing and personal care homes and facilities for the mentally retarded at any time in calendar year 1987. This survey provides information on the functional status, use of services, and health expenditures of the institutionalized population. The Survey in Institutions (SII) collected data from facility administrators and designated staff on the characteristics of facilities and charges. The Survey of Next of Kin (SNK) obtained data from the respondent's next-of-kin or other knowledgeable persons in the community on the financial status, insurance coverage, and personal history of the institutionalized person. Survey Samples All survey components were designed to provide statistically unbiased estimates that are representative of the civilian population of the United States in 1987. The Household Survey sample is a stratified multistage area probability design with a total sample of roughly 35,000 individuals, in 14,000 households, who completed all rounds of data collection. Oversampling of the population subgroups of special policy interest was based on a separate screening interview conducted in the fall of 1986 with a sample of 36,000 addresses. The Survey of American Indians and Alaska Natives adopted a multistage area probability sample design using an IHS- constructed frame of counties with individuals eligible for services provided or supported by the Indian Health Service and living on or near Federally recognized reservations or in Alaska. An initial screening interview was completed in approximately 13,700 dwelling units to identify the eligible sample. The screening yielded approximately 1,950 households responding for the full year and approximately 6,500 SAIAN persons responded for their entire period of eligibility in 1987. The institutional population sample was based on a three stage probability design. The first two stages were used to select facilities; the final stage sampled facility residents present on January 1, 1987. These facilities were also used to obtain a sample of admissions between January 1, 1987, and December 31, 1987. Based on sampling specifications the Institutional Population Component includes 1,500 facilities, 800 nursing homes and 700 facilities for the mentally retarded. There is a total of approximately 10,100 persons in the sample including both residents and new admissions. This includes 5,700 persons in nursing homes and 4,400 persons in facilities for the mentally retarded. The sample frame for facilities in the Institutional Population Component was derived from the 1986 Inventory of Long- Term Care Places. Taken in conjunction, the NMES-2 surveys yield comprehensive, population-based information that will support studies of most population groups of policy interest, including those presently outside the scope of various public and private financing mechanisms. In contrast to information obtained from program or provider statistics, NMES-2 data can be used to analyze all public and private sources of coverage for health care services and out-of-pocket payments by individuals and families. The Agency for Health Care Policy and Research sponsored the NMES-2 data collection activities. A substantial part of the support for the Survey of American Indians and Alaska Natives was provided by the Indian Health Service. The Health Care Financing Administration, the National Center for Health Statistics, and the Office of the Assistant Secretary for Planning and Evaluation provided extensive technical assistance during the development of the survey design and instruments. Interviews were conducted by the primary contractor, Westat, Inc., Rockville, Maryland and by National Opinion Research Center at the University of Chicago; the Council of Energy Resource Tribes, Denver, Colorado; and Stephen R. Braund and Associates, Anchorage Alaska. Data processing during the analysis stage of the project is being provided by Social and Scientific Systems, Inc., Bethesda, Maryland. The data were collected under the authorities of the Public Health Service Act and are being edited and published in accordance with the confidentiality provisions of that Act and the Privacy Act. Additional information on NMES-2 is available from Daniel C. Walden, Ph.D., Director of the Division of Medical Expenditure Studies; Center for General Health Services Intramural Research, Agency for Health Care Policy and Research; 2101 E. Jefferson Street, Suite 500; Rockville , Maryland, 20852 (301/227-8400). TECHNICAL AND PROGRAMMING INFORMATION General Information This documentation describes one in a series of public use tapes from the Household Survey of the 1987 National Medical Expenditure Survey (NMES). The tape provides two data files and related documentation on the use of and expenditures for formal home health care and the purchase and rental of medical equipment, supplies and other medical items for calendar year 1987. The data file on home health services (File 1) contains information on each person in the Household Survey using these services in 1987. Each record is restricted to the set of formal services provided during the year by each type of provider sent by each unique agency furnishing home health care. Services provided informally by friends or family are not included. Each record also contains selected person-level demographic information for the respective user, and household reported medical conditions associated with the use of home health care. File 2 contains one record per type of medical item per round for each eligible person in the Household Survey who reported having purchased, rented, or otherwise obtained such items during that round. This file also contains selected person-level demographic, medical condition and date of purchase variables. Each data file represents all persons in the civilian noninstitutionalized population who used home health care, in the first instance, or medical equipment and supplies, in the second instance, for one or more reference periods during calendar year 1987 and who responded for their entire period of eligibility. The files can be used to construct summary variables of expenditures, sources of payment and other aspects of utilization of home health care and purchases of medical equipment and supplies. NMES Public Use Tape 13 provides information on persons in the Household Survey without home care or without purchase of other medical equipment and supplies in 1987. Also provided on Tape 13 are annual person-level information on other health services use as well as detailed demographic, employment and insurance information, round-specific eligibility status indicators and reference period dates for the entire civilian noninstitutionalized population. The data on this tape are being released as EBCDIC files. The tape also includes an EBCDIC file containing programming statements required to create a SAS data set and a SAS format library for each data file on the tape. The records on either of the data files can be linked to all NMES public use tapes from the Household Survey by using the person identifier (PIDX). The following documentation offers a brief overview of the type and level of data provided, the content and structure of the data files and codebooks, and programming information. It contains the following sections: Data File 1: Home Health Care Data File Structure and Contents Data File 2: Medical Equipment Purchases & Rentals Data File Structure and Contents Variable Naming and Codebook Conventions Sample Design and Response Rates Estimation and Sampling Weights Programming Information References Data Dictionaries File 1: Home Health Care Data Alphabetical and Positional Listing of Variables File 1 Codebook File 2: Medical Equipment and Supplies Data Alphabetical and Positional Listing of Variables File 2 Codebook Codebook Notes for Files 1 and 2 More detailed information on NMES survey instruments and data collection procedures, variance estimation programs, and coding and related information are in Attachments 1 to 5, which are provided as hard-copy attachments to the documentation. Attachment 6 contains a catalogue of data items released on this and other NMES public use tapes. It is supplied to guide the user to the appropriate public use tape for the data items of interest in the NMES Household Survey. File 1: Home Health Care Data File Structure and Contents General Information File 1 contains data pertaining to the use of and expenditures for home health services. To expedite release of home health data and ensure data processing efficiency, the file structure generally reflects the aggregation across rounds of the household questionnaire (see Attachment 3A for the instrument used). This file contains 1,682 records. Each record provides variables related to the set of formal services provided during the year by a specific provider type from a unique agency furnishing home health care. For example, the set of services provided by RN's from Home Health Agency "ABC" are represented as a single record. Services provided by LPN's, from Agency "ABC", a second record, and services by RN's from Agency "XYZ" a third record. File 1 variables include type of home health care provider, the household reported conditions related to each set of services, the number of visits and type of care provided, and associated expenses and sources of payment. Using the number of visits variable (VISTNUMX) and linking all records with the same person identifier (PIDX) will provide the total number of home health care visits by all providers to each user during the survey year. Each record on File 1 contains the following information: Unique person and record identifiers Selected demographic variables Beginning and end dates of each set of home health care visits A constructed and edited variable representing the number of visits each health care provider made to the individual based on questions H32 to H46 in the home health booklet. Constructed and edited variable representing the home health provider type based on questions H2 and H3 in the home health booklet Variables based on questionnaire items H5 through H47 in the home health booklet. These include the ICD-9 codes representing the conditions for which the home health care provider visited, the types of services provided, the place of employment of the provider (including self-employed), average visit expenses, and sources of payment for each set of services as well as associated imputation flags. Weight and variance estimation variables Detailed information on editing of home health care provider type, editing of number of visits and the coding of medical conditions is provided in Sections 1.1, 1.2 and 1.3. The construction of the expense and source of payment variables and associated imputation procedures are described in Sections 1.4 and 1.5. Miscellaneous edits and omissions are discussed in Section 1.6. Additional detail for selected variables is also provided in the Codebook Notes at the end of the File 2 codebook. Home Health Care Provider Type Each record on this file contains a constructed and edited variable (PROVTYPE) corresponding to the type of home health care provider whose visits were reported by the household respondent for 1987. Each provider is identified by profession, e.g. nurse, therapist. As noted, the informal caregiving by friends or relatives is excluded from the file. The variable PROVTVPE was logically edited using responses from questions H2 and H3 in the home health booklet and supplemented from matching records from the NMES Medical Provider Survey (information on the MPS is available in Section 4 and in Attachment 1B.). When the household data were missing, MPS data were used. When there were discrepancies in reporting between the two sources, they were resolved by examining responses, including the text variables, to questions about the types of services performed by the home health provider and by checking the specialty of the provider (PROVCOD). Provider type responses (PROVTYPE) were not imputed. Number of Visits The variable VISTNUMX represents all visits by a particular provider (or substitutes for that provider) for the whole year. VISTNUMX was constructed and edited from the household survey data in a three-step process using all the information in questions H32 through H46 for each round of data collection. The first level of editing was to logically impute missing beginning dates from end dates of hospitalizations. If no hospitalization occurred, missing beginning dates were imputed to the midpoint of the reference period in which the visits were reported to have begun. A similar procedure was used for end dates. In the second step, logical inconsistencies were resolved, duplication involving visit dates eliminated, and a visit count determined based upon edited beginning and end dates and the frequency of visits. All editing was done at the level of a data segment. Up to eight data segments were created for each record depending upon the branching possibilities of the questionnaire (questions H32 - H46). Finally, a hotdeck imputation process was carried out for those in which missing data still existed. Missing values were imputed using a weighted sequential hotdeck procedure based upon known values. Variables with known values were used to form groups of donors and groups of recipients. Within such groups, data on the number of visits from donors were assigned to recipients, taking into account the weights associated with each person in the complex NMES household survey design. The classification variables used for this process were age, sex, number of conditions and provider type. An imputation flag indicates for each record whether the visit number for any round was imputed or not. For the purposes of this data file, the first date of the year indicating the beginning of home health visits from a unique provider type and the last date of the year indicating the ending of home health visits for that provider type were used to define the period of home health care use by that provider. The number of visits during that period was totaled over rounds between those two dates to create VISTNUMX. Medical Conditions This file contains up to four condition codes per home health provider record. For each use of a home health provider (File 1) (or medical equipment and supplies purchase, File 2) reported in the Household Survey, reasons for use in terms of related medical conditions were obtained from Household Survey respondents. This included medical diagnosis, if any, related history, and parts of the body affected by the condition. This information was used to code each condition related to the reported use of a provider into one of the codes of the 9th Revision of the International Classification of Diseases, revised for use in the National Health Interview Survey (NHIS; NCHS, 1979). The revision takes into account the experience of the National Center for Health Statistics, the sponsor of the NHIS, in coding household reported conditions. One major revision of the ICD-9 coding procedure in surveys using the NHIS system is the introduction of X-codes. These codes represent impairments such as blindness, deafness, and paralysis. Coding instructions directed coders to favor X-codes over other ICD-9 codes that could be applied to a particular condition. Attachment 4 provides details of the NHIS coding scheme for X-codes. The first condition on the record does not necessarily reflect the primary condition for the sample person, nor its importance or severity. For 20 records, there were more than four conditions related to the set of home health provider visits comprising the record. In these cases, the conditions were reviewed, and the less serious conditions dropped in order to satisfy the four-condition limit. Coding was conducted by trained medical coders. Two-stage verification of the coding was performed first by supervisors and then by trained nosologists. Coders were required to maintain an error rate at or below 2 percent throughout the coding process. Visit Expense for Home Health Care The file contains the constructed and edited average visit expense for the home health care received by the sample person. The visit expense variable (VISTEXPX) reflects the average amount paid for a visit from all sources including out-of-pocket and third party payers. Home health data were collected for all visits in four rounds throughout the year, but visit charges were only collected for the last visit in each round. Since visit expenses could change between rounds of data collection, an overall average visit expense was calculated based on the last visit expense associated with each round of data collection and weighted by the number of visits which occurred in each round for which there were both visits and recorded visit expenses. Visit expenses on this file refer to the average visit charge with two exceptions. First, expenses reflect payments rather than charges when charges were reduced to the amounts allowed by third-party payers such as private health insurers, Medicare, or Medicaid. Second, a dollar value was assigned to each service when services were delivered by providers who do not specify a charge for such services, such as providers who are financed out of budgets of governments, charities and other organizations who do not specify charges for their services. In these cases, a visit expense value was imputed from the expenses associated with otherwise similar services. There are no home health visits with zero expenses in this file. Data for visit expense were derived both from the home health questionnaire data from the Household Survey and from the NMES Medical Provider Survey (MPS). MPS data were used as the primary data source for expense data where it was available. The MPS was designed to collect data from the organization or provider reported by all respondents in the Household Survey who reported use of home health care. Data were edited when 1) the reported expense was a total for all visits rather than a per visit expense; (2) discrepencies were found between the MPS and Household data; (3) charges were exceptionally high or low; and (4) data were missing. When a total figure was available rather than a visit expense, the total was divided by the number of visits as reported in the Household Survey. Outliers were checked against the length and number of visits and the types of services given. If no MPS expense data were available, the expense as reported by the household respondent was used. Missing values were imputed using a weighted sequential hotdeck procedure, based upon known values from both the MPS and Household data. Type of provider, census region of residence and insurance coverage were used as classification variables and age, race, gender and marital status were used as sort variables. In total, approximately 50 percent of expense information was edited or imputed. All imputations were performed at the level of the last visit expense in each round. Each record with any imputed expense information contains a corresponding imputation flag. Sources of Payment for Home Health Care Unlike the expense variable, which refers to the average expense per visit, the source of payment variables refer to the share of total expenses paid by each source for the set of services represented by each record. These percentages were derived from the questions about the last visit for each round. Each record contains 9 constructed variables which sum to 100 percent, corresponding to the percent of the total expense (the sum of all visit expenses for each provider) paid by each of the following sources: Out of pocket by user or family; Private insurance; Medicaid; Medicare; Other Federal (CHAMPUS, CHAMPVA, SSI, Indian Health Service facility or contact, Intertribal Council, Alaska Native Corporation, Veteran's Administration, any military and other federal programs such as free government screening services and NIH care); Other State and local medical assistance (such as community health centers but excluding local and state employment related insurance and welfare programs); Workers compensation; Free from the provider including professional courtesy and bad debt; and Other, which includes automobile and car insurance, other kinds of insurance not specified, company (where the company is not the insurer), school (where the school is not the insurer or employer), union (where the union is not the insurer or employer), charity, friend, foreign government or not otherwise specified. The source of payment variables reflect all home health visits by a specific provider type, whether self-employed or charging through a home health care agency. If a provider was responsible for 10 visits (VISTNUMX = 10), the SOP variables refer to the total expenses for all 10 visits (10 x VISTEXPX). Based on respondent reports of the percent or amount paid by each of these sources of payment, the source of payment variables were edited and, where necessary, imputed to correct for the following: (1) the household-reported payer was incompatible with enrollment in public and private insurance programs reported for the person; (2) the person was not billed for the home health visit so no charge or sources of payment were reported; (3) the sum of the reported sources did not equal 100 percent; or (4) the sources of payment or the amounts or proportions of the payment were partially or completely missing. Logical edits for sources of payment were performed in those cases where enough information existed. When only a partial source of payment was available and no logical edit was possible, the total distribution of sources of payment was imputed. Since the source of payment information is based on questions which refer to the last visit of a particular provider rather than all the visits of that provider, the cumulated data yield accurate aggregate or average estimates but are not necessarily accurate for any specific visit or individual case if the payers for the services of the provider changed during the year. As for visit expenses, the general imputation strategy for sources of payment used a weighted sequential hotdeck procedure. The classification variables used in the source of payment imputation included insurance coverage, type of provider, region, ethnicity and family income. Each record with imputed values contains a corresponding flag. Other Edits and Omissions Some data items from the home health care booklet were omitted from this file because they were components or probes used to construct the summary variables provided. Omitted variables were considered not to be of independent analytic interest but as methodological probes to insure that the respondent had provided complete utilization and expenditure information. The summary variables included on this file, such as visit expense and number of visits, reflect all of the components related to the home health information elicited in the home health care section of the questionnaire. Verification was performed on all link variables (e.g., ODUX, PIDX) except PROVIDX. File 2: Medical Equipment and Supplies Data File Structure and Co General Information File 2 contains data on the purchase of and expenditures for medical equipment, supplies and other medical items. File 2 contains one record per type of medical item per reference period for each eligible person in the Household Survey who reported having purchased, rented, or otherwise used such medical item during that reference period. To expedite the release of the data and ensure data processing efficiency, the file structure generally reflects the structure of the household questionnaire (see Attachment 3B for the instrument used). The file contains information for various types of medical items and related conditions, and charges and sources of payment, as obtained in four rounds of interviews covering calendar year 1987. The persons represented on this file include all sampled users of medical items in calendar year 1987 who responded for their entire period of NMES eligibility. The file contains 11,010 records, or one record for each type of medical item purchased, rented or otherwise obtained by a sample person during a round of data collection. A record can represent one or more purchases of the particular type of item within the reference period. Each record on the data file contains the following information: Unique person and record identifiers Indicator of the round of data collection Selected demographic variables Type of medical item (coded in question P18 of the Other Medical Expenses Booklet) Variables based on questionnaire items P19 through P38 of the Other Medical Expenses Booklet. These include the ICD-9 codes representing the conditions for which the medical item(s) was used, the date when it was first used during the reference period, and total expense and sources of payment across all uses of that medical item(s) per record per reference period as well as associated imputation flags. Weight and variance estimation variables Detailed information on coding of medical items is provided in Section 2.1. Medical condition coding is described in Section 2.2. The construction of the total expenses and source of payment variables and imputation procedures are described in Sections 2.3 and 2.4. Other edits and omissions are discussed in Section 2.5 and additional detail for selected variables are also provided in the codebook notes at the end of the File 2 codebook. Medical Items The data were collected in the Other Medical Expenses Probes and the Other Medical Expenses Booklets of the NMES questionnaire. The medical items were identified by means of seven structured questions and one open-ended question which together comprise the Other Medical Expenses Probes. The structured questions asked about the purchase, rental, or repair of a variety of medical equipment and supplies, including: eyeglasses and contact lenses, orthopedic items (crutches, wheelchairs, walkers, corrective shoes), hearing aid devices, diabetic equipment or supplies (insulin, syringes, test paper), prostheses, special home or car alterations or equipment (ramps, handrails, special bathroom fixtures, special automobile equipment), and ambulance services. Those medical items that require a prescription, such as insulin syringes, may also have been captured in the questions about prescription medications (no attempt was made to exclude medical items also reported on NMES Tape 14.1, Prescribed Medicine Data) The open-ended question asked about the purchase of any other medical equipment. A booklet was completed for each type of medical item mentioned in a round. CODEITMX references the type of medical item and includes the original seven categories specified in the probes plus additional items organized to incorporate all the responses from the open ended question. Thirty records referenced more than one type of medical item, and these additional mentions were coded in OMECOD2X and OMECOD3X. The information collected in the Other Medical Expenses Booklet about each item identified include: the person who obtained the item(s); the medical conditions associated with the item(s); the date when the item(s) were bought, rented or put in service; the cost of the item(s); sources of payment; and the amount or percent of total charges paid by each source. Medical Conditions See discussion for File 1. Total Expense The file contains both the unedited (EXPTOT) and edited (EXPTOTX) total expenses for the type of medical item (or types of items in the few cases of multiple mentions) identified in the record as corresponding to the particular reference period for a given person. These variables sum all expenses paid out-of-pocket and by third party sources for the medical item(s) of the type indicated in CODEITMX, over the reference period covered by the record and reported in the Household Survey for the round. In the case of the 30 records that referenced more than one type of item, the edited expense refers to all items. Total expenses on this file refer to total charges with two exceptions. First, expenses reflect payments rather than charges when charges were reduced to the amounts allowed by third-party payers such as private insurers, Medicare or Medicaid. Second, a dollar value was assigned to each item for which there was no specified total charge. For example, most equipment and supplies that are financed out of budgets of governments, charities and other organizations do not specify charges for the equipment. In these cases a total expense value was imputed from the expenses associated with otherwise similar equipment. There are no records on the file with zero expenses. Data edits addressed (1) copayment amounts reported by respondents as the total expense of the item(s); (2) extreme values; and (3) missing data. Logical edits were performed in those cases where enough information existed to construct a logical value for total expense. Where the reported expense appeared to be a copayment rather than the total cost for the item(s), the expense was set to missing and imputed to reflect the total cost rather than the copayment amount. A statistical procedure was used to impute a total expense amount from medical item records with complete information, as reported by the Household Survey respondent, to records with similar characteristics but with charge data missing. Each medical item category in CODEITMX was treated as a separate group for imputation purposes (for a total of 47 categories). Covariates of total expense and charge nonresponse were identified through separate regression runs for the various medical items in CODEITMX. These covariates were used as classification variables during imputation to form groups of donors (with known expense data) and recipient groups with identical characteristics but missing expense data. The number of classification variables used varied according to medical item and included such characteristics as census region of residence, poverty status, gender, and whether the person had coverage from Medicare or private insurance, or was a member of an HMO during the year. Within such groups, the median expense amount reported by donors was assigned to recipients. For records missing one or more of the classification variables, matching was performed on some subset of the classification variables. Each record with imputed values contains a corresponding imputation flag. In total, approximately 28% of records had total expenses imputed. Sources of Payment Each record on File 2 contains 9 constructed variables which sum to 100 percent, corresponding to the percent of the total charge paid by each of the following sources: Out of pocket by user or family; Private insurance; Medicaid; Medicare; Other Federal (CHAMPUS, CHAMPVA, SSI, Indian Health Service facility or contact, Intertribal Council, Alaska Native Corporation, Veteran's Administration, any military and other federal programs such as free government screening services and NIH care); Other State and local medical assistance (such as community health centers excluding local and state employment related insurance and welfare programs); Workers compensation; Free from the provider including professional courtesy and bad debt; and Other, which includes automobile and car insurance, other kinds of insurance not specified, company (where the company is not the insurer), school (where the school is not the insurer or employer), union (where the union is not the insurer or employer), charity, friend, foreign government or not otherwise specified. Based on respondent reports of the percent or amount paid by each of these sources of payment, the source of payment variables were edited and, where necessary, imputed to correct for the following: (1) the household reported payer was incompatible with enrollment in public and private insurance programs reported for the person; (2) the sum of the reported sources did not equal 100 percent; or (3) the sources of payment or the amounts or proportions of the payment were partially or completely missing. Logical edits for sources of payment were performed in those cases where enough information existed. When only a partial source of payment was available and no logical edit was possible, the total distribution of sources of payment was imputed. As for total expense, a statistical procedure was used to impute information about sources of payment. The general imputation strategy for sources of payment used a weighted sequential hotdeck procedure. The classification variables used in the source of payment imputation included insurance coverage, region of residence, month of purchase, and union status of the primary insured. Each record with imputed values contains a corresponding imputation flag. Other Edits and Omissions Question P18 of the Other Medical Expenses Booklet consists of seven prelisted categories of medical items (numbered 1 through 7) and an Other (Specify) response category. The responses recorded under Other were reviewed during editing in order to identify and assign a unique numeric code to the other classes of medical items not captured by the categories listed in the instrument. If the medical item was captured as an "other" and was the same as or similar to the prelisted categories in the questionnaire, it was not incorporated into the prelisted categories but categorized as a unique code from 11 thru 99. The edited data appear in CODEITMX, where code categories 1 through 7 reference the original data corresponding to the codes prelisted in the instrument, and categories 11 through 99 reference the codes developed to classify the verbatim responses. Because of this method of coding the text response, some items may be found in two category codes, e.g. one respondent who had wheelchair expenses answered the medical expenditure probe question about buying or renting orthopedic items such as crutches, wheelchairs, walkers or corrective shoes with a yes and was coded as a (2) orthopedic equipment, while another respondent answered the probe about buying or renting medical equipment besides what was talked about and answered an electric wheelchair which was recoded to (73). A handful of records had more than one type of medical item listed as part of the Other response. These additional mentions are coded in variables OMECOD2X and OMECOD3X. Unless indicated, all other Medical Expense Booklet variables are unedited. Skip patterns associated with unedited variables have not been reconciled. No editing was performed on the round indicator that is on this file, however, verification was performed on all link variables on the file. Variable Naming and Codebook Conventions A codebook is provided for each data file on this tape. The codebooks provide unweighted and weighted frequencies for all variables on each of the data files. The File 1 codebook contains variable information and frequency distributions for a total of 1,682 records. Weighted, these records represent 8,841,220 home health care visits to 5,878,253 persons (unweighted sample of 1,067 persons). The File 2 codebook contains variable information for a total of 11,010 records. Weighted, these records represent all purchases of medical equipment and supplies by 50,951,843 persons (unweighted sample of 7,322 persons). Complete variable listings in alphabetical order and by file position are provided for cross-reference for each file. Most variable descriptors in the codebooks are abbreviated versions of questionnaire items, preceded by indicators of item number. A copy of the round one home health care booklet and round one medical equipment booklet are included as Attachment 3A and 3B to this public use tape to permit a full understanding of the content and wording of each item, the structure of questionnaire sections, skip patterns and administrative information. Each codebook describes an EBCDIC data set and provides the following programming identifiers for each variable: IDENTIFIER DESCRIPTION NAME Variable name (maximum of 8 characters) DESCRIPTION Variable descriptor (maximum of 40 characters) FORMAT Number of bytes and decimal TYPE Type of data: numeric (indicated by NUM) or character (indicated by CHAR) START Beginning column position of variable in the record END Ending column position of variable in the record NOTES Indicator of an explanatory note(s) corresponding to the variable In general, variable names reflect the content of the variable, with an 8 character limitation. For edited versions of original variables, the edited variable name is identical to the original variable with an "X" appended (and truncated when necessary to comply with the 8 character limitation). For variables corresponding to specific questionnaire items, the question number is included in the variable label. The following reserved code values are used: VALUE DEFINITION -1 INAPPLICABLE Question was not asked due to skip pattern -5 NEVER KNOW Question was asked and respondent did not know and never will know the answer. -7 REFUSED Question was asked and respondent refused to answer the question -8 DK Question was asked and respondent did not know the answer -9 NOT ASCERTAINED Interviewer did not record the data Sample Design and Response Rates NMES Household Survey The NMES Household Survey was designed to produce national estimates representative of the civilian noninstitutionalized population of the United States as of 1987. For sample selection, the household component of NMES used two independent national multistage area samples from Westat, Inc. and NORC. To improve the quality of the data and to allow for analysis of trends during 1987, it was conducted as a panel survey over four core rounds of interviewing. Sampling specifications required the selection of about 17,500 households for the first core household interview. Data were obtained for about 86 percent of eligible households in the first interview and 80 percent by the fourth interview. Approximately 6 percent of all survey participants provided data for only some of the time in which they were eligible to respond. These persons were considered total nonrespondents and a standard nonresponse weight adjustment was used to account for possible selection bias in this respect. For a detailed description of the survey design and of sampling, estimation, and adjustment methods see Cohen, DiGaetano, and Waksberg, (1991). NMES Medical Provider Survey The Medical Provider Survey (MPS) in NMES was primarily designed to reduce the bias associated with national medical expenditure estimates derived from household-reported data. This bias is a function of item nonresponse and poor quality data. By selectively targeting (1) individuals who were most likely to misreport or not possess adequate knowledge about their medical expenditures and (2) medical care events that were expected to be associated with charge data of questionable quality, optimal use could be made of medical provider-reported data to improve the accuracy of national medical expenditure survey estimates. See Attachment 1B for a full discussion of MPS design and response rates. Estimation and Sampling Weights General Information The application of appropriate sampling weights is essential to the derivation of estimates when using these public use files. The weight provided for use with home health care and medical item data, INCALPER, reflects adjustments for complete nonresponse to the NMES survey and poststratification to the Census Bureau, 1987 Current Population Survey (CPS) cross- classified by age, race/ethnicity, gender and poverty status. All persons who were eligible at any time during 1987 and responded for the entire period of their eligibility have positive INCALPER weights. Only the 1,067 persons who have positive INCALPER weights, and who used home health care and responded for their entire period of eligibilty are represented on File 1. Only the 7,322 persons who have positive INCALPER weights and who purchased or otherwise obtained medical equipment, supplies and/or items and who responded for their entire period of eligibility are represented on File 2. In order to produce national estimates related to the types, frequency of use, expenses and sources of payment for these utilizations and purchases, the value in each record contributing to the estimates must be multiplied by the weight (INCALPER) contained on that record. It should be noted that the weight, INCALPER, can also serve as a person-level estimation weight (see NMES Public Use Tape 13). The variable on each record in File 1 containing the number of visits by the provider during 1987, VISTNUMX, must be used as an additional factor in most estimates of home health care utilization. For estimates involving persons in the Household Survey not on these files (e.g., in the case of File 1, persons without use of home health care in 1987) or for detailed person-level characteristics of users, including round-specific eligibility status and reference period dates, the data on these files should be merged with NMES Public Use Tape 13, using the person-level identification variable PIDX. Basic Estimates of Utilization and Expenditures Basic Estimates of Home Health Care Utilization and Expenditures File 1 is constructed for efficient estimation of utilization and expenditures for home health care visits. Such estimates include the total number of and expenses for visits. The mean home health care visit expense, for instance, should be calculated as the sum of each record's weighted values for average visit expense multiplied by the number of visits across all records in the file (sum of (VISTEXPX x VISTNUMX x INCALPER)) divided by weighted sum of the number of visits (sum of VISTNUMX x INCALPER). Thus, the numerator is the national estimate for total expenses for home health care and the denominator is the population estimate for the total number of home health care visits. Subsetting to records based on characteristics of interest expands the scope of potential estimates. For example, the number of home health care visits provided by nurses is estimated by summing (VISTNUMX x INCALPER) across all records with PROVTYPE = 1. The variables VISTNUMX and PROVTYPE on File 1 are used to replicate the home health care data provided on Public Use Tape 13. PROVTYPE equal to 7 identifies home health care visits by physicians and summing, at the person-level (PIDX), VISTNUMX from records with that provider type will correspond to DRHOME on Tape 13. Summing, at the person-level, VISTNUMX for records with PROVTYPE not equal to 7 will be equivalent to NONDRMHM (non- physician home health care visits) on Tape 13. Basic Estimates of Medical Item Purchase and Expenditures File 2 is constructed for efficient estimation of purchase or rental and expenditures for medical equipment, supplies or items. Such estimates include the incidence of and expenses for medical item procurement by round. The proportion of total medical item expenses accounted for by the purchase of eyeglasses or contact lenses, for instance, should be calculated as the weighted sum of total medical item expense (sum of TOTEXPX x INCALPER) across all records in the file with CODEITMX = 1 divided by weighted sum of total medical item expense (sum of TOTEXPX x INCALPER) across all records in the file. Thus, the numerator is the national estimate for total expenses for eyeglasses and contact lenses and the denominator is the national estimate for total expenses for all categories of medical equipment, supplies and items. This file should not be used to calculate the mean expense per medical item. The variable EXPTOTX is the total expense for all medical items of the type identified in CODEITMX (and, where applicable, in OMECOD2X and OMECOD3X) acquired during the reference period; however, the count of items represented by this expense is not available (the question was not asked). It should be noted that contained on NMES Tape 13 are person-level use variables suggesting the unique number of purchases. In fact these variables (MEXP1 and MEXPOTH) are an aggregation of purchases for a round, where one purchase represents all purchases for a particular kind of item obtained during a round of data collection. Consequently, mean expenditure estimates per item should be avoided. In order to replicate the Other Medical Expenses data on Public Use Tape 13, use the variables CODEITMX, OMECOD2X and OMECOD3X on File 2 of the current tape to distinguish purchase of eyeglasses and contact lenses from purchase or rental of other medical equipment, supplies or items. A count, at the person-level (PIDX), of records with CODEITMX = 1 will identify acquisitions of eyeglasses/contact lenses (MEXP1 on Tape 13). To reconstruct the Tape 13 variable MEXPOTH; i.e. procurement of medical equipment other than eyeglasses/contact lenses; count, at the person-level, records with CODEITMX greater than 1 or OMECOD2X greater than 0 or OMECOD3X greater than 0. Person-Based Ratio Estimates Person-Based Ratio Estimates for Persons with Use of Home Health When calculating ratio estimates where the denominator is persons, not home health visits, care should be taken to properly define and estimate this denominator. If the estimate of interest, for example, is the mean annual home health care expense for users of home health care, the following strategy should be considered: All expenses for a person on this file should be summed and a person-level total expense variable created (e.g., the variable X). The mean national estimate would then be derived by obtaining the ratio of the weighted sum of total expense per person across all unique persons on the file (sum of INCALPER times X) divided by the weighted number of unique persons on the file (sum of INCALPER). Only one INCALPER value for each PIDX should contribute to the calculation of the sums for both the denominator and numerator. Person-Based Ratio Estimates for Persons with Purchase or Rental of Medical Equipment, Supplies or Items As was the case with person-based home health care estimates, care should be taken to properly define and estimate the denominator when calculating ratio estimates where the denominator is persons, not medical items. If the estimate of interest, for example, is the mean annual expense for hearing aids and/or communication devices for persons who purchased this type of medical equipment, the following strategy should be considered: all expenses with CODEITMX = 3 or CODEITMX = 97 for a person on this file should be summed and a person-level total expense variable created (e.g., the variable Z). The mean national estimate would then be derived by obtaining the ratio of the weighted sum of total hearing aid/communication device expenses per person across all unique persons on the file with Z greater than 0 (sum of INCALPER times Z) divided by the weighted number of unique persons on the file with Z greater than 0 (sum of INCALPER). Only one INCALPER value for each PERSON (PIDX) with expenses for hearing aids and/or communication devices should contribute to the calculation of the sums for both the denominator and numerator. Person-Based Ratio Estimates Relative to the Entire Population If the ratio relates to the entire population, these files cannot be used to calculate the denominator, as only those persons with at least one home health care visit are represented on File 1 and, similarly, only those with at least one medical item purchase or acquisition are represented on File 2. In this case, Public Use Tape 13 -- Rounds 1-4 Household Survey: Population Characteristics and Person-level Utilization, which has data for all sampled people, must be used to estimate persons. For example, to estimate the proportion of persons 65 and over with at least one purchase (rental or repair) of an orthopedic item, the current file is used to calculate the numerator and NMES Tape 13 is used to calculate the denominator. Sampling Weights for Merging Previous Releases of NMES Household Data with the Current Tape There have been several previous releases of NMES Household Survey public use data (see Attachment 5). Unless a variable name common to several tapes is provided, the sampling weights contained on these tapes are tape-specific. The tape-specific sampling weights reflect minor adjustments to eligibility and response indicators due, among other factors, to birth, death, or institutionalization among respondents. Adjustments to the weights have also included post-stratification adjustments to control for the distribution of the U.S. noninstitutionalized population by poverty status and, where appropriate, nonresponse adjustments for round-specific supplemental questionnaires (e.g., the health status questionnaires). For estimates from a NMES data file that do not require merging with variables on other NMES files, the sampling weights provided on that tape are the appropriate weights. When merging a NMES household survey tape to another NMES household survey tape, the major analytical variable (i.e., the dependent variable) determines the correct sampling weight to use. For example, for 1987 estimates of home health care use or expenditures (from File 1 on the present tape) using health status variables from NMES Public Use Tape 9, the full-year weight, INCALPER, on the present tape should be used. By contrast, the weight HSQACCWT from Public Use Tape 9 should be used when the major dependent variable is health status and home health care utilization is an independent variable. Three exceptions to this general sampling weight and merge rule are noted below. For details concerning the appropriate weight specific to each tape, see the hard copy information specific to each tape. (1) For estimates of round one data from NMES Public Use Tape 3 (preliminary round one person characteristics and functional health status data), the round one weight (WGTR1PER) provided on NMES Public Use Tape 13 should be used. It should be noted that as a result of further response and eligibility edits, not all persons with positive round one weights on Tape 3 will link when merging it to Tape 13. In those instances, an imputation or weighting strategy can be developed to adjust for all persons with positive WGTR1PER weights. The preferred approach is to use the round one data and the round one weight released on NMES Tape 13. (2) For point in time estimates of persons with activity of daily living and instrumental activity of daily living difficulties (Tape 10), the round one or four weight (WGTR1PER and WGTR4PER, respectively), provided on NMES Tape 13 should be used in all instances of merged data regardless of the type of analysis. (3) NMES Public Use Tape 4, which contains prescribed medicine data for the Medicare beneficiary population, should not be merged with the current tape (or any other NMES public use file) because of adjustments to the sampling weights made after the release of Tape 4. It should be noted that the sampling weight provided on NMES Tape 9 (HSQACCWT) reflects nonresponse adjustments specific to the health status questionnaire and access to care supplement data on that tape. This further nonresponse adjustment requires additional considerations in merging Tape 9 with the current tape. (1) When making estimates for data in the current tape, the sampling weights provided on the current tape should be used. Since this would include persons not on Tape 9 in the analysis, data items from Tape 9 will have missing values for these persons. (2) When making estimates of health status or access to care indicators, the Tape 9 weight, HSQACCWT, should be used. This weight adjusts for the exclusion of persons appearing on the present tape that are not on Tape 9. Variance Estimation Variance estimates of sample statistics require that the complex nature of the NMES Household Survey design be taken into account for hypothesis testing and for the construction of confidence intervals. To obtain variance estimates of statistics by means of statistical programs that use the Taylor series method of variance estimation, variables must be used that denote the strata and the primary sampling unit (PSU) within a given stratum. The variables STRATUMX and SPSU are these variables respectively, and are included on the data file. There are variance estimation programs that account for the complex survey design. A list of available variance estimation programs is produced in Attachment 2. Programming Information These files are contained on a standard label, 9 track 6250 bpi tape. The specifications for each file on the tape are as follows: FILE 1 Description: NMES Household Survey Home Health Care Data File Dataset Name: NMES.PUF142.DATA1 Number of Observations: 1,682 Number of Variables: 62 Record Length: 265 Block Size: 2,650 Record Format: FB FILE 2 Description: NMES Household Survey Medical Equipment and Supplies Data File Dataset Name: NMES.PUF142.DATA2 Number of Observations: 11,010 Number of Variables: 38 Record Length: 180 Block Size: 1,800 Record Format: FB FILE 3 Description: Technical and Programming Information and Data Dictionaries for the NMES HHS Home Health Care and Medical Equipment and Supplies Data Files Dataset Name: NMES.PUF142.DOC Record Length: 133 Block Size: 19,950 Record Format: FB FILE 4 Description: Additional Documentation for SAS Users for the NMES HHS Home Health Care and Medical Equipment and Supplies Data Files Dataset Name: NMES.PUF142.SRC Record Length: 80 Block Size: 800 Record Format: FB File 1 and File 2 were created using the SAS (Statistical Analysis System, version 5.18) computer software, and converted to EBCDIC format. File 3 contains the technical documentation stored as an Operating System (OS) EBCDIC file containing ASA carriage control characters in the first byte in each record, which will direct the line printer to skip lines, begin a new page, etc. This technical documentation can be copied to disk and retrieved on-line to view, modify with a text editor program such as WYLBUR, or make additional copies. File 4 is an EBCDIC file containing the following additional documentation for SAS users: INPUT statement to create the SAS file, including a LABEL statement; SAS statements which assign a format name to each variable; and SAS statements describing formats. References Cohen, S.B., DiGaetano, R. and Waksberg, J. (1991). National Medical Expenditure Survey: Sample Design of the 1987 Household Survey, Methods 3. AHCPR Pub. No. 91-0037. DHHS: U.S. Public Health Service. National Center for Health Statistics (1979). Medical Coding Manual: National Health Interview Survey. DHHS: U.S. Public Health Service. DATA DICTIONARY File 1: NMES Home Health Provider Data Codebook Alphabetical Listing of Variables DATE: OCTOBER 8, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- START END NAME DESCRIPTION ----- --- ---- ----------- 93 93 BANDRSNG H10A PROVIDR EVER APPLIED BANDGS/DRESSNG 145 146 BATHSHWR H11A PROVIDR EVER HELPED W/BATH/SHOWER 42 43 DATEBDX H1ED DATE FIRST PROVIDER VISIT - DAY 46 46 DATEBFLG IMPUTATION FLAG FOR DATE OF FIRST VISIT 40 41 DATEBMX H1ED DATE FIRST PROVIDER VISIT - MONTH 44 45 DATEBYX H1ED DATE FIRST PROVIDER VISIT - YEAR 49 50 DATEEDX H1ED DATE LAST PROVIDER VISIT - DAY 53 53 DATEEFLG IMPUTATION FLAG FOR DATE OF LAST VISIT 47 48 DATEEMX H1ED DATE LAST PROVIDER VISIT - MONTH 51 52 DATEEYX H1ED DATE LAST PROVIDER VISIT - YEAR 163 164 GETARND H12D PROVIDR EVER HELPED WITH TRANSPORT 147 148 GETDRESS H11B PROVIDR EVER HELPED W/DRESSG/CLOTHG 153 154 HELPFEED H11E PROVIDR EVER HELPED WITH FEEDING 77 80 ICD1 H9 ICD9 CODE - CONDITION 1 81 84 ICD2 H9 ICD9 CODE - CONDITION 2 85 88 ICD3 H9 ICD9 CODE - CONDITION 3 89 92 ICD4 H9 ICD9 CODE - CONDITION 4 245 256 INCALPER FULL-YEAR WEIGHT 95 95 INJECTNS H10C PROVIDR EVER GAVE SHOTS/INJECTIONS 151 152 IOBEDCHR H11D PROVIDR EVER HELPED I/O BED/CHAIRS 33 35 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 167 168 LITHSEWK H12F PROVIDR EVER HELPED W/LIGHT HOUSEWK 159 160 MNGCASH H12B PROVIDR EVER HELPED TO MANAGE MONEY 96 96 NTRTMENT H10D PROVIDR EVER GAVE OTH MED TREATM 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 94 94 ORALMED H10B PROVIDR EVER GAVE MEDICATION ORALLY 13 20 PIDX PERSON ID (ODUX + PN) 6 8 PN PERSON NUMBER 165 166 PREPMEAL H12E PROVIDR EVER HELPED PREPARE MEALS 69 70 PROVCOD H6 SPECIALITY OF PROVIDER TYPE 61 68 PROVIDX PROVIDER PLACE OF WORK ID 58 58 PROVTYPE H2/H3ED TYPE OF PROVIDER 9 12 PRVDKEY PROVIDER NUMBER 59 60 PRVDWRKX H5ED PROVIDER PLACE OF WORK 38 38 RACE3 PID RACE/ETHNICITY 37 37 RACE6 ED PID RACE 21 32 RECIDX PROVIDER ID (ODUX + PN + PRVDKEY) 161 162 SHOPITEM H12C PROVIDR EVER HELPED SHOP PERS ITEMS 36 36 SMPSEXR PID SEX 238 243 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 244 244 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 200 207 SOPTMCD PCT PAYMENT FROM MEDICAID 192 199 SOPTMCR PCT PAYMENT FROM MEDICARE 208 215 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 230 237 SOPTOTHR PCT PAYMENT FROM OTHER 216 223 SOPTOTST PCT PAYMENT FROM OTHER STATE 184 191 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 176 183 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 224 229 SOPTWC PCT PAYMENT FROM WORKERS COMP 260 260 SPSU PSEUDO PSU 39 39 SREGION PID CENSUS REGION 257 259 STRATUMX SAMPLING STRATUM 71 72 TMPROVSX H7ED TIME OF DAY PROVIDER VISITED 97 144 TREATMNT H10E PROVIDR EVER GAVE OTH MED CARE 157 158 USETELE H12A PROVIDR EVER HELPED WITH TELEPHONE 149 150 USGETLET H11C PROVIDR EVER HELPED USE/GET TOILET 73 76 VISLGTHX H8ED AVERAGE VISIT LENGTH - MINUTES 175 175 VISTEFLG IMPUTATION FLAG FOR EDITED EXP PER VISIT 169 174 VISTEXPX EDITED EXPENSE PER VISIT 57 57 VISTNFLG IMPUTATION FLG FOR EDITD NUMBR OF VISITS 54 56 VISTNUMX EDITED NUMBER OF VISITS PER PROVIDER 155 156 WALKXRM H11F PROVIDR EVER HELPED WALK ACROSS RM Positional Listing of Variables DATE: OCTOBER 8, 1992 --POSITIONAL LISTING OF VARIABLES----- START END NAME DESCRIPTION _____ ___ ____ ___________ 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 6 8 PN PERSON NUMBER 9 12 PRVDKEY PROVIDER NUMBER 13 20 PIDX PERSON ID (ODUX + PN) 21 32 RECIDX PROVIDER ID (ODUX + PN + PRVDKEY) 33 35 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 36 36 SMPSEXR PID SEX 37 37 RACE6 ED PID RACE 38 38 RACE3 PID RACE/ETHNICITY 39 39 SREGION PID CENSUS REGION 40 41 DATEBMX H1ED DATE FIRST PROVIDER VISIT - MONTH 42 43 DATEBDX H1ED DATE FIRST PROVIDER VISIT - DAY 44 45 DATEBYX H1ED DATE FIRST PROVIDER VISIT - YEAR 46 46 DATEBFLG IMPUTATION FLAG FOR DATE OF FIRST VISIT 47 48 DATEEMX H1ED DATE LAST PROVIDER VISIT - MONTH 49 50 DATEEDX H1ED DATE LAST PROVIDER VISIT - DAY 51 52 DATEEYX H1ED DATE LAST PROVIDER VISIT - YEAR 53 53 DATEEFLG IMPUTATION FLAG FOR DATE OF LAST VISIT 54 56 VISTNUMX EDITED NUMBER OF VISITS PER PROVIDER 57 57 VISTNFLG IMPUTATION FLG FOR EDITD NUMBR OF VISITS 58 58 PROVTYPE H2/H3ED TYPE OF PROVIDER 59 60 PRVDWRKX H5ED PROVIDER PLACE OF WORK 61 68 PROVIDX PROVIDER PLACE OF WORK ID 69 70 PROVCOD H6 SPECIALITY OF PROVIDER TYPE 71 72 TMPROVSX H7ED TIME OF DAY PROVIDER VISITED 73 76 VISLGTHX H8ED AVERAGE VISIT LENGTH - MINUTES 77 80 ICD1 H9 ICD9 CODE - CONDITION 1 81 84 ICD2 H9 ICD9 CODE - CONDITION 2 85 88 ICD3 H9 ICD9 CODE - CONDITION 3 89 92 ICD4 H9 ICD9 CODE - CONDITION 4 93 93 BANDRSNG H10A PROVIDR EVER APPLIED BANDGS/DRESSNG 94 94 ORALMED H10B PROVIDR EVER GAVE MEDICATION ORALLY 95 95 INJECTNS H10C PROVIDR EVER GAVE SHOTS/INJECTIONS 96 96 NTRTMENT H10D PROVIDR EVER GAVE OTH MED TREATM 97 144 TREATMNT H10E PROVIDR EVER GAVE OTH MED CARE 145 146 BATHSHWR H11A PROVIDR EVER HELPED W/BATH/SHOWER 147 148 GETDRESS H11B PROVIDR EVER HELPED W/DRESSG/CLOTHG 149 150 USGETLET H11C PROVIDR EVER HELPED USE/GET TOILET 151 152 IOBEDCHR H11D PROVIDR EVER HELPED I/O BED/CHAIRS 153 154 HELPFEED H11E PROVIDR EVER HELPED WITH FEEDING 155 156 WALKXRM H11F PROVIDR EVER HELPED WALK ACROSS RM 157 158 USETELE H12A PROVIDR EVER HELPED WITH TELEPHONE 159 160 MNGCASH H12B PROVIDR EVER HELPED TO MANAGE MONEY 161 162 SHOPITEM H12C PROVIDR EVER HELPED SHOP PERS ITEMS 163 164 GETARND H12D PROVIDR EVER HELPED WITH TRANSPORT 165 166 PREPMEAL H12E PROVIDR EVER HELPED PREPARE MEALS 167 168 LITHSEWK H12F PROVIDR EVER HELPED W/LIGHT HOUSEWK 169 174 VISTEXPX EDITED EXPENSE PER VISIT 175 175 VISTEFLG IMPUTATION FLAG FOR EDITED EXP PER VISIT 176 183 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 184 191 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 192 199 SOPTMCR PCT PAYMENT FROM MEDICARE 200 207 SOPTMCD PCT PAYMENT FROM MEDICAID 208 215 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 216 223 SOPTOTST PCT PAYMENT FROM OTHER STATE 224 229 SOPTWC PCT PAYMENT FROM WORKERS COMP 230 237 SOPTOTHR PCT PAYMENT FROM OTHER 238 243 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 244 244 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 245 256 INCALPER FULL-YEAR WEIGHT 257 259 STRATUMX SAMPLING STRATUM 260 260 SPSU PSEUDO PSU File 1: NMES Home Health Provider Data Codebook General Information DATE: OCTOBER 8, 1992 ---- ------- - ---- THIS CODEBOOK PROVIDES UNWEIGHTED AND WEIGHTED FREQUENCIES FOR THE USE OF HOME HEALTH SERVICES FOR CALENDAR YEAR 1987. THE DATA FILE CONTAINS ONE RECORD PER HOME HEALTH PROVIDER FOR EACH PERSON IN THE HOUSEHOLD SURVEY WHO REPORTED HAVING HAD A HOME HEALTH SERVICE IN CALENDAR YEAR 1987. EACH RECORD IS RESTRICTED TO THE SET OF FORMAL SERVICES PROVIDED DURING THE YEAR BY A SPECIFIC PROVIDER TYPE. SERVICES OBTAINED THROUGH DIFFERENT HOME HEALTH AGENCIES ARE REPRESENTED ON SEPARATE RECORDS. SERVICES PROVIDED INFORMALLY BY FRIENDS AND FAMILY ARE NOT INCLUDED. EACH RECORD ALSO CONTAINS SELECTED PERSON-LEVEL DEMOGRAPHIC INFORMATION FOR THE RESPECTIVE USER, AND MEDICAL CONDITIONS ASSOCIATED WITH THE USE OF HOME HEALTH CARE. FOR VARIABLES CORRESPONDING DIRECTLY TO QUESTIONNAIRE ITEMS, THE ITEM NUMBER IS PROVIDED IN THE VARIABLE DESCRIPTOR, WHICH ALSO IDENTIFIES EDITED VARIABLES. FOR VARIABLES WITH AN ASTERISK IN THE RIGHTMOST COLUMN, EXPLANATORY NOTES ARE PROVIDED AT THE END OF THE FILE 2 CODEBOOK IN ALPHABETICAL ORDER OF THE VARIABLE NAME. TO OBTAIN NATIONAL ESTIMATES FOR THE VARIABLES ON THIS FILE, THE WEIGHT DESCRIBED AT THE END OF THIS CODEBOOK MUST BE USED. INFORMATION CONCERNING SAMPLE DESIGN AND ESTIMATION IS PROVIDED IN THE FILE DOCUMENTATION. 8Positions 1-49 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIG DWELLING UNIT OF PERSON 5.0 NUM 1 5 VALUE UNWEIGHTED WEIGHTED BY INCALPER 20001-37615 1,682 8,841,220 TOTAL 1,682 8,841,220 PN PERSON NUMBER 3.0 NUM 6 8 VALUE UNWEIGHTED WEIGHTED BY INCALPER 10-266 1,682 8,841,220 TOTAL 1,682 8,841,220 PRVDKEY PROVIDER NUMBER 4.0 NUM 9 12 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 100-4370 1,682 8,841,220 TOTAL 1,682 8,841,220 PIDX PERSON ID (ODUX + PN) 8.0 CHAR 13 20 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID PERSON ID 1,682 8,841,220 TOTAL 1,682 8,841,220 RECIDX PROVIDER ID (ODUX+PN+PRVDKEY) 12.0 CHAR 21 32 * VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID RECORD ID 1,682 8,841,220 TOTAL 1,682 8,841,220 LASTAGE ED PID AGE AT END OF LAST ELIG ROUND 3.0 NUM 33 35* VALUE UNWEIGHTED WEIGHTED BY INCALPER 0-17 133 930,442 18-44 165 1,231,810 45-64 218 1,489,711 65+ 1,166 5,189,257 TOTAL 1,682 8,841,220 SMPSEXR PID SEX 1.0 NUM 36 36 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 MALE 440 2,474,749 2 FEMALE 1,242 6,366,471 TOTAL 1,682 8,841,220 RACE6 ED PID RACE 1.0 NUM 37 37 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 AMER INDIAN 14 74,025 2 ALASKAN NATIVE 4 26,986 3 ASIAN/PACIFIC 4 40,556 4 BLACK 304 1,086,222 5 WHITE 1,326 7,445,557 6 OTHER 30 167,873 TOTAL 1,682 8,841,220 RACE3 PID RACE/ETHNICITY 1.0 NUM 38 38 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 HISPANIC 80 417,042 2 BLACK NONHISP 304 1,086,222 3 OTHER 1,298 7,337,957 TOTAL 1,682 8,841,220 SREGION PID CENSUS REGION 1.0 NUM 39 39 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 NORTHEAST 393 2,186,694 2 MIDWEST 448 2,425,496 3 SOUTH 479 2,331,285 4 WEST 362 1,897,745 TOTAL 1,682 8,841,220 DATEBMX H1ED DATE FIRST PROVIDER VISIT-MON 2.0 NUM 40 41* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 JANUARY 469 2,360,006 2 FEBRUARY 196 1,051,157 3 MARCH 153 821,174 4 APRIL 115 658,117 5 MAY 94 490,651 6 JUNE 101 538,716 7 JULY 128 662,625 8 AUGUST 109 562,780 9 SEPTEMBER 67 360,279 10 OCTOBER 78 417,867 11 NOVEMBER 79 420,633 12 DECEMBER 93 497,214 TOTAL 1,682 8,841,220 DATEBDX H1ED DATE FIRST PROVIDER VISIT-DAY 2.0 NUM 42 43* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1-31 1,682 8,841,220 TOTAL 1,682 8,841,220 DATEBYX H1ED DATE FIRST PROVIDER VISIT-YR 2.0 NUM 44 45* VALUE UNWEIGHTED WEIGHTED BY INCALPER 87 1,682 8,841,220 TOTAL 1,682 8,841,220 DATEBFLG IMPUTATION FLAG FOR DATE OF FIRST VISIT 1.0 NUM 46 46* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 IMPUTED 18 92,914 2 FROM HS 1,664 8,748,306 TOTAL 1,682 8,841,220 DATEEMX H1ED DATE LAST PROVIDER VISIT-MON 2.0 NUM 47 48* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 JANUARY 71 406,716 2 FEBRUARY 160 837,572 3 MARCH 123 694,531 4 APRIL 84 482,749 5 MAY 73 394,547 6 JUNE 110 593,955 7 JULY 152 795,400 8 AUGUST 121 657,801 9 SEPTEMBER 76 368,095 10 OCTOBER 115 567,539 11 NOVEMBER 144 774,082 12 DECEMBER 453 2,268,233 TOTAL 1,682 8,841,220 DATEEDX H1ED DATE LAST PROVIDER VISIT-DAY 2.0 NUM 49 50* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1-31 1,682 8,841,220 TOTAL 1,682 8,841,220 Positions 51-71 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DATEEYX H1ED DATE LAST PROVIDER VISIT-YEAR 2.0 NUM 51 52* VALUE UNWEIGHTED WEIGHTED BY INCALPER 87 1,682 8,841,220 TOTAL 1,682 8,841,220 DATEEFLG IMPUTATION FLAG FOR DATE OF LAST VISIT 1.0 NUM 53 53* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 IMPUTED 23 116,509 2 FROM HS 1,659 8,724,711 TOTAL 1,682 8,841,220 VISTNUMX EDITED NUMBER OF VISITS PER PROVIDER 3.0 NUM 54 56* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1- 10 977 5,327,518 11- 25 219 1,174,001 26- 50 181 903,127 51-100 136 666,761 101-150 77 368,874 151-200 28 107,249 201-300 47 218,110 301-614 17 75,581 TOTAL 1,682 8,841,220 VISTNFLG IMPUTATION FLG FOR EDITD NUMBR OF VISITS 1.0 NUM 57 57* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 ALL FROM HS 1,613 8,481,704 2 SOME IMPUTED 69 359,516 TOTAL 1,682 8,841,220 PROVTYPE H2/H3ED TYPE OF PROVIDER 1.0 NUM 58 58 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 NURSE/PRACTIC 468 2,441,214 2 LPN 14 59,268 3 PHYSICAL THERP 60 337,172 4 OTHER THERAPST 45 303,722 5 HME HEALTH AID 396 2,006,961 6 HOMEMAKER 238 1,105,117 7 DOCTOR 182 1,016,100 8 SOCIAL WORKER 60 347,133 9 OTHER MEDICAL 219 1,224,535 TOTAL 1,682 8,841,220 RVDWRKX H5ED PROVIDER PLACE OF WORK 2.0 NUM 59 60 * VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 85 440,614 -1 INAPPLICABLE 182 1,016,100 1 SELF-EMPLOYED 247 1,306,347 2 PRIVATE PHYSI 23 129,515 3 HOSPITAL/CLNC 165 846,692 4 OTHER MEDICAL 199 1,093,123 5 VISITING NURS 307 1,533,515 6 HMEHLTH AGCNY 9 38,751 7 LOCL GOVERMNT 115 566,040 8 COMM ORGANZTN 47 216,088 9 NON HMHLTH PV 144 774,245 91 OTHER 159 880,192 TOTAL 1,682 8,841,220 PROVIDX PROVIDER PLACE OF WORK ID 8.0 CHAR 61 68 * VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID PROVIDR ID 1,682 8,841,220 TOTAL 1,682 8,841,220 PROVCOD H6 SPECIALITY OF PROVIDER TYPE 2.0 NUM 69 70 * VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 461 2,397,867 1 ALLERGY 1 8,976 2 ANESTHESIOLOGY 2 14,654 3 CARDIOLOGY 8 53,395 4 DERMATOLOGY 3 21,315 5 FAMLY PRACTICE 20 104,818 6 GEN'L PRACTICE 73 404,791 7 INTERNAL MEDCN 24 110,637 8 OB/GYN 3 15,500 10 ORTHODEPY 5 43,897 11 OSTEOPATHY 3 13,334 14 PEDIATRICS 7 52,753 15 PSYCHIATRY 4 22,421 16 RADIOLOGY 2 7,397 17 SURGERY 7 41,902 18 UROLOGY 1 3,105 19 DENTIST/CLNIC 6 32,778 20 EM ROOM PHYSN 1 3,381 22 ONCOLOGIST 1 5,648 30 HEMATOLOGY 1 5,522 51 AUDIOLOGIST 4 28,498 52 CHIROPRACTOR 6 31,939 53 HME HLTH AIDE 319 1,570,732 54 MNTL HLTH CSR 4 17,833 55 NURSE 380 1,989,061 56 NRSE PRCTITNR 12 70,474 57 TECHNICIAN 16 93,644 58 OCUPTNL THERA 3 11,616 60 PODIATRIST 30 136,980 61 PHYSCIAN ASST 16 90,987 62 PHYSCAL THERA 46 279,262 63 PSYCHOLOGIST 2 16,843 64 RESPIRY THERA 10 56,938 65 SOCIAL WORKER 47 229,863 66 SPCH THERPIST 7 62,703 67 COUNSELOR 5 27,561 68 THERAPIST 13 96,874 69 MIDWIFE 7 48,800 91 OTH DOC SPECL 11 57,738 92 OTH PRVDR TYP 111 558,785 TOTAL 1,682 8,841,220 TMPROVSX H7ED TIME OF DAY PROVIDER VISITED 2.0 NUM 71 72* VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 17 92,920 1 DAY ONLY 1,444 7,513,641 2 NIGHT ONLY 92 548,286 3 BOTH 129 686,373 TOTAL 1,682 8,841,220 Positions 73-153 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- VISLGTHX H8ED AVERAGE VISIT LENGTH - MINUTES 4.0 NUM 73 76* VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 29 165,463 1-10 72 438,211 11-30 429 2,310,003 31-60 443 2,335,588 61-120 223 1,099,553 121-180 149 701,276 181-240 99 492,120 241-300 60 314,139 301-360 30 146,073 361-420 15 80,224 421-480 43 240,421 481-540 11 56,593 541-600 7 39,186 601-5400 72 422,370 TOTAL 1,682 8,841,220 ICD1 H9 ICD9 CODE - CONDITION 1 4.0 CHAR 77 80 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 111 630,464 V001-V999 74 471,449 X00X-X999 201 1,011,273 0001-9999 1,296 6,728,034 TOTAL 1,682 8,841,220 ICD2 H9 ICD9 CODE - CONDITION 2 4.0 CHAR 81 84 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 1,067 5,732,286 -9 NOT ASCERTAIN 111 630,464 X00X-X999 11 51,919 0001-9999 493 2,426,551 TOTAL 1,682 8,841,220 ICD3 H9 ICD9 CODE - CONDITION 3 4.0 CHAR 85 88 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 1,375 7,288,458 -9 NOT ASCERTAIN 111 630,464 X00X-X999 1 2,997 0001-9999 195 919,302 TOTAL 1,682 8,841,220 ICD4 H9 ICD9 CODE - CONDITION 4 4.0 CHAR 89 92 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 1,485 7,816,222 -9 NOT ASCERTAIN 111 630,464 0001-9999 86 394,535 TOTAL 1,682 8,841,220 BANDRSNG H10A PROVIDR EVER APPLIED BANDGS/DRESSNG 1.0 NUM 93 93 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 YES 194 942,757 2 NO 1,488 7,898,463 TOTAL 1,682 8,841,220 ORALMED H10B PROVIDR EVER GAVE MEDICATION ORALLY 1.0 NUM 94 94 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 YES 208 1,025,950 2 NO 1,474 7,815,270 TOTAL 1,682 8,841,220 INJECTNS H10C PROVIDR EVER GAVE SHOTS/INJECTIONS 1.0 NUM 95 95 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 YES 108 561,803 2 NO 1,574 8,279,418 TOTAL 1,682 8,841,220 NTRTMENT H10D PROVIDR EVER GAVE OTH MED TREATM 1.0 NUM 96 96 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 YES 642 3,417,647 2 NO 1,040 5,423,573 TOTAL 1,682 8,841,220 TREATMNT H10E PROVIDR EVER GAVE OTH MED CARE 48.0 CHAR 97 144 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 1,040 5,423,573 -9 NOT ASCERTAIN 22 94,553 TEXT 620 3,323,094 TOTAL 1,682 8,841,220 BATHSHWR H11A PROVIDR EVER HELPED W/BATH/SHOWER 2.0 NUM 145 146 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 379 1,718,614 2 NO 956 5,118,480 TOTAL 1,682 8,841,220 GETDRESS H11B PROVIDR EVER HELPED W/DRESSG/CLOTHG 2.0 NUM 147 148 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 327 1,486,054 2 NO 1,008 5,351,041 TOTAL 1,682 8,841,220 USGETLET H11C PROVIDR EVER HELPED USE/GET TOILET 2.0 NUM 149 150 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 202 889,406 2 NO 1,133 5,947,689 TOTAL 1,682 8,841,220 IOBEDCHR H11D PROVIDR EVER HELPED I/O BED/CHAIRS 2.0 NUM 151 152 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 224 1,025,655 2 NO 1,111 5,811,440 TOTAL 1,682 8,841,220 HELPFEED H11E PROVIDR EVER HELPED WITH FEEDING 2.0 NUM 153 154 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 92 393,447 2 NO 1,243 6,443,648 TOTAL 1,682 8,841,220 Positions 155-208 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- WALKXRM H11F PROVIDR EVER HELPED WALK ACROSS RM 2.0 NUM 155 156 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 170 762,850 2 NO 1,165 6,074,245 TOTAL 1,682 8,841,220 USETELE H12A PROVIDR EVER HELPED WITH TELEPHONE 2.0 NUM 157 158 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 82 377,058 2 NO 1,253 6,460,037 TOTAL 1,682 8,841,220 MNGCASH H12B PROVIDR EVER HELPED TO MANAGE MONEY 2.0 NUM 159 160 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 51 233,883 2 NO 1,284 6,603,212 TOTAL 1,682 8,841,220 SHOPITEM H12C PROVIDR EVER HELPED SHOP PERS ITEMS 2.0 NUM 161 162 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 250 1,156,451 2 NO 1,085 5,680,644 TOTAL 1,682 8,841,220 GETARND H12D PROVIDR EVER HELPED WITH TRANSPORT 2.0 NUM 163 164 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 186 870,863 2 NO 1,149 5,966,232 TOTAL 1,682 8,841,220 PREPMEAL H12E PROVIDR EVER HELPED PREPARE MEALS 2.0 NUM 165 166 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 312 1,475,832 2 NO 1,023 5,361,263 TOTAL 1,682 8,841,220 LITHSEWK H12F PROVIDR EVER HELPED W/LIGHT HOUSEWK 2.0 NUM 167 168 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 347 2,004,125 1 YES 562 2,748,063 2 NO 773 4,089,032 TOTAL 1,682 8,841,220 VISTEXPX EDITED EXPENSE PER VISIT 6.2 NUM 169 174 * VALUE UNWEIGHTED WEIGHTED BY INCALPER .01- 5.00 24 108,355 5.01- 10.00 140 712,656 10.01- 20.00 319 1,647,429 20.01- 30.00 244 1,251,127 30.01- 40.00 176 959,524 40.01- 50.00 153 881,048 50.01- 60.00 186 932,145 60.01- 70.00 214 1,100,810 70.01- 80.00 91 490,512 80.01-100.00 49 312,410 100.01-200.00 60 302,181 200.01-895.00 26 143,023 TOTAL 1,682 8,841,220 VISTEFLG IMPUTATION FLAG FOR EDITED EXP PER VISIT 1.0 NUM 175 175* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 EXP FROM HS 399 2,176,015 2 EXP FROM MPS 424 2,054,766 3 EXP IMPUTED 859 4,610,440 TOTAL 1,682 8,841,220 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 8.4 NUM 176 183 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 899 4,735,476 GT 0 TO 20 61 346,179 GT 20 TO 40 31 156,388 GT 40 TO 60 36 169,972 GT 60 TO 80 18 89,980 GT 80 TO LT 100 3 11,990 100 634 3,331,235 TOTAL 1,682 8,841,220 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 8.4 NUM 184 191 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,421 7,198,464 GT 0 TO 20 48 213,429 GT 20 TO 40 4 28,019 GT 40 TO 60 12 55,292 GT 60 TO 80 17 112,997 GT 80 TO LT 100 16 140,499 100 164 1,092,521 TOTAL 1,682 8,841,220 SOPTMCR PCT PAYMENT FROM MEDICARE 8.4 NUM 192 199 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,244 6,816,624 GT 0 TO 20 16 85,650 GT 20 TO 40 19 83,214 GT 40 TO 60 31 140,249 GT 60 TO 80 76 362,579 GT 80 TO LT 100 22 86,032 100 274 1,266,870 TOTAL 1,682 8,841,220 SOPTMCD PCT PAYMENT FROM MEDICAID 8.4 NUM 200 207 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,298 6,871,504 GT 0 TO 20 2 9,625 GT 20 TO 40 6 25,104 GT 40 TO 60 6 27,152 GT 60 TO 80 5 25,775 GT 80 TO LT 100 4 18,558 100 361 1,863,501 TOTAL 1,682 8,841,220 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 8.4 NUM 208 215 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,670 8,766,910 GT 80 TO LT 100 2 7,394 100 10 66,916 TOTAL 1,682 8,841,220 Positions 216-260 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPTOTST PCT PAYMENT FROM OTHER STATE 8.4 NUM 216 223 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,665 8,751,116 GT 0 TO 20 1 4,231 GT 20 TO 40 5 28,193 GT 40 TO 60 2 13,982 GT 60 TO 80 4 15,694 100 5 28,004 TOTAL 1,682 8,841,220 SOPTWC PCT PAYMENT FROM WORKERS COMP 6.4 NUM 224 229 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,682 8,841,220 TOTAL 1,682 8,841,220 SOPTOTHR PCT PAYMENT FROM OTHER 8.4 NUM 230 237 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,654 8,694,138 GT 0 TO 20 6 29,269 GT 20 TO 40 1 8,867 GT 40 TO 60 4 19,031 GT 80 TO LT 100 3 17,683 100 14 72,232 TOTAL 1,682 8,841,220 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 6.4 NUM 238 243 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 1,677 8,814,409 GT 0 TO 20 5 26,812 TOTAL 1,682 8,841,220 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 1.0 NUM 244 244* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 ALL SOP FRM HS 606 3,430,014 2 ALL SOP IMPUTD 1,076 5,411,206 TOTAL 1,682 8,841,220 INCALPER FULL-YEAR WEIGHT 12.6 NUM 245 256 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 780.924-27174.39 1,682 N/A TOTAL 1,682 N/A STRATUMX SAMPLING STRATUM 3.0 NUM 257 259 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 301-401 1,682 8,841,220 TOTAL 1,682 8,841,220 SPSU PSEUDO PSU 1.0 NUM 260 260 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 797 4,112,333 2 885 4,728,888 TOTAL 1,682 8,841,220 File 2: NMES Other Medical Expenses Data Codebook ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: OCTOBER 8, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- START END NAME DESCRIPTION _____ ___ ____ ___________ 42 43 CODEITEM P18 CODE FOR SPECIAL MEDICAL ITEM 44 45 CODEITMX P18ED CODE FOR SPECIAL MEDICAL ITEM 1 68 69 DATEBDD P20 DATE FIRST ACQUIRED - DAY 66 67 DATEBMM P20 DATE FIRST ACQUIRED - MONTH 70 71 DATEBYY P20 DATE FIRST ACQUIRED - YEAR 9 12 EN EVENT NUMBER 21 32 EVENTIDX EVENT ID (ODUX + PN + EN) 86 86 EXPTFLG IMPUTATION FLAG FOR EDITED TOTAL EXPENSE 72 78 EXPTOT P24/P36 ORIGINAL TOTAL CHARGE 79 85 EXPTOTX EDITED TOTAL EXPENSE 50 53 ICD1 P19 ICD9 CODE - CONDITION 1 54 57 ICD2 P19 ICD9 CODE - CONDITION 2 58 61 ICD3 P19 ICD9 CODE - CONDITION 3 62 65 ICD4 P19 ICD9 CODE - CONDITION 4 160 171 INCALPER FULL-YEAR WEIGHT 35 37 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 46 47 OMECOD2X P18ED CODE FOR SPECIAL MEDICAL ITEM 2 48 49 OMECOD3X P18ED CODE FOR SPECIAL MEDICAL ITEM 3 13 20 PIDX PERSON ID (ODUX + PN) 6 8 PN PERSON NUMBER 40 40 RACE3 PID RACE/ETHNICITY 39 39 RACE6 ED PID RACE 33 34 ROUND DATA COLLECTION ROUND 38 38 SMPSEXR PID SEX 151 158 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 159 159 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 111 118 SOPTMCD PCT PAYMENT FROM MEDICAID 103 110 SOPTMCR PCT PAYMENT FROM MEDICARE 119 126 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 143 150 SOPTOTHR PCT PAYMENT FROM OTHER 127 134 SOPTOTST PCT PAYMENT FROM OTHER STATE 95 102 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 87 94 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 135 142 SOPTWC PCT PAYMENT FROM WORKERS COMP 175 175 SPSU PSEUDO PSU 41 41 SREGION PID CENSUS REGION 172 174 STRATUMX SAMPLING STRATUM File 2: NMES Other Medical Expenses Data Codebook ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: OCTOBER 8, 1992 -----POSITIONAL LISTING OF VARIABLES----- START END NAME DESCRIPTION _____ ___ ____ ___________ 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 6 8 PN PERSON NUMBER 9 12 EN EVENT NUMBER 13 20 PIDX PERSON ID (ODUX + PN) 21 32 EVENTIDX EVENT ID (ODUX + PN + EN) 33 34 ROUND DATA COLLECTION ROUND 35 37 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 38 38 SMPSEXR PID SEX 39 39 RACE6 ED PID RACE 40 40 RACE3 PID RACE/ETHNICITY 41 41 SREGION PID CENSUS REGION 42 43 CODEITEM P18 CODE FOR SPECIAL MEDICAL ITEM 44 45 CODEITMX P18ED CODE FOR SPECIAL MEDICAL ITEM 1 46 47 OMECOD2X P18ED CODE FOR SPECIAL MEDICAL ITEM 2 48 49 OMECOD3X P18ED CODE FOR SPECIAL MEDICAL ITEM 3 50 53 ICD1 P19 ICD9 CODE - CONDITION 1 54 57 ICD2 P19 ICD9 CODE - CONDITION 2 58 61 ICD3 P19 ICD9 CODE - CONDITION 3 62 65 ICD4 P19 ICD9 CODE - CONDITION 4 66 67 DATEBMM P20 DATE FIRST ACQUIRED - MONTH 68 69 DATEBDD P20 DATE FIRST ACQUIRED - DAY 70 71 DATEBYY P20 DATE FIRST ACQUIRED - YEAR 72 78 EXPTOT P24/P36 ORIGINAL TOTAL CHARGE 79 85 EXPTOTX EDITED TOTAL EXPENSE 86 86 EXPTFLG IMPUTATION FLAG FOR EDITED TOTAL EXPENSE 87 94 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 95 102 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 103 110 SOPTMCR PCT PAYMENT FROM MEDICARE 111 118 SOPTMCD PCT PAYMENT FROM MEDICAID 119 126 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 127 134 SOPTOTST PCT PAYMENT FROM OTHER STATE 135 142 SOPTWC PCT PAYMENT FROM WORKERS COMP 143 150 SOPTOTHR PCT PAYMENT FROM OTHER 151 158 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 159 159 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 160 171 INCALPER FULL-YEAR WEIGHT 172 174 STRATUMX SAMPLING STRATUM 175 175 SPSU PSEUDO PSU File 2: NMES Other Medical Expenses Data Codebook General Information DATE: OCTOBER 8, 1992 ---- ------- - ---- HIS CODEBOOK PROVIDES UNWEIGHTED AND WEIGHTED FREQUENCIES FOR THE USE F MEDICAL EQUIPMENT, SUPPLIES AND OTHER MEDICAL ITEMS FOR CALENDAR EAR 1987. THE DATA FILE CONTAINS ONE RECORD PER TYPE OF MEDICAL ITEM ER ROUND FOR EACH ELIGIBLE PERSON IN THE HOUSEHOLD SURVEY WHO EPORTED HAVING PURCHASED, RENTED, OR OTHERWISE OBTAINED SUCH ITEMS URING THAT ROUND. EACH RECORD ALSO CONTAINS SELECTED PERSON-LEVEL EMOGRAPHIC, MEDICAL CONDITION AND DATE OF PURCHASE VARIABLES. FOR ARIABLES CORRESPONDING DIRECTLY TO QUESTIONNAIRE ITEMS, THE ITEM UMBER IS PROVIDED IN THE VARIABLE DESCRIPTOR, WHICH ALSO IDENTIFIES DITED VARIABLES. FOR VARIABLES WITH AN ASTERISK IN THE RIGHTMOST OLUMN, EXPLANATORY NOTES ARE PROVIDED AT THE END OF THIS CODEBOOK IN LPHABETICAL ORDER OF THE VARIABLE NAME. TO OBTAIN NATIONAL ESTIMATES OR THE VARIABLES ON THIS FILE, THE WEIGHT DESCRIBED AT THE END OF HIS CODEBOOK MUST BE USED. INFORMATION CONCERNING SAMPLE DESIGN AND STIMATION IS PROVIDED IN THE FILE DOCUMENTATION. Variable Position 1-46 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIG DWELLING UNIT OF PERSON 5.0 NUM 1 5 VALUE UNWEIGHTED WEIGHTED BY INCALPER 20001-37614 11,010 73,767,437 TOTAL 11,010 73,767,437 PN PERSON NUMBER 3.0 NUM 6 8 VALUE UNWEIGHTED WEIGHTED BY INCALPER 10-266 11,010 73,767,437 TOTAL 11,010 73,767,437 EN EVENT NUMBER 4.0 NUM 9 12 VALUE UNWEIGHTED WEIGHTED BY INCALPER 11-1318 11,010 73,767,437 TOTAL 11,010 73,767,437 PIDX PERSON ID (ODUX + PN) 8.0 CHAR 13 20 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID PERSON ID 11,010 73,767,437 TOTAL 11,010 73,767,437 EVENTIDX EVENT ID (ODUX + PN + EN) 12.0 CHAR 21 32 VALUE UNWEIGHTED WEIGHTED BY INCALPER VALID EVENT ID 11,010 73,767,437 TOTAL 11,010 73,767,437 ROUND DATA COLLECTION ROUND 2.0 NUM 33 34 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 116 653,416 1 2,837 19,083,441 2 3,959 26,588,401 3 2,473 16,835,666 4 1,625 10,606,512 TOTAL 11,010 73,767,437 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 3.0 NUM 35 3 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0-17 1,045 7,623,518 18-44 3,156 25,824,699 45-64 2,607 19,726,660 65+ 4,202 20,592,560 TOTAL 11,010 73,767,437 SMPSEXR PID SEX 1.0 NUM 38 38 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 MALE 4,479 31,343,772 2 FEMALE 6,531 42,423,665 TOTAL 11,010 73,767,437 RACE6 ED PID RACE 1.0 NUM 39 39 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 AMER INDIAN 69 440,461 2 ALASKAN NATIVE 10 91,543 3 ASIAN/PACIFIC 106 939,569 4 BLACK 1,802 6,809,175 5 WHITE 8,786 64,175,785 6 OTHER 237 1,310,904 TOTAL 11,010 73,767,437 RACE3 PID RACE/ETHNICITY 1.0 NUM 40 40 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 HISPANIC 638 3,194,264 2 BLACK NONHISP 1,784 6,719,997 3 OTHER 8,588 63,853,177 TOTAL 11,010 73,767,437 SREGION PID CENSUS REGION 1.0 NUM 41 41 VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 NORTHEAST 2,211 15,159,588 2 MIDWEST 2,843 19,646,069 3 SOUTH 3,741 23,547,292 4 WEST 2,215 15,414,488 TOTAL 11,010 73,767,437 CODEITEM P18 CODE FOR SPECIAL MEDICAL ITEM 2.0 NUM 42 43 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 7 46,817 1 GLSSES/CTLENS 5,718 41,847,413 2 ORTHOPED ITEM 1,017 6,867,224 3 HEAR AID/COMM 388 2,275,417 4 DIABETIC ITEM 1,537 8,793,090 5 AMBULANCE 1,179 6,943,452 6 PROSTHESES 56 355,185 7 ALTERATIONS 101 587,225 91 OTHER 1,007 6,051,614 TOTAL 11,010 73,767,437 CODEITMX P18ED CODE FOR SPECIAL MEDICAL ITEM 1 2.0 NUM 44 45 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 35 229,553 1 GLSSES/CTLENS 5,718 41,847,413 2 ORTHOPED ITEM 1,017 6,867,224 3 HEAR AID/COMM 388 2,275,417 4 DIABETIC ITEM 1,537 8,793,090 5 AMBULANCE 1,179 6,943,452 6 PROSTHESES 56 355,185 7 ALTERATIONS 101 587,225 11 BATHING EQUIP 24 147,185 12 HOME MODFCTNS 9 57,396 21 CLOTHING 25 169,565 22 BANDAGES 43 258,438 31 MATTRESS/PADS 26 138,957 32 BEDS 54 288,190 33 FURNITURE 16 81,294 39 LIFTS&HOISTS 7 33,529 41 TOILETING EQP 52 279,603 42 OSTOMY SUPPLS 78 454,864 43 CATHETERS 18 82,756 44 DIAPERS 27 180,441 49 OT TOILTNG EQ 9 47,931 51 FEEDING MACHS 7 33,598 52 DENTURES 2 14,777 53 OT FEEDING EQ 7 36,749 61 BREATHNG EQUP 64 387,001 62 OXYGEN 136 737,860 63 OXYGEN EQUIPM 38 197,689 72 WALKRS/CRUTHS 5 47,946 73 ELEC WHEELCHR 3 22,995 74 NON-ELEC WCHR 15 60,956 75 CANES 4 12,635 76 BRACES 83 615,121 77 CHAIR LIFTS 7 22,954 79 OT AMBULRY EQ 24 170,529 81 BLOOD PRES EQ 24 178,944 82 HEART VALVES 3 12,617 83 HEART MONITOR 14 87,098 89 OT HEART ITEM 4 27,491 91 IV EQ & SUPLS 8 38,718 92 MISCELLANEOUS 48 296,482 93 TEST/MONTR EQ 38 266,495 94 PUMPS 7 33,890 95 SPECL TRANSPR 5 48,298 96 WARNNG DEVICE 17 89,713 97 OT HEARING EQ 1 10,525 98 STIMULATORS 6 39,678 99 HEATING PADS 21 157,971 TOTAL 11,010 73,767,437 OMECOD2X P18ED CODE FOR SPECIAL MEDICAL ITEM 2 2.0 NUM 46 47* VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 10,980 73,588,946 31 MATTRESS/PADS 1 8,108 32 BEDS 1 2,496 33 FURNITURE 1 5,224 41 TOILETING EQP 3 11,133 53 OT FEEDING EQ 1 4,154 72 WALKRS/CRUTHS 1 1,801 75 CANES 15 80,234 91 IV EQ & SUPLS 6 56,474 95 SPECL TRANSPR 1 8,867 TOTAL 11,010 73,767,437 Variable Position 48-87 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- OMECOD3X P18ED CODE FOR SPECIAL MEDICAL ITEM 3 2.0 NUM 48 49* VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 11,008 73,757,804 76 BRACES 1 3,984 94 PUMPS 1 5,648 TOTAL 11,010 73,767,437 ICD1 P19 ICD9 CODE-CONDITION 1 4.0 CHAR 50 53 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 114 745,829 V001-V999 301 2,128,131 X00X-X999 756 4,629,057 0001-9999 9,839 66,264,420 TOTAL 11,010 73,767,437 ICD2 P19 ICD9 CODE-CONDITION 2 4.0 CHAR 54 57 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 10,464 70,349,659 -9 NOT ASCERTAIN 114 745,829 V001-V999 4 30,383 X00X-X999 19 111,827 0001-9999 409 2,529,738 TOTAL 11,010 73,767,437 ICD3 P19 ICD9 CODE-CONDITION 3 4.0 CHAR 58 61 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 10,832 72,721,515 -9 NOT ASCERTAIN 114 745,829 X00X-X999 1 3,951 0001-9999 63 296,142 TOTAL 11,010 73,767,437 ICD4 P19 ICD9 CODE-CONDITION 4 4.0 CHAR 62 65 VALUE UNWEIGHTED WEIGHTED BY INCALPER -1 INAPPLICABLE 10,889 72,997,459 -9 NOT ASCERTAIN 114 745,829 0001-9999 7 24,149 TOTAL 11,010 73,767,437 DATEBMM P20 DATE FIRST ACQUIRED - MONTH 2.0 NUM 66 67 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 115 653,057 -8 DON'T KNOW 228 1,325,260 -7 REFUSED 3 13,548 -5 NEVER KNOW 89 519,264 1 JANUARY 1,300 8,288,978 2 FEBRUARY 975 6,560,947 3 MARCH 975 6,811,736 4 APRIL 836 5,612,993 5 MAY 801 5,407,001 6 JUNE 847 5,841,480 7 JULY 918 6,084,467 8 AUGUST 883 5,936,342 9 SEPTEMBER 687 4,783,709 10 OCTOBER 844 5,847,128 11 NOVEMBER 794 5,331,572 12 DECEMBER 715 4,749,955 TOTAL 11,010 73,767,437 DATEBDD P20 DATE FIRST ACQUIRED-DAY 2.0 NUM 68 69 VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 232 1,326,020 -8 DON'T KNOW 903 5,441,351 -7 REFUSED 4 18,177 -5 NEVER KNOW 311 1,968,658 1-31 9,560 65,013,232 TOTAL 11,010 73,767,437 DATEBYY P20 DATE FIRST ACQUIRED-YR 2.0 NUM 70 71 VALUE UNWEIGHTED WEIGHTED BY INCALPER 87 11,010 73,767,437 TOTAL 11,010 73,767,437 EXPTOT P24/P36 ORIGINAL TOTAL CHARGE 7.2 NUM 72 78 * VALUE UNWEIGHTED WEIGHTED BY INCALPER -9 NOT ASCERTAIN 48 261,320 -8 DON'T KNOW 502 3,025,337 -5 NEVER KNOW 223 1,376,753 -1 INAPPLICABLE 2,266 14,773,389 .01- 5.00 264 1,706,228 5.01- 50.00 2,696 18,050,529 50.01- 100.00 1,803 12,516,064 100.01- 200.00 2,240 15,550,710 200.01- 400.00 662 4,674,860 400.01- 600.00 124 748,818 600.01-1000.00 95 568,225 1000.01-4000.00 83 481,563 4000.01-8500.00 4 33,641 TOTAL 11,010 73,767,437 EXPTOTX EDITED TOTAL EXPENSE 7.2 NUM 79 85 * VALUE UNWEIGHTED WEIGHTED BY INCALPER .01- 5.00 264 1,706,228 5.01- 50.00 3,455 22,466,571 50.01- 100.00 2,641 17,652,220 100.01- 200.00 3,646 25,244,196 200.01- 400.00 694 4,849,861 400.01- 600.00 127 762,253 600.01-1000.00 95 568,225 1000.01-4000.00 84 484,242 4000.01-8500.00 4 33,641 TOTAL 11,010 73,767,437 EXPTFLG IMPUTATION FLAG FOR EDITED TOT EXP 1.0 NUM 86 86* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 EXP FROM HS 7,965 54,300,179 3 EXP IMPUTED 3,045 19,467,258 TOTAL 11,010 73,767,437 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 8.4 NUM 87 94 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 2,519 15,056,802 GT 0 TO 20 480 3,308,870 GT 20 TO 40 223 1,543,400 GT 40 TO 60 218 1,558,343 GT 60 TO 80 149 1,053,981 GT 80 TO LT 100 51 391,950 100 7,370 50,854,091 TOTAL 11,010 73,767,437 Variable Position 95-175 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 8.4 NUM 95 102 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 9,357 61,644,594 GT 0 TO 20 157 841,782 GT 20 TO 40 128 886,382 GT 40 TO 60 188 1,424,014 GT 60 TO 80 374 2,939,385 GT 80 TO LT 100 126 935,097 100 680 5,096,183 TOTAL 11,010 73,767,437 SOPTMCR PCT PAYMENT FROM MEDICARE 8.4 NUM 103 110 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 9,948 68,617,561 GT 0 TO 20 51 231,851 GT 20 TO 40 76 355,672 GT 40 TO 60 89 406,065 GT 60 TO 80 559 2,687,990 GT 80 TO LT 100 40 202,000 100 247 1,266,300 TOTAL 11,010 73,767,437 SOPTMCD PCT PAYMENT FROM MEDICAID 8.4 NUM 111 118 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,013 68,710,731 GT 0 TO 20 232 1,098,853 GT 20 TO 40 28 141,367 GT 40 TO 60 21 85,233 GT 60 TO 80 48 203,606 GT 80 TO LT 100 9 29,003 100 659 3,498,644 TOTAL 11,010 73,767,437 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 8.4 NUM 119 126 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,857 72,802,583 GT 0 TO 20 4 24,964 GT 20 TO 40 7 49,560 GT 60 TO 80 2 14,482 GT 80 TO LT 100 1 4,534 100 139 871,314 TOTAL 11,010 73,767,437 SOPTOTST PCT PAYMENT FROM OTHER STATE 8.4 NUM 127 134 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,873 72,980,815 GT 0 TO 20 57 329,880 GT 20 TO 40 9 55,451 GT 40 TO 60 8 48,760 GT 60 TO 80 10 49,690 GT 80 TO LT 100 4 18,543 100 49 284,299 TOTAL 11,010 73,767,437 SOPTWC PCT PAYMENT FROM WORKERS COMP 8.4 NUM 135 142 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,962 73,379,283 100 48 388,154 TOTAL 11,010 73,767,437 SOPTOTHR PCT PAYMENT FROM OTHER 8.4 NUM 143 150 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,905 73,075,683 GT 0 TO 20 8 50,002 GT 20 TO 40 9 55,315 GT 40 TO 60 5 26,902 GT 60 TO 80 11 61,223 GT 80 TO LT 100 4 36,077 100 68 462,234 TOTAL 11,010 73,767,437 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 8.4 NUM 151 158 VALUE UNWEIGHTED WEIGHTED BY INCALPER 0 10,916 73,127,834 GT 0 TO 20 9 40,952 GT 20 TO 40 5 37,776 GT 40 TO 60 3 21,012 GT 60 TO 80 5 32,470 100 72 507,392 TOTAL 11,010 73,767,437 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 1.0 NUM 159 159* VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 ALL SOP FRM HS 8,704 60,924,717 2 ALL SOP IMPUTD 2,306 12,842,720 TOTAL 11,010 73,767,437 INCALPER FULL-YEAR WEIGHT 12.6 NUM 160 171 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 942.69-23942.322 11,010 N/A TOTAL 11,010 N/A STRATUMX SAMPLING STRATUM 3.0 NUM 172 174 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 301-401 11,010 73,767,437 TOTAL 11,010 73,767,437 SPSU PSEUDO PSU 1.0 NUM 175 175 * VALUE UNWEIGHTED WEIGHTED BY INCALPER 1 5,408 36,089,877 2 5,602 37,677,560 TOTAL 11,010 73,767,437 Hlth Care And Meidcal Equipment And Supplies Data Codebook Notes General Information An asterisk in the rightmost column of a codebook indicates that an explanatory note provides greater detail on information necessary for the use of this variable. These notes are listed below in alphabetical order by variable name. Unless otherwise indicated, variables and variable names are identical across files. Home and Health Care and Medical Equipment VARIABLE NOTE CODEITMX Categories 1-7 in CODEITMX correspond to the pre- OMECOD2X listed categories indicating type of medical OMECOD3X equipment (File 2) in the survey instrument. Categories 11-99 represent all items referred to in the "other specify" text field. The handful of records that had more than one medical item listed in the "other specify" field of CODEITMX have up to two additional mentions coded in OMECOD2X and OMECOD3X. Possible positive values are: 1. Glasses/Contact lenses 2. Orthopedic Items 3. Hearing Aids/ Communication Devices 4. Diabetic Items 5. Ambulances 6. Prostheses 7. Alterations to home or car 11. Bathing Equipment 12. Home Modifications 21. Clothing 22. Bandages 31. Mattress/Pads 32. Beds 33. Furniture 39. Lifts and Hoists 41. Toileting Equipment 42. Ostomy Supplies 43. Catheters 44. Diapers 49. Other Toileting Equipment 51. Feeding Machines 52. Dentures 53. Other Feeding Equipment 61. Breathing Equipment 62. Oxygen 63. Oxygen Equipment 72. Walkers/Crutches 73. Electric Wheelchair 74. Non-electric Wheelchair 75. Canes 76. Braces 77. Chair Lifts 79. Other Ambulatory Equipment 81. Blood Pressure Equipment 82. Heart Valves 83. Heart Monitor 89. Other Heart Equipment 91. IV Equipment and Supplies 92. Miscellaneous 93. Test/Monitor Equipment 94. Pumps 95. Special Transportation 96. Warning Devices 97. Other Hearing Equipment 98. Stimulators 99. Heating Pads Supplies Data Codebook Notes DATEBMX This File 1 date represents the first visit DATEBDX of the home health care provider to the user. See DATEBYX section 1.2 for details. DATEEMX This File 1 date represents the last visit of DATEEDX the home health care provider to the user. See DATEEYX section 1.2 for details. DATEBFLG File 1 flags indicating the imputation of one or DATEEFLG more of the components of the beginning date (DATEBFLG) or the end date (DATEEFLG) for the home health care visits on the record. EN EN is provided on each File 2 record and identifies each event when an item(s) was purchased, rented or otherwise obtained for a person. EVENTIDX The unique record identifier on File 2. EXPTFLG File 2 flag indicating whether the total expense for the record was imputed or obtained directly from the household respondent. EXPTOT The unedited (EXPTOT) and edited total (EXPTOTX) EXPTOTX expense variables for File 2. See section 2.3 for details. INCALPER Weight adjusted for nonresponse and post- stratified to U.S. census data. Estimates of utilization and expenditures for the data on Files 1 and 2 require the use of weighted data. For details, see the Technical and Programming section on this file and the hard copy documentation accompanying this tape. LASTAGE An edited variable which identifies person age, in years, as of the end of the last round in 1987 for which the person was eligible. Less than 0.1 percent of the cases in NMES were edited. PROVCOD Identifies the specialty of the provider on each file record (File 1). PROVIDX Unique number identifying the home health agency employing the home health care provider on each record (includes self-employed). This File 1 variable may be used as a link to similar variables on NMES Public Use Tapes 9, 14.5 and 14.4 (usual source of care, ambulatory medical visit data and hospital stays data). The identifier consists of the ODUX variable plus a three digit number which was assigned to each facility reported by dwelling unit respondents. Since this number was assigned within a dwelling unit, this identifier is not unique across dwelling units. In order to link the files all identification variables provided for medical providers, physicians and place of care (PROVIDX, DOCRIDX, PLACEIDX and IHSANIDX; the last three are not provided on the current tape but are on NMES Tapes 9, 14.5 and 14.4) must first be renamed to a common variable name. Consistency across files for provider type has not been verified, e.g., a medical provider identified on the current file may link to a place of care on another file rather than a medical provider. PRVDKEY When used in concert with the ODUX variable, this File 1 variable identifies unique provider types. It is an edited version of PROVIDX. See PROVIDX. PROVTYPE This File 1 variable is an edited and constructed variable for questions H2 and H3 and the home health provider type. Possible values are: 1. Nurse, including nurses and nurse practitioners. 2. LPN, licensed practical nurses. 3. Physical Therapists 4. Other Therapists, including speech therapists, occupational therapists and any other form of therapist mentioned. 5. Home Health Aide 6. Homemaker 7. Doctor, including any type of physician that may have been reported. 8. Social worker, included psychologists 9. Other medical provider - including podiatrists, lab technicians, other technicians, midwives, and any other medical personnel not covered in the previous categories. PRVDWRKX File 1 variable identifying the type of place of employment of the home health provider. It was edited and constructed using the categories generated by the "other specify" response in question H5 and edited against the information from question H6. Possible values are: 1. Self-employed 2. Private Physician, any person employed in a private physician's office. 3. Hospital or clinic 4. Other Medical Organization 5. Visiting Nurse Association 6. Home Health Agency 7. Local Government Agency 8. Community Organization 9. Non-Home Health Organization 91. Other RACE3 A person-level variable constructed to facilitate the poststratification of the NMES person-level sampling weights by race and ethnicity, considering three mutually exclusive classifications: Hispanic, Black--non-Hispanic, and white or other. RACE6 An edited variable indicating race. Less than 0.2 percent of cases were edited. RECIDX The unique record identifier on File 1. ROUND Indicator of the round of data collection (applies to File 2 only). Dates for each sample person's rounds of data collection are provided on NMES Public Use Tape 13. SOPTFLG A flag indicating whether all the source of payment percentages for that record were imputed or provided by the household respondent. Applies to Files 1 and 2. SPSU To obtain variance estimates of sample statistics STRATUMX by means of standard statistical programs that use the Taylor series linearization method of variance estimation, variables must be used that denote the strata and primary sampling unit (PSU) within a given strata. The variables STRATUMX and SPSU are these variables, respectively. For details on sampling weights and variance estimation, see Section 5 of the documentation. TMPROVSX This edited File 1 variable indicates the time of day the set of visits occurred and incorporates information from the home health questionnaire (H47) on the length of stay. If the length of stay was calculated to be greater than 12 hours, this variable was edited to reflect the fact that the visit must have occurred in both night and day. VISLGTHX File 1 variable representing the average length of visit by the home health provider. Constructed variable which combines information from question H8 and H47. Since each record reflects the cumulation of data for visits over the period of the survey year, the question referring to the usual visit length was used to create a weighted average across visits. If these data were missing for any one or more rounds, information on the length of stay for a particular visit (H8) was used in its place. All answers were converted to minutes to give a uniform unit of measure. VISTNUMX File 1 variable indicating the total number of visits per record by the specific home health care provider for 1987. It is a constructed and edited variable using questions H34, H35 and H36. See Section 1.2 for details. VISTNFLG File 1 flag indicating if home health visits were imputed for at least one round of data collection. VISTEXPX File 1 variable indicating the average visit expense for each home health care provider, per record. This is a constructed variable based on the visit charge information collected in both the Household Survey and the Medical Providers Survey. See Section 1.4 for details. VISTEFLG File 1 flag indicating whether the source of data, for the number of visits per record came from either the MPS, the Household Survey or was imputed.