The mpi_srcxent table is used to provide source-to-entity mapping.

Expanded name
Source-to-Entity Cross-Reference
Table category
Algorithm configuration
Defines srcrecno and enttypeno mapping for enhanced entity management.
The table cross-references mpi_enttype through enttypeno and mpi_srchead through srcrecno.
Table 1. mpi_srcxent Attribute Descriptions
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)