US20100235315A1 - Systems and Methods for Address Intelligence - Google Patents
Systems and Methods for Address Intelligence Download PDFInfo
- Publication number
- US20100235315A1 US20100235315A1 US12/721,280 US72128010A US2010235315A1 US 20100235315 A1 US20100235315 A1 US 20100235315A1 US 72128010 A US72128010 A US 72128010A US 2010235315 A1 US2010235315 A1 US 2010235315A1
- Authority
- US
- United States
- Prior art keywords
- occupancy
- determining
- present status
- score
- sources
- 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
- 238000000034 method Methods 0.000 title claims abstract description 100
- 238000010200 validation analysis Methods 0.000 claims description 11
- 230000015654 memory Effects 0.000 claims description 5
- 230000008859 change Effects 0.000 description 9
- 238000012360 testing method Methods 0.000 description 9
- 238000012795 verification Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 238000012545 processing Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 230000008520 organization Effects 0.000 description 5
- 239000000203 mixture Substances 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000003442 weekly effect Effects 0.000 description 2
- 241000953555 Theama Species 0.000 description 1
- 230000032683 aging Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 239000003814 drug Substances 0.000 description 1
- 229940079593 drug Drugs 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000000474 nursing effect Effects 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000007670 refining Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 238000013515 script Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Definitions
- a compilation of addresses of potential and existing customers is an important asset for any company that uses traditional methods to identify, manage and allocate the multiple types of addresses that are configured for a professional to meet multiple operational needs for customer management, personal and non-personal communications.
- it can be a daunting task to keep a large compilation of addresses up-to-date and accurate.
- a user may want to gather the addresses of the persons of interest from various sources.
- the use of multiple address sources does not guarantee a broader reach to the targeted audience, but instead can create confusion and cause more waste. This is due to not only the varying reliability of the individual sources, but also the conflicts or inconsistencies of the addresses provided by the different sources. For example, an address can be present in one source, but not another; a person can have multiple office addresses reported by different sources, yet no information is available as to which one is more current. Without further analysis or investigation, a user of such addresses will not be able to use them effectively.
- the techniques include obtaining the at least one occupancy of said one or more individuals from said one or more sources; computing a score of said at least one occupancy by a computer processor based on the currency and the relative trustworthiness of said one or more sources; and determining said present status of said at least one occupancy based on said computed score.
- the techniques can also include presenting the at least one occupancy in a user readable format.
- the occupancy is obtained from at least one external source.
- computing the score for an occupancy can include obtaining an age of the occupancy, assigning a weight point to each of one or more instances of the occupancy based on the age and the relative trustworthiness of the at least one external source, and obtaining a score of the occupancy by summing up all of the weights of the one or more instances of the occupancy.
- the score of an occupancy is an overall score and computing the score includes combining an internal score and an external score of an occupancy.
- the techniques further include additional verification or validation based on one or more criteria for supplementing missing information of an occupancy, correcting an error existent in an occupancy as reported, validating an occupancy, updating the present status of an occupancy, and/or resolving a conflict between multiple occupancies associated with a person.
- FIGS. 1A and 1B depict structures of three database tables and some occupancy data as obtained by a procedure according to some embodiments of the described subject matter.
- FIG. 1C depicts a diagram for linking a database table in an external source with a database table in an internal source via a bridging table according to some embodiments of the described subject matter.
- FIG. 2 depicts a diagram for setting flags of address types for occupancies according to some embodiments of the described subject matter.
- FIG. 3 depicts a database table relating to computing of the age of an occupancy according to some embodiments of the described subject matter.
- FIG. 4 depicts a scheme relating to computing the age of an occupancy according to some embodiments of the described subject matter.
- FIG. 5 depicts a scheme for assigning weight points for an occupancy according to some embodiments of the described subject matter.
- FIG. 6 depicts a scheme relating to deriving a rank and an indicator based on the score of an occupancy according to some embodiments of the described subject matter.
- FIG. 7 depicts a database table obtained by processing occupancies received from an external source according to some embodiments of the described subject matter.
- FIG. 8 depicts a diagram relating to evaluating the internal indicator of an occupancy according to some embodiments of the described subject matter.
- FIG. 9A depicts a diagram relating to evaluating the internal score of an occupancy according to some embodiments of the described subject matter.
- FIG. 9B depicts a scheme for incrementing the internal score for an occupancy according to some embodiments of the described subject matter
- FIG. 9C depicts a scheme relating to deriving an internal rank and an internal indicator based on the internal score of an occupancy according to some embodiments of the described subject matter.
- FIG. 10A depicts a diagram relating to deriving an overall score of an occupancy according to some embodiments of the described subject matter.
- FIG. 10B depicts a scheme relating to deriving an overall rank and an overall indicator based on an overall score of an occupancy according to some embodiments of the described subject matter
- FIG. 11 depicts a diagram relating to evaluating the overall indicator of an occupancy according to some embodiments of the described subject matter.
- FIG. 12 depicts a diagram relating to evaluating the overall indicator of an occupancy according to some embodiments of the described subject matter.
- FIG. 13 depicts a diagram relating to evaluating the overall indicators of multiple occupancies associated with a person according to some embodiments of the described subject matter.
- FIG. 14 depicts a portion of a table containing a number of occupancies presented in a user readable format according to some embodiments of the described subject matter.
- the described techniques herein include providing a user with one or more addresses of a person of interest.
- the techniques are hereinafter referred to as the “address intelligence techniques.”
- the address intelligence techniques are based on an analysis of the currency of an occupancy, the source(s) where the occupancy is obtained, as well as an evaluation of the occupancy based on a set of criteria designed using the characteristics of the occupancy.
- the techniques ‘score’ an occupancy based on cumulative quantity of the occupancy reported by the various sources as well as the currency and quality of these sources. Such a score can be converted to a rank representing the degree of confidence with respect to currency of the address. In situations where a person has multiple locations, the technique can select the best address or addresses according to the rank, the indicator, or a combination of both.
- the address intelligence techniques further allow the reconciliation of the inconsistencies existent in large collections of occupancies reported from different sources, thus enabling more effective use of these occupancies.
- the word “person” includes a person whose address(es) is obtained and processed by the address intelligence techniques disclosed in the presently described subject matter. Certain aspects of the described subject matter are illustrated in the context of the healthcare industry where the person of interest can be a healthcare professional, e.g., a physician, an administrative contact of a healthcare organization, etc.
- the term “person” can include a prescriber who has prescription qualification (e.g., a physician), a mid-level practitioner (e.g. Nurse of Physician's Assistant), or more generally a “professional.”
- the presently described techniques can be applied to persons of any category or industry, and is not limited to persons in the healthcare industry.
- service provider includes an individual or organization that may use the address intelligence techniques described herein to obtain, procedure, and present data for its customer(s).
- occupancy includes a unique combination of an identifier of a person and an address of the person.
- a person can be represented by a unique identifier, such as SSN#, license number, etc.
- a person can have multiple different addresses, and they can be of different types (e.g., office, home, mailing, etc.). These different addresses combined with the same person can be referred to as different occupancies associated with the person.
- one occupancy e.g., “David Smith, 123 Main Street” can be reported multiple times by different sources. This can be referred to as the multiple instances of an occupancy, rather than different occupancies.
- An occupancy can include other attributes, such as the affiliation or specialty of a person, or the type or category of an address (e.g., home, office, etc.).
- the techniques disclosed in the presently described subject matter include the following: obtaining the at least one occupancy of said one or more individuals from said one or more sources; computing a score of said at least one occupancy by a computer processor based on the currency and the relative trustworthiness of said one or more sources; and determining a present status of said at least one occupancy based on said computed score.
- An occupancy can be obtained from one or more external and internal sources.
- “External sources,” as used herein, include sources of occupancies that are not proprietary databases of the service provider. They include but are not limited to: reference files purchased or made publicly available by the Drug Enforcement Agency (DEA), American Medical Association (AMA), American Osteopathic Association (AOA), National Provider Identifier (NPI), State License Number (SLN), Yellow White Pages (YWP), and GM Loadstone (GML). The reference files can be updated periodically, e.g., daily, weekly, or monthly.
- “Internal sources” include one or more proprietary databases maintained by a service provider, e.g., IMS's primary research databases for professionals: MI CORETM and PHOENIXTM.
- An occupancy can be obtained from the one or multiple such sources, or combinations thereof. Multiple instances of an occupancy associated with a person can be obtained from the multiple sources. It is understood that internal sources can operate similarly as the external sources.
- the MI CORETM database used throughout the present application merely for illustrative purposes, is organized in a substantially similar fashion as other commercial databases.
- Obtaining occupancy data from external sources can take various routes.
- One such route is through periodically receiving a feed from a vendor which provides occupancy data to the service provider.
- An example of obtaining occupancies from an external source is illustrated in FIG. 1A , wherein an external source such as the DEA reference file is integrated into REFERENCE FILE MASTER (or “RF MASTER”), a database containing a master collection of external occupancy data, maintained by the service provider.
- REFERENCE FILE MASTER or “RF MASTER”
- a “SOURCE COMPARE” procedure can be run to integrate the data obtained from the DEA file to the PROFESSIONAL, ADDRESS OCCUPANCY, and ADDRESS SOURCE TAG tables in the REFERENCE FILE MASTER, whose structures are illustrated in FIG. 1A .
- the procedure can be performed as follows for each entry received from the DEA:
- the person's information is not yet in the REFERENCE FILE MASTER, the person is added to the PROFESSIONAL table. For example, suppose the two entries are first reported by the DEA to the REFERENCE FILE MASTER, the entry relating to John Doe representing a new person. The procedure first creates an entry in the PROFESSIONAL table for John Doe, and then a Postal Standardized entry in the ADDRESS OCCUPANCY table for John Doe at 123 Main Street, Bedford N.H. 03110. Further, John Doe's address can be “source tagged” by creating an entry in the ADDRESS SOURCE TAG table for the address with the ‘source’ of DEA, and setting a ‘start’ date and ‘change’ date to the data of file receipt.
- the start state of an occupancy refers to the date when the occupancy was first reported by an external data source to the service provider;
- the change date of an occupancy refers to the date when the occupancy was last referenced by an external data source (as seen by the SOURCE COMPARE procedure). For example, if an external source reported an occupancy in the first month, but stop reporting the occupancy in the subsequent two months, the change date of the occupancy at the end of the three-month period would still be the reporting date in the first month. If however, the occupancy was repeatedly reported by a source for three consecutive months, then the change date at the end of the three-month period is the last reporting date of the reference file.
- the change date is herein also referred to as a ‘recency’ date.
- the ADDRESS OCCUPANCY table is checked as to whether the address 123 Main Street Bedford N.H. is attached to John Doe. If the address does not already exist, a Postal Standardized entry can be created in the ADDRESS OCCUPANCY table for John Doe at 123 Main Street, Bedford N.H. 03110, and then an entry can be created in the ADDRESS SOURCE TAG table for the address with the ‘source’ of DEA, and the start date and recency date can be set to the data of file receipt. If the address does exist for John Doe, the ADDRESS SOURCE TAG table can be checked as to whether the address has previously been sourced by the DEA reference file.
- FIG. 1A The result of this exemplary SOURCE COMPARE procedure and the results visible within the REFERENCE FILE MASTER is illustrated in FIG. 1A .
- the SOURCE COMPARE procedure is repeated on these three entries (all on the same day, or separately, e.g., on the days the respective entries were received). The results are reflected in the relevant tables, as illustrated in FIG. 1B .
- an internal operative database e.g., MI CORETM
- MI CORETM can be configured to link or integrate with REFERENCE FILE MASTER using standard database technologies, as illustrated in FIG. 1C .
- a subset of REFERENCE FILE MASTER can contain a set of data tables: ADDRESS OCCUPANCY, PROFESSIONAL, and ADDRESS SOURCE TAG.
- the tables can be linked with occupancy data contained in an internal source, for example, MI CORETM, via a bridging table (e.g., MIIL_RFM_ADDR_BRDG ( 20 )), which contains an ADDR_ID field being used to reference the key ADDR_ID in a table MIIC_PRSCRBR_ADDR ( 30 ) of the MI CORETM database, and a RFM_ADDR_KEY field being used to reference a field RFM_ADDR_KEY (a unique address identifier used in REFERENCE FILE MASTER) of a table ADDRESS OCCUPANCY ( 10 ) in the REFERENCE FILE MASTER.
- a bridging table e.g., MIIL_RFM_ADDR_BRDG ( 20 )
- an ADDR_ID field being used to reference the key ADDR_ID in a table MIIC_PRSCRBR_ADDR ( 30 ) of the MI CORETM database
- RFM_ADDR_KEY a unique address identifier
- a new occupancy entry having a unique ADDR_ID can be created in the internal source MI CORETM.
- the externally sourced occupancy data does not necessarily solely originate from a third party provider; the occupancies can also be directly collected by the service provider itself into so called “internal sources.” Therefore, the internal sources, as previously noted, can also contain occupancy data which are similarly referenced by various external sources. Additionally, the internal sources can include database entry systems that employ manual input of an occupancy on a more individual basis (as opposed to importation of entire occupancy databases), and therefore can contain data that are collected through means other than the automated SOURCE COMPARE procedure, for example, by directly contacting with a physician and obtaining the physician's address, or data relating to information about the physicians other than occupancies, such as affiliations, date of birth, specialties, etc.
- a certain portion of the externally sourced occupancies can be later be verified or validated by an internal procedure, therefore an originally externally sourced occupancy can also acquire attribute(s) that indicates a modification history by an internal verification or validation procedure.
- These occupancies can be referred to as dually sourced occupancy data; they can still be tagged with the particular external sources from which they are received for processing as detailed below. It is noted that REFERENCE FILE MASTER database includes both the master collection of all the externally sourced data and internally sourced data.
- an occupancy obtained from an external source can optionally be further categorized according to type or category of the address.
- FIG. 2 illustrates some of the exemplary approaches for the categorization.
- a database table field pt_address_loc is used to update the category information based on a set of criteria. For example, if an address link, via the ADDR_ID (in the MI CORETM database), is found to link to (or associated with) an organization within the IMS Healthcare Organizational Services (HCOS) database, and is currently marked as Home, Unknown, Neither, or Both, then the pt_address_loc field for the occupancy is updated to “office.”
- ADDR_ID in the MI CORETM database
- an externally sourced occupancy can then be processed to derive a score based on the currency and relative trustworthiness of the source from which the occupancy data is obtained.
- an “approval age” (or “age”) of an occupancy can be derived to reflect the currency of the occupancy.
- the age can be computed using either or both of the start date and the change date as a reference approval date.
- the start date and change date can be obtained from a database table designed or assembled to keep track of the update history of the external source reporting the occupancy. An example of such a table is shown in FIG. 3 .
- the age of an occupancy can then be derived by assigning a number to the occupancy based on the number of days elapsed since the relevant reference approval date of the specific external source relative to the present date. For example, it can be done in a manner described in FIG. 4 , where the age of occupancy data is assigned to a scale of 0-7 depending the days elapsed since the reference approval date, where greater ages correspond to more days elapsed.
- a weight point can then be assigned to an occupancy based on the age and the relative trustworthiness of the source from which the occupancy is obtained. For example, greater positive points can be used to represent occupancy data having a “younger” age, which indicates more reliability and better currency of the occupancy. Smaller positive points or negative points are assigned to an older occupancy. Some sources are more trustworthy and therefore an occupancy having a certain age obtained from these sources is assigned a greater weight point as compared to an occupancy having the same age obtained from other sources.
- the relative trustworthiness of a source can be assessed by the type of the source, e.g., whether it has a government mandated update procedures, or by collecting a portion of occupancy data from the source and performing statistical or manual validation.
- FIG. 5 An illustrative weight point assignment scheme is presented in FIG. 5 , where src_no represents the identifier of an external source, and the ext_points represent the weight points assigned based on the source and recency. Since the AMA database is assessed to have a greater trustworthiness compared to DEA, an occupancy having an age of 1 is assigned 10 weight points, as opposed to the 8 points assigned to an occupancy having the same age but obtained from the DEA database.
- a score is further derived for an occupancy based on the weight point(s) given to the occupancy from each of the one or more external sources from which the occupancy is obtained. If there are multiple instances of the occupancy from difference sources, the score can be derived by summing up the individual weight points assigned to each instance of the occupancy associated with the person. If there is only one instance of the occupancy, the score can be the same as the weight point assigned to such an occupancy.
- an indicator can be computed for or assigned to an occupancy based on the score of the occupancy.
- the indicator can reflect the present status of the occupancy.
- the indicator can be ‘P’ (for “preferred active”), ‘A’ (for “active”), ‘T’ (for “transitional”), ‘U’ (for ‘unknown’), ‘O’ (for “old”), and ‘D’ (for “deleted”), reflecting in a decreasing order of currency.
- the status indicators ‘P’ and ‘A’ are called high-end indicators.
- a rank can be further assigned to an occupancy based on the score of the occupancy.
- FIG. 6 outlines an illustrative scheme for assigning indicator values and ranks based on the calculated score of an occupancy. For example, ‘A’ can be assigned to an occupancy having a score greater than 5, ‘T’ can be assigned to an occupancy having a score between 1-4, ‘U’ can be assigned to an occupancy having a score of 0, and any occupancy having a score less than or equal to ⁇ 1 is assigned as “Old” (O).
- a rank can be derived by converting the score, which can have a rather large numerical value (e.g., in the negative tens to the positive tens), into an integer in a smaller range, e.g., in the range of ⁇ 10 to ⁇ 10, for the purpose of a more intuitive presentation to a user: higher ranks signifies higher degree of confidence with respect to currency of the occupancy, and therefore generally correlates to high-end indicators such as ‘P’ or ‘A.’ It should be understand that any number of indicators and ranges of ranks can be used; the above is provided merely for illustrative purposes and is not meant to provide a limitation of the described subject matter.
- the above derived score, indicator and rank for an externally sourced occupancy can be assembled and stored into a table.
- FIG. 7 illustrates the structure of such a table, named “RFM_intelligence.”
- the table can be used for further processing needs. For example, at the next SOURCE COMPARE procedure, if an occupancy is dropped from the newly received external source file(s), then the new score, indicator, and rank of the occupancy can be computed according to the steps outlined above using the saved information from this table, and then stored back in this table to replace the corresponding previous values.
- an internal score, rank, and indicator can be derived from internal validation and/or update history of an occupancy, which occupancy can be either externally sourced or internally sourced.
- one or more additional quality check steps can be performed to further improve the accuracy and reliability of the occupancy data before presenting them to a user.
- these quality check steps are referred to as the quality check technique, or simply the quality check.
- the quality check can be incorporated into the address intelligence techniques by refining the score, rank, and/or indicator of an occupancy to make these parameters more realistically reflect the currency and the confidence of the currency of the occupancy.
- the quality check technique can have one or more of the following features: to supplement missing information for an occupancy, to resolve conflicts of multiple occupancies associated with a person, to update the present status of an occupancy, to correct an error contained in an occupancy as reported from an external source(s), and to validate or confirm an occupancy.
- the quality check technique can start with loading a database table containing occupancy data.
- the table can be an expanded database table formed by linking occupancy data from an internal source (e.g., an address table core_address_work — 1, denormalized, from the MI CORETM database) and an external source (e.g., a table of REFERENCE FILE MASTER).
- a Street Front ID which can be an identifier for the street front portion of the address of an occupancy (e.g., an address with the suite/apartment/room number omitted), can be derived from the MIIC_ADDR table and included in the expanded database.
- Some attributes from REFERENCE FILE MASTER that may be of interest to a user can also be included in the expanded table.
- One of such attributes is “deliverability” which reflects the likelihood that a mail can be correctly delivered to the address.
- delivery is “deliverability” which reflects the likelihood that a mail can be correctly delivered to the address.
- NEG_CODE is a code designed for internal auditing purpose (e.g., to identify the point where the quality check terminates).
- the internal score, internal rank, and internal indicator are attributes of an occupancy (either internally sourced or externally sourced) that can be modified based on some criteria further explained below.
- the quality check technique includes one or more testing of conditions for an occupancy.
- This technique can be generally viewed as sending an occupancy through a series of checkpoints, and at each checkpoint, checking the occupancy against a given criterion (or query). If the occupancy does not satisfy the criterion, its indicator value (such as an internal indicator for purely internally sourced occupancy, or an external indicator for externally sourced occupancy without internal support, or an overall indicator for dually sourced occupancy) is updated, a NEG_CODE is set, and the quality check terminates. Otherwise, the occupancy is sent down to one or more other checkpoints for further inspection.
- the specific order, number, or specific tests performed for each criterion of the checkpoints are not critical to the efficacy of the method, although they may affect the efficiency of the quality check technique.
- certain orders of performing the quality check may allow the procedure to terminate earlier when a “termination” condition is met, e.g., when a definitive result is reached as to the present status of an occupancy.
- the quality check includes manual validation or verification of an occupancy. For example, if a customer informs the service provider by phone that the customer just moved to a new address, the address is accordingly updated, e.g., its internal score is set to the highest possible value, and its overall indicator is set to “P.” With the “aging” of such an update, the score and indicator may be later modified.
- manual verification or validation can also form the basis for other aspects of the quality check technique, which can use the result of a manual verification (or whether there has been a manual verification) as part of a test criterion.
- Manual verification can be used when externally sourced occupancy data contain some specific types of information or errors that trigger such a manual verification procedure.
- the quality check includes updating the present status of an occupancy and/or correcting an error in an occupancy by overriding an initially computed indicator of an occupancy to ‘O’ or ‘D’. For example, it can include checking an occupancy as to whether the person or the address has expired, as illustrated in FIG. 8 .
- a query is presented for an occupancy of interest: “is prescriber expired or logically deleted?” If the answer is yes (an indication that this particular person should never have been included in the IMS database as he or she is not a professional which IMS maintains information or the record was a mistake or incomplete), the IND variable is assigned a value of ‘D’ (for “deleted”) at 120 , NEG_CODE is set to 1, and the quality check terminates. Otherwise (i.e., the answer is no), the occupancy can be further checked at one or more other checkpoints, e.g., 130 .
- an occupancy is checked as to whether the prescriber status code is something other than active or semi retired. If the answer is yes, the IND variable is assigned a value of ‘O’ (for “old”) at 140 , NEG_CODE is set to 2, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 150 .
- an occupancy is tested as to whether its address has expired or logically deleted. If the answer is yes, the IND variable is assigned a value of ‘D’ at 160 , NEG_CODE is set to 3, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 170 .
- an occupancy is tested as to whether its address type is one of the three prior address codes (primary mailing, prior home, and prior office). If the answer is yes, the IND variable is assigned a value of ‘O’ at 180 , NEG_CODE is set to 4, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 190 .
- an occupancy is tested as to whether its DOB and decile suggest the prescriber is dead or retired.
- decile is an indicator of quantity of prescriptions a prescriber wrote in a given period relative to all other prescribers, which can be obtained from a prescription database. For example, decile can be set at levels 0-10, with 5 representing a quantity of prescriptions such that 50% of the prescribers wrote more scripts than this professional and 40% of professionals writing fewer prescriptions. If any of the three combinations of a DOB and a decile at 190 is true, then the answer is yes, the IND variable is assigned a value of ‘O’ at 200 , NEG_CODE is set to 5, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints of the quality check technique.
- the formulation of a specific criterion in these embodiments can be based either on a manual validation as explained above (e.g., at 110 ), or a characteristics of the occupancy data itself (e.g., at 190 ), or both (e.g., at 130 ).
- the quality check includes modifying the internal score of an occupancy using a set of criteria.
- the occupancy can either be externally sourced or internally sourced.
- FIG. 9A illustrates this aspect of the quality check technique.
- the quality check tests whether the occupancy is confirmed via a manual or semi manual affiliation in a tool/database for tracking the organizational affiliation of a professional (e.g., the PHOENIXTM database available from IMS Health). If the answer is yes, the internal score is incremented at 220 from a previous value (e.g., the default value of 0) based on the internal approval age of the occupancy, which indicates the time lapse since the last time when this occupancy was confirmed by an analyst by direct call, email, etc., with the person. If the answer is no, the internal score is not updated (at 230 ).
- a previous value e.g., the default value of 0
- an occupancy is tested as to whether it has a high level internal address type code, namely, primary office (‘PO’) or ‘office’ (‘O’).
- PO primary office
- O office
- Internal address type refers to the address type assigned to an occupancy either based on the source where the occupancy is obtained, which can be later validated by an analyst using manual validation.
- the internal score is incremented at 250 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 260 ).
- an occupancy is tested as to whether it has a low internal address type level, e.g., preferred mailing (‘PM’), home (‘H’), and mailing (‘M’), with an approval age less than or equal to 12 months. If the answer is yes, the internal score is incremented at 280 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 290 ).
- a low internal address type level e.g., preferred mailing (‘PM’), home (‘H’), and mailing (‘M’
- an occupancy is tested as to whether it is confirmed via a high level affiliation with GML, e.g., P/T1/A1.
- GML is an external data claims data source that contains not only a professional address, but also the organizational affiliation and the affiliation type field, which is used to describe the recency and accuracy of the affiliation. If the answer is yes, the internal score is incremented at 310 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 320 ).
- the concept for internal scoring mirrors the concepts for external scoring.
- there are two major internal sources such as MI CORETM and PHOENIXTM.
- sub sources representing different types of manually based verification.
- RT manual phone call
- FL current
- BFL current
- FIG. 9B represents a portion of an exemplary table summarizing the weight points that can be assigned based on the different sources, sub sources, and approval age.
- the internal rank and internal indicator of an occupancy can be updated using the updated internal score. This can be done in a similar manner as the case for deriving the external indicator from an external score.
- An exemplary conversion table is illustrated in FIG. 9C .
- the quality check technique includes combining the internal and external score of an occupancy to derive an overall score of the occupancy.
- the overall score of an occupancy can then be used to compute an overall indicator with an improved reliability relative to the internal indicator and the external indicator alone.
- FIG. 10A illustrates an example for implementing this aspect of the quality check technique.
- An occupancy is first obtained from the expanded database table combining REFERENCE FILE MASTER and MI CORETM.
- the quality check technique tests whether the occupancy is available in the REFERENCE FILE MASTER using the table “RFM_intelligence” (the summary table created at the end of SOURCE COMPARE procedure, see FIG. 7 ).
- an overall score of the occupancy is computed as the sum of the internal score and the external score.
- the overall score can be used to compute an overall rank (e.g., from ⁇ 6 to 10) and an overall indicator (e.g., ‘P’, ‘A’, ‘T’, ‘U’, ‘O’, ‘D’, etc.).
- FIG. 10B presents an example of how the overall score can be used to derive an overall rank and an overall indicator.
- the quality check includes evaluating the overall indicator of an occupancy based on a set of criteria based on the external and/or internal score, and/or external and/or internal indicator, among others factors reflecting the internal update history of the occupancy.
- FIG. 11 illustrates a way of implementing this aspect of the quality check technique.
- the quality check technique tests whether the external indicator of the occupancy is ‘A’ (with or without internal support). If the answer is yes, at 420 , the overall indicator value is set as ‘A’, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 430 .
- the quality check technique tests whether this criterion is satisfied: “Is the occupancy has an external address type, and is not in the REFERENCE FILE MASTER, and has no internal support?”
- internal support means that an occupancy has been confirmed or validated by an analyst using some manual checks, e.g., via telephone, email, or other means of communication with the person of the occupancy. If the answer is yes, at 440 , the overall indicator value is set to ‘O’, the NEG_CODE is set to 56, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 450 .
- the quality check technique tests whether this criterion is satisfied: “Is the external indicator of the occupancy ‘O’, its internal indicator ‘U’, and the occupancy was not inserted or validated in the last 90 days?” If the answer is yes, at 460 , the overall indicator value is set to ‘O’, the NEG_CODE is set to 50, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 470 .
- an occupancy is tested as to whether its external indicator is ‘T’ and that it has no internal support. If the answer is yes, at 480 , the overall indicator is set to ‘T’, the NEG_CODE is set to 55, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 490 .
- an occupancy is tested as to whether it has a MII or US address type and no internal support.
- MII represents an address originally based on an affiliation in PHOENIXTM that no longer exists.
- US represents a user attempt to verify an address that was unsuccessful. The address could not be confirmed as old or invalid but it is strongly suspected as such.
- the overall indicator is set to ‘T’ (for MII address type) or ‘O’ (for US address type), with the corresponding NEG_CODE set to 51 or 52, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 510 .
- an occupancy is tested as to whether it has no internal or external support, and has the internal insert date of more than 90 days.
- the term “external support” as used herein refers to the presence or availability of an external source from which the occupancy is obtained and the age of the occupancy can be determined. If the answer is affirmative, at 520 , the overall indicator is set to ‘O’, the NEG_CODE is set to 58, and the quality check terminates. If the answer is negative, the occupancy can be further checked at one or more other checkpoints, e.g., 530 .
- an occupancy is tested against this criterion: “Are the following conditions all true: the external indicator of the occupancy is ‘O’; the internal indicator of the occupancy is ‘U’; the occupancy was not inserted in the last 90 days; and the occupancy was not validated in the last 90 days.” If the answer is affirmative, at 540 , the overall indicator is set to ‘O’, the NEG_CODE is set to 59, and the quality check terminates. If the answer is negative, the occupancy can be further checked at one or more other checkpoints, e.g., 550 .
- an occupancy is tested as to whether its external indicator is ‘T’ while its internal indicator is ‘U’. If the answer is yes, at 560 , the overall indicator is set to ‘T’, the NEG_CODE is set to 60, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 570 .
- an occupancy is tested as to whether it was inserted in the last 3 months or validated in the last six months and still marked as ‘U’. If the answer is yes, at 580 , the overall indicator is set to ‘A’, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 590 .
- the occupancy is tested as to whether it was inserted in the last 3 months or validated in the last six months and still marked as ‘U’. If the answer is yes, at 600 , the overall indicator is set to ‘T’, the NEG_CODE is set to 305, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 610 , as explained below.
- the quality check technique includes evaluating the validity of a previous determination of an overall indicator having an ‘A’ value.
- FIG. 12 illustrates an embodiment for implementing this aspect of the quality check technique.
- an occupancy is tested as to whether any portion of its address has a ‘NULL’ or ‘INVALID’ value. If the answer is yes, at 620 , the overall indicator is set to ‘O’, the NEG_CODE is set to 61, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 630 , as explained below.
- the occupancy is tested as to whether its internal score is less than 5 while its external score is less than ⁇ 6. If the answer is yes, at 640 , the overall indicator is set to ‘T’ (i.e., ‘A’ is overridden), the NEG_CODE is set to 62, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 650 .
- an occupancy is tested as to whether the sum of 1.5 ⁇ its internal score and its external score is smaller than zero, while the internal score is smaller than 8. If the answer is yes, at 660 , the overall indicator is set to ‘T’, the NEG_CODE is set to 63, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 670 .
- the formulation of a specific criterion in the above embodiments can be based either solely on the external indicator (e.g., at 410 ), whether there has been a prior manual validation (e.g., at 570 ), or a mixture of both (e.g., at 530 ).
- the quality check includes resolving a conflict existent in the occupancy data. For example, it can include evaluating multiple addresses in non-contiguous states for a physician, because such a situation is unlikely and usually caused by errors in the reporting external sources.
- FIG. 13 illustrates an embodiment implementing this aspect of the quality check technique.
- the quality check technique tests whether a prescriber has multiple addresses in non-contiguous states.
- the score for unique street front (STF) addresses for each state is aggregated, and the overall indicator for the losing state (i.e., the state with a lower aggregate STF score) is updated to ‘O’ if it is currently ‘T’, or updated to ‘T’ if it is currently ‘A’; and then the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 690 .
- the prescriber associated with an occupancy is tested as to whether he or she has 2-9 unique STF addresses. If the answer is yes, the overall indicator for each of the unique STF occupancies is retained if the indicator is greater or equal to 20, and the overall indicator for each of the unique SFT occupancies is updated from ‘A’ to ‘T’ if smaller or equal to 5.
- FIG. 14 is an illustrative portion of a table (in a spreadsheet) that can be presented to a user.
- the presentation can be made in an electronic format to facilitate any desired sorting by rank, indicator, or other fields or attributes of the occupancies. All of the occupancies for a person can be presented, or only some occupancies that are above certain threshold in terms of rank or indicator can be presented, depending on the user's need or request. For example, where only the most preferred occupancies for a person (e.g., those satisfy a condition of a high rank, a high-end indicator, or a combination of both) are desired or requested by the user, the presentation includes not presenting the occupancy or occupancies that do not satisfy the given condition.
- the user can readily note the currency and the reliability of the occupancy, thus can be empowered to make informed decision as to how to utilize the occupancy.
- Multiple occupancies associated of multiple persons can be similarly presented after the occupancies are obtained and processed by the address intelligence techniques.
- an occupancy can include type and category information, e.g., home address or a professional location. Further refinement is available to assign a category of professional office, such as Institutional, Outpatient or Nursing Home. These attributes can be obtained either directly from the external or internal sources, or through the application of some aspects of the address intelligence techniques.
- a series of examples for the occupancy ‘type’ are illustrated in FIG. 2 .
- the techniques of the described subject matter can be implemented on a computer apparatus, special purpose hardware, or computers in a client/server environment that includes one or more processors, memory, input devices, output devices, communication devices and networks, and data storage devices (e.g., computer readable media) using software or firmware programmed to implement the techniques.
- instructions embodying the described techniques can be included in a computer readable medium, such as a DVD, CD, hard disk, nonvolatile memory, computer chip, or the like.
- the computer apparatus can include the computer readable medium.
- the computer apparatus can include processors in communication with the computer readable medium to receive the instructions embodied thereon.
- the processors can be in communication with one or more memories for storing and/or accessing data for the techniques.
- the data can include one or more of the tables or other data of the described techniques.
- the computer apparatus can also include multiple processors, processing the described techniques in parallel or processing the described techniques in a separable manner such that a first one or more processors can process a first portion of the techniques while a second one or more processors processes a second portion of the techniques.
- results of the techniques can be stored in a memory, such as a database, as appropriate.
- the results can be provided to another entity, such as a customer, in any appropriate format, such as a data file, physical representation (e.g., on paper), or the like.
- the results can be delivered over one or more networks to the other entity as appropriate.
- the techniques include one or more software applications for implementing the described techniques.
- the separation of software applications can be done in any appropriate manner, such as designating a first software application to calculate the weights and ranks as described above and a second application to assign the indicators and to perform the remainder of the processing.
- the processing for a software application can be distributed across multiple processors and/or computer apparatuses or be embodied in a single processor or computer apparatus (in the latter multiple processors and computer apparatuses can work together to accomplish the described techniques).
- an address/occupancy can represent a physical location of a person or other entity as appropriate.
Abstract
Description
- This application claims priority to U.S. Provisional Application No. 61/158,793 filed on Mar. 10, 2009 and is incorporated by reference in its entirety.
- A compilation of addresses of potential and existing customers is an important asset for any company that uses traditional methods to identify, manage and allocate the multiple types of addresses that are configured for a professional to meet multiple operational needs for customer management, personal and non-personal communications. However, it can be a daunting task to keep a large compilation of addresses up-to-date and accurate.
- A person often has multiple addresses of different types or categories. These addresses can enter into private or public records through many channels, for example, state or federal government authorizations, licensing or certification, membership in professional associations, registration of real property or motor vehicles, posting in advertisements, etc. After the addresses become available in these original sources, they can later be transferred to, shared or purchased by myriads of organizational entities including the government, communities, or commercial vendors (these become “secondary sources” for the addresses). The reliability of some of these sources can be questionable, as they are typically not actively monitored. For example, when a person changes his or her address, the change often is likely reflected in only a few of the above sources at the outset (and can percolate through other sources at different times). As a result, many sources, especially the secondary sources, can contain a significant portion of outdated addresses.
- A user may want to gather the addresses of the persons of interest from various sources. However, the use of multiple address sources does not guarantee a broader reach to the targeted audience, but instead can create confusion and cause more waste. This is due to not only the varying reliability of the individual sources, but also the conflicts or inconsistencies of the addresses provided by the different sources. For example, an address can be present in one source, but not another; a person can have multiple office addresses reported by different sources, yet no information is available as to which one is more current. Without further analysis or investigation, a user of such addresses will not be able to use them effectively.
- Therefore, there is a need for systems and methods that can assess the currency and reliability of addresses obtained from various sources, as well as to reconcile the inconsistencies of a large amount of addresses obtained from different sources. There is also a need for presenting the analyzed addresses to a user in an understandable format to allow the user to more effectively use the addresses.
- Systems and methods for determining the present status of at least one occupancy of one or more individuals based on one or more occupancy data sources are described. In some embodiments, the techniques include obtaining the at least one occupancy of said one or more individuals from said one or more sources; computing a score of said at least one occupancy by a computer processor based on the currency and the relative trustworthiness of said one or more sources; and determining said present status of said at least one occupancy based on said computed score. The techniques can also include presenting the at least one occupancy in a user readable format.
- In some embodiments, the occupancy is obtained from at least one external source. For such an embodiment, computing the score for an occupancy can include obtaining an age of the occupancy, assigning a weight point to each of one or more instances of the occupancy based on the age and the relative trustworthiness of the at least one external source, and obtaining a score of the occupancy by summing up all of the weights of the one or more instances of the occupancy.
- In some embodiments, the score of an occupancy is an overall score and computing the score includes combining an internal score and an external score of an occupancy.
- In some embodiments, the techniques further include additional verification or validation based on one or more criteria for supplementing missing information of an occupancy, correcting an error existent in an occupancy as reported, validating an occupancy, updating the present status of an occupancy, and/or resolving a conflict between multiple occupancies associated with a person.
- For a more complete understanding of example embodiments of the described subject matter and its advantages, reference is now made to the following description, taken in conjunction with the accompanying drawings, in which:
-
FIGS. 1A and 1B depict structures of three database tables and some occupancy data as obtained by a procedure according to some embodiments of the described subject matter. -
FIG. 1C depicts a diagram for linking a database table in an external source with a database table in an internal source via a bridging table according to some embodiments of the described subject matter. -
FIG. 2 depicts a diagram for setting flags of address types for occupancies according to some embodiments of the described subject matter. -
FIG. 3 depicts a database table relating to computing of the age of an occupancy according to some embodiments of the described subject matter. -
FIG. 4 depicts a scheme relating to computing the age of an occupancy according to some embodiments of the described subject matter. -
FIG. 5 depicts a scheme for assigning weight points for an occupancy according to some embodiments of the described subject matter. -
FIG. 6 depicts a scheme relating to deriving a rank and an indicator based on the score of an occupancy according to some embodiments of the described subject matter. -
FIG. 7 depicts a database table obtained by processing occupancies received from an external source according to some embodiments of the described subject matter. -
FIG. 8 depicts a diagram relating to evaluating the internal indicator of an occupancy according to some embodiments of the described subject matter. -
FIG. 9A depicts a diagram relating to evaluating the internal score of an occupancy according to some embodiments of the described subject matter. -
FIG. 9B depicts a scheme for incrementing the internal score for an occupancy according to some embodiments of the described subject matter -
FIG. 9C depicts a scheme relating to deriving an internal rank and an internal indicator based on the internal score of an occupancy according to some embodiments of the described subject matter. -
FIG. 10A depicts a diagram relating to deriving an overall score of an occupancy according to some embodiments of the described subject matter. -
FIG. 10B depicts a scheme relating to deriving an overall rank and an overall indicator based on an overall score of an occupancy according to some embodiments of the described subject matter -
FIG. 11 depicts a diagram relating to evaluating the overall indicator of an occupancy according to some embodiments of the described subject matter. -
FIG. 12 depicts a diagram relating to evaluating the overall indicator of an occupancy according to some embodiments of the described subject matter. -
FIG. 13 depicts a diagram relating to evaluating the overall indicators of multiple occupancies associated with a person according to some embodiments of the described subject matter. -
FIG. 14 depicts a portion of a table containing a number of occupancies presented in a user readable format according to some embodiments of the described subject matter. - The described techniques herein include providing a user with one or more addresses of a person of interest. The techniques are hereinafter referred to as the “address intelligence techniques.” The address intelligence techniques are based on an analysis of the currency of an occupancy, the source(s) where the occupancy is obtained, as well as an evaluation of the occupancy based on a set of criteria designed using the characteristics of the occupancy. The techniques ‘score’ an occupancy based on cumulative quantity of the occupancy reported by the various sources as well as the currency and quality of these sources. Such a score can be converted to a rank representing the degree of confidence with respect to currency of the address. In situations where a person has multiple locations, the technique can select the best address or addresses according to the rank, the indicator, or a combination of both. The address intelligence techniques further allow the reconciliation of the inconsistencies existent in large collections of occupancies reported from different sources, thus enabling more effective use of these occupancies.
- As used in the present application, the word “person” includes a person whose address(es) is obtained and processed by the address intelligence techniques disclosed in the presently described subject matter. Certain aspects of the described subject matter are illustrated in the context of the healthcare industry where the person of interest can be a healthcare professional, e.g., a physician, an administrative contact of a healthcare organization, etc. The term “person” can include a prescriber who has prescription qualification (e.g., a physician), a mid-level practitioner (e.g. Nurse of Physician's Assistant), or more generally a “professional.” The presently described techniques can be applied to persons of any category or industry, and is not limited to persons in the healthcare industry.
- The term “service provider” includes an individual or organization that may use the address intelligence techniques described herein to obtain, procedure, and present data for its customer(s).
- The term “occupancy” includes a unique combination of an identifier of a person and an address of the person. As a name can be shared by many persons, a person can be represented by a unique identifier, such as SSN#, license number, etc. A person can have multiple different addresses, and they can be of different types (e.g., office, home, mailing, etc.). These different addresses combined with the same person can be referred to as different occupancies associated with the person. Note that one occupancy, e.g., “David Smith, 123 Main Street” can be reported multiple times by different sources. This can be referred to as the multiple instances of an occupancy, rather than different occupancies. An occupancy can include other attributes, such as the affiliation or specialty of a person, or the type or category of an address (e.g., home, office, etc.).
- The techniques disclosed in the presently described subject matter include the following: obtaining the at least one occupancy of said one or more individuals from said one or more sources; computing a score of said at least one occupancy by a computer processor based on the currency and the relative trustworthiness of said one or more sources; and determining a present status of said at least one occupancy based on said computed score.
- An occupancy can be obtained from one or more external and internal sources. “External sources,” as used herein, include sources of occupancies that are not proprietary databases of the service provider. They include but are not limited to: reference files purchased or made publicly available by the Drug Enforcement Agency (DEA), American Medical Association (AMA), American Osteopathic Association (AOA), National Provider Identifier (NPI), State License Number (SLN), Yellow White Pages (YWP), and GM Loadstone (GML). The reference files can be updated periodically, e.g., daily, weekly, or monthly. “Internal sources” include one or more proprietary databases maintained by a service provider, e.g., IMS's primary research databases for professionals: MI CORE™ and PHOENIX™. An occupancy can be obtained from the one or multiple such sources, or combinations thereof. Multiple instances of an occupancy associated with a person can be obtained from the multiple sources. It is understood that internal sources can operate similarly as the external sources. For example, the MI CORE™ database, used throughout the present application merely for illustrative purposes, is organized in a substantially similar fashion as other commercial databases.
- Obtaining occupancy data from external sources can take various routes. One such route is through periodically receiving a feed from a vendor which provides occupancy data to the service provider. An example of obtaining occupancies from an external source is illustrated in
FIG. 1A , wherein an external source such as the DEA reference file is integrated into REFERENCE FILE MASTER (or “RF MASTER”), a database containing a master collection of external occupancy data, maintained by the service provider. For example, on Jan. 15, 2009, the following addresses are received for one John Doe and one Jane Doe from DEA: -
A12345678 John Doe 123 Main Street Bedford NH 03110B98765432 Jane Doe 456 West Blvd Plymouth Meeting, PA 00011
where A12345678 and B98765432 are identifiers used by the DEA. A “SOURCE COMPARE” procedure can be run to integrate the data obtained from the DEA file to the PROFESSIONAL, ADDRESS OCCUPANCY, and ADDRESS SOURCE TAG tables in the REFERENCE FILE MASTER, whose structures are illustrated inFIG. 1A . In one exemplary embodiment, the procedure can be performed as follows for each entry received from the DEA: - First, if the person's information is not yet in the REFERENCE FILE MASTER, the person is added to the PROFESSIONAL table. For example, suppose the two entries are first reported by the DEA to the REFERENCE FILE MASTER, the entry relating to John Doe representing a new person. The procedure first creates an entry in the PROFESSIONAL table for John Doe, and then a Postal Standardized entry in the ADDRESS OCCUPANCY table for John Doe at 123 Main Street, Bedford N.H. 03110. Further, John Doe's address can be “source tagged” by creating an entry in the ADDRESS SOURCE TAG table for the address with the ‘source’ of DEA, and setting a ‘start’ date and ‘change’ date to the data of file receipt. As used herein, the start state of an occupancy refers to the date when the occupancy was first reported by an external data source to the service provider; the change date of an occupancy refers to the date when the occupancy was last referenced by an external data source (as seen by the SOURCE COMPARE procedure). For example, if an external source reported an occupancy in the first month, but stop reporting the occupancy in the subsequent two months, the change date of the occupancy at the end of the three-month period would still be the reporting date in the first month. If however, the occupancy was repeatedly reported by a source for three consecutive months, then the change date at the end of the three-month period is the last reporting date of the reference file. The change date is herein also referred to as a ‘recency’ date.
- If the person already exists in the REFERENCE FILE MASTER, the ADDRESS OCCUPANCY table is checked as to whether the
address 123 Main Street Bedford N.H. is attached to John Doe. If the address does not already exist, a Postal Standardized entry can be created in the ADDRESS OCCUPANCY table for John Doe at 123 Main Street, Bedford N.H. 03110, and then an entry can be created in the ADDRESS SOURCE TAG table for the address with the ‘source’ of DEA, and the start date and recency date can be set to the data of file receipt. If the address does exist for John Doe, the ADDRESS SOURCE TAG table can be checked as to whether the address has previously been sourced by the DEA reference file. Again, there are two possibilities (when the address exist for John Doe): if the address has never been sourced by the DEA before, an entry can be created in the ADDRESS SOURCE TAG table for the address with the ‘source’ of DEA, and the start date and recency date set to the data of file receipt; if the address has been sourced by the DEA before, the entry in the ADDRESS SOURCE TAG table can be updated for the address with the ‘source’ tag of DEA by re-setting the recency date to the data of file receipt. - The result of this exemplary SOURCE COMPARE procedure and the results visible within the REFERENCE FILE MASTER is illustrated in
FIG. 1A . - If further, for example, on Feb. 14, 2009, two address entries were received from DEA about John Doe and Jane Doe, respectively:
-
A12345678 John Doe 750 East Street Manchester NH 03110B98765432 Jane Doe 456 West Blvd Plymouth Meeting, PA 00011 - And on Feb. 10, 2009, an address was received from AMA about John Doe:
-
A12345678 John Doe 750 East Street Manchester N.H. 03110 - The SOURCE COMPARE procedure is repeated on these three entries (all on the same day, or separately, e.g., on the days the respective entries were received). The results are reflected in the relevant tables, as illustrated in
FIG. 1B . - Further, in some embodiments, an internal operative database, e.g., MI CORE™, can be configured to link or integrate with REFERENCE FILE MASTER using standard database technologies, as illustrated in
FIG. 1C . A subset of REFERENCE FILE MASTER can contain a set of data tables: ADDRESS OCCUPANCY, PROFESSIONAL, and ADDRESS SOURCE TAG. The tables can be linked with occupancy data contained in an internal source, for example, MI CORE™, via a bridging table (e.g., MIIL_RFM_ADDR_BRDG (20)), which contains an ADDR_ID field being used to reference the key ADDR_ID in a table MIIC_PRSCRBR_ADDR (30) of the MI CORE™ database, and a RFM_ADDR_KEY field being used to reference a field RFM_ADDR_KEY (a unique address identifier used in REFERENCE FILE MASTER) of a table ADDRESS OCCUPANCY (10) in the REFERENCE FILE MASTER. For a new occupancy reported in REFERENCE FILE MASTER which does not have a previous corresponding ADDR_ID in the internal operative database (i.e., the linking attempt will fail for this occupancy), a new occupancy entry having a unique ADDR_ID can be created in the internal source MI CORE™. - The externally sourced occupancy data does not necessarily solely originate from a third party provider; the occupancies can also be directly collected by the service provider itself into so called “internal sources.” Therefore, the internal sources, as previously noted, can also contain occupancy data which are similarly referenced by various external sources. Additionally, the internal sources can include database entry systems that employ manual input of an occupancy on a more individual basis (as opposed to importation of entire occupancy databases), and therefore can contain data that are collected through means other than the automated SOURCE COMPARE procedure, for example, by directly contacting with a physician and obtaining the physician's address, or data relating to information about the physicians other than occupancies, such as affiliations, date of birth, specialties, etc. These data are herein referred to as “internally sourced data,” and are typically validated in some ways, the validation techniques including, for example, direct contact by phone, or through comparing some other sources that have high reliability of currency, such as rosters posted on organizational websites. They can be generally maintained in the MI CORE™ and/or PHOENIX™ databases or other internal sources.
- Further, in some embodiments, a certain portion of the externally sourced occupancies can be later be verified or validated by an internal procedure, therefore an originally externally sourced occupancy can also acquire attribute(s) that indicates a modification history by an internal verification or validation procedure. These occupancies can be referred to as dually sourced occupancy data; they can still be tagged with the particular external sources from which they are received for processing as detailed below. It is noted that REFERENCE FILE MASTER database includes both the master collection of all the externally sourced data and internally sourced data.
- In some embodiments, an occupancy obtained from an external source can optionally be further categorized according to type or category of the address.
FIG. 2 illustrates some of the exemplary approaches for the categorization. In one embodiment, a database table field pt_address_loc is used to update the category information based on a set of criteria. For example, if an address link, via the ADDR_ID (in the MI CORE™ database), is found to link to (or associated with) an organization within the IMS Healthcare Organizational Services (HCOS) database, and is currently marked as Home, Unknown, Neither, or Both, then the pt_address_loc field for the occupancy is updated to “office.” - In another embodiment, an externally sourced occupancy can then be processed to derive a score based on the currency and relative trustworthiness of the source from which the occupancy data is obtained.
- In some embodiments, an “approval age” (or “age”) of an occupancy can be derived to reflect the currency of the occupancy. The age can be computed using either or both of the start date and the change date as a reference approval date. The start date and change date can be obtained from a database table designed or assembled to keep track of the update history of the external source reporting the occupancy. An example of such a table is shown in
FIG. 3 . These calculations can be maintained in a staging database, outside of but linked to the MI CORE™, and can be updated weekly or whenever a new SOURCE COMPARE procedure is run. - It is noted that if multiple instances of the same occupancy are extracted from multiple external sources, a separate start date and change date can be maintained for each instance of the occupancy (i.e., an occupancy will be tracked individually for each source).
- In one embodiment, the age of an occupancy can then be derived by assigning a number to the occupancy based on the number of days elapsed since the relevant reference approval date of the specific external source relative to the present date. For example, it can be done in a manner described in
FIG. 4 , where the age of occupancy data is assigned to a scale of 0-7 depending the days elapsed since the reference approval date, where greater ages correspond to more days elapsed. - In some embodiments, a weight point can then be assigned to an occupancy based on the age and the relative trustworthiness of the source from which the occupancy is obtained. For example, greater positive points can be used to represent occupancy data having a “younger” age, which indicates more reliability and better currency of the occupancy. Smaller positive points or negative points are assigned to an older occupancy. Some sources are more trustworthy and therefore an occupancy having a certain age obtained from these sources is assigned a greater weight point as compared to an occupancy having the same age obtained from other sources. The relative trustworthiness of a source can be assessed by the type of the source, e.g., whether it has a government mandated update procedures, or by collecting a portion of occupancy data from the source and performing statistical or manual validation. An illustrative weight point assignment scheme is presented in
FIG. 5 , where src_no represents the identifier of an external source, and the ext_points represent the weight points assigned based on the source and recency. Since the AMA database is assessed to have a greater trustworthiness compared to DEA, an occupancy having an age of 1 is assigned 10 weight points, as opposed to the 8 points assigned to an occupancy having the same age but obtained from the DEA database. - In certain embodiments, a score is further derived for an occupancy based on the weight point(s) given to the occupancy from each of the one or more external sources from which the occupancy is obtained. If there are multiple instances of the occupancy from difference sources, the score can be derived by summing up the individual weight points assigned to each instance of the occupancy associated with the person. If there is only one instance of the occupancy, the score can be the same as the weight point assigned to such an occupancy.
- In some embodiments, an indicator can be computed for or assigned to an occupancy based on the score of the occupancy. The indicator can reflect the present status of the occupancy. The indicator can be ‘P’ (for “preferred active”), ‘A’ (for “active”), ‘T’ (for “transitional”), ‘U’ (for ‘unknown’), ‘O’ (for “old”), and ‘D’ (for “deleted”), reflecting in a decreasing order of currency. For convenience, the status indicators ‘P’ and ‘A’ are called high-end indicators. In some embodiments, a rank can be further assigned to an occupancy based on the score of the occupancy.
-
FIG. 6 outlines an illustrative scheme for assigning indicator values and ranks based on the calculated score of an occupancy. For example, ‘A’ can be assigned to an occupancy having a score greater than 5, ‘T’ can be assigned to an occupancy having a score between 1-4, ‘U’ can be assigned to an occupancy having a score of 0, and any occupancy having a score less than or equal to −1 is assigned as “Old” (O). Further, a rank can be derived by converting the score, which can have a rather large numerical value (e.g., in the negative tens to the positive tens), into an integer in a smaller range, e.g., in the range of −10 to −10, for the purpose of a more intuitive presentation to a user: higher ranks signifies higher degree of confidence with respect to currency of the occupancy, and therefore generally correlates to high-end indicators such as ‘P’ or ‘A.’ It should be understand that any number of indicators and ranges of ranks can be used; the above is provided merely for illustrative purposes and is not meant to provide a limitation of the described subject matter. - It is noted that the above translation from age and source of an occupancy to the rank of occupancy is suitable for the majority of occupancies. However, in some embodiments, there are some differences for situations where an address is sourced by the SLN. Generally, three custom formulas can be used depending on whether the occupancy is sourced by SLN, i.e., (1) solely by SLN; (2) by non-SLN sources only; and (3) by SLN and another trusted source. These formulas apply (+) and (−) points on top of the base score as determined by the source, the approval age, and the number of sources reporting an occupancy. For example, if the occupancy is obtained solely from SLN, the weight points are adjusted ‘less harshly’ for occupancies with older recency dates, because the SLN files are not fully refreshed monthly, but instead, quarterly. Other reference files run monthly and occupancies older than 45 days are treated with increasing skepticism the older the recency date. If the occupancy is obtained from SLN and another trusted source, such as a source where approval_age=1 is assigned 8 or greater points, then the ‘negative SLN’ points are disregarded.
- In some embodiments, the above derived score, indicator and rank for an externally sourced occupancy can be assembled and stored into a table.
FIG. 7 illustrates the structure of such a table, named “RFM_intelligence.” The table can be used for further processing needs. For example, at the next SOURCE COMPARE procedure, if an occupancy is dropped from the newly received external source file(s), then the new score, indicator, and rank of the occupancy can be computed according to the steps outlined above using the saved information from this table, and then stored back in this table to replace the corresponding previous values. - The above noted score, rank, indicator of an occupancy can refer to an external score, rank, and indicator, as they are derived solely from the quality and recency of an external source(s). As discussed hereafter, an internal score, rank, and indicator can be derived from internal validation and/or update history of an occupancy, which occupancy can be either externally sourced or internally sourced.
- In some embodiments, after occupancy data are obtained (either from internal or external sources) and processed, one or more additional quality check steps can be performed to further improve the accuracy and reliability of the occupancy data before presenting them to a user. Collectively, these quality check steps are referred to as the quality check technique, or simply the quality check. The quality check can be incorporated into the address intelligence techniques by refining the score, rank, and/or indicator of an occupancy to make these parameters more realistically reflect the currency and the confidence of the currency of the occupancy. The quality check technique can have one or more of the following features: to supplement missing information for an occupancy, to resolve conflicts of multiple occupancies associated with a person, to update the present status of an occupancy, to correct an error contained in an occupancy as reported from an external source(s), and to validate or confirm an occupancy.
- Further details of an exemplary quality check technique are illustrated as follows. The quality check technique can start with loading a database table containing occupancy data. The table can be an expanded database table formed by linking occupancy data from an internal source (e.g., an
address table core_address_work —1, denormalized, from the MI CORE™ database) and an external source (e.g., a table of REFERENCE FILE MASTER). A Street Front ID, which can be an identifier for the street front portion of the address of an occupancy (e.g., an address with the suite/apartment/room number omitted), can be derived from the MIIC_ADDR table and included in the expanded database. Some attributes from REFERENCE FILE MASTER that may be of interest to a user can also be included in the expanded table. One of such attributes is “deliverability” which reflects the likelihood that a mail can be correctly delivered to the address. Thereafter, some key variables for the quality check technique are initialized with default values as follows. -
INT_IND = ‘U’ INT_SCORE = 0 INT_RANK = 0 EXT_IND = ‘U’ EXT_SCORE = 0 EXT_RANK = 0 ADDR_IND = ‘U’ ADDR_SCORE = 0 ADDR_RANK = 0 NEG_CODE = 0
wherein INT_IND represents the internal indicator, INT_SCORE represents the internal score, INT_RANK represents the internal rank; EXT_IND represents the external indicator, EXT_SCORE represents the external score, EXT_RANK represents the external rank; ADDR_IND represents the overall indicator, ADDR_SCORE represents the overall score, and ADDR_RANK represents the overall rank ADDR_IND is also abbreviated by IND. NEG_CODE is a code designed for internal auditing purpose (e.g., to identify the point where the quality check terminates). As used herein, the internal score, internal rank, and internal indicator are attributes of an occupancy (either internally sourced or externally sourced) that can be modified based on some criteria further explained below. - In one embodiment, the quality check technique includes one or more testing of conditions for an occupancy. This technique can be generally viewed as sending an occupancy through a series of checkpoints, and at each checkpoint, checking the occupancy against a given criterion (or query). If the occupancy does not satisfy the criterion, its indicator value (such as an internal indicator for purely internally sourced occupancy, or an external indicator for externally sourced occupancy without internal support, or an overall indicator for dually sourced occupancy) is updated, a NEG_CODE is set, and the quality check terminates. Otherwise, the occupancy is sent down to one or more other checkpoints for further inspection. It is noted, however, the specific order, number, or specific tests performed for each criterion of the checkpoints are not critical to the efficacy of the method, although they may affect the efficiency of the quality check technique. For example, certain orders of performing the quality check may allow the procedure to terminate earlier when a “termination” condition is met, e.g., when a definitive result is reached as to the present status of an occupancy.
- In some embodiments, the quality check includes manual validation or verification of an occupancy. For example, if a customer informs the service provider by phone that the customer just moved to a new address, the address is accordingly updated, e.g., its internal score is set to the highest possible value, and its overall indicator is set to “P.” With the “aging” of such an update, the score and indicator may be later modified.
- In some embodiments, manual verification or validation can also form the basis for other aspects of the quality check technique, which can use the result of a manual verification (or whether there has been a manual verification) as part of a test criterion. Manual verification can be used when externally sourced occupancy data contain some specific types of information or errors that trigger such a manual verification procedure.
- In some embodiments, the quality check includes updating the present status of an occupancy and/or correcting an error in an occupancy by overriding an initially computed indicator of an occupancy to ‘O’ or ‘D’. For example, it can include checking an occupancy as to whether the person or the address has expired, as illustrated in
FIG. 8 . At 110, a query is presented for an occupancy of interest: “is prescriber expired or logically deleted?” If the answer is yes (an indication that this particular person should never have been included in the IMS database as he or she is not a professional which IMS maintains information or the record was a mistake or incomplete), the IND variable is assigned a value of ‘D’ (for “deleted”) at 120, NEG_CODE is set to 1, and the quality check terminates. Otherwise (i.e., the answer is no), the occupancy can be further checked at one or more other checkpoints, e.g., 130. - At 130, for example, an occupancy is checked as to whether the prescriber status code is something other than active or semi retired. If the answer is yes, the IND variable is assigned a value of ‘O’ (for “old”) at 140, NEG_CODE is set to 2, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 150.
- At 150, for example, an occupancy is tested as to whether its address has expired or logically deleted. If the answer is yes, the IND variable is assigned a value of ‘D’ at 160, NEG_CODE is set to 3, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 170.
- At 170, for example, an occupancy is tested as to whether its address type is one of the three prior address codes (primary mailing, prior home, and prior office). If the answer is yes, the IND variable is assigned a value of ‘O’ at 180, NEG_CODE is set to 4, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints, e.g., 190.
- At 190, for example, an occupancy is tested as to whether its DOB and decile suggest the prescriber is dead or retired. As used herein, “decile” is an indicator of quantity of prescriptions a prescriber wrote in a given period relative to all other prescribers, which can be obtained from a prescription database. For example, decile can be set at levels 0-10, with 5 representing a quantity of prescriptions such that 50% of the prescribers wrote more scripts than this professional and 40% of professionals writing fewer prescriptions. If any of the three combinations of a DOB and a decile at 190 is true, then the answer is yes, the IND variable is assigned a value of ‘O’ at 200, NEG_CODE is set to 5, and the quality check terminates. Otherwise, the occupancy can be further checked at one or more other checkpoints of the quality check technique.
- The formulation of a specific criterion in these embodiments (as illustrated in
FIG. 8 ) can be based either on a manual validation as explained above (e.g., at 110), or a characteristics of the occupancy data itself (e.g., at 190), or both (e.g., at 130). - In some embodiments, the quality check includes modifying the internal score of an occupancy using a set of criteria. The occupancy can either be externally sourced or internally sourced.
FIG. 9A illustrates this aspect of the quality check technique. At 210, the quality check tests whether the occupancy is confirmed via a manual or semi manual affiliation in a tool/database for tracking the organizational affiliation of a professional (e.g., the PHOENIX™ database available from IMS Health). If the answer is yes, the internal score is incremented at 220 from a previous value (e.g., the default value of 0) based on the internal approval age of the occupancy, which indicates the time lapse since the last time when this occupancy was confirmed by an analyst by direct call, email, etc., with the person. If the answer is no, the internal score is not updated (at 230). - At 240, for example, an occupancy is tested as to whether it has a high level internal address type code, namely, primary office (‘PO’) or ‘office’ (‘O’). “Internal address type” as used herein refers to the address type assigned to an occupancy either based on the source where the occupancy is obtained, which can be later validated by an analyst using manual validation. The internal score is incremented at 250 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 260).
- At 270, for example, an occupancy is tested as to whether it has a low internal address type level, e.g., preferred mailing (‘PM’), home (‘H’), and mailing (‘M’), with an approval age less than or equal to 12 months. If the answer is yes, the internal score is incremented at 280 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 290).
- At 300, for example, an occupancy is tested as to whether it is confirmed via a high level affiliation with GML, e.g., P/T1/A1. GML is an external data claims data source that contains not only a professional address, but also the organizational affiliation and the affiliation type field, which is used to describe the recency and accuracy of the affiliation. If the answer is yes, the internal score is incremented at 310 from the previous value based on the internal approval age of the occupancy. If the answer is no, the internal score is not updated (at 320).
- In some embodiments, the concept for internal scoring mirrors the concepts for external scoring. For example, there are two major internal sources, such as MI CORE™ and PHOENIX™. Within each source there are different “sub sources” representing different types of manually based verification. From PHOENIX™, the three techniques indicate whether the result is based off of a manual phone call (RT), an analyst verifying results from a web-site after a telephone call to the organization to verify the contents of the web site are current (FL) or whether the web sites contents were automatically updated into the database after a telephone call to the organization to verify the contents of the web site are current (BFL). For MI CORE™, the six variations and relative points are based on when the address was inserted by a user, the person was marked as validated or the occupancy was marked as Manually Verified and whether the address was marked as an OFFICE or PRIMARY OFFICE. Based on the dates when any of these activities for PHOENIX™ or MI CORE™ took place and approval age and score are assigned.
FIG. 9B represents a portion of an exemplary table summarizing the weight points that can be assigned based on the different sources, sub sources, and approval age. - In one embodiment, the internal rank and internal indicator of an occupancy can be updated using the updated internal score. This can be done in a similar manner as the case for deriving the external indicator from an external score. An exemplary conversion table is illustrated in
FIG. 9C . - In some embodiments, the quality check technique includes combining the internal and external score of an occupancy to derive an overall score of the occupancy. The overall score of an occupancy can then be used to compute an overall indicator with an improved reliability relative to the internal indicator and the external indicator alone.
FIG. 10A illustrates an example for implementing this aspect of the quality check technique. An occupancy is first obtained from the expanded database table combining REFERENCE FILE MASTER and MI CORE™. At 350, the quality check technique tests whether the occupancy is available in the REFERENCE FILE MASTER using the table “RFM_intelligence” (the summary table created at the end of SOURCE COMPARE procedure, seeFIG. 7 ). If the answer is yes, the external score, rank and indicator stored for the corresponding occupancy in the table are imported (at 360); otherwise, the external score, indicator, and rank of the occupancy are set at 370 to their default values, e.g., 0, ‘U’ (for “unknown”), and 0, respectively. Subsequently, at 380, an overall score of the occupancy is computed as the sum of the internal score and the external score. The overall score can be used to compute an overall rank (e.g., from −6 to 10) and an overall indicator (e.g., ‘P’, ‘A’, ‘T’, ‘U’, ‘O’, ‘D’, etc.).FIG. 10B presents an example of how the overall score can be used to derive an overall rank and an overall indicator. - In some embodiments, the quality check includes evaluating the overall indicator of an occupancy based on a set of criteria based on the external and/or internal score, and/or external and/or internal indicator, among others factors reflecting the internal update history of the occupancy.
FIG. 11 illustrates a way of implementing this aspect of the quality check technique. At 410, the quality check technique tests whether the external indicator of the occupancy is ‘A’ (with or without internal support). If the answer is yes, at 420, the overall indicator value is set as ‘A’, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 430. - At 430, for an occupancy of interest, the quality check technique tests whether this criterion is satisfied: “Is the occupancy has an external address type, and is not in the REFERENCE FILE MASTER, and has no internal support?” As used herein, “internal support” means that an occupancy has been confirmed or validated by an analyst using some manual checks, e.g., via telephone, email, or other means of communication with the person of the occupancy. If the answer is yes, at 440, the overall indicator value is set to ‘O’, the NEG_CODE is set to 56, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 450.
- At 450, for example, for an occupancy of interest, the quality check technique tests whether this criterion is satisfied: “Is the external indicator of the occupancy ‘O’, its internal indicator ‘U’, and the occupancy was not inserted or validated in the last 90 days?” If the answer is yes, at 460, the overall indicator value is set to ‘O’, the NEG_CODE is set to 50, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 470.
- At 470, for example, an occupancy is tested as to whether its external indicator is ‘T’ and that it has no internal support. If the answer is yes, at 480, the overall indicator is set to ‘T’, the NEG_CODE is set to 55, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 490.
- At 490, for example, an occupancy is tested as to whether it has a MII or US address type and no internal support. (In one embodiment, MII represents an address originally based on an affiliation in PHOENIX™ that no longer exists. US represents a user attempt to verify an address that was unsuccessful. The address could not be confirmed as old or invalid but it is strongly suspected as such.) If the answer is yes, at 500, the overall indicator is set to ‘T’ (for MII address type) or ‘O’ (for US address type), with the corresponding NEG_CODE set to 51 or 52, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 510.
- At 510, for example, an occupancy is tested as to whether it has no internal or external support, and has the internal insert date of more than 90 days. The term “external support” as used herein refers to the presence or availability of an external source from which the occupancy is obtained and the age of the occupancy can be determined. If the answer is affirmative, at 520, the overall indicator is set to ‘O’, the NEG_CODE is set to 58, and the quality check terminates. If the answer is negative, the occupancy can be further checked at one or more other checkpoints, e.g., 530.
- At 530, for example, an occupancy is tested against this criterion: “Are the following conditions all true: the external indicator of the occupancy is ‘O’; the internal indicator of the occupancy is ‘U’; the occupancy was not inserted in the last 90 days; and the occupancy was not validated in the last 90 days.” If the answer is affirmative, at 540, the overall indicator is set to ‘O’, the NEG_CODE is set to 59, and the quality check terminates. If the answer is negative, the occupancy can be further checked at one or more other checkpoints, e.g., 550.
- At 550, for example, an occupancy is tested as to whether its external indicator is ‘T’ while its internal indicator is ‘U’. If the answer is yes, at 560, the overall indicator is set to ‘T’, the NEG_CODE is set to 60, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 570.
- At 570, for example, an occupancy is tested as to whether it was inserted in the last 3 months or validated in the last six months and still marked as ‘U’. If the answer is yes, at 580, the overall indicator is set to ‘A’, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 590.
- At 590, for example the occupancy is tested as to whether it was inserted in the last 3 months or validated in the last six months and still marked as ‘U’. If the answer is yes, at 600, the overall indicator is set to ‘T’, the NEG_CODE is set to 305, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 610, as explained below.
- In some embodiments, the quality check technique includes evaluating the validity of a previous determination of an overall indicator having an ‘A’ value.
FIG. 12 illustrates an embodiment for implementing this aspect of the quality check technique. At 610, for example, an occupancy is tested as to whether any portion of its address has a ‘NULL’ or ‘INVALID’ value. If the answer is yes, at 620, the overall indicator is set to ‘O’, the NEG_CODE is set to 61, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 630, as explained below. - At 630, the occupancy is tested as to whether its internal score is less than 5 while its external score is less than −6. If the answer is yes, at 640, the overall indicator is set to ‘T’ (i.e., ‘A’ is overridden), the NEG_CODE is set to 62, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 650.
- At 650, for example, an occupancy is tested as to whether the sum of 1.5× its internal score and its external score is smaller than zero, while the internal score is smaller than 8. If the answer is yes, at 660, the overall indicator is set to ‘T’, the NEG_CODE is set to 63, and the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 670.
- The formulation of a specific criterion in the above embodiments can be based either solely on the external indicator (e.g., at 410), whether there has been a prior manual validation (e.g., at 570), or a mixture of both (e.g., at 530).
- In some embodiments, the quality check includes resolving a conflict existent in the occupancy data. For example, it can include evaluating multiple addresses in non-contiguous states for a physician, because such a situation is unlikely and usually caused by errors in the reporting external sources.
FIG. 13 illustrates an embodiment implementing this aspect of the quality check technique. At 670, the quality check technique tests whether a prescriber has multiple addresses in non-contiguous states. If the answer is yes, at 680, the score for unique street front (STF) addresses for each state is aggregated, and the overall indicator for the losing state (i.e., the state with a lower aggregate STF score) is updated to ‘O’ if it is currently ‘T’, or updated to ‘T’ if it is currently ‘A’; and then the quality check terminates. If the answer is no, the occupancy can be further checked at one or more other checkpoints, e.g., 690. - At 690, for example, the prescriber associated with an occupancy is tested as to whether he or she has 2-9 unique STF addresses. If the answer is yes, the overall indicator for each of the unique STF occupancies is retained if the indicator is greater or equal to 20, and the overall indicator for each of the unique SFT occupancies is updated from ‘A’ to ‘T’ if smaller or equal to 5.
- After the one or more occupancies for a person of interests are obtained and processed according to the described techniques, they can be presented to a user, optionally together with the determined present status (e.g., represented by an overall score, rank and/or indicator) for the occupancy or occupancies, in a user readable format.
FIG. 14 is an illustrative portion of a table (in a spreadsheet) that can be presented to a user. - Any suitable form of presentation is contemplated. For example, the presentation can be made in an electronic format to facilitate any desired sorting by rank, indicator, or other fields or attributes of the occupancies. All of the occupancies for a person can be presented, or only some occupancies that are above certain threshold in terms of rank or indicator can be presented, depending on the user's need or request. For example, where only the most preferred occupancies for a person (e.g., those satisfy a condition of a high rank, a high-end indicator, or a combination of both) are desired or requested by the user, the presentation includes not presenting the occupancy or occupancies that do not satisfy the given condition. Based on the presented rank and indicator of an occupancy, the user can readily note the currency and the reliability of the occupancy, thus can be empowered to make informed decision as to how to utilize the occupancy. Multiple occupancies associated of multiple persons can be similarly presented after the occupancies are obtained and processed by the address intelligence techniques.
- Other useful attributes of an occupancy can be included in the presentation. For example, an occupancy can include type and category information, e.g., home address or a professional location. Further refinement is available to assign a category of professional office, such as Institutional, Outpatient or Nursing Home. These attributes can be obtained either directly from the external or internal sources, or through the application of some aspects of the address intelligence techniques. A series of examples for the occupancy ‘type’ are illustrated in
FIG. 2 . - The techniques of the described subject matter can be implemented on a computer apparatus, special purpose hardware, or computers in a client/server environment that includes one or more processors, memory, input devices, output devices, communication devices and networks, and data storage devices (e.g., computer readable media) using software or firmware programmed to implement the techniques.
- In some embodiments, instructions embodying the described techniques can be included in a computer readable medium, such as a DVD, CD, hard disk, nonvolatile memory, computer chip, or the like. The computer apparatus can include the computer readable medium. The computer apparatus can include processors in communication with the computer readable medium to receive the instructions embodied thereon. The processors can be in communication with one or more memories for storing and/or accessing data for the techniques. The data can include one or more of the tables or other data of the described techniques. The computer apparatus can also include multiple processors, processing the described techniques in parallel or processing the described techniques in a separable manner such that a first one or more processors can process a first portion of the techniques while a second one or more processors processes a second portion of the techniques.
- The results of the techniques can be stored in a memory, such as a database, as appropriate. Alternatively, the results can be provided to another entity, such as a customer, in any appropriate format, such as a data file, physical representation (e.g., on paper), or the like. The results can be delivered over one or more networks to the other entity as appropriate.
- The techniques include one or more software applications for implementing the described techniques. The separation of software applications can be done in any appropriate manner, such as designating a first software application to calculate the weights and ranks as described above and a second application to assign the indicators and to perform the remainder of the processing. The processing for a software application can be distributed across multiple processors and/or computer apparatuses or be embodied in a single processor or computer apparatus (in the latter multiple processors and computer apparatuses can work together to accomplish the described techniques).
- It should be noted that an address/occupancy can represent a physical location of a person or other entity as appropriate.
- The foregoing merely illustrates the principles of the described subject matter. Various modifications and alterations to the described embodiments will be apparent to those skilled in the art in view of the teachings herein. It will thus be appreciated that those skilled in the art will be able to devise numerous techniques which, although not explicitly described herein, embody the principles of the described subject matter and are thus within the spirit and scope of the described subject matter.
Claims (20)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US12/721,280 US8782025B2 (en) | 2009-03-10 | 2010-03-10 | Systems and methods for address intelligence |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US15879309P | 2009-03-10 | 2009-03-10 | |
US12/721,280 US8782025B2 (en) | 2009-03-10 | 2010-03-10 | Systems and methods for address intelligence |
Publications (2)
Publication Number | Publication Date |
---|---|
US20100235315A1 true US20100235315A1 (en) | 2010-09-16 |
US8782025B2 US8782025B2 (en) | 2014-07-15 |
Family
ID=42728742
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US12/721,280 Active 2032-03-28 US8782025B2 (en) | 2009-03-10 | 2010-03-10 | Systems and methods for address intelligence |
Country Status (6)
Country | Link |
---|---|
US (1) | US8782025B2 (en) |
EP (1) | EP2406737A1 (en) |
JP (1) | JP2012520515A (en) |
AU (1) | AU2010224157A1 (en) |
CA (1) | CA2754953A1 (en) |
WO (1) | WO2010104946A1 (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140149871A1 (en) * | 2012-11-26 | 2014-05-29 | Verizon Patent And Licensing Inc. | Service address validation tool for a service provider network |
WO2015183395A1 (en) * | 2014-05-29 | 2015-12-03 | Lexisnexis Risk Solutions Inc. | Systems and methods for determining occupancy |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10467629B2 (en) * | 2015-05-01 | 2019-11-05 | Veeva Systems Inc. | System and method for creating a new account in CRM |
Citations (51)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US3351920A (en) * | 1964-01-02 | 1967-11-07 | Xerox Corp | Thermoplastic computer memory storage system |
US3610159A (en) * | 1968-06-06 | 1971-10-05 | Bendix Corp | Automatic baggage-handling system |
US3623006A (en) * | 1970-06-29 | 1971-11-23 | Burroughs Corp | Queueing device for the selection of requests for access to a storage medium |
US3881097A (en) * | 1973-05-14 | 1975-04-29 | Weston Instruments Inc | Fully digital spectrum analyzer using time compression and discrete fourier transform techniques |
US5041921A (en) * | 1987-01-06 | 1991-08-20 | Duplitronics, Inc. | System for recording custom albums from a library of pre-recorded items |
US5598276A (en) * | 1993-10-29 | 1997-01-28 | Time Warner Entertainment Co., L.P. | System and method for controlling play of multiple versions of the same motion picture stored on an optical disk |
US5913013A (en) * | 1993-01-11 | 1999-06-15 | Abecassis; Max | Seamless transmission of non-sequential video segments |
US6016038A (en) * | 1997-08-26 | 2000-01-18 | Color Kinetics, Inc. | Multicolored LED lighting method and apparatus |
US6026304A (en) * | 1997-01-08 | 2000-02-15 | U.S. Wireless Corporation | Radio transmitter location finding for wireless communication network services and management |
US20020032612A1 (en) * | 2000-03-28 | 2002-03-14 | Williams Daniel F. | Apparatus, systems and methods for online, multi-parcel, multi-carrier, multi-service parcel returns shipping management |
US20020082892A1 (en) * | 1998-08-27 | 2002-06-27 | Keith Raffel | Method and apparatus for network-based sales force management |
US20020097651A1 (en) * | 2001-01-25 | 2002-07-25 | Watt Charles R. | System and method for performing a spin motor startup operation |
US20020136206A1 (en) * | 2001-03-20 | 2002-09-26 | Worldcom, Inc. | Recursive query for communications network data |
US20020165739A1 (en) * | 1999-05-04 | 2002-11-07 | George V. Guyan | Method and article of manufacturing for component based information linking during claim processing |
US20030009570A1 (en) * | 2001-07-03 | 2003-01-09 | International Business Machines Corporation | Method and apparatus for segmented peer-to-peer computing |
US20030033308A1 (en) * | 2001-08-03 | 2003-02-13 | Patel Sujal M. | System and methods for providing a distributed file system utilizing metadata to track information about data stored throughout the system |
US20030112809A1 (en) * | 2001-08-24 | 2003-06-19 | Bharali Anupam A. | Efficient method and system for automatic discovery and verification of optimal paths through a dynamic multi-point meshed overlay network |
US20030172053A1 (en) * | 2002-02-01 | 2003-09-11 | John Fairweather | System and method for mining data |
US20030196094A1 (en) * | 2002-04-10 | 2003-10-16 | Hillis W. Daniel | Method and apparatus for authenticating the content of a distributed database |
US20040059705A1 (en) * | 2002-09-25 | 2004-03-25 | Wittke Edward R. | System for timely delivery of personalized aggregations of, including currently-generated, knowledge |
US20040134982A1 (en) * | 2001-06-27 | 2004-07-15 | Frederic Jouvin | Shipment tracking method, device for the implementation of the method and printing device |
US20040143710A1 (en) * | 2002-12-02 | 2004-07-22 | Walmsley Simon Robert | Cache updating method and apparatus |
US20040181425A1 (en) * | 2003-03-14 | 2004-09-16 | Sven Schwerin-Wenzel | Change Management |
US20050021523A1 (en) * | 2002-01-08 | 2005-01-27 | Wafik Farag | Holistic dynamic information management platform for end-users to interact with and share all information categories, including data, functions, and results, in a collaborative secure venue |
US20050149741A1 (en) * | 2002-07-13 | 2005-07-07 | Humbel Roger M. | Autorisations, regulation, characterisation, localisation, locking and theft security system (here also referred to as lock-loop dss) |
US20050180753A1 (en) * | 2004-02-12 | 2005-08-18 | Adaptive Optics Associates, Inc. | Free space optical (FSO) laser communication system employing fade mitigation measures based on laser beam speckle tracking and locking principles |
US20050188071A1 (en) * | 2004-02-19 | 2005-08-25 | International Business Machines Corporation | Architecture for a centralized management system |
US20050234913A1 (en) * | 2002-05-28 | 2005-10-20 | Providian Financial Corporation | Method and system for creating and maintaining an index for tracking files relating to people |
US20050257083A1 (en) * | 2004-05-13 | 2005-11-17 | Cousins Robert E | Transaction-based storage system and method that uses variable sized objects to store data |
US20050289508A1 (en) * | 2004-06-08 | 2005-12-29 | Daniel Illowsky | Method and system for customized programmatic dynamic creation of interoperability content |
US20060062363A1 (en) * | 2004-09-19 | 2006-03-23 | Sirenada, Inc. | Method and apparatus for interacting with broadcast programming |
US20060095586A1 (en) * | 2004-10-29 | 2006-05-04 | The Go Daddy Group, Inc. | Tracking domain name related reputation |
US7099878B2 (en) * | 2002-04-08 | 2006-08-29 | First Data Corporation | System and method for managing account addresses |
US20060200487A1 (en) * | 2004-10-29 | 2006-09-07 | The Go Daddy Group, Inc. | Domain name related reputation and secure certificates |
US20060212386A1 (en) * | 2005-03-15 | 2006-09-21 | Willey Dawn M | Credit scoring method and system |
US20070008884A1 (en) * | 2003-10-08 | 2007-01-11 | Bob Tang | Immediate ready implementation of virtually congestion free guarantedd service capable network |
US20070038524A1 (en) * | 2005-08-11 | 2007-02-15 | Sitoa Corporation | Inventory-less transaction fulfillment |
US20070168675A1 (en) * | 2006-01-18 | 2007-07-19 | Per Wahlberg | Systems and methods for tracking mobile terrestrial terminals for satellite communications |
US7254549B1 (en) * | 2001-07-23 | 2007-08-07 | At&T Corp. | Real-time addresses for direct mail using online directories |
US20070244627A1 (en) * | 2006-04-18 | 2007-10-18 | Boss Gregory J | Intelligent Redirection of Vehicular Traffic Due to Congestion and Real-Time Performance Metrics |
US7305404B2 (en) * | 2003-10-21 | 2007-12-04 | United Parcel Service Of America, Inc. | Data structure and management system for a superset of relational databases |
US20080052414A1 (en) * | 2006-08-28 | 2008-02-28 | Ortiva Wireless, Inc. | Network adaptation of digital content |
US20080109845A1 (en) * | 2006-11-08 | 2008-05-08 | Ma Capital Lllp | System and method for generating advertisements for use in broadcast media |
US20080228040A1 (en) * | 2007-03-16 | 2008-09-18 | Arthur Solomon Thompson | International medical expert diagnosis |
US20080285886A1 (en) * | 2005-03-29 | 2008-11-20 | Matthew Emmerson Allen | System For Displaying Images |
US7512612B1 (en) * | 2002-08-08 | 2009-03-31 | Spoke Software | Selecting an optimal path through a relationship graph |
US20090132395A1 (en) * | 2007-11-15 | 2009-05-21 | Microsoft Corporation | User profiling in a transaction and advertising electronic commerce platform |
US20090232112A1 (en) * | 2008-03-11 | 2009-09-17 | Solomon Trainin | System and methods for polling for dynamic slot reservation |
US20090307206A1 (en) * | 2008-06-05 | 2009-12-10 | Is Technologies, Llc | Self verifying address update process and system |
US20100070448A1 (en) * | 2002-06-24 | 2010-03-18 | Nosa Omoigui | System and method for knowledge retrieval, management, delivery and presentation |
US8589286B1 (en) * | 2003-05-30 | 2013-11-19 | Experian Information Solutions, Inc. | Credit score simulation |
Family Cites Families (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0214718A3 (en) | 1985-07-22 | 1990-04-04 | Alliant Computer Systems Corporation | Digital computer |
US5991758A (en) | 1997-06-06 | 1999-11-23 | Madison Information Technologies, Inc. | System and method for indexing information about entities from different information sources |
EP1208412A2 (en) | 1999-02-26 | 2002-05-29 | Reveo, Inc. | Globally time-synchronized systems, devices and methods |
WO2001080238A1 (en) | 2000-04-05 | 2001-10-25 | Infineon Technologies North America Corp. | Improved read/write channel |
WO2003038562A2 (en) | 2001-10-31 | 2003-05-08 | Csg Systems, Inc. | System and method for provisioning network services |
US7792683B2 (en) * | 2002-11-07 | 2010-09-07 | Siemens Industry, Inc. | Method and system for address information distribution |
AU2003212837A1 (en) | 2003-01-27 | 2004-08-30 | Russell P. Davis | Integrated system of shellfish production and utilization |
AU2004320526B2 (en) | 2004-05-27 | 2008-08-07 | Memjet Technology Limited | Method for at least partially compensating for errors in ink dot placement due to erroneous rotational displacement |
CN101495953B (en) * | 2005-01-28 | 2012-07-11 | 美国联合包裹服务公司 | System and method of registration and maintenance of address data for each service point in a territory |
EP2248087A4 (en) | 2007-12-21 | 2012-02-15 | Glyde Corp | Web system for providing an ecommerce storefront |
-
2010
- 2010-03-10 US US12/721,280 patent/US8782025B2/en active Active
- 2010-03-10 EP EP10751351A patent/EP2406737A1/en not_active Withdrawn
- 2010-03-10 CA CA2754953A patent/CA2754953A1/en not_active Abandoned
- 2010-03-10 WO PCT/US2010/026818 patent/WO2010104946A1/en active Application Filing
- 2010-03-10 AU AU2010224157A patent/AU2010224157A1/en not_active Abandoned
- 2010-03-10 JP JP2011554148A patent/JP2012520515A/en active Pending
Patent Citations (52)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US3351920A (en) * | 1964-01-02 | 1967-11-07 | Xerox Corp | Thermoplastic computer memory storage system |
US3610159A (en) * | 1968-06-06 | 1971-10-05 | Bendix Corp | Automatic baggage-handling system |
US3623006A (en) * | 1970-06-29 | 1971-11-23 | Burroughs Corp | Queueing device for the selection of requests for access to a storage medium |
US3881097A (en) * | 1973-05-14 | 1975-04-29 | Weston Instruments Inc | Fully digital spectrum analyzer using time compression and discrete fourier transform techniques |
US5041921A (en) * | 1987-01-06 | 1991-08-20 | Duplitronics, Inc. | System for recording custom albums from a library of pre-recorded items |
US5913013A (en) * | 1993-01-11 | 1999-06-15 | Abecassis; Max | Seamless transmission of non-sequential video segments |
US5598276A (en) * | 1993-10-29 | 1997-01-28 | Time Warner Entertainment Co., L.P. | System and method for controlling play of multiple versions of the same motion picture stored on an optical disk |
US6026304A (en) * | 1997-01-08 | 2000-02-15 | U.S. Wireless Corporation | Radio transmitter location finding for wireless communication network services and management |
US6016038A (en) * | 1997-08-26 | 2000-01-18 | Color Kinetics, Inc. | Multicolored LED lighting method and apparatus |
US20020082892A1 (en) * | 1998-08-27 | 2002-06-27 | Keith Raffel | Method and apparatus for network-based sales force management |
US20020165739A1 (en) * | 1999-05-04 | 2002-11-07 | George V. Guyan | Method and article of manufacturing for component based information linking during claim processing |
US20020032612A1 (en) * | 2000-03-28 | 2002-03-14 | Williams Daniel F. | Apparatus, systems and methods for online, multi-parcel, multi-carrier, multi-service parcel returns shipping management |
US20020097651A1 (en) * | 2001-01-25 | 2002-07-25 | Watt Charles R. | System and method for performing a spin motor startup operation |
US20020136206A1 (en) * | 2001-03-20 | 2002-09-26 | Worldcom, Inc. | Recursive query for communications network data |
US20040134982A1 (en) * | 2001-06-27 | 2004-07-15 | Frederic Jouvin | Shipment tracking method, device for the implementation of the method and printing device |
US20030009570A1 (en) * | 2001-07-03 | 2003-01-09 | International Business Machines Corporation | Method and apparatus for segmented peer-to-peer computing |
US7254549B1 (en) * | 2001-07-23 | 2007-08-07 | At&T Corp. | Real-time addresses for direct mail using online directories |
US20030033308A1 (en) * | 2001-08-03 | 2003-02-13 | Patel Sujal M. | System and methods for providing a distributed file system utilizing metadata to track information about data stored throughout the system |
US20030112809A1 (en) * | 2001-08-24 | 2003-06-19 | Bharali Anupam A. | Efficient method and system for automatic discovery and verification of optimal paths through a dynamic multi-point meshed overlay network |
US20050021523A1 (en) * | 2002-01-08 | 2005-01-27 | Wafik Farag | Holistic dynamic information management platform for end-users to interact with and share all information categories, including data, functions, and results, in a collaborative secure venue |
US20030172053A1 (en) * | 2002-02-01 | 2003-09-11 | John Fairweather | System and method for mining data |
US7099878B2 (en) * | 2002-04-08 | 2006-08-29 | First Data Corporation | System and method for managing account addresses |
US20030196094A1 (en) * | 2002-04-10 | 2003-10-16 | Hillis W. Daniel | Method and apparatus for authenticating the content of a distributed database |
US20050234913A1 (en) * | 2002-05-28 | 2005-10-20 | Providian Financial Corporation | Method and system for creating and maintaining an index for tracking files relating to people |
US7676459B2 (en) * | 2002-05-28 | 2010-03-09 | Jpmorgan Chase Bank, N.A. | Method and system for creating and maintaining an index for tracking files relating to people |
US20100070448A1 (en) * | 2002-06-24 | 2010-03-18 | Nosa Omoigui | System and method for knowledge retrieval, management, delivery and presentation |
US20050149741A1 (en) * | 2002-07-13 | 2005-07-07 | Humbel Roger M. | Autorisations, regulation, characterisation, localisation, locking and theft security system (here also referred to as lock-loop dss) |
US7512612B1 (en) * | 2002-08-08 | 2009-03-31 | Spoke Software | Selecting an optimal path through a relationship graph |
US20040059705A1 (en) * | 2002-09-25 | 2004-03-25 | Wittke Edward R. | System for timely delivery of personalized aggregations of, including currently-generated, knowledge |
US20040143710A1 (en) * | 2002-12-02 | 2004-07-22 | Walmsley Simon Robert | Cache updating method and apparatus |
US20040181425A1 (en) * | 2003-03-14 | 2004-09-16 | Sven Schwerin-Wenzel | Change Management |
US8589286B1 (en) * | 2003-05-30 | 2013-11-19 | Experian Information Solutions, Inc. | Credit score simulation |
US20070008884A1 (en) * | 2003-10-08 | 2007-01-11 | Bob Tang | Immediate ready implementation of virtually congestion free guarantedd service capable network |
US7305404B2 (en) * | 2003-10-21 | 2007-12-04 | United Parcel Service Of America, Inc. | Data structure and management system for a superset of relational databases |
US20050180753A1 (en) * | 2004-02-12 | 2005-08-18 | Adaptive Optics Associates, Inc. | Free space optical (FSO) laser communication system employing fade mitigation measures based on laser beam speckle tracking and locking principles |
US20050188071A1 (en) * | 2004-02-19 | 2005-08-25 | International Business Machines Corporation | Architecture for a centralized management system |
US20050257083A1 (en) * | 2004-05-13 | 2005-11-17 | Cousins Robert E | Transaction-based storage system and method that uses variable sized objects to store data |
US20050289508A1 (en) * | 2004-06-08 | 2005-12-29 | Daniel Illowsky | Method and system for customized programmatic dynamic creation of interoperability content |
US20060062363A1 (en) * | 2004-09-19 | 2006-03-23 | Sirenada, Inc. | Method and apparatus for interacting with broadcast programming |
US20060095586A1 (en) * | 2004-10-29 | 2006-05-04 | The Go Daddy Group, Inc. | Tracking domain name related reputation |
US20060200487A1 (en) * | 2004-10-29 | 2006-09-07 | The Go Daddy Group, Inc. | Domain name related reputation and secure certificates |
US20060212386A1 (en) * | 2005-03-15 | 2006-09-21 | Willey Dawn M | Credit scoring method and system |
US20080285886A1 (en) * | 2005-03-29 | 2008-11-20 | Matthew Emmerson Allen | System For Displaying Images |
US20070038524A1 (en) * | 2005-08-11 | 2007-02-15 | Sitoa Corporation | Inventory-less transaction fulfillment |
US20070168675A1 (en) * | 2006-01-18 | 2007-07-19 | Per Wahlberg | Systems and methods for tracking mobile terrestrial terminals for satellite communications |
US20070244627A1 (en) * | 2006-04-18 | 2007-10-18 | Boss Gregory J | Intelligent Redirection of Vehicular Traffic Due to Congestion and Real-Time Performance Metrics |
US20080052414A1 (en) * | 2006-08-28 | 2008-02-28 | Ortiva Wireless, Inc. | Network adaptation of digital content |
US20080109845A1 (en) * | 2006-11-08 | 2008-05-08 | Ma Capital Lllp | System and method for generating advertisements for use in broadcast media |
US20080228040A1 (en) * | 2007-03-16 | 2008-09-18 | Arthur Solomon Thompson | International medical expert diagnosis |
US20090132395A1 (en) * | 2007-11-15 | 2009-05-21 | Microsoft Corporation | User profiling in a transaction and advertising electronic commerce platform |
US20090232112A1 (en) * | 2008-03-11 | 2009-09-17 | Solomon Trainin | System and methods for polling for dynamic slot reservation |
US20090307206A1 (en) * | 2008-06-05 | 2009-12-10 | Is Technologies, Llc | Self verifying address update process and system |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140149871A1 (en) * | 2012-11-26 | 2014-05-29 | Verizon Patent And Licensing Inc. | Service address validation tool for a service provider network |
WO2015183395A1 (en) * | 2014-05-29 | 2015-12-03 | Lexisnexis Risk Solutions Inc. | Systems and methods for determining occupancy |
Also Published As
Publication number | Publication date |
---|---|
CA2754953A1 (en) | 2010-09-16 |
US8782025B2 (en) | 2014-07-15 |
WO2010104946A1 (en) | 2010-09-16 |
JP2012520515A (en) | 2012-09-06 |
EP2406737A1 (en) | 2012-01-18 |
AU2010224157A1 (en) | 2011-10-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
DesRoches et al. | The results are only as good as the sample: assessing three national physician sampling frames | |
US20030191669A1 (en) | System for providing consumer access to healthcare related information | |
US20030233252A1 (en) | System and method for providing a generic health care data repository | |
JP2004145853A (en) | System for monitoring healthcare client related information | |
Abrams et al. | Mortality and revascularization following admission for acute myocardial infarction: implication for rural veterans | |
US8108225B2 (en) | Method, system, and software for analysis of a billing process | |
Iachan et al. | Design and weighting methods for a nationally representative sample of HIV-infected adults receiving medical care in the United States-Medical Monitoring Project | |
US10430478B1 (en) | Automatic finding of online profiles of an entity location | |
US20210334407A1 (en) | Personally identifiable information storage detection by searching a metadata source | |
US10366351B2 (en) | Information standardization and verification | |
Boggs et al. | An inventory of stroke centers in the United States | |
US8782025B2 (en) | Systems and methods for address intelligence | |
US20210043319A1 (en) | Healthcare data cloud system, server and method | |
Dygaszewicz | Transition from traditional census to combined and registers based census | |
US20120191471A1 (en) | Method, system, and software for analysis of a billing process | |
Grannis et al. | Evaluation of real-world referential and probabilistic patient matching to advance patient identification strategy | |
Tenner et al. | Secret shopper analysis shows getting psychiatry appointment in New York City is well kept secret | |
Hamm et al. | Population coverage of the Canadian Chronic Disease Surveillance System: a survey of the contents of health insurance registries across Canada | |
Mulry et al. | Comparison of 2010 census nonresponse follow-up proxy responses with administrative records using census coverage measurement results | |
US20230394233A1 (en) | System, server and method for training artificial intelligence using vectorized data | |
Shah et al. | Record linkage in healthcare: Applications, opportunities, and challenges for public health | |
Iron et al. | Health services data, sources and examples: the Institute for clinical evaluative sciences data repository | |
US20230161750A1 (en) | System and method for improving data validation and synchronization across disparate parties | |
EP1497765A2 (en) | A system for providing consumer access to healthcare related information | |
US20230267548A1 (en) | Systems and methods for complying with lists of excluded individuals and entities |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: IMS SOFTWARE SERVICES LTD., DELAWARE Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:SWENSON, KAREN;REEL/FRAME:024060/0637 Effective date: 20100309 |
|
AS | Assignment |
Owner name: BANK OF AMERICA, N.A., AS COLLATERAL AGENT, NEW YO Free format text: SECURITY AGREEMENT;ASSIGNOR:IMS SOFTWARE SERVICES LTD.;REEL/FRAME:031592/0331 Effective date: 20131030 |
|
AS | Assignment |
Owner name: IMS HEALTH INCORPORATED, CONNECTICUT Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:IMS SOFTWARE SERVICES, LTD.;REEL/FRAME:033123/0671 Effective date: 20140610 |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
AS | Assignment |
Owner name: QUINTILES IMS INCORPORATED, CONNECTICUT Free format text: MERGER AND CHANGE OF NAME;ASSIGNORS:IMS HEALTH INCORPORATED;QUINTILES TRANSNATIONAL CORP.;REEL/FRAME:041260/0474 Effective date: 20161003 |
|
AS | Assignment |
Owner name: QUINTILES IMS INCORPORATED, CONNECTICUT Free format text: MERGER AND CHANGE OF NAME;ASSIGNORS:IMS HEALTH INCORPORATED;QUINTILES TRANSNATIONAL CORP.;REEL/FRAME:041791/0233 Effective date: 20161003 |
|
AS | Assignment |
Owner name: QUINTILES IMS INCORPORATED, CONNECTICUT Free format text: MERGER AND CHANGE OF NAME;ASSIGNORS:IMS HEALTH INCORPORATED;QUINTILES TRANSNATIONAL CORP.;REEL/FRAME:045102/0549 Effective date: 20161003 |
|
FEPP | Fee payment procedure |
Free format text: MAINTENANCE FEE REMINDER MAILED (ORIGINAL EVENT CODE: REM.) |
|
FEPP | Fee payment procedure |
Free format text: SURCHARGE FOR LATE PAYMENT, LARGE ENTITY (ORIGINAL EVENT CODE: M1554) |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 4TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1551) Year of fee payment: 4 |
|
AS | Assignment |
Owner name: IQVIA INC., NEW JERSEY Free format text: CHANGE OF NAME;ASSIGNOR:QUINTILES IMS INCORPORATED;REEL/FRAME:047207/0276 Effective date: 20171106 |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 8TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1552); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY Year of fee payment: 8 |
|
AS | Assignment |
Owner name: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, MINNESOTA Free format text: SECURITY INTEREST;ASSIGNORS:IQVIA INC.;IQVIA RDS INC.;IMS SOFTWARE SERVICES LTD.;AND OTHERS;REEL/FRAME:063745/0279 Effective date: 20230523 |
|
AS | Assignment |
Owner name: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, MINNESOTA Free format text: SECURITY INTEREST;ASSIGNOR:IQVIA INC.;REEL/FRAME:065709/0618 Effective date: 20231128 Owner name: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, MINNESOTA Free format text: SECURITY INTEREST;ASSIGNORS:IQVIA INC.;IQVIA RDS INC.;IMS SOFTWARE SERVICES LTD.;AND OTHERS;REEL/FRAME:065710/0253 Effective date: 20231128 |
|
AS | Assignment |
Owner name: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, MINNESOTA Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE CONVEYING PARTIES INADVERTENTLY NOT INCLUDED IN FILING PREVIOUSLY RECORDED AT REEL: 065709 FRAME: 618. ASSIGNOR(S) HEREBY CONFIRMS THE SECURITY AGREEMENT;ASSIGNORS:IQVIA INC.;IQVIA RDS INC.;IMS SOFTWARE SERVICES LTD.;AND OTHERS;REEL/FRAME:065790/0781 Effective date: 20231128 |