Plasma Data Objects

Structure And Calculations

detailed data objects structure and calculations: Plasma Data Objects Structure [Sharepoint]
KPIs provided by Bain (for Plasma_KPI DM): Plasma_KPIs [Sharepoint]
exchange Data Loads: Plasma Exchange Data Loads [Sharepoint]
- overrides the original items sourced from a DS
validation rules: Plasma_Validations [Sharepoint]

Customer Partition

Transactions:

Plasma_TX (DS)
Plasma_Transactions (DM)
Plasma_Output_Transactions (DM)

Quotes:

Plasma_Quotes (DS)
Plasma_Quotes (DM)
Plasma_Output_Quotes (DM)

both:

Plasma_KPI (DM)
- data provided by Bain

Harvester Partition

Transactions:

Plasma_Transactions_Harvester (DS)
Plasma_Transactions_Harvester (DM)
- consists of fields from Plasma_Transactions_Harvester (DS), Plasma_Entities (DS) and Plasma_Taxonomy (DS)

Quotes:

Plasma_Quotes_Harvester (DS)
Plasma_Quotes_Harvester (DM)
- consists of fields from Plasma_Quotes_Harvester (DS), Plasma_Entities (DS) and Plasma_Taxonomy (DS)

both:

Plasma_Entities (DS)
Plasma_Taxonomy (DS)
Plasma_Currencies (DS)

Data Loads Engagement

DL Label	DL Type	Formula	Feeder (if any)	Config tables	Source	Target
Plasma_Transactions	Calculation	Plasma_Data_Extractor	Plasma_Data_Extractor_Feeder	Plasma_Config, Plasma_Operator_Mapping, Plasma_Transactions_Extractor_Mapping, Plasma_Transactions_Extractor_Fields, Plasma_Audit	Customer transaction data	DMDS.Plasma_TX
Plasma_Transactions_PreviousPrice	Calculation	Plasma_Transactions_PreviousPrice			DMDS.Plasma_TX	DMDS.Plasma_TX
Plasma_Transactions_Exchange	Calculation	Plasma_Transactions_Exchange			DMDS.Plasma_TX, DMDS.ccy, DMDS.Plasma_Currencies	DM.Plasma_Transactions
Plasma_Output_Creation	Calculation	Plasma_Transactions_Creation		Plasma_Config	DM.Plasma_Transactions	DM.Plasma_Output_Transactions
Plasma_Output_Enrichment	Calculation	Plasma_Transactions_Enrichment			DM.Plasma_Output_Transactions, DM.Plasma_Transactions	DM.Plasma_Output_Transactions
Plasma Quotes Extractor	Calculation	Plasma_Quotes_Extractor	Plasma_Quotes_Extractor_Feeder	Plasma_Quotes_Extractor_Mapping	Customer quote data	DMDS.Plasma_Quotes
Plasma Quotes Enrichment	Calculation	Plasma_Data_Extractor	Plasma_Data_Extractor_Feeder	Plasma_Config, Plasma_Operator_Mapping, Plasma_Quotes_Enrichment_Mapping, Plasma_Quotes_Enrichment_Fields, Plasma_Audit	DMDS.Plasma_Quotes, Customer data	DMDS.Plasma_Quotes
Plasma Quotes Exchange	Calculation	Plasma_Quotes_Exchange			DMDS.Plasma_Quotes, DMDS.ccy, DMDS.Plasma_Currencies	DM.Plasma_Quotes
Plasma Output Quotes Load	Calculation	Plasma_Quotes		Plasma_Config	DM.Plasma_Quotes	DM.Plasma_Output_Quotes

Calculation Conditions

Plasma_Output_Transactions DM

(sourced by Plasma_Transactions_Creation DL)

Total_Sales_HC_Annual, Total_Sales_HC_TTM_Region, Total_Accounts_TTM, Total_Accounts_TTM_Region, Total_Products_TTM, Total_Products_TTM_Region:
- to have the value of these elements in Plasma_Output_Transactions DM, there must be data for last 12 months, otherwise, it will be null value. (E.g: UniqueId: 2020-M06 --> must have data in 2019, if you only have data from 2020-M01 --> M06, we don't show value for these elements.)