mpi_srcxent
The mpi_srcxent table is used to provide source-to-entity mapping.
- Expanded name
- Source-to-Entity Cross-Reference
- Table category
- Algorithm configuration
- Purpose
- Defines srcrecno and enttypeno mapping for enhanced entity management.
- Cross-reference
- The table cross-references mpi_enttype through enttypeno and mpi_srchead through srcrecno.
| Attribute | Description |
|---|---|
| caudrecno | Creation of this particular record, from mpi_audhead |
| maudrecno | Last time the record value was modified, from mpi_audhead |
| recstat | Record status; A(ctive) or I(nactive) |
| enttypeno | Entity type, from mpi_enttype |
| srcrecno | Source record number |
| srcprior | Source priority. This field is used by the best-match linking process to determine the confidence level in accuracy of source data used in linkage creation. The higher the numeric value, the higher the confidence level. For example, you have Source A with a value of 1, Source B at 2 and Source C at 3. In this instance, during the linkage process, records from Source C are linked to first. The common approach for most implementations is to use the default value of 1. If 0 is used, members from the source are not linked. |
| istrusted | Flag indicating that this is a trusted source |
mpi_srcxent SQL:
CREATE TABLE mpi_srcxent
(
caudrecno bigint NOT NULL,
maudrecno bigint NOT NULL,
recstat nchar(1) NOT NULL,
enttypeno smallint NOT NULL,
srcrecno int NOT NULL,
srcprior int NOT NULL
istrusted nchar(1) NOT NULL
)
CREATE UNIQUE INDEX mpi_srcxent1 on mpi_srcxent (enttypeno, srcrecno)