Contract Level Contact Data Extract

The generation date and time of this extract can be determined by the text file "Date modified" attribute.

The Contract Level Contact Data Extract consists of the following files downloaded from the
HPMS Repository:

ContractContactsReadme2023.txt
Contact_Def_2023.pdf
ContractContacts2023.txt
ContractContacts2023.sas

                                            ******

ContractContacts2023.txt is a tab delimited text file containing contact information at the
time the extract is requested for the year selected. The file contains the following columns:

contract_id                     Contract Id
role                            Contact Role
title                           Title
prefix                          Name Prefix
last_name                       Last Name
first_name                      First Name
mi                              Middle Initial
phone                           Phone Number
phone_ext                       Phone Extension
alt_phone                       TTY/TDD Phone Number
alt_phone_ext                   TTY/TDD Phone Extension
fax                             Fax Number
email                           Email Address
street_address                  Street Address
street_address2                 Street Address 2
city                            City
state_code                      State
zip                             Zipcode
last_update                     Date of Last Update
contract_year                   Contract Year
contract_name                   Contract Name
org_type                        Organization Type
marketing_name                  Organization Marketing Name
contract_plan_type              Contract Plan Type
employer                        PHR Company Name
parent_organization_name        Parent Organization Description
parent_organization_id          Parent Identifiaction Number
partd_offered                   Part D Offered
contract_status                 Contract Status
tollfree_phone                  Toll-free Phone Number
tollfree_ext                    Toll-free Phone Extension
alt_tollfree_phone              TTY/TDD Toll-free Phone Number
alt_tollfree_phone_ext          TTY/TDD Toll-free Phone Extension
new_payment_bill_option         New Payment Bill Option
demo_type_flag                  Demo Type
bill_option_code                Bill Option Code
   Note: bill_option_code has the following values
        1 - Non Lock-In Beneficiary - CMS to process all claims
        2 - Non Lock-In Beneficiary - Plan to process only in-plan Part A and in-area Part B claims
        4 - Chronic Care Orgs - CMS to process all claims
        5 - PDPs
        A - Lock-In Beneficiary - CMS to process all claims
        B - Lock-In Beneficiary - Plan to process only in-plan Part A and in-area Part B claims
        C - Lock-In Beneficiary - Plan to process all Part A and Part B claims

region_responsible              Responsible Region

ContractContacts2023.sas is SAS program which will read the tab-delimited
file ContractContacts2023.txt.  This program also serves as the data dictionary for
this extract.  The type and length of all the variables are described in the
SAS program.  The SAS program also documents variables with discrete values.

                                            ******

If you are importing the data into Excel, you must define certain columns as text
or you will lose any leading zero information (example, a plan id of '001' will
appear as '1' if defined as "general" or "numeric.").  The variable names for
columns which should be declared as text are indicated in the SAS program by
being listed in the length statement.
