Data Dictionary
matheagle91 edited this page Jan 18, 2018
·
3 revisions
Defines a credentials that are to be used to submit or query the IIS Kernel.
- org_access_id : Unique database identifier, auto generated
- org_id : Foreign key to connect to Org Master table
- access_name : Credential username
- access_key : Credential password
Defines an institution
- org_id : Unique database identifier, auto generated
- organization_name : Designation of the institution
Defines a unique person
- patient_id : Unique database identifier, auto generated
- patient_external_link : Unique identifier generated for the registry
- patient_name_last : Person's family designation
- patient_name_first : Person's personal designation
- patient_name_first : Person's second personal designation
- patient_birth_date : When the person was born
- patient_phone_frag : Fraction of person's telephone number (last 7 digits)
- patient_address_frag : Fraction of where the person lives (first five digits of zip code : number of street address)
- patient_soundex_last :
- patient_soundex_first :
Defines record of a person from one of the organizations that the person has visited
- patient_reported_id : Unique database identifier, auto generated
- org_reported_id : Foreign key to connect to Org Master table
- patient_reported_external_link : Unique identifier for that the organization uses to identify the person
- patient_id : Foreign key to connect to Patient Master table
- patient_data : HL7 having to do with the person
- reported_date : When the data is submitted
- updated_date : When the data was last modified
Defines if two reported people are in fact the same person
Defines a specific instance of an immunization being given
- vaccination_id : Unique database identifier, auto generated
- patient_id : Foreign key to connect to Patient Master table (which person received the immunization)
- administered_date : When the vaccination was given
- vaccine_cvx_code : Identifier that describes which immunization was given
- vaccination_reported_id : Foreign key to connect to Vaccination Reported table
Defines a record of an immunization shot being given
- vaccination_reported_id : Unique database identifier, auto generated
- patient_reported_id : Foreign key to connect to Patient Master table (which recorded person received the vaccine)
- vaccination_reported_external_link : Unique identifier for that the organization uses to identify the immunization
- vaccination_id : Foreign key to connect to Vaccination Master table
- vaccination_data : HL7 having to do with the immunization
- reported_date : When the data is submitted
- updated_date : When the data was last modified