IBM InfoSphere Master Data Management, Version 11.3The mpi_memtype table is used to define member types.
| Attribute | Description |
|---|---|
| caudrecno | Current audit record |
| maudrecno | Modified audit record |
| recstat | Record status; options are: A – Active. The record is current and should be used in all matching-related activities. I – Inactive. The record is not current and should not be used in matching-related activities, but is retained for retrieval due to historical significance. D – Deleted. The record is marked for deletion, pending a purge of data, and should not be used in matching-related activities. S – Shadow. The record is current, and should be used in all matching-related activities. The record is somewhat in limbo, pending verification due to workflow-related activities in the task-oriented tables. |
| memtypeno | Numeric value for member type |
| memtype | String value for member type |
| memtypelabel | Expanded string value for member type |
| memtypecat | Member type category |
| memtypedesc | Member type description |
| optputmode | Optimized put mode |
| dvdcode | Data derivation code |
| hashistory | Y/N field indicates whether history is enabled for this member type |
CREATE TABLE mpi_memtype
(
caudrecno bigint NOT NULL,
maudrecno bigint NOT NULL,
recstat nchar(1) NOT NULL,
memtypeno smallint NOT NULL,
memtype nvarchar(32) NOT NULL,
memtypelabel nvarchar(32) NOT NULL,
memtypecat nvarchar(32) NOT NULL,
memtypedesc nvarchar(255) NULL,
optputmode nchar(1) NULL,
dvdcode nvarchar(12) NULL,
hashistory nchar(1) NOT NULL
)
CREATE UNIQUE INDEX mpi_memtype0 ON mpi_memtype (memtypeno)
CREATE UNIQUE INDEX mpi_memtype1 ON mpi_memtype (memtype)