Docstoc

HTN Registry Data Dictionary_20110811

Document Sample
HTN Registry Data Dictionary_20110811 Powered By Docstoc
					HMORN HTN Registry Data Dictionary
Last updated: 06/23/11
                                                                     KPCO
                                           VDW (diagnoses, vitals, demographic, pharmacy), Epic
                   source
Superset           date ranges available   2000-2009
                   update frequency        Static
                   comments
                   source                  VDW Demographics(Common Membership, clarity)
                   date ranges available   2000-2009
Demographics
                   update frequency        Static
                   comments
                   source                  VDW Enrollment (Common Membership)
                   date ranges available   2000-2009
Enrollment         update frequency        Static
                                           Using local variables to indicate HMO members vs. Network
                   comments                members -
                                           VDW Vitals (Epic, CIS, and Data Warehouse)
                   source
                   date ranges available   2000-2009
Vitals             update frequency        Static
                                           Only have vitals for KPCO internal clinics, very rarely
                   comments                rounding visits -
                                           VDW Encounters
                                           (QCARE (claims system 200-2009), Epic (2005-2009)
                   source                  Legacy Data Warehouse (2000 - 2004))
Encounters         date ranges available   2000-2009
                   update frequency        Static

                   comments
                                           VDW Diagnoses
                                           (QCARE (claims system 200-2009), Epic (2005-2009)
                   source                  Legacy Data Warehouse (2000 - 2004))
Diagnoses          date ranges available   2000-2009
                   update frequency        Static

                   comments
                                           VDW Procedures
                                           (QCARE (claims system 200-2009), Epic (2005-2009)
                   source                  Legacy Data Warehouse (2000 - 2004))
Procedures         date ranges available   2000-2009
                   update frequency        Static

                   comments
                                           VDW Mortality
                   source                  (Epic, Membership system and state files)
Mortality          date ranges available   2000-2009
                   update frequency        Static
                   comments
                                           VDW Cause of Death
                   source                  (state files)
Cause of Death     date ranges available   2000-2009
                   update frequency        Static
                   comments
                                           VDW Pharmacy
                   source                  (PIMS Pharmacy System)
Pharmacy           date ranges available   2000-2009
Pharmacy
                  update frequency        Static
                  comments                Not easily linked to Med orders.
                                          VDW Ever NDC, local product link files
                  source                   (PIMS Pharmacy System)
EverNDC_Plus      date ranges available   2000-2009
                  update frequency        Static
                  comments
                  source                  NOT CURRENTLY AVAILABLE
                  date ranges available
Med_Orders
                  update frequency
                  comments
                                          VDW Labs (for some labs)
                                          Epic (2005-2009)
                  source                  Legacy Data Warehouse (2000 - 2004)
                  date ranges available
Labs
                  update frequency        Static
                                          3 Labs still incomplete as of 10/09/09, waiting for VDW
                                          definitions
                  comments
                  source                  Data Warehouse, HealthTrack system
                  date ranges available   2000-2009
Clinics
                  update frequency        Static
                  comments                Still working on clinic descriptives
                  source                  VDW Census
                  date ranges available   2000 Census data
Census
                  update frequency        Static
                  comments
                                          VDW Provider Specialty, Credentialling, Epic, Data
                  source                  Warehouse
Provider          date ranges available   2000-2009
                  update frequency        Static
                  comments
                  source                  HTN Registry Encounters, HTN Registry Provider
                  date ranges available   2000 Census data
Provider_Yearly
                  update frequency        Static
                  comments
                      KPNC                                                  HPRF
VDW (diagnoses, vitals, demographic, pharmacy),   VDW (diagnoses, vitals, demographic, pharmacy), Epic
Epic
2000-2009                                         2000-2009
Static                                            Static

VDW Demographics (need sourcing info)             VDW Demographics (Epic and Claims)
2000-2009                                         2000-2009
Static                                            Static

VDW Enrollment (Membership system)                VDW Enrollment (Claims data)
2000-2009                                         2000-2009
Static                                            Static
                                                  Created HP filters to help with membership.

VDW Vitals (Legacy and Clarity)                   VDW Vitals (Epic)

2000-2009                                         2002-2009
Static                                            Static
                                                  Staggered rollout for clinics starting in 2002, most completed
                                                  by 2004. Only have vitals for owned clinics.
VDW Encounters                                    VDW Encounters
(Legacy and Clarity)                              (Claims, Epic)

2000-2009                                         2000-2009
Static                                            Static
                                                  Encounters from people who were members at time of visit

VDW Diagnoses                                     VDW Diagnoses
(Legacy and Clarity)                              (Claims, Epic)

2000-2009                                         2000-2009
Static                                            Static
                                                  Diagnoses from people who were members at time of visit.

VDW Procedures                                    VDW Procedures
(Legacy and Clarity)                              (Claims, Epic)

2000-2009                                         2000-2009
Static                                            Static
                                                  Procedures from people who were members at time of visit

VDW Mortality                                     VDW Morality
state of CA?                                      (Epic, Membership, State Files)
2000-2009                                         2000-2009
Static                                            Static
                                                  state files through 2006.
VDW Cause of Death                                VDW Cause of Death
NDI?                                              (state files)
2000-2009                                         2000-2006
Static                                            Static

VDW Pharmacy                                      VDW Pharmacy
(PIMS Pharmacy System)                            (Claims)
2000-2009                                         2000-2009
Static                                             Static

VDW Pharmacy (need sourcing information)           VDW EverNDC
                                                   (Claims)
                                                   2000-2009
Static

NOT CURRENTLY AVAILABLE                            NOT CURRENTLY AVAILABLE




LURS, regional laboratory reporting system         VDW Labs (Epic)



2000-2009                                          2000-2009
Static                                             Static
                                                   Have QA specific labs for analyses, further testing needed
                                                   for other labs. Waiting for VDW definitions. Only have lab
                                                   results from owned clinics.
Legacy and Clarity                                 Internal clinic reports
2000-2009                                          2000-2009
Static                                             static

VDW Census                                         VDW Census Data
2000 Census data                                   2000 Census data
Static                                             Static

VDW missing HMO provider board cert. and date of   Epic, Phyisican Services / Credentialing
hire
2000-2009                                          2000-2009
Static                                             Static
                                                   Most info on providers from owned clinics.
HTN Registry Encounters, HTN Registry Provider     HTN Registry Encounters, HTN Registry Provider
under development                                  2000-2009
Static                                             Static
SUPERSET
Please refer to the Superset Determination Document for more specific information on how to assign values for the ss_entry flags and the superset entry date
Variable names in all caps are dates based on combined criteria and can be used as indicators as to how an individual got into the superset or what combine
Data spans the years of 2000 - 2009; Superset meant to contain those patients with diagnosed and undiagnosed hypertension.
*More than one condition can be met at the same time, so multiple superset entry flags may be set to Y for any given STUDY_ID

           Variable Name             Type                    Values
Study_id                           Num 8     Identifier unique to an individual

                                             KPCO: study id= 106xxxxxxxxx
                                             HP : study_id= 107xxxxxxxxx
                                             KPNC: study_id= 103xxxxxxxxx
Site_id                            Num 4     Identifier unique to site

                                             KPCO: site id = 106
                                             HP : site_id = 107
                                             KPNC: site_id = 103
SUPERSET_ENTRY_DT                  Num 4     SAS Date




SS_ENTRY_2DX                       Char 1    Y' = Yes
                                             ' ' = No or missing

DT_2DX_MET                         Num 4     SAS Date



SS_ENTRY_DX_RX                     Char 1    Y' = Yes
                                             ' ' = No or missing

DT_DX_RX_MET                       Num 4     SAS Date




SS_ENTRY_DX_EBP                    Char 1    Y' = Yes
                                             ' ' = No or missing
DT_DX_EBP_MET                      Num 4     SAS Date




SS _ENTRY_2EBP                     Char 1    Y' = Yes
                                             ' ' = No or missing
DT_2EBP_MET                        Num 4     SAS Date



DT_3EBP_MET                        Num 4     SAS Date



dx1_dt                             Num 4     SAS Date



dx2_dt                             Num   4   SAS Date
problist_init_dt                   Num   4   SAS Date
rx_init_dt                         Num   4   SAS Date
ebp_init_dt                        Num   4   SAS Date

Cnsc2_ebp1_dt                      Num 4     SAS Date
Cnsc2_ebp2_dt        Num 4    SAS Date
Cnsc3_ebp1_dt        Num 4    SAS Date
Cnsc3_ebp2_dt        Num 4    SAS Date
Cnsc3_ebp3_dt        Num 4    SAS Date
CKD_DT               Num 4    SAS Date
DM_DT                Num 4    SAS Date
Secondary_HTN_flag   Char 1   Y' = Yes
                              ' ' = No or missing

Prevalent_flag       Char 1   Y' = Yes
                              ' ' = No or missing
Other_HtnDX_flag     Char 1   Y' = Yes
                              ' ' = No or missing
cific information on how to assign values for the ss_entry flags and the superset entry date and for selecting appropriate blood pressures and diagnoses.
d can be used as indicators as to how an individual got into the superset or what combined criteria was met.
ose patients with diagnosed and undiagnosed hypertension.
superset entry flags may be set to Y for any given STUDY_ID

                                                                 Comments                                                       KPCO          KPNC
                12 digit number, with a ‘1’ always as the first digit and the VDW site code always in the next two digits.   Completed     Completed
                Following 9 digits are randomized/deidentified study id for which each site will maintain a crosswalk.




                3 digit number, with a ‘1’ always as the first digit and the VDW site code always in the next two digits.    Completed     Completed




                Date at which MRN entered the superset. This is based on the first condition met.                            Completed     Completed

                Because of how this is defined, this will either be set equal to DX1_DT or dt_2EBP_met, depending on
                whether the condition met first contains a diagnosis as a criteria ( such as DX + RX or DX + EPB) or
                whether the MRN met 2 EBPs prior to any diagnosis.
                Indicates whether the patient entered the superset due to having two diagnoses of hypertension. If two       Completed     Completed
                diagnoses were encountered before any other conditions were met then this flag is set to ‘Y’. *

                Date on which the patient met the criteria of having two diagnoses                                           Completed     Completed

                dt_2DX_met=dx2_dt
                Indicates whether the patient entered the superset due to having an HTN diagnosis and a treatment as the Completed         Completed
                earliest condition met. If a diagnosis and a treatment were encountered before any other conditions were
                met then this flag is set to ‘Y’. *
                Date on which the patient met the criteria of having a diagnosis AND a treatment (dispensed HTN med)         Completed     Completed

                dt_DX_RX_met= max(dx1_dt, rx_init_dt)

                Indicates whether the patient entered the cohort due to having an HTN diagnosis and an elevated blood        Completed     Completed
                pressure. If a diagnosis and an elevated blood pressure were
                Date on which the patient met the criteria of having a diagnosis AND an elevated blood pressure.             Completed     Completed

                dt_DX_EBP_met=max(dx1_dt, ebp_init_dt)

                Indicates whether the patient entered the cohort due to having three consecutive elevated blood              Completed     Completed
                pressures.
                Date on which the patient met the criteria of having two consecutive elevated blood pressures.               Completed     Completed

                dt_2EBP_met=cnsc2_ebp2_dt
                Date on which the patient met the criteria of having two consecutive elevated blood pressures.               Completed     Completed

                dt_3EBP_met=cnsc3_ebp3_dt
                Date of first HTN diagnosis during 2000-2007 time period                                             Completed             Completed
                See CVRN Superset Determination document for requirements around selecting an appropriate diagnosis.

                Date of second HTN diagnosis during 2000-2007 time period                                                    Completed     Completed
                Date of first problem list entry with an associated HTN diagnosis during 2000-2007 time period               Completed     Completed
                Date of first dispense of an HTN medication during 2000-2007 time period                                     Completed     Completed
                Date of first elevated blood pressure during 2000-2007 time period. See CVRN Superset Determination          Completed     Completed
                document for requirements around determining an elevated blood pressure.
                Date of first blood pressure in a series of two consecutive blood pressures                                  Completed     Completed
Date of second blood pressure in a series of two consecutive blood pressures                                    Completed      Completed
Date of first blood pressure in a series of three consecutive blood pressures                                   Completed      Completed
Date of second blood pressure in a series of three consecutive blood pressures                                  Completed      Completed
Date of third blood pressure in a series of three consecutive blood pressures                                   Completed      Completed
Date of first evidence of Chronic Kidney disease, merged in from the DMCKD_DATES table.                         Completed      Completed
Date of first evidence of diabetes, merged in from the DMCKD_DATES table.                                       Completed      Completed
Defined in creation document but was not in data dictionary for CVRN…identifies whether the patient             Completed      Completed
entered based on one or more "secondary hypertension" diagnoses (secondary to another condition such
as CKD) as opposed to primary/essential HTN
Potiential field for DRN2: To be defined - flagged with Y if there are any prior "valid criteria" DX prior to   not included   not included at
2000. Need determination on how far back to go and an IRB modification if desired .                             at this time   this time
Potiential field for DRN2: flagged as Y if there are any non-criteria DX found prior to CVRN superset entry     not included   not included at
date. Used for validation and potentially for prevalence.                                                       at this time   this time
and diagnoses.




                   HPRF
                 Completed




                 Completed




                 Completed




                 Completed



                 Completed



                 Completed



                 Completed




                 Completed

                 Completed




                 Completed

                 Completed



                 Completed



                 Completed



                 Completed
                 Completed
                 Completed
                 Completed

                 Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed



not included
at this time
not included
at this time
  Table Name:   Demographics
       Status: Finalized
   Description: 1 record per person


                Variable
Variable Name   Definition Values                                                       Comments
                           Patient Identifier
Study_id        Num 8      See Definition in Superset table
Birth_Date      Num 4      SAS Date                                                     As pulled directly from VDW.

                                                                                        NOTE: Minnesota has strict
                                                                                        requirements about disclosing birth
                                                                                        date, so distributed code should be
                                                                                        written to calculate "year of xxxx" or
                                                                                        "age at xxxx" so that birthdate may be
                                                                                        dropped. HPRF will not send this on
                                                                                        in their data pulls.


Gender          Char 1     ‘M’ = male                                                   As pulled directly from VDW
                           ‘F’ = female
                           ‘O’ = Other
                           ‘T’ = Transsexual
                           ‘U’ = Unknown
Race1           Char 2     HP' = Native Hawaiian or Other Pacific Islander              As pulled directly from VDW
                           'IN' = American Indian/Alaska Native
                           'AS' = Asian
                           'BA' = Black or African American
                           'WH' = White
                           'MU' = More than one race, particular races unknown or not
                           reported
                           'UN' = Unknown or Not Reported

Race2           Char 2     See Race 1                                                   As pulled directly from VDW
Race3           Char 2     See Race 1                                                   As pulled directly from VDW
Hispanic        Char 1     ‘Y’ = Yes                                                    Hispanic origin (ethnicity)
                           ‘N’ = No                                                     As pulled directly from VDW
                           ‘ ‘ = Unknown
VDW         KPCO         KPNC        HPRF
N     Completed    Completed    Completed

Y     Completed    Completed    Completed




Y     Completed    Completed    Completed




Y     Completed    Completed    Completed




Y     Completed    Completed    Completed
Y     Completed    Completed    Completed
Y     Completed    Completed    Completed
      Completed    Completed    Completed
      Completed    Completed    Completed
     Table Name: ENROLLMENT
          Status: Finalized
     Description: Enrollment period detail, including primary care physician and clinic bonding.

NOTE: Business models are very different between the three sites, and each sites (especially KPCO and HP) have ways to locally determine or approximate an "HMO" member as
     opposed to an external utilizer. Please make sure to check with sites whenever followup or utilization is important for a study.

   Variable Name         Variable          Values                                               Comments                                             VDW
                        Definition
Study_id              Num 8                              Patient Identifier                                                                          N
                                                         See Definition in Superset table
enr_start             Num 4          SAS Date            A date signifying the beginning of the time period described by this record. If an input     Y
                                                         record from the VDW enrollment file has a beginning date before 1/1/2000 and an
                                                         ending date equal to or after 1/1/2000 then enr_start is set to 1/1/2000.

enr_end               Num 4          SAS Date            A date signifying the end of the time period described by this record. If an input record    Y
                                                         from the VDW enrollment file has an end date after 12/31/2009 and a start date before
                                                         12/31/2009 then the enr_end set to 12/31/2009.
DRUGCOV               Char 1         "Y"= Yes            In the event that membership drug coverage periods overlap and conflict, preference is       Y
                                     “N“ = No            given to “Y” drug coverage. Please see Note 2 below.
                                     "U" = Unknown
Ins_Medicaid          Char(1)        "Y"= Yes            Flag indicating whether the person had any Medicaid coverage during the period.              Y
                                     “N“ = No
                                     "U" = Unknown
Ins_Commercial        Char(1)        "Y"= Yes            Flag indicating whether the person had any Commercial coverage during the period.            Y
                                     “N“ = No
                                     "U" = Unknown
Ins_PrivatePay        Char(1)        "Y"= Yes            Flag indicating whether the person had Private Pay coverage during the period. This is       Y
                                     “N“ = No            defined broadly as the covered person bearing all (or most) of the cost of the premium.
                                     "U" = Unknown
Ins_StateSubsidized   Char(1)        "Y"= Yes            Flag indicating whether the person had any State Subsidized coverage during the              Y
                                     “N“ = No            period.Individuals who are eligible for a State-subsidized health insurance plan and
                                     "U" = Unknown       have elected to join the participating HMO under a risk contract with the State health
                                                         insurance program. These programs are typically designed for persons who are too
                                                         wealthy to qualify for Medicaid coverage but who cannot afford to purchase health
                                                         insurance on their own, usually because they do not have access to group health
                                                         insurance.
Ins_SelfFunded       Char(1)   "Y"= Yes        Flag indicating whether the person had any coverage through an Employer group that          Y
                               “N“ = No        insures itself. Larger companies may seek to save costs by directly bearing the risk of
                               "U" = Unknown   their employees’ medical expenses, rather than transferring it to an insurer/HMO. In
                                               these cases, the HMO generally retains the role of provider of care, and takes on the
                                               duties of a claims administrator
Ins_HighDeductible   Char(1)   "Y"= Yes        Flag indicating whether the person had any coverage in a high-deductible plan.A form        Y
                               “N“ = No        of catastrophic health insurance defined in US Internal Revenue Service Publication
                               "U" = Unknown   969. This type of coverage is required to take advantage of Health Savings Accounts.
                                               Please see Note 1 below.
Ins_Medicare         Char(1)   "Y"= Yes        Flag indicating whether the person had any Medicare coverage, including Medicare            Y
                               “N“ = No        Working Aged. Included for cases where the particular parts of Medicare are not
                               "U" = Unknown   known, but it is known that some Medicare coverage is in place. If any of the specific
                                               Medicare-part vars are set to ‘Y’, this should also = ‘Y’.

Ins_Medicare_A       Char(1)   "Y"= Yes        Flag indicating the person had Medicare Part A coverage during the period. Medicare         Y
                               “N“ = No        Hospital insurance.
                               "U" = Unknown
Ins_Medicare_B       Char(1)   "Y"= Yes        Flag indicating the person had Medicare Part B coverage during the period. Medicare         Y
                               “N“ = No        outpatient insurance.
                               "U" = Unknown
Ins_Medicare_C       Char(1)   "Y"= Yes        Flag indicating the person had Medicare Part C coverage during the period. “Medicare        Y
                               “N“ = No        Advantage” (nee Medicare+Choice) plans. Captitated benefits covering in- and
                               "U" = Unknown   outpatient care.
Ins_Medicare_D       Char(1)   "Y"= Yes        Flag indicating the person had Medicare Part D coverage during the period. Medicare         Y
                               “N“ = No        prescription drug coverage.
                               "U" = Unknown
Ins_Other            Char(1)   "Y"= Yes        Flag indicating whether the person had an Other type of coverage during the period.         Y
                               “N“ = No        Intended to cover any type of insurance not adequately categorized by one of the other
                               "U" = Unknown   Ins_* variables.
plan_hmo             Char(1)   "Y"= Yes        Had at least some coverage under an HMO plan. HEDIS defines HMO as “An                      Y
                               “N“ = No        organized health care system that is accountable for both the financing and delivery of
                               "U" = Unknown   a broad range of comprehensive health services to an enrolled population. An HMO is
                                               accountable for assessing access and ensuring quality and appropriate care.
                                               Practitioners affiliated with the health care system render health care services. In this
                                               type of organization, members must obtain all services from affiliated practitioners and
                                               must usually comply with a predefined authorization system to receive reimbursement.”
plan_pos              Char(1)        "Y"= Yes                  Had at least some coverage under a point-of-service plan. HEDIS defines POS as               Y
                                     “N“ = No                  “An HMO with an opt-out option. In this type of organization, members may choose to
                                     "U" = Unknown             receive services either within the organization’s health care system (e.g., an in-network
                                                               practitioner) or outside the organization’s health care delivery system (e.g., an out-of-
                                                               network practitioner). The level of benefits or reimbursement is generally determined
                                                               by whether the member uses in-network or out-of-network services. Common uses of
                                                               ‘POS’ include references to products that enroll each member in both an HMO (or HMO-
                                                               like) system and in an indemnity product. A POS product is also referred to as an ‘HMO
                                                               swing-out organization’, an ‘out-of-organization benefits rider to an HMO’ or an ‘open-
                                                               ended HMO’.


plan_ppo              Char(1)        "Y"= Yes                  Had at least some coverage under a preferred provider organization plan. HEDIS               Y
                                     “N“ = No                  Defines PPO as: “PPOs take responsibility for providing health benefits-related
                                     "U" = Unknown             services to covered individuals and for managing a practitioner network. They may
                                                               administer health benefits programs for employers, either by assuming insurance risk
                                                               or by providing only administrative services.”
plan_indemnity        Char(1)        "Y"= Yes                  Had at least some coverage under a traditional indemnity plan. Indemnity insurance           Y
                                     “N“ = No                  gives an insured the right to reimbursement of covered healthcare costs from the
                                     "U" = Unknown             insurer. There is typically no pretense that the care involved is “managed”.

outside_utilization   Char(1)        Y = Yes, we expect        Is this person/period likely to have substantial health care utilization outside the HMO     Y
                                     the utilization           system, under circumstances that would not result in a claim being submitted to the
                                     capture for this          HMO? See Note 3 below. The capture intended here does not include lab results or
                                     person/period is          vital signs data. Because those data areas are not feedable from claims data, and
                                     incomplete.               because the number of studies that rely on those data areas are relatively few, they are
                                                               defined outside the scope of this variable. Note that having data solely from claims is
                                     N = No, there is no       not a bar to using an ‘N’ value here, so long as the claims feed the appropriate VDW
                                     reason to suspect         files.
                                     we have incomplete
                                     capture of utilization.

                                     U = completeness of
                                     capture is unknown.




PCC                   Char(varies)                             Primary Care Clinic - The clinic to which the patient is paneled in administrative record.
                                                               Should have a matching record in Clinic Table. Please see Note 4 below.
PCP                     Char(varies)                           The clinician to which the patient is paneled in Provider Table. Please see Note 4
                                                               below. This is a masked provider ID.




3. Notes:
Note 1: High Deductible Health Plans
These plans came into vogue around 2006, and were aimed at stemming premium cost increases. They are characterized by deductibles far in excess of those typically offered in traditional managed care pla
resemble catastrophic coverage plans with a thin veneer of preventive/routine care coverage. The rules for when deductibles apply and how they are calculated within/between family members can be quite co
variations on individual/family deductible structure.

Note 2: DrugCov
If the member has any drug coverage, meaning that the insurer is at risk for any portion of the cost associated with drug dispensings, this should be coded as ‘Y’. It should of course follow from this that cover
guaranteed.

Note 3: outside_utilization
One of the primary advantages that HMORN member orgs enjoy in doing research is our ability to enumerate populations who are at risk for various things—suffering illness, utilizing healthcare services, etc.
compute rates of illness, and to identify sets of “unexposed” people for use as control subjects in studies. Implicit in this ability is the notion that we have a generally complete record of a patient’s health care in
make inferences from an absence of data in a given person’s record. For example, if a given person has no record of a colonoscopy during a period of enrollment, we would like to be able to conclude that the
colonoscopy. We would not like to have to worry—as many other healthcare organizations do—that the person has had a colonoscopy elsewhere, under circumstances that would not result in a claim or other
member organization for inclusion in administrative data.


That said, at nearly every HMORN site there are enrollees whose relationship to the organization is known to be of a type that does not give much assurance that the electronic data are complete. The forms t
and varied, and yet most every site has had to come to terms with those whose enrollment should not be taken to assure completeness of the medical record. Rather than try and take account of the various c
products at the various sites, and harmonize them to the point where we might define variables from which completeness can be derived, we have chosen to put the logic for the derivation in the hands o
are closest to their sites’ data, are familiar with local custom, and their good judgment is the basis for many other important decisions. In general, the question SDMs should ask themselves in populating this v
person/period from the denominator if I were calculating an incidence rate of a disease, procedure or pharmacy fill?”


Please note the negative nature of the logic here—a record with outside_utilization = ‘N’ is not a guarantee that data capture is in fact complete. It is merely a statement that the local SDM does not know the c
weaker statement. This is due to the difficulty entailed in determining (for every person, over every period of enrollment) the degree of data capture. We do not expect SDMs to derive this variable from what i
data—this is only for people/periods for whom we can tell from indigenous enrollment data that their capture is incomplete. SDMs at those rare sites that do not have any of these known-partial-capture enrolle
assign an ‘N’ to every record.

This variable is meant to serve an important need to research projects, but projects that are very sensitive to the need for complete data capture should consult with their sites about the degree to which this va
study-specific measures need to be taken.

A Special Note about Lab Result and Vital Signs Data Capture
In general, people/periods for whom the only source of data is claims should have outside_utilization = ‘N’. That is, good capture of claims data in utilization and pharmacy is enough to have an ‘N’ value. How
proportions of this group will also have no records in the vital signs or lab results files (and at Group Health at least, the Tumor file as well). Thus, projects requiring complete data capture in these files will hav
with the sites to develop such samples.


Note 4: Primary Care Clinic/Physician
These data items are intended to come from administrative data (e.g., a membership and billing system) and do not purport to describe the location or provider of primary care actually received. That is
assign PCP/PCC values from observed utilization data. Providers and facilities listed in these variables may exclusively provide primary care or may be a part of a facility that provides an array of care.


Primary Care Physicians will often be MDs, but may include other types of providers such as a physician assistants or nurse practitioners if the medical plan panels patients to clinicians with these disciplines.
receives primary care from may be different than the PCP. The PCP value should link to the PROVIDER lookup table associated with the Utilization data structure.
r approximate an "HMO" member as



                          KPCO           KPNC     HPRF

              Completed            Completed    Completed

              Completed            Completed    Completed




              Completed            Completed    Completed



              Completed            Completed    Completed



              Completed            Completed    Completed



              Completed            Completed    Completed



              Completed            Completed    Completed



              Completed            Completed    Completed
Completed   Completed   Completed




Completed   Completed   Completed




Completed   Completed   Completed




Completed   Completed   Completed



Completed   Completed   Completed



Completed   Completed   Completed



Completed   Completed   Completed



Completed   Completed   Completed



Completed   Completed   Completed
Completed                         Completed          Completed




Completed                         Completed          Completed




Completed                         Completed          Completed




Completed                           N=95%, Y=4%      Completed




Completed - only available and    approx 30% missing in progress
applicable for HMO members
(non-network model plans)
currently working on QA of this
data
                 Completed - only available and      approx 10% missing in progress
                 applicable for HMO members
                 (non-network model plans)
                 currently working on QA of this
                 data




 excess of those typically offered in traditional managed care plans—to the point where they
ey are calculated within/between family members can be quite complicated. Please document any




d be coded as ‘Y’. It should of course follow from this that coverage for any particular drug is not



 rious things—suffering illness, utilizing healthcare services, etc. This is what allows us to e.g.,
 we have a generally complete record of a patient’s health care in electronic data, enabling us to
 eriod of enrollment, we would like to be able to conclude that they did not in fact have a
ere, under circumstances that would not result in a claim or other notification to the HMORN



ch assurance that the electronic data are complete. The forms these relationships take are many
medical record. Rather than try and take account of the various circumstances and insurance
ave chosen to put the logic for the derivation in the hands of the Site Data Managers. They
al, the question SDMs should ask themselves in populating this variable is “would I exclude this



  It is merely a statement that the local SDM does not know the capture to be incomplete—a much
ture. We do not expect SDMs to derive this variable from what is found empirically in utilization
 sites that do not have any of these known-partial-capture enrollees, they should feel free to


e should consult with their sites about the degree to which this variable is suitable, or whether
 in utilization and pharmacy is enough to have an ‘N’ value. However, at most sites large
us, projects requiring complete data capture in these files will have to make special arrangements




ocation or provider of primary care actually received. That is, there is no effort to empirically
r may be a part of a facility that provides an array of care.


medical plan panels patients to clinicians with these disciplines. Who the enrollee actually
ation data structure.
          Table Name:    Vitals
               Status: Finalized
          Description: Contains vitals taken by MRN, date, time (where available) and department, for the entire superset. This is primarily a subset of the VDW, but other variables w



     Variable Name           Type                          Values                                                       Comments                                            VDW
Study_id                     Num 8                                              See Definition in Superset table                                                             N
Enc_id                       Num 8                                              See Definition in Encounters table - may be null where there is no direct system match or a  Y
                                                                                confident match to an encounter cannot be made.

                                                                                Used to link a vitals measurement to encounter detail, such as provider, dept, and any
                                                                                diagnoses/procedures performed during same visit.

                                                                                Note: In the VDW, if there is not a native system key, the enc_id is not mapped. This can
                                                                                cause missing or inaccurate provider/dept/enctype information at some sites. For the HTN
                                                                                Registry, as much effort as possible should be made to link vitals to ambulatory office visits
                                                                                where a confident match can be made. If a match can only be made on Study_id and
                                                                                Adate, do not match to an encounter unless there is only one encounter on that same date.


Enctype                      Char 2                                             See Definition in Encounters table. Use the associated encounter to assign this field. If an       Y
                                                                                encounter cannot be mapped due to not having a key between systems then use an
                                                                                indicator in the source system to assign this variable. Vitals measures collected in different
                                                                                clinical contexts will have different interpretations (e.g., BP collected in ED trauma situation
                                                                                may not reflect typical BP).
Encounter_subtype            Char 2                                             See Definition in Encounters table. Use the associated encounter to assign this field. If an       N
                                                                                encounter cannot be mapped due to not having a key between systems then use an
                                                                                indicator in the source system to assign this variable. Vitals measures collected in different
                                                                                clinical contexts will have different interpretations (e.g., BP collected in ED trauma situation
                                                                                may not reflect typical BP).
Measure_Date                 Num 4      SAS Date                                Date the variables are measured                                                                    Y
HT                           Num 8      Height in inches                        Height on measurement date                                                                         Y
WT                           Num 8      Weight in pounds                        Weight on measurement date                                                                         Y
BMI       Num 8                                        This will be the numeric BMI straight out of the system, not calculated.                         Y, with
                                                                                                                                                         edits
                                                       If KPNC has a median estimate for the pre-clarity timeframe, that estimate should be               for
                                                       placed into this field and set BMI_EST=1 so that it is clear that this is not an actual value.   KPNC

                                                       Sites can include BMI, directly from EMR at their option. BMI as a variable derived
                                                       (calculated) from height and weight should be calculated using algorithms provided by the
                                                       Vitals work group.

                                                       NOTE: The VDW calls this variable BMI_RAW, however since we will be allowing the
                                                       estimates into this field we will simply call it BMI for CVRN.

                  Body mass index (kg/m 2), optional
BMI_RAW   Num 8   See comments                         The value used for BMI_KPNC_Estimate in the prior CVRN Version. Since Health                       Y
                                                       Connect (HC) began “roll out” at KPNC only several years ago, is the OSCR BMI (from BMI
                                                       variable above). Pre-KPNC HC, KPNC captured BMI in categories on forms filled out by
                                                       health providers, see categories below. Medians were calculated for all categories shown
                                                       below; medians were calculated from all existing KPNC HC BMI values that were in
                                                       existence through the end of 2007. The BMI from HC was always taken instead of
                                                       categorical data if both were available for the same visit.

                                                       Here are the ranges providers used pre-KPNC HC for the BMIs:
                                                       <19.0
                                                       19.0-24.9
                                                       25.0-25.9
                                                       26.0-26.9
                                                       27.0-27.9
                                                       28.0-28.9
                                                       29.0-29.9
                                                       30.0-30.9
                                                       31.0-31.9
                                                       32.0-32.9
                                                       33.0-33.9
                                                       34.0-34.9
                                                       35.0-35.9
                                                       36.0-36.9
                                                       37.0-37.9
                                                       38.0-38.9
                                                       39.0-39.9
                                                       >=40
Diastolic       Num 4   Diastolic blood pressure   MmHg                                                                                        Y, with
                                                   For KPNC, this may be missing if there is only a Systolic_KPNC_Estimate value. In this       edits
                                                   case, place the Systolic_KPNC_Estimate value into this field and set BP_EST=1 to              for
                                                   indicate that this is a BP Estimate only.                                                   KPNC

Diastolic_RAW   Num 8   See comments               Separate record for diastolic with systolic blank, <2007                                      N
                                                   MmHg

                                                   The value used for Diastolic_KPNC_Estimate in the prior CVRN version, since Health
                                                   Connect (HC) began “roll out” at KPNC only several years ago, is based on the categorical
                                                   values from OSCR forms. Pre-KPNC HC, KPNC captured diastolic BP in categories on
                                                   forms filled out by health providers, see diastolic BP categories below. Medians were
                                                   calculated separately for each of the categories shown below; these medians were
                                                   calculated from all existing KPNC HC BP values that were in existence through the end of
                                                   2007 and used in place of the OSCR categorical values. KPHealth Connect data were
                                                   backfed into OSCR and converted to median value for each category.

                                                   Here are the ranges providers used pre-KPNC HC for the diastolic BPs:

                                                   =<80
                                                   81-84
                                                   85-89
                                                   90-99
                                                   100-109
                                                   =>110



Systolic        Num 4   Systolic blood pressure    MmHg                                                                                        Y, with
                                                   For KPNC, this may be missing if there is only a Systolic_KPNC_Estimate value. In this       edits
                                                   case, place the Systolic_KPNC_Estimate value into this field and set BP_EST=1 to              for
                                                   indicate that this is a BP Estimate only.                                                   KPNC
Systolic_RAW   Num 8    See comments                             Separate record for systolic with diastolic blank, <2007                                     Y
                                                                 MmHg

                                                                 The value used for Systolic_KPNC_Estimate in the prior CVRN version. Since Health
                                                                 Connect (HC) began “roll out” at KPNC several years ago, , is based on the categorical
                                                                 values from OSCR forms. Pre-KPNC HC, KPNC captured systolic BP in categories on
                                                                 forms filled out by health providers, see systolic BP categories below. Medians were
                                                                 calculated separately for each of the categories shown below; these medians were
                                                                 calculated from all existing KPNC HC BP values that were in existence through the end of
                                                                 2007 and used in place of the OSCR categorical values. KPHealth Connect data were
                                                                 backfed into OSCR and converted to median value for each category.

                                                                 Here are the ranges providers used pre-KPNC HC for the systolic BPs:
                                                                 <=120
                                                                 121-129
                                                                 130-139
                                                                 140-159
                                                                 160-179
                                                                 >=180




BP_TYPE                 R=Rooming                                Optional, may be null. Type of blood pressure taken. Please refer to                         Y
                        O=Orthostatic                            https://appliedresearch.cancer.gov/crnportal/data-resources/vdw/datasets/v3-vital-signs-
                        M=Multiple                               data-dictinary for information on identifying these.
                        E=Extended




BP_EST                  0=actual value from Health Connect       A boolean flag to indicate that the value in the BP field is not directly from Clarity and   N
                        1=estimated median value from KPNC pre   instead from a estimate (systolic_KPNC_estimate). Will always be 0 or null (where systolic
                        Clarity                                  and diastolic are missing) for KPCO and HPRF.
BMI_EST        Num 4    0=actual value from Health Connect       Weight on measurement date                                                                   N
                        1=estimated median value from KPNC pre
                        Clarity
Position       Char 1   ‘ ‘=missing                              Position for blood pressure reading                                                          Y
                        ‘1’=sitting
                        ‘2’=standing
                        ‘3’=supine
Pulse Rate     Num 4                                             PULSE_RAW from VDW                                                                           Y
PROVIDER_ID    Char (varies by Identifier unique to a single provider       Provider Responsible for the visit where this measurement was taken. This is a masked       N
                   site)       See Definition in Provider Table.            provider ID, not directly from site source data.

Department         Char 4                                                  Department in which the vitals were measured.
                               See table for encounters for department values                                                                                           N
Measure_time       Num 4       SAS Time value                              Time at which vitals were taken – typically will be the check in time from the visit.        N
Tobacco            Num 4       1 = current user                            Include tobacco status as of the visit date. Unknown values should be left blank. The not    Y
                               2 = never                                   asked value should be used only when it is a valid response from your system (e.g. this is
                               3 = quit/former user                        a valid value for EPIC). The conflicting value should be used when you receive tobacco
                               4 = passive                                 information from multiple sources that disagree.
                               5 = environmental exposure
                               6 = not asked
                               7 = conflicting
Tobacco_type       Num 4       1 = Cigarettes only                          Indicate whether the tobacco use was something other than cigarettes. Unknown values        Y
                               2 = Other tobacco only                       should be left blank.
                               3 = Cigarettes and other tobacco
                               4 = None
e VDW, but other variables will be added.



              KPCO                          KPNC        HP
              Completed                     Completed   Completed
              Completed                     Completed   Completed - will
                                                        reassing when VDW
                                                        team does this
                                                        linkage




              Completed                     Completed   Completed




              Completed                     Completed   Completed




              Completed                     Completed   Completed
              Completed                     Completed   Completed
              Completed                     Completed   Completed
Complete                                 Completed   Completed
KPCO did not have BMI historically,
so BMI has been calculated for history
prior to 2005 where HT and WT are on the
same record, as if it were in the EMR,
using the Vitals Workgroup algorithm.




N/A                                    Completed     N/A
Completed   Completed




N/A         Completed   N/A




Completed   Completed   Completed
N/A                                          Completed           N/A




Completed. All final charted BPs are         VDW partially filled; Completed
tagged with 'R', and there are many          only several
Multiples/repeat readings in the data. For   thousand with
most studies will want to use                R=rooming have
BP_TYPE='R', however to accommodate          been identified. If not
other sites may need to use BP_TYPE in       'M' or 'O' then
('R' ' '); to capture null values also.      assume that it is a
                                             rooming BP.

Completed                                    Completed           Completed



Completed                                    Completed           Completed



complete - Only for Orthostatic              Completed           Completed
measurements



Completed                                    Completed           Completed
Completed   Completed   Completed



Completed   Completed   Completed
Completed   Completed   Completed
Completed   Completed   Completed




Completed   Completed   Completed
          Table Name:       Encounters
              Status: Finalized
          Description: Basically a straight pull from the VDW, with Study id attached in place of MRN as well as masked provider and clinic IDS

NOTE: Facility claims often indicate an acute inpatient stay or a long term stay at an institutional facility.
      For any facility claim or encounter that has an Enctype of IS or IP, look for any other non-Emergency encounters or claims
      that fall within that over lapping time period and give them the same encounter id. (i.e. if encounter is of type ED, keep that as a separate encounter).
      Keep all diagnosis/procedure detail from the original claims/encounters.

    Variable Name             Type                             Values                                         Comments                          VDW               KPCO
STUDY_ID                   Num 8          Patient Identifier                                                                                     N Completed
                                          See Definition in Superset table
ENC_ID                     Num 8          Site specific unique encounter id as pulled from A number of any length to identify an unique          Y    Completed
                                          the VDW                                          encounter. Used as a key variable to link
                                                                                           diagnoses, procedures, and vitals to a given
                                                                                           encounter.

                                                                                           The encounter id can be any number of digits, but
                                                                                           the first three digits must follow the conventions
                                                                                           laid out for the study_id to avoid any duplicates
                                                                                           across sites.

ADATE                      Num, 8                                                          Encounter or admission date.                          Y    Completed
DDATE                      Num, 8                                                          Discharge date. This field will be blank for          Y    Completed
                                                                                           outpatient encounters and for
                                                                                           professional/HCFA/CMS-1600 claims.
PROVIDER_ID                 Char (varies Identifier unique to a single provider            Provider Responsible for the visit. This is a         Y    Completed
                             by site)    See Definition in Provider Table.                 masked provider ID, not directly from site source
                                                                                           data.
ENCTYPE                    Char 2         IP = Acute inpatient hospital stay (includes                                                           Y    Completed
                                          same-day hospital discharges, hospital
                                          transfers, observation bed, and acute hospital
                                          care where discharge is after admission).
                                          Encounter_SubType = AI .
                                          ED = Emergency department encounter
                                          (including those that become inpatient stays).
                                          Excludes urgent care visits.
                                          Encounter_SubType = HA, OC.
                           AV = Ambulatory visit (outpatient clinics, same
                           day surgery, urgent care, and other same-day
                           ambulatory hospital encounters. Excludes ED
                           and obs. Encounter_SubType = OB, OC, SD,
                           HA, UC, RH, DI, HA.


                           TE = Telephone encounter.
                           Encounter_subtype = OT, HH.
                           EM = E-mail encounter. Encounter_SubType
                           = OT, HH.
                           IS = Non-acute institutional stay (hospice,
                           SNF, rehab, nursing home, residential, rehab,
                           overnight non-hospital dialysis, other non-
                           hospital stay). Encounter_SubType = HS, SN,
                           NH, RH, DI, OT.


                           OE = Other encounter (not overnight),
                           including hospice visit, home health visit, SNF
                           visit, other non-hospital visit.
                           Encounter_SubType = HS, HH, SN, RH, DI,
                           OT.
                           LO = Lab only encounter (cannot be matched
                           to another encounter). Include to link variables
                           from utilization file to procedure file.
                           Encounter_SubType = LO.
                           RO = Radiology only encounter (cannot be
                           matched to another encounter). Include to link
                           variables from utilization file to procedure file.
                           Encounter_SubType = RO.
ENCOUNTER_SUBTYPE Char 2   AI = Acute inpatient stay (excludes observation      Y   Completed
                           bed). EncType = IP.
                           OB = Observation bed. EncType = AV.
                           OC = Outpatient clinic visit. EncType = AV.
                           SD = Same day surgery. EncType = AV.
                           UC = Urgent care. EncType = AV.
                           HA = Hospital ambulatory (outpatient care at a
                           hospital, excluding same day surgery and obs).
                           EncType = AV, ED.
                           HS = Hospice. EncType = IS, OE.
                           HH = Home health. EncType = OE, TE.
                           SN = SNF. EncType = IS, OE.
                                       NH = Nursing home (including ICF). EncType
                                       = IS.
                                       RH = Rehab. EncType = IS, AV.
                                       DI = Dialysis. EncType = IS< AV.
                                       OT = Other non-hospital. EncType = IS, OE,
                                       TE, EM, AV, LO, RO.
FACILITY_ID             Char (varies                                                Ciinic Identifier                                   Y   Completed
                         by site)                                                   Please see Clinic Table for definition. This is a
                                                                                    masked Facility ID, not directly from site source
                                                                                    data.
Discharge_Disposition   Char 1         A = Discharged alive                         Discharge status. Use for hospital and overnight    Y   Completed
                                       E = Expired                                  encounters.
                                       U = Unknown
Discharge_Status        Char, 2        AF = Adult foster home                       Hospital discharge status. Optional.                Y   Completed
                                       AL = Assisted living facility
                                       AM = Against medical advice
                                       AW = Absent without leave
                                       EX = Expired
                                       HH = Home health
                                       HS = Hospice
                                       HO = Home/self care
                                       IP = Other acute inpatient hospital
                                       NH = Nursing home (including ICF)
                                       OT = Other
                                       RS = residential facility
                                       RH = Rehab facility
                                       SH = Still in hospital
                                       SN = SNF
DRG_VALUE               Char 3                                                      Diagnostic Related Group. Optional .                Y   Completed

                                                                                    Use for hospital encounters. Use leading 0s for
                                                                                    codes < 100.
DRG_VERSION                  A=DRG values using the old coding system   Identifies the version of the Diagnostic Related      Y   Completed
                             B=DRG values using the current coding      Group. Used for hospital encounters. The DRG
                             system                                     coding system officially changed 10/1/2007, but
                                                                        the variable should indicate the code version used,
                                                                        regardless of the actual date of conversion at the
                                                                        individual site which may be different from
                                                                        10/1/2007.Must use with DRG_Value.


Admitting_Source   Char, 2   AV = Ambulatory visit                      Admitting source. Optional . Use for hospital and     Y   Completed
                             ED = Emergency department                  overnight encounters.
                             AF = Adult foster home
                             AL = Assisted living facility
                             HH = Home health
                             HS = Hospice
                             HO = Home/self care
                             IP = Other acute inpatient hospital
                             NH = Nursing home (including ICF)
                             OT = Other
                             RS = Residential facility
                             RH = Rehab facility
                             SN = SNF
                             UN = Unknown
Department         Char, 4   Please see Department Lookup Tab           Department code of specialty providing service.       Y   Completed
                             for valid values                           More granularity than in the VDW. Please use
                                                                        this coding standard if you have this
                                                                        granularity in your departments.
    KPNC            HP
Complete    Completed

Completed   Completed




Completed   Completed
Completed   Completed



Completed   Completed



Completed   Completed
Completed   Completed
Completed   Completed




Completed   Completed



Completed   Completed




Completed   Completed
Completed       Completed




Completed       Completed




Modifications   Completed
needed
   Table Name:   Diagnoses
       Status: Finalized
   Description: Basically a straight pull from the VDW - with CVRN study_id attached in place of MRN
                Multiple diagnoses per encounter, only one primary/principal diagnosis per encounter

Variable Name    Type      Values                                 Comments                                     VDW    KPCO          KPNC       HP
STUDY_ID         Num 8     Patient Identifier                                                                  N   Completed    Completed   Completed
                           See Definition in Superset table
ENC_ID           Num 8                                            Encounter/Visit Identifier. Please see       Y    Completed   Completed   Completed
                                                                  definition in Encounters Table
ADATE            Num 4                                            Encounter or admit date.                     Y    Completed   Completed   Completed
DX               Char 6                                           ICD-9 diagnosis code. Contains decimal       Y    Completed   Completed   Completed
                                                                  point.
DX_CODETYPE                09=’ICD-9-CM’                                                                       Y    Completed   Completed   in progress
                           10=’ICD-10-CM’
                           11=’ICD-11-CM’
                           OT=’Other’
ORIGDX           Char 10                                          Actual value from source data. OSCR         Y     Completed   Completed   Completed
                                                                  codes will go here.
PDX              Char 1    P = Principal                          P = The prinicipal diagnosis for hospital   Y     Completed   Completed   Completed
                           S = Secondary                          encounters or the primary diagnosis for any
                           X = Not available                      other encounter. Should have only 1 per
                                                                  encounter. For claims data, use the last
                                                                  facility bill for an encounter.
PROVIDER_ID         Char Identifier unique to a single provider   Provider Responsible for the visit. This is a Y   Completed   Completed   Completed
                 (varies by See Definition in Provider Table.     masked Provider ID.
                    site)

DIAGPROVIDER_I      Char Identifier unique to a single provider   This will be the provider that actually made Y    Completed   Completed   Completed
D                (varies by See Definition in Provider Table.     the diagnosis, matching any distinct claims
                    site)                                         or encounter information prior to merging.
                                                                  This is a masked Provider ID.

ENCTYPE          Char 2    IP, ED, AV, TE, EM, IS, OE, LO, RO     Please see encounter table for value         Y    Completed   Completed   Completed
                                                                  descriptions.
    Table Name:   Procedures
        Status: Finalized
    Description: Basically a straight pull from the VDW, with CVRN Study id attached


Variable Name     Type       Values                                       Comments                                VDW         KPCO            KPNC

STUDY_ID          Num 8      Patient Identifier                                                                   N     Completed    Completed
                             See Definition in Superset table
ENC_ID            Num 8      Encounter Identifier                         Encounter/Visit Identifier. Please      N     Completed    Completed
                             Please see Encounter table for definition.   see definition in Encounters Table

ADATE             Num 4                                                   Encounter or admit date.                Y     Completed    Completed
PX                Char 6                                                  ICD-9 diagnosis code. Contains          Y     Completed    Completed
                                                                          decimal point.
                                                                          CPT Modifier Code 1 as found in the           Completed    VDW blank, currently
CPTMOD1           Char (2)                                                source data
                                                                          CPT Modifier Code 2 as found in the           Completed    VDW blank, currently
CPTMOD2           Char (2)                                                source data
                                                                          CPT Modifier Code 3 as found in the           Completed    VDW blank, currently
CPTMOD3           Char (2)                                                source data
ORIGPX            Char 10                                                 Actual value from source data. Store    Y     Completed    Completed
                                                                          Oscar codes here!
CODETYPE          Char 1     I = ICD-9                                    Flag to indicate type of procedure      Y     Completed    Completed
                             C = CPT-4                                    code (includes Radiology). Added
                             H = HCPCS                                    OSCR codes to list from VDW.
                             R = Revenue code                             However if there is a valid PX code
                             L = Local homegrown                          in the PX field please use one of the
                             O = Oscar                                    other values.


PXCNT             Char 1                                                  Number of times the procedure was N           Completed    Completed
                                                                          performed during the encounter.
                                                                          The usual value is 1, unless the
                                                                          procedure was performed multiple
                                                                          times during the encounter. This
                                                                          count should be over all uniquely
                                                                          identifying variables, including but
                                                                          not limited to performing provider,
                                                                          cpt_mod1-3, and px date.
PROVIDER_ID              Char    Identifier unique to a single provider   Provider Responsible for the visit.    Y    Completed   Completed
                      (varies by See Definition in Provider Table.        This is a masked Provider ID
                         site)
PeformingProvider_I              Identifier unique to a single provider   This will be the provider that actually Y   Completed   Completed
D                                See Definition in Provider Table.        performed the procedure, matching
                                                                          any distinct claims or encounter
                                                                          information prior to merging. This is
                                                                          a masked provider ID.


ENCTYPE               Char 2     IP, ED, AV, TE, EM, IS, OE, LO, RO       Please see encounter table for value Y      Completed   Completed
                                                                          descriptions.
         HP

Completed

Completed



Completed
Completed

in progress

in progress

in progress

Completed

Completed




Completed
Completed



Completed




Completed
   Table Name: Labs
        Status: Finalized
   Description: Lab Table - One record per resulted lab.
                Basically a straight pull from the VDW, with CVRN Study id and site id attached

           Details
  Variable Name        Type                     Values                                  Comments                             VDW      KPCO             KPNC
Study_id             Num 8      Patient Identifier                                                                       Y         completed   completed
                                See Definition in Superset table
TEST_TYPE            Char, 10   CREATININE                         Serum Creatinine                                      Y         completed   completed
                                GLU_F                              Fasting Glucose (Blood Sugar)                                   completed   completed
                                HGBA1C                             Hemoglobin A1C                                                  completed   completed
                                K                                  Serum Potassium                                                 completed   completed
                                HCT                                                                                                completed   completed

                                HDL                                                                                                completed   completed
                                TOT_CHOLES                                                                                         completed   completed
                                LDL_DIRECT                         LDL direct- Low Density Lipoprotein                             completed   completed
                                LDL_CLC_F                          LDL calculated, fasting                                         completed   Not available from
                                                                                                                                               VDW lab table
                                LDL_CLC_NS                         LDL calculated, not specified                                   completed   completed
                                TRIGL_F                            Triglycerides, fasting                                          completed   Not available from
                                                                                                                                               VDW lab table
                                TRIGL_NS                           Triglycerides, nonspecified                                     completed   completed
                                GFR_MDRD_CALC                      Estimated Glomerular Filtration Rate                            completed   Not available from
                                                                   The GFR_MDRD will be calculated at each site                                VDW lab table
                                                                   using the MDRD equation as defined in the
                                                                   superset documentation.
                                                                   The GFR_MDRD will be placed onto its own record,
                                                                   retaining some of the fields contained in the serum
                                                                   creatinine record from which it is calculated.


                                GFR_MDRD                           Estimated Glomerular Filtration Rate as reported in             completed   Not available from
                                                                   the emr.                                                                    VDW lab table
                                UR_PROTEIN-Urine Protein                                                                           completed   Not available from
                                                                                                                                               VDW lab table
                                MIC_ALBUM-Microalbumin             -the Microalbumin we need is mass concentration,                completed   Not available from
                                                                   not the ratio to creatinine,                                                VDW lab table
LOINC        Char, 10   Codes in the form of nnnnn-n    Logical Observation Identifiers Names and Codes,    Y   completed   Partially available from
                                                        from http://www.regenstrief.org/loinc/ Although a                   VDW lab table
                                                        length of 7 would work as of 11/07/07 LOINC
                                                        suggests 10 for future growth.

                                                        This will be null for test_type= GFR_MDRD.

                                                        May not be available for all sites across all
                                                        timeframes.



LOCAL_CD     Char       Unique to each HMO - optional   Non LOINC code related to lab test result**         Y   completed   completed

                                                        Null for test_type=GFR_MDRD.

BATTERY_CD   Char       Unique to each HMO - optional   Battery code                                        Y   completed   completed

                                                        Null for test_type= GFR_MDRD.
PX           Char, 6                                    Related procedure code (most likely CPT)            Y   completed   completed

                                                        Null for test_type= GFR_MDRD.

                                                        Note: PX does not always match standard CPT
                                                        codes since home-grown CPT codes are used for
                                                        some battery testing. Not a reliable way to pull
                                                        tests..use TEST_TYPE instead


Codetype     Char, 1    C=CPT,                          Specifies what type of code PX is                   Y   completed   completed
                        I=ICD9,
                                                        Null for test_type= GFR_MDRD.
                        H=HCPCS,
                        L=local home-grown,
                        O=other
Order_dt     Num 4      SAS Date                        Date test was ordered.                              Y   completed   Not available from
                                                                                                                            VDW lab table
                                                        Test_type= GFR_MDRD will retain this value from
                                                        the corresponding serum creatinine record.
Lab_dt            Num 4     SAS Date                                  Date specimen was collected                         Y   completed   completed

                                                                      Test_type= GFR_MDRD will retain this value from
                                                                      the corresponding serum creatinine record.


Lab_tm            Num, 4    SAS Time                                  Time specimen was collected                         Y   completed   completed

                                                                      Test_type= GFR_MDRD will retain this value from
                                                                      the corresponding serum creatinine record.


Result_dt         Num, 4    SAS Date                                  Date of test result                                 Y   completed   Not available from
                                                                                                                                          VDW lab table
                                                                      Test_type= GFR_MDRD will retain this value from
                                                                      the corresponding serum creatinine record.


Result_tm         Num, 4    SAS Time                                  Time of test result                                 Y   completed   Not available from
                                                                                                                                          VDW lab table
                                                                      Test_type= GFR_MDRD will retain this value from
                                                                      the corresponding serum creatinine record.


Result_C          Char(8)   original value in data                    To accept digits, decimal, sign or text (e.g.           completed   completed
                            Non-null, non-default result values       POSITIVE, NEGATIVE, DETECTED) result
                                                                      values.The symbols >, <, >=, <= should be
                                                                      removed.If the input data contains a comment in
                            ‘Default result values’ means those       the same field as the result value then Result_C
                            values used in place of a null, such as   should contain only the result value and the
                            ‘9999999’.                                comment should be stored in the LAB NOTES
                                                                      table.

                                                                      For numeric values INPUT function can be used
                                                                      when programming to convert character to numeric.



Result_modifier   Char 2    ‘TX’= Text                                Value is determined by considering the existence of N   completed   completed
                            ‘EQ’= Equal                               or lack of the symbols >, <, >=, <= or the existence
                            'LT' = Less Than                          of text.
                            ‘LE’= Less than or equal to
                            ‘GT’= Greater than
                            ‘GE’=greater than or equal to
Result_unit     Char, 11   possible values include %, IU/L, MEQ/L, Units in which result is reported. Future recoding    Y    completed   completed
                           MG/DL, THERAPEUTIC                      will probably be necessary to standardize among
                                                                   sites.

                                                                    May not be available at all sites across entire
                                                                    timeframe.
Normal_low_C    Char, 8    to accept >, <, >=, <=                   Lowest value of normal range for this                 Y   completed   completed
                                                                    test/instrumentation/etc as short character. For true
                                                                    numeric values INPUT function can be used when
                                                                    programming to convert character to numeric.

                                                                    - null for test_type= GFR_MDRD.

                                                                     - May not be available at all sites across entire
                                                                    timeframe.


Modifier_low    Char 2     ‘TX’= Text                               Value is determined by considering the existence of N     completed   completed
                           ‘EQ’= Equal                              or lack of the symbols >, <, >=, <= or the existence
                           'LT' = Less Than                         of text. Modifies the Normal_low_c value.
                           ‘LE’= Less than or equal to
                           ‘GT’= Greater than
                           ‘GE’=greater than or equal to

Normal_high_C   Char, 8    to accept >, <, >=, <=                   Highest value of normal range for this                Y   completed   completed
                                                                    test/instrumentation/etc as short character. For true
                                                                    numeric values INPUT function can be used when
                                                                    programming to convert character to numeric.

                                                                    - null for test_type= GFR_MDRD.

                                                                     - May not be available at all sites across entire
                                                                    timeframe.


Modifier_hi     Char 2     ‘TX’= Text                               Value is determined by considering the existence of N     completed   completed
                           ‘EQ’= Equal                              or lack of the symbols >, <, >=, <= or the existence
                           'LT' = Less Than                         of text. Modifies the Normal_high_c value.
                           ‘LE’= Less than or equal to
                           ‘GT’= Greater than
                           ‘GE’=greater than or equal to
Abn_ind           Char, 1      A=abnormal; H=abnormal high                 Abnormal result indicator                                Y         completed       completed
                               L=abnormal low U=unknown N=normal
                                                                           - null for test_type= GFR_MDRD.

                                                                            - May not be available at all sites across entire
                                                                           timeframe.
ORDER_PROV_ID Num 8            Should match to a provider in the           Ordering provider. This is a Masked Provider Value Y               completed       completed
                               Providers table
                                                                           Test_type= GFR_MDRD will retain this value from
                                                                           the corresponding serum creatinine record.
Order_dept        Char 4       Same coding scheme as department in Department of ordering provider                                  Y         completed       Not available from
                               the encounters table.                                                                                                          VDW lab table
                                                                   Test_type= GFR_MDRD will retain this value from
                                                                   the corresponding serum creatinine record.


Facility_code     Char         See Clinic Table for definition.            Where order originated                                   Y         completed       completed
                  (varies)
                                                                           Test_type= GFR_MDRD will retain this value from
                                                                           the corresponding serum creatinine record.


RowID             type and     Facility-specific identifier that links a Missing value or a pointer                                           completed       completed
                  length are   LAB RESULTS record to corresponding
                  site         LAB NOTES record(s).                      Most records in LAB RESULTS will have a missing
                  specific                                               ROWID since most records do not need to link to
                                                                         the LAB NOTES table. Any record in LAB
                                                                         RESULTS that has a value other than missing will
                                                                         have a unique value. That is, any ROWID value
                                                                         other than missing will appear only once in the LAB
                                                                         RESULTS data set.




 Lab Notes Table
  Variable Name      Type                        Values                                         Comments                                VDW       KPCO                 KPNC
                                                                           A pointer - It is possible for more than one record in       V3    will be pulled if
                  type and                                                 LAB NOTES to link back to the same record in LAB                   necessary for
                  length are   Facility-specific identifier that links a   RESULTS. Therefore it is possible for multiple                     given lab -
                  site         LAB NOTES record to the                     records in LAB NOTES to have the same RowID                        available in
RowID             specific     corresponding LAB RESULTS record.           value.                                                             VDW               Under construction
                                                                                                                                     V3        will be pulled if
                                                                                                                                               necessary for
                                  To accept text string results, comments                                                                      given lab -
                                  or normal low or high range values that This field could contain:result, lowest value of                     available in
Result_Note          Char(80)     are longer than 8 bytes                 normal range, highest value of normal range, notes                   VDW               Under construction
                                  ‘R’ = result                                                                                       V3        will be pulled if
                                  ‘L’ = low normal value                                                                                       necessary for
                                  ‘H’ = high normal value                                                                                      given lab -
                                  ‘N’ = note(other type values can be     Describes what information is held in the                            available in
Type                 Char(1)      added as need arises)                   Result_Note field.                                                   VDW               Under construction
                                                                                                                                     V3
                                                                          As many rows as necessary can be associated with
                                                                          a RowID/Type combination. For example, a RowID                       will be pulled if
                                                                          might have 5 records of Notes associated with it.                    necessary for
                                  Integer counter starting at 1 and       The Type value would = N and the line value would                    given lab -
                                  incrementing by 1 as needed for each    be 1 for the first note, 2 for the second note and so                available in
Line                 Num(4)       RowID by Type.                          on through 5.                                                        VDW               Under construction


3. Notes:

Note 1: Charts illustrating a) the RowID link between LAB RESULTS and LAB NOTES and b) the relationship between the variables Type and
Line.

Selected variables and observations from LAB RESULTS table where ROWID not equal missing.

                                                                                                                                  Result_uni
obs                  RowID        Test_Type                               Result_C                                                t
              3596             471 K                                                                                          4 MEQ/L
              3709             472 K                                                                                        5.9 MEQ/L
              4843             473 K                                                                                        3.6 MEQ/L
              6045             474 K                                                                                        3.4 MEQ/L
              6786             475 K                                                                                        5.4 MEQ/L


Selected observations from LAB NOTES table where ROWID corresponds to observations above.

obs                  RowID         Result_Note                            Type                                                    Line
                                   SPECIMEN SLIGHTLY HEMOLYZED,
              512              471 MAY FALSELY INCREASE K                 N                                                                1
                           SPECIMEN MODERATELY
                           HEMOLYZED, MODERATE
                           HEMOLYSIS WILL FALSELY
             513       472 INCREASE SERUM                   N                                                  1
             514       472 POTASSIUM                        N                                                  2
             515       473 HEMOLYSIS, MAY INCREASE K.       N                                                  1
                           SPECIMEN SLIGHTLY HEMOLYZED,
             516       474 MAY FALSELY INCREASE K           N                                                  1
                           MOD HEMOLYSIS, FALSE
             517       475 INCREASES IN K.                  N                                                  1


Note 2: Changes that “break the structure” are defined as those changes that are not backwards compatible, that is, old programs will no longer
work with the new data structure.
         HPRF
completed

completed
completed
completed
completed
completed

completed
completed
completed
completed

completed
completed

completed
in progress




completed

in progress

completed
completed




completed



completed



completed




completed
completed
completed
completed
completed
completed
completed




completed




completed




completed




completed




completed
completed




completed




completed




completed




completed
completed




completed




completed




completed




completed




         HPRF




will be pulled if
necessary for given lab
will be pulled if
necessary for given lab




will be pulled if
necessary for given lab




will be pulled if
necessary for given lab
 Table Name:    Pharmacy
      Status: Finalized
 Description: Contains a distinct record for each NDC dispensed on a given day. If multiple fills are picked up on a given day for the same NDC,
                the rx amt and rx supply should be totalled up over the multiple fills.
                Basically a straight pull from the VDW, with CVRN Study id and site id attached

Variable name   Type                        Values              Comments                                          VDW   KPCO                   KPNC     HPRF
STUDY_ID        Num 8        Patient Identifier                                                                    N Completed     Completed          Completed
                             See Definition in Superset table
RXDATE          Num 4        SAS Date                           Date of dispensing                                 Y   Completed   Completed          Completed
NDC             Char 11      National Drug Code                 “-“ has been expunged                              Y   Completed   Completed          Completed
RXSUP           Num 4                                           Number of days supply                              Y   Completed   Completed          Completed
                                                                Number of units (pills, tablets) dispensed. Net        Completed   Completed          Completed
RXAMT           Num 4                                           amount per day per NDC.                            Y
                                                                Should match to a provider in the Providers            Completed   Completed          Completed
RXMD_ID         Num 8        Prescribing MD                     table. This is a Masked Provider ID value.         Y
      Table Name:   EVERNDC_Plus
           Status: Finalized
      Description: A lookup table by NDC code to obtain GPI codes, drug names, cardiac drug classes, etc.
                   This table contains a record for ALL NDCs pulled for the registry (not just cardiac medications).
                   Special flags will be created for the cardiac medications for easy classification and identification.
                   (Preliminary list of classifications: ACE, ARB, Aldosterone antagonist, BB-probably also want subcategories, i
                   based BB; selective vs. nonselective BB, Hydralazine, Long-acting nitrates, Anticoagulants, Others?)
                    NOTE: The anti-hypertensive drug class flags do not include injectible solutions

                    Type
Variable Name       Length                 Values           Comments
                                                            National Drug Code
NDC                 Char 11                                 , "-" has been expunged
Generic             Char 105                                Generic Name
Brand               Char 100                                Brand Name
                                                            Generic Product Index
GPI                 Char 14                                 extremely useful in determining HTN medications
                                                            American Hospital Formulary Service
                                                            Cross-site comparisons show that this is dependent on the
                                                            local pharmacy systems. Some sites may classify the drugs
AHFS                Char 6                                  at a lower level than others.
                                                            Flagged if any of the flags below are created. This is for
                                 Y=Yes                      quick and easy identification of all antihypertensive
HTN_MED             Char1        N=No                       medications.
                                 Y=Yes                      Flagged if drug is classified as an Angiotensin-Converting
ACE                 Char 1       N=No                       Enzyme Inhibitor (ACE)
                                 Y=Yes                      Flagged if drug is classified as an Angiotensin II Receptor
ARB                 Char 1       N=No
                                 Y=Yes                      Antagonist (ARB)
ADR_BLK             Char 1       N=No                       Flagged if drug is classified as an adrenergic blocker
                                 Y=Yes                      Flagged if drug is classified as an Alpha 1 adrenergic
A1_ADR_BLK          Char 1       N=No                       blocker
                                 Y=Yes                      Flagged if drug is classified as an Alpha 2 adrenergic
A2_ADR_BLK          Char 1       N=No
                                 Y=Yes                      blocker
BETA_BLK            Char 1       N=No                       Flagged if drug is classified as a Beta Blocker
                                 Y=Yes                      Flagged if drug is classified as a Calcium Channel Blocker/
CCB_DHP             Char 1       N=No                       Dihydropyridines
                                 Y=Yes                      Flagged if drug is classified as a Calcium Channel Blocker/
CCB_NONDHP          Char 1       N=No                       non-Dihydropyridines
                                 Y=Yes
DIUR_KSPARE         Char 1       N=No
                                 Y=Yes                      Flagged if drug is classified as a postassium sparing diuretic
DIUR_LOOP           Char 1       N=No
                                 Y=Yes                      Flagged if drug is classified as a loop diuretic
DIUR_THIAZIDE       Char 1       N=No                       Flagged if drug is classified as a thiazide diuretic
                                 Y=Yes                      Flagged if drug is classified as a Carbonic Anhydrase
DIUR_CAI            Char 1       N=No
                                 Y=Yes                      Inhibitor Diuretic
PERIPH_VASO         Char 1       N=No
                                 Y=Yes                      Flagged if drug is classified as a Peripheral Vasodilator
RESERPINE           Char 1       N=No                       Flagged if drug is classified as a reserpine
RENIN_INH
                                                            Flagged if the drug is a combination of any of the above
                                 Y=Yes                      classes. This will be flagged in addition to two of the
COMBO               Char 1       N=No                       specific classes.
                                                            Dosage of medication as packaged. Currently a text field
MED_DOSE            Char 15                                 with units that needs to be parsed.
 diac medications).
 n and identification.
obably also want subcategories, including evidence-based vs. non-evidence-
Anticoagulants, Others?)




             VDW            KPCO              KPNC               HPRF
                     Completed         Completed          Completed
               Y
               Y     Completed         Completed          Completed
               Y     Completed         Completed          Completed
               Y     Completed                            Completed
              Opt.                     N/A
                     Completed         Completed          Completed

               Y
              Opt.
                     Completed         Completed          Completed

                N
                     Completed         Completed          Completed
                N
                     Completed         Completed          Completed
                N
                N    Completed         Completed          Completed
                     Completed         Completed          Completed
                N
                     Completed         Completed          Completed
                N
                N    Completed         Completed          Completed
                     Completed         Completed          Completed
                N
                     Completed         Completed          Completed
                N
                     Completed         Completed          Completed
                N
                N    Completed         Completed          Completed
                N    Completed         Completed          Completed
                     Completed         Completed          Completed
                N
                N    Completed         Completed          Completed
                N    Completed         Completed          Completed
                     Completed         Completed
                     Completed         Completed          Completed

                N
                     Completed         Completed          Completed
                N
 Table Name:
                 Mortality
     Status: Finalized
 Description: 1 record per person
              Basically a straight pull from the VDW, with CVRN Study id and site id attached

 Variable Name      Type               Values                              Comments                            VDW     KPCO             KPNC           HPRF
                   Length
Study_id         Char       Patient Identifier                                                            Y          Completed   Completed           Completed
                            See Definition in Superset
                            table
DeathDt          Num (4)    Sasdate                      Date on which death occurred                     Y          Completed   Completed           Completed
DtImpute         Char (1)   M = Month of date imputed    How DeathDt was imputed                          Y          Completed   Completed           Completed
                            D = Day of date imputed
                            B = Both month and day
                            imputed
                            N = Not imputed
UnderCOD         Char (6)                                ICD code identified as underlying cause of death. Y         Completed   Completed           Completed
                                                         Please include the decimal point in your ICD
                                                         codes

Codetype         Char (1)   A = ICD-10                   Coding type for UnderCOD                         Y          Completed   Completed           Completed
                            B = ICD-9
Source           Char (1)   S = State Death files                                                         Y          Completed   Completed           Completed
                            N = National Death Index                                                                             KPNC added:
                            T = Tumor data                                                                                       F=Social Security
                            E = EMR                                                                                              K=Kaiser
                            C = Claims
Confidence       Char(1)    E = Excellent                How the site rates the accuracy of the           Y          Completed   Completed           Completed
                            F = Fair                     observation based on source, match, # of
                                                         reporting sources, discrepancies, etc.
                            P = Poor
 Table Name: Cause of Death
      Status: Finalized
 Description: All causes of death identified (1:many)
              Basically a straight pull from the VDW, with CVRN Study id attached

           Details
 Variable Name          Type               Values                                 Comments                     VDW     KPCO        KPNC        HPRF
Study_id             Char                                  Unique to each HMO                              Y         Completed   Completed   Completed
                                                           Used to link across files
COD                  Char (6)                              Cause of Death                                  Y         Completed   Completed   Completed
                                                           Please include the decimal point in ICD Codes
CodeType             Char (1)   A = ICD-10                 Identify COD code source                        Y         Completed   Completed   Completed
                                B = ICD-9
CauseType            Char (1)   I = Immediate/Primary                                                      Y         Completed   Completed   Completed
                                U = Underlying
                                C = Contributory
                                O = Other
Source               Char (1)   S = State Death files                                                      Y         Completed   Completed   Completed
                                N = National Death Index
                                T = Tumor data
                                E = EMR
                                C = Claims
      Table Name:   Census
           Status: Finalized
      Description: Basically a straight pull from the VDW, with CVRN Study id attached
                   This table is based on the last known address for an individual at end of study or disenrollment

Variable name       Type                  Values                Comments                                                 VDW      KPCO                 KPNC
Study_ID            Num 8    Patient Identifier                 Used to link across files                                N     Completed   Completed
                             See Definition in Superset table



BLOCK               Char 3                                      BLOCK CODE                                               Y     Completed   Completed
BLOCKGP             Char 1                                      BLOCK GROUP CODE                                         Y     Completed   Completed
COUNTY              Char 3                                      COUNTY CODE                                              Y     Completed   Completed
STATE               Char 2                                      STATE CODE                                               Y     Completed   Completed
TRACT               Char 6                                      TRACT CODE                                               Y     Completed   Completed
ZIP                 Char 5                                      ZIP CODE                                                 Y     Completed   Completed
MAP_FLAG            Char 1   B=BLOCK,G=BLOCK                    LEVEL AT WHICH ADDRESS DATA WERE MAPPED                  Y     Completed   Completed
                             GROUP,T=TRACT,Z=ZIPCODE,
                             U=UNABLE TO BE APPENDED
Match_Strength      Char 1   Code indicating the type of match Part of the match metadata string output by Map Marker+   Y     Completed   Completed
                             achieved by the geocoding
                             software.
                             0 = No coordinates
                             1 = Zip +0 centroid
                             2 = Zip +2 centroid
                             3 = Zip +4 centroid
                             4 = Shape Path Centroid
                             5 = Street address position
                             6 = Point zip centroid
                             X = Street Intersection

EDUCATION1          Num 8                                       %POP AGE 25+: EDUCATION, LESS THAN 9TH GRADE Y                 Completed   Completed

EDUCATION2          Num 8                                       %POP AGE 25+: EDUCATION, 9 TH -12TH GRADE                Y     Completed   Completed
EDUCATION3          Num 8                                       %POP AGE 25+: EDUCATION, HIGH SCHOOL                     Y     Completed   Completed
                                                                GRADUATE
EDUCATION4          Num 8                                       %POP AGE 25+: EDUCATION, SOME COLLEGE, NO                Y     Completed   Completed
                                                                DEGREE
EDUCATION5          Num 8                                       %POP AGE 25+: EDUCATION, ASSOCIATE DEGREE                Y     Completed   Completed
EDUCATION6          Num 8                                       %POP AGE 25+: EDUCATION, BACHELOR DEGREE                 Y     Completed   Completed
EDUCATION7      Num 8   %POP AGE 25+: EDUCATION, GRADUATE OR                 Y   Completed   Completed
                        PROFESSONAL DEGREE
MEDFAMINCOME    Num 8   MEDIAN FAMILY INCOME                                 Y   Completed   Completed
FAMINCOME01     Num 8   %FAMILY INCOME LESS THAN $10,000                     Y   Completed   Completed
FAMINCOME02     Num 8   %FAMILY INCOME $10,000-$14,999                       Y   Completed   Completed
FAMINCOME03     Num 8   %FAMILY INCOME $15,000-$19,999                       Y   Completed   Completed
FAMINCOME04     Num 8   %FAMILY INCOME $20,000-$24,999                       Y   Completed   Completed
FAMINCOME05     Num 8   %FAMILY INCOME $25,000-$29,999                       Y   Completed   Completed
FAMINCOME06     Num 8   %FAMILY INCOME $30,000-$34,999                       Y   Completed   Completed
FAMINCOME07     Num 8   %FAMILY INCOME $35,000-$39,999                       Y   Completed   Completed
FAMINCOME08     Num 8   %FAMILY INCOME $40,000-$44,999                       Y   Completed   Completed
FAMINCOME09     Num 8   %FAMILY INCOME $45,000-$49,999                       Y   Completed   Completed
FAMINCOME10     Num 8   %FAMILY INCOME $50,000-$59,999                       Y   Completed   Completed
FAMINCOME11     Num 8   %FAMILY INCOME $60,000-$74,999                       Y   Completed   Completed
FAMINCOME12     Num 8   %FAMILY INCOME $75,000-$99,999                       Y   Completed   Completed
FAMINCOME13     Num 8   %FAMILY INCOME $100,000-$124,999                     Y   Completed   Completed
FAMINCOME14     Num 8   %FAMILY INCOME $125,000-$149,999                     Y   Completed   Completed
FAMINCOME15     Num 8   %FAMILY INCOME $150,000-$199,999                     Y   Completed   Completed
FAMINCOME16     Num 8   %FAMILY INCOME $200,000+                             Y   Completed   Completed
FamPoverty      Num 8   %Family households with below-poverty level income   Y   Completed   Completed
MEDHOUSINCOME   Num 8   MEDIAN HOUSEHOLD INCOME                              Y   Completed   Completed
HOUSINCOME01    Num 8   %HOUSEHOLD INCOME LESS THAN $10,000                  Y   Completed   Completed
HOUSINCOME02    Num 8   %HOUSEHOLD INCOME $10,000-$14,999                    Y   Completed   Completed
HOUSINCOME03    Num 8   %HOUSEHOLD INCOME $15,000-$19,999                    Y   Completed   Completed
HOUSINCOME04    Num 8   %HOUSEHOLD INCOME $20,000-$24,999                    Y   Completed   Completed
HOUSINCOME05    Num 8   %HOUSEHOLD INCOME $25,000-$29,999                    Y   Completed   Completed
HOUSINCOME06    Num 8   %HOUSEHOLD INCOME $30,000-$34,999                    Y   Completed   Completed
HOUSINCOME07    Num 8   %HOUSEHOLD INCOME $35,000-$39,999                    Y   Completed   Completed
HOUSINCOME08    Num 8   %HOUSEHOLD INCOME $40,000-$44,999                    Y   Completed   Completed
HOUSINCOME09    Num 8   %HOUSEHOLD INCOME $45,000-$49,999                    Y   Completed   Completed
HOUSINCOME10    Num 8   %HOUSEHOLD INCOME $50,000-$59,999                    Y   Completed   Completed
HOUSINCOME11    Num 8   %HOUSEHOLD INCOME $60,000-$74,999                    Y   Completed   Completed
HOUSINCOME12    Num 8   %HOUSEHOLD INCOME $75,000-$99,999                    Y   Completed   Completed
HOUSINCOME13    Num 8   %HOUSEHOLD INCOME $100,000-$124,999                  Y   Completed   Completed
HOUSINCOME14    Num 8   %HOUSEHOLD INCOME $125,000-$149,999                  Y   Completed   Completed
HOUSINCOME15    Num 8   %HOUSEHOLD INCOME $150,000-$199,999                  Y   Completed   Completed
HOUSINCOME16    Num 8   %HOUSEHOLD INCOME $200,000+                          Y   Completed   Completed
HousPoverty     Num 8   %Households with below-poverty level income          Y   Completed   Completed
Pov_LT_50      Num 8   % people whose 1999 income was <50% of poverty level.    Y   Completed   Completed

Pov_50_74      Num 8   % people whose 1999 income was between 50 and 74.99%     Y   Completed   Completed
                       of poverty level
Pov_75_99      Num 8   % people whose 1999 income was between 75 and 99.99%     Y   Completed   Completed
                       of poverty level
Pov_100_124    Num 8   % people whose 1999 income was between 100 and           Y   Completed   Completed
                       124.99% of poverty level
Pov_125_149    Num 8   % people whose 1999 income was between 125 and           Y   Completed   Completed
                       149.99% of poverty level
Pov_150_174    Num 8   % people whose 1999 income was between 150 and           Y   Completed   Completed
                       174.99% of poverty level
Pov_175_184    Num 8   % people whose 1999 income was between 175 and           Y   Completed   Completed
                       184.99% of poverty level
Pov_185_199    Num 8   % people whose 1999 income was between 185 and           Y   Completed   Completed
                       199.99% of poverty level
Pov_GT_200     Num 8   % people whose 1999 income was > 200% of poverty level   Y   Completed   Completed

RA_NHS_WH      Num 8   %WHITE, NON-HISPANIC                                     Y   Completed   Completed
FAMINCOME10    Num 8   %FAMILY INCOME $50,000-$59,999                           Y   Completed   Completed
RA_NHS_BL      Num 8   %BLACK OR AFRICAN AMERICAN, NON-HISPANIC                 Y   Completed   Completed
RA_NHS_AM      Num 8   %AMERCIAN INDIAN ANS ALASKA NATIVE, NON-                 Y   Completed   Completed
                       HISPANIC
RA_NHS_AS      Num 8   %ASIAN, NON-HISPANIC                                     Y   Completed   Completed
RA_NHS_HA      Num 8   %NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER,              Y   Completed   Completed
                       NON-HISPANIC
RA_NHS_OT      Num 8   %OTHER, NON-HISPANIC                                     Y   Completed   Completed
RA_NHS_ML      Num 8   %TWO OR MORE RACES, NON-HISPANIC                         Y   Completed   Completed
RA_HIS_WH      Num 8   %WHITE, HISPANIC                                         Y   Completed   Completed
RA_HIS_BL      Num 8   %BLACK OR AFRICAN AMERICAN, HISPANIC                     Y   Completed   Completed
RA_HIS_AM      Num 8   %AMERCIAN INDIAN ANS ALASKA NATIVE, HISPANIC             Y   Completed   Completed

RA_HIS_AS      Num 8   %ASIAN, HISPANIC                                         Y   Completed   Completed
RA_HIS_HA      Num 8   %NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER,              Y   Completed   Completed
                       HISPANIC
RA_HIS_OT      Num 8   %OTHER, HISPANIC                                         Y   Completed   Completed
RA_HIS_ML      Num 8   %TWO OR MORE RACES, HISPANIC                             Y   Completed   Completed
HOUSES_N       Num 8   Number of housing units in geography                     Y   Completed   Completed
HOUSES_OCCUPIE Num 8   Proportion of HOUSES_N that are occupied.                Y   Completed   Completed
D
HOUSES_OWN       Num 8                              Proportion of occupied housing units that are occupied by    Y   Completed   Completed
                                                    owners.
HOUSES_RENT      Num 8                              Proportion of occupied housing units that are occupied by    Y   Completed   Completed
                                                    renters.
HOUSES_UNOCC_F   Num 8                              Proportion of unoccupied housing units that are for rent.    Y   Completed   Completed
ORRENT
HOUSES_UNOCC_F   Num 8                              Proportion of unoccupied housing units that are for sale     Y   Completed   Completed
ORSALE
HOUSES_UNOCC_R   Num 8                              Proportion of unoccupied housing units that are rented or    Y   Completed   Completed
ENTSOLD                                             sold, but still unoccupied.
HOUSES_UNOCC_S   Num 8                              Proportion of unoccupied housing units that are used         Y   Completed   Completed
EASONAL                                             seasonally or other occasional use.
HOUSES_UNOCC_    Num 8                              Proportion of unoccupied housing units that are used for     Y   Completed   Completed
MIGRANT                                             migrant workers.
HOUSES_UNOCC_    Num 8                              Proportion of unoccupied housing units that are vacant for   Y   Completed   Completed
OTHER                                               other reasons.
RACE_APPD_FLAG   Char 1   B=BLOCK,                  level at which Race data were appended from demographic      Y   Completed   Completed
                          G=BLOCK GROUP,            statistics files
                          T=TRACT,
                          Z=ZIPCODE,
                          U=UNABLE TO BE APPENDED
NONRACE_APPD_F Char 1     B=BLOCK,                  level at which Non-race data were appended from              Y   Completed   Completed
LAG                       G=BLOCK GROUP,            demographic statistics files:
                          T=TRACT,
                          Z=ZIPCODE,
                          U=UNABLE TO BE APPENDED
   HPRF
Completed




Completed
Completed
Completed
Completed
Completed
Completed
Completed



Completed




Completed

Completed
Completed

Completed

Completed
Completed
Completed

Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed
Completed

Completed

Completed

Completed

Completed

Completed

Completed

Completed

Completed

Completed
Completed
Completed
Completed

Completed
Completed

Completed
Completed
Completed
Completed
Completed

Completed
Completed

Completed
Completed
Completed
Completed
Completed

Completed

Completed

Completed

Completed

Completed

Completed

Completed

Completed




Completed
          Table Name:   Clinic
               Status: Finalized
          Description: Contains clinic characteristics based on a survey sent from each site


Variable name           Type            Values   Comments                                                  VDW        KPCO        KPNC          HPRF
Site_id                 Num 4                    See Definition in Superset table                      N         Complete      in progress   in progress
FACILITY_ID             Char (varies)            A unique identifier for a given facility or clinic.   N         Complete      in progress   in progress

FACIL_TYPE                                       HMO_OC        - Owned Outpatient Clinic               N         Complete      in progress   in progress
                                                 HMO_HOSP - Owned Hospital
                                                 HMO_ADMIN - Owned facility that is not
                                                 typically used as a clinic (these show up at
                                                 KPCO)
                                                 EXTERNAL - other facilities/clinics, etc
Vitals_Avail                                     Y- Yes, indicating a site from which we get           N         in progress   in progress   in progress
                                                 vitals (primarily BP is of interest) vitals
                                                 information …more information than we would
                                                 get from claims
                                                 N - No - most information we can get is
                                                 utilization from claimes
Vitals_start                                     First date that vitals became available from this N             in progress   in progress   in progress
                                                 clinic. If internal HMO owned clinic or owned
                                                 Hospital, then can use '01jan2000'd as start
                                                 date
Vitals_end                                       Last date that vitals were available from this        N         in progress   in progress   in progress
                                                 clinic. If no end date, simply use 31dec9999

LabResults_Avail                                 Y- Yes, indicating a site from which we can get N               in progress   in progress   in progress
                                                 actual lab results…more information than we
                                                 would get from claims
                                                 N - No - most information we can get is
                                                 utilization from claims

LabResults_Start                                 First date that Lab results became available      N             in progress   in progress   in progress
                                                 from this clinic. If internal HMO owned clinic or
                                                 owned Hospital, then can use '01jan2000'd as
                                                 start date
LabResults_End                                   Last date that Lab results were available from        N         in progress   in progress   in progress
                                                 this clinic. If no end date, simply use
                                                 31dec9999
<siteabbr>_Facil_Name   Char 100   OPTIONAL - simply to help identify facility   N   in progress   in progress   in progress
                                   when questions arise
     Table Name: Provider
          Status: Final
     Description: Descriptive details on each provider - Based off of VDW Provider Specialty table (V3)
                  With masked Provider IDs

             Details
  Variable Name               Type                          Values                                    Comments                             VDW              KPCO       KPNC
PROVIDER_ID            Character. Unique   Identifier unique to a single provider   Unique provider identifier - width determined as Y           Completed         VDW
                       to each HMO                                                  necessary at each site. This is a masked ID and                                Provider
                                                                                    will not be identical to values coming from the                                Specialty
                                                                                    Virtual Data Warehouse                                                         table under
                                                                                                                                                                   construction
                                                                                                                                                                   not complete

Specialty              Char (3)            Specialty code                           Using specialty coding developed for the           Y         Completed         VDW
                                                                                    IMPACT project. See Specialty tab for values                                   Provider
                                                                                    and translation.                                                               Specialty
                                                                                                                                                                   table under
                                                                                                                                                                   construction
                                                                                                                                                                   not complete

Specialty2             Char (3)            Specialty code                           Optional. If provider has more than 1 specialty.   Y         Completed         VDW
                                                                                    Using specialty coding developed for the                                       Provider
                                                                                    IMPACT project. See Specialty tab for values                                   Specialty
                                                                                    and translation.                                                               table under
                                                                                                                                                                   construction
                                                                                                                                                                   not complete

SpecialtyN             Char (3)            Specialty code                           Optional. If provider has more than 2 specialty.   Y         Complete          VDW
                                                                                    Using specialty coding developed for the                                       Provider
                                                                                    IMPACT project. See Specialty tab for values                                   Specialty
                                                                                    and translation.                                                               table under
                                                                                                                                                                   construction
                                                                                                                                                                   not complete
Provider_Type         Char (3)    Provider Type CodeType of job            See Provider Type Tab for details              Y   Complete                       VDW
                                  performing in the health plan                                                                                              Provider
                                                                                                                                                             Specialty
                                                                                                                                                             table under
                                                                                                                                                             construction
                                                                                                                                                             not complete

Provider_Birth_Year   Numeric 4   Provider Birth Year                                                                     Y   Complete. Most available       VDW
                                                                                                                              for internal KPCO providers.   Provider
                                                                                                                              External provider              Specialty
                                                                                                                              information is largely         table under
                                                                                                                              missing.
                                                                                                                                                             construction
                                                                                                                                                             not complete

Provider_Gender       Char (1)    Provider Gender                          F=Female                                       Y   Complete. Most available       VDW
                                                                           M=Male                                             for internal KPCO providers.   Provider
                                                                           O=Other                                            External provider              Specialty
                                                                           U=Unknown                                          information is largely         table under
                                                                           O=Other                                            missing.
                                                                                                                                                             construction
Provider_Race         Char (2)    Provider Race                            Match Demographic table specs                  Y   "UN" for all providers at      VDW
                                                                                                                              KPCO. Not available            Provider
                                                                                                                                                             Specialty
                                                                                                                                                             table under
                                                                                                                                                             construction
                                                                                                                                                             not complete

Provider_hispanic     Char (2)    A flag signifying whether the provider   Match Demographic table specs                  Y   "UN" for all providers at      VDW
                                  is Hispanic.                                                                                KPCO. Not available            Provider
                                                                                                                                                             Specialty
                                                                                                                                                             table under
                                                                                                                                                             construction
                                                                                                                                                             not complete

Year_Graduated        Numeric 4   Year provider graduated from             When provider received their medical/nursing   Y   Complete. Most available       VDW
                                  medical/nursing/technical school         degree.Missing if unknown                          for internal KPCO providers.   Provider
                                                                                                                              External provider              Specialty
                                                                                                                              information is largely         table under
                                                                                                                              missing.
  HPRF
Completed




Completed




Completed




Complete
Complete




Complete




Complete




Complete




Complete




Complete
       Table Name: Provider Yearly
            Status: Finalized
       Description: Yearly snapshot of HTN patient counts
                    Up to two records per provider per year, unique record defined by Provider_ID, Year, and Prov_Data_Type

              Details
  Variable Name           Type                         Values                              Comments                            VDW     KPCO        KPNC
Provider_ID             Num 8    Provider Identifier                                                                           N     in progress in progress
Year                    Num 4    2000, 2001…N                      Year of summary                                             N     in progress in progress
Prov_Data_Type          Num 4    See comments                      Provider Data Type for the defined year field:              N     in progress in progress
                                                                   1 = Number of HTN patients administratively bonded during
                                                                   calendar year, post superset entry date.

                                                                   2 = Number of HTN patients seen by provider during year,
                                                                   based on utilization, post superset entry date.
Prov_Data_Value         Num 8    See comments                      Value associated with data type                             N     in progress in progress
  HPRF
Completed
Completed
Completed




Completed
      Table Name: Med_Orders
           Status: KPCO and HPRF to work on developing this further - not available for use at this time
      Description: One record per prescription ordered

           Details
   Variable Name       Type                Values                                  Comments                      VDW   KPCO   KPNC
Study_id             Num 8      Patient Identifier                                                                N
Site_id              Num 4      Site Definition
                                See Identifier in Superset                                                        N
ENCOUNTER_ID         Num 8      See Definition in Superset   See Definition in Encounters table                   N
ORD_DATE             Num 4      SAS Date                     Order Date                                           N
NDC                  Char 11    National Drug Code           “-“ has been expunged                                N
SIG                  Char 100                                SIG text                                             N
RXQTY                Num 4                                   Number of units (pills, tablets) ordered.            N
                                                             *Need to verify that this variable equals RXSUP x
                                                             RXAMT from pharm table above.

RXREFILLS            Num                                     Number of refills permitted.                        N
START_DATE           Num 4      SAS Date                     Prescription start date                             N
END_DATE             Num 4      SAS Date                     Prescription end date                               N
RXMD_ID              Num 8      Prescribing MD               See provider table for definition                   N
HPRF
HTN Registry Department Values
Note: Each site will need to map their internal department codes to the best
match to one of these departments listed here.

Most come from directly from the VDW definitions, but some are broken out a
little bit further…most notably…minor/ambulatory/same day surgery needs to
be distinguishable from other surgery departments.

CVRN Department Code        Department Description                     VDW?
ACUP                        Acupuncture                                Y
ALGY                        Allergy                                    Y
ALTM                        Alternative Medicine                       N
AMBU                        Ambulance                                  Y
ANES                        Anesthesiology                             Y
AUD                         Audiology                                  Y
CARD                        Cardiology                                 Y
CASR                        Cast Room                                  Y
CHEM                        Chemical and Alcohol Dependency            Y
CHIR                        Chiropractic                               Y
CMHL                        Community Health                           Y
COSM                        Cosmetic Services                          N
CPHA                        Clinical Pharmacy                          N
CRHB                        Cardiac Rehab                              N
CRIT                        Critical Care Medicine                     Y
CRMG                        Care Management                            Y
CTRD                        Cardiac Treadmill                          N
DENT                        Dental                                     Y
DERM                        Dermatology                                Y
DMAN                        Disease Management                         N
EDUC                        Education                                  Y
ENDO                        Endocrinology                              Y
ENT                         Otolaryngology/Head and Neck Surgery       Y
ER                          Emergency Room                             Y
FP                          Family Practice                            Y
GEN                         Genetics                                   Y
GER                         Gerontology/Geriatrics                     Y
GI                          Gastroenterology                           Y
HAP                         Health Appraisals                          Y
HEP                         Hepatology                                 Y
HLED                        Health Education                           N
HOSP                        Hospital Care                              Y
HSPC                        Hospice Care                               N
IM                          Internal Medicine                          Y
IMUN                        Immunology                                 Y
IND                         Industrial Medicine                        Y
INF                         Infectious Disease                         Y
INFC                        Infection Control                          N
IR                          Injection Room                             Y
LAB                         Laboratory                                 Y
MH                          Mental Health                              Y
MSUR                        Minor/Day Surgery                          N
NATU                        Naturopathy                                Y
NEPH                        Nephrology                                 Y
NEUR   Neurology                             Y
NRSG   Neurosurgery                          Y
NUCL   Nuclear Medicine                      Y
NUT    Nutrition                             Y
OBED   Childbirth Education                  N
OBGN   Obstetrics/Gynecology                 Y
OCTH   Occupational Therapy                  Y
ONC    Oncology                              Y
OPTH   Ophthalmology                         Y
OPTO   Optometry                             Y
ORTH   Orthopedics                           Y
OST    Osteopathy                            Y
OTH    Other                                 Y
PAIN   Pain Clinic/Chronic Pain Management   N
PATH   Pathology                             Y
PC     Primary Care                          Y
PEDS   Pediatrics                            Y
PERI   Perinatology                          Y
PHAR   Pharmacy                              N
PHYS   Physiatry/Physical Medicine           Y
POD    Podiatry                              Y
PROC   Procedural                            N
PREV   Prevention                            N
PSRG   Plastic Surgery                       Y
PT     Physical Therapy                      Y
PTED   Patient Education                     N
PULM   Pulmonology                           Y
RAD    Radiology                             Y
RECT   Recreational Therapy                  Y
REHB   Rehabilitation                        Y
RESP   Respiratory Therapy                   Y
RHEU   Rheumatology                          Y
RN     Registered Nurse                      Y
SBSP   Subspecialty                          N
SNF    Skilled Nursing Facility              N
SPOR   Sports Medicine                       Y
SPTH   Speech Therapy                        Y
SURG   General Surgery                       Y
UNK    Unknown                               Y
URG    Urgent Care                           Y
URO    Urology                               Y
WOUN   Wound Care Clinic                     N
WTRD   Weight Reduction                      N
Provider type values from Virtual Data Warehouse

PROV_TYPE        Provider Type Description
             1   ACUPUNCTURIST
             2   ANESTHESIOLGY ASST
             3   AUDIOLOGIST
             4   AUDIOLOGY ASSISTANT
             5   CARDIAC REHAB THERAPIST
             6   CASE MANAGER
             7   CERTIFIED NURSE SPECIALIST
             8   CERTIFIED REG NURSE ANESTHETIST
             9   CHAPLAIN
            10   CHEM DEP COUNSELOR, ADULT
            11   CHEM DEP COUNSELOR, CHILD/ADOL
            12   CHIROPRACTOR
            13   CIGNA
            14   CLINICAL NURSE SPECIALIST
            15   COUMADIN NURSE
            16   CPAP SPECIALIST
            17   DENTAL ASSISTANT
            18   DENTIST
            19   DIABETIC NURSE
            20   DIETETIC TECH
            21   DIETITIAN
            22   EEG TECHNICIAN
            23   ER TECH
            24   EXERCISE PHYSIOLOGIST
            25   FELLOW
            26   HEALING TOUCH
            27   HEALTH EDUCATOR
            28   HOME HEALTH AIDE
            29   HP PHYSICIAN
            30   HYGIENIST
            31   INDEPENDENT LAB/X-RAY
            32   INF CNTRL PRACT
            33   INFUSION THERAPIST
            34   INTERPRETER
            35   LAB ASSISTANT
            36   LAB TECHNICIAN
            37   LACTATION CONSULTANT
            38   LIC FAM THERAPIST
            39   LIC SOCIAL WORKER
            40   MASSAGE THERAPIST
            41   MEDICAL ASSISTANT
            42   MIDLEVEL
            43   MIDWIFE
            44   MUSIC THERAPIST
            45   NOT APPLICABLE
            46   NURSE
            47   NURSE CLINICIAN
            48   NURSE PRACTITIONER
            49   OCCUPATIONAL THERAPIST
            50   OPHTHALMIC ASSISTANT
            51   OPHTHALMIC TECHNICIAN
            52   OPTICIAN
            53   OPTOMETRIST
            54   ORTHO PHY ASST
            55   ORTHOPAEDIC
            56   OSTEOPATH
            57   PERSONAL CARE ATTENDANT
            58   PHARM TECH
            59   PHARMACIST
 60   PHYSICAL THERAPIST
 61   PHYSICIAN
 62   PHYSICIAN ASSISTANT
 63   PODIATRIST
 64   PSYCH TECHNICIAN
 65   PSYCHOLOGIST
 66   PSYCHOTHERAPIST
 67   PSYCHOTHERAPIST, ADULT
 68   PSYCHOTHERAPIST, CHILD/ADOL
 69   PT ASSISTANT
 70   RADIATION THERAPIST
 71   RADIOLOGY TECHNICIAN
 72   RECREATIONAL THERAPIST
 73   REGISTERED NURSE
 74   REHAB ASSISTANT
 75   REHAB THERAPIST
 76   REIKI
 77   RESIDENT
 78   RESOURCE
 79   RESPIRATORY THERAPIST
 80   SOCIAL WORKER
 81   SPEECH PATHOLOGIST CERTIFIED
 82   STUDENT
 83   SURG TECH
 84   SURGEON ASSISTANT
 85   THERAPEUTIC AQUATIC SPECIALIST
 86   ULTRASOUND TECHNICIAN
888   OTHER
999   UNKNOWN
Provider Specialty values from Virtual Data Warehouse

Specialty   Specialty Description
ALC         ADDICTION MEDICINE/CHEMICAL DEPENDENCY
ALL         ALLERGY & IMMUNOLOGY
ANE         ANESTHESIOLOGY
AUD         AUDIOLOGY
CAR         CARDIOLOGY
CAV         CARDIOVASCULAR SURGERY
CHR         CHIROPRACTIC
COL         COLORECTAL SURGERY
COM         ALTERNATIVE MEDICINE
CRI         CRITICAL CARE
DEN         DENTISTRY
DER         DERMATOLOGY
EME         EMERGENCY MEDICINE
END         ENDOCRINOLOGY
ENT         OTOLARYNGOLOGY
FAM         FAMILY PRACTICE
GAS         GASTROENTEROLOGY
GEN         GENETICS
GER         GERIATRIC MEDICINE
HAN         HAND SURGERY
HOM         HOME HEALTH CARE
HOS         HOSPITAL MEDICINE
HYM         HYPERBARIC MEDICINE
IMG         INTERNAL MEDICINE
INF         INFECTIOUS DISEASE
LAB         LABORATORY
MEN         MENTAL HEALTH
MUL         MULTI-SPECIALTY
NEH         NEPHROLOGY
NEO         NEONATOLOGY
NES         NEUROSURGERY
NEU         NEUROLOGY
NUM         NUCLEAR MEDICINE
NUR         NURSING, GENERAL
NUT         NUTRITION
OBO         GYN ONCOLOGY
OBS         OBSTETRICS/GYNECOLOGY
OCM         OCCUPATIONAL MEDICINE
ONC         ONCOLOGY
OPH         OPTHAMOLOGY
OPT         OPTOMETRY
ORA         ORAL SURGERY
ORT         OTHOPEDICS
OTO         OTOLARYNGOLOGY
OTO         OTOLARYNGOLOGY
OTO         PEDIATRIC OTOLARYNGOLOGY
OTO         OTOLARYNGOLOGY
OTO         OTOLARYNGOLOGY
PAI         PAIN MANAGEMENT
PAL         PALLIATIVE CARE
PAT         PATHOLOGY
PED         PEDIATRIC MEDICINE
PEY   PERINATOLOGY
PHA   PHARMACOLOGY
PHT   PHYSICAL THERAPY
PLA   PLASTIC & RECONSTRUCTIVE SURGERY
POD   PODIATRY
PRE   PREVENTATIVE MEDICINE
PRC   PROCTOLOGY
PSY   PSYCHIATRY
PUL   PULMONARY MEDICINE
PVM   PERIPHERAL VASCULAR DISEASE
RAD   RADIOLOGY
REH   REHABILITATION FACILITY
RHE   RHEUMATOLOGY
ROP   RADIATION ONCOLOGY
SLC   SLEEP MEDICINE
SPP   SPEECH THERAPY
SUR   GENERAL SURGERY
SMD   SPORTS MEDICINE
TRN   TRANSPORTATION SERVICES/AMBULANCE
TRS   TRANSPLANT SURGERY
UNK   UNKNOWN SPECIALTY
URG   URGENT CARE
URO   UROLOGY
VAS   VASCULAR SURGERY

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:5/7/2012
language:
pages:87