mpi_memstat
The mpi_memstat table is used to define member statuses.
- Expanded name
- Member Status
- Table category
- Base configuration
- Purpose
- This table provides the definitions for member statuses.
- Cross-reference
- Not applicable.
| 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. |
| memstatno | Numeric value for member status |
| memstat | String value for member status |
| memstatlabel | Expanded string value for member status |
| memstatcat | Member status category |
| isderived | Indicates whether the member has derived data for this status |
mpi_memstat SQL:
CREATE TABLE mpi_memstat
(
caudrecno bigint NOT NULL,
maudrecno bigint NOT NULL,
recstat nchar(1) NOT NULL,
memstatno smallint NOT NULL,
memstat nvarchar(32) NOT NULL,
memstatlabel nvarchar(32) NOT NULL,
memstatcat nvarchar(32) NOT NULL,
isderived nchar(1) NOT NULL
)
CREATE UNIQUE INDEX mpi_memstat0 ON mpi_memstat (memstatno)
CREATE UNIQUE INDEX mpi_memstat1 ON mpi_memstat(memstat)