Rolled Up Size Profile Results

In Scope

Technical: ALC_SESSION_SIZE_PROFILE_RATIO | ID: OR-ALLOC-ALC_SESSION_SIZE_PROFILE_RATIO-ACTUAL_LANDED_COST_SESSION_SIZE_PROFILE_RATIO

This temporary table holds the rolled up size profile results.

See how this object fits into Allocations

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: ALC_SESSION_SIZE_PROFILE_RATIO

Field Definitions(5)

Rules & Considerations(18)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_IDRPK	SESSION_IDRPK	RESULT_TYPERPK	SIZE_PROFILERPK	RATIO	AGGREGATEDDIFF	SIZE_PROFILE_LEVEL
Example values from field definitions	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	100003	ALT-ALC_SESSIO-002	3	Alc Session Size Profile Ratio-002-ALT	Alc Session Size	Alc Session Size Profile Ratio-002-ALT	Alc Session Size Profile Ratio-002-ALT
default	100005	EDGE-ALC_SESSIO-003	5	Alc Session Size Profile Ratio-003-EDGE	Alc Session Size	Alc Session Size Profile Ratio-003-EDGE	Alc Session Size Profile Ratio-003-EDGE

Example values from field definitions

SEQ_IDRPK: 1
SESSION_IDRPK: SAMPLE
RESULT_TYPERPK: 1
SIZE_PROFILERPK: SAMPLE
RATIO: SAMPLE
AGGREGATEDDIFF: SAMPLE
SIZE_PROFILE_LEVEL: SAMPLE

default

SEQ_IDRPK: 100003
SESSION_IDRPK: ALT-ALC_SESSIO-002
RESULT_TYPERPK: 3
SIZE_PROFILERPK: Alc Session Size Profile Ratio-002-ALT
RATIO: Alc Session Size
AGGREGATEDDIFF: Alc Session Size Profile Ratio-002-ALT
SIZE_PROFILE_LEVEL: Alc Session Size Profile Ratio-002-ALT

default

SEQ_IDRPK: 100005
SESSION_IDRPK: EDGE-ALC_SESSIO-003
RESULT_TYPERPK: 5
SIZE_PROFILERPK: Alc Session Size Profile Ratio-003-EDGE
RATIO: Alc Session Size
AGGREGATEDDIFF: Alc Session Size Profile Ratio-003-EDGE
SIZE_PROFILE_LEVEL: Alc Session Size Profile Ratio-003-EDGE

Rule Validation Summary

Source Rule Count: 34
Governed Rule Count: 18