Relationships:
1. cc_patient_info has a one to one relationship with cc_patient_demographics
2. cc_patient_info has multiple cc_patient_protocol_history entries
3. cc_patient_info has multiple cc_patient_visit entries
4. cc_patient_info has multiple cc_visit_researcher entries
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| pi_master_pat_index | Master Patient Index | int | Owned Key |
| pi_last_name | Last Name | varchar(25) | Owned Non-key |
| pi_middle_initial | Middle Name | varchar(15) | Owned Non-key |
| pi_first_name | First Name | varchar(25) | Owned Non-key |
| pi_suffix | Suffix | varchar(15) | Owned Non-key |
| pi_gender | Gender | char(1) | Owned Non-key |
| pi_ethnicity | Ethnicity | char(1) | Owned Non-key |
| pi_date_of_birth | Date OF Birth | datetime | Owned Non-key |
| pi_mis_name | Full MIS Name, necessary because name must be massaged and based on type-in inconsistencies wanr to make sure system matches. | varchar(39) | Owned Non-key |
| pi_active_flag | Active/Inactive Patient | char(1) | Owned Non-key |
| pi_patient_mrn | Patient Medical Record Number | char(10) | Owned Non-key |
| pi_database_no | Database Number (also referred to as Hospital ID) | char(2) | Owned Non-key |
| pi_pdf_no | PDF Number (Also referred to as MIS System ID) | char(6) | Owned Non-key |
| pi_last_date_modified | Date last modified | datetime | Owned Non-key |
| pv_visit_id | Last Visit ID | int | Owned Non-key |
Relationships:
1. cc_patient_demographics has a one to one relationship with cc_patient_demographics
2. cc_patient_demographics has multiple cc_patient_protocol_history entries
3. cc_patient_demographics has multiple cc_patient_visit entries
4. cc_patient_demographics has multiple cc_visit_researcher entries
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| pi_master_pat_index | Patient Master Index | int | Foreign Key |
| pd_street | Street | char(25) | Owned Non-key |
| pd_city | City | char(21) | Owned Non-key |
| pd_state | State | char(2) | Owned Non-key |
| pd_zip | Zip | char(5) | Owned Non-key |
| pd_country | Country | char(23) | Owned Non-key |
| pd_home_phone | Home Phone | char(12) | Owned Non-key |
| pd_ssn | Social Security Number | char(11) | Owned Non-key |
| pd_religion | Religion | char(20) | Owned Non-key |
| pd_death_code | Death Code, need to determine values | char(1) | Owned Non-key |
| pd_mothers_name | Mother's Maiden Name | char(21) | Owned Non-key |
| pd_last_date_modified | Last Date Modified | datetime | Owned Non-key |
Relationships:
1. cc_patient_info has multiple cc_patient_protocol_history entries
2. cc_patient_demographics has multiple cc_patient_protocol_history entries
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| pi_master_pat_index | Patient Master Index | int | Foreign Key |
| pi_patient_mrn | Patient MRN | char(10) | Owned Non-key |
| ph_primary_flag | Flag to indicate primary versus secondary (P,A) | char(1) | Owned Non-key |
| ph_typed_protocol | Protocol Number provided by admissions | char(10) | Owned Non-key |
| ph_protocol_id | Numeric Representation of Protocol | int | Owned Non-key |
| ph_corrected_protocol | Protocol Number with corrected format of a four digit sequence number | char(10) | Owned Non-key |
| ph_assigned_date | Start Date on Protocol | datetime | Owned Non-key |
| ph_removed_date | End Date on Protocol | datetime | Owned Non-key |
Relationships:
1. cc_patient_info has multiple cc_patient_visit entries
2. cc_patient_demographics has multiple cc_patient_visit entries
3. cc_patient_visit has multiple cc_visit_researcher entries
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| pv_visit_id | Visit Sequence ID | int | Owned Key |
| pi_master_pat_index | Patient Master Index | int | Foreign Non-key |
| pv_admission_date | Admission Date | datetime | Owned Non-key |
| pv_discharge_date | Discharge Date | datetime | Owned Non-key |
| pv_institute | Institute | char(2) | Owned Non-key |
| pv_branch | Branch | char(2) | Owned Non-key |
| pv_nursing_unit | Nursing Unit | char(6) | Owned Non-key |
| pv_bed | Bed | char(6) | Owned Non-key |
| pv_admit_diagnosis | Admitting Diagnosis | varchar(52) | Owned Non-key |
| pv_primary_protocol | Primary Protocol | char(10) | Owned Non-key |
| pv_last_date_modified | Last Modified Date | datetime | Owned Non-key |
Relationships:
1. cc_researcher_info has one record for multiple cc_visit_researcher entries.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| ri_sequence_id | Researcher unique identification number. | numeric(9) | Owned Key |
| ri_last_name | Researcher Last Name. | varchar(30) | Owned Non-key |
| ri_first_name | Researcher First Name. | varchar(30) | Owned Non-key |
| ri_middle_initial | Researcher Middle Initial | char(1) | Owned Non-key |
| ri_suffix | Researcher suffix. | varchar(9) | Owned Non-key |
| ri_prof_designation | Researcher Professional Designation. | varchar(9) | Owned Non-key |
| ri_institute | Researcher Institute affiliation. | char(2) | Owned Non-key |
| ri_branch | Researcher branch affiliation. | char(2) | Owned Non-key |
| ri_office_address | Researcher NIH Address for internal researchers. Street Address1 for external researchers. | varchar(30) | Owned Non-key |
| ri_office_phone | Researcher Office Phone. | varchar(14) | Owned Non-key |
| ri_office_fax | Researcher Office Fax. | varchar(14) | Owned Non-key |
| ri_email_address | Researcher email address. | varchar(80) | Owned Non-key |
| ri_full_name | Researcher Full Name. | varchar(60) | Owned Non-key |
| ri_last_date_modified | Last date this entry was updated in the system. | smalldatetime | Owned Non-key |
| ri_office_address_addition | Street Address 2. | varchar(30) | Owned Non-key |
| ri_office_address_city | City | varchar(30) | Owned Non-key |
| ri_office_address_state | State | varchar(30) | Owned Non-key |
| ri_office_address_zip | Zip | varchar(10) | Owned Non-key |
| ri_speciality | Speciality of Researcher | varchar(30) | Owned Non-key |
Relationships:
1. cc_researcher_info has one record for multiple cc_visit_researcher entries
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| pv_visit_id | Patient Visit ID | int | Foreign Non-key |
| ri_researcher_id | Researcher ID | numeric | Foreign Non-key |
| vr_researcher_role | Physician Role (A=Attending, S=Senior Authorizing, R=Referring, ...) | varchar(80) | Owned Non-key |
| pi_master_pat_index | Patient Master Index | int | Foreign Non-key |
| vr_last_date_modified | Last date this entry was updated in the system. | smalldatetime | Owned Non-key |
Relationships:
1. cc_visit_researcher has one cc_researcher_role_lookup.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| role_id | Numeric ID | int | Foreign key |
| role_desc | Physician Role (A=Attending, S=Senior Authorizing, R=Referring, ...) | varchar(30) | Owned Non-key |