Person

This section describes the person object.

Person Data Model

The following data model illustrates the person object.

Person Data Model

Person Table Names

Data Model Name

Table Name

Generated Keys

Object Validation Batch Control

Referential Integrity Validation Batch Control

Key Assignment Batch Control

Insertion Batch Control

Person

CI_​PER

Yes CI_​PER_​K

VAL-PER

CIPVPERK

CIPVPERI

Name

CI_​PER_​NAME

No. The key is PER_​ID plus a sequence number.

CIPVPNMV

CIPVPNMI

Person / Person

CI_​PER_​PER

No. The key is PER_​ID1, PER_​ID2, relationship type and start date.

CIPVPPEV

CIPVPPEI

Phone

CI_​PER_​PHONE

No. The key is PER_​ID plus phone type.

CIPVPPHV

CIPVPPHI

Identifier

CI_​PER_​ID

No. The key is PER_​ID plus identifier type.

CIPVPIDV

CIPVPIDI

Characteristic

CI_​PER_​CHAR

No. The key is PER_​ID plus an edate and a char type.

CIPVPRCV

CIPVPRCI

Address

CI_​PER_​ADDR

No. The key is PER_​ID plus a sequence number.

CIPVPADV

CIPVPADI

Miscellaneous Address1

CI_​PER_​ADDR_​SEAS

No. The key is PER_​ID plus a sequence number.

CIPVPSAV

CIPVPSAI

Note: Note 1. Country, State and the Person Miscellaneous Addresses are only supported for legacy addresses. Refer to Address Support for more information.

Person Suggestions

A person must have at least one row on the name table and at least one of the names must be marked as being the primary name.

A person must have at least one row on the identity table and at least one of the identities must be marked as being the primary ID.

This maintenance object includes a character large object field that your organization may be using to capture implementation specific data as defined by your business objects. For records of this type, the process to insert the records to the staging table is responsible for populating the data in this CLOB as per the record's business object schema.