PERSONSEARCH

The PERSONSEARCH table contains the standardized or non-standardized versions of the PERSON NAME table to facilitate searching.

This table is used by the following domain.
Name Comment Datatype Null Option Is PK
PERSON_SEARCH_ID A unique, system-generated key that identifies a person search record in the system. BIGINT Not Null Yes
PERSON_NAME_ID A unique, system-generated key that identifies a person name record in the system. BIGINT Not Null No
CONT_ID A unique, system-generated key that identifies a party in the system. BIGINT Not Null No
GIVEN_NAME_ONE The first given name (commonly known as a first name) of the person. If standardization of the name has taken place, the standardized version of the name will be stored here. VARCHAR(25) Null No
GIVEN_NAME_TWO The second given name (commonly known as a middle name) of the person. If standardization of the name has taken place, the standardized version of the name will be stored here. VARCHAR(25) Null No
GIVEN_NAME_THREE The third given name (commonly known as a middle name) of the person. If standardization of the name has taken place, the standardized version of the name will be stored here. VARCHAR(25) Null No
GIVEN_NAME_FOUR The fourth given name (commonly known as a middle name) of the person. If standardization of the name has taken place, the standardized version of the name will be stored here. VARCHAR(25) Null No
LAST_NAME The last name of a person. If standardization of the name has taken place, the standardized version of the name will be stored here. VARCHAR(30) Not Null No
END_DT The date when this record becomes inactive. TIMESTAMP Null No
LAST_UPDATE_DT When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. TIMESTAMP Not Null No
LAST_UPDATE_USER The ID of the user who last updated the data. VARCHAR(20) Null No
LAST_UPDATE_TX_ID A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. BIGINT Null No
STANDARD_IND Indicates whether the PERSONSEARCH record contains standardized content. CHAR(1) Null No