Converting tabular demographic information into an export entity file
The present disclosure is directed to methods and non-transitory program storage devices for identifying demographic information in an input data file and converting that data into autonomous data of an export entity file. In an embodiment, the received tabular data is sorted based on a lowest number of unique entities of a certain type in the revised data file, common data describing the lowest number of unique entities is extracted, labeled, and stored as an autonomous export entity file. In an embodiment a plurality of autonomous export entities are linked to create a master export entity comprising the plurality of autonomous export entities.
1 . A computer-implemented method, comprising:
converting, by one or more computing devices, data in a data file into an export entity, wherein the converting comprises:
sorting the data based on identifying a lowest number of unique entities associated with a type,
extracting common data associated with the lowest number of unique entities,
labeling the common data as describing a single entity,
in response to the labeling, storing the extracted common data as an autonomous entity under a label of the labeled common data, and
linking a plurality of single entities to generate the export entity; and
combining, by the one or more computing devices, one or more export entities converted from the data into a combined file.
2 . The computer-implemented method of claim 1 , wherein the data is from a healthcare provider and the data file containing a plurality of fields of demographic information is a medical roster.
3 . The computer-implemented method of claim 1 , further comprising detecting, by the one or more computing devices, the type for one of a plurality of fields of demographic information.
4 . The computer-implemented method of claim 1 , further comprising extracting, by the one or more computing devices, the common data into a language-independent format.
5 . The computer-implemented method of claim 1 , wherein linking the plurality of single entities is performed via a pointer, a logical connection between entities, or data describing a first entity that is embedded within data describing a second entity.
6 . The computer-implemented method of claim 1 , further comprising storing, by the one or more computing devices, a transaction record of each of the converting, sorting, extracting, labeling, and linking steps in an auditable persistent file.
7 . The computer-implemented method of claim 1 , further comprising comparing, by the one or more computing devices, the combined file with an existing second combined file to determine a difference between the combined file and the existing second combined file.
8 . A system, comprising:
a memory; and
at least one processor coupled to the memory and configured to perform operations comprising:
converting data in a data file into an export entity, wherein the converting comprises:
sorting the data based on identifying a lowest number of unique entities associated with a type,
extracting common data associated with the lowest number of unique entities,
labeling the common data as describing a single entity,
in response to the labeling, storing the extracted common data as an autonomous entity under a label of the labeled common data, and
linking a plurality of single entities to generate the export entity; and
combining one or more export entities converted from the data into a combined file.
9 . The system of claim 8 , wherein the data is from a healthcare provider and the data file containing a plurality of fields of demographic information is a medical roster.
10 . The system of claim 8 , wherein the operations further comprise detecting the type for one of a plurality of fields of demographic information.
11 . The system of claim 8 , wherein the operations further comprise extracting the common data into a language-independent format.
12 . The system of claim 8 , wherein linking the plurality of single entities is performed via a pointer, a logical connection between entities, or data describing a first entity that is embedded within data describing a second entity.
13 . The system of claim 8 , wherein the operations further comprise storing a transaction record of each of the converting, sorting, extracting, labeling, and linking steps in an auditable persistent file.
14 . The system of claim 8 , wherein the operations further comprise comparing the combined file with an existing second combined file to determine a difference between the combined file and the existing second combined file.
15 . A non-transitory program storage device having instructions stored thereon that, when executed by at least one computing device, causes the at least one computing device to perform operations comprising:
converting data in a data file into an export entity, wherein the converting comprises:
sorting the data based on identifying a lowest number of unique entities associated with a type,
extracting common data associated with the lowest number of unique entities,
labeling the common data as describing a single entity,
in response to the labeling, storing the extracted common data as an autonomous entity under a label of the labeled common data, and
linking a plurality of single entities to generate the export entity; and
combining one or more export entities converted from the data into a combined file.
16 . The non-transitory program storage device of claim 15 , wherein the data is from a healthcare provider and the data file containing a plurality of fields of demographic information is a medical roster.
17 . The non-transitory program storage device of claim 15 , wherein the operations further comprise extracting the common data into a language-independent format.
18 . The non-transitory program storage device of claim 15 , wherein linking the plurality of single entities is performed via a pointer, a logical connection between entities, or data describing a first entity that is embedded within data describing a second entity.
19 . The non-transitory program storage device of claim 15 , wherein operations further comprise storing a transaction record of each of the converting, sorting, extracting, labeling, and linking steps in an auditable persistent file.
20 . The non-transitory program storage device of claim 15 , wherein operations further comprise comparing the combined file with an existing second combined file to determine a difference between the combined file and the existing second combined file.