{
    "version": 22,
    "typedId": "290.DM",
    "uniqueName": "Plasma_Quotes_Validations",
    "label": "Plasma_Quotes_Validations",
    "fields": [
        {
            "name": "UniqueId",
            "label": "UniqueId",
            "rank": 1,
            "visibility": 1,
            "expression": "",
            "numeric": false,
            "time": false,
            "persisted": true,
            "dimension": true,
            "calculated": false,
            "dbColumn": "attribute19",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": false,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": true,
            "deleted": false,
            "type": "TEXT",
            "functionalType": "KEY",
            "hidden": false
        },
        {
            "name": "Total_Quote_Revenue",
            "label": "Total_Quote_Revenue",
            "rank": 2,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Total_Number_Quotes",
            "label": "Total_Number_Quotes",
            "rank": 3,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue_In_Guidance",
            "label": "Revenue_In_Guidance",
            "rank": 4,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue_Outside_Guidance",
            "label": "Revenue_Outside_Guidance",
            "rank": 5,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Number_Approved",
            "label": "Number_Approved",
            "rank": 6,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue_Need_Approval",
            "label": "Revenue_Need_Approval",
            "rank": 7,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Margin_Need_Approval",
            "label": "Margin_Need_Approval",
            "rank": 8,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Number_Need_Approval",
            "label": "Number_Need_Approval",
            "rank": 9,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue_Approved",
            "label": "Revenue_Approved",
            "rank": 10,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Number_Approved_Relativity",
            "label": "Number_Approved_Relativity",
            "rank": 11,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue_Approved_Relativity",
            "label": "Revenue_Approved_Relativity",
            "rank": 12,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Total_Quotes_Relativity",
            "label": "Total_Quotes_Relativity",
            "rank": 13,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Total_Revenue_Relativity",
            "label": "Total_Revenue_Relativity",
            "rank": 14,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Revenue",
            "label": "Revenue",
            "rank": 15,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Number",
            "label": "Number",
            "rank": 16,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Simple_Avg",
            "label": "Simple_Avg",
            "rank": 17,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Weighted_Avg",
            "label": "Weighted_Avg",
            "rank": 18,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "GUID",
            "label": "GUID",
            "rank": 19,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "hidden": false
        },
        {
            "name": "Critical",
            "label": "Critical",
            "rank": 20,
            "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_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": false,
            "deleted": false,
            "type": "BOOLEAN",
            "hidden": false
        },
        {
            "name": "isDeleted",
            "label": "IsDeleted",
            "rank": 21,
            "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": 22,
            "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": 23,
            "visibility": 0,
            "expression": "",
            "numeric": false,
            "time": false,
            "persisted": true,
            "dimension": false,
            "calculated": false,
            "dbColumn": "attribute21",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": true,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": true,
            "key": false,
            "deleted": false,
            "type": "TEXT",
            "owningFC": "[System]",
            "hidden": true
        },
        {
            "name": "formulaDetailedResults",
            "label": "Details",
            "rank": 24,
            "visibility": 0,
            "expression": "",
            "numeric": false,
            "time": false,
            "persisted": true,
            "dimension": false,
            "calculated": false,
            "dbColumn": "attribute22",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": true,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": true,
            "key": false,
            "deleted": false,
            "type": "LOB",
            "owningFC": "[System]",
            "hidden": true
        },
        {
            "name": "warnings",
            "label": "Warnings",
            "rank": 25,
            "visibility": 0,
            "expression": "",
            "numeric": false,
            "time": false,
            "persisted": true,
            "dimension": false,
            "calculated": false,
            "dbColumn": "attribute23",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": true,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": true,
            "key": false,
            "deleted": false,
            "type": "LOB",
            "owningFC": "[System]",
            "hidden": true
        },
        {
            "name": "alerts",
            "label": "Alerts",
            "rank": 26,
            "visibility": 0,
            "expression": "",
            "numeric": false,
            "time": false,
            "persisted": true,
            "dimension": false,
            "calculated": false,
            "dbColumn": "attribute24",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": true,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": true,
            "key": false,
            "deleted": false,
            "type": "LOB",
            "owningFC": "[System]",
            "hidden": true
        },
        {
            "name": "completeResultsAvailable",
            "label": "Details",
            "rank": 27,
            "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": "attribute19",
            "aggregation": false,
            "partitioningKey": false,
            "auxiliary": false,
            "deployed": true,
            "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
            "queryable": true,
            "system": false,
            "key": true,
            "deleted": false,
            "type": "TEXT"
        }
    ],
    "reload": false,
    "lastUpdateByName": "jenkins",
    "source": "",
    "sources": [],
    "sourceName": "DM.Plasma_Quotes_Validations",
    "type": "DATAMART",
    "view": false,
    "queryable": true,
    "baseUomCode": "EA",
    "baseCcyCode": "USD",
    "valid": true,
    "auxiliary": false,
    "deployed": true,
    "dbTable": "templates-qa_DM_Plasma_Quotes_Validations",
    "dbKey": "attribute19",
    "locked": false,
    "createDate": "2021-04-22T07:50:11",
    "createdBy": 119,
    "lastUpdateDate": "2021-04-30T12:18:58",
    "lastUpdateBy": 119,
    "isPlasma": false,
    "normalization": "MEDIUM"
}