Opportunity custom field values fact table
Bi_FactOpportunityCustomFieldValues
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter Centerwid | ||
Fieldwid | bigint | Unique identifier for fields in the opportunity form | |||
IsActive | BOOLEAN | Indicates if field value is active or not | |||
OpportunityFieldValueId | VARCHAR(36) | unique identfier for the row in the table | |||
OpportunityFieldValuewid | bigint | unique identfier for the row in the table | Yes | ||
OpportunityId | VARCHAR(36) | Unique identifier of the opportunity. This is a non-blank value that is generated in the core system for every opportunity | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Value | VARCHAR(32000) | Name of the field | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
etlcreateddate | timestamp | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||