Table SALES_AND_ADMINISTRATION_PERFORMANCE_FACT

DescriptionFact entity that records measures related to the performance of sales and administration related activities.
The measures are fully identified by the dimensions which are:
- Time (grain: Calendar date)
- Specification (grain: Product component)
- Channel role (grain: Channel role)
- Customer profile (grain: Customer profile)
- Task (grain: Task)
- Task performer (grain: Employee position)

Columns
COLLECTED_PREMIUMCOLLECTED_PREMIUM
COLLECTED_REVENUECOLLECTED_REVENUE
COLLECTION_COST_PER_REVENUECOLLECTION_COST_PER_REVENUE
CUSTOMER_SATISFACTION_WITH_SALES_FORCECUSTOMER_SATISFACTION_WITH_SALES_FORCE
GENERATED_REVENUEGENERATED_REVENUE
LEAD_GENERATION_TO_FIRST_CONTACT_CYCLE_TIMELEAD_GENERATION_TO_FIRST_CONTACT_CYCLE_TIME
MARGINAL_ACTIVITY_COST_PER_POLICYMARGINAL_ACTIVITY_COST_PER_POLICY
NUMBER_OF_NEW_CUSTOMERS_ACQUIREDNUMBER_OF_NEW_CUSTOMERS_ACQUIRED
NUMBER_OF_NEW_POLICIES_ACQUIREDNUMBER_OF_NEW_POLICIES_ACQUIRED
NUMBER_OF_RENEWALSNUMBER_OF_RENEWALS
NUMBER_OF_SALES_LEADS_GENERATEDNUMBER_OF_SALES_LEADS_GENERATED
NUMBER_OF_TARGETED_NEW_CUSTOMERSNUMBER_OF_TARGETED_NEW_CUSTOMERS
NUMBER_OF_TERMINATED_POLICIESNUMBER_OF_TERMINATED_POLICIES
REVENUE_GENERATED_PER_SALES_EXPENSEREVENUE_GENERATED_PER_SALES_EXPENSE
REVENUE_LOSSES_FROM_POLICY_TERMINATIONSREVENUE_LOSSES_FROM_POLICY_TERMINATIONS
REVENUE_RATIO_FOR_NEW_CUSTOMERSREVENUE_RATIO_FOR_NEW_CUSTOMERS
REVENUE_RATIO_FOR_NEW_PRODUCTSREVENUE_RATIO_FOR_NEW_PRODUCTS
SALES_FORECAST_ACCURACYSALES_FORECAST_ACCURACY
OVERDUE_PAYMENT_AMOUNTOVERDUE_PAYMENT_AMOUNT
PERCENTAGE_OF_CONVERSION_RATE_OF_LEADS_TO_ACCOUNTS_OPENEDPERCENTAGE_OF_CONVERSION_RATE_OF_LEADS_TO_ACCOUNTS_OPENED
NUMBER_OF_PRODUCTS_SOLD_PER_SALES_LEADNUMBER_OF_PRODUCTS_SOLD_PER_SALES_LEAD
SALES_INCENTIVES_AS_PERCENTAGE_OF_SGA_EXPENSESSALES_INCENTIVES_AS_PERCENTAGE_OF_SGA_EXPENSES
NUMBER_OF_PRODUCTS_SOLD_PER_CUSTOMERNUMBER_OF_PRODUCTS_SOLD_PER_CUSTOMER
CALENDAR_DATE_IDCALENDAR_DATE_ID
CHANNEL_ROLE_IDCHANNEL_ROLE_ID
FINANCIAL_SERVICES_PRODUCT_IDFINANCIAL_SERVICES_PRODUCT_ID
CHANNEL_ROLE_MINI_DIMENSION_IDCHANNEL_ROLE_MINI_DIMENSION_ID
FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_IDFINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID
POPULATION_TIMESTAMPPOPULATION_TIMESTAMP
GEOGRAPHIC_AREA_IDGEOGRAPHIC_AREA_ID
CROSS_SELL_RATECROSS_SELL_RATE
LINE_OF_BUSINESS_IDLINE_OF_BUSINESS_ID
REVENUE_GENERATED_PER_RENEWALSREVENUE_GENERATED_PER_RENEWALS
REVENUE_GENERATED_FOR_NEW_BUSINESSREVENUE_GENERATED_FOR_NEW_BUSINESS
REVENUE_GENERATED_FOR_CROSS_SELLREVENUE_GENERATED_FOR_CROSS_SELL
REVENUE_GENERATED_FO_CONVERSIONREVENUE_GENERATED_FO_CONVERSION
RETENTION_RATERETENTION_RATE
MARKET_SEGMENT_IDMARKET_SEGMENT_ID

Foreign Key
SALES_AND__CALE_FKSALES_AND__CALE_FK
SALES_AND__CHAN_FKSALES_AND__CHAN_FK
SALES_AND__FINA_FKSALES_AND__FINA_FK
SALES_AND__CHAN_F1SALES_AND__CHAN_F1
SALES_AND__FS_P_FKSALES_AND__FS_P_FK
SALES_AND__GEOG_FKSALES_AND__GEOG_FK
SALES_AND__PROD_FKSALES_AND__PROD_FK
SALES_AND__MARK_FKSALES_AND__MARK_FK

Primary Key
SALES_AND_ADMINISTRATION_PERFORMANCE_FACT_PKSALES_AND_ADMINISTRATION_PERFORMANCE_FACT_PK

Column Details

 COLLECTED_PREMIUM
DescriptionTotal amount of the collected premium.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COLLECTED_REVENUE
DescriptionTotal amount of the collected revenue.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COLLECTION_COST_PER_REVENUE
DescriptionThe proportion of the cost of billing and collection per collected revenue.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Task_Actual_cost / Payment_Amount ]
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_SATISFACTION_WITH_SALES_FORCE
DescriptionIndicator of the satisfaction of the customer with the sales process. This measure is not additive on the Time dimension.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GENERATED_REVENUE
DescriptionTotal amount of revenue generated through sales activities.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LEAD_GENERATION_TO_FIRST_CONTACT_CYCLE_TIME
DescriptionThe elapsed time between generation of a lead and making first contact with the prospect or customer.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARGINAL_ACTIVITY_COST_PER_POLICY
DescriptionThe marginal activity cost per product, per policy for that product.

Measure Calculation Formula:
[ Task_Actual_cost /]
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_NEW_CUSTOMERS_ACQUIRED
DescriptionThe number of customers who bought policies and who did not own active policies beforehand.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_NEW_POLICIES_ACQUIRED
DescriptionTotal number of new policies that were sold to customers.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_RENEWALS
DescriptionNumber of policies renewed during the specified period.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_SALES_LEADS_GENERATED
DescriptionTotal number of new and existing customers that are targeted by the sales activities.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_TARGETED_NEW_CUSTOMERS
DescriptionThe number of new customers in the campaign target list.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_TERMINATED_POLICIES
DescriptionTotal number of policies no longer in-force, due to termination at maturity or any other reason (cancellation), for specified period.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_GENERATED_PER_SALES_EXPENSE
DescriptionThe proportion of the revenue realised as a result of the sales process, versus, the total cost of the sales and distribution process.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount / Task_Actual_cost ]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_LOSSES_FROM_POLICY_TERMINATIONS
DescriptionThe revenue that was not realised due to the termination of policies.


Measure Calculation Formula:
[sum() for policy events that are termination events]
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_RATIO_FOR_NEW_CUSTOMERS
DescriptionPercentage of the revenue that is earned by the acquisition of new customers.
This measure is not additive on the Time dimension.

Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount /]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_RATIO_FOR_NEW_PRODUCTS
DescriptionPercentage of the revenue that is earned via sale of policies for new products.
This measure is not additive on the Time dimension.

Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount /]
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SALES_FORECAST_ACCURACY
DescriptionMeasures the accuracy of the sales forecast as a ratio between actual sales versus forecasted sales.
This measure is not additive on the Time dimension.

Measure Calculation Formula:
[(+)/ Campaign_Planned_agreement_sales ]
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OVERDUE_PAYMENT_AMOUNT
DescriptionAmount of the due payments that are unsettled and overdue.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERCENTAGE_OF_CONVERSION_RATE_OF_LEADS_TO_ACCOUNTS_OPENED
DescriptionProportion at which sales leads result in actual sales, to the total sales. Expresses the importance of sales lead identification in the total sales figures.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[((/(+ Activity___Agreement_Rlship_Agreement_id ))/(+))*100]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_PRODUCTS_SOLD_PER_SALES_LEAD
DescriptionThe number of products sold to new or existing customers that were identified as sales lead.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[( Customer_Status_date + Customer_Status_date )/(+)]
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SALES_INCENTIVES_AS_PERCENTAGE_OF_SGA_EXPENSES
DescriptionProportion of the total sales incentives against the Selling, General and Administrative expenses (SGA).

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_part_Amount /(( Money_provision_part_Amount + Money_provision_part_Amount - Money_provision_part_Amount )+ Particular_activity_Actual_cost + Particular_activity_Actual_cost + Particular_activity_Actual_cost )*100]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_PRODUCTS_SOLD_PER_CUSTOMER
DescriptionTotal number of products sold per customer.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[( Customer_Status_date + Customer_Status_date )/ Financial_services_role_Role_player_id ]
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_ID
DescriptionIdentifies the Calendar date dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_ROLE_ID
DescriptionIdentifies the Channel role dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FINANCIAL_SERVICES_PRODUCT_ID
DescriptionIdentifies the Financial services product dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_ROLE_MINI_DIMENSION_ID
DescriptionIdentifies the Channel role mini dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID
DescriptionIdentifies the Financial services product mini dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIMESTAMP
DescriptionA timestamp that identifies when this Fact Entity's instance was populated
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_ID
DescriptionThe unique identifier of the Geographic Area
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CROSS_SELL_RATE
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINESS_ID
DescriptionThe unique identifier of the Category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_GENERATED_PER_RENEWALS
DescriptionThe proportion of the revenue realised as a result of the sales process, versus, the total cost of the sales and distribution process.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount / Task_Actual_cost ]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_GENERATED_FOR_NEW_BUSINESS
DescriptionThe proportion of the revenue realised as a result of the sales process, versus, the total cost of the sales and distribution process.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount / Task_Actual_cost ]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_GENERATED_FOR_CROSS_SELL
DescriptionThe proportion of the revenue realised as a result of the sales process, versus, the total cost of the sales and distribution process.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount / Task_Actual_cost ]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVENUE_GENERATED_FO_CONVERSION
DescriptionThe proportion of the revenue realised as a result of the sales process, versus, the total cost of the sales and distribution process.

This measure is not additive on the Time dimension.
Measure Calculation Formula:
[ Money_provision_cash_flow_Base_amount / Task_Actual_cost ]
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RETENTION_RATE
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET_SEGMENT_ID
DescriptionThe unique identifier of the Role player category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 SALES_AND__CALE_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnCALENDAR_DATE_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 SALES_AND__CHAN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnCHANNEL_ROLE_ID [BIGINT]
Parent TableCHANNEL_ROLE
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintCHANNEL_ROLE_PK



 SALES_AND__FINA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnFINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
Parent TableFINANCIAL_SERVICES_PRODUCT
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintFINANCIAL_SERVICES_PRODUCT_PK



 SALES_AND__CHAN_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnCHANNEL_ROLE_MINI_DIMENSION_ID [BIGINT]
Parent TableCHANNEL_ROLE_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintCHANNEL_ROLE_MINI_DIMENSION_PK



 SALES_AND__FS_P_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnFINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID [BIGINT]
Parent TableFS_PRODUCT_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintFS_PRODUCT_MINI_DIMENSION_PK



 SALES_AND__GEOG_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role NameVerb2
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



 SALES_AND__PROD_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnLINE_OF_BUSINESS_ID [BIGINT]
Parent TablePRODUCT_GROUP
Parent Multiplicity1
Unique ConstraintPRODUCT_GROUP_PK



 SALES_AND__MARK_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_AND_ADMINISTRATION_PERFORMANCE_FACT
Child Role NameVerb3
Child Multiplicity*
Key ColumnMARKET_SEGMENT_ID [BIGINT]
Parent TableMARKET_SEGMENT
Parent Multiplicity1
Unique ConstraintMARKET_SEGMENT_PK

Primary Key Details

 SALES_AND_ADMINISTRATION_PERFORMANCE_FACT_PK
DescriptionThe unique identifier of the Sales and administration performance Fact
MemberCALENDAR_DATE_ID [BIGINT]
MemberCHANNEL_ROLE_ID [BIGINT]
MemberFINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
MemberGEOGRAPHIC_AREA_ID [BIGINT]
MemberLINE_OF_BUSINESS_ID [BIGINT]
MemberMARKET_SEGMENT_ID [BIGINT]