Spreadsheet: 377039d1423774049-dataset-reshape-restructure-excelforum
Sheet: Codebook

Variable name | Variable description | Coding | Response options
GranteeID | A unique ID for each grantee who receives [NAME] funding | Numeric | 1-8577
GranteeName | The name associated with the unique ID | Text
GranteeStreet | Grantee street address stored in the system | Alphanumeric
GranteeCity | Grantee city stored in the system | Text
GranteeZipCode | Grantee zip code stored in the system | Numeric (zip)
Grantee State | Grantee state stored in the system | Text
Grantee Contact name | Name of person logged into EHB entering information based on user profile | Text
Grantee Contact title | Title of person logged into EHB entering information based on user profile | Text
Grantee Contact fax | Fax number of person logged into EHB entering information based on user profile | Phone
Grantee Contact phone | Phone number of person logged into EHB entering information based on user profile | Phone
Grantee Contact email | [NAME] of person logged into EHB entering information based on user profile | [NAME]
Program Funding Part | [NAME] funding that the grantee receives from HAB.  A grantee can receive more than one Part funding.  The grantee would then be listed multiple times. Some grantees (usually Part A and B) receive funding from HAB and then fund providers to deliver services.  They only administrate the funds.  Other grantees (Part C and D) both administrate funds and deliver the services. | Text | Part A Part B Part C Part D
Funded Service | These are the core medical services for which the grantee is funding the provider associated with that entry.  There are up to 12 core medical services for which a provider can receive funding.  The provider will be listed in the table for each service and each discrete grantee that funds the service.  Note that providers who ONLY receive funding for Health Insurance Premium & Cost Sharing Assistance and/or Local AIDS Pharmaceutical Assistance will need to be filtered from the list | Text | Early intervention services (Parts A and B) Health Insurance Premium & Cost Sharing Assistance Home and community-based health services Home health care Hospice services Local AIDS Pharmaceutical Assistance Medical case management (including treatment adherence) Medical nutrition therapy Mental health services Oral health care Outpatient/ambulatory medical care Substance abuse services-outpatient
ProviderID | A unique ID for each provider who receives [NAME] funding.  If grantee ID=provider ID, then this provider is a grantee/provider.   That means they receive funding directly from HAB and then provide direct services to clients. | Numeric | 11-8580
Provider Type | The provider type for the agency is selected.  Only one option can be chosen.  Agency reporting for multiple fee-for-service providers - any entries reporting this option should be filtered out. | Text | Agency reporting for multiple fee-for-service providers Health Department Hospital or university-based clinic Other community-based service organization (CBO) Other provider type Publicly funded community health center Publicly funded community mental health center Solo/group private medical practice Substance abuse treatment center VA facility
ProviderName | The name associated with the unique ID | Text
ProviderStreet | Provider street address stored in the system | Alphanumeric
ProviderCity | Provider city stored in the system | Text
ProviderZipcode | Provider zip code stored in the system | Numeric (zip)
Provider State | Provider state stored in the system | Text
Provider Contact name | Name of person logged into the system entering information based on user profile | Text
Provider Contact title | Title of person logged into the system entering information based on user profile | Text
Provider Contact fax | Fax number of person logged into the system entering information based on user profile | Phone
Provider Contact phone | Phone number of person logged into the system entering information based on user profile | Phone
Provider Contact email | [NAME] of person logged into the system entering information based on user profile | [NAME]
Number of Clients receiving this service from this provider | Total client count reported as receiving this service.  HAB aggregate individual records to create this total. Note that if two different grantees fund the same provider for the same service, the client count will be the same for both.  This is because the reporting system cannot differentiate the data | Numeric
Total number of visits made by clients receiving this service to | Providers can only report 1 visit per client per service per day.  This represents the total for all clients reported for the service.  Note that if two different grantees fund the same provider for the same service, the visit count will be the same for both.  This is because the reporting system cannot differentiate the data | Numeric
Provider Receipt of Section 330 Funding | Did your organization receive funding under Section 330 of the Public Health Service Act (PHSA) (funds Community Health Centers, Migrant Health Centers, and Healthcare for the Homeless)?  Only publicly funded Community health centers provide this information.  It is reported as a yes, no or unknown. | Text | Yes  No Blank
Number of Clients with Reported Insurance Status | Insurance status is required to be reported for clients who received a core medical services.  Insurance reflects all insurance during the year.   However, missing data are permitted. Multuple insurance types can be reported.  Options that can be reported include: Private, Medicare, Medicaid, Other Public, No Insurance, Other Insurance and unknown | Numeric
Number of Clients with Private Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients.  Of clients who reported multiple insurance, this is the number of clients who reported private insurance.  Note that since we don't know the combinations, this variable is not very helpful (different than how we asked HAB for data). | Numeric
Number of Clients with Other Private Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients. Of clients who reported multiple insurance, this is the number of clients who reported other private insurance. Note that since we don't know the combinations, this variable is not very helpful (different than how we asked HAB for data) | Numeric
Number of Clients with Medicare Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients. Of clients who reported multiple insurance, this is the number of clients who reported Medicare insurance. Note that since we don't know the combinations, this variable is not very helpful (different than how we asked HAB for data) | Numeric
Number of Clients with Medicaid Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients. Of clients who reported multiple insurance, this is the number of clients who reported Medicaid insurance. Note that since we don't know the combinations, this variable is not very helpful (different than how we asked HAB for data) | Numeric
Number of Clients with Other Public Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients. Of clients who reported multiple insurance, this is the number of clients who reported other public insurance. Note that since we don't know the combinations, this variable is not very helpful (different than how we asked HAB for data) | Numeric
Number of Clients with No Insurance | Need to clarify with HAB if this is limited only to those who reported multiple insurance or for all clients. Of clients who reported multiple insurance, this is the number of clients who reported no insurance. | Numeric
Number of Clients with Only Private Insurance | Private insurance means health insurance plans such as BlueCross/BlueShield, Kaiser Permanente, and Aetna.  If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Only Other Private Insurance | Other private insurance means client has an insurance type other than those listed above. If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Only Medicare Insurance | Medicare is a health insurance program for people 65 years of age and older, some disabled people under 65 years of age, and people with end-stage renal disease (permanent kidney failure treated with dialysis or a transplant). If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Only Medicaid Insurance | Medicaid is a jointly funded, Federal–State health insurance program for certain low-income and needy people. If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Only Other Public Insurance | Other public means other Federal, State, and/or local government programs providing a broad set of benefits for eligible individuals. Examples include State-funded insurance plans, military health care (TRICARE), State Children’s Health Insurance Program (SCHIP), Indian Health Service, and Veterans Health Administration. If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Only No Insurance | No insurance means the client did not have insurance to cover the cost of services at any time during the reporting period, the client self pays, or services are covered by RWHAP funds.  If you add up all of the "only" responses and add to clients with multiple insurance statuses, it equals the total number of clients with reported insurance status. | Numeric
Number of Clients with Multiple Insurance Statuses | Clients may report more than one insurance status.  This is the total number of clients for whom multiple insurance statuses were reported | Numeric