Scientific Data DocumentationAmbulatory Medical Visit, 1987This compressed file contains 4 data sets for the NMES 1987 Ambulatory data:
DATA1 DATA2 DATA3 SRC 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 micro-data tapes available for purchase was supplied to the Agency for statistical summaries and health services research. It is necessary, therefore, that the individual ordering such micro-data tapes sign the following assurance: By using this documentation, 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.ABSTRACT 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 the 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 East 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 information and related documentation on the use of and expenditures for ambulatory medical services for calendar year 1987. This tape contains three data files: (1) visits and telephone calls to physician's offices (including HMOs and health departments) in settings other than a hospital or at home, and to other providers of care (e.g. chiropractors and psychologists), (2) visits to hospital outpatient departments, and (3) hospital emergency room visits, both regardless of provider type. A record on any of these data files represents a unique ambulatory visit. In addition, each record contains basic person-level demographic information for the respective user, dates of visits, medical conditions associated with the visit, and variables such as types of procedures performed and the main reason for the visit. The records on this tape represent all persons in the civilian noninstitutionalized population who reported ambulatory medical visits during calendar year 1987 and who responded for their entire period of eligibility. Taken together, they represent all instances in which the person made an ambulatory visit to a medical provider during 1987. Excluded from this tape are persons who were admitted and discharged from a hospital on the same day and had no other ambulatory care visits. The variables on the tape can be used to construct summary variables of expenditures, sources of payment, and other aspects of the use of ambulatory care. Information on persons in the Household Survey without ambulatory visits in 1987 is provided on NMES Public Use Tape 13. Tape 13 also contains annual person-level information on other health services use as well as detailed demographic, employment, insurance, round specific eligibility status indicators and reference period dates for the entire civilian noninstitutionalized population. The data file records on the current tape can be linked to all NMES public use tapes from the Household Survey by using the person identifier (PIDX). The data on this tape are being released as three 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 following documentation offers a brief overview of the type and level of data provided, the content and structure of the data files and the codebooks, and programming information. It contains the following sections: Structure and Contents of the Data Files Variable Naming and Codebook Conventions Sample Design and Response Rates Estimation and Sampling Weights Programming Information References Data Dictionaries Alphabetical and Positional Listing of Variables on File 1 - Medical Provider Visits Codebook for File 1 Alphabetical and Positional Listing of Variables File 2 - Hospital Outpatient Visits Codebook for File 2 Alphabetical and Positional Listing of Variables on File 3 - Emergency Room Visits Codebook for File 3 Codebook Notes for Files 1, 2 and 3. More detailed information on NMES survey instruments and data collection procedures, variance estimation programs, and coding and related information are in Attachments 1 to 8, which are provided as hard-copy attachments to the documentation. Attachment 8 contains a catalogue of data items released on this and other NMES Household Survey 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. Structure and Contents of the Data Files General Information This public use tape contains three data files and represents the data collected by means of three separate visit booklets in NMES. In addition, expenditure information from the NMES Medical Provider Survey (MPS) was used to supplement expenditure data obtained in the Household Survey. To expedite release of data and ensure data processing efficiency, the structure of the files generally reflects the structure of the applicable household questionnaire (see Attachments 1, and 3 through 5 for the instruments used). The files contain information on ambulatory services, expenses, and sources of payment as obtained in four rounds of interviews covering calendar year 1987. Each record on these data files represents a unique visit during 1987, regardless of the file. The persons represented on this tape include all sampled users of ambulatory services in calendar year 1987 who responded for their entire period of NMES eligibility. Unless otherwise indicated, variables and variable names are identical across files. The medical provider visit file (File 1) contains 156,957 records, the hospital outpatient visit file (File 2) 20,648 records, and the hospital emergency room visit file (File 3) 8,249 records. An ambulatory visit is defined as a single contact with a medical provider for one or more services in either a hospital outpatient department or emergency room, or in a setting (such as a physician's office, a clinic, or a lab) other than an inpatient hospital, a nursing home, or a person's home. Each record on the medical provider visit, hospital outpatient visit and hospital emergency visit files contains the following information: Unique person and record identifiers Indicator of the round of data collection Selected demographic variables Variables based on questionnaire items J1 through J43 for medical provider visits (File 1), F1 thru F60 for hospital outpatient visits (File 2) and E1 thru E56 for emergency room visits (File 3) - They include the ICD-9 codes representing the conditions for each medical event, dates of the visit, the total expense and sources of payment as well as associated imputation flags. Also included on the medical provider visit file (File 1) and the hospital outpatient visit file (File 2) are questions regarding the type of health professional and the specialty of the medical provider seen during the visit, the location at which services were delivered, the reason for the visit, and the types of procedures performed. Included on the emergency room visit file (File 3) only are variables representing whether or not the visit was a result of a referral, the travel time to and waiting time in the emergency room, and whether the emergency room visit resulted in an immediate hospital admission. Weights and variance estimation variables Detailed information on coding of medical conditions and procedures is provided in Section 1.1. The construction of the expense and source of payment variables and associated imputation procedures are described in Sections 1.2 and 1.3. A summary of the edits and omissions for the three files is provided in Section 1.4. Additional details on selected File 1, 2 or 3 variables are provided in the codebook notes which immediately follow the codebook for File 3. Condition and Procedure Coding Medical Condition Coding The three data files on this tape contain up to four condition codes per visit. For each ambulatory medical visit reported in the Household Survey, information on reasons for use, in terms of related medical conditions, medical diagnosis, if any, related history, and parts of the body affected by the condition were obtained. This information was used to code each condition related to the reported use 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 6A provides details of the NHIS coding scheme for X-codes. The first condition on a record does not necessarily reflect the primary condition for the sample person and, more generally, the order of the conditions on the record does not reflect importance or severity. In addition, there is a small probability that duplicate conditions are attached to the same record. No editing to eliminate these duplications was done. Procedure Coding Each data file can contain a single procedure code per record. For each ambulatory visit reported in the Household Survey, questions were asked about operations or surgical procedures performed during that visit. The respondent-reported procedure was used to code to one of the codes in the 9th Revision of the International Classification of Diseases, Clinical Modification, 3 (ICD9-CM3) revised for use in the National Health Interview Survey (NHIS; NCHS, 1979). The revision uses only the first two digits of the ICD9-CM3 which indicates the body system or region on which the procedures was performed. For miscellaneous diagnostic and therapeutic procedures, the code represents a general procedure class, for example, "diagnostic radiology" or "physical or rehabilitative procedures". Attachment 6B provides the codes for medical procedures. Quality Control Coding for conditions and medical procedures 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. No additional editing or imputation was performed on these variables. Expenses and Imputation of Expenses General Information The medical provider visit file (File 1) contains only one expense variable, which reflects the total expenses associated with each visit. The hospital outpatient department and emergency room visit files (Files 2 and 3) contain both facility and doctor expense variables for each hospital outpatient department or emergency room visit made by sample persons during 1987. These files also contain a combined expense variable which equals the sum of the separate facility and doctor expense variables for each visit (EXPTOTX). Total expenses on these data files 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 health insurers, Medicare, or Medicaid. Second, a dollar value was assigned to each service in settings that do not specify a total charge for such services. For example, there is no stated total charge (although there may be copayments) for each visit to a provider in an HMO, where care is financed through a prepaid capitation payment rather than on a fee-for-service payment basis. Also, providers who are financed out of budgets of governments, charities, and other organizations may not specify charges for their services. In these cases where the expense was not otherwise accounted for, a total expense value was imputed from the expenses associated with similar types of services. This approach was also used for most flat fee arrangements, when a respondent reported one lump sum charge that applied to a number of different medical services and there was no reasonable method of allocating that charge among them. Where the reported total expense for the visit appeared to be a copayment rather than the total cost for the event, the total expense was set to missing and imputed, as described below, to reflect the total cost rather than the copay amount. The total expense was also set to missing and imputed for cases that appeared to be extreme outliers. In cases where the respondent stated a visit was "free from provider", but the person was enrolled in an HMO or was a Medicaid recipient, the total expense was imputed. Zero total expenses occur only in situations where the charge for a particular service is included with other charges. For example, emergency room charges were often included with inpatient stay charges when the emergency room visit led directly to an inpatient hospitalization. As a result there are a relatively large number of records with zero facility expenses in the emergency room visit file. There are also a large number of zeros in the doctor expense variables on Files 2 and 3 because doctor expenses are often included in the facility charges of hospital outpatient departments and emergency rooms. The edited expense variables adjust for missing or inconsistent values by a series of edits and imputations. These addressed three major issues: (1) potential copayment amounts which were mainly charges reported at the lower extreme of the total expense distribution; (2) potential flat fees which encompassed multiple visits over a course of treatment and were mainly visit charges at the upper extreme of the total expense distribution; and (3) missing charges where care was delivered under a prepaid arrangement such as an HMO, covered by a flat fee or by Medicaid, or otherwise not reported by the respondent. Weighted sequential hot deck imputation was used to replace cases with missing data. This procedure imputes data to events with missing data from events with complete data, where the events have similar characteristics. Cases with known values on characteristics of the person and other variables shown to be correlates of total expense and to distinguish persons with data from their missing data counterparts were used to form groups of donors for the cases with identical person and correlation information but with missing total expenses (called recipients). This procedure also takes into account the complex survey design and weights associated with persons with missing and nonmissing data. All imputations were done at the visit level with the exception of repeat visits (see Section 1.4). Imputation flags are provided for all expense variables. Total Expense for File 1 Both unedited (EXPTOT) and edited (EXPTOTX) expense variables are included on the medical provider visit file. Where possible, expense data were obtained from linked records in the NMES Medical Provider Survey (MPS), which obtained provider information for a sample of medical events reported by household respondents (see Section 3.1.2 for brief description of the MPS). If MPS data were not available, expenses as reported by the household respondent were used. If household reported data were not available the expense was imputed using either MPS or household reported data as the source data for the imputation. Imputations of expenses for medical provider visits (EXPTOTX) were performed according to type of provider (physician, chiropractor, podiatrist, optometrist, psychologist, others working for a medical doctor, and others not working for a medical doctor). While the variables used to form groups of donors and recipients by the type of provider differed somewhat across imputations in the medical provider visits file, in general the variables used were the following: if any test was performed during the visit, if a third party was a source of payment for the visit, the patient's race and education, the Medicare prevailing charge index for specialists and general practitioners for the county in which the sampled person resided (obtained from the 1987 Area Resource File), region of the country, and type of medical condition. Facility Expense for Files 2 and 3 General Information Both unedited (EXPFAC) and edited (EXPFACX) facility expense variables are included on the hospital outpatient visit and emergency room files (Files 2 and 3). Facility expenses comprise all expenses associated with visits except those of physicians who bill the patient separately from the emergency room or outpatient department. As with the medical provider visit file, where possible, facility expense data were obtained from linked records in the Medical Provider Survey. If MPS data were not available, facility expenses as reported by the household respondent were used. If household reported data were not available, the facility expense was imputed using only MPS data as the source data for the imputation. Facility Expenses for Outpatient Visits (File 2) Missing facility expenses for outpatient visits were imputed using a weighted sequential hot deck procedure. The variables used to form the donor and recipient groups were: whether or not the patient had cataract surgery, whether or not the patient saw a physician, region of the country, use of Medicaid as a source of payment and performance of any diagnostic test. The edited variable EXPFACX reflects this imputation on File 2. Facility Expenses for Emergency Room Visits (File 3) Missing facility expenses for emergency room visits were imputed with a weighted sequential hot deck using as classification variables: whether or not the patient had an x- ray, a cat scan, imaging, or surgery; type of residence of patient (SMSA, Non-SMSA), region of the country, age, number of activities of daily living for which the patient needed assistance, perceived health status, the cost of malpractice insurance for physicians in the MSA or state (outside of MSAs) of the sampled person, and Medicaid or Medicare as a source of payment. The edited variable EXPFACX on File 3 reflects this imputation. Physician Expenses for Files 2 and 3 Because household respondents often do not accurately report the physicians seen in conjunction with emergency room or hospital outpatient department visits, charges for physician services associated with visits billed separately from the facility charges were derived entirely from the Medical Provider Survey. The variable EXPDRX (provided on both Files 2 and 3) is the sum of expenses for all separately billing doctors for a visit. In the Medical Provider Survey, physicians who were listed in the medical records for a given visit to an emergency room or hospital outpatient department were enumerated by specialty and contacted to determine the charges rendered for the visit. When physician nonresponse yielded partial expenditure data for a visit, the missing elements were imputed using the mean MPS charge for a physician of that specialty. When all physician charges were missing, the total was imputed using procedures described for the facility charge (Section 1.2.2). Total Expense for Files 2 and 3 The total expense variable (EXPTOTX) on the outpatient and emergency room files (Files 2 and 3) is the sum of the facility (EXPFACX) and the physician expenses (EXPDRX) for a visit. Sources of payment Each record on the medical provider visit file (File 1) contains 9 constructed variables which sum to 100 percent, corresponding to the percent of the total expense paid by each of the following sources: Out of pocket by user or family; Private insurance; Medicaid; Medicare; Other Federal programs, which include CHAMPUS, CHAMPVA, Supplemental Security Income (SSI), Indian Health Service facility or contract, 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 programs, 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. HMO provided visits were assigned to a source of payment according to the insurance status of the person who had the visit. For example, if an individual had private insurance and the visit was covered by an HMO plan, the source of payment was set to private. The hospital outpatient department and emergency room visit files (Files 2 and 3) contain two separate sets of source of payment variables, one for the facility and a second for the physician expenses for each visit. The source of payment variables are based on respondent reports of the percent or amount paid by each of these sources of payment. Edits or imputations were performed under the following circumstances: (1) the payer reported by the household was incompatible with enrollment in public and private insurance programs reported for the person; (2) the person was not billed for the visit so that no expenses 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. As for the expense variables on all three files, the general imputation strategy for sources of payment used a weighted sequential hot deck procedure. Source of payment imputations were conditional upon insurance coverage. The classification variables included insurance coverage, region, date of visit, whether the respondent had reported a specific charge, and union membership of the primary insured. In addition, visits with missing source of payment information and for which a Veteran's Administration facility was the site of care (on File 1 question J6=1 or question J22=4; on File 2 question F3=1 or question F16=4 or question F36=4; on File 3 question E4=1 or question E16=4 or question E36=4), were assigned to the other Federal category as the sole source of payment. Each record with imputed values contains a corresponding imputation flag. Other Edits and Omissions General Information Some data items from the medical provider, the hospital outpatient department, and the hospital emergency room questionnaires were omitted from these files because they were components or probes used to construct the summary variables provided. Omitted variables were not considered to be of independent analytic interest but rather were methodological probes to insure that the respondent had provided complete utilization and expenditure information. The summary variables included on this file, such as total expense, reflect all of the components collected in the medical provider visits, the hospital outpatient visits or the hospital emergency room visits booklets. Other omitted variables are box items for use by the interviewer in following skip patterns, interview times and names, and items related to the confidentiality of sample persons or respondents. Unless indicated, all variables on these files are unedited. Skip patterns associated with unedited variables have not been reconciled. No editing was performed on the round indicator provided on these files. Verification was performed on all link variables except DOCRIDX, PLACEIDX and PROVIDX. Repeat Visits Questions pertaining to repeat visits (i.e., F55-F59 in the outpatient visit questionnaire and J38-J42 in the medical provider visit questionnaire) are not represented by separate variables on these files. Instead, to increase data processing efficiency, the data collected in these questions are represented as separate records, with each record representing a single visit. VISITIDX is the unique record identifier for each outpatient department or medical provider visit. It concatenates ODUX, PN, EN and RVISN. The ODUX identifies the dwelling unit. The PN represents the person number. The event number, EN, identifies an initial contact with a given provider for specific services during a round. RVISN is the numerical identifier for any repeat visit within one data collection round to the same provider for the same services at the same expense. The value for RVISN for the first visit equals zero and all repeat visits associated with that visit are numbered consecutively (RVISN = 1 to n). The first visit and all of the repeat visits share the same event number (EN). All characteristics of the initial visit (except the date) are assigned to the repeat visits. Type of Provider A variable ascertaining the type of provider seen during a medical provider visit (MVISCLAS) is included on File 1. It was constructed based on both information reported on the doctor roster developed during the survey year and from selected questions in the medical provider visits booklet. This variable is not in all cases consistent with the specialty information provided in questions J10 and J12. Persons with Zero Night Stays In a number of cases, hospital outpatient department visits may have been reported by the household respondent as a hospital admission, but with admission and discharge dates on the same calendar day. Since these events were reported as hospital admissions they, and related expenditures and sources of payments, are included on the hospital stays file (NMES Public Use Tape 14.4, Household Survey, Hospital Stays, Calendar Year 1987). In order to provide a more complete picture of persons with ambulatory hospital use, persons with both outpatient department use and zero night hospital stays can be identified with the person-level variable ZERONITE provided on File 2. Persons with only zero night stays are not included on the outpatient department file (File 2), see Section 4.1. Variable Naming and Codebook Conventions Three codebooks are provided, one for each file. The codebooks provide unweighted and weighted frequencies for all variables on the files. These codebooks contain variable information and frequency distributions for the following: A total of 156,957 records for the medical provider visits file, A total of 20,648 records for the outpatient department visit file, A total of 8,249 records for the emergency room visits file. Weighted, these records represent: 1,112,032,040 visits to a medical provider by 171,936,150 people (156,957 unweighted visits by 24,336 people); 131,906,328 visits to a hospital outpatient department by 41,521,102 people (20,648 unweighted visits by 6,216 people) 53,424,204 visits to a hospital emergency room by 37,702,370 people (8,249 unweighted visits by 5,728 people). 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 medical provider visit, hospital outpatient department visit and hospital emergency room visit booklets are included as Attachments 3 through 5 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 places 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 An asterisk indicating an explanatory note(s) corresponding to the variable. Explanatory notes can be found in the Codebook Note Section 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. Variables common to more than one file (e.g. conditions associated with the visit) are identically named for ease of data processing. 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 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 the National Opinion Research Center at the University of Chicago. To improve the quality of the data and to allow for analysis of trends during 1987, the Household Survey 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). 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 estimates (See Attachment 1B for a full discussion of MPS design and objectives). 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 ambulatory care 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 24,336 persons who have positive INCALPER weights and who received ambulatory care at a medical provider's office are represented on the medical provider visit file. Similarly, only the 6,552 persons who have positive INCALPER weights and who received care at an outpatient department are represented on the hospital outpatient department file. And finally, only the 5,728 persons who have positive INCALPER weights and who received ambulatory care at an emergency room are represented on the hospital emergency room file. In order to produce national estimates related to the site, the frequency of use, and expense and sources of payment for ambulatory care, 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). For estimates involving persons in the Household Survey not on these files (e.g., persons without use of any ambulatory care services 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. (see Section 4.3) using the person-level identification variable PIDX. Basic Estimates of Utilization and Expenditures These files are constructed for efficient estimation of utilization and expenditures for ambulatory care. Such estimates include the total number of and expenses for ambulatory care visits. The mean expense for emergency room visits, for instance, should be calculated as the weighted sum of the total expense across all records in File 3, the Hospital Emergency Room visit file (sum of EXPTOTX x INCALPER on File 3) divided by the weighted sum of the number of emergency room visits (sum of INCALPER on File 3). Thus, the numerator is the national estimate for total expenses for emergency room care, and the denominator is the population estimate for the total number of emergency room visits. Subsetting to records based on characteristics of interest expands the scope of potential estimates. For example, the number of medical provider visits paid for, totally or in part, by private insurance is estimated by summing INCALPER on File 1 across all records in File 1 for which the private insurance source of payment variable (SOPTPRVT) is greater than zero. To analyze data from these 3 files for ambulatory care across sites, any two or all three files may be concatenated to create a single data set containing all of the observations from the input data files. However, the contents of these files are not totally identical. Where feasible and appropriate, variables have been named consistently across files. The variables MVISCLAS and SEETLKMX on File 1, the Medical Provider Office visit file, can be used to replicate the physician utilization data provided on NMES Public Use Tape 13. MVISCLAS equal to 2 identifies office visits to physicians (DRVISITS on Tape 13), while MVISCLAS greater than 2 indicates an office visit to a nonphysician (NONDRVIS on Tape 13). For records with MVISCLAS equal to 1, which indicates that the service was provided by phone, use the variable SEETLKMX (on file 1 of the current tape) to distinguish calls taken by physicians (DRTEL on Tape 13) from those taken by nonphysicians (NONDRTEL on Tape 13). In order to replicate all the hospital outpatient department utilization data provided on NMES Tape 13, zero night hospital stays (NUMNGHTX = 0) from Public Use Tape 14.4 - HHS Hospital Stay data should be included with the outpatient department visits on File 2 of the current tape to produce estimates. To reconstruct the Tape 13 variable DROPD (i.e. outpatient visits to physicians), combine the zero night hospital stays from Public Use Tape 14.4 with the outpatient department records which have SEEDOCX equal to 1 from File 2 of the current tape. SEEDOCX not equal to 1 on File 2 on the current tape identifies outpatient visits to medical providers other than physicians (NONDROPD on Tape 13). Emergency room visit data is defined identically on File 3 of the current tape and on Public Use Tape 13. To identify records for emergency room visits which resulted in hospitalization (EROMHO on Tape 13) select records on File 3 for which the variable ADMTHOSX equals 1. Person-Based Ratio Estimates Person-Based Ratio Estimates for Persons with Use of Ambulatory When calculating ratio estimates where the denominator is persons, not ambulatory medical visits, care should be taken to properly define and estimate this denominator. If the estimate of interest, for example, is the mean charge for all the visits to outpatient departments across all users of outpatient services, not including zero night hospital stays, the following strategy should be considered. All expenses for a person on the hospital outpatient department visit file (File 2) should be summed and a person-level total charge variable created (e.g., the variable X). The mean national estimate for outpatient department visit expense would then be derived by obtaining the ratio of the weighted sum of total expense per person across all unique persons (each unique value of PIDX) on the file (sum of INCALPER times X on File 2) divided by the weighted number of unique persons on the file (sum of INCALPER) on File 2. Only one INCALPER value for each PIDX (i.e. each person) should contribute to the calculation of the sum for this denominator and numerator. Person-Based Ratio Estimates Relative to the Entire Population If the ratio relates to the entire population, this tape cannot be used to calculate the denominator, as only those persons with at least one ambulatory visit to a provider's office, to an emergency room or to an outpatient department are represented on this tape. In this case, Public Use Tape 13 -- Rounds 1-4 Household Survey: Population Characteristics and Person-level Utilization, which has data for all sample people, must be used to estimate persons. For example, to estimate the proportion of children 5 to 12 years of age with at least one office visit for streptococcal sore throat, File 1 of the current tape 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 previously released public use data tapes (see Attachment 7). 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 emergency room use or expenditures (from File 3 of the current 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 emergency room visits 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 adjustment 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 included on the present tape. 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 Medical Provider Visit Data File Dataset Name: NMES.PUF145.DATA1 Number of Observations: 156,957 Number of Variables: 69 Record Length: 270 Block Size: 2,700 Record Format: FB FILE 2: Description: NMES Household Survey Hospital Outpatient Visit Data File Dataset Name: NMES.PUF145.DATA2 Number of Observations: 20,648 Number of Variables: 91 Record Length: 375 Block Size: 15,000 Record Format: FB FILE 3: Description: NMES Household Survey Hospital Emergency Room Visit Data File Dataset Name: NMES.PUF145.DATA3 Number of Observations: 8,249 Number of Variables: 72 Record Length: 352 Block Size: 23,232 Record Format: FB FILE 4: Description: Technical and Programming Information and Data Dictionary for the NMES HHS Ambulatory Medical Visit Data File Dataset Name: NMES.PUF145.DOC Record Length: 133 Block Size: 19,950 Record Format: FB FILE 5: Description: Additional Documentation for SAS Users for the NMES HHS Ambulatory Medical Visit Data File Dataset Name: NMES.PUF145.SRC Record Length: 80 Block Size: 800 Files 1-3 were created using the SAS (Version 5.18) computer software, and converted to EBCDIC format. File 4 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, to modify with a text editor program such as WYLBUR, or to make additional copies. File 5 is an EBCDIC file containing the following additional documentation for SAS users: INPUT statements to create SAS files, including LABEL statements; 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. U.S. Bureau of Health Professions (1987). Area Resource Files (ARF): Rockville, MD: U.S. Department of Health and Human Services, U.S. Bureau of Health Professions. DATA DICTIONARIES Alphabetical Listing of Variables NMES AMBULATORY MEDICAL VISIT DATA FILE 1 MEDICAL PROVIDER VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 14, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- Variables A-SMP START END NAME DESCRIPTION ----- --- ---- ----------- 78 79 APTWLKIN J7 PID HAD APPOINTMENT OR WALKED IN 140 141 CULTURE J18C PID HAD CULTURE, OTHER LAB TEST 142 143 CULTUREX J18C ED PID HAD CULTURE, OTHER LAB TEST 61 62 DATEBDD J1 MED PROV VISIT DATE - DAY 59 60 DATEBMM J1 MED PROV VISIT DATE - MONTH 63 64 DATEBYY J1 MED PROV VISIT DATE - YEAR 144 145 DIAGTEST J18D PID HAD EKG, EEG, OTHER DX TEST 146 147 DIAGTESX J18D ED PID HAD EKG, EEG, OTHER DX TEST 100 107 DOCRIDX J12 ID OF DOCTOR 108 109 DRCOD J12 DOCTOR SPECIALTY 9 12 EN EVENT NUMBER 23 34 EVENTIDX EVENT ID (ODUX + PN + EN) 169 169 EXPTFLG IMPUTATION FLG FOR ED TOT MED PROV EXPEN 154 161 EXPTOT J23 ORIGINAL TOTAL MED PROV CHARGE/VISIT 162 168 EXPTOTX EDITED TOTAL MED PROV EXPENSE/VISIT 114 117 ICD1 J15/J17 ICD9 CODE - CONDITION 1 118 121 ICD2 J15/J17 ICD9 CODE - CONDITION 2 122 125 ICD3 J15/J17 ICD9 CODE - CONDITION 3 126 129 ICD4 J15/J17 ICD9 CODE - CONDITION 4 243 244 IHSFAC J43 FACILITY IS IHS OR TRIBE/ANC 245 256 INCALPER FULL-YEAR WEIGHT 51 53 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 130 131 MPDISCVR J16 PROVIDER DISCOVERED OTHER CONDITION 75 75 MVISCLAS PROVIDER TYPE FOR VISIT 1 5 ODUX ORIGINAL DWELLING UNIT OF PID 15 22 PIDX PERSON ID (ODUX + PN) 6 8 PN PERSON NUMBER 67 68 PREFBYMD J3 PID REFERD BY OTHER MD OR MED PROVIDR 58 58 PREGFLG VISIT RELATED TO PREGNANCY 152 153 PROCCODE J19 PROCEDURE CODE 94 95 PROVCOD J10 PROVIDER SPECIALITY 86 93 PROVIDX J10 ID OF PROVIDER 110 111 PRSNPROV J13 MAIN REASON FOR MED PROVIDER VISIT 96 97 PRVWKMD J11 PROVIDER WORKS FOR A DOCTOR 98 99 PRVWKMDX J11ED PROVIDER WORKS FOR A DOCTOR 56 56 RACE3 PID RACE/ETHNICITY 55 55 RACE6 ED PID RACE 65 66 REFBYHMO J2 PROVIDR FROM/REFERD BY PIDS HMO/OTHER 49 50 ROUND DATA COLLECTION ROUND 13 14 RVISN VISIT NUMBER 136 137 SCAN J18B PID HAD CT, SONO, OTHER SCAN 138 139 SCANX J18B ED PID HAD CT, SONO, OTHER SCAN 82 83 SEETLKMD J9 PID SAW/TALK TO MED PROV DURING VISIT 84 85 SEETLKMX J9ED PID SAW/TALK TO MED PROV DURING VIS 69 70 SEETLKPV J4 PERSONAL OR PHONE VISIT 71 72 SEETLKPX J4ED PERSONAL OR PHONE VISIT 80 81 SETPCALL J8 PID CALLED OR APPT WAS SET BY PROVIDR 54 54 SMPSEXR PID SEX Variables SOP-XZA START END NAME DESCRIPTION ----- --- ---- ----------- 234 241 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 242 242 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 194 201 SOPTMCD PCT PAYMENT FROM MEDICAID 186 193 SOPTMCR PCT PAYMENT FROM MEDICARE 202 209 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 226 233 SOPTOTHR PCT PAYMENT FROM OTHER 210 217 SOPTOTST PCT PAYMENT FROM OTHER STATE 178 185 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 170 177 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 218 225 SOPTWC PCT PAYMENT FROM WORKERS COMP 260 260 SPSU PSEUDO PSU 57 57 SREGION PID CENSUS REGION 257 259 STRATUMX SAMPLING STRATUM 148 149 SURGERY J18E PID HAD SURGICAL PROCEDURE 150 151 SURGERYX J18E ED PID HAD SURGICAL PROCEDURE 76 77 VAFACLTY J6 PLACE WAS A FACILITY OF THE VET ADMIN 35 48 VISITIDX VISIT ID (ODUX + PN + EN + RVISN) 73 74 WHRSEEMP J5 PLACE OF MED PROV VISIT 132 133 XRAY J18A PID HAD X-RAY 134 135 XRAYX J18A ED PID HAD X-RAY 112 113 XZATCOND J14 VISIT WAS FOR SPECIFIC CONDITION Positional Listing of Variables NMES AMBULATORY MEDICAL VISIT DATA FILE 1 MEDICAL PROVIDER VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 14, 1992 -----POSITIONAL LISTING OF VARIABLES----- Variables 1-144 START END NAME DESCRIPTION ----- --- ---- ----------- 1 5 ODUX ORIGINAL DWELLING UNIT OF PID 6 8 PN PERSON NUMBER 9 12 EN EVENT NUMBER 13 14 RVISN VISIT NUMBER 15 22 PIDX PERSON ID (ODUX + PN) 23 34 EVENTIDX EVENT ID (ODUX + PN + EN) 35 48 VISITIDX VISIT ID (ODUX + PN + EN + RVISN) 49 50 ROUND DATA COLLECTION ROUND 51 53 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 54 54 SMPSEXR PID SEX 55 55 RACE6 ED PID RACE 56 56 RACE3 PID RACE/ETHNICITY 57 57 SREGION PID CENSUS REGION 58 58 PREGFLG VISIT RELATED TO PREGNANCY 59 60 DATEBMM J1 MED PROV VISIT DATE - MONTH 61 62 DATEBDD J1 MED PROV VISIT DATE - DAY 63 64 DATEBYY J1 MED PROV VISIT DATE - YEAR 65 66 REFBYHMO J2 PROVIDR FROM/REFERD BY PIDS HMO/OTHER 67 68 PREFBYMD J3 PID REFERD BY OTHER MD OR MED PROVIDR 69 70 SEETLKPV J4 PERSONAL OR PHONE VISIT 71 72 SEETLKPX J4ED PERSONAL OR PHONE VISIT 73 74 WHRSEEMP J5 PLACE OF MED PROV VISIT 75 75 MVISCLAS PROVIDER TYPE FOR VISIT 76 77 VAFACLTY J6 PLACE WAS A FACILITY OF THE VET ADMIN 78 79 APTWLKIN J7 PID HAD APPOINTMENT OR WALKED IN 80 81 SETPCALL J8 PID CALLED OR APPT WAS SET BY PROVIDR 82 83 SEETLKMD J9 PID SAW/TALK TO MED PROV DURING VISIT 84 85 SEETLKMX J9ED PID SAW/TALK TO MED PROV DURING VIS 86 93 PROVIDX J10 ID OF PROVIDER 94 95 PROVCOD J10 PROVIDER SPECIALITY 96 97 PRVWKMD J11 PROVIDER WORKS FOR A DOCTOR 98 99 PRVWKMDX J11ED PROVIDER WORKS FOR A DOCTOR 100 107 DOCRIDX J12 ID OF DOCTOR 108 109 DRCOD J12 DOCTOR SPECIALTY 110 111 PRSNPROV J13 MAIN REASON FOR MED PROVIDER VISIT 112 113 XZATCOND J14 VISIT WAS FOR SPECIFIC CONDITION 114 117 ICD1 J15/J17 ICD9 CODE - CONDITION 1 118 121 ICD2 J15/J17 ICD9 CODE - CONDITION 2 122 125 ICD3 J15/J17 ICD9 CODE - CONDITION 3 126 129 ICD4 J15/J17 ICD9 CODE - CONDITION 4 130 131 MPDISCVR J16 PROVIDER DISCOVERED OTHER CONDITION 132 133 XRAY J18A PID HAD X-RAY 134 135 XRAYX J18A ED PID HAD X-RAY 136 137 SCAN J18B PID HAD CT, SONO, OTHER SCAN 138 139 SCANX J18B ED PID HAD CT, SONO, OTHER SCAN 140 141 CULTURE J18C PID HAD CULTURE, OTHER LAB TEST 142 143 CULTUREX J18C ED PID HAD CULTURE, OTHER LAB TEST 144 145 DIAGTEST J18D PID HAD EKG, EEG, OTHER DX TEST Variables 146-260 START END NAME DESCRIPTION ----- --- ---- ----------- 146 147 DIAGTESX J18D ED PID HAD EKG, EEG, OTHER DX TEST 148 149 SURGERY J18E PID HAD SURGICAL PROCEDURE 150 151 SURGERYX J18E ED PID HAD SURGICAL PROCEDURE 152 153 PROCCODE J19 PROCEDURE CODE 154 161 EXPTOT J23 ORIGINAL TOTAL MED PROV CHARGE/VISIT 162 168 EXPTOTX EDITED TOTAL MED PROV EXPENSE/VISIT 169 169 EXPTFLG IMPUTATION FLG FOR ED TOT MED PROV EXPEN 170 177 SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 178 185 SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 186 193 SOPTMCR PCT PAYMENT FROM MEDICARE 194 201 SOPTMCD PCT PAYMENT FROM MEDICAID 202 209 SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 210 217 SOPTOTST PCT PAYMENT FROM OTHER STATE 218 225 SOPTWC PCT PAYMENT FROM WORKERS COMP 226 233 SOPTOTHR PCT PAYMENT FROM OTHER 234 241 SOPTFFP PCT PAYMENT FREE FROM PROVIDER 242 242 SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 243 244 IHSFAC J43 FACILITY IS IHS OR TRIBE/ANC 245 256 INCALPER FULL-YEAR WEIGHT 257 259 STRATUMX SAMPLING STRATUM 260 260 SPSU PSEUDO PSU FILE 1 MEDICAL PROVIDER VISIT CODEBOOK General Information THIS CODEBOOK PROVIDES UNWEIGHTED AND WEIGHTED FREQUENCIES FOR THE USE OF MEDICAL PROVIDERS IN AMBULATORY OFFICE SETTINGS FOR CALENDAR YEAR 1987. THE DATA FILE CONTAINS ONE RECORD PER MEDICAL PROVIDER VISIT FOR EACH PERSON IN THE HOUSEHOLD SURVEY WHO REPORTED HAVING SEEN OR TALKED TO A MEDICAL PROVIDER (INCLUDING PHYSICIANS OF ALL SPECIALITIES, MEDICAL PROVIDERS WORKING UNDER THE SUPERVISION OF A PHYSICIAN, AND NONPHYSICIAN PROVIDERS SUCH AS PSYCHOLOGISTS, CHIROPRACTORS, AND PODIATRISTS) DURING THE REFERENCE PERIOD. BASIC DEMOGRAPHIC INFORMATION FOR EACH PATIENT, MAIN REASON FOR THE VISIT AND ADDITIONAL CONDITIONS AS REPORTED IN THE HOUSEHOLD SURVEY, AND ALL PROVIDER EXPENSES ARE INCLUDED ON EACH RECORD. 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 VARIANCE ESTIMATION IS PROVIDED IN THE FILE DOCUMENTATION. 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 3 CODEBOOK IN ALPHABETICAL ORDER OF THE VARIABLE NAME. Variable Position 1-61 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIGINAL DWELLING UNIT OF PID 5.0 NUM 1 5 VALUE 20001-37615 TOTAL PN PERSON NUMBER 3.0 NUM 6 8 VALUE 10-266 TOTAL EN EVENT NUMBER 4.0 NUM 9 12 * VALUE 11-1209 TOTAL RVISN VISIT NUMBER 2.0 NUM 13 14 * VALUE 0-99 TOTAL PIDX PERSON ID (ODUX + PN) 8.0 CHAR 15 22 VALUE VALID PERSON ID TOTAL EVENTIDX EVENT ID (ODUX + PN + EN) 12.0 CHAR 23 34 VALUE VALID EVENT ID TOTAL VISITIDX VISIT ID (ODUX+PN+EN+RVISN) 14.0 CHAR 35 48 * VALUE VALID VISIT ID TOTAL ROUND DATA COLLECTION ROUND 2.0 NUM 49 50 * VALUE -9 NOT ASCERTAI 1 2 3 4 TOTAL LASTAGE ED PID AGE@END OF LAST ELIG RND 3.0 NUM 51 53 * VALUE 0-17 18-44 45-64 65+ TOTAL SMPSEXR PID SEX 1.0 NUM 54 54 VALUE 1 MALE 2 FEMALE TOTAL RACE6 ED PID RACE 1.0 NUM 55 55 * VALUE 1 AMER INDIAN 2 ALASKAN NATIVE 3 ASIAN/PACIFIC 4 BLACK 5 WHITE 6 OTHER TOTAL RACE3 PID RACE/ETHNICITY 1.0 NUM 56 56 * VALUE 1 HISPANIC 2 BLACK NONHISP 3 OTHER TOTAL SREGION PID CENSUS REGION 1.0 NUM 57 57 VALUE 1 NORTHEAST 2 MIDWEST 3 SOUTH 4 WEST TOTAL PREGFLG VISIT RELATED TO PREGNANCY 1.0 NUM 58 58 * VALUE 1 YES 2 NO TOTAL DATEBMM J1 MED PROV VISIT DATE-MONTH 2.0 NUM 59 60 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW 1 JANUARY 2 FEBRUARY 3 MARCH 4 APRIL 5 MAY 6 JUNE 7 JULY 8 AUGUST 9 SEPTEMBER 10 OCTOBER 11 NOVEMBER 12 DECEMBER TOTAL DATEBDD J1 MED PROV VISIT DATE-DAY 2.0 NUM 61 62 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW 1-31 TOTAL Variable Position 63-80 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DATEBYY J1 MED PROV VISIT DATE-YEAR 2.0 NUM 63 64 VALUE 87 TOTAL REFBYHMO J2 PRVDR FROM/REFERD BY PIDS HMO/OTHER 2.0 NUM 65 66 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 HMO PROVIDER 2 HMO REFERRAL 3 NEITHER TOTAL PREFBYMD J3 PID REFERD BY OTHER MD OR MED PRVDR 2.0 NUM 67 68 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL SEETLKPV J4 PERSONAL OR PHONE VISIT 2.0 NUM 69 70 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED 1 SAW PROVIDER 2 PHONE VISIT TOTAL SEETLKPX J4ED PERSONAL OR PHONE VISIT 2.0 NUM 71 72 VALUE -9 NOT ASCERTAIN 1 SAW PROVIDER 2 PHONE VISIT TOTAL WHRSEEMP J5 PLACE OF MED PROV VISIT 2.0 NUM 73 74 * VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 DR OFFICE/GRP 2 DR'S CLINIC 3 NEIGH/FAM CTR 4 SURGICAL CNTR 5 COMPANY CLNIC 6 SCHOOL CLINIC 7 OTHER CLINIC 8 HOME 9 LABORATORY 10 WLK-IN URG CT 11 HOSP CLNIC/ER 12 TELEPHONE 19 DENTAL CLINIC 20 LONG TRM CARE 21 HME HLTH AGCY 22 OPTICAL STORE 23 RADIOLOGY 24 AMBULANCE SEV 91 OTHER TOTAL MVISCLAS PROVIDER TYPE FOR VISIT 1.0 NUM 75 75 * VALUE 1 TELEPHONE 2 PHYSICIAN 3 CHIROPRACTOR 4 PODIATRIST 5 OPTOMETRIST 6 PSYCHOLOGIST 7 OTHS WORK W/DR 8 OTH NOT WRK DR TOTAL VAFACLTY J6 PLACE WAS A FACLTY OF THE VET ADMIN 2.0 NUM 76 77 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL APTWLKIN J7 PID HAD APPNTMNT OR WALKED IN 2.0 NUM 78 79 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 APPOINTMENT 2 WALK IN 91 OTHER TOTAL SETPCALL J8 PID CALLED OR APPT WAS SET BY PRVDR 2.0 NUM 80 81 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 SET BY PROVDR 2 PATIENT CALLD TOTAL Variable Position 82-108 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SEETLKMD J9 PID SAW/TALK TO MED PROV DURING VISIT 2.0 NUM 82 83 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED 1 YES 2 NO TOTAL SEETLKMX J9ED PID SAW/TALK TO MED PROV DURING VIS 2.0 NUM 84 85 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED 1 YES 2 NO TOTAL PROVIDX J10 ID OF PROVIDER 8.0 CHAR 86 93 * VALUE VALID PROVIDR ID TOTAL PROVCOD J10 PROVIDER SPECIALITY 2.0 NUM 94 95 * VALUE -9 NOT ASCERTAIN 1 ALLERGY 2 ANESTHESIOLGY 3 CARDIOLOGY 4 DERMATOLOGY 5 FAMLY PRCTICE 6 GENRL PRCTICE 7 INTERNL MEDCN 8 OB/GYN 9 OPHTHALMOLOGY 10 ORTHOPEDICS 11 OSTEOPATHY 12 OTOLARYNGOLGY 13 PATHOLOGY 14 PEDIATRICS 15 PSYCHIATRY 16 RADIOLOGY 17 SURGERY 18 UROLOGY 19 DENTIST/CLNIC 20 EM ROOM PHYSN 21 NEUROLOGIST 22 ONCOLOGIST 23 ARTHRIT/RHEUM 24 GASTRENTERLGY 25 ENDOCRINOLOGY 26 NEPHROLOGY 27 ER/EY/NSE/THR 28 DIET/NUTRTNST 29 PROCTOLOGY 30 HEMATOLOGY 31 GERIATRICS 32 SPORTS DOCTOR 51 AUDIOLOGIST 52 CHIROPRACTOR 53 HME HLTH AIDE 54 MNTL HLTH CSR 55 NURSE 56 NRSE PRCTITNR 57 TECHNICIAN 58 OCUPTNL THERA 59 OPTOMETRIST 60 PODIATRIST 61 PHYSCIAN ASST 62 PHYSCAL THERA 63 PSYCHOLOGIST 64 RESPIRY THERA 65 SOCIAL WORKER 66 SPCH THERPIST 67 COUNSELOR 68 THERAPIST 69 MIDWIFE 91 OTH DOC SPECL 92 OTH PRVDR TYP TOTAL PRVWKMD J11 PRVDR WORKS FOR A DOCTOR 2.0 NUM 96 97 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL PRVWKMDX J11ED PRVDR WORKS FOR DOCTOR 2.0 NUM 98 99 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL DOCRIDX J12 ID OF DOCTOR 8.0 CHAR 100 107 * VALUE -1 INAPPLICABLE VALID DOCTOR ID TOTAL DRCOD J12 DOCTOR SPECIALTY 2.0 NUM 108 109 * VALUE -9 NOT ASCERTAIN -1 INAPPLICABLE 1 ALLERGY 2 ANESTHESIOLGY 3 CARDIOLOGY 4 DERMATOLOGY 5 FAMLY PRCTICE 6 GENRL PRCTICE 7 INTERNL MEDCN 8 OB/GYN 9 OPHTHALMOLOGY 10 ORTHOPEDICS 11 OSTEOPATHY 12 OTOLARYNGOLGY 13 PATHOLOGY 14 PEDIATRICS 15 PSYCHIATRY 16 RADIOLOGY 17 SURGERY 18 UROLOGY 19 DENTIST/CLNIC 20 EM ROOM PHYSN 21 NEUROLOGIST 22 ONCOLOGIST 23 ARTHRIT/RHEUM 24 GASTRENTERLGY 25 ENDOCRINOLOGY 26 NEPHROLOGY 28 DIET/NUTRTNST 29 PROCTOLOGY 30 HEMATOLOGY 32 SPORTS DOCTOR 51 AUDIOLOGIST 52 CHIROPRACTOR 54 MNTL HLTH CSR 55 NURSE 56 NRSE PRCTITNR 57 TECHNICIAN 58 OCUPTNL THERA 59 OPTOMETRIST 60 PODIATRIST 61 PHYSCIAN ASST 62 PHYSCAL THERA 63 PSYCHOLOGIST 64 RESPIRY THERA 66 SPCH THERPIST 67 COUNSELOR 68 THERAPIST 69 MIDWIFE 91 OTH DOC SPECL 92 OTH PRVDR TYP TOTAL Variable Position 110-136 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- PRSNPROV J13 MAIN REASON FOR MED PRVDR VISIT 2.0 NUM 110 111* VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 DIAG/TREATMNT 2 GEN'L CHK-UP 3 VISION EXAM 4 MATERNTY CARE 5 WELL CHILD EX 6 IMMUNIZATIONS 7 PSYCHOTHERAPY 8 REPRODCTV SER 9 FOOT CARE 10 PHYSCAL THRPY 11 XRAYS 12 CAT/SONO/SCAN 13 TH CULT/BL/UR 14 DIAGNOSTC TST 15 SURGERY/PROCD 16 TESTS,UNSPECF 17 PRE-ADMIS TST 18 HEARING TEST 19 SPEECH THRPY 91 OTHER TOTAL XZATCOND J14 VISIT WAS FOR SPCFC CONDT 2.0 NUM 112 113 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL ICD1 J15/J17 ICD9 CODE-CONDITION1 4.0 CHAR 114 117 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V999 X00X-X999 0001-9999 TOTAL ICD2 J15/J17 ICD9 CODE-CONDITION2 4.0 CHAR 118 121 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V999 X00X-X999 0001-9999 TOTAL ICD3 J15/J17 ICD9 CODE-CONDITION3 4.0 CHAR 122 125 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V999 X00X-X999 0001-9999 TOTAL ICD4 J15/J17 ICD9 CODE-CONDITION4 4.0 CHAR 126 129 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V999 X00X-X999 0001-9999 TOTAL MPDISCVR J16 PRVDR DISCOVERED OTHR CONDITION 2.0 NUM 130 131 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL XRAY J18A PID HAD X-RAY 2.0 NUM 132 133 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL XRAYX J18A ED PID HAD X-RAY 2.0 NUM 134 135 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL SCAN J18B PID HAD CT, SONO, OTHER SCAN 2.0 NUM 136 137 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL Variable Position 138-170 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SCANX J18B ED PID HAD CT, SONO, OTHER SCAN 2.0 NUM 138 139 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL CULTURE J18C PID HAD CULTURE, OTHER LAB TEST 2.0 NUM 140 141 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL CULTUREX J18C ED PID HAD CULTURE OTHR LAB TEST 2.0 NUM 142 143 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL DIAGTEST J18D PID HAD EKG, EEG, OTHER DX TEST 2.0 NUM 144 145 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL DIAGTESX J18D ED PID HAD EKG, EEG, OTHR DX TEST 2.0 NUM 146 147 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL SURGERY J18E PID HAD SURGICAL PROCEDURE 2.0 NUM 148 149 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL SURGERYX J18E ED PID HAD SURGICAL PROCEDURE 2.0 NUM 150 151 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -1 INAPPLICABLE 1 YES 2 NO TOTAL PROCCODE J19 PROCEDURE CODE 2.0 CHAR 152 153 VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN 00-99 TOTAL EXPTOT J23 ORIGINAL TOTAL MED PROV CHARGE/VISIT 8.2 NUM 154 161* VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW -1 INAPPLICABLE .01- 24.99 25.00- 49.99 50.00- 99.99 100.00-499.99 500.00-999.99 1000.00+ TOTAL EXPTOTX EDITED TOTAL MED PROV EXPENSE/VISIT 7.2 NUM 162 168* VALUE 0 .01- 24.99 25.00- 49.99 50.00- 99.99 100.00-499.99 500.00-999.99 1000.00+ TOTAL EXPTFLG IMPUTATION FLG FOR ED TOT MED PROV EXPEN 1.0 NUM 169 169* VALUE 1 EXP FROM HS 2 EXP FROM MPS 3 EXP IMPUTED TOTAL SOPTSELF PCT PAYMENT FROM SELF OR FAMILY 8.4 NUM 170 177 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL Variable Position 178-260 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPTPRVT PCT PAYMENT FROM PRIVATE INSUR 8.4 NUM 178 185 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTMCR PCT PAYMENT FROM MEDICARE 8.4 NUM 186 193 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTMCD PCT PAYMENT FROM MEDICAID 8.4 NUM 194 201 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTOTFD PCT PAYMENT FROM OTHER FEDERAL 8.4 NUM 202 209 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTOTST PCT PAYMENT FROM OTHER STATE 8.4 NUM 210 217 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTWC PCT PAYMENT FROM WORKERS COMP 8.4 NUM 218 225 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTOTHR PCT PAYMENT FROM OTHER 8.4 NUM 226 233 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTFFP PCT PAYMENT FREE FROM PROVIDER 8.4 NUM 234 241 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPTFLG IMPUTATION FLG FOR SOURCE OF PAYMENT 1.0 NUM 242 242* VALUE 0 NO EXPENSES 1 ALL SOP FRM HS 2 ALL SOP IMPUTD TOTAL IHSFAC J43 FACILITY IS IHS OR TRIBE/ANC 2.0 NUM 243 244 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 IHS 2 TRIBE/ANC 3 NOT IHS/TRIBE TOTAL INCALPER FULL-YEAR WEIGHT 12.6 NUM 245 256 * VALUE 780.924-27174.39 TOTAL STRATUMX SAMPLING STRATUM 3.0 NUM 257 259 * VALUE 301-401 TOTAL SPSU PSEUDO PSU 1.0 NUM 260 260 * VALUE 1 2 TOTAL Alphabetical Listing of Variables NMES AMBULATORY MEDICAL VISIT DATA FILE 2: HOSPITAL OUTPATIENT VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 18, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- Variables A-SEE START END NAME DESCRIPTION ----- --- ---- ----------- 332 333 APTWLK F52 APPOINTMENT OR WALK-IN/VISIT 334 335 COMEBACK F53 RETURN APPOINTMENT 147 148 CULTURE F12C PID HAD CULTURE, OTHER LAB TEST 61 62 DATEBDD F1 DATE OF OP VISIT-DAY 59 60 DATEBMM F1 DATE OF OP VISIT-MONTH 63 64 DATEBYY F1 DATE OF OP VISIT-YEAR 149 150 DIAGTEST F12D PID HAD EKG, EEG, OTHER DX TEST 141 142 DISCOND F10 PROVIDER DISCOVERED OTHER CONDITIONS 9 12 EN EVENT NUMBER 23 34 EVENTIDX EVENT ID (ODUX+PN+EN) 251 251 EXPDRFLG IMPUTATION FLAG FOR OP DOC EXPENSE/VISIT 244 250 EXPDRX EDITED OP DOCTOR EXPENSE/VISIT 155 162 EXPFAC F17/F29 ORIG OP FACILITY CHARGE/VISIT 163 169 EXPFACX EDITED OP FACILITY EXPENSE/VISIT 170 170 EXPFCFLG IMPUTATION FLAG FOR OP FAC EXPENSE/VISIT 325 331 EXPTOTX EDITED TOTAL OP EXPENSE 125 128 ICD1 F9/F11 ICD9 CODE - CONDITION 1 129 132 ICD2 F9/F11 ICD9 CODE - CONDITION 2 133 136 ICD3 F9/F11 ICD9 CODE - CONDITION 3 137 140 ICD4 F9/F11 ICD9 CODE - CONDITION 4 344 345 IHSFAC F60 FACILITY IS IHS OR TRIBE/ANC 346 357 INCALPER FULL-YEAR WEIGHT 50 52 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 338 340 ONSPROVD F55 # OTHER VISITS TO SAME PROVIDER 341 343 ONSSERV F56 # OTH VIS TO SAME PROV FOR SAME COND 67 68 OPATVA F3 HOSP OUTPATIENT DEPT IS A VA FACILTY 15 22 PIDX PERSON ID (ODUX+PN) 69 76 PLACEIDX F4 ID OF FACILITY 6 8 PN PERSON NUMBER 57 57 PREGFLG VISIT RELATED TO PREGNANCY 153 154 PROCCODE F13 PROCEDURE CODE 55 55 RACE3 PID RACE/ETHNICITY 54 54 RACE6 ED PID RACE 336 337 REFERDBY F54 PID WAS REFERRED BY OTHER PROVIDER 48 49 ROUND DATA COLLECTION ROUND 13 14 RVISN VISIT NUMBER 145 146 SCAN F12B PID HAD CT, SONO, OTHER SCAN 81 82 SEECHIRO F6 PID SAW A CHIROPRACTOR 83 84 SEECHIRX F6 ED PID SAW A CHIROPRACTOR 77 78 SEEDOC F5 PID SAW A MEDICAL DOCTOR 79 80 SEEDOCX F5 ED PID SAW A MEDICAL DOCTOR 85 86 SEENURSE F6 PID SAW A NURSE 87 88 SEENURSX F6 ED PID SAW A NURSE 95 96 SEEOPTMX F6 ED PID SAW AN OPTOMETRIST 93 94 SEEOPTOM F6 PID SAW AN OPTOMETRIST 119 120 SEEOTDCX F6 ED PID SAW OTHER MED PERS 117 118 SEEOTDOC F6 PID SAW OTHER MED PERS Variables SEE-ZEE START END NAME DESCRIPTION ----- --- ---- ----------- 97 98 SEEPODI F6 PID SAW A PODIATRIST 99 100 SEEPODIX F6 ED PID SAW A PODIATRIST 89 90 SEETECHN F6 PID SAW A TECHNICIAN 91 92 SEETECHX F6 ED PID SAW A TECHNICIAN 101 102 SEPHYAST F6 PID SAW A PHYSICIANS' ASSISTANT 103 104 SEPHYASX F6 ED PID SAW A PHYSICIANS' ASSISTANT 109 110 SEPSYCHO F6 PID SAW A PSYCHOLOGIST 111 112 SEPSYCHX F6 ED PID SAW A PSYCHOLOGIST 113 114 SESOCWRK F6 PID SAW A SOCIAL WORKER 115 116 SESOCWRX F6 ED PID SAW A SOCIAL WORKER 105 106 SETHERAP F6 PID SAW A PHYSICAL THERAPIST 107 108 SETHERAX F6 ED PID SAW A PHYSICAL THERAPIST 53 53 SMPSEXR PID SEX 316 323 SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 324 324 SOPDFLG IMPUTATN FLG FOR SOURCE OF PAYM-DOC EXP 276 283 SOPDMCD PCT PAYMENT FROM MEDICAID-DR EXP 268 275 SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 284 291 SOPDOTFD PCT PAYMENT FROM OTHER FEDERAL-DR EXP 308 315 SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 292 299 SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 260 267 SOPDPRVT PCT PAYMENT PRIVATE INSURANCE-DR EXP 252 259 SOPDSELF PCT PAYMENT FROM SELF OR FAMILY-DR EXP 300 307 SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 235 242 SOPFFFP PCT PAYMENT FREE FROM PROVIDER-FAC EXP 243 243 SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 195 202 SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 187 194 SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP 203 210 SOPFOTFD PCT PAYMENT FROM OTHER FEDERAL-FAC EXP 227 234 SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 211 218 SOPFOTST PCT PAYMENT FROM OTHER STATE-FAC EXP 179 186 SOPFPRVT PCT PAYMENT PRIVATE INSURANCE-FAC EXP 171 178 SOPFSELF PCT PAYMENT FROM SELF OR FAMILY-FAC EXP 219 226 SOPFWC PCT PAYMENT FROM WORKERS COMP-FAC EXP 123 124 SPECCOND F8 VISIT WAS FOR SPECIFIC CONDITION 361 361 SPSU PSEUDO PSU 56 56 SREGION PID CENSUS REGION 358 360 STRATUMX SAMPLING STRATUM 151 152 SURGERY F12E PID HAD SURGICAL PROCEDURE 35 47 VISITIDX VISIT ID (ODUX+PN+EN+RVISN) 65 66 WHOREFER F2 VISIT REFERRAL BY AN HMO 121 122 WHYVISIT F7 MAIN REASON FOR OP VISIT 143 144 XRAY F12A PID HAD X-RAY 58 58 ZERONITE PERSON-LEVEL CNT OF # 0-NGHT HOSP STAYS Positional Listing of Variables NMES AMBULATORY MEDICAL VISIT DATA FILE 2: HOSPITAL OUTPATIENT VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 18, 1992 -----POSITIONAL LISTING OF VARIABLES----- Variables 1-133 START END NAME DESCRIPTION ----- --- ---- ----------- 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 6 8 PN PERSON NUMBER 9 12 EN EVENT NUMBER 13 14 RVISN VISIT NUMBER 15 22 PIDX PERSON ID (ODUX+PN) 23 34 EVENTIDX EVENT ID (ODUX+PN+EN) 35 47 VISITIDX VISIT ID (ODUX+PN+EN+RVISN) 48 49 ROUND DATA COLLECTION ROUND 50 52 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 53 53 SMPSEXR PID SEX 54 54 RACE6 ED PID RACE 55 55 RACE3 PID RACE/ETHNICITY 56 56 SREGION PID CENSUS REGION 57 57 PREGFLG VISIT RELATED TO PREGNANCY 58 58 ZERONITE PERSON-LEVEL CNT OF # 0-NGHT HOSP STAYS 59 60 DATEBMM F1 DATE OF OP VISIT-MONTH 61 62 DATEBDD F1 DATE OF OP VISIT-DAY 63 64 DATEBYY F1 DATE OF OP VISIT-YEAR 65 66 WHOREFER F2 VISIT REFERRAL BY AN HMO 67 68 OPATVA F3 HOSP OUTPATIENT DEPT IS A VA FACILTY 69 76 PLACEIDX F4 ID OF FACILITY 77 78 SEEDOC F5 PID SAW A MEDICAL DOCTOR 79 80 SEEDOCX F5 ED PID SAW A MEDICAL DOCTOR 81 82 SEECHIRO F6 PID SAW A CHIROPRACTOR 83 84 SEECHIRX F6 ED PID SAW A CHIROPRACTOR 85 86 SEENURSE F6 PID SAW A NURSE 87 88 SEENURSX F6 ED PID SAW A NURSE 89 90 SEETECHN F6 PID SAW A TECHNICIAN 91 92 SEETECHX F6 ED PID SAW A TECHNICIAN 93 94 SEEOPTOM F6 PID SAW AN OPTOMETRIST 95 96 SEEOPTMX F6 ED PID SAW AN OPTOMETRIST 97 98 SEEPODI F6 PID SAW A PODIATRIST 99 100 SEEPODIX F6 ED PID SAW A PODIATRIST 101 102 SEPHYAST F6 PID SAW A PHYSICIANS' ASSISTANT 103 104 SEPHYASX F6 ED PID SAW A PHYSICIANS' ASSISTANT 105 106 SETHERAP F6 PID SAW A PHYSICAL THERAPIST 107 108 SETHERAX F6 ED PID SAW A PHYSICAL THERAPIST 109 110 SEPSYCHO F6 PID SAW A PSYCHOLOGIST 111 112 SEPSYCHX F6 ED PID SAW A PSYCHOLOGIST 113 114 SESOCWRK F6 PID SAW A SOCIAL WORKER 115 116 SESOCWRX F6 ED PID SAW A SOCIAL WORKER 117 118 SEEOTDOC F6 PID SAW OTHER MED PERS 119 120 SEEOTDCX F6 ED PID SAW OTHER MED PERS 121 122 WHYVISIT F7 MAIN REASON FOR OP VISIT 123 124 SPECCOND F8 VISIT WAS FOR SPECIFIC CONDITION 125 128 ICD1 F9/F11 ICD9 CODE - CONDITION 1 129 132 ICD2 F9/F11 ICD9 CODE - CONDITION 2 133 136 ICD3 F9/F11 ICD9 CODE - CONDITION 3 Variables 137-361 START END NAME DESCRIPTION ----- --- ---- ----------- 137 140 ICD4 F9/F11 ICD9 CODE - CONDITION 4 141 142 DISCOND F10 PROVIDER DISCOVERED OTHER CONDITIONS 143 144 XRAY F12A PID HAD X-RAY 145 146 SCAN F12B PID HAD CT, SONO, OTHER SCAN 147 148 CULTURE F12C PID HAD CULTURE, OTHER LAB TEST 149 150 DIAGTEST F12D PID HAD EKG, EEG, OTHER DX TEST 151 152 SURGERY F12E PID HAD SURGICAL PROCEDURE 153 154 PROCCODE F13 PROCEDURE CODE 155 162 EXPFAC F17/F29 ORIG OP FACILITY CHARGE/VISIT 163 169 EXPFACX EDITED OP FACILITY EXPENSE/VISIT 170 170 EXPFCFLG IMPUTATION FLAG FOR OP FAC EXPENSE/VISIT 171 178 SOPFSELF PCT PAYMENT FROM SELF OR FAMILY-FAC EXP 179 186 SOPFPRVT PCT PAYMENT PRIVATE INSURANCE-FAC EXP 187 194 SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP 195 202 SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 203 210 SOPFOTFD PCT PAYMENT FROM OTHER FEDERAL-FAC EXP 211 218 SOPFOTST PCT PAYMENT FROM OTHER STATE-FAC EXP 219 226 SOPFWC PCT PAYMENT FROM WORKERS COMP-FAC EXP 227 234 SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 235 242 SOPFFFP PCT PAYMENT FREE FROM PROVIDER-FAC EXP 243 243 SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 244 250 EXPDRX EDITED OP DOCTOR EXPENSE/VISIT 251 251 EXPDRFLG IMPUTATION FLAG FOR OP DOC EXPENSE/VISIT 252 259 SOPDSELF PCT PAYMENT FROM SELF OR FAMILY-DR EXP 260 267 SOPDPRVT PCT PAYMENT PRIVATE INSURANCE-DR EXP 268 275 SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 276 283 SOPDMCD PCT PAYMENT FROM MEDICAID-DR EXP 284 291 SOPDOTFD PCT PAYMENT FROM OTHER FEDERAL-DR EXP 292 299 SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 300 307 SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 308 315 SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 316 323 SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 324 324 SOPDFLG IMPUTATN FLG FOR SOURCE OF PAYM-DOC EXP 325 331 EXPTOTX EDITED TOTAL OP EXPENSE 332 333 APTWLK F52 APPOINTMENT OR WALK-IN/VISIT 334 335 COMEBACK F53 RETURN APPOINTMENT 336 337 REFERDBY F54 PID WAS REFERRED BY OTHER PROVIDER 338 340 ONSPROVD F55 # OTHER VISITS TO SAME PROVIDER 341 343 ONSSERV F56 # OTH VIS TO SAME PROV FOR SAME COND 344 345 IHSFAC F60 FACILITY IS IHS OR TRIBE/ANC 346 357 INCALPER FULL-YEAR WEIGHT 358 360 STRATUMX SAMPLING STRATUM 361 361 SPSU PSEUDO PSU FILE 2: HOSPITAL OUTPATIENT VISIT CODEBOOK General Information DATE: AUGUST 18, 1992 THIS CODEBOOK PROVIDES UNWEIGHTED AND WEIGHTED FREQUENCIES FOR VISITS TO MEDICAL PROVIDERS SEEN IN HOSPITAL OUTPATIENT DEPARTMENTS DURING CALENDAR YEAR 1987. THE DATA FILE CONTAINS ONE RECORD PER VISIT FOR EACH PERSON IN THE HOUSEHOLD SURVEY WHO REPORTED HAVING RECEIVED CARE AT A HOSPITAL OUTPATIENT DEPARTMENT DURING THE REFERENCE PERIOD. BASIC DEMOGRAPHIC INFORMATION FOR EACH PATIENT, MAIN REASON FOR THE VISIT AND ADDITIONAL CONDITIONS AS REPORTED IN THE HOUSEHOLD SURVEY, AND ALL FACILITY AND PHYSICIAN EXPENSES ARE INCLUDED ON EACH RECORD. 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 VARIANCE ESTIMATION IS PROVIDED IN THE FILE DOCUMENTATION. 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 3 CODEBOOK IN ALPHABETICAL ORDER OF THE VARIABLE NAME. Variable Positions 1-59 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIGINAL DWELLING UNIT OF PERSON 5.0 NUM 1 5 VALUE 20001-37615 TOTAL PN PERSON NUMBER 3.0 NUM 6 8 VALUE 10-266 TOTAL EN EVENT NUMBER 4.0 NUM 9 12 * VALUE 11-1209 TOTAL RVISN VISIT NUMBER 2.0 NUM 13 14 * VALUE 0-99 TOTAL PIDX PERSON ID (ODUX+PN) 8.0 CHAR 15 22 VALUE VALID PERSON ID TOTAL EVENTIDX EVENT ID (ODUX+PN+EN) 12.0 CHAR 23 34 VALUE VALID EVENT ID TOTAL VISITIDX VISIT ID (ODUX+PN+EN+RVISN) 13.0 CHAR 35 47 * VALUE VALID VISIT ID TOTAL ROUND DATA COLLECTION ROUND 2.0 NUM 48 49 * VALUE -9 NOT ASCERTAIN 1 2 3 4 TOTAL LASTAGE ED PID AGE AT END OF LAST ELGBL RND 3.0 NUM 50 52* VALUE 0-17 18-44 45-64 65+ TOTAL SMPSEXR PID SEX 1.0 NUM 53 53 VALUE 1 MALE 2 FEMALE TOTAL RACE6 ED PID RACE 1.0 NUM 54 54 * VALUE 1 AMER INDIAN 2 ALASKAN NATIVE 3 ASIAN/PACIFIC 4 BLACK 5 WHITE 6 OTHER TOTAL RACE3 PID RACE/ETHNICITY 1.0 NUM 55 55 * VALUE 1 HISPANIC 2 BLACK NONHISP 3 OTHER TOTAL SREGION PID CENSUS REGION 1.0 NUM 56 56 VALUE 1 NORTHEAST 2 MIDWEST 3 SOUTH 4 WEST TOTAL PREGFLG VISIT RELATED TO PREGNANCY 1.0 NUM 57 57 * VALUE 1 YES 2 NO TOTAL ZERONITE PERSON-LEVEL CNT OF # 0-NGHT HOSP STAYS 1.0 NUM 58 58* VALUE 0 1 2 3 4 5 6 TOTAL DATEBMM F1 DATE OF OP VISIT-MONTH 2.0 NUM 59 60 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW 1 JANUARY 2 FEBRUARY 3 MARCH 4 APRIL 5 MAY 6 JUNE 7 JULY 8 AUGUST 9 SEPTEMBER 10 OCTOBER 11 NOVEMBER 12 DECEMBER TOTAL Variable Positions 61-91 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DATEBDD F1 DATE OF OP VISIT-DAY 2.0 NUM 61 62 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW 1-31 TOTAL DATEBYY F1 DATE OF OP VISIT-YEAR 2.0 NUM 63 64 VALUE 87 TOTAL WHOREFER F2 VISIT REFERRAL BY AN HMO 2.0 NUM 65 66 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL OPATVA F3 HOSP OUTPTNT DEPT IS A VA FAC 2.0 NUM 67 68 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL PLACEIDX F4 ID OF FACILITY 8.0 CHAR 69 76 * VALUE VALID FACILTY ID TOTAL SEEDOC F5 PID SAW A MEDICAL DOCTOR 2.0 NUM 77 78 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL SEEDOCX F5 ED PID SAW A MEDICAL DOCTOR2.0 NUM 79 80 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL SEECHIRO F6 PID SAW A CHIROPRACTOR 2.0 NUM 81 82 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEECHIRX F6 ED PID SAW A CHIROPRACTOR 2.0 NUM 83 84 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEENURSE F6 PID SAW A NURSE 2.0 NUM 85 86 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEENURSX F6 ED PID SAW A NURSE 2.0 NUM 87 88 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEETECHN F6 PID SAW A TECHNICIAN 2.0 NUM 89 90 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEETECHX F6 ED PID SAW A TECHNICIAN 2.0 NUM 91 92 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL Variable Positions 93-117 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SEEOPTOM F6 PID SAW AN OPTOMETRIST 2.0 NUM 93 94 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEEOPTMX F6 ED PID SAW AN OPTOMETRIST 2.0 NUM 95 96 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEEPODI F6 PID SAW A PODIATRIST 2.0 NUM 97 98 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEEPODIX F6 ED PID SAW A PODIATRIST 2.0 NUM 99 100 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEPHYAST F6 PID SAW A PHYSICIANS' ASSIS 2.0 NUM 101 102 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEPHYASX F6 ED PID SAW A PHYSICIANS' ASSIS 2.0 NUM 103 104 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SETHERAP F6 PID SAW A PHYSICAL THERAPIST 2.0 NUM 105 106 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SETHERAX F6 ED PID SAW A PHYSICAL THERAPIST 2.0 NUM 107 108 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEPSYCHO F6 PID SAW A PSYCHOLOGIST 2.0 NUM 109 110 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEPSYCHX F6 ED PID SAW A PSYCHOLOGIST 2.0 NUM 111 112 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SESOCWRK F6 PID SAW A SOCIAL WORKER 2.0 NUM 113 114 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SESOCWRX F6 ED PID SAW A SOCIAL WORKER 2.0 NUM 115 116 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SEEOTDOC F6 PID SAW OTHER MED PERS 2.0 NUM 117 118 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 2 NO 91 OTHER TOTAL Variable Positions 119-147 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SEEOTDCX F6 ED PID SAW OTHER MED PERS 2.0 NUM 119 120 * VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 10 RADIOLGST 11 CONSLR/THRPST 12 OCC THRPST 91 OTHER TOTAL WHYVISIT F7 MAIN REASON FOR OP VISIT 2.0 NUM 121 122 * VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 DIAG/TREATMNT 2 GEN'L CHK-UP 3 VISION EXAM 4 MATERNTY CARE 5 WELL CHILD EX 6 IMMUNIZATIONS 7 PSYCHOTHERAPY 8 REPRODCTV SER 9 FOOT CARE 10 PHYSCAL THRPY 11 XRAYS 12 CAT/SONO/SCAN 13 TH CULT/BL/UR 14 DIAGNOSTC TST 15 SURGERY/PROCD 16 TESTS,UNSPECF 17 PRE-ADMIS TST 18 HEARING TEST 19 SPEECH THRPY 91 OTHER TOTAL SPECCOND F8 VISIT WAS FOR SPECIFIC CONDITION 2.0 NUM 123 12 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL ICD1 F9/F11 ICD9 CODE-CONDITION 1 4.0 CHAR 125 128 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V009 X00X-X009 0001-9999 TOTAL ICD2 F9/F11 ICD9 CODE-CONDITION 2 4.0 CHAR 129 132 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V009 X00X-X009 0001-9999 TOTAL ICD3 F9/F11 ICD9 CODE-CONDITION 3 4.0 CHAR 133 136 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V009 X00X-X009 0001-9999 TOTAL ICD4 F9/F11 ICD9 CODE-CONDITION 4 4.0 CHAR 137 140 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN 0001-9999 TOTAL DISCOND F10 PROVIDER DISCED OTHR COND 2.0 NUM 141 142 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL XRAY F12A PID HAD X-RAY 2.0 NUM 143 144 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SCAN F12B PID HAD CT,SONO,OTHER SCAN 2.0 NUM 145 146 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL CULTURE F12C PID HAD CULTURE,OTHR LAB TEST 2.0 NUM 147 148 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL Variable Positions 149-195 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- DIAGTEST F12D PID HAD EKG,EEG,OTHR DX TEST 2.0 NUM 149 150 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL SURGERY F12E PID HAD SURG PROCEDURE 2.0 NUM 151 152 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 YES 2 NO TOTAL PROCCODE F13 PROCEDURE CODE 2.0 CHAR 153 154 VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN 0-99 TOTAL EXPFAC F17/F29 ORIG OP FAC CHARGE/VISIT 8.2 NUM 155 162* VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -5 NEVER KNOW -1 INAPPLICABLE 1.00-5.00 5.01-10.00 10.01-25.00 25.01-50.00 50.01-75.00 75.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01-1000 1000.01-2000 2000.01-4000 4000.01-6000 6000.01-8500 8500.01-23000 TOTAL EXPFACX EDITED OP FACILITY EXP/VISIT 7.2 NUM 163 169 * VALUE 0 1.00-5.00 5.01-10.00 10.01-25.00 25.01-50.00 50.01-75.00 75.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01-1000 1000.01-2000 2000.01-4000 4000.01-6000 TOTAL EXPFCFLG IMPUTATION FLAG FOR OP FAC EXP/VISIT 1.0 NUM 170 170* VALUE 1 EXP FROM HS 2 EXP FROM MPS 3 EXP IMPUTED TOTAL SOPFSELF PCT PAYMENT FROM SELF OR FAMILY-FAC EXP 8.4 NUM 171 178 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFPRVT PCT PAYMENT PRIVATE INSURANCE-FAC VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 8.4 NUM 195 202 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL Variable Positions 203-268 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPFOTFD PCT PAYMENT FROM OTHER FED-FAC EXP 8.4 NUM 203 210 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFOTST PCT PAYM FROM OTHER STATE-FAC EXP 8.4 NUM 211 218 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFWC PCT PAYM FROM WORKERS COMP-FAC EXP 8.4 NUM 219 226 VALUE 0 GT 80 TO LT 100 100 TOTAL SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 8.4 NUM 227 234 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFFFP PCT PAYM FREE FROM PROVIDER-FAC EXP 8.4 NUM 235 242 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 1.0 NUM 243 243* VALUE 0 NO EXPENSES 1 ALL SOP FROM H 2 ALL SOP IMPUTE TOTAL EXPDRX EDITED OP DOCTOR EXPENSE/VISIT 7.2 NUM 244 250 * VALUE 0 1.00-5.00 5.01-10.00 10.01-25.00 25.01-50.00 50.01-75.00 75.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01-1000 1000.01-2000 2000.01-4000 4000.01-6000 TOTAL EXPDRFLG IMPUTATION FLAG FOR OP DOC EXP/VISIT 1.0 NUM 251 251* VALUE 2 EXP FROM MPS 3 EXP IMPUTED TOTAL SOPDSELF PCT PAYM FROM SELF OR FAMILY-DR EXP 8.4 NUM 252 259 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDPRVT PCT PAYMENT PRIVATE INSURANCE-DR EXP 8.4 NUM 260 267 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 8.4 NUM 268 275 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL Variable Positions 276-336 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- SOPDMCD PCT PAYMENT FROM MEDICAID-DR EXP 8.4 NUM 276 283 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDOTFD PCT PAYMENT FROM OTHER FEDERAL-DR EXP 8.4 NUM 284 291 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 8.4 NUM 292 299 VALUE 0 GT 0 TO 20 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 8.4 NUM 300 307 VALUE 0 GT 60 TO 80 100 TOTAL SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 8.4 NUM 308 315 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 8.4 NUM 316 323 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDFLG IMPUTATN FLG FOR SOURCE OF PAYM-DOC EXP 1.0 NUM 324 324 VALUE 0 NO EXPENSES 1 ALL SOP FROM H 2 ALL SOP IMPUTE TOTAL EXPTOTX EDITED TOTAL OP EXPENSE 7.2 NUM 325 331 * VALUE 0 1.00-5.00 5.01-10.00 10.01-25.00 25.01-50.00 50.01-75.00 75.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01-1000 1000.01-2000 2000.01-4000 4000.01-6000 6000.01-8500 8500.01-17500 TOTAL APTWLK F52 APPOINTMENT OR WALK-IN/VISIT 2.0 NUM 332 333 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 APPOINTMENT 2 WALK IN 91 OTHER TOTAL COMEBACK F53 RETURN APPOINTMENT 2.0 NUM 334 335 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 1 SET BY PROVDR 2 PATIENT CALLD TOTAL REFERDBY F54 PID WAS REFERRED BY OTHR PRVDR 2.0 NUM 336 337 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL Variable Positions 338-361 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ONSPROVD F55 # OTHER VISITS TO SAME PROVIDER 3.0 NUM 338 340 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -1 INAPPLICABLE 0-200 TOTAL ONSSERV F56 # OTH VIS TO SAME PROV FOR SAME COND 3.0 NUM 341 343 VALUE -9 NOT ASCERTAIN -1 INAPPLICABLE 0-200 TOTAL IHSFAC F60 FACILITY IS IHS OR TRIBE/ANC 2.0 NUM 344 345 VALUE -9 NOT ASCERTAIN -1 INAPPLICABLE 1 IHS 2 TRIBE/ANC 3 NOT IHS/TRIBE TOTAL INCALPER FULL-YEAR WEIGHT 12.6 NUM 346 357 * VALUE 780.924-27174.39 TOTAL STRATUMX SAMPLING STRATUM 3.0 NUM 358 360 * VALUE 301-401 TOTAL SPSU PSEUDO PSU 1.0 NUM 361 361 * VALUE 1 2 TOTAL Alphabetical Listing of Variables NMES AMBULATORY MEDICAL VISIT DATA FILE 3: HOSPITAL EMERGENCY ROOM VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 17, 1992 -----ALPHABETICAL LISTING OF VARIABLES----- START END NAME DESCRIPTION ----- --- ---- ----------- 290 291 ADMTHOSP E52 PID ADMITTED TO HOSP AFTER ER VISIT 292 292 ADMTHOSX E52ED PID ADMITTED HOSP AFTER ER VISIT 103 104 CULTURE E12C PID HAD CULTURE, OTHER LAB TEST 45 46 DATEBDD E1 DATE ER VISIT-DAY 43 44 DATEBMM E1 DATE ER VISIT-MONTH 47 48 DATEBYY E1 DATE ER VISIT-YEAR 105 106 DIAGTEST E12D PID HAD EKG, EEG, OTHER DX TEST 71 78 DOCRIDX E8 ID OF E6 MED PROVIDER 79 80 DRCOD E8 SPECIALTY OF E6 MED PROVIDER 9 12 EN EVENT NUMBER 51 52 ERHOUR E3 TIME OF DAY OF ER VISIT 53 54 ERMINS E3 TIME OF DAY OF ER VISIT-MIN 81 82 EROFFOUT E9 E6-PROVIDER OFFICE OUTSIDE HOSPITAL 55 56 ERTIME E3 TIME OF DAY OF ER VISIT-HOUR 21 32 EVENTIDX EVENT ID (ODUX + PN + EN) 208 208 EXPDRFLG IMPUTATION FLAG FOR EDITED DOC EXPENSE 201 207 EXPDRX EDITED ER DOCTOR EXPENSE 111 118 EXPFAC E17/E29 ORIGINAL ER FAC CHARGE/VISIT 119 126 EXPFACX EDITED ER FACILITY EXPENSE/VISIT 127 127 EXPFCFLG IMPUTATION FLAG FOR EDITED ER FAC EXP 282 289 EXPTOTX EDITED TOTAL ER EXPENSE 83 86 ICD1 E11 ICD9 CODE - CONDITION 1 87 90 ICD2 E11 ICD9 CODE - CONDITION 2 91 94 ICD3 E11 ICD9 CODE - CONDITION 3 95 98 ICD4 E11 ICD9 CODE - CONDITION 4 302 303 IHSFAC E56 FACILITY IS IHS OR TRIBE/ANC 304 315 INCALPER FULL-YEAR WEIGHT 35 37 LASTAGE ED PID AGE AT END OF LAST ELIGIBLE ROUND 69 70 MDMEETP E7 MED PROVIDER MET PID IN ER 67 68 MDTELLGO E6 ER VISIT SUGGESTED BY MED PROV 1 5 ODUX ORIGINAL DWELLING UNIT OF PERSON 13 20 PIDX PERSON ID (ODUX + PN) 59 66 PLACEIDX E5 ID OF FACILITY 6 8 PN PERSON NUMBER 42 42 PREGFLG VISIT RELATED TO PREGNANCY 109 110 PROCCODE E13 PROCEDURE CODE 40 40 RACE3 PID RACE/ETHNICITY 39 39 RACE6 ED PID RACE 33 34 ROUND DATA COLLECTION ROUND 101 102 SCAN E12B PID HAD CT, SONO, OTHER SCAN 38 38 SMPSEXR PID SEX 273 280 SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 281 281 SOPDFLG IMPUTATN FLG FOR SOURC PAYM INFO-DOC CHG 233 240 SOPDMCD PCT PAYMENT FROM MEDICAID-DR EXP 225 232 SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 241 248 SOPDOTFD PCT PAYMENT FROM OTHER FEDERAL-DR EXP 265 272 SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 249 256 SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 217 224 SOPDPRVT PCT PAYMENT FROM PRIVATE INSUR-DR EXP 209 216 SOPDSELF PCT PAYMENT FROM SELF OR FAMILY-DR EXP 257 264 SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 192 199 SOPFFFP PCT PAYMENT FREE FROM PROVIDER-FAC EXP 200 200 SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 152 159 SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 144 151 SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP 160 167 SOPFOTFD PCT PAYMENT FROM OTHER FEDERAL-FAC EXP 184 191 SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 168 175 SOPFOTST PCT PAYMENT FROM OTHER STATE-FAC EXP 136 143 SOPFPRVT PCT PAYMENT FROM PRIVATE INSUR-FAC EXP 128 135 SOPFSELF PCT PAYMENT FROM SELF OR FAMILY-FAC EXP 176 183 SOPFWC PCT PAYMENT FROM WORKERS COMP-FAC EXP 319 319 SPSU PSEUDO PSU 41 41 SREGION PID CENSUS REGION 316 318 STRATUMX SAMPLING STRATUM 107 108 SURGERY E12E PID HAD SURGICAL PROCEDURE 300 301 TRANSP E55 HOW PID TRAVELLED TO ER 297 299 TRAVMINS E54 TIME PID TRAVELLED TO ER-MINS 57 58 TYPEEFAC E4 EMERGENCY ROOM WAS FACIL OF VET ADMIN 293 294 VLENGHRS E53 LENGTH OF ER VISIT-HOUR 295 296 VLENGMIN E53 LENGTH OF ER VISIT-MINUTES 49 50 WEEKDAY E2 DAY OF WEEK OF ER VISIT 99 100 XRAY E12A PID HAD X-RAY Positional Listing of Variables FILE 3: HOSPITAL EMERGENCY ROOM VISIT CODEBOOK ALPHABETICAL AND POSITIONAL LISTING OF VARIABLES DATE: AUGUST 17, 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 42 PREGFLG VISIT RELATED TO PREGNANCY 43 44 DATEBMM E1 DATE ER VISIT-MONTH 45 46 DATEBDD E1 DATE ER VISIT-DAY 47 48 DATEBYY E1 DATE ER VISIT-YEAR 49 50 WEEKDAY E2 DAY OF WEEK OF ER VISIT 51 52 ERHOUR E3 TIME OF DAY OF ER VISIT 53 54 ERMINS E3 TIME OF DAY OF ER VISIT-MIN 55 56 ERTIME E3 TIME OF DAY OF ER VISIT-HOUR 57 58 TYPEEFAC E4 EMERGENCY ROOM WAS FACIL OF VET ADMIN 59 66 PLACEIDX E5 ID OF FACILITY 67 68 MDTELLGO E6 ER VISIT SUGGESTED BY MED PROV 69 70 MDMEETP E7 MED PROVIDER MET PID IN ER 71 78 DOCRIDX E8 ID OF E6 MED PROVIDER 79 80 DRCOD E8 SPECIALTY OF E6 MED PROVIDER 81 82 EROFFOUT E9 E6-PROVIDER OFFICE OUTSIDE HOSPITAL 83 86 ICD1 E11 ICD9 CODE - CONDITION 1 87 90 ICD2 E11 ICD9 CODE - CONDITION 2 91 94 ICD3 E11 ICD9 CODE - CONDITION 3 95 98 ICD4 E11 ICD9 CODE - CONDITION 4 99 100 XRAY E12A PID HAD X-RAY 101 102 SCAN E12B PID HAD CT, SONO, OTHER SCAN 103 104 CULTURE E12C PID HAD CULTURE, OTHER LAB TEST 105 106 DIAGTEST E12D PID HAD EKG, EEG, OTHER DX TEST 107 108 SURGERY E12E PID HAD SURGICAL PROCEDURE 109 110 PROCCODE E13 PROCEDURE CODE 111 118 EXPFAC E17/E29 ORIGINAL ER FAC CHARGE/VISIT 119 126 EXPFACX EDITED ER FACILITY EXPENSE/VISIT 127 127 EXPFCFLG IMPUTATION FLAG FOR EDITED ER FAC EXP 128 135 SOPFSELF PCT PAYMENT FROM SELF OR FAMILY-FAC EXP 136 143 SOPFPRVT PCT PAYMENT FROM PRIVATE INSUR-FAC EXP 144 151 SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP 152 159 SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 160 167 SOPFOTFD PCT PAYMENT FROM OTHER FEDERAL-FAC EXP 168 175 SOPFOTST PCT PAYMENT FROM OTHER STATE-FAC EXP 176 183 SOPFWC PCT PAYMENT FROM WORKERS COMP-FAC EXP 184 191 SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 192 199 SOPFFFP PCT PAYMENT FREE FROM PROVIDER-FAC EXP 200 200 SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 201 207 EXPDRX EDITED ER DOCTOR EXPENSE 208 208 EXPDRFLG IMPUTATION FLAG FOR EDITED DOC EXPENSE 209 216 SOPDSELF PCT PAYMENT FROM SELF OR FAMILY-DR EXP 217 224 SOPDPRVT PCT PAYMENT FROM PRIVATE INSUR-DR EXP 225 232 SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 233 240 SOPDMCD PCT PAYMENT FROM MEDICAID-DR EXP 241 248 SOPDOTFD PCT PAYMENT FROM OTHER FEDERAL-DR EXP 249 256 SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 257 264 SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 265 272 SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 273 280 SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 281 281 SOPDFLG IMPUTATN FLG FOR SOURC PAYM INFO-DOC CHG 282 289 EXPTOTX EDITED TOTAL ER EXPENSE 290 291 ADMTHOSP E52 PID ADMITTED TO HOSP AFTER ER VISIT 292 292 ADMTHOSX E52ED PID ADMITTED HOSP AFTER ER VISIT 293 294 VLENGHRS E53 LENGTH OF ER VISIT-HOUR 295 296 VLENGMIN E53 LENGTH OF ER VISIT-MINUTES 297 299 TRAVMINS E54 TIME PID TRAVELLED TO ER-MINS 300 301 TRANSP E55 HOW PID TRAVELLED TO ER 302 303 IHSFAC E56 FACILITY IS IHS OR TRIBE/ANC 304 315 INCALPER FULL-YEAR WEIGHT 316 318 STRATUMX SAMPLING STRATUM 319 319 SPSU PSEUDO PSU FILE 3: HOSPITAL EMERGENCY ROOM VISIT CODEBOOK General Infoemation THIS CODEBOOK PROVIDES UNWEIGHTED AND WEIGHTED FREQUENCIES FOR VISITS TO HOSPITAL EMERGENCY ROOMS DURING CALENDAR YEAR 1987. THE DATA FILE CONTAINS ONE RECORD PER VISIT FOR EACH PERSON IN THE HOUSEHOLD SURVEY WHO REPORTED HAVING RECEIVED CARE IN A HOSPITAL EMERGENCY ROOM DURING THE REFERENCE PERIOD. BASIC DEMOGRAPHIC INFORMATION FOR EACH PATIENT, CHARACTERISTICS OF THE VISIT, CONDITIONS AS REPORTED IN THE HOUSEHOLD SURVEY, AND ALL FACILITY AND PHYSICIAN EXPENSES ARE INCLUDED ON EACH RECORD. 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 VARIANCE ESTIMATION IS PROVIDED IN THE FILE DOCUMENTATION. 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 CODEBOOK IN ALPHABETICAL ORDER OF THE VARIABLE NAME. Variable Positions 1-47 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ODUX ORIG DWELLING UNIT OF PERSON 5.0 NUM 1 5 VALUE 20003-37610 TOTAL PN PERSON NUMBER 3.0 NUM 6 8 VALUE 10-266 TOTAL EN EVENT NUMBER 4.0 NUM 9 12 * VALUE 11-1209 TOTAL PIDX PERSON ID (ODUX + PN) 8.0 CHAR 13 20 VALUE VALID PERSON ID TOTAL EVENTIDX EVENT ID (ODUX + PN + EN) 12.0 CHAR 21 32 * VALUE VALID EVENT ID TOTAL ROUND DATA COLLECTION ROUND 2.0 NUM 33 34 * VALUE -9 NOT ASCERTAIN 1 2 3 4 TOTAL LASTAGE ED PID AGE AT END OF LAST ELIG RND 3.0 NUM 35 37 * VALUE 0-17 18-44 45-64 65+ TOTAL SMPSEXR PID SEX 1.0 NUM 38 38 VALUE 1 MALE 2 FEMALE TOTAL RACE6 ED PID RACE 1.0 NUM 39 39 * VALUE 1 AMER INDIAN 2 ALASKAN NATIVE 3 ASIAN/PACIFIC 4 BLACK 5 WHITE 6 OTHER TOTAL RACE3 PID RACE/ETHNICITY 1.0 NUM 40 40 * VALUE 1 HISPANIC 2 BLACK NONHISP 3 OTHER TOTAL SREGION PID CENSUS REGION 1.0 NUM 41 41 VALUE 1 NORTHEAST 2 MIDWEST 3 SOUTH 4 WEST TOTAL PREGFLG VISIT RELATED TO PREGNANCY 1.0 NUM 42 42 * VALUE 1 YES 2 NO TOTAL DATEBMM E1 DATE ER VISIT-MONTH 2.0 NUM 43 44 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -5 NEVER KNOW 1 JANUARY 2 FEBRUARY 3 MARCH 4 APRIL 5 MAY 6 JUNE 7 JULY 8 AUGUST 9 SEPTEMBER 10 OCTOBER 11 NOVEMBER 12 DECEMBER TOTAL DATEBDD E1 DATE ER VISIT-DAY 2.0 NUM 45 46 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW 1-31 TOTAL DATEBYY E1 DATE ER VISIT-YEAR 2.0 NUM 47 48 VALUE 87 TOTAL Variable Positions 49-79 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- WEEKDAY E2 DAY OF WEEK OF ER VISIT 2.0 NUM 49 50 VALUE -9 NOT ASCERTAIN -8 DK -7 REFUSED 1 MONDAY 2 TUESDAY 3 WEDNESDAY 4 THURSDAY 5 FRIDAY 6 SATURDAY 7 SUNDAY TOTAL ERHOUR E3 TIME OF DAY OF ER VISIT 2.0 NUM 51 52 VALUE -9 NOT ASCERTAIN -8 DK 01-12 TOTAL ERMINS E3 TIME OF DAY OF ER VISIT-MIN 2.0 NUM 53 54 VALUE -9 NOT ASCERTAIN -8 DK 00-59 TOTAL ERTIME E3 TIME OF DAY OF ER VISIT-HOUR 2.0 NUM 55 56 VALUE -9 NOT ASCERTAIN -8 DK AM PM TOTAL TYPEEFAC E4 EMERG RM WAS FACIL OF VET ADMIN 2.0 NUM 57 58 VALUE -9 NOT ASCERTAIN -8 DK -1 INAPPLICABLE 1 YES 2 NO TOTAL PLACEIDX E5 ID OF FACILITY 8.0 CHAR 59 66 * VALUE VALID FACILTY ID TOTAL MDTELLGO E6 ER VISIT SUGGSTD BY MED PROV 2.0 NUM 67 68 VALUE -9 NOT ASCERTAIN -8 DK 1 YES 2 NO TOTAL MDMEETP E7 MED PROVIDER MET PID IN ER 2.0 NUM 69 70 VALUE -9 NOT ASCERTAIN -8 DK -1 INAPPLICABLE 1 YES 2 NO TOTAL DOCRIDX E8 ID OF E6 MED PROVIDER 8.0 CHAR 71 78 * VALUE -1 INAPPLICABLE VALID DOCTOR ID TOTAL DRCOD E8 SPECIALTY OF E6 MED PROVIDER 2.0 NUM 79 80 * VALUE -9 NOT ASCERTAIN -1 INAPPLICABLE 1 ALLERGY 3 CARDIOLOGY 4 DERMATOLOGY 5 FAMLY PRCTICE 6 GENRL PRCTICE 7 INTERNL MEDCN 8 OB/GYN 9 OPHTHALMOLOGY 10 ORTHOPEDICS 11 OSTEOPATHY 12 OTOLARYNGOLGY 14 PEDIATRICS 16 RADIOLOGY 17 SURGERY 18 UROLOGY 19 DENTIST/CLNIC 20 EM ROOM PHYSN 21 NEUROLOGIST 22 ONCOLOGIST 24 GASTRENTERLGY 26 NEPHROLOGY 55 NURSE 57 TECHNICIAN 59 OPTOMETRIST 60 PODIATRIST 61 PHYSCIAN ASST 62 PHYSCAL THERA 91 OTH DOC SPECL 92 OTH PRVDR TYP TOTAL Variable Positions 81-119 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- EROFFOUT E9 E6-PROVDR OFF OUTSIDE HOSP 2.0 NUM 81 82 VALUE -9 NOT ASCERTAIN -8 DK -1 INAPPLICABLE 1 YES 2 NO TOTAL ICD1 E11 ICD9 CODE-CONDITION 1 4.0 CHAR 83 86 * VALUE -9 NOT ASCERTAIN V001-V009 X001-X009 0001-9999 TOTAL ICD2 E11 ICD9 CODE-CONDITION 2 4.0 CHAR 87 90 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN V001-V009 X001-X009 0001-9999 TOTAL ICD3 E11 ICD9 CODE-CONDITION 3 4.0 CHAR 91 94 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN X001-X009 0001-9999 TOTAL ICD4 E11 ICD9 CODE-CONDITION 4 4.0 CHAR 95 98 * VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN 0001-9999 TOTAL XRAY E12A PID HAD X-RAY 2.0 NUM 99 100 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL SCAN E12B PID HAD CT,SONO,OTHER SCAN 2.0 NUM 101 102 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL CULTURE E12C PID HAD CULTURE,OTHER LAB TEST 2.0 NUM 103 104 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL DIAGTEST E12D PID HAD EKG,EEG,OTHR DX TEST 2.0 NUM 105 106 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL SURGERY E12E PID HAD SURGICAL PROCEDURE 2.0 NUM 107 108 VALUE -9 NOT ASCERTAIN -8 DON'T KNOW 1 YES 2 NO TOTAL PROCCODE E13 PROCEDURE CODE 2.0 CHAR 109 110 VALUE -1 INAPPLICABLE -9 NOT ASCERTAIN 00-99 TOTAL EXPFAC E17/E29 ORIGINAL ER FAC CHARGE/VISIT 8.2 NUM 111 118* VALUE -9 NOT ASCERTAIN -8 DON'T KNOW -7 REFUSED -5 NEVER KNOW -1 INAPPLICABLE 1.00- 5 5.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01- 1000 1000.01- 2000 2000.01- 5000 5000.01-20489 TOTAL EXPFACX EDITED ER FACILITY EXPENSE/VISIT 8.2 NUM 119 126* VALUE 0 1.00- 5 5.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01- 1000 1000.01- 2000 2000.01- 5000 5000.01-16641 TOTAL Variable Positions 127-201 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- EXPFCFLG IMPUT FLAG FOR EDITED ER FAC EXP 1.0 NUM 127 127* VALUE 1 EXP FROM HS 2 EXP FROM MPS 3 EXP IMPUTED TOTAL SOPFSELF PCT PAYMT FROM SELF OR FAMILY-FAC EXP 8.4 NUM 128 135 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFPRVT PCT PAYT FROM PRIVATE INSUR-FAC EXP 8.4 NUM 136 143 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFMCR PCT PAYMENT FROM MEDICARE-FAC EXP 8.4 NUM 144 151 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFMCD PCT PAYMENT FROM MEDICAID-FAC EXP 8.4 NUM 152 159 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFOTFD PCT PAYMENT FROM OTHER FEDERAL-FAC EXP 8.4 NUM 160 167 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFOTST PCT PAYMENT FROM OTHR STATE-FAC EXP 8.4 NUM 168 175 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFWC PCT PAYMENT FROM WORKERS COMP-FAC EXP 8.4 NUM 176 183 VALUE 0 100 TOTAL SOPFOTHR PCT PAYMENT FROM OTHER-FAC EXP 8.4 NUM 184 191 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFFFP PCT PAYMT FREE FROM PROVIDER-FAC EXP 8.4 NUM 192 199 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPFFLG IMPUTATN FLG FOR SOURC PAYM INFO-FAC EXP 1.0 NUM 200 200* VALUE 0 NO EXPENSES 1 ALL SOP FRM HS 2 ALL SOP IMPUTD TOTAL EXPDRX EDITED ER DOCTOR EXPENSE 7.2 NUM 201 207 * VALUE 0 1.00- 5 5.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01- 1000 1000.01- 2000 2000.01- 5000 TOTAL Variable Positions 208-282 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- EXPDRFLG IMPUTAT FLAG FOR EDITED DOC EXP 1.0 NUM 208 208 * VALUE 2 EXP FROM MPS 3 EXP IMPUTED TOTAL SOPDSELF PCT PAYMENT FROM SELF OR FAMILY-DR EXP 8.4 NUM 209 216 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDPRVT PCT PAYMT FROM PRIVATE INSUR-DR EXP 8.4 NUM 217 224 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDMCR PCT PAYMENT FROM MEDICARE-DR EXP 8.4 NUM 225 232 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDMCD PCT PAYMT FROM MEDICAID-DR EXP 8.4 NUM 233 240 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDOTFD PCT PAYM FROM OTHR FEDERAL-DR EXP 8.4 NUM 241 248 VALUE 0 GT 0 TO 20 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDOTST PCT PAYMENT FROM OTHER STATE-DR EXP 8.4 NUM 249 256 VALUE 0 GT 0 TO 20 GT 40 TO 60 GT 60 TO 80 100 TOTAL SOPDWC PCT PAYMENT FROM WORKERS COMP-DR EXP 8.4 NUM 257 264 VALUE 0 100 TOTAL SOPDOTHR PCT PAYMENT FROM OTHER-DR EXP 8.4 NUM 265 272 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDFFP PCT PAYMENT FREE FROM PROVIDER-DR EXP 8.4 NUM 273 280 VALUE 0 GT 0 TO 20 GT 20 TO 40 GT 40 TO 60 GT 60 TO 80 GT 80 TO LT 100 100 TOTAL SOPDFLG IMPUTATN FLG FOR SOURC PAYM INFO-DOC CHG 1.0 NUM 281 281* VALUE 0 NO EXPENSES 1 ALL SOP FRM HS 2 ALL SOP IMPUTD TOTAL EXPTOTX EDITED TOTAL ER EXPENSE 8.2 NUM 282 289 * VALUE 0 1.00- 5 5.01- 100 100.01- 400 400.01- 600 600.01- 800 800.01- 1000 1000.01- 2000 2000.01- 5000 5000.01-16641 TOTAL Variable Positions 290-319 NAME DESCRIPTION FORMAT TYPE START END NOTE ---- ----------- ------ ---- ----- --- ---- ADMTHOSP E52 PID ADMITTED TO HOSP AFTER ER VISIT 2.0 NUM 290 291 VALUE -9 NOT ASCERTAIN -8 DK 1 YES 2 NO TOTAL ADMTHOSX E52ED PID ADMITTED HOSP AFTER ER VISIT 1.0 NUM 292 292 VALUE 1 YES 2 NO TOTAL VLENGHRS E53 LENGTH OF ER VISIT-HOUR 2.0 NUM 293 294 VALUE -9 NOT ASCERTAIN -8 DK -1 INAPPLICABLE 00-24 TOTAL VLENGMIN E53 LENGTH OF ER VISIT-MINUTES 2.0 NUM 295 296 VALUE -9 NOT ASCERTAIN -8 DK -1 INAPPLICABLE 00-59 TOTAL TRAVMINS E54 TIME PID TRAVELLED TO ER-MINS 3.0 NUM 297 299 VALUE -9 NOT ASCERTAIN -8 DK 1-999 TOTAL TRANSP E55 HOW PID TRAVELLED TO ER 2.0 NUM 300 301 VALUE -9 NOT ASCERTAIN -8 DK 1 PRIVATE AUTO 2 TAXI 3 PUBLIC TRANSP 4 AMBULANCE 5 WALKING 91 OTHER TOTAL IHSFAC E56 FACILITY IS IHS OR TRIBE/ANC 2.0 NUM 302 303 VALUE -9 NOT ASCERTAIN -1 INAPPLICABLE 1 IHS 2 TRIBE/ANC 3 NOT IHS/TRIBE TOTAL INCALPER FULL-YEAR WEIGHT 12.6 NUM 304 315 * VALUE 780.924-27174.39 TOTAL STRATUMX SAMPLING STRATUM 3.0 NUM 316 318 * VALUE 301-401 TOTAL SPSU PSEUDO PSU 1.0 NUM 319 319 * VALUE 1 2 TOTAL NMES HOUSEHOLD SURVEY AMBULATORY USE DATA CODEBOOK NOTES FOR FILES 1,2, AND 3 An asterisk in the right-most column of the 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. VARIABLE NOTE DRCOD The medical specialty of the provider PROVCOD (PROVCOD) or physician (DRCOD) recorded verbatim from the respondent's answer to question J10 or J12 (File 1; Medical Provider Visit Questionnaire) and question E8 (File 3; Emergency Room Visit Questionnaire). For less than 1 per cent of cases on File 1, the reported specialty was edited to resolve inconsistencies with response to question(s) J5 (WHRSEEMP), J13 (PRSNPROV), J15/J17 (ICD1-ICD4), and J18 (XRAY-DIAGTEST). No other editing was performed. DOCRIDX Provider identification variables constructed to PLACEIDX link medical providers, physicians, and places of PROVIDX care (PROVIDX, DOCRIDX, PLACEIDX) across NMES household files. Responses to questions identifying the medical provider seen or talked to (File 1; question J10), or the supervising physician (File 1; question J12), or the provider who met the sampled person in the emergency room (File 3; question E8) and the hospital visited (File 2; question F4, and File 3; question E5) were converted to numerical identifiers. These variables link to the corresponding variables on Files 1, 2 and 3 and to NMES Public Use Tape 14.2 (question H6, home health visit file); Public Use Tape 14.4 (question G2; hospital stay file), and Public Use Tape 9 (questions W5, W12 or W15; usual source of care file). Each identifier consists of the ODUX variable plus a three-digit number assigned to each provider, physician, or place of care reported by a dwelling unit. Since this number was assigned within a dwelling unit, this identifier is not unique across dwelling units. Also, if the respondent saw a provider in more than one location it is possible to have a different provider ID for each location. For linkage, these variables (DOCRIDX, PROVIDX, PLACEIDX, and IHSANIDX; the latter on Tape 9 only) must be renamed to a common variable name. Provider type has not been verified across files. EN These variables (Files 1 and 2) EVENTIDX identify and link multiple or repeat ambulatory RVISN visits. VISITIDX is the unique record VISITIDX identifier for each ambulatory visit. The event number, EN, identifies an initial contact with a given provider for specific services during a round. RVISN is the numerical identifier for repeat visits within one data collection round to the same provider for the same services at the same expense. Here, RVISN for the first visit equals zero and all repeat visits associated with that visit are numbered consecutively (RVISN=1 to n). The first visit and all repeat visits share the same event number. There are no repeat visits on the Emergency Room visit file (File 3) and the unique record identifier is EVENTIDX. EN as provided on the Emergency Room file identifies each ER visit for a person. EXPDRFLG A flag indicating whether the facility expense EXPFCFLG (EXPFCFLG on Files 2 and 3), physician expense EXPTFLG (EXPDRFLG on Files 2 and 3), or total expense (EXPTFLG on File 1) was imputed, provided directly from the household respondent or taken from the Medical Provider Survey. EXPDRX On the medical provider visit file (File 1) the EXPFAC unedited charge (EXPTOT) and edited expenditure EXPFACX (EXPTOTX) variables reflect total expense EXPTOT for each 1987 medical provider visit. On the EXPTOTX hospital outpatient file (File 2) and the emergency room file (File 3), the unedited charge (EXPFAC) and edited (EXPFACX) facility expense represent the total charges for outpatient facility care excluding separately billed charges for physician services, which are represented by the constructed variable EXPDRX. For editing and imputation procedures, see Section C.1.2 of the documentation. ICD1 Variables indicating up to 4 different medical ICD2 conditions associated with the visits on Files ICD3 1-3. They represent both conditions ICD4 reported by the household respondent as the reason for the visit (File 1, J15; File 2, F9; File 3, E11) and conditions as discovered during the visit reported by the household respondent. (File 1, J17; File 2, F11). The variables do not distinguish between reason for visit and physician-discovered conditions. INCALPER Weight adjusted for nonresponse and post- stratified to U.S. census data. Estimates of utilization and expenditure for ambulatory medical events require the use of weighted data. For details on this weight, see Section 4 of documentation. LASTAGE An edited variable which identifies the person's 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 were edited. MVISCLAS Constructed variable (File 1) that indicates the provider type for medical provider visits. PLACEIDX See DOCRIDX. PREGFLG A constructed variable which indicates whether the visit was associated with a pregnancy. Pregnancy related visits were identified using the following: (i) any condition code in the ranges 6300-6769, V220-V222, V230-V239, V240-V242 and V300-392; (ii) a procedure code in the range 72-75; (iii) a pregnancy related reason given for the visit on File 1 (PRSNPROV = 4) or File 2 (WHYVIST = 4); (iv) a flat fee which also covers events having any of the characteristics of items i, ii, or iii. PROVCOD See DRCOD. PROVIDX See DOCRIDX. PRSNPROV Categories 8-20 were created for this variable after reviewing the "other specified" text fields (File 1, question J13). Categories may duplicate original categories from the questionnaire. Possible positive values are: 1 Diagnosis or treatment 2 General checkup 3 Vision exam for glasses 4 Maternity care (pre/postnatal) 5 Well-child exam 6 Immunizations 7 Psychotherapy/Mental health counseling 8 Reproductive services 9 Foot care 10 Physical therapy 11 X-rays 12 CATSCANS, sonograms, bodyscans 13 Throat cultures, blood/urine testing 14 Diagnostic testing 15 Surgery/procedures 16 Tests,unspecified 17 Pre-admission testing 18 Hearing tests 19 Speech therapy 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. ROUND Indicator of the round of data collection. Dates specific to each person's rounds of data collection are provided on NMES Public Use Tape 13. RVISN See EN. SEEOTDCX "Other specify" text fields for question F6 (File 2) were reviewed and recoded into variables representing the preexisting categories; new categories 10-12 were created as appropriate. Possible positive values for this variable are: 10 Radiologist 11 Counselor/therapist 12 Occupational therapist 91 Other SOPDFLG Variables indicating whether all the sources of SOPFFLG payment were provided by the household respondent SOPTFLG or imputed. SOPTFLG relates to sources of payment for a record on File 1; SOPFFLG and SOPDFLG are common to the outpatient visit file (File 2) and the emergency room visit file (File 3). 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 the Technical and Programming section on this file and the hard copy documentation accompanying this tape. VISITIDX See EN. WHRSEEMP Variable indicating place of care. The skip patterns associated with these questions (J5 and Box J2; File 1) have not been edited. As a result, File 1 includes 11 home health provider visit records and 303 hospital outpatient, hospital inpatient, or emergency room visit records. Categories 12-24 were created for this variable after reviewing "other specify" text fields for question J5. Possible positive values for this variable are: 1 Doctor's office or group practice 2 Doctor's clinic 3 Neighborhood/family health center 4 Free standing surgical center 5 Company clinic 6 School clinic 7 Other clinic 8 Home 9 Laboratory 10 Walk-in urgent center 11 Hospital outpatient clinic, hospital inpatient clinic, emergency room. 12 Telephone 19 Dental clinic 20 Long-term care facility 21 Home health agency 22 Optical store 23 Radiology 24 Ambulance service 91 Other WHYVISIT Variable indicating reason for visit for outpatient visit (File 2). Categories 8-19 were created for this variable after reviewing the "other specify" text fields for question F7. Newly created categories may duplicate original categories from the questionnaire. Possible positive values are: 1 Diagnosis or treatment 2 General checkup 3 Vision exam for glasses 4 Maternity care (pre/postnatal) 5 Well-child Exam 6 Immunizations 7 Psychotherapy/mental health counseling 8 Reproductive services 9 Foot care 10 Physical therapy 11 X-rays 12 CATSCANS, sonograms, bodyscans 13 Throat cultures, blood or urine testing 14 Diagnostic testing 15 Surgery or procedures 16 Tests, unspecified 17 Pre-admission testing 18 Hearing tests 19 Speech therapy 91 Other ZERONITE A person level variable which provides a count of the number of zero night hospital stays. (See Section C.1.4.3 on the current documentation and NMES Tape 14.4, Hospital Stays.
This page last reviewed:
Thursday, January 28, 2016
This information is provided as technical reference material. Please contact us at cwus@cdc.gov to request a simple text version of this document.