Name: | Colorado |
---|---|
Abbreviation: | CO |
Title of System | Colorado All Payer Claims Database |
Website | http://www.cohealthdata.org ![]() |
Who Maintains the System | Center for Improving Value in Health Care (CIVHC) |
Versions: | August 2011 - v3 March 2013 - v5 March 2014 - v6 |
Data Element ID | Data Element | Description | Type | Format | Length |
---|---|---|---|---|---|
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Not Provided | date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | date | CCYYMM | 6 |
![]() |
Record count | Total number of records submitted in the medical claims file, excluding header and trailer records | int | 10 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 30 | |
![]() |
Insurance Type/Product Code | Not Provided | char | 2 | |
![]() |
Payer Claim Control Number | Must apply to the entire claim and be unique within the payer's system. No partial claims. Only paid (or partially paid) claims | varchar | 35 | |
![]() |
Line Counter | Line number for this service. The line counter begins with 1 and is incremented by 1 for each additional service line of a claim. All claims must contain a line 1. | int | 4 | |
![]() |
Version Number | The version number of this claim service line. The original claim will have a version number of 0, with the next version being assigned a 1, and each subsequent version being incremented by 1 for that service line. Plans that cannot increment this column may opt to use YYMM as the version number. | int | 4 | |
![]() |
Insured Group or Policy Number | Group or policy number - not the number that uniquely identifies the subscriber. | varchar | 30 | |
![]() |
Subscriber Social Security Number | Subscriber's social security number; Set as null if unavailable | varchar | 9 | |
![]() |
Plan Specific Contract Number | Plan assigned subscriber's contract number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the subscriber. | varchar | 128 | |
![]() |
Member Suffix or Sequence Number | Unique number of the member within the contract. Must be an identifier that is unique to the member. | varchar | 20 | |
![]() |
Member Identification Code (patient) | Member's social security number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the member. | varchar | 9 | |
![]() |
Individual Relationship Code | Member's relationship to insured | char | 2 | |
![]() |
Member Gender | Not Provided | char | 1 | |
![]() |
Member Date of Birth | Not Provided | char | YYYYMMDD | 8 |
![]() |
Member City Name | City name of member | varchar | 30 | |
![]() |
Member Street Address | Physical street address of the covered member | Varchar | 50 | |
![]() |
Member State or Province | As defined by the US Postal Service | char | 2 | |
![]() |
Member ZIP Code | ZIP Code of member - may include non- US codes. Plus 4 optional but desired. | varchar | 11 | |
![]() |
Date Service Approved/Accounts Payable Date/Actual Paid Date | Not Provided | char | YYYYMMDD | 8 |
![]() |
Admission Date | Required for all inpatient claims. | char | YYYYMMDD | 8 |
![]() |
Admission Hour | Required for all inpatient claims. Time is expressed in military time | char | HHMM | 4 |
![]() |
Admission Type | Required for all inpatient claims (SOURCE: National Uniform Billing Data Element Specifications) | int | 1 | |
![]() |
Admission Source | Required for all inpatient claims (SOURCE: National Uniform Billing Data Element Specifications) | char | 1 | |
![]() |
Discharge Hour | Time expressed in military time | int | HHMM | 4 |
![]() |
Discharge Status | Required for all inpatient claims. | char | 2 | |
![]() |
Service Provider Number | Payer assigned service provider number. Submit facility for institutional claims; physician or healthcare professional for professional claims. | varchar | 30 | |
![]() |
Service Provider Tax ID Number | Federal taxpayer's identification number | varchar | 10 | |
![]() |
Service National Provider ID | National Provider ID. This data element pertains to the entity or individual directly providing the service. | varchar | 20 | |
![]() |
Service Provider Entity Type Qualifier | HIPAA provider taxonomy classifies provider groups (clinicians who bill as a group practice or under a corporate name, even if that group is composed of one provider) as a "person", and these shall be coded as a person. | char | 1 | |
![]() |
Service Provider First Name | Individual first name. Set to null if provider is a facility or organization. | varchar | 25 | |
![]() |
Service Provider Middle Name | Individual middle name or initial. Set to null if provider is a facility or organization. | varchar | 25 | |
![]() |
Service Provider Last Name or Organization Name | Full name of provider organization or last name of individual provider | varchar | 60 | |
![]() |
Service Provider Suffix | Suffix to individual name. Set to null if provider is a facility or organization. The service provider suffix shall be used to capture the generation of the individual clinician (e.g., Jr., Sr., III), if applicable, rather than the clinician's degree (e.g., MD, LCSW). | varchar | 10 | |
![]() |
Service Provider Specialty | As defined by payer. Dictionary for specialty code values must be supplied during testing. | varchar | 10 | |
![]() |
Service Provider Street Address | Physical practice location street address of the provider administering the services | Varchar | 50 | |
![]() |
Service Provider City Name | City name of provider - preferably practice location | varchar | 30 | |
![]() |
Service Provider State or Province | As defined by the US Postal Service | char | 2 | |
![]() |
Service Provider ZIP Code | ZIP Code of provider - may include non- US codes; do not include dash. Plus 4 optional but desired. | varchar | 11 | |
![]() |
Type of Bill - Institutional | Required for institutional claims; Not to be used for professional claims | char | 3 | |
![]() |
Place of Service | Required for professional claims. Not to be used for institutional claims. Map where you can and default to "99" for all others. | char | 2 | |
![]() |
Claim Status | Not Provided | char | 2 | |
![]() |
Admitting Diagnosis | Required on all inpatient admission claims and encounters. ICD-9-CM or ICD-10-CM. Do not code decimal point. | varchar | 7 | |
![]() |
ICD-9 / ICD-10 Flag | The purpose of this field is to identify which code set is being utilized. | char | 1 | |
![]() |
E-Code | Describes an injury, poisoning or adverse effect. ICD-9-CM or ICD-10-CM. Do not code decimal point. | varchar | 7 | |
![]() |
Principal Diagnosis | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 1 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 2 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 3 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 4 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 5 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 6 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 7 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 8 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 9 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 10 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 11 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Other Diagnosis - 12 | ICD-9-CM or ICD-10_CM. Do not code decimal point. | varchar | 7 | |
![]() |
Revenue Code | National Uniform Billing Committee Codes. Code using leading zeroes, left justified, and four digits. | char | 10 | |
![]() |
Outpatient Procedure Code | Health Care Common Procedural Coding System (HCPCS); this includes the CPT codes of the American Medical Association. Required for Outpatient and Professional claims only. | varchar | 10 | |
![]() |
Procedure Modifier - 1 | Procedure modifier required when a modifier clarifies/improves the reporting accuracy of the associated procedure code. Required for Outpatient and Professional claims only. | char | 2 | |
![]() |
Procedure Modifier - 2 | Procedure modifier required when a modifier clarifies/improves the reporting accuracy of the associated procedure code. Required for Outpatient and Professional claims only. | char | 2 | |
![]() |
ICD-9-CM or ICD-10 Procedure Code | Primary procedure code for this line of service. Do not code decimal point. Default to Blank | char | 7 | |
![]() |
Date of Service - From | First date of service for this service line. | Date | YYYYMMDD | 8 |
![]() |
Date of Service - Thru | Last date of service for this service line. | Date | YYYYMMDD | 8 |
![]() |
Quantity | Count of services performed, which shall be set equal to one on all observation bed service lines and should be set equal to zero on all other room and board service lines, regardless of the length of stay. | int | 3 | |
![]() |
Charge Amount | Do not code decimal point or provide any punctuation where $1,000.00 converted to 100000 Same for all financial data that follows. | int | 10 | |
![]() |
Paid Amount | Includes any withhold amounts. Do not code decimal point. For capitated claims set to zero. | int | 10 | |
![]() |
Prepaid Amount | For capitated services, the fee for service equivalent amount. Do not code decimal point. | int | 10 | |
![]() |
Co-pay Amount | The preset, fixed dollar amount for which the individual is responsible. Do not code decimal point. | int | 10 | |
![]() |
Coinsurance Amount | The dollar amount an individual is responsible for - not the percentage. Do not code decimal point. | int | 10 | |
![]() |
Deductible Amount | Do not code decimal point. | int | 10 | |
![]() |
Patient Account/Control Number | Number assigned by hospital | varchar | 20 | |
![]() |
Discharge Date | Date patient discharged. Required for all inpatient claims. | Date | YYYYMMDD | 8 |
![]() |
Service Provider Country Name | Code US for United States. | varchar | 30 | |
![]() |
DRG | Insurers and health care claims processors shall code using the CMS methodology when available. Precedence shall be given to DRGs transmitted from the hospital provider. When the CMS methodology for DRGs is not available, but the DRG system is used, the insurer shall format the DRG and the complexity level within the same field with an "A" prefix, and with a hyphen separating the DRG and the complexity level (e.g. AXXX-XX). | varchar | 10 | |
![]() |
DRG Version | Version number of the grouper used | char | 2 | |
![]() |
APC | Insurers and health care claims processors shall code using the CMS methodology when available. Precedence shall be given to APCs transmitted from the health care provider. | char | 4 | |
![]() |
APC Version | Version number of the grouper used | char | 2 | |
![]() |
Drug Code | An NDC code used only when a medication is paid for as part of a medical claim. | varchar | 11 | |
![]() |
Billing Provider Number | Payer assigned billing provider number. This number should be the identifier used by the payer for internal identification purposes, and does not routinely change. | varchar | 30 | |
![]() |
National Billing Provider ID | National Provider ID | varchar | 20 | |
![]() |
Billing Provider Last Name or Organization Name | Full name of provider billing organization or last name of individual billing provider. | varchar | 60 | |
![]() |
Subscriber Last Name | Subscriber last name | varchar | 128 | |
![]() |
Subscriber First Name | Subscriber first name | varchar | 128 | |
![]() |
Subscriber Middle Initial | Subscriber middle initial | char | 1 | |
![]() |
Member Last Name | Not Provided | varchar | 128 | |
![]() |
Member First Name | Not Provided | varchar | 128 | |
![]() |
Member Middle Initial | Not Provided | char | 1 | |
![]() |
Present on Admission - PDX | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX1 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX2 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX3 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX4 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX5 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX6 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX7 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX8 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX9 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX10 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX11 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Present on Admission - DX12 | Code indicating the presence of diagnosis at the time of admission | Varchar | 1 | |
![]() |
Tooth Number | Tooth Number or Letter Identification | Char | 20 | |
![]() |
Dental Quadrant | Dental Quadrant | Char | 1 | |
![]() |
Tooth Surface | Tooth Surface Identification | Char | 10 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058 was performed | Date | 8 | |
![]() |
ICD-9-CM Procedure Code or ICD-10-CM Procedure code | Secondary procedure code for this line of service. Do not code decimal point. | char | 7 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058A was performed | Date | 8 | |
![]() |
ICD-9-CM Procedure Code or ICD-10-CM Procedure code | Secondary procedure code for this line of service. Do not code decimal point. | char | 7 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058B was performed | Date | 8 | |
![]() |
ICD-9-CM Procedure Code or ICD-10-CM Procedure code | Secondary procedure code for this line of service. Do not code decimal point. | char | 7 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058C was performed | Date | 8 | |
![]() |
ICD-9-CM Procedure Code or ICD-10-CM Procedure code | Secondary procedure code for this line of service. Do not code decimal point. | char | 7 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058E was performed | Date | 8 | |
![]() |
ICD-9-CM Procedure Code or ICD-10-CM Procedure code | Secondary procedure code for this line of service. Do not code decimal point. | char | 7 | |
![]() |
ICD-9-CM or ICD-10-CM Procedure Date | Date MC058E was performed | Date | 8 | |
![]() |
Capitated Service Indicator | Not Provided | Char | 1 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Not Provided | date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | date | CCYYMM | 6 |
![]() |
Extraction Date | Not Provided | date | YYYYMMDD | 8 |
Data Element ID | Data Element | Description | Type | Format | Length |
---|---|---|---|---|---|
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Not Provided | date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | date | CCYYMM | 6 |
![]() |
Record count | Total number of records submitted in the medical eligibility file, excluding header and trailer records | int | 10 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 30 | |
![]() |
Insurance Type Code/Product | changes: Required field; codes added to Lookup Table. | char | 2 | |
![]() |
Year | 4 digit Year for which eligibility is reported in this submission | int | 4 | |
![]() |
Month | Month for which eligibility is reported in this submission expressed numerical from 01 to 12. | char | 2 | |
![]() |
Insured Group or Policy Number | Group or policy number - not the number that uniquely identifies the subscriber | varchar | 30 | |
![]() |
Coverage Level Code | Benefit coverage level | char | 3 | |
![]() |
Subscriber Social Security Number | Subscriber's social security number; Set as null if unavailable | varchar | 9 | |
![]() |
Plan Specific Contract Number | Plan assigned subscriber's contract number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the subscriber. | varchar | 128 | |
![]() |
Member Suffix or Sequence Number | Unique number of the member within the contract. Must be an identifier that is unique to the member. This column is the unique identifying column for membership and related medical and pharmacy claims. Only one record per eligibility month. | varchar | 128 | |
![]() |
Member Identification Code | Member's social security number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the member. | varchar | 9 | |
![]() |
Individual Relationship Code | Member's relationship to insured | char | 2 | |
![]() |
Member Gender | Not Provided | char | 1 | |
![]() |
Member Date of Birth | Not Provided | char | YYYYMMDD | 8 |
![]() |
Member City Name | City location of member | varchar | 30 | |
![]() |
Member State or Province | As defined by the US Postal Service | char | 2 | |
![]() |
Member ZIP Code | ZIP Code of member - may include non-US codes. Do not include dash. Plus 4 optional but desired. | varchar | 11 | |
![]() |
Medical Coverage | Not Provided | char | 1 | |
![]() |
Prescription Drug Coverage | Not Provided | char | 1 | |
![]() |
Dental Coverage | Not Provided | char | 1 | |
![]() |
Race 1 | Not Provided | varchar | 6 | |
![]() |
Race 2 | Not Provided | varchar | 6 | |
![]() |
Other Race | List race if MC021or MC022 are coded as R9. | varchar | 15 | |
![]() |
Hispanic Indicator | Not Provided | char | 1 | |
![]() |
Ethnicity 1 | Not Provided | varchar | 6 | |
![]() |
Ethnicity 2 | Not Provided | varchar | 6 | |
![]() |
Other Ethnicity | List ethnicity if MC025 or MC026 are coded as OTHER. | varchar | 20 | |
![]() |
Primary Insurance Indicator | Not Provided | char | 1 | |
![]() |
Coverage Type | Insurers using this code shall obtain prior approval. | char | 3 | |
![]() |
Market Category Code | Not Provided | varchar | 4 | |
![]() |
Employer Tax ID | Employer tax ID | varchar | 50 | |
![]() |
Member Street Address | Street address of member | varchar | 50 | |
![]() |
Employer Group Name | Employer Group Name or IND for individual Policies | varchar | 128 | |
![]() |
Subscriber Last Name | The subscriber last name | varchar | 128 | |
![]() |
Subscriber First Name | The subscriber first name | varchar | 128 | |
![]() |
Subscriber Middle Initial | The subscriber middle initial | char | 1 | |
![]() |
Member Last Name | The member last name | varchar | 128 | |
![]() |
Member First Name | The member first name | varchar | 128 | |
![]() |
Plan Effective Date | Date eligibility started for this member under this plan type. The purpose of this data element is to maintain eligibility span for each member. | char | YYYYMMDD | 8 |
![]() |
Exchange Offering | Identifies whether or not a policy was purchased through the Colorado Health Benefits Exchange (COBHE). | char | 1 | |
![]() |
Group Size | Code indicating Group Size consistent with Colorado Insurance Law and Regulation Required only for plans sold in the commercial large, small and non-group markets. The following plan/products do not need to report this value: Student plans Medicare supplemental Medicaid-funded plans Stand-alone behavioral health, dental and vision | char | 2 | |
![]() |
Risk Basis | Default to "F" for grandfathered Plans | char | 1 | |
![]() |
High Deductible/ Health Savings Account Plan | Default to "N" for grandfathered Plans | char | 1 | |
![]() |
Actuarial Value | Report value as calculated in the most recent version of the HHS Actuarial Value Calculator available at http://cciio.cms.gov/resources/regulations/index.html Size includes decimal point. Required as of January 1, 2014 for small group and non-group (individual) plans sold inside or outside the Exchange. Default to "0" for Grandfathered plans | decimal | 6 | |
![]() |
Metallic Value | Metal Level (percentage of Actuarial Value) per federal regulations... Required as of January 1, 2014 for small group and non-group (individual) plans sold inside or outside the Exchange. Use values provided in the most recent version of the HHS Actuarial Value Calculator available at : http://cciio.cms.gov/resources/regulations/index.html Default to "0" for Grandfathered plans | int | 1 | |
![]() |
Grandfather Status | See definition of "grandfathered plans" in HHS rules CFR 147.140 Required as of January 1, 2014 for small group and non-group (individual) plans sold inside or outside the Exchange. Default to "0" for  Grandfathered plans | Char | 1 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Not Provided | date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | date | CCYYMM | 6 |
![]() |
Extraction Date | Not Provided | date | YYYYMMDD | 8 |
Data Element ID | Data Element | Description | Type | Format | Length |
---|---|---|---|---|---|
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Example: 200801 | Date | CCYYMM | 6 |
![]() |
Ending Month | Example: 200812 | Date | CCYYMM | 6 |
![]() |
Record count | Total number of records submitted in the medical eligibility file, excluding header and trailer records | int | 10 | |
![]() |
Provider ID | Unique identified for the provider as assigned by the reporting entity | varchar | 30 | |
![]() |
Provider Tax ID | Tax ID of the provider. Do not code punctuation. | varchar | 10 | |
![]() |
Provider Entity | Not Provided | char | 1 | |
![]() |
Provider First Name | Individual first name. Set to null if provider is a facility or organization. | varchar | 25 | |
![]() |
Provider Middle Name or Initial | Not Provided | varchar | 25 | |
MP006 | Provider Last Name or Organization Name | Full name of provider organization or last name of individual provider | varchar | 60 | |
![]() |
Provider Suffix | Example: Jr; null if provider is an organization. Do not use credentials such as MD or PhD | varchar | 10 | |
![]() |
Provider Specialty | Report the HIPAA-compliant health care provider taxonomy code. Code set is freely available at the National Uniform Claims Committee's web site at http://www.nucc.org/ | varchar | 50 | |
![]() |
Provider Office Street Address | Physical address - address where provider delivers health care services | varchar | 50 | |
![]() |
Provider Office City | Physical address - address where provider delivers health care services | varchar | 30 | |
![]() |
Provider Office State | Physical address - address where provider delivers health care services. Use postal service standard 2 letter abbreviations. | char | 2 | |
![]() |
Provider Office Zip | Physical address - address where provider delivers health care services. Minimum 5 digit code. | varchar | 11 | |
![]() |
Provider DEA Number | Not Provided | varchar | 12 | |
![]() |
Provider NPI | Not Provided | varchar | 20 | |
![]() |
Provider State License Number | Prefix with two-character state of licensure with no punctuation. Example COLL12345 | varchar | 20 | |
MP016 | Provider office Address | Physical address - address where provider delivers health care services: Suite number, floor number, Unit number, etc. | Varchar | 10 | |
MP017 | Provider Office number | Provider Office number: Telephone number where provider delivers health care services. | varchar | 10 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Example: 200801 | Date | CCYYMM | 6 |
![]() |
Ending Month | Example: 200812 | Date | CCYYMM | 6 |
![]() |
Extraction Date | Not Provided | Date | YYYYMMDD | 8 |
Data Element ID | Data Element | Description | Type | Format | Length |
---|---|---|---|---|---|
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | char | 8 | |
![]() |
Payer Name | Distributed by CIVHC | char | 75 | |
![]() |
Beginning Month | Not Provided | Date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | Date | CCYYMM | 6 |
![]() |
Record count | Total number of records submitted in the medical claims file, excluding header and trailer records | int | 10 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 30 | |
![]() |
Insurance Type/Product Code | Not Provided | char | 2 | |
![]() |
Payer Claim Control Number | Must apply to the entire claim and be unique within the payer's system. | varchar | 35 | |
![]() |
Line Counter | Line number for this service. The line counter begins with 1 and is incremented by 1 for each additional service line of a claim. | int | 4 | |
![]() |
Insured Group Number | Group or policy number - not the number that uniquely identifies the subscriber | varchar | 30 | |
![]() |
Subscriber Social Security Number | Subscriber's social security number; Set as null if unavailable | varchar | 9 | |
![]() |
Plan Specific Contract Number | Plan assigned subscriber's contract number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the subscriber. | varchar | 128 | |
![]() |
Member Suffix or Sequence Number | Unique number of the member within the contract. Must be an identifier that is unique to the member. | varchar | 20 | |
![]() |
Member Identification Code | Member's social security number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the member. | varchar | 128 | |
![]() |
Individual Relationship Code | Member's relationship to insured | char | 2 | |
![]() |
Member Gender | Not Provided | char | 1 | |
![]() |
Member Date of Birth | Not Provided | Date | YYYYMMDD | 8 |
![]() |
Member City Name of Residence | City name of member | varchar | 50 | |
![]() |
Member State or Province | As defined by the US Postal Service | char | 2 | |
![]() |
Member ZIP Code | ZIP Code of member - may include non-US codes; Do not include dash. Plus 4 optional but desired. | varchar | 11 | |
![]() |
Date Service Approved (AP Date) | date claim paid if available, otherwise set to Date Prescription Filled | Date | YYYYMMDD | 8 |
![]() |
Pharmacy Number | Payer assigned pharmacy number. AHFS number is acceptable. | varchar | 30 | |
![]() |
Pharmacy Tax ID Number | Federal taxpayer's identification number coded with no punctuation (carriers that contract with outside PBM's will not have this) | varchar | 10 | |
![]() |
Pharmacy Name | Name of pharmacy | varchar | 50 | |
![]() |
National Provider ID Number | National Provider ID. This data element pertains to the entity or individual directly providing the service. | varchar | 20 | |
![]() |
Pharmacy Location Street Address | Street address of pharmacy | Varchar | 30 | |
![]() |
Pharmacy Location City | City name of pharmacy - preferably pharmacy location (if mail order null) | varchar | 30 | |
![]() |
Pharmacy Location State | As defined by the US Postal Service (if mail order null) | char | 2 | |
![]() |
Pharmacy ZIP Code | ZIP Code of pharmacy - may include non-US codes. Do not include dash. Plus 4 optional but desired (if mail order null) | varchar | 10 | |
![]() |
Pharmacy Country Name | Code US for United States | varchar | 30 | |
![]() |
Claim Status | Not Provided | char | 2 | |
![]() |
Drug Code | NDC Code | varchar | 11 | |
![]() |
Drug Name | Text name of drug | varchar | 80 | |
![]() |
New Prescription or Refill | Older systems provide only an "N" for new or an "R" for refill, otherwise provide refill # | varchar | 2 | |
![]() |
Generic Drug Indicator | Not Provided | char | 2 | |
![]() |
Dispense as Written Code | Payers able to map available codes to those below | char | 1 | |
![]() |
Compound Drug Indicator | Not Provided | char | 1 | |
![]() |
Date Prescription Filled | Not Provided | Date | YYYYMMDD | 8 |
![]() |
Quantity Dispensed | Number of metric units of medication dispensed | int | 5 | |
![]() |
Days Supply | Estimated number of days the prescription will last | int | 3 | |
![]() |
Charge Amount | Do not code decimal point or provide any punctuation where $1,000.00 converted to 100000 Same for all financial data that follows. | int | 10 | |
![]() |
Paid Amount | Includes all health plan payments and excludes all member payments. Do not code decimal point. | int | 10 | |
![]() |
Ingredient Cost/List Price | Cost of the drug dispensed. Do not code decimal point. | int | 10 | |
![]() |
Postage Amount Claimed | Do not code decimal point. Not typically captured. | int | 10 | |
![]() |
Dispensing Fee | Do not code decimal point. | int | 10 | |
![]() |
Co-pay Amount | The preset, fixed dollar amount for which the individual is responsible. Do not code decimal point. | int | 10 | |
![]() |
Coinsurance Amount | The dollar amount an individual is responsible for - not the percentage. Do not code decimal point. | int | 10 | |
![]() |
Deductible Amount | Do not code decimal point. | int | 10 | |
![]() |
Unassigned | Reserved for assignment | Not Supplied | Not Supplied | Not Supplied |
![]() |
Prescribing Physician First Name | Physician first name. | varchar | 25 | |
![]() |
Prescribing Physician Middle Name | Physician middle name or initial. | varchar | 25 | |
![]() |
Prescribing Physician Last Name | Physician last name. | varchar | 60 | |
![]() |
Prescribing Physician NPI | NPI number for prescribing physician | varchar | 20 | |
![]() |
Member Street Address | Street address of member | varchar | 50 | |
![]() |
Subscriber Last Name | Not Provided | varchar | 128 | |
![]() |
Subscriber First Name | Not Provided | varchar | 128 | |
![]() |
Subscriber Middle Initial | Not Provided | char | 1 | |
![]() |
Member Last Name | Not Provided | varchar | 128 | |
![]() |
Member First Name | Not Provided | varchar | 128 | |
![]() |
Member Middle Initial | Not Provided | char | 1 | |
![]() |
Version Number | The version number of this claim service line. The original claim will have a version number of 0, with the next version being assigned a 1, and each subsequent version being incremented by 1 for that service line. Required Default YYMM | int | 4 | |
![]() |
Prescription Written Date | Date Prescription was written | Date | 8 | |
![]() |
Prescribing Physician Provider ID | Provider ID for the prescribing physician | varchar | 30 | |
![]() |
Prescribing Physician DEA | DEA number for prescribing physician | varchar | 20 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Record Type | Not Provided | char | 2 | |
![]() |
Payer Code | Distributed by CIVHC | varchar | 8 | |
![]() |
Payer Name | Distributed by CIVHC | varchar | 75 | |
![]() |
Beginning Month | Not Provided | Date | CCYYMM | 6 |
![]() |
Ending Month | Not Provided | Date | CCYYMM | 6 |
![]() |
Extraction Date | Not Provided | Date | YYYYMMDD | 8 |