ReSA Realm

In Scope

Technical: SA_REALM | ID: OR-RSA-SA_REALM-RESA_REALM

The REALM table is used to keep track of metadata realms. Realms represent database objects (such as tables and PL/SQL blocks), ARI constructs (such as lookup and actions), and external...

See how this object fits into Sales Audit

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Information Type: Configuration
Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SA_REALM

Field Definitions(5)

Rules & Considerations(24)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NOR	REALM_IDRPK	INSTANCE_IDR	PHYSICAL_NAMER	REALM_TYPE_IDR	SCHEMA	DB_LINK	RDW_OWNER	ACTIVE_IND	RDW_PROJECT	DISPLAY_NAME	LAST_SCAN_DATE	LOGICAL_REALM_ID	MULTISELECT_AVAIL_IND
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	2026-01-01	SAMPLE	S
default	4	ALT-SA_REALM-00	ALT-SA	SA Realm Secondary	ALT-SA_R	SA Realm-002-ALT	SA Realm-002-ALT	SA Realm-002-ALT	S	SA Realm-002-ALT	SA Realm Secondary	2026-01-03	ALT-SA_REALM-00	S
default	6	EDGE-SA_REALM-0	EDGE-S	SA Realm Core	EDGE-SA_	SA Realm-003-EDGE	SA Realm-003-EDGE	SA Realm-003-EDGE	S	SA Realm-003-EDGE	SA Realm Core	2026-01-05	EDGE-SA_REALM-0	S

Example values from field definitions

SEQ_NOR: 1
REALM_IDRPK: SAMPLE
INSTANCE_IDR: SAMPLE
PHYSICAL_NAMER: SAMPLE
REALM_TYPE_IDR: SAMPLE
SCHEMA: SAMPLE
DB_LINK: SAMPLE
RDW_OWNER: SAMPLE
ACTIVE_IND: S
RDW_PROJECT: SAMPLE
DISPLAY_NAME: SAMPLE
LAST_SCAN_DATE: 2026-01-01
LOGICAL_REALM_ID: SAMPLE
MULTISELECT_AVAIL_IND: S

default

SEQ_NOR: 4
REALM_IDRPK: ALT-SA_REALM-00
INSTANCE_IDR: ALT-SA
PHYSICAL_NAMER: SA Realm Secondary
REALM_TYPE_IDR: ALT-SA_R
SCHEMA: SA Realm-002-ALT
DB_LINK: SA Realm-002-ALT
RDW_OWNER: SA Realm-002-ALT
ACTIVE_IND: S
RDW_PROJECT: SA Realm-002-ALT
DISPLAY_NAME: SA Realm Secondary
LAST_SCAN_DATE: 2026-01-03
LOGICAL_REALM_ID: ALT-SA_REALM-00
MULTISELECT_AVAIL_IND: S