Introduction

The carrier dimension is intended for those fact tables and star schemas that need to capture performance measurements related to in- and out-bound shipments from and to facilities.

Description

The carrier dimension is derived from:

  1. PartyRoleNameDetail entity

The discriminating factor is the roletypeId (value = "CARRIER")

and consists of following elements (fields):

namealiastypedescription
dimensionId
id-longthe unique identifier of the record
partyId
idthe natural (primary) key from table 1 (see above): partyId
partyName
description

The name of the party. Value is dependent on the partyTypeId of the PartyRoleNameDetail entity:

  1. if partyRoleTypeId = PARTY_GROUP: groupName
  2. if partyRoleTypeId = PERSON: lastName, firstName


Related tickets