mpi_strword

The mpi_strword table is used to standardize words.

Expanded name
Word String Values
Table category
Algorithm configuration
Purpose
Used to standardize words, such as address tokens (for example, APT/apartment) and name tokens (Mr., Dr., Jr.).
Cross-reference
This table is a child table of mpi_strhead.
Table 1. mpi_strword 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)
strcode Defined code from mpi_strhead. Identifies the token type (for example, address token).
strval Input string value (for example, BOULEVARD).
strstd Standardized value of the string (for example, BLVD).
wordtype Type of word or token. Values include:

ANT = alphanumeric (for example, 2nd, 3rd, 4th)

NUM = all digits

NMX = leading/trailing digit

BN = block number type (for example, 1...10)

DT = direction type (for example, N, S, E, W)

ST = street type (for example, TRAIL, STREET, CIRCLE)

MT = P.O. box type (for example, POBOX, POB)

UT = unit number type (for example, SUITE, APT, FLOOR)

SP = special

BT = business type

BLT = business legal type (for example, ASSOCIATES, INC, GROUP)

PCT = person credential type (for example, DDS, MD, DMD, MBA)

PST = person suffix type (for example, II, JR, SR)

PPT = person prefix type (for example, DR, MRS, MR)

mpi_strword SQL:

CREATE TABLE mpi_strword
(
caudrecno   bigint		NOT NULL,
maudrecno   bigint		NOT NULL,
recstat     nchar(1)		NOT NULL,
strcode     nvarchar(40)	NOT NULL,
strval      nvarchar(63)	NOT NULL,
strstd      nvarchar(63)	NOT NULL,
wordtype    nvarchar(4)		NOT NULL
)
CREATE UNIQUE INDEX mpi_strword1 ON mpi_strword (strcode, strval)