CVX Source Information

Field	Value
Short Name	Vaccines Administered
Family	CVX
Source Restriction Level	0
Language	ENG
License Contact	CDC, National Center for Immunization and Respiratory Diseases Immunization Information System Support Branch - Informatics 1600 Clifton Road Mailstop: E-62 Atlanta GA United States 30333 iisinfo@cdc.gov http://www2a.cdc.gov/vaccines/iis/iisstandards/vaccines.asp?rpt=cvx
Content Contact	CDC, National Center for Immunization and Respiratory Diseases Immunization Information System Support Branch - Informatics 1600 Clifton Road Mailstop: E-62 Atlanta GA United States 30333 iisinfo@cdc.gov http://www2a.cdc.gov/vaccines/iis/iisstandards/vaccines.asp?rpt=cvx

This section lists specific source data elements and provides information on their representation in RxNorm.

Summary of Changes

There are no changes since the last monthly release.

Source Provided Files:

The CVX drug data is available from: http://www2a.cdc.gov/vaccines/iis/iisstandards/vaccines.asp?rpt=cvx

The two NDC files are available from: https://www2a.cdc.gov/vaccines/iis/iisstandards/ndc_tableaccess.asp

The following three files are used for RxNorm source processing.

File Name	Description
web_cvx.xlsx	Excel file containing information on both active and inactive vaccines available in the US
NDC_Unit_Use.xlsx	Excel file containing NDC unit of use information facilitating the use of NDCs to identify vaccines
NDC_Unit_Sale.xlsx	Excel file containing NDC unit sale information facilitating the use of NDCs to identify vaccines

Source-Provided Files: Details

The following is a list of fields in the CVX source files used in RxNorm processing and their representations in RxNorm.

Consult the CVX web site for additional CVX information at: http://www2a.cdc.gov/vaccines/iis/iisstandards/vaccines.asp?rpt=cvx

File name: web_cvx.xlsx

#	CVX Field Name	Description	RxNorm Representation
1	CVX Code	Indicates the product used in a vaccination. There are three codes indicating that the concept is not a vaccine: 998 = "no vaccine administered", 999 = "unknown vaccine or immune globulin", and 99 = "RESERVED - do not use".	RXNCONSO.CODE
2	CVX Short Description	Vaccine short name	RXNCONSO.STR (TTY = AB)
3	Full Vaccine Name	Vaccine full name	RXNCONSO.STR (TTY = PT)
4	Note	More information about the vaccine	RXNSAT.ATN = SOS
5	VaccineStatus	Indicates if the vaccine is currently available in the United States	RXNSAT.ATN = VACCINE_STATUS
6	internalID	Not applicable	Not applicable
7	nonvaccine	A value of "True" indicates that the concept is a non-vaccine. There are three concepts with nonvaccine = "True," indicating that the concept is not a vaccine: "no vaccine administered", "unknown vaccine or immune globulin", and "RESERVED - do not use". All other concepts have a nonvaccine value of "False".	RXNSAT.ATN = NON_VACCINE
8	update_date	Indicates the last time this particular vaccine code was updated in this file	RXNSAT.ATN = DATE_LAST_MODIFIED

File name: NDC_Unit_Use.xlsx

#	CVX Field Name	RxNorm Representation
1	NDCInnerID	Not applicable
2	UseUnitLabeler	Not applicable
3	UseUnitProduct	Not applicable
4	UseUnitPackage	Not applicable
5	UseUnitPropName	Not applicable; used to append brand name in TTY = RXN_PT atom string
6	UseUnitGenericName	Not applicable
7	UseUnitLabelerName	Not applicable
8	UseUnitstartDate	Not applicable
9	UseUnitEndDate	Not applicable
10	UseUnitPackForm	Not applicable
11	UseUnitGTIN	Not applicable
12	CVX Code	Not applicable
13	CVX Short Description	Not applicable
14	NoInner	Not applicable
15	NDC11	RXNSAT.ATN = NDC (for RxNorm editor created TTY = RXN_PT atoms only)
16	last_updated_date	Not applicable
17	GTIN	Not applicable

File name: NDC_Unit_Sale.xlsx

#	CVX Field Name	RxNorm Representation
1	NDCouterID	Not applicable
2	OuterLabeler	Not applicable
3	OuterProduct	Not applicable
4	Outerpackage	Not applicable
5	OuterPropName	Not applicable; used to append brand name in TTY = RXN_PT atom string
6	OuterGenericName	Not applicable
7	OuterLabelerName	Not applicable
8	OuterStartDate	Not applicable
9	OuterEndDate	Not applicable
10	OuterPackForm	Not applicable
11	OuterRoute	Not applicable
12	last_updated_date	Not applicable
13	CVX Code	Not applicable
14	CVX Short Description	Not applicable
15	NDC11	RXNSAT.ATN = NDC (for RxNorm editor created TTY = RXN_PT atoms only)
16	GTIN	Not applicable

This section lists RxNorm data elements and traces them back to the specific CVX data that populates them.

Summary of Changes

There are no changes since the last monthly release.

Source Provided Files:

File Name	Description
web_cvx.xlsx	Excel file containing information on both active and inactive vaccines available in the US
NDC_Unit_Use.xlsx	Excel file containing NDC unit of use information facilitating the use of NDCs to identify vaccines
NDC_Unit_Sale.xlsx	Excel file containing NDC unit sale information facilitating the use of NDCs to identify vaccines

RxNorm Identifiers:

Identifiers are assigned as follows:

Identifier	Origin
CODE	CVX Code
SAUI	Not applicable
SCUI	Not applicable
SDUI	Not applicable

Atoms (RXNCONSO):

Term Type	Origin
PT	CODE = web_cvx.xlsx.CVX Code STR = web_cvx.xlsx.Full Vaccine Name
AB	CODE = web_cvx.xlsx.CVX Code STR = web_cvx.xlsx.CVX Short Description
RXN_PT (RxNorm editor created atom)	CODE = Same code as PT STR = RxNorm editor created name (for a given NDC); brand name appended using NDC_Unit_Sale.xlsx.OuterPropName and NDC_Unit_Use.xlsx.UseUnitPropName If a source atom has more than one NDC and the NDCs have different meanings, new RXN_PT atoms are created by an RxNorm editor to separate the NDCs which can then be associated with proper RxNorm forms. The original atom remains a TTY = PT atom. For example, PT atom string: hepatitis A vaccine, adult dosage RXN_PT atom strings: hepatitis A vaccine, adult dosage vial [HAVRIX] hepatitis A vaccine, adult dosage syringe [HAVRIX] hepatitis A vaccine, adult dosage vial [VAQTA] hepatitis A vaccine, adult dosage syringe [VAQTA]

Attributes (RXNSAT):

ATN	Origin
DATE_LAST_MODIFIED	web_cvx.xlsx.update_date
SOS	web_cvx.xlsx.Note
VACCINE_STATUS	web_cvx.xlsx.VaccineStatus
NON_VACCINE	web_cvx.xlsx.nonvaccine
NDC	NDC_Unit_Use.xlsx.NDC11 and NDC_Unit_Sale.xlsx.NDC11 (assigned to TTY = RXN_PT atoms only; TTY = PT atoms lack NDCs)

Relationships (RXNREL):

REL	RELA/Inverse RELA	Description
RO (RxNorm editor created relationship)	mapped_to mapped_from	Connects PT and RXN_PT atoms with same CVX Code. Created when an RxNorm editor creates a TTY = RXN_PT atom.

This section lists source terminology specific data examples and sample database queries using Structured Query Language (SQL) to obtain the data. For more information about RxNorm data and files, see the RxNorm Technical Documentation.

Names and Codes in RXNCONSO.RRF

Here are sample source terminology code, source string, RxNorm Concept Unique Identifier (RXCUI), RxNorm string, RxNorm term type (TTY), and suppress values.

SOURCE_CODE	SOURCE_STR	RXCUI	RXNORM_STR	RXNORM_TTY	SUPPRESS
12	diphtheria antitoxin	3510	Diphtheria Antitoxin	IN	N
12	diphtheria antitoxin	3510	diphtheria immunoglobulin	SY	N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rc2.str as rxnorm_str, rc2.tty as rxnorm_tty, rc2.suppress
FROM rxnconso rc1, rxnconso rc2
WHERE rc1.code in ('12')
     AND rc1.sab = 'CVX'
     AND rc1.rxcui = rc2.rxcui
     AND rc2.sab = 'RXNORM';