Fact Tables

Una uses several fact tables to store different types of data. Each table serves a specific purpose in the data model. [...S_Segments] represents a column for every segment associated with that fact table.

Name	Pattern	Purpose / Description	Key Columns / Notes
Metrics	`M_{model}`	Stores financial metrics and KPI data	`Id` `ScenarioId` `KpiId` `PeriodId` `V_Opening` `V_New` `V_Expand` `V_Churn` `V_Closing` `V_LID` `V_Notes` `[...S_Segments]`
Transaction	`T_{model}`	Each row = deal moving between stages (RevIQ Transaction Table)	`Id` `DealId` `DealName` `DateIn` `DateOut` `StageId` `MinorStageId` `NextStageId` `NextMinorStageId` `Progress` `Lost` `PeriodIn` `PeriodOut` `DaysInStage` `ARR` `ClientId` `ClientName` `PrevStageId` `PrevMinorStageId` `StandardStageId` `NextStandardStageId` `PrevStandardStageId` `CloseDate` `[...S_Segments]`
Bowtie	`B_{model}`	Aggregated actuals (from `T_{model}`) or forecasts (via `Appg_GenerateForecast_{model}`)	`Id` `ScenarioId` `KpiId` `PeriodId` `StageId` `V_Opening` `V_New` `V_Expand` `V_Progress` `V_Lost` `V_Closing` `V_Regress` `[...S_Segments]`
Statistics	`S_{model}`	Metrics from `B_{model}`/`T_{model}` (e.g., conversion %), used for forecasting	`Id` `ScenarioId` `KpiId` `PeriodId` `StageId` `Trend` `Value` `OriginalValue` `NeedsForecast` `[...S_Segments]`
Cohort	`C_{model}`	Cohort analysis data	`Id` `ScenarioId` `KpiId` `PeriodId` `StageId` `V_Overall` `V_Progress` `V_Regress` `V_Lost` `[...S_Segments]`
Virtual Cohort	`VCohort_{model}`	Virtual cohort data for analysis	`Id` `StageId` `DateIn` `PeriodIn` `DealId` `ClientId` `Progress` `Regress` `Lost` `ARR` `TotalDays` `[...S_Segments]`
Customer Balance	`CB_{model}`	Customer balance information	`Id` `IsPlug` `ClientId` `ClientName` `ScenarioId` `KpiId` `PeriodId` `V_Opening` `V_New` `V_Expand` `V_Churn` `V_Closing` `[...S_Segments]`
Customer Balance Sync	`CBS_{model}`	Customer balance sync (for synchronizing data)	`Id` `ClientId` `KpiId` `PeriodId` `V_Closing` `ClientName`
Write Metrics	`WM_{model}`	Writeback metrics data	`BatchId` `Measure` `ScenarioId` `KpiId` `PeriodId` `Value_Int` `Value_Float` `Value_Date` `Value_String` `[...S_Segments]`
Write Metrics Line Items	`WML_{model}`	Write metrics line items (detail)	`BatchId` `Measure` `ScenarioId` `KpiId` `PeriodId` `LIDDesc` `Value_Int` `Value_Float` `Value_Date` `Value_String` `[...S_Segments]`