{ "version": 18, "typedId": "292.DM", "uniqueName": "Plasma_Transactions_Validations", "label": "Plasma_Transactions_Validations", "fields": [ { "name": "UniqueId", "label": "UniqueId", "rank": 1, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": true, "calculated": false, "dbColumn": "attribute36", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": true, "deleted": false, "type": "TEXT", "functionalType": "KEY", "hidden": false }, { "name": "GUID", "label": "GUID", "rank": 2, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute10", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Customer_90_Decile", "label": "Customer_90_Decile", "rank": 3, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute7", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Product_90_Decile", "label": "Product_90_Decile", "rank": 4, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute23", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Customer_Decile", "label": "Customer_Decile", "rank": 5, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute9", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Product_Decile", "label": "Product_Decile", "rank": 6, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute24", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_Accounts_Positive_Negative_Margin", "label": "Total_Accounts_Positive_Negative_Margin", "rank": 7, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute31", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_Products_Positive_Negative_Margin", "label": "Total_Products_Positive_Negative_Margin", "rank": 8, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute33", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_Transactions_Positive_Negative_Margin", "label": "Total_Transactions_Positive_Negative_Margin", "rank": 9, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute35", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Revenue_Accounts_Positive_Negative_Margin", "label": "Revenue_Accounts_Positive_Negative_Margin", "rank": 10, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute26", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Revenue_Products_Positive_Negative_Margin", "label": "Revenue_Products_Positive_Negative_Margin", "rank": 11, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute27", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Revenue_Transactions_Positive_Negative_Margin", "label": "Revenue_Transactions_Positive_Negative_Margin", "rank": 12, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute28", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "ListPrice_Bucket", "label": "ListPrice_Bucket", "rank": 13, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute13", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "InvoicePrice_Bucket", "label": "InvoicePrice_Bucket", "rank": 14, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute11", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "NetPrice_Bucket", "label": "NetPrice_Bucket", "rank": 15, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute16", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "RealizedPrice_Bucket", "label": "RealizedPrice_Bucket", "rank": 16, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute25", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Margin_Bucket", "label": "Margin_Bucket", "rank": 17, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute15", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Annual_Change_List_Price", "label": "Annual_Change_List_Price", "rank": 18, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute2", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Annual_Change_Invoice_Price", "label": "Annual_Change_Invoice_Price", "rank": 19, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute1", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Annual_Change_Net_Price", "label": "Annual_Change_Net_Price", "rank": 20, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute4", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Annual_Change_Realized_Price", "label": "Annual_Change_Realized_Price", "rank": 21, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute5", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Annual_Change_Margin", "label": "Annual_Change_Margin", "rank": 22, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute3", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Invoice_Price", "label": "Invoice_Price", "rank": 23, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute12", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "List_Price", "label": "List_Price", "rank": 24, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute14", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Customer_Charges", "label": "Customer_Charges", "rank": 25, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute8", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_SalesHC", "label": "Total_SalesHC", "rank": 26, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute34", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_Accounts", "label": "Total_Accounts", "rank": 27, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute30", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Total_Products", "label": "Total_Products", "rank": 28, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute32", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_Accounts", "label": "Number_Accounts", "rank": 29, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute17", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_Products", "label": "Number_Products", "rank": 30, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute21", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_Transactions", "label": "Number_Transactions", "rank": 31, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute22", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_PriceChanges", "label": "Number_PriceChanges", "rank": 32, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute19", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_Customer_Decile", "label": "Number_Customer_Decile", "rank": 33, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute18", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Number_Product_Decile", "label": "Number_Product_Decile", "rank": 34, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute20", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "SalesHC_Zero", "label": "SalesHC_Zero", "rank": 35, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute29", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "TEXT", "hidden": false }, { "name": "Critical", "label": "Critical", "rank": 36, "visibility": 1, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute6", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": false, "deleted": false, "type": "BOOLEAN", "hidden": false }, { "name": "isDeleted", "label": "IsDeleted", "rank": 37, "visibility": 0, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "queryable": false, "system": true, "key": false, "deleted": false, "type": "BOOLEAN", "owningFC": "[System]", "hidden": true }, { "name": "lastUpdateDate", "label": "LastUpdateDate", "rank": 38, "visibility": 0, "expression": "", "numeric": false, "time": true, "persisted": true, "dimension": false, "calculated": false, "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "queryable": true, "system": true, "key": false, "deleted": false, "type": "DATETIME", "owningFC": "[System]", "hidden": true }, { "name": "formulaResult", "label": "Result", "rank": 39, "visibility": 0, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute37", "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": true, "key": false, "deleted": false, "type": "TEXT", "owningFC": "[System]", "hidden": true }, { "name": "formulaDetailedResults", "label": "Details", "rank": 40, "visibility": 0, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute38", "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": true, "key": false, "deleted": false, "type": "LOB", "owningFC": "[System]", "hidden": true }, { "name": "warnings", "label": "Warnings", "rank": 41, "visibility": 0, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute39", "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": true, "key": false, "deleted": false, "type": "LOB", "owningFC": "[System]", "hidden": true }, { "name": "alerts", "label": "Alerts", "rank": 42, "visibility": 0, "expression": "", "numeric": false, "time": false, "persisted": true, "dimension": false, "calculated": false, "dbColumn": "attribute40", "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": true, "key": false, "deleted": false, "type": "LOB", "owningFC": "[System]", "hidden": true }, { "name": "completeResultsAvailable", "label": "Details", "rank": 43, "visibility": 0, "expression": "NOT ISNULL(formulaDetailedResults)", "numeric": false, "time": false, "persisted": false, "dimension": false, "calculated": true, "aggregation": false, "partitioningKey": false, "auxiliary": true, "deployed": false, "queryable": true, "system": true, "key": false, "deleted": false, "type": "BOOLEAN", "owningFC": "[System]", "hidden": true } ], "keyFields": [ { "name": "UniqueId", "label": "UniqueId", "rank": 1, "visibility": 1, "expression": "UniqueId", "numeric": false, "time": false, "persisted": true, "dimension": true, "calculated": false, "dbColumn": "attribute36", "aggregation": false, "partitioningKey": false, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "queryable": true, "system": false, "key": true, "deleted": false, "type": "TEXT" } ], "reload": false, "lastUpdateByName": "jenkins", "source": "", "sources": [], "sourceName": "DM.Plasma_Transactions_Validations", "type": "DATAMART", "view": false, "queryable": true, "baseUomCode": "EA", "baseCcyCode": "USD", "valid": true, "auxiliary": false, "deployed": true, "dbTable": "templates-qa_DM_Plasma_Transactions_Validations", "dbKey": "attribute36", "locked": false, "createDate": "2021-04-22T07:50:14", "createdBy": 119, "lastUpdateDate": "2021-04-30T12:19:01", "lastUpdateBy": 119, "lastDataModificationDate": "2021-04-28T04:55:38", "isPlasma": false, "normalization": "MEDIUM" }