	US 12,147,570 B2
	Simultaneously administering user accounts in two related information systems, such as an EMR and a separate health system single signon system
Trevor A. Harms, Surrey (CA); Tripurari Dash, Hyderabad (IN); Robin Kang, Prosper, TX (US); Colin M. Dere, Calgary (CA); Lisa D. Mason, Newcastle, WA (US); and Sainikhil Manda, Hyderabad (IN)
Assigned to Praia Health Inc., Renton, WA (US)
Filed by Providence St. Joseph Health, Seattle, WA (US)
Filed on Feb. 3, 2023, as Appl. No. 18/164,190.
Prior Publication US 2024/0265129 A1, Aug. 8, 2024
Int. Cl. G06F 21/62 (2013.01); G16H 10/60 (2018.01)

CPC G06F 21/6245 (2013.01) [G16H 10/60 (2018.01)]

18 Claims

1. A method in a computing system, comprising:

receiving a query containing identifying information for a person;

in response to receiving the query:

processing the query against at least one first table in which each row corresponds to a different EMR account established on an EMR instance operated by a health system, and further containing an EMR record identifier identifying an EMR record on the EMR instance that the EMR account is authorized to access, to obtain a first result identifying any rows of the first table matching the query;

processing the query against a second table in which each row corresponds to a different health system account established by the health system to obtain a second result identifying any rows of the second table matching the query;

obtaining an augmented query by, for each row of the second table identified by the second result:

extracting from the row of the second table a health system account identifier;

adding the extracted a health system account identifier to the query;

processing the augmented query against a third table in which each maps a different combination of a health system account identifier and an EMR instance to an EMR record identifier identifying an EMR record on the EMR instance that the health service account is authorized to access, to obtain a third result identifying any rows of the third table matching the augmented query;

for each row of the first table identified by the first result:

where the EMR record identifier of the row of the first table matches the EMR record identifier of any row of the third table identified by the third result:

constructing a first entry comprising both information from the row of the first table and information from the row of the third table whose EMR record identifier matches and/or the row of the second table having the same health system account identifier as the row of the third table whose EMR record identifier matches;

where the EMR record identifier of the row of the first table does not match the EMR record identifier of any row of the third table identified by the third result:

constructing a second entry comprising information from the row of the first table;

for each row of the third table identified by the third result:

where no first entry contains information from the row of the third table:

constructing a third entry comprising information from the row of the third table and/or the row of the second table having the same health system account identifier as the row of the third table whose EMR record identifier matches;

causing the constructed entries to be displayed; and

soliciting user input selecting one of the displayed entries for administrative action.