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 |