| Change_Type |
An indicator showing if the payment record is New, Added, Changed, or Unchanged in the current publication compared to the previous publication. • NEW - To identify “new” records added from the end of the previous submission deadline until the current submission period deadline date • ADDED - To identify records that were not eligible at the time of previous publication, which is eligible for current publication. • CHANGED - To identify previously published records modified after the last publication. • UNCHANGED - To identify previously published records that remain “unchanged” in current publication. |
NEW |
VARCHAR2(20) |
string |
20 |
| Covered_Recipient_Type |
An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
Covered Recipient Teaching Hospital |
VARCHAR2(50) |
string |
50 |
| NonCovered_Recipient_Entity_Name |
The name of the non-covered recipient entity receiving the payment or other transfer of value EDCBA Corporation |
VARCHAR2(50) |
string |
50 |
|
| Teaching_Hospital_CCN |
A unique identifying number (CMS Certification Number) of the Teaching Hospital receiving the payment or other transfer of value. |
330024 |
VARCHAR2(06) |
string |
6 |
| Teaching_Hospital_ID |
System generated unique identifier of the Teaching Hospital receiving the payment or other transfer of value. |
1000000999 |
NUMBER(38,0) |
number |
38 |
| Teaching_Hospital_Name |
The name of the Teaching Hospital receiving the payment or other transfer of value. The name displayed is as listed in CMS teaching hospital list under Hospital name. |
Healthy Heart Hospital |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Profile_ID |
System generated unique identifier for covered recipient physician profile or covered recipient non-physician practitioner profile receiving the payment or other transfer of value. |
1000000378 |
NUMBER(38,0) |
number 38 |
|
| Covered_Recipient_NPI |
National Provider Identifier is a unique identification number for covered recipient physician or nonphysician practitioner (and not the NPI of a group the physician/non-physician practitioner belongs to). |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Covered_Recipient_First_Name |
First name of the physician (covered recipient) or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Covered_Recipient_Middle_Name |
Middle name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Covered_Recipient_Last_Name |
Last name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Covered_Recipient_Name_Suffix |
Name suffix of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Recipient_Primary_Business_ Street_Address_Line1 |
The first line of the primary business street address of the physician or non-physician practitioner or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Recipient_Primary_Business_ S treet_Address_Line2 |
The second line of the primary business street address of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Recipient_City |
The primary practice/business address city of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Recipient_State |
The state or territory abbreviation of the primary business address of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary business address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Recipient_Zip_Code |
The 9-digit zip code for the primary business location of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) |
number |
10 |
| Recipient_Country |
The primary practice/business address country of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary practice address is in the United States |
US |
VARCHAR2(100) |
string |
100 |
| Recipient_Province |
The primary practice/business province name of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Recipient_Postal_Code |
The international postal code for the primary business location of the physician or teaching hospital or noncovered recipient entity receiving the payment or other transfer of value if the primary business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Covered_Recipient_Primary_ Type_1 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Primary_ Type_2 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Primary_ Type_3 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Primary_ Type_4 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Primary_ Type_5 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Primary_ Type_6 |
Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). |
Medical Doctor (MD)/ Physician Assistant (PA) |
VARCHAR2(100) |
string |
100 |
| Covered_Recipient_Specialty _1 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_Specialty _2 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. Note: OP began accepting this field in PY2021. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_Specialty _3 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. Note: OP began accepting this field in PY2021. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_Specialty _4 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. Note: OP began accepting this field in PY2021. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_Specialty _5 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. Note: OP began accepting this field in PY2021. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_Specialty _6 |
Physician's or non-physician practitioner’s specialty chosen from the standardized "provider taxonomy" code list. Note: OP began accepting this field in PY2021. |
Allopathic & Osteopathic Physicians- Obstetrics & Gynecology |
VARCHAR2(300) |
string |
300 |
| Covered_Recipient_License_State_code1 |
The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Covered_Recipient_License_State_code2 |
The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
CA |
CHAR(2) |
string |
2 |
| Covered_Recipient_License_State_code3 |
The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
TX |
CHAR(2) |
string |
2 |
| Covered_Recipient_License_State_code4 |
The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Covered_Recipient_License_State_code5 |
The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
MA |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_Profile_ID |
An identifier for Principal Investigator profile after validation |
3843332 |
NUMBER(38,0) |
number |
38 |
| Principal_Investigator_1_NPI |
National Provider Identifier is a unique identification number for principal investigator, if available. |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Principal_Investigator_1_First _Name |
The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_1_Middle_Name |
The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Principal_Ivestigator_1_Last_Name |
Last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Principal_Investigator_1_Name_Suffix_ Name |
suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Principal_Investigator_1_Business_Street_Address_Line1 |
The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_1_Business_Street_Address_Line2 |
The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_1_City |
The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Principal_Investigator_1__State |
The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_Zip_Code |
The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) number- number 10 |
|
|
| Principal_Investigator_1_Country |
The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
United States |
VARCHAR2(100) |
string |
100 |
| Principal_Investigator_1_Province |
The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_1_Post al_Code |
The international postal code for the primary practice/business location of the principal investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_1_Primary_Type_1 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Primary_Type_2 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Primary_Type_3 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Primary_Type_4 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Primary_Type_5 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Primary_Type_6 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_1_Spec i alty_1 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_Specialty_2 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_Specialty_3 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_Specialty_4 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_Specialty_5 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_Specialty_6 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_1_License_State_code1 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_License_State_code2 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_License_State_code3 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
ME |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_License_State_code4 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
NY |
CHAR(2) |
string |
2 |
| Principal_Investigator_1_License_State_code5 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MI |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_Profile_ID |
An identifier for Principal Investigator profile after validation |
3843342 |
NUMBER(38,0) |
number |
38 |
| Principal_Investigator_2_NPI |
National Provider Identifier is a unique identification number for principal investigator, if available. |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Principal_Investigator_2_First _Name |
The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_2_Middle_Name |
The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_2_Last _Name |
The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Principal_Investigator_2_Name_Suffix |
Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Principal_Investigator_2_Business_Street_Address_Line1 |
The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_2_Business_Street_Address_Line2 |
The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_2_City |
The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Principal_Investigator_2__State |
The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_Zip_Code |
The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) |
number |
10 |
| Principal_Investigator_2_Country |
The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
United States |
VARCHAR2(100) |
string |
100 |
| Principal_Investigator_2_Province |
The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_2_Post al_Code |
The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value if the primary practice/business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_2_Primary_Type_1 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Primary_Type_2 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Primary_Type_3 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Primary_Type_4 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Primary_Type_5 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Primary_Type_6 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_2_Specialty_1 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_Specialty_2 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_Spe ci alty_3 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_Spe ci alty_4 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_Spe ci alty_5 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_Specialty_6 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_2_License_State_code1 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_License_State_code2 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_License_State_code3 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
TX |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_License_State_code4 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
CA |
CHAR(2) |
string |
2 |
| Principal_Investigator_2_License_State_code5 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
AL |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_Profile_ID |
An identifier for Principal Investigator profile after validation |
3843347 |
NUMBER(38,0) |
number |
38 |
| Principal_Investigator_3_NPI |
National Provider Identifier is a unique identification number for principal investigator, if available. |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Principal_Investigator_3_First _Name |
The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_3_Middle_Name |
The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_3_Last _Name |
The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Principal_Investigator_3_Name_Suffix |
Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Principal_Investigator_3_Business_Street_Address_Line1 |
The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_3_Business_Street_Address_Line2 |
The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_3_City |
The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Principal_Investigator_3__State |
The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_Zip_Code |
The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) |
number |
10 |
| Principal_Investigator_3_Country |
The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
United States |
VARCHAR2(100) |
string |
100 |
| Principal_Investigator_3_Province |
The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_3_Post al_Code |
The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_3_Primary_Type_1 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Primary_Type_2 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Primary_Type_3 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Primary_Type_4 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Primary_Type_5 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Primary_Type_6 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_3_Specialty_1 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_Specialty_2 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_Spe ci alty_3 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_Spe ci alty_4 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_Spe ci alty_5 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_Spe ci alty_6 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_3_License_State_code1 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_License_State_code2 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_License_State_code3 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
CA |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_License_State_code4 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
TX |
CHAR(2) |
string |
2 |
| Principal_Investigator_3_License_State_code5 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
AL |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_Profile_ID |
An identifier for Principal Investigator profile after validation |
3843347 |
NUMBER(38,0) |
number |
38 |
| Principal_Investigator_4_NPI |
National Provider Identifier is a unique identification number for principal investigator, if available. |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Principal_Investigator_4_First _Name |
The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_4_Middle_Name |
The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_4_Last _Name |
The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Principal_Investigator_4_Name_Suffix |
Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Principal_Investigator_4_Business_Street_Address_Line1 |
The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_4_Business_Street_Address_Line2 |
The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_4_City |
The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Principal_Investigator_4__State |
The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_Zip_Code |
The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) |
number |
- |
| Principal_Investigator_4_Country |
The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
United States |
VARCHAR2(100) |
string |
100 |
| Principal_Investigator_4_Province |
The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_4_Post al_Code |
The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_4_Primary_Type_1 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Primary_Type_2 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Primary_Type_3 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Primary_Type_4 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Primary_Type_5 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Primary_Type_6 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_4_Specialty_1 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_Specialty_2 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_Spec ialty_3 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_Specialty_4 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_Specialty_5 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_Specialty_6 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_4_License_State_code1 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_License_State_code2 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_License_State_code3 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
CA |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_License_State_code4 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
TX |
CHAR(2) |
string |
2 |
| Principal_Investigator_4_License_State_code5 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
AL |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_Prof ile_ID |
An identifier for Principal Investigator profile after validation |
3843347 |
NUMBER(38,0) |
number |
38 |
| Principal_Investigator_5_NPI |
National Provider Identifier is a unique identification number for principal investigator, if available. |
2495351826 |
NUMBER(10,0) |
number |
10 |
| Principal_Investigator_5_First _Name |
The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
John |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_5_Middle_Name |
Middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
A |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_5_Last _Name |
Last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
Smith |
VARCHAR2(35 |
string |
35 |
| Principal_Investigator_5_Name_Suffix |
Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
III |
VARCHAR2(5) |
string |
5 |
| Principal_Investigator_5_Business_Street_Address_Line1 |
The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
7500 Security Blvd. |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_5_Business_Street_Address_Line2 |
The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
Suite 100 |
VARCHAR2(55) |
string |
55 |
| Principal_Investigator_5_City |
The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
Baltimore |
VARCHAR2(40) |
string |
40 |
| Principal_Investigator_5__State |
The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_Zip_Code |
The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
21244-3712 |
VARCHAR2(10) number- number 10 |
|
|
| Principal_Investigator_5_Country |
The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
United States |
VARCHAR2(100) |
string |
100 |
| Principal_Investigator_5_Province |
The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
Manitoba |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_5_Post al_Code |
The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
5600098 |
VARCHAR2(20) |
string |
20 |
| Principal_Investigator_5_Primary_Type_1 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Primary_Type_2 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Primary_Type_3 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Primary_Type_4 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Primary_Type_5 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Primary_Type_6 |
Primary type name of medicine practiced by the principal investigator |
Medical Doctor |
VARCHAR2(50) |
string |
50 |
| Principal_Investigator_5_Specialty_1 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_Specialty_2 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_Spec i alty_3 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_Spec i alty_4 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_Spec i alty_5 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_Spe ci alty_6 |
Principal Investigator's single-specialty chosen from the standardized "provider taxonomy" code list. |
Allopathic & Osteopathic Physicians/ Independent Medical Examiner |
VARCHAR2(300) |
string |
300 |
| Principal_Investigator_5_License_State_code1 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
MD |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_License_State_code2 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
VA |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_License_State_code3 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
CA |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_License_State_code4 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
TX |
CHAR(2) |
string |
2 |
| Principal_Investigator_5_License_State_code5 |
The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
AL |
CHAR(2) |
string |
2 |
| Submitting_Applicable_Manu facturer_or_Applicable_GPO_Name |
Textual proper name of either the Submitting Applicable Manufacturer or Submitting Applicable Group Purchasing Organization (GPO). |
ABCDE Manufacturing |
VARCHAR2(100) |
string |
100 |
| Applicable_Manufacturer_or_ Applicable_GPO_Making_Pay ment_ID |
System generated unique identifier of the Applicable Manufacturer or Applicable Group Purchasing Organization (GPO) Making payment or other transfer of value |
1000000049 |
NUMBER(38,0) |
number |
38 |
| Applicable_Manufacturer_or_ Applicable_GPO_Making_Pay ment_Name |
Textual proper name of the applicable manufacturer or applicable GPO making the payment or other transfer of value |
ABCDE Manufacturing |
VARCHAR2(100) |
string |
100 |
| Applicable_Manufacturer_or_ Applicable_GPO_Making_Pay ment_State |
State name of the submitting applicable manufacturer or submitting applicable GPO as provided in Open Payments |
VA |
CHAR(2) |
string |
2 |
| Applicable_Manufacturer_or_ Applicable_GPO_Making_Pay ment_Country |
Country name of the Submitting Applicable Manufacturer or Submitting Applicable Group Purchasing Organization (GPO) as provided in Open Payments |
United States |
VARCHAR2(100) |
string |
100 |
| Related_Product_Indicator |
Indicator allows the applicable manufacturer or applicable GPO to select whether the payment or other transfer of value is related to one or more product(s) (drugs, devices, biologicals, or medical supplies). If the payment was not made in relation to a product, select "No". If the payment was related to one or more product, select "Yes". |
Y |
VARCHAR2(100) |
string |
100 |
| Covered__Noncovered_Indicator_1 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
Covered |
VARCHAR2(100) |
string |
100 |
| Indicate_Drug_or_Biological_ or_Device_or_Medical_Supply_1 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
Drug |
VARCHAR2(100) |
string |
100 |
| Product_Category_or_Therapeutic_Area_1 |
Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
Endocrinology |
VARCHAR2(100) |
string |
100 |
| Name_of_Drug_or_Biological _or_Device_or_Medical_Supply_1 |
The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
Sample Drug 1 |
VARCHAR2(500) |
string |
500 |
| Drug_or_Biological_NDC_1 |
The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
3698-7272-61 |
VARCHAR2(100) |
string |
12 |
| Device_or_Medical_Supply_PDI_1 |
The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
0084865700026 0 |
VARCHAR(100) |
string |
100 |
| Covered__Noncovered_Indicator_2 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
Covered |
VARCHAR2(100) |
string |
100 |
| Indicate_Drug_or_Biological_or_Device_or_Medical_Supply_2 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
Device |
VARCHAR2(100) |
string |
100 |
| Product_Category_or_Therapeutic_Area_2 |
Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
Endocrinology |
VARCHAR2(100) |
string |
100 |
| Name_of_Drug_or_Biological _or_Device_or_Medical_Supply_2 |
The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
Sample Drug 2 |
VARCHAR2(500) |
string |
500 |
| Drug_or_Biological_NDC_2 |
The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
36987-272-62 |
VARCHAR2(100) |
string |
12 |
| Associated_Device_or_Medical_Supply_PDI_2 |
The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
0084865700026 0 |
VARCHAR(100) |
string |
100 |
| Covered_or_Noncovered_Indicator_3 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
Covered |
VARCHAR2(100) |
string |
100 |
| Indicate_Drug_or_Biological_ or_Device_or_Medical_Suppl y_ 3 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
Device |
VARCHAR2(100) |
string |
100 |
| Product_Category_or_Therapeutic_Area_3 |
Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
Endocrinology |
VARCHAR2(100) |
string |
100 |
| Name_of_Drug_or_Biological _or_Device_or_Medical_Supply_3 |
The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
Sample Drug 3 |
VARCHAR2(500) |
string |
500 |
| Associated_Drug_or_Biological_NDC_3 |
The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
36987-2726-3 |
VARCHAR2(100) |
string |
12 |
| Associated_Device_or_Medical_Supply_PDI_3 |
The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
0084865700026 0 |
VARCHAR(100) |
string |
100 |
| Covered_or_Noncovered_Indicator_4 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
Covered |
VARCHAR2(100) |
string |
100 |
| Product_Category_or_Therapeutic_Area_4 |
Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
Endocrinology |
VARCHAR2(100) |
string |
100 |
| Name_of_Drug_or_Biological_or_Device_or_Medical_Supply_4 |
The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
Sample Drug 4 |
VARCHAR2(500) |
string |
500 |
| Associated_Drug_or_Biological_NDC_4 |
The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
3698-7272-64 |
VARCHAR2(100) |
string |
12 |
| Associated_Device_or_Medical_Supply_PDI_4 |
The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
0084865700026 0 |
VARCHAR(100) |
string |
100 |
| Covered_or_Noncovered_Indicator_5 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
Covered |
VARCHAR2(100) |
string |
100 |
| Indicate_Drug_or_Biological_or_Device_or_Medical_Supply_5 |
For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
Drug |
VARCHAR2(100) |
string |
100 |
| Product_Category_or_Therapeutic_Area_5 |
Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
Endocrinology |
VARCHAR2(100) |
string |
100 |
| Name_of_Drug_or_Biological_or_Device_or_Medical_Supply_5 |
The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
Sample Drug 5 |
VARCHAR2(500) |
string |
500 |
| Associated_Drug_or_Biological_NDC_5 |
The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
36987-2726-5 |
VARCHAR2(100) |
string |
12 |
| Associated_Device_or_Medical_Supply_PDI_5 |
The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
0084865700026 0 |
VARCHAR(100) |
string |
100 |
| Total_Amount_of_Payment_ USDollars |
U.S. dollar amount of payment or transfer of value to recipient (manufacturer must convert to dollar currency if necessary). |
2016 |
NUMBER(12,2) |
decimal |
12 |
| Date_of_Payment |
If a singular payment, then this is the actual date the payment was issued; if a series of payments or an aggregated set of payments, this is the date of the first payment to the covered recipient in this program year |
06/30/2017 |
DATE |
Date MM/D D/ YYYY |
12 |
| Form_of_Payment_or_Transfer_of_Value |
The method of payment used to pay the covered recipient or to make the transfer of value. |
In-kind items and services |
VARCHAR2(100) |
string |
100 |
| Expenditure_Category1 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Expenditure_Category2 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Expenditure_Category3 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Expenditure_Category4 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Expenditure_Category5 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Expenditure_Category6 |
Contextual category for this research payment or other transfer of value |
Patient Care |
VARCHAR2(50) |
string |
50 |
| Preclinical_Research_Indicator |
An indicator showing if payment or other transfer of value is related to research, which is pre-clinical |
Yes |
CHAR(3) |
string |
3 |
| Delay_in_Publication_Indicator |
An indicator showing if an applicable manufacturer or applicable GPO is requesting a delay in publication of a payment or other transfer of value when the payment or other transfer of value is made in connection with: (1) research on or development of a new product (drug, device, biological, or medical supply) or (2) clinical investigation regarding a new product (drug, device, biological, or medical supply) |
No |
CHAR(3) |
string |
3 |
| Name_of_Study |
The textual name of the study for which the covered recipient is receiving this payment or other transfer of value. The textual name of the study for which the covered recipient is receiving this payment or other transfer of value |
A Comparison of the Heart |
VARCHAR2(500) |
string |
500 |
| Dispute_Status_for_Publication |
Indicates whether the payment or other transfer of value is disputed by the covered recipient or not |
Yes |
CHAR(3) |
string |
3 |
| Record_ID |
System assigned identifier to the research transaction at the time of submission |
100000000023 |
NUMBER(38,0) |
number |
38 |
| Program_Year |
The year in which the payment occurred, as reported by submitting entity. |
2016 |
CHAR(4) |
number |
4 |
| Payment_Publication_Date |
The predefined date when the payment or other transfer of value is scheduled to be published |
06/30/2017 |
DATE |
Date MM/DD/YYYY |
12 |
| ClinicalTrials_Gov_Identifier |
Identifier assigned if research study is registered on clinicaltrials.gov |
NCT21498631 |
VARCHAR2(11) |
string |
11 |
| Research_Information_Link |
Optional link to information relevant to the research study for which this payment or other transfer of value is being reported (there can be a maximum of five links reported) |
Research |
VARCHAR2(2083) |
string |
2083 |
| Context_of_Research |
Textual description of research context or research objectives |
Objective is new designs for heart valve replacements |
VARCHAR2(500) |
string |
500 |