Location

Location Data Model

The following data model illustrates the location object.

Location Data Model

Location 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

Location

CI_PREM

Yes CI_PREM_K

VAL-PREM

CIPVPRMK

Has dependencies

CIPVPRMI

Characteristic

CI_PREM_CHAR

No. The key is PREM_ID plus an edate and a char type.

CIPVPCHV

CIPVPCHI

Geo Loc

CI_PREM_GEO

No. The key is PREM_ID plus geo loc type.

CIPVPGOV

CIPVPGOI

Alternate Address

CI_PRM_ALT_ADDR

Yes CI_PRM_ALT_ADDR_K

CIPVAPAV

CIPVAPAK

Has dependencies

CIPVAPAI

Location Suggestions

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.