US20040139076A1 - Method of communicating data between computers having different record formats - Google Patents
Method of communicating data between computers having different record formats Download PDFInfo
- Publication number
- US20040139076A1 US20040139076A1 US10/333,897 US33389703A US2004139076A1 US 20040139076 A1 US20040139076 A1 US 20040139076A1 US 33389703 A US33389703 A US 33389703A US 2004139076 A1 US2004139076 A1 US 2004139076A1
- Authority
- US
- United States
- Prior art keywords
- record
- format
- transmitter
- server
- computer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
Definitions
- the present invention relates to a method of communicating and converting data of different formats between databases having different designs.
- a medical service provider has database software installed on a general purpose computer for maintaining for each patient serviced by the medical service provider one or more electronic records.
- Each of these records includes data regarding a patient, such as notes regarding the patient's condition, services rendered on a particular date by the medical service provider for the patient, fees associated with one or more of the rendered services, and the like.
- This data is often maintained for each patient of the medical service provider as an electronic patient record in the database which has been designed specifically by or for the medical service provider.
- Insurers also have database software installed on a computer for creating and maintaining for each insured patient one or more electronic patient records that include some or all of the same information as the electronic patient record maintained by the patient's medical service provider.
- electronic patient records of a medical service provider often have a different design than the electronic patient records of a particular patient's insurer.
- an insurer In order to account for the differences in design of the database of a medical service provider and the design of the database of an insurer for a patient, an insurer often provides the medical service provider with data entry software which enables the medical service provider to electronically enter data regarding a patient into an interface screen and thereafter forward this entered data to the insurer for processing. More specifically, this data entry software is configured to receive the data into predetermined fields, including one or more patient identification fields, of a record for the particular patient. Once data is entered into these predetermined fields, the software program formats the entered data into a form that the database software of the patient's insurer is expecting and electronically transfers the formatted data to the database software of the patient's insurer for processing.
- a problem with such data entry software is that the medical service provider, in addition to entering data regarding a patient into their own database, needs to enter some or all of the same patient data into the data fields of the data entry software so that this data can be processed by the particular patient's insurer.
- a medical service provider is sending data regarding patients to a plurality of different insurers, a plurality of different data entry software must be maintained by the medical service provider and utilized to effect entry and transfer of patent data to each insurer.
- a problem with this arrangement is the need for the medical service provider to acquire the appropriate data entry software for the insurer of a particular patient and the need for the medical service provider to redundantly enter data into the medical service provider's database and the data entry software.
- Another problem is that a medical service provider may be required to become familiar with more than one data entry software.
- an object of the present invention to overcome the above problems and others by providing a method of communicating data across a distributed computer network between computer systems having different record formats.
- a server comprised of conversion routines configured to convert patient records from one format into another format.
- a record format used by a transmitter database is sent by the transmitter to an intermediary server.
- the server selects the appropriate conversion routine by determining who is the transmitter of the record and who is the receiver of the record.
- the medical service provider record may explicitly indicate to the server which conversion routine is to be used.
- the actual conversion entails manipulations including, but not limited to literal transformations, truncations, and concatenations of record components, such as description fields, data fields, and datatype fields.
- the insurer may transmit back to the medical service provider, through the server, an acknowledgement in the form of a record.
- the server converts the record format used by the insurer database into a record format compatible with the medical service provider database.
- the server transmits the converted acknowledgement record to the medical service provider for processing in the medical service provider database.
- the present invention can also be used for data transfer between other entities having incompatible data records.
- the use of the present invention can be enhanced to include transfer of data to and from data records of employers of insured patients, an insurance broker and/or sub-broker, and other insurance group programs.
- the data can be transmitted to multiple successive conversion servers prior to the data reaching its ultimate receiver. It should be further appreciated that the data can also be transferred to more than one server, in order to arrive at multiple receivers for processing.
- FIG. 1 is a schematic drawing of service providers, insurers, and a server communicating with each other across a distributed computer network;
- FIG. 2 is a block diagram representing the exchange of data from a service provider database to a insurance database through the server;
- FIG. 3 is a block diagram of the server
- FIG. 4 is block diagram of an incoming packet directed to the server from a service provider database
- FIG. 5 is a block diagram of the transmitter-receiver conversion matrix of the server
- FIG. 6 is a block diagram of an alternative incoming packet directed to the server from a service provider database
- FIG. 7 is a block diagram of an outgoing packet directed to the first insurer database from a server.
- FIG. 8 is a block diagram representing the exchange of data from an insurer database to a service provider database through the server.
- a party or patient 2 covered by medical insurance issued by an insurer 14 , 16 , . . . , 18 receives services from one or more medical service providers 4 , 6 , . . . , 8 , such as a doctor or physician, a hospital, a medical laboratory, and the like.
- the present invention connects each service provider, 4 , 6 , . . . , 8 and each insurer 14 , 16 , . . . , 18 to the Internet 20 and provides a server 22 connected to Internet 20 .
- Each medical service provider, 4 , 6 , . . . , 8 and each insurer 14 , 16 , . . . , 18 is provided with software which directs Internet communications related to a patient record through server 22 for processing, and more specifically, conversion from a first record format to a second record format, and vice versa.
- FIG. 2 and continuing reference to FIG. 1 when a service is rendered to a patient, the service provider rendering the service typically forwards to the patient's insurer a claim for the service rendered.
- first service provider 4 provides a specific health service to patient 2
- first service provider 4 will forward to first insurer 14 information regarding the rendered service.
- this process is initiated by having first service provider 4 enter patient data into a database 24 of first service provider 4 .
- Information concerning each patient is stored in a record 26 a of database 24 .
- Record 26 a is comprised of a plurality of related fields, e.g., related field 28 which includes a description field 28 a, e.g., Patient_ID; data field 28 b, e.g. social security number; and datatype field 28 c, e.g., long int.
- Database 24 is designed to have specific formats for datatype field 28 c thereby requiring data to conform to specific datatype formats in order to be compatible with record 26 a.
- first service provider 4 transmits record 26 a to an insurer, e.g., first insurer 14 .
- a transmitter-receiver layer 53 Prior to transmission of record 26 a, a transmitter-receiver layer 53 is associated with record 26 a.
- Transmitter-receiver layer 53 identifies the transmitter of record 26 a and the receiver of record 26 a.
- transmitter-receiver layer 53 includes the name and/or Internet Protocol (IP) address 5 of first service provider 4 and IP address 15 of first insurer 14 .
- IP Internet Protocol
- first service provider 4 transmits to server 22 a packet 60 a which includes record 26 a, transmitter-receiver layer 53 , and, in conformity with standard transmission conventions, an IP header 62 a designating a receiver IP address 23 of server 22 and transmitter IP address 5 of first service provider 4 , which are both utilized to route packet 60 a through Internet 20 to server 22 .
- server 22 is configured to convert a database record having one format into a database record having a different format. Accordingly, upon receiving packet 60 a from first service provider 4 , a packet sniffer 52 of server 22 separates the packet into its constituent parts, namely transmitter-receiver layer 53 and record 26 a. The transmitter-receiver layer 53 is then scanned by a transmitter-receiver conversion matrix 50 which determines who is the transmitter and who is the receiver.
- the transmitter-receiver conversion matrix 50 includes an X-Y grid where transmitters and receivers line the X-axis and Y-axis, respectively.
- a conversion routine capable of converting the record format of the transmitter database into a new record compatible with that of the receiver database.
- the conversion routine is then applied to the transmitter record. More specifically, the transmitter record's description fields, data fields, and datatype fields are converted into description fields, data fields, and datatype fields which match the record format of the receiver database.
- Conversion matrix 50 then scans transmitter-receiver layer 53 and determines that record 26 a was sent by first service provider 4 to be received by first insurer 14 .
- Transmitter-receiver conversion matrix 50 utilizes this information to identify a conversion routine 54 , which can convert the record format of database 24 of first service provider 4 into the record format of a database 34 of first insurer 14 .
- Conversion routine 54 and record 26 a are passed to a convert function 56 for processing. Convert function 56 then applies conversion routine 54 to record 26 a.
- record 26 a therefore has description field 28 a, “Patient_ID”, data field 28 b “ 123456789”, and datatype field 28 c which indicates that data field 28 b is of type long int.
- record 26 b of first insurer 14 does not follow the naming and/or data conventions of record 26 a. Namely, record 26 b has a description field 38 a “SSN”, a corresponding data field 38 b “ 123-45-6789”, and datatype field 38 c which indicates that data field 38 b of first insurer 14 is of type custom format.
- convert function 56 executes conversion routine 54 to convert description field 28 a “Patient_ID” into description field 38 a “SSN.”
- datatype field 28 c of record 26 a requires that data field 28 b for social security number “123456789” have a long integer format, whereas data field 38 b of insurer record 26 b is configured to receive this social security number in custom format, namely, with suitable hyphenation, i.e., “123-45-6789.”
- Convert function 56 converts social security number “123456789” in data field 28 b into social security number “123-45-6789” which is inserted into data field 38 b of record 26 b.
- Another example of a datatype field conversion is that of an integer 30 in record 26 a converted to a floating integer 40 in record 38 a.
- a packet 70 illustrates an alternative means of identifying the appropriate conversion routine, e.g., 54 , to apply to record 26 a of first service provider 4 .
- packet 70 can also include a conversion designator 63 .
- Conversion designator 63 expressly informs server 22 of the conversion routine, e.g., 54 , server 22 should use for conversion of record 26 a. Therefore, the transmitter-receiver conversion matrix 50 lookup is bypassed or eliminated.
- conversion routine 54 can also create new fields and manipulate existing fields in the patient record.
- record 26 a can have data field 29 containing an entry “John Q.”, thereby including both a first name and a middle initial within the same data field.
- Insurer record 26 b designates a first name and a middle initial using two separate data fields.
- Conversion routine 54 can separate data field 29 containing the entry “John Q.” into first name data 41 “John” and middle initial data 39 “Q.”
- Conversion routine 54 must then instantiate these new data fields within record 26 b of first insurer 14 to receive first name data 41 “John” and middle initial data 39 “Q.”.
- record 26 b needs to be transmitted to first insurer 14 for processing in database 34 .
- Standard Internet transmission protocol provide for the IP header of a data packet to be discarded upon successful transmission of the data packet between a transmitter and a receiver.
- the receiver is server 22 acting as an intermediary between a transmitter, e.g., first service provider 4 , and an ultimate receiver, e.g., first insurer 14 , for processing and converting the data packet into a different data packet, e.g., 62 b, to be transmitted to the ultimate receiver.
- server 22 Prior to processing the data packet, e.g., 60 a, server 22 would ordinarily discard the IP header, e.g., 62 a, thereby effectively removing any reference to the original transmitter and server 22 itself.
- the ultimate receiver now has no knowledge of the original transmitter, nor does server 22 have any knowledge of the ultimate receiver.
- the present invention addresses this problem through the use of transmitter-receiver layer 53 which retains with the data packet the transmitter IP address and the receiver IP address.
- IP header 62 a which was used to route packet 60 a to server 22 has been destroyed after successful transmission of packet 60 a to server 22 , thereby removing any reference to first service provider 4 from packet 60 a.
- the IP addresses contained in the transmitter-receiver layer 53 are static and remain in transmitter-receiver layer 53 from the moment first service provider 4 transmits record 26 a until first insurer 14 receives record 26 b.
- Server 22 can therefore create a new IP header 62 b using the IP addresses contained in transmitter-receiver layer 53 .
- server 22 determines the receiver IP address, e.g., IP address 15 of first insurer 14 , by scanning IP address 15 from transmitter-receiver layer 53 . IP address 15 is then designated as the receiver IP address in IP header 62 b. IP address 23 of server 22 is designated as the transmitter IP address in IP header 62 b. Accordingly, server 22 bundles record 26 b, the original transmitter-receiver layer 53 , and IP header 62 b, into an outgoing packet 60 b, as shown in FIG. 7. Packet 60 b is then routed from server 22 through Internet 20 to first insurer 14 .
- IP address 15 is then designated as the receiver IP address in IP header 62 b.
- IP address 23 of server 22 is designated as the transmitter IP address in IP header 62 b. Accordingly, server 22 bundles record 26 b, the original transmitter-receiver layer 53 , and IP header 62 b, into an outgoing packet 60 b, as shown in FIG. 7. Packet 60 b is then routed from server 22 through
- the insurer may wish to send an acknowledgement to the service provider informing the service provider that the patient claim has been received, approved, disapproved, that there is a request for additional information to justify a requested fee for a rendered service, and/or the like.
- FIG. 8 depicts the transmission of an acknowledgement 42 b in the form of a record 46 b from first insurer 14 to first service provider 4 .
- the transmission of record 46 b from first insurer 14 to first service provider 4 requires the transposition of the transmitter-receiver layer information, e.g.,the first insurer 14 is designated as the transmitter and the first service provider 4 is designated as the receiver.
- the first insurer 14 is designated as the transmitter and the first service provider 4 is designated as the receiver.
- a different conversion routine is applied to record 46 b.
- the transmitter-receiver conversion matrix 50 scans transmitter-receiver layer 53 as before, but this time, determines that the transmitter of record 46 b is insurer 14 and that the receiver is first service provider 4 . Accordingly, conversion matrix 50 selects and applies conversion routine 44 to record 46 b. This results in the conversion of the appropriate description fields, data fields, and datatype fields into description fields, data fields, and datatype fields which match the data format of database 24 of first service provider 4 . In the instant case, the acknowledgement field 42 b, of record 46 b is converted into an acknowledgement field 42 a of record 46 a.
- Server 22 determines the receiver IP address by scanning the receiver IP address from the transmitter-receiver layer, therefore having the receiver IP address designated as the receiver IP address in the IP header. Additionally, the IP address of the server 22 is designated as the transmitter IP address in the IP header. Accordingly, the outgoing packet from server 22 includes record 46 a, the transmitter-receiver layer, and the IP header. The outgoing packet is then routed from server 22 through Internet 20 to first service provider 4 . After first service provider 4 receives record 46 a from server 22 , first service provider database 24 updates its patient records accordingly.
- the present invention provides a method of communicating data across a distributing computer network between computer systems having different record formats.
- the present invention also provides a method for having IP addresses of a transmitter and a receiver accompanying a data packet to its intended destination while passing through one or more designated intermediate receivers.
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
Description
- 1. Field of the Invention
- The present invention relates to a method of communicating and converting data of different formats between databases having different designs.
- 2. Description of the Prior Art
- Typically, a medical service provider has database software installed on a general purpose computer for maintaining for each patient serviced by the medical service provider one or more electronic records. Each of these records includes data regarding a patient, such as notes regarding the patient's condition, services rendered on a particular date by the medical service provider for the patient, fees associated with one or more of the rendered services, and the like. This data is often maintained for each patient of the medical service provider as an electronic patient record in the database which has been designed specifically by or for the medical service provider.
- Insurers also have database software installed on a computer for creating and maintaining for each insured patient one or more electronic patient records that include some or all of the same information as the electronic patient record maintained by the patient's medical service provider. Unfortunately, however, electronic patient records of a medical service provider often have a different design than the electronic patient records of a particular patient's insurer. To this end, it is common practice for many medical service providers to treat numerous patient, each of whom may be insured by a different insurer having databases of different design.
- In order to account for the differences in design of the database of a medical service provider and the design of the database of an insurer for a patient, an insurer often provides the medical service provider with data entry software which enables the medical service provider to electronically enter data regarding a patient into an interface screen and thereafter forward this entered data to the insurer for processing. More specifically, this data entry software is configured to receive the data into predetermined fields, including one or more patient identification fields, of a record for the particular patient. Once data is entered into these predetermined fields, the software program formats the entered data into a form that the database software of the patient's insurer is expecting and electronically transfers the formatted data to the database software of the patient's insurer for processing.
- A problem with such data entry software is that the medical service provider, in addition to entering data regarding a patient into their own database, needs to enter some or all of the same patient data into the data fields of the data entry software so that this data can be processed by the particular patient's insurer. As can be seen, when a medical service provider is sending data regarding patients to a plurality of different insurers, a plurality of different data entry software must be maintained by the medical service provider and utilized to effect entry and transfer of patent data to each insurer.
- A problem with this arrangement is the need for the medical service provider to acquire the appropriate data entry software for the insurer of a particular patient and the need for the medical service provider to redundantly enter data into the medical service provider's database and the data entry software. Another problem is that a medical service provider may be required to become familiar with more than one data entry software. Furthermore, from the standpoint of each insurer, there are logistical problems maintaining the integrity of the release and version of data entry software utilized by numerous medical service providers.
- It is therefore, an object of the present invention to overcome the above problems and others by providing a method of communicating data across a distributed computer network between computer systems having different record formats. Is an object of the present invention to provide a method where IP addresses of a transmitter and a receiver accompany a data packet to its ultimate destination while the data packet is routed through one or more designated intermediate receivers. Still other objects will become apparent to those of ordinary skill in the art upon reading and understanding the following detailed description It is a second object of the present invention
- Accordingly, we have invented a server comprised of conversion routines configured to convert patient records from one format into another format. A record format used by a transmitter database is sent by the transmitter to an intermediary server. The server selects the appropriate conversion routine by determining who is the transmitter of the record and who is the receiver of the record. Alternatively, the medical service provider record may explicitly indicate to the server which conversion routine is to be used. The actual conversion entails manipulations including, but not limited to literal transformations, truncations, and concatenations of record components, such as description fields, data fields, and datatype fields. Upon completion of the conversion, the server transmits the converted record to the insurer for processing in the insurer database. In connection with processing of the converted record, the insurer may transmit back to the medical service provider, through the server, an acknowledgement in the form of a record. In response to receiving the acknowledgement record, the server converts the record format used by the insurer database into a record format compatible with the medical service provider database. Upon completion of the conversion, the server transmits the converted acknowledgement record to the medical service provider for processing in the medical service provider database.
- While described in connection with a transaction between an insurer and a medical service provider, the present invention can also be used for data transfer between other entities having incompatible data records. For example, the use of the present invention can be enhanced to include transfer of data to and from data records of employers of insured patients, an insurance broker and/or sub-broker, and other insurance group programs. It should be appreciated that the data can be transmitted to multiple successive conversion servers prior to the data reaching its ultimate receiver. It should be further appreciated that the data can also be transferred to more than one server, in order to arrive at multiple receivers for processing.
- The foregoing and other features of the method of the present invention will be further apparent from the description which follows.
- Other important objects and features of the invention will be apparent from the following detailed description of the invention, taken in connection with the accompanying drawings in which:
- FIG. 1 is a schematic drawing of service providers, insurers, and a server communicating with each other across a distributed computer network;
- FIG. 2 is a block diagram representing the exchange of data from a service provider database to a insurance database through the server;
- FIG. 3 is a block diagram of the server;
- FIG. 4 is block diagram of an incoming packet directed to the server from a service provider database;
- FIG. 5 is a block diagram of the transmitter-receiver conversion matrix of the server;
- FIG. 6 is a block diagram of an alternative incoming packet directed to the server from a service provider database;
- FIG. 7 is a block diagram of an outgoing packet directed to the first insurer database from a server; and
- FIG. 8 is a block diagram representing the exchange of data from an insurer database to a service provider database through the server.
- The present invention will be described with reference to the accompanying Figs. where like reference numbers correspond to like elements.
- With reference to FIG. 1, in connection with a medical insurance contract, a party or
patient 2 covered by medical insurance issued by aninsurer medical service providers 4, 6, . . . , 8, such as a doctor or physician, a hospital, a medical laboratory, and the like. - The present invention connects each service provider,4, 6, . . . , 8 and each
insurer server 22 connected to Internet 20. Each medical service provider, 4, 6, . . . , 8 and eachinsurer server 22 for processing, and more specifically, conversion from a first record format to a second record format, and vice versa. With reference to FIG. 2 and continuing reference to FIG. 1, when a service is rendered to a patient, the service provider rendering the service typically forwards to the patient's insurer a claim for the service rendered. For example, if first service provider 4 provides a specific health service topatient 2, first service provider 4 will forward tofirst insurer 14 information regarding the rendered service. Specifically, this process is initiated by having first service provider 4 enter patient data into adatabase 24 of first service provider 4. Information concerning each patient is stored in a record 26 a ofdatabase 24. Record 26 a is comprised of a plurality of related fields, e.g.,related field 28 which includes a description field 28 a, e.g., Patient_ID;data field 28 b, e.g. social security number; and datatype field 28 c, e.g., long int.Database 24 is designed to have specific formats for datatype field 28 c thereby requiring data to conform to specific datatype formats in order to be compatible with record 26 a. - With reference to FIGS. 3 and 4 and with continuing reference to FIGS. 1 and 2, at a suitable time first service provider4 transmits record 26 a to an insurer, e.g.,
first insurer 14. Prior to transmission of record 26 a, a transmitter-receiver layer 53 is associated with record 26 a. Transmitter-receiver layer 53 identifies the transmitter of record 26 a and the receiver of record 26 a. Thus, for example, transmitter-receiver layer 53 includes the name and/or Internet Protocol (IP)address 5 of first service provider 4 andIP address 15 offirst insurer 14. More specifically, first service provider 4 transmits to server 22 a packet 60 a which includes record 26 a, transmitter-receiver layer 53, and, in conformity with standard transmission conventions, an IP header 62 a designating areceiver IP address 23 ofserver 22 andtransmitter IP address 5 of first service provider 4, which are both utilized to route packet 60 a through Internet 20 toserver 22. - With reference to FIG. 5 and with continuing reference to FIGS. 2 and 3,
server 22 is configured to convert a database record having one format into a database record having a different format. Accordingly, upon receiving packet 60 a from first service provider 4, apacket sniffer 52 ofserver 22 separates the packet into its constituent parts, namely transmitter-receiver layer 53 and record 26 a. The transmitter-receiver layer 53 is then scanned by a transmitter-receiver conversion matrix 50 which determines who is the transmitter and who is the receiver. Preferably, the transmitter-receiver conversion matrix 50 includes an X-Y grid where transmitters and receivers line the X-axis and Y-axis, respectively. At an intersection grid point of a transmitter and a receiver resides a conversion routine, or the name of a conversion routine, capable of converting the record format of the transmitter database into a new record compatible with that of the receiver database. The conversion routine is then applied to the transmitter record. More specifically, the transmitter record's description fields, data fields, and datatype fields are converted into description fields, data fields, and datatype fields which match the record format of the receiver database. - For example, suppose that
server 22 receives packet 60 a from first service provider 4.Packet sniffer 52 separates packet 60 a into transmitter-receiver layer 53 and record 26 a.Conversion matrix 50 then scans transmitter-receiver layer 53 and determines that record 26 a was sent by first service provider 4 to be received byfirst insurer 14. Transmitter-receiver conversion matrix 50 utilizes this information to identify aconversion routine 54, which can convert the record format ofdatabase 24 of first service provider 4 into the record format of adatabase 34 offirst insurer 14.Conversion routine 54 and record 26 a are passed to aconvert function 56 for processing.Convert function 56 then appliesconversion routine 54 to record 26 a. - In the instant case, suppose that service provider4 treats a patient whose social security number is 123456789. Record 26 a therefore has description field 28 a, “Patient_ID”,
data field 28 b “123456789”, and datatype field 28 c which indicates that data field 28 b is of type long int. Moreover, suppose thatrecord 26 b offirst insurer 14 does not follow the naming and/or data conventions of record 26 a. Namely,record 26 b has a description field 38 a “SSN”, a correspondingdata field 38 b “123-45-6789”, and datatype field 38 c which indicates that data field 38 b offirst insurer 14 is of type custom format. As can be seen, the data format of record 26 a of first service provider 4 and the data format ofrecord 26 b offirst insurer 14 are incompatible with each other and require conversion. To this end, convertfunction 56 executesconversion routine 54 to convert description field 28 a “Patient_ID” into description field 38 a “SSN.” Additionally, datatype field 28 c of record 26 a requires that data field 28 b for social security number “123456789” have a long integer format, whereasdata field 38 b ofinsurer record 26 b is configured to receive this social security number in custom format, namely, with suitable hyphenation, i.e., “123-45-6789.”Convert function 56 converts social security number “123456789” indata field 28 b into social security number “123-45-6789” which is inserted intodata field 38 b ofrecord 26 b. Another example of a datatype field conversion is that of aninteger 30 in record 26 a converted to a floatinginteger 40 in record 38 a. - With reference to FIG. 6 and with continuing reference to FIG. 3, a
packet 70 illustrates an alternative means of identifying the appropriate conversion routine, e.g., 54, to apply to record 26 a of first service provider 4. In addition to record 26 a, transmitter-receiver layer 53, and IP header 62 a,packet 70 can also include aconversion designator 63.Conversion designator 63 expressly informsserver 22 of the conversion routine, e.g., 54,server 22 should use for conversion of record 26 a. Therefore, the transmitter-receiver conversion matrix 50 lookup is bypassed or eliminated. - With reference to FIGS. 2 and 4,
conversion routine 54 can also create new fields and manipulate existing fields in the patient record. For example, record 26 a can havedata field 29 containing an entry “John Q.”, thereby including both a first name and a middle initial within the same data field.Insurer record 26 b, however, designates a first name and a middle initial using two separate data fields.Conversion routine 54 can separatedata field 29 containing the entry “John Q.” intofirst name data 41 “John” and middleinitial data 39 “Q.” Conversion routine 54 must then instantiate these new data fields withinrecord 26 b offirst insurer 14 to receivefirst name data 41 “John” and middleinitial data 39 “Q.”. - After
convert function 56 has createdrecord 26 b that is now compatible withdatabase 34 offirst insurer 14,record 26 b needs to be transmitted tofirst insurer 14 for processing indatabase 34. Standard Internet transmission protocol, provide for the IP header of a data packet to be discarded upon successful transmission of the data packet between a transmitter and a receiver. For example, suppose that the receiver isserver 22 acting as an intermediary between a transmitter, e.g., first service provider 4, and an ultimate receiver, e.g.,first insurer 14, for processing and converting the data packet into a different data packet, e.g., 62 b, to be transmitted to the ultimate receiver. Prior to processing the data packet, e.g., 60 a,server 22 would ordinarily discard the IP header, e.g., 62 a, thereby effectively removing any reference to the original transmitter andserver 22 itself. The ultimate receiver now has no knowledge of the original transmitter, nor doesserver 22 have any knowledge of the ultimate receiver. As in the present invention, there are circumstances, such as identification of the original transmitter by the ultimate receiver, and vice versa, which require data packets to maintain the IP address of the transmitter and the ultimate receiver. - The present invention addresses this problem through the use of transmitter-
receiver layer 53 which retains with the data packet the transmitter IP address and the receiver IP address. For example, IP header 62 a which was used to route packet 60 a toserver 22 has been destroyed after successful transmission of packet 60 a toserver 22, thereby removing any reference to first service provider 4 from packet 60 a. It should be appreciated that the IP addresses contained in the transmitter-receiver layer 53 are static and remain in transmitter-receiver layer 53 from the moment first service provider 4 transmits record 26 a untilfirst insurer 14 receivesrecord 26 b.Server 22, can therefore create a new IP header 62 b using the IP addresses contained in transmitter-receiver layer 53. Accordingly,server 22 determines the receiver IP address, e.g.,IP address 15 offirst insurer 14, by scanningIP address 15 from transmitter-receiver layer 53.IP address 15 is then designated as the receiver IP address in IP header 62 b.IP address 23 ofserver 22 is designated as the transmitter IP address in IP header 62 b. Accordingly,server 22bundles record 26 b, the original transmitter-receiver layer 53, and IP header 62 b, into an outgoing packet 60 b, as shown in FIG. 7. Packet 60 b is then routed fromserver 22 throughInternet 20 tofirst insurer 14. - After an insurer record has been entered and processed into the insurer database, the insurer may wish to send an acknowledgement to the service provider informing the service provider that the patient claim has been received, approved, disapproved, that there is a request for additional information to justify a requested fee for a rendered service, and/or the like.
- For example, with reference to FIG. 8 and with continuing reference to FIGS. 1, 2,3, and 5, FIG. 8 depicts the transmission of an acknowledgement 42 b in the form of a record 46 b from
first insurer 14 to first service provider 4. The transmission of record 46 b fromfirst insurer 14 to first service provider 4 requires the transposition of the transmitter-receiver layer information, e.g.,thefirst insurer 14 is designated as the transmitter and the first service provider 4 is designated as the receiver. Upon record 46b reaching server 22, a different conversion routine is applied to record 46 b. For example, the transmitter-receiver conversion matrix 50 scans transmitter-receiver layer 53 as before, but this time, determines that the transmitter of record 46 b isinsurer 14 and that the receiver is first service provider 4. Accordingly,conversion matrix 50 selects and appliesconversion routine 44 to record 46 b. This results in the conversion of the appropriate description fields, data fields, and datatype fields into description fields, data fields, and datatype fields which match the data format ofdatabase 24 of first service provider 4. In the instant case, the acknowledgement field 42 b, of record 46 b is converted into an acknowledgement field 42 a of record 46 a.Server 22 then determines the receiver IP address by scanning the receiver IP address from the transmitter-receiver layer, therefore having the receiver IP address designated as the receiver IP address in the IP header. Additionally, the IP address of theserver 22 is designated as the transmitter IP address in the IP header. Accordingly, the outgoing packet fromserver 22 includes record 46 a, the transmitter-receiver layer, and the IP header. The outgoing packet is then routed fromserver 22 throughInternet 20 to first service provider 4. After first service provider 4 receives record 46 a fromserver 22, firstservice provider database 24 updates its patient records accordingly. - As can be seen, the present invention provides a method of communicating data across a distributing computer network between computer systems having different record formats. The present invention also provides a method for having IP addresses of a transmitter and a receiver accompanying a data packet to its intended destination while passing through one or more designated intermediate receivers.
- The present invention has been described with reference to the preferred embodiments. Obvious modifications, combinations, and alterations will occur to others upon reading the preceding detailed description. It is intended that the invention be construed as including all such modifications, combinations, and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (17)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/333,897 US7120636B2 (en) | 2001-07-25 | 2001-07-25 | Method of communicating data between computers having different record formats |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/US2001/023364 WO2002008947A1 (en) | 2000-07-25 | 2001-07-25 | Method of communicating data between computers having different record formats |
US10/333,897 US7120636B2 (en) | 2001-07-25 | 2001-07-25 | Method of communicating data between computers having different record formats |
Publications (2)
Publication Number | Publication Date |
---|---|
US20040139076A1 true US20040139076A1 (en) | 2004-07-15 |
US7120636B2 US7120636B2 (en) | 2006-10-10 |
Family
ID=32710856
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/333,897 Expired - Lifetime US7120636B2 (en) | 2001-07-25 | 2001-07-25 | Method of communicating data between computers having different record formats |
Country Status (1)
Country | Link |
---|---|
US (1) | US7120636B2 (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020091709A1 (en) * | 2001-01-08 | 2002-07-11 | Lg Electronics Inc. | Method of storing data in a personal information terminal |
US20040148193A1 (en) * | 2003-01-23 | 2004-07-29 | International Business Machines Corporation | Method, system, and program for managing patient biometric data from patients in a health care environment |
US20070162444A1 (en) * | 2006-01-12 | 2007-07-12 | Microsoft Corporation | Abstract pipeline component connection |
US20090125796A1 (en) * | 2007-11-09 | 2009-05-14 | Fred Day | System, multi-tier interface and methods for management of operational structured data |
EP2061280A1 (en) * | 2007-11-18 | 2009-05-20 | Qualcomm Incorporated | Method and apparatus for synchronizing contacts stored on smart card with contact stored in an internal memory |
US20090240681A1 (en) * | 2008-03-20 | 2009-09-24 | Nadeem Saddiqi | Medical records network |
US20090316879A1 (en) * | 2008-06-18 | 2009-12-24 | Aspect Software Inc. | Method of Unifying Control of Contact Center System |
US20110153667A1 (en) * | 2009-11-13 | 2011-06-23 | Ab Initio Technology Llc | Managing record format information |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7325076B1 (en) * | 1999-11-10 | 2008-01-29 | Navimedix, Inc. | System for dynamic information exchange |
US8244589B2 (en) * | 2006-08-29 | 2012-08-14 | Daevid Vincent | Personalized audio controlled shopping information service for a mobile device |
US8799010B2 (en) * | 2008-05-07 | 2014-08-05 | Unitedhealth Group Incorporated | Telehealth scheduling and communications network |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5687373A (en) * | 1994-04-05 | 1997-11-11 | International Business Machines Corporation | Communications system for exchanging data between computers in a network and a method of operating such a system in which communications services are defined within a common object class |
US5924074A (en) * | 1996-09-27 | 1999-07-13 | Azron Incorporated | Electronic medical records system |
US5974238A (en) * | 1996-08-07 | 1999-10-26 | Compaq Computer Corporation | Automatic data synchronization between a handheld and a host computer using pseudo cache including tags and logical data elements |
US6006274A (en) * | 1997-01-30 | 1999-12-21 | 3Com Corporation | Method and apparatus using a pass through personal computer connected to both a local communication link and a computer network for indentifying and synchronizing a preferred computer with a portable computer |
US6088677A (en) * | 1997-05-30 | 2000-07-11 | Spurgeon; Loren J. | System for exchanging health care insurance information |
US20030084024A1 (en) * | 2001-10-31 | 2003-05-01 | Drake Christensen | Integrated database system for an educational institution |
US6757898B1 (en) * | 2000-01-18 | 2004-06-29 | Mckesson Information Solutions, Inc. | Electronic provider—patient interface system |
US6873841B1 (en) * | 1999-12-16 | 2005-03-29 | Koninklijke Philips Electronics N.V. | Shared address-data service for personal CE equipment |
-
2001
- 2001-07-25 US US10/333,897 patent/US7120636B2/en not_active Expired - Lifetime
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5687373A (en) * | 1994-04-05 | 1997-11-11 | International Business Machines Corporation | Communications system for exchanging data between computers in a network and a method of operating such a system in which communications services are defined within a common object class |
US5974238A (en) * | 1996-08-07 | 1999-10-26 | Compaq Computer Corporation | Automatic data synchronization between a handheld and a host computer using pseudo cache including tags and logical data elements |
US5924074A (en) * | 1996-09-27 | 1999-07-13 | Azron Incorporated | Electronic medical records system |
US6006274A (en) * | 1997-01-30 | 1999-12-21 | 3Com Corporation | Method and apparatus using a pass through personal computer connected to both a local communication link and a computer network for indentifying and synchronizing a preferred computer with a portable computer |
US6088677A (en) * | 1997-05-30 | 2000-07-11 | Spurgeon; Loren J. | System for exchanging health care insurance information |
US6873841B1 (en) * | 1999-12-16 | 2005-03-29 | Koninklijke Philips Electronics N.V. | Shared address-data service for personal CE equipment |
US6757898B1 (en) * | 2000-01-18 | 2004-06-29 | Mckesson Information Solutions, Inc. | Electronic provider—patient interface system |
US20030084024A1 (en) * | 2001-10-31 | 2003-05-01 | Drake Christensen | Integrated database system for an educational institution |
Cited By (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7747948B2 (en) * | 2001-01-08 | 2010-06-29 | Lg Electronics Inc. | Method of storing data in a personal information terminal |
US20020091709A1 (en) * | 2001-01-08 | 2002-07-11 | Lg Electronics Inc. | Method of storing data in a personal information terminal |
US20040148193A1 (en) * | 2003-01-23 | 2004-07-29 | International Business Machines Corporation | Method, system, and program for managing patient biometric data from patients in a health care environment |
US20070162444A1 (en) * | 2006-01-12 | 2007-07-12 | Microsoft Corporation | Abstract pipeline component connection |
US8103684B2 (en) | 2006-01-12 | 2012-01-24 | Microsoft Corporation | Abstract pipeline component connection |
US7779017B2 (en) * | 2006-01-12 | 2010-08-17 | Microsoft Corporation | Employing abstract pipeline component connections to maintain data flow |
US20090125796A1 (en) * | 2007-11-09 | 2009-05-14 | Fred Day | System, multi-tier interface and methods for management of operational structured data |
US9292306B2 (en) * | 2007-11-09 | 2016-03-22 | Avro Computing, Inc. | System, multi-tier interface and methods for management of operational structured data |
EP2061280A1 (en) * | 2007-11-18 | 2009-05-20 | Qualcomm Incorporated | Method and apparatus for synchronizing contacts stored on smart card with contact stored in an internal memory |
WO2009065148A1 (en) * | 2007-11-18 | 2009-05-22 | Qualcomm Incorporated | Method and apparatus for synchronizing contacts stored on smart card with contacts stored in an internal memory |
US20090240681A1 (en) * | 2008-03-20 | 2009-09-24 | Nadeem Saddiqi | Medical records network |
WO2009117655A3 (en) * | 2008-03-20 | 2010-01-07 | Ns Development, Llc | Medical records network |
WO2009117655A2 (en) * | 2008-03-20 | 2009-09-24 | Ns Development, Llc | Medical records network |
US20090316879A1 (en) * | 2008-06-18 | 2009-12-24 | Aspect Software Inc. | Method of Unifying Control of Contact Center System |
US8520831B2 (en) * | 2008-06-18 | 2013-08-27 | Aspect Software, Inc. | Method of unifying control of contact center system |
AU2010319344B2 (en) * | 2009-11-13 | 2014-10-09 | Ab Initio Technology Llc | Managing record format information |
US20110153667A1 (en) * | 2009-11-13 | 2011-06-23 | Ab Initio Technology Llc | Managing record format information |
KR101755365B1 (en) | 2009-11-13 | 2017-07-10 | 아브 이니티오 테크놀로지 엘엘시 | Managing record format information |
US10445309B2 (en) * | 2009-11-13 | 2019-10-15 | Ab Initio Technology Llc | Managing record format information |
Also Published As
Publication number | Publication date |
---|---|
US7120636B2 (en) | 2006-10-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7152094B1 (en) | Middleware brokering system adapter | |
US5995939A (en) | Automated networked service request and fulfillment system and method | |
US8260820B2 (en) | Method and apparatus for searching | |
US20090177637A1 (en) | Ndma db schema, dicom to relational schema translation, and xml to sql query translation | |
US7523505B2 (en) | Methods and systems for managing distributed digital medical data | |
US7860726B2 (en) | Method for providing web-based delivery of medical service requests | |
US6856414B1 (en) | Image data communication system, server system, method of controlling operation of same, and recording medium storing program for control of server system | |
US7574500B2 (en) | Establishing a cache expiration time to be associated with newly generated output by determining module- specific cache expiration times for a plurality of processing modules | |
US7234064B2 (en) | Methods and systems for managing patient authorizations relating to digital medical data | |
US20040205664A1 (en) | Claim data and document processing system | |
US7120636B2 (en) | Method of communicating data between computers having different record formats | |
US20110106564A1 (en) | Electronic medical records interoperability | |
US20100011087A1 (en) | Delivering dicom data | |
US20050050228A1 (en) | Method and apparatus for the use of dynamic XML message formats with web services | |
US20070027717A1 (en) | Automatic patient record update enabled clinical messaging | |
US20070022141A1 (en) | System and method for acquiring and assembling real property data | |
US20030171953A1 (en) | System and method for facilitating the exchange of health care transactional information | |
US20010042093A1 (en) | Information processing system capable of file transmission and information processing apparatus in the system | |
EP2191615A2 (en) | Healthcare semantic interoperability platform | |
WO2007064434A2 (en) | On-line business-packet creator for electronic forms | |
JP2005519413A (en) | System and method for providing comprehensive healthcare data storage means | |
US20080005144A1 (en) | Apparatus and method for transferring data between incompatible computer systems | |
WO2009074878A2 (en) | Formatted intellectual property data exchange over a network | |
US20090157837A1 (en) | Ndma socket transport protocol | |
US6516353B1 (en) | System and method for interactive EDI transactions |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: SOMFY SAS, FRANCE Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:RU, YANN LE;REEL/FRAME:017048/0096 Effective date: 20050320 |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
CC | Certificate of correction | ||
FPAY | Fee payment |
Year of fee payment: 4 |
|
REMI | Maintenance fee reminder mailed | ||
FPAY | Fee payment |
Year of fee payment: 8 |
|
SULP | Surcharge for late payment |
Year of fee payment: 7 |
|
FEPP | Fee payment procedure |
Free format text: 11.5 YR SURCHARGE- LATE PMT W/IN 6 MO, SMALL ENTITY (ORIGINAL EVENT CODE: M2556) |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YR, SMALL ENTITY (ORIGINAL EVENT CODE: M2553) Year of fee payment: 12 |