PERSON
The PERSON table is a subtype of CONTACT and represents a human being as a legal entity.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| CONT_ID | A unique, system-generated key that identifies a party in the system. | BIGINT | Not Null | Yes |
| MARITAL_ST_TP_CD | The marital status of a person. For example, single, widowed, divorced, and so forth. | BIGINT | Null | No |
| BIRTHPLACE_TP_CD | A Country Type Code identifying the country of birth. | BIGINT | Null | No |
| CITIZENSHIP_TP_CD | The country where an individual is a citizen. | BIGINT | Null | No |
| HIGHEST_EDU_TP_CD | The level of schooling that this person has received. For examples, high school, college, university, and so forth. | BIGINT | Null | No |
| AGE_VER_DOC_TP_CD | An identifier that uniquely separates one type of document being used to verify a client's age from another. For example, birth certificate, or driver's license. | BIGINT | Null | No |
| GENDER_TP_CODE | Identifies the sex of a person. | CHAR(1) | Null | No |
| BIRTH_DT | The date of birth of the person. | TIMESTAMP | Null | No |
| DECEASED_DT | The date of death of the person. | TIMESTAMP | Null | No |
| CHILDREN_CT | The total number of children that a person has. | SMALLINT | Null | No |
| DISAB_START_DT | The date the person became disabled. | TIMESTAMP | Null | No |
| DISAB_END_DT | The date the person ceased being disabled. | TIMESTAMP | Null | No |
| USER_IND | Indicates whether this a person is a user of the system. | CHAR(1) | 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 |