Orghier Export Stg

In Scope

Technical: ORGHIER_EXPORT_STG | ID: OR-FND-ORGHIER_EXPORT_STG-ORGHIER_EXPORT_STG

This is table is a staging table for organizational hierarchy records as they wait to be extracted. This table is automatically inserted into, as records are processed by Oracle Retail.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ORGHIER_EXPORT_STG

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NORPK	WH	AREA	CHAIN	STORE	REGION	COMPANY	DISTRICT	PROCESS_ID	ACTION_TYPE	PARENT_LEVEL	BASE_EXTRACTED_IND	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	1	1	1	1	1	1	1	1	1	SAMPLE	SAMPLE	S	2026-01-01	S	S	S	S
default	4	9003	103	13	1003	203	3	303	1000000003	Orghier Export	Orghier Ex	O	2026-01-03	O	O	O	O
default	6	9005	105	15	1005	205	5	305	1000000005	Orghier Export	Orghier Ex	O	2026-01-05	O	O	O	O

Example values from field definitions

SEQ_NORPK: 1
WH: 1
AREA: 1
CHAIN: 1
STORE: 1
REGION: 1
COMPANY: 1
DISTRICT: 1
PROCESS_ID: 1
ACTION_TYPE: SAMPLE
PARENT_LEVEL: SAMPLE
BASE_EXTRACTED_IND: S
TRANSACTION_DATETIME: 2026-01-01
CUSTOM1_EXTRACTED_IND: S
CUSTOM2_EXTRACTED_IND: S
CUSTOM3_EXTRACTED_IND: S
CUSTOM4_EXTRACTED_IND: S

default

SEQ_NORPK: 4
WH: 9003
AREA: 103
CHAIN: 13
STORE: 1003
REGION: 203
COMPANY: 3
DISTRICT: 303
PROCESS_ID: 1000000003
ACTION_TYPE: Orghier Export
PARENT_LEVEL: Orghier Ex
BASE_EXTRACTED_IND: O
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: O
CUSTOM2_EXTRACTED_IND: O
CUSTOM3_EXTRACTED_IND: O
CUSTOM4_EXTRACTED_IND: O