Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
66 Cards in this Set
- Front
- Back
|
ATNA |
(Audit Trail and Node Authentication) gives security through fictional access control, defined security audit logging and secure network communication |
|
|
PIX |
(Patient Identifier Cross Reference)-use of patient identifiers to cross reference with hospitals and HIE |
|
|
XCA |
(Cross community Acess)- allows to query and retrieve patient EHrs held by other communities like independent HiE's |
|
|
XDS |
(Cross Enterprise Document sharing)- shares and discovers EHR documents between health care enterprises, physician offices, clinics and personal health records |
|
|
Current Capabilities of HIE |
-it can send "test" patient ADT's such as patient name, DOB, SSN from EHR to both HIE -it can create a MPI in each HIE -Create and send patient CCD from EHR to HIe and vice verse -transmit lab orders from eCW EHR to labcorp -and it can send immunization records |
|
|
ICA-North Texas-Athena |
-this lab consist of a test patient being registered in Athena in which the patient demographics is sent to ICA HIE - will include local and global I'd from Athena and ICA -once the patient progress note is signed, Athena does a PIX (patient identifier cross reference) with ICA and sends the XML based CCD to the HIe - |
|
|
ICA with eCW |
-the patient demographics and CCD is sent to eCW to the ICA -once the patient is registered and consents are signed, eCW provides those documents to ICA -ICA uses DETERMINISTIC matching to lol the eCW pt info to pt in ICA MPI -this results in the MPI to include both pt info from both practices with both ID - once the patient note is locked, PIC sends the XML CCD thru eCW server |
|
|
Interoperability with labcorp and evw |
To send the order to labcorp via HL7 ORM message
To receive the date is thru ORU message |
|
|
North Texas HIe |
-it's a centralized model and based on deterministic matching
|
|
|
North Texas HIe |
-it's a centralized model and based on deterministic matching
|
|
|
How is data transferred in the HIE? |
-information is transferred through HL7 and the IHE |
|
|
North Texas HIe |
-it's a centralized model and based on deterministic matching
|
|
|
How is data transferred in the HIE? |
-information is transferred through HL7 and the IHE |
|
|
What are the two data transmission security? |
TLs and VPn |
|
|
What is HL7? |
It is a standard that defines message standard for transmitting health info
-commonly used with patient demographics, orders and results |
|
|
What is HL7? |
It is a standard that defines message standard for transmitting health info
-commonly used with patient demographics, orders and results |
|
|
Who initiated the integration of IHE? |
Healthcare professionals and industry initiated this to improve computer systems sharing health info |
|
|
What is SQL used for? |
Used to access and manipulate data |
|
|
What is SQL used for? |
Used to access and manipulate data |
|
|
What is RDBMS(relational database management system)? |
A software that stores and manipulates data that are in relational database tables |
|
|
What is SQL used for? |
Used to access and manipulate data |
|
|
What is RDBMS(relational database management system)? |
A software that stores and manipulates data that are in relational database tables |
|
|
What is DQL( Data query language)? |
Select or retrieve |
|
|
What is SQL used for? |
Used to access and manipulate data |
|
|
What is RDBMS(relational database management system)? |
A software that stores and manipulates data that are in relational database tables |
|
|
What is DQL( Data query language)? |
Select or retrieve |
|
|
What is DML(data manipulation language? |
Insert, update or delete |
|
|
What is SQL used for? |
Used to access and manipulate data |
|
|
What is RDBMS(relational database management system)? |
A software that stores and manipulates data that are in relational database tables |
|
|
What is DQL( Data query language)? |
Select or retrieve |
|
|
What is DML(data manipulation language? |
Insert, update or delete |
|
|
What is DDL(data definition language)? |
Create or alter or drop |
|
|
What is DCL ( data control language)? |
Grant(assign) or revoke/ remove |
|
|
What is a database? |
Collection of related tables
Also known as relational database! |
|
|
What is a database? |
Collection of related tables
Also known as relational database! |
|
|
What is a key? |
It's a group of values that are unique and they are underlines such as MRN, SSN |
|
|
What is a database? |
Collection of related tables
Also known as relational database! |
|
|
What is a key? |
It's a group of values that are unique and they are underlines such as MRN, SSN |
|
|
What is a primary key? |
It a field/fields whose values are unique and are used to identify a row |
|
|
What is a database? |
Collection of related tables
Also known as relational database! |
|
|
What is a key? |
It's a group of values that are unique and they are underlines such as MRN, SSN |
|
|
What is a primary key? |
It a field/fields whose values are unique and are used to identify a row |
|
|
What is a foreign key? |
A primary key of one relation that is placed in a second relation
-basically it is the primary key that is in a second table to link them together which makes it a foreign key |
|
|
What is a field? |
Different categories in a table |
|
|
What is data types? |
Properties of each field and the field can only have one data type |
|
|
What is data types? |
Properties of each field and the field can only have one data type. It tells what you are trying to store and sets values and operations defined on those values.
-basically the computer has to be told what kind of data each field is so that it stores and retrieved correctly
-ex: name, debit card # |
|
|
What is normalization? |
The process of organizing data to reduce redundancy.
|
|
|
What is a reason not to normalize? |
It takes the system longer to retrieve data linked (joined) across multiple tables. |
|
|
What are the uses for SQL? |
To modify the structure of the database using DDL and working with the content of the database using DML |
|
|
What does SELECT mean? |
Retrieve data from DB |
|
|
What are the DDL commands? |
Create, alter(modify), drop(delete) |
|
|
What are DML commands? |
Select(retrieve) and join |
|
|
What is the syntax to select records from a table "patients"? |
Select* From patient |
|
|
What is the syntax to determine the average age in a table "student"? |
Select average From student |
|
|
What is a wildcard? |
A wildcard character can be substituted for any other character
%= 0 to many character. For example looking for smith, '%smith%' gives all patients with smith anywhere in their last name where as 'Smith' only gives you exact patients with that exact last name |
|
|
What is Where? |
Used to get a specific result or find specific patients with a last name. Example
Select* From patients Where patients last name like 'smith'; |
|
|
How to create a SQL database? |
Use, drop table, create |
|
|
What is an attribute? |
Name, DOB, MRN, basically things that can link to a person |
|
|
What are the 2 types identifiers? |
Things that are linked to a patient.
Unique: SSN Non unique:last name |
|
|
What is referential integrity? |
It ensures that the relationship between two table remains synchronized through updates and deletes. |
|
|
What safeguard can be used in creating a table to reduce the possibility of duplicate data? |
Normalization |
|
|
When would a composite identifier be required? |
Could be used when looking for a patient. Always uses 2 or more attributes such as name and DOB |
|
|
When do you know that a table is normalized? |
When there is something that is the same in both tables |
|
|
What is an example of a one to one relationship? |
Where 1 patient has a driver license number and only that driver license number can belong to them.
SAN |
|
|
What is an example of a one to many relationship? |
1 patient can have many clinic visits, many drugs, and many dx |
|
|
What is an example of many to many relationship? |
1 patient can have many doctors and those doctors can have many patients |
