Untitled
unknown
plain_text
a year ago
48 kB
3
Indexable
{
"result": {
"result": {
"formLayout": [
{
"question_details": [
{
"name": "colName",
"answer": "",
"type": 1,
"props": {
"label": "Feature Name",
"maxLength": 63,
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 1
},
"id": 163
},
{
"name": "metricAggregation",
"answer": "",
"type": 2,
"props": {
"label": "Source Metric Aggregator",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 2
},
"id": 164
},
{
"name": "sourceLevel",
"answer": "",
"type": 2,
"props": {
"label": "Source Metric Level",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 3
},
"id": 165
},
{
"name": "metric",
"answer": "",
"type": 2,
"props": {
"label": "Source Metric",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 1,
"positionY": 4
},
"id": 166
},
{
"name": "segmentDimension",
"answer": "",
"type": 2,
"props": {
"label": "Segment Dimension",
"initialValue": "",
"isVisible": true,
"span": 1,
"positionX": 2,
"positionY": 1
},
"id": 167
},
{
"name": "description",
"answer": "",
"type": 3,
"props": {
"label": "Description",
"maxLength": 255,
"initialValue": "",
"isVisible": true,
"span": 2,
"positionX": 3,
"positionY": 1
},
"id": 168
},
{
"name": "volTranslationFeature",
"answer": "",
"type": 24,
"props": {
"label": "Volume Translation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"order\":0}",
"renderInfo": "To be provided from Moyeen"
},
"id": 169
},
{
"name": "timeAggrFeature",
"answer": "",
"type": 24,
"props": {
"label": "Time Aggregation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"order\":0}",
"renderInfo": "To be provided from Moyeen"
},
"id": 170
},
{
"name": "transformationFeature",
"answer": "",
"type": 24,
"props": {
"label": "Transformation",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"functionalForm\":0, \"parameterA\":\"\", \"parameterB\":\"\", \"parameterC\":\"\", \"parameterD\":\"\", \"expression\":\"\", \"order\":0}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "functionalForm",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Functional Form",
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 2
},
{
"answer": "",
"id": 0,
"name": "parameterA",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter a",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "parameterB",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter b",
"positionX": 3,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "parameterC",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Parameter c",
"positionX": 4,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "expression",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Expression",
"positionX": 5,
"positionY": 1,
"span": 1
},
"type": 11
}
]
},
"id": 172
},
{
"name": "normalizationFeature",
"answer": "",
"type": 24,
"props": {
"label": "Normalization",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"normalizationType\":0, \"value\":\"\", \"order\":0}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "normalizationType",
"props": {
"initialValue": "",
"isVisible": true,
"label": "NormalizationType",
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 2
},
{
"answer": "",
"id": 0,
"name": "value",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Input",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
}
]
},
"id": 171
},
{
"name": "timeCreditingFeature",
"answer": "",
"type": 24,
"props": {
"label": "Time Crediting",
"initialValue": "",
"isVisible": true,
"span": 0,
"positionX": 0,
"positionY": 0,
"payloadInfo": "{\"horizon\":\"\", \"order\":0, \"adstockValue\":\"\", \"lagValue\":\"\"}",
"renderInfo": [
{
"answer": "",
"id": 0,
"name": "horizon",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Horizon (=-1)",
"inpMin": -1,
"positionX": 1,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "adstockValue",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Adstock Value",
"positionX": 2,
"positionY": 1,
"span": 1
},
"type": 1
},
{
"answer": "",
"id": 0,
"name": "lagValue",
"props": {
"initialValue": "",
"isVisible": true,
"label": "Lag Value",
"positionX": 3,
"positionY": 1,
"span": 1
},
"type": 1
}
]
},
"id": 173
}
],
"label": "Feature Details"
}
],
"customParams": {
"transformationOn": "db",
"type": "Feature",
"dbId": "7d243bbfe0d949b8a9f828a3bf5c2fc6",
"dbName": "test_db",
"dbLevel": "GEOID_DMA",
"aggregation": "[{'name': 'Raw Level', 'value': 'raw'},{'name': 'DB Level', 'value': 'db'}]",
"normalization": "[{'name': 'Constant', 'value': 1},{'name': 'Sales', 'value': 2},{'name': 'Activity', 'value': 3},{'name': 'Miscellaneous', 'value': 4}]",
"functionalForm": "[{'name': 'Power', 'value': 1},{'name': 'Log', 'value': 2},{'name': 'Binary', 'value': 3},{'name': 'Neg ex', 'value': 4},{'name': 'Generic', 'value': 5},{'name': 'Neg ex + Cannibalization', 'value': 6}]",
"data": "{'column': ['aggregation', 'level', 'id', 'name', 'alias', 'biz_dtype', 'levelHierarchy', 'subSectionId', 'key'], 'data': [['db', 'GEOID_DMA', '43fb60077f9c4ea5bf60d0ad2e1ab7b9', 'INTERCEPT', 'INTERCEPT', 15, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|43fb60077f9c4ea5bf60d0ad2e1ab7b9|15|INTERCEPT'], ['db', 'GEOID_DMA', '730619a602b3408a94d7c0eb857939ac', 'ID_GEOID_DMA_GEOID_DMA', 'GEOID_DMA', 5, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|730619a602b3408a94d7c0eb857939ac|5|ID_GEOID_DMA_GEOID_DMA'], ['db', 'GEOID_DMA', '994c657498854438b82b2e94d577add2', 'DATERANGE_TIME_PERIOD_GEOID_DMA', 'TIME_PERIOD', 4, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|994c657498854438b82b2e94d577add2|4|DATERANGE_TIME_PERIOD_GEOID_DMA'], ['db', 'GEOID_DMA', '34549e84fcc24599a795af381ecd90e5', 'SALES_SALES_DMA_CURR_GEOID_DMA_previous', 'SALES_DMA_CURR_previous', 14, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|34549e84fcc24599a795af381ecd90e5|14|SALES_SALES_DMA_CURR_GEOID_DMA_previous'], ['db', 'GEOID_DMA', 'd1662a79f61b45f393a218005a62a03a', 'SALES_SALES_DMA_CURR_GEOID_DMA', 'SALES_DMA_CURR', 1, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|d1662a79f61b45f393a218005a62a03a|1|SALES_SALES_DMA_CURR_GEOID_DMA'], ['db', 'GEOID_DMA', 'af7975650aac4ca89c04f8f2765aa579', 'SALES_SALES_DMA_UNIT_GEOID_DMA_previous', 'SALES_DMA_UNIT_previous', 14, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|af7975650aac4ca89c04f8f2765aa579|14|SALES_SALES_DMA_UNIT_GEOID_DMA_previous'], ['db', 'GEOID_DMA', '381b44bdeef643a888df1606e0bc8da4', 'SALES_SALES_DMA_UNIT_GEOID_DMA', 'SALES_DMA_UNIT', 1, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|381b44bdeef643a888df1606e0bc8da4|1|SALES_SALES_DMA_UNIT_GEOID_DMA'], ['db', 'GEOID_DMA', '2f2da4a3401a482fb6fc361b74ea01c8', 'ACTIVITY_COUNT_DMA_CUSTOMER_CNT_2021_GEOID_DMA', 'COUNT_DMA_CUSTOMER_CNT_2021', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|2f2da4a3401a482fb6fc361b74ea01c8|2|ACTIVITY_COUNT_DMA_CUSTOMER_CNT_2021_GEOID_DMA'], ['db', 'GEOID_DMA', 'b6acffd6b4ff4f7980fed789789f132a', 'ACTIVITY_ACTIVITY_DMA_EVENT_HCP_CNT_GEOID_DMA', 'ACTIVITY_DMA_EVENT_HCP_CNT', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|b6acffd6b4ff4f7980fed789789f132a|2|ACTIVITY_ACTIVITY_DMA_EVENT_HCP_CNT_GEOID_DMA'], ['db', 'GEOID_DMA', '5bccd94ff2bf4b82af9fb1c42b19a33d', 'ACTIVITY_ACTIVITY_DMA_EVENT_CNT_GEOID_DMA', 'ACTIVITY_DMA_EVENT_CNT', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|5bccd94ff2bf4b82af9fb1c42b19a33d|2|ACTIVITY_ACTIVITY_DMA_EVENT_CNT_GEOID_DMA'], ['db', 'GEOID_DMA', '3d3a556d45b44f229cc4548a1646cfcf', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_SENT_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|3d3a556d45b44f229cc4548a1646cfcf|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', 'ccca94fd04b24887964b7d4f3418a240', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_OPENED_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|ccca94fd04b24887964b7d4f3418a240|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', 'e8fb59270b2246889bd78fedb0a9b888', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_CLICKED_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|e8fb59270b2246889bd78fedb0a9b888|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', 'd47b8b1658034cf989d346d6363b896a', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_DELIVERED_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|d47b8b1658034cf989d346d6363b896a|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', '7608641087614823af90e115b0865037', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_TOTAL_CALLS_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7608641087614823af90e115b0865037|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', '3bc927605620414a97526b53fe40b722', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_TOTAL_DETAILS_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|3bc927605620414a97526b53fe40b722|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', '8640c108461744279944a94afb5b6f30', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_EVENTS_ATTENDED_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|8640c108461744279944a94afb5b6f30|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', '8ef6067408ff4dc0815b6dcd9572b2cc', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_SAMPLES_DROPPED_Mapped_GEOID_DMA', 2, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|8ef6067408ff4dc0815b6dcd9572b2cc|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP_GEOID_DMA'], ['db', 'GEOID_DMA', '0b425e0625f84f879fb13d6a86b6d49c', 'ACTIVITY_N_GEOID_DMA', 'n', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|0b425e0625f84f879fb13d6a86b6d49c|2|ACTIVITY_N_GEOID_DMA'], ['db', 'GEOID_DMA', 'a0397b40127e49af9bf0f9afb4c41122', 'SEGMENT_SEG_TEST_GEOID_DMA', 'seg_test', 3, 'parent', 21, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|a0397b40127e49af9bf0f9afb4c41122|3|SEGMENT_SEG_TEST_GEOID_DMA'], ['db', 'GEOID_DMA', '675ff6ef241046bc9216b97e016ebde9', 'SEGMENT_TEST_GEOID_DMA', 'test', 3, 'parent', 21, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|675ff6ef241046bc9216b97e016ebde9|3|SEGMENT_TEST_GEOID_DMA'], ['db', 'GEOID_DMA', 'a326626faf894277bc40317911b81162', 'SEGMENT_TEST_07_GEOID_DMA', 'test_07', 3, 'parent', 23, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|a326626faf894277bc40317911b81162|3|SEGMENT_TEST_07_GEOID_DMA'], ['db', 'GEOID_DMA', '01b7209428994acf9c3240d797e870fd', 'ACTIVITY_T_CARRYOVER_GEOID_DMA', 't_carryover', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|01b7209428994acf9c3240d797e870fd|2|ACTIVITY_T_CARRYOVER_GEOID_DMA'], ['db', 'GEOID_DMA', '437d95fa945c4dee816dc88960a786b0', 'SEGMENT_BB_GEOID_DMA', 'bb', 3, 'parent', 15, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|437d95fa945c4dee816dc88960a786b0|3|SEGMENT_BB_GEOID_DMA'], ['db', 'GEOID_DMA', '02fa2c3aec2f4683a413358214545041', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|02fa2c3aec2f4683a413358214545041|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology'], ['db', 'GEOID_DMA', '7e035f4c2a8f45bfb3318c23e1839195', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7e035f4c2a8f45bfb3318c23e1839195|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology'], ['db', 'GEOID_DMA', '037bf56c46e745a0a0f0ce12e7c90ca3', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinolo', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|037bf56c46e745a0a0f0ce12e7c90ca3|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinology'], ['db', 'GEOID_DMA', '6307b3d0a6454dadb80a472e9749fd49', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medicine', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medi', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|6307b3d0a6454dadb80a472e9749fd49|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medicine'], ['db', 'GEOID_DMA', 'd980dbc5f5494684b076325f58c58a56', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenterology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenter', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|d980dbc5f5494684b076325f58c58a56|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenterology'], ['db', 'GEOID_DMA', '8f1298ae9c3b4cbb9286ae590272caf5', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Practice', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Pra', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|8f1298ae9c3b4cbb9286ae590272caf5|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Practice'], ['db', 'GEOID_DMA', 'd835dcd5899b4ac1888ca306a5bbf610', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|d835dcd5899b4ac1888ca306a5bbf610|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics'], ['db', 'GEOID_DMA', '96a75a42e9924c52adba2a2426aa7117', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|96a75a42e9924c52adba2a2426aa7117|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology'], ['db', 'GEOID_DMA', '92886acb82114b49944572990c4a6864', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_Diseases', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|92886acb82114b49944572990c4a6864|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_Diseases'], ['db', 'GEOID_DMA', '801fc916df4a45a2ad4e39a4f7295a09', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Medicine', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Me', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|801fc916df4a45a2ad4e39a4f7295a09|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Medicine'], ['db', 'GEOID_DMA', '58dcf3130a64454cb69fbcdf41e92665', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|58dcf3130a64454cb69fbcdf41e92665|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology'], ['db', 'GEOID_DMA', '1107fefe39d9438ea7074933128ed7a7', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|1107fefe39d9438ea7074933128ed7a7|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology'], ['db', 'GEOID_DMA', '921d54cbdd8d4e43b9611efac6b2b37f', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|921d54cbdd8d4e43b9611efac6b2b37f|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology'], ['db', 'GEOID_DMA', '294f9464e22845e6811872d90597247d', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|294f9464e22845e6811872d90597247d|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others'], ['db', 'GEOID_DMA', '0b59db07ad7444ddbc892bb1de4cdecd', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|0b59db07ad7444ddbc892bb1de4cdecd|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics'], ['db', 'GEOID_DMA', 'fc0e25f4870948fabd7b60e94cddf107', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|fc0e25f4870948fabd7b60e94cddf107|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology'], ['db', 'GEOID_DMA', '64783d6c801f42869326720667d86f14', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatology', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatolog', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|64783d6c801f42869326720667d86f14|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatology'], ['db', 'GEOID_DMA', '7a872d06370c411299aad7d9759a7f05', 'ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_General', 'fn_raw_seg_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_G', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7a872d06370c411299aad7d9759a7f05|13|ACTIVITY_FN_RAW_SEG_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_General'], ['db', 'GEOID_DMA', '288712a7f3cd458f9a38bd52ee15bc1f', 'SEGMENT_FLAG_GEOID_DMA', 'flag', 3, 'parent', 15, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|288712a7f3cd458f9a38bd52ee15bc1f|3|SEGMENT_FLAG_GEOID_DMA'], ['db', 'GEOID_DMA', 'e68ff667bcf74c36930658424783bdc5', 'ACTIVITY_FN_GEOID_DMA', 'fn', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|e68ff667bcf74c36930658424783bdc5|2|ACTIVITY_FN_GEOID_DMA'], ['db', 'GEOID_DMA', '7ba45a62198547c482614986469d4eeb', 'ACTIVITY_FN_SAME_LEVEL_RAW_GEOID_DMA', 'fn_same_level_raw', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7ba45a62198547c482614986469d4eeb|2|ACTIVITY_FN_SAME_LEVEL_RAW_GEOID_DMA'], ['db', 'GEOID_DMA', 'e16f5fe3c1d9437288aa2843ed28a287', 'SEGMENT_A_GEOID_DMA', 'a', 3, 'parent', 22, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|e16f5fe3c1d9437288aa2843ed28a287|3|SEGMENT_A_GEOID_DMA'], ['db', 'GEOID_DMA', 'a37ce09c021a4c508a7b5e9f38df46b2', 'SEGMENT_TEST03_GEOID_DMA', 'test03', 3, 'parent', 21, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|a37ce09c021a4c508a7b5e9f38df46b2|3|SEGMENT_TEST03_GEOID_DMA'], ['db', 'GEOID_DMA', 'bd4af1d1e55e482aa07ad80f387122af', 'SEGMENT_TEST04_GEOID_DMA', 'test04', 3, 'parent', 24, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|bd4af1d1e55e482aa07ad80f387122af|3|SEGMENT_TEST04_GEOID_DMA'], ['db', 'GEOID_DMA', '4659db12dbc14861916aa4e58ef39e88', 'SEGMENT_TEST05_GEOID_DMA', 'test05', 3, 'parent', 22, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|4659db12dbc14861916aa4e58ef39e88|3|SEGMENT_TEST05_GEOID_DMA'], ['db', 'GEOID_DMA', '048ee640d042444b91c02a7b92d2bddb', 'SEGMENT_TEST06_GEOID_DMA', 'test06', 3, 'parent', 23, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|048ee640d042444b91c02a7b92d2bddb|3|SEGMENT_TEST06_GEOID_DMA'], ['db', 'GEOID_DMA', '42e673d288d24a3d94d8e175c6246aec', 'SEGMENT_TEST08_GEOID_DMA', 'test08', 3, 'parent', 23, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|42e673d288d24a3d94d8e175c6246aec|3|SEGMENT_TEST08_GEOID_DMA'], ['db', 'GEOID_DMA', '0412600284814041ab945e412edba1af', 'ACTIVITY_NEWTEST1_GEOID_DMA', 'newTest1', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|0412600284814041ab945e412edba1af|2|ACTIVITY_NEWTEST1_GEOID_DMA'], ['db', 'GEOID_DMA', '85c8739460d94c33af06e32e9c3838c3', 'ACTIVITY_TEST01_GEOID_DMA', 'test01', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|85c8739460d94c33af06e32e9c3838c3|2|ACTIVITY_TEST01_GEOID_DMA'], ['db', 'GEOID_DMA', '4524cfbc851a4056b369d1a530d1a2fe', 'SALES_NEW_NORM_TEST_GEOID_DMA', 'new_norm_test', 1, 'parent', 19, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|4524cfbc851a4056b369d1a530d1a2fe|1|SALES_NEW_NORM_TEST_GEOID_DMA'], ['db', 'GEOID_DMA', '724e1c1591f6449a956a53a6d9acaac8', 'SALES_NEW_NORM_TEST_GEOID_DMA_previous', 'new_norm_test_previous', 14, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|724e1c1591f6449a956a53a6d9acaac8|14|SALES_NEW_NORM_TEST_GEOID_DMA_previous'], ['db', 'GEOID_DMA', '8518e1f28d8c4248b63a11afaa707046', 'SALES_NW_TEST_GEOID_DMA', 'nw_test', 1, 'parent', 19, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|8518e1f28d8c4248b63a11afaa707046|1|SALES_NW_TEST_GEOID_DMA'], ['db', 'GEOID_DMA', '270736c15ad74a79a798c33364dd5ebb', 'SALES_NW_TEST_GEOID_DMA_previous', 'nw_test_previous', 14, 'parent', 0, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|270736c15ad74a79a798c33364dd5ebb|14|SALES_NW_TEST_GEOID_DMA_previous'], ['db', 'GEOID_DMA', 'fd7ff551aa3b4349a9fd20d8dd3175fe', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|fd7ff551aa3b4349a9fd20d8dd3175fe|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Cardiology'], ['db', 'GEOID_DMA', 'cdb8aae85c4e42acb3d8d8dfb13d48a7', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|cdb8aae85c4e42acb3d8d8dfb13d48a7|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Diabetology'], ['db', 'GEOID_DMA', 'ac87af668fa4491c9671cbda3c5950e1', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|ac87af668fa4491c9671cbda3c5950e1|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Endocrinology'], ['db', 'GEOID_DMA', '027cdf07c9c84018b68472039cb9601a', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medicine', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medicine', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|027cdf07c9c84018b68472039cb9601a|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Family_Medicine'], ['db', 'GEOID_DMA', '5211704c2da749819edabc6a9a2e9ff4', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenterology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenterology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|5211704c2da749819edabc6a9a2e9ff4|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Gastroenterology'], ['db', 'GEOID_DMA', 'f51a0173cbbc4573b7e2897960678330', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Practice', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Practice', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|f51a0173cbbc4573b7e2897960678330|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_General_Practice'], ['db', 'GEOID_DMA', '39d76461be34409ca2efd627cfa23507', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|39d76461be34409ca2efd627cfa23507|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Geriatrics'], ['db', 'GEOID_DMA', '7560e020140f4250b851db2644a2376a', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7560e020140f4250b851db2644a2376a|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Hematology'], ['db', 'GEOID_DMA', '990ddebbeb724e2689cb360c3504fcd4', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_Diseases', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_Disea', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|990ddebbeb724e2689cb360c3504fcd4|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Infectious_Diseases'], ['db', 'GEOID_DMA', '738b3b7e9a8b4485a38a94789eba2017', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Medicine', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Medicin', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|738b3b7e9a8b4485a38a94789eba2017|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Internal_Medicine'], ['db', 'GEOID_DMA', '7a7214667ea04602951247b63fd2e5ff', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7a7214667ea04602951247b63fd2e5ff|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Nephrology'], ['db', 'GEOID_DMA', '365ae356b9d647d4814ab7b7f330f513', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|365ae356b9d647d4814ab7b7f330f513|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Neurology'], ['db', 'GEOID_DMA', '0c593c4fe0ae4d46addc3288a40e82a9', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|0c593c4fe0ae4d46addc3288a40e82a9|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Oncology'], ['db', 'GEOID_DMA', '893e5279a5b44f33ad6b70694e46569b', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|893e5279a5b44f33ad6b70694e46569b|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Others'], ['db', 'GEOID_DMA', 'fd3706755b194ee2bcdb16208b245dfe', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|fd3706755b194ee2bcdb16208b245dfe|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pediatrics'], ['db', 'GEOID_DMA', 'cf59dd36fe264b8ab68a5dfb8084fba8', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|cf59dd36fe264b8ab68a5dfb8084fba8|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Pulmonology'], ['db', 'GEOID_DMA', '2ebbf7e95d3342be951e070069c5c38d', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatology', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatology', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|2ebbf7e95d3342be951e070069c5c38d|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Rheumatology'], ['db', 'GEOID_DMA', '7f2616959793418094860ec50f8ecf9d', 'ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_General', 'tt123_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_Genera', 13, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7f2616959793418094860ec50f8ecf9d|13|ACTIVITY_TT123_GEOID_DMA_SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP_Surgeon_-_General'], ['db', 'GEOID_DMA', '7a3011a0875d491f874e9354c833c744', 'ACTIVITY_YAY_GEOID_DMA', 'yay', 2, 'parent', 29, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|7a3011a0875d491f874e9354c833c744|2|ACTIVITY_YAY_GEOID_DMA'], ['db', 'GEOID_DMA', '2560b63d0d744f63a421d823430e376a', 'ACTIVITY_NEW_NORM_GEOID_DMA', 'new_norm', 2, 'parent', 19, '19f112ecd7d5468d98e0032b57755ea3|c05c63794843448ba68acd4af95e7972|GEOID_DMA|2560b63d0d744f63a421d823430e376a|2|ACTIVITY_NEW_NORM_GEOID_DMA'], ['raw', 'CUSTID_HCP', 'b0488ba6db4346948f04d38aac55ba77', 'ID_CUSTID_HCP_CUSTID_HCP', 'CUSTID_HCP', 5, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|b0488ba6db4346948f04d38aac55ba77|5|ID_CUSTID_HCP_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'bf12d1930fdb490dbb7966b1d50bc54a', 'DATERANGE_TIME_PERIOD_CUSTID_HCP', 'TIME_PERIOD', 4, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|bf12d1930fdb490dbb7966b1d50bc54a|4|DATERANGE_TIME_PERIOD_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '018bd7d3044945f6b2d3a8c6e8e4c2fb', 'ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP', 'ACTIVITY_HCP_FUE_SENT', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|018bd7d3044945f6b2d3a8c6e8e4c2fb|2|ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'f398e38cc5a04988952ae5b0743d829c', 'ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP', 'ACTIVITY_HCP_FUE_OPENED', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|f398e38cc5a04988952ae5b0743d829c|2|ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'd145d53a9177428da0439362cc5fa9a7', 'ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP', 'ACTIVITY_HCP_FUE_CLICKED', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|d145d53a9177428da0439362cc5fa9a7|2|ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'cf6bfeb2ee4a4e4f883c100abe8ed279', 'ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP', 'ACTIVITY_HCP_FUE_DELIVERED', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|cf6bfeb2ee4a4e4f883c100abe8ed279|2|ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'ba0c3a6fcd27485ea03c4ea4a642733a', 'ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP', 'ACTIVITY_HCP_TOTAL_CALLS', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|ba0c3a6fcd27485ea03c4ea4a642733a|2|ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '0a13bf5d358044d79002464f95ed3a0d', 'ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP', 'ACTIVITY_HCP_TOTAL_DETAILS', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|0a13bf5d358044d79002464f95ed3a0d|2|ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '10587179a54d47e8aef80ea73180f1e7', 'ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP', 'ACTIVITY_HCP_EVENTS_ATTENDED', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|10587179a54d47e8aef80ea73180f1e7|2|ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '87677d6f2cf44f3b8dbdf7d9bd58504e', 'ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP', 'ACTIVITY_HCP_SAMPLES_DROPPED', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|87677d6f2cf44f3b8dbdf7d9bd58504e|2|ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '3d33d18ff05948d1b5a153d45d915b13', 'SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP', 'SEGMENT_HCP_SPECIALTY', 3, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|3d33d18ff05948d1b5a153d45d915b13|3|SEGMENT_SEGMENT_HCP_SPECIALTY_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '0b8d2248b97b491482f30346d068f60f', 'SEGMENT_SEGMENT_HCP_BEHAVIORAL_LATEST_CUSTID_HCP', 'SEGMENT_HCP_BEHAVIORAL_LATEST', 3, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|0b8d2248b97b491482f30346d068f60f|3|SEGMENT_SEGMENT_HCP_BEHAVIORAL_LATEST_CUSTID_HCP'], ['raw', 'CUSTID_HCP', '51f84ee7953b4edc92f585923eac1a41', 'SEGMENT_SEGMENT_HCP_CVM_LATEST_CUSTID_HCP', 'SEGMENT_HCP_CVM_LATEST', 3, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|51f84ee7953b4edc92f585923eac1a41|3|SEGMENT_SEGMENT_HCP_CVM_LATEST_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'a3c7903529154760bbc8e50ab587f5ab', 'SEGMENT_CUT_CUSTID_HCP', 'CUT', 3, 'lower', 7, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|a3c7903529154760bbc8e50ab587f5ab|3|SEGMENT_CUT_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'ec053750059541afb8eda5feb8a65445', 'SEGMENT_GRP_CUSTID_HCP', 'grp', 3, 'lower', 9, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|ec053750059541afb8eda5feb8a65445|3|SEGMENT_GRP_CUSTID_HCP'], ['raw', 'CUSTID_HCP', 'd2b14878d24f428d841be6166f0fa23e', 'SALES_TEST_ABCD_CUSTID_HCP', 'test_abcd', 1, 'lower', 5, '19f112ecd7d5468d98e0032b57755ea3|e69768cc571a4ce18dd2ef92e38321d9|CUSTID_HCP|d2b14878d24f428d841be6166f0fa23e|1|SALES_TEST_ABCD_CUSTID_HCP'], ['raw', 'GEOID_DMA', 'c6a819fbf3a6441788b4edef013ecf2c', 'SALES_SALES_DMA_UNIT_GEOID_DMA', 'SALES_DMA_UNIT', 1, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|c6a819fbf3a6441788b4edef013ecf2c|1|SALES_SALES_DMA_UNIT_GEOID_DMA'], ['raw', 'GEOID_DMA', '7270c896629a4f0aa0c82b98ea0343b0', 'ACTIVITY_COUNT_DMA_CUSTOMER_CNT_2021_GEOID_DMA', 'COUNT_DMA_CUSTOMER_CNT_2021', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|7270c896629a4f0aa0c82b98ea0343b0|2|ACTIVITY_COUNT_DMA_CUSTOMER_CNT_2021_GEOID_DMA'], ['raw', 'GEOID_DMA', 'a2b8aa08d44c4b848e9bce16953e6195', 'ACTIVITY_ACTIVITY_DMA_EVENT_HCP_CNT_GEOID_DMA', 'ACTIVITY_DMA_EVENT_HCP_CNT', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|a2b8aa08d44c4b848e9bce16953e6195|2|ACTIVITY_ACTIVITY_DMA_EVENT_HCP_CNT_GEOID_DMA'], ['raw', 'GEOID_DMA', 'f4916b9b69ea48f4973242ea5181bfbb', 'ACTIVITY_ACTIVITY_DMA_EVENT_CNT_GEOID_DMA', 'ACTIVITY_DMA_EVENT_CNT', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|f4916b9b69ea48f4973242ea5181bfbb|2|ACTIVITY_ACTIVITY_DMA_EVENT_CNT_GEOID_DMA'], ['raw', 'GEOID_DMA', 'b975e2d88a8246a7b794ace3459e7273', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_SENT_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|b975e2d88a8246a7b794ace3459e7273|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_SENT_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', 'd31f6f775cb04817a5a725d632c40c52', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_OPENED_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|d31f6f775cb04817a5a725d632c40c52|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_OPENED_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', 'a1ca49b9c0e146f3b1cb9367070478c6', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_CLICKED_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|a1ca49b9c0e146f3b1cb9367070478c6|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_CLICKED_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', '7206a82a8f1640a1be1090937b1b2128', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_FUE_DELIVERED_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|7206a82a8f1640a1be1090937b1b2128|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_FUE_DELIVERED_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', '60e1469fa9e2471db5b3afc836f6be64', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_TOTAL_CALLS_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|60e1469fa9e2471db5b3afc836f6be64|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_CALLS_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', '12658e2efcd141a0aada1353c64b30d7', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_TOTAL_DETAILS_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|12658e2efcd141a0aada1353c64b30d7|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_TOTAL_DETAILS_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', 'ae0040a0c82c47d096cc6f28dc4e6a7c', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_EVENTS_ATTENDED_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|ae0040a0c82c47d096cc6f28dc4e6a7c|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_EVENTS_ATTENDED_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', '0bce1153172a4da0b02182f6d0138e88', 'ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP_GEOID_DMA', 'ACTIVITY_HCP_SAMPLES_DROPPED_Mapped_GEOID_DMA', 2, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|0bce1153172a4da0b02182f6d0138e88|2|ACTIVITY_ACTIVITY_ACTIVITY_HCP_SAMPLES_DROPPED_CUSTID_HCP_GEOID_DMA'], ['raw', 'GEOID_DMA', '640889a1829b4f3ab9e6f61ca1364ae7', 'ACTIVITY_TT12_GEOID_DMA', 'tt12', 2, 'lower', 5, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|640889a1829b4f3ab9e6f61ca1364ae7|2|ACTIVITY_TT12_GEOID_DMA'], ['raw', 'GEOID_DMA', '2d9efe8a33bd43ecba5289d1f9614186', 'SEGMENT_TT2_GEOID_DMA', 'tt2', 3, 'lower', 9, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|2d9efe8a33bd43ecba5289d1f9614186|3|SEGMENT_TT2_GEOID_DMA'], ['raw', 'GEOID_DMA', '828d5ebf895848cf9c8801b95b0f1caf', 'SEGMENT_TEST_GEOID_DMA', 'test', 3, 'lower', 8, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|828d5ebf895848cf9c8801b95b0f1caf|3|SEGMENT_TEST_GEOID_DMA'], ['raw', 'GEOID_DMA', 'a069761b214441859ad2f5c00d624362', 'ID_GEOID_DMA_GEOID_DMA', 'GEOID_DMA', 5, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|a069761b214441859ad2f5c00d624362|5|ID_GEOID_DMA_GEOID_DMA'], ['raw', 'GEOID_DMA', '3b6bfbadfc244f349a2958cf0fb432dc', 'DATERANGE_TIME_PERIOD_GEOID_DMA', 'TIME_PERIOD', 4, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|3b6bfbadfc244f349a2958cf0fb432dc|4|DATERANGE_TIME_PERIOD_GEOID_DMA'], ['raw', 'GEOID_DMA', '33a6dbec33db40228283f26454ef7b17', 'SALES_SALES_DMA_CURR_GEOID_DMA', 'SALES_DMA_CURR', 1, 'lower', 0, '19f112ecd7d5468d98e0032b57755ea3|e87dcd36901d41d9bf3e00bcd43cb8c6|GEOID_DMA|33a6dbec33db40228283f26454ef7b17|1|SALES_SALES_DMA_CURR_GEOID_DMA']]}"
},
"isMultiplicative": true
}
},
"status": { "code": 200, "message": "Questions fetched successfully" }
}