{
"_id" : ObjectId("68743cc2c0d4cb00175e0929"),
"version" : NumberInt(0),
"createDate" : "2025-07-12T21:55:14.150Z",
"updateDate" : "2025-07-12T21:55:14.150Z",
"addressStandardizationMode" : "CASS",
"name" : "datamart_provider",
"fields" : [
{
"name" : "aais",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "address01",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "address02",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "addressStandardization",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "adid",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "city",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "client_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "create_date",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "email",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "file_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "firstName",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_md5",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha1",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha256",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha3",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_md5",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha1",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha256",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha3",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "idfa",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "lastName",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "maid",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_a",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_h",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_i",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "originalRecord",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "phone",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "record_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "state",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "zipcode",
"maxMissing" : NumberInt(3),
"profile" : false
}
],
"output" : {
"format" : "TABLE",
"fields" : [
{
"name" : "originalRecord"
},
{
"name" : "file_id"
},
{
"name" : "client_id"
},
{
"name" : "record_id"
},
{
"name" : "aais"
},
{
"name" : "create_date",
"format" : "yyyy-MM-dd"
},
{
"name" : "adid"
},
{
"name" : "maid"
},
{
"name" : "idfa"
},
{
"name" : "matchcode_a",
"alias" : "bd_address_id"
},
{
"name" : "matchcode_h",
"alias" : "bd_household_id"
},
{
"name" : "matchcode_i",
"alias" : "bd_individual_id"
},
{
"name" : "hem_md5"
},
{
"name" : "hem_sha1"
},
{
"name" : "hem_sha256"
},
{
"name" : "hem_sha3"
},
{
"name" : "hashed_phone_md5"
},
{
"name" : "hashed_phone_sha1"
},
{
"name" : "hashed_phone_sha256"
},
{
"name" : "hashed_phone_sha3"
}
],
"location" : {
"type" : "SNOWFLAKE",
"route" : {
"version" : NumberInt(0),
"createDate" : "2025-07-14T16:20:58.625Z",
"updateDate" : "2025-07-14T16:20:58.625Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "0",
"database" : {
"version" : NumberInt(0),
"createDate" : "2025-07-14T16:20:58.625Z",
"updateDate" : "2025-07-14T16:20:58.625Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "0",
"table" : "DATAMART_PROVIDER_KEYED_EXAMPLE",
"username" : "DATAMART_BD_USER",
"password" : "U2FsdGVkX1+gcmVlLXYMVnGYRtSVB07rz8Wl58xCG/1sHdzcWxiJv66sBbUJ2C1R",
"accountName" : "jymdzxq-bxb14362",
"schema" : "POC",
"warehouse" : "COMPUTE_WH_MED_DEMO",
"role" : "DATAMART_BD_ROLE",
"db" : "DATAMART",
"deleteSQLStatement" : "delete from DATAMART_PROVIDER_KEYED_EXAMPLE where file_id = {{file._id}};"
},
"protocol" : "SNOWFLAKE"
}
},
"encryption" : {
},
"autoMerge" : {
"enabled" : false,
"window" : NumberInt(10),
"windowTolerance" : NumberInt(0),
"minBatchSize" : NumberInt(1),
"clientOnly" : false,
"joinItems" : [
]
},
"escape" : "\\",
"flagDuplicates" : false,
"deduplicate" : false,
"filenameTemplate" : "{{file._id}}.csv",
"delimiter" : "|"
},
"audienceAcuityApiConfig" : {
"pii" : false
},
"description" : "DataMart Keying Convert",
"allowAutoConvertGeneration" : false,
"externalInjectedProcess" : {
"route" : {
"version" : NumberInt(0),
"createDate" : "2025-07-12T22:07:28.652Z",
"updateDate" : "2025-07-12T22:07:28.652Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "injectable"
}
},
"parseAddressComponents" : true,
"parseTokenizedNames" : true,
"standardizeAddress" : true,
"code" : {
"text" : "\nnew RuntimeOverride {\n\n override def setup(config: RuntimeConfiguration): Option[Any] = {\n // Perform any one-time setup logic here and return a global object if needed.\n // The returned value will be available in the subsequent setup steps.\n //\n // Available config parameters:\n // - config.client\n // - config.file\n // - config.convertType\n // - config.convertRun\n\n None\n }\n\n override def overrideCode(holder: Holder, setup: Option[Any]): Holder = {\n // Insert your custom override logic here.\n // This function allows you to modify the incoming `holder` as needed\n // before further processing.\n\n /*\n // Example: Replace state \"AX\" with \"AZ\", otherwise keep existing state.\n val state = if (holder.getFieldAs[String](\"state\").getOrElse(\"UU\") == \"AX\") {\n \"AZ\"\n } else {\n holder.getFieldAs[String](\"state\").getOrElse(\"UU\")\n }\n\n holder.upsertField(\"state\", Some(state))\n */\n\n // For more details and examples, refer to the documentation:\n // https://www.notion.so/phase3io/Convert-Code-Override-b3595988000641f7b036d75c3855e68a?pvs=4\n\n holder\n }\n}\n "
},
"codeFinal" : {
"text" : "\nnew RuntimeOverride {\n import com.google.i18n.phonenumbers.PhoneNumberUtil.PhoneNumberFormat\n import io.phase3.transform.model.{File, Holder}\n import io.phase3.transform.service.FieldUtilities.phoneUtil\n import io.phase3.transform.service.{RuntimeConfiguration}\n import org.joda.time.DateTime\n\n import java.nio.charset.StandardCharsets\n import java.security.MessageDigest\n \n override def setup(config: RuntimeConfiguration): Option[Any] = {\n Some(config)\n }\n\n /** Canonicalise the input email before hashing:\n * – trim leading/trailing spaces\n * – lowercase\n * – optionally normalise dots/plus‑labels for gmail, etc.\n */\n def createCanonicalEmail(email: String): String = {\n email.trim.toLowerCase\n }\n\n /** Canonicalise the input email before hashing:\n * – Parse\n * - Give formatted stirng if value\n * - Otherwise give empty string\n */\n def createCanonicalPhone(phone: String): String = {\n try {\n val proto = phoneUtil.parse(phone,\"US\")\n val formatted: String = if(phoneUtil.isValidNumber(proto)) {\n phoneUtil.format(proto, PhoneNumberFormat.E164).replaceFirst(\"^\\\\+1\", \"\")\n } else {\n phone\n }\n formatted\n } catch {\n case e: Throwable => phone\n }\n }\n\n /** Hash using any algorithm supported by `MessageDigest` (e.g. \"SHA-256\", \"SHA-1\", \"MD5\"). */\n def digest(input: String, algo: String): Array[Byte] = {\n val md = MessageDigest.getInstance(algo)\n md.update(input.getBytes(StandardCharsets.UTF_8))\n md.digest()\n }\n\n /** Convert raw hash bytes to an all‑lowercase hexadecimal string. */\n def toHex(bytes: Array[Byte]): String = {\n bytes.map(\"%02x\".format(_)).mkString\n }\n\n /** Public helpers ------------------------------------------------------- */\n\n /** MD5 HEM (legacy, weakest). */\n def md5String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"MD5\")))\n } else {\n None\n }\n }\n\n /** SHA‑1 HEM (legacy). */\n def sha1String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-1\")))\n } else {\n None\n }\n }\n\n /** SHA‑256 HEM (recommended). */\n def sha256String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-256\")))\n } else {\n None\n }\n }\n\n /** SHA‑256 HEM (recommended). */\n def sha3String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-3\")))\n } else {\n None\n }\n }\n\n override def overrideCode(holder: Holder, setup: Option[Any]): Holder = {\n val config: RuntimeConfiguration = setup.get.asInstanceOf[RuntimeConfiguration]\n val file: File = config.file.get\n val createDate: Option[DateTime] = file.createDate\n val cid: String = file.belongsTo\n\n // HEMS\n val emailRaw: String = holder.getFieldAs[String](\"email\").getOrElse(\"\")\n val canonicalEmail: String = createCanonicalEmail(emailRaw)\n val hem_md5: Option[String] = md5String(canonicalEmail)\n val hem_sha1: Option[String] = sha1String(canonicalEmail)\n val hem_sha256: Option[String] = sha256String(canonicalEmail)\n val hem_sha3: Option[String] = sha256String(canonicalEmail)\n\n // HASHED PHONES\n val phoneRaw: String = holder.getFieldAs[String](\"phone\").getOrElse(\"\")\n val canonicalPhone: String = createCanonicalEmail(phoneRaw.toString)\n val hashed_phone_md5: Option[String] = md5String(canonicalPhone)\n val hashed_phone_sha1: Option[String] = sha1String(canonicalPhone)\n val hashed_phone_sha256: Option[String] = sha256String(canonicalPhone)\n val hashed_phone_sha3: Option[String] = sha256String(canonicalPhone)\n\n holder.upsertField(\"client_id\", Some(cid))\n .upsertField(\"file_id\", Some(file._id))\n .upsertField(\"create_date\", createDate)\n .upsertField(\"hem_md5\", hem_md5)\n .upsertField(\"hem_sha1\", hem_sha1)\n .upsertField(\"hem_sha256\", hem_sha256)\n .upsertField(\"hem_sha3\", hem_sha3)\n .upsertField(\"hashed_phone_md5\", hashed_phone_md5)\n .upsertField(\"hashed_phone_sha1\", hashed_phone_sha1)\n .upsertField(\"hashed_phone_sha256\", hashed_phone_sha256)\n .upsertField(\"hashed_phone_sha3\", hashed_phone_sha3)\n }\n}\n",
"enabled" : true
},
"retainRawParsedInput" : true
}
{
"_id" : ObjectId("6872d9c21287a60017d7abdc"),
"version" : NumberInt(0),
"createDate" : "2025-07-12T21:55:14.150Z",
"updateDate" : "2025-07-12T21:55:14.150Z",
"addressStandardizationMode" : "CASS",
"name" : "datamart_customer",
"fields" : [
{
"name" : "aais",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "address01",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "address02",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "addressStandardization",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "adid",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "city",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "client_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "create_date",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "email",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "file_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "firstName",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_md5",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha1",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha256",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hashed_phone_sha3",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_md5",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha1",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha256",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "hem_sha3",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "idfa",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "lastName",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "maid",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_a",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_h",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "matchcode_i",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "originalRecord",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "phone",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "record_id",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "state",
"maxMissing" : NumberInt(3),
"profile" : false
},
{
"name" : "zipcode",
"maxMissing" : NumberInt(3),
"profile" : false
}
],
"output" : {
"format" : "TABLE",
"fields" : [
{
"name" : "file_id"
},
{
"name" : "client_id"
},
{
"name" : "create_date",
"format" : "yyyy-MM-dd"
},
{
"name" : "record_id"
},
{
"name" : "aais"
},
{
"name" : "adid"
},
{
"name" : "maid"
},
{
"name" : "idfa"
},
{
"name" : "matchcode_a",
"alias" : "bd_address_id"
},
{
"name" : "matchcode_h",
"alias" : "bd_household_id"
},
{
"name" : "matchcode_i",
"alias" : "bd_individual_id"
},
{
"name" : "hem_md5"
},
{
"name" : "hem_sha1"
},
{
"name" : "hem_sha256"
},
{
"name" : "hem_sha3"
},
{
"name" : "hashed_phone_md5"
},
{
"name" : "hashed_phone_sha1"
},
{
"name" : "hashed_phone_sha256"
},
{
"name" : "hashed_phone_sha3"
}
],
"location" : {
"type" : "SNOWFLAKE",
"route" : {
"version" : NumberInt(0),
"createDate" : "2025-07-14T16:17:44.673Z",
"updateDate" : "2025-07-14T16:17:44.673Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "0",
"database" : {
"version" : NumberInt(0),
"createDate" : "2025-07-14T16:17:44.673Z",
"updateDate" : "2025-07-14T16:17:44.673Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "0",
"table" : "DATAMART_CUSTOMER_KEYED_DATA",
"username" : "DATAMART_BD_USER",
"password" : "U2FsdGVkX1+o5opoyThw04kL1txzjNwMdX549P3oGG43RIaNSLSjwvhP8HeRRU3L",
"accountName" : "jymdzxq-bxb14362",
"db" : "DATAMART",
"schema" : "POC",
"warehouse" : "COMPUTE_WH_MED_DEMO",
"role" : "DATAMART_BD_ROLE",
"deleteSQLStatement" : "delete from DATAMART_CUSTOMER_KEYED_DATA where file_id = {{file._id}}"
},
"protocol" : "SNOWFLAKE"
}
},
"encryption" : {
},
"autoMerge" : {
"enabled" : false,
"window" : NumberInt(10),
"windowTolerance" : NumberInt(0),
"minBatchSize" : NumberInt(1),
"clientOnly" : false,
"joinItems" : [
]
},
"escape" : "\\",
"flagDuplicates" : true,
"deduplicate" : true,
"filenameTemplate" : "{{file._id}}.csv",
"delimiter" : "|"
},
"audienceAcuityApiConfig" : {
"pii" : false
},
"description" : "DataMart Keying Convert",
"allowAutoConvertGeneration" : false,
"externalInjectedProcess" : {
"route" : {
"version" : NumberInt(0),
"createDate" : "2025-07-12T22:07:28.652Z",
"updateDate" : "2025-07-12T22:07:28.652Z",
"reset" : true,
"postHeaders" : [
],
"belongsTo" : "injectable"
}
},
"parseAddressComponents" : true,
"parseTokenizedNames" : true,
"standardizeAddress" : true,
"code" : {
"text" : "\nnew RuntimeOverride {\n\n override def setup(config: RuntimeConfiguration): Option[Any] = {\n // Perform any one-time setup logic here and return a global object if needed.\n // The returned value will be available in the subsequent setup steps.\n //\n // Available config parameters:\n // - config.client\n // - config.file\n // - config.convertType\n // - config.convertRun\n\n None\n }\n\n override def overrideCode(holder: Holder, setup: Option[Any]): Holder = {\n // Insert your custom override logic here.\n // This function allows you to modify the incoming `holder` as needed\n // before further processing.\n\n /*\n // Example: Replace state \"AX\" with \"AZ\", otherwise keep existing state.\n val state = if (holder.getFieldAs[String](\"state\").getOrElse(\"UU\") == \"AX\") {\n \"AZ\"\n } else {\n holder.getFieldAs[String](\"state\").getOrElse(\"UU\")\n }\n\n holder.upsertField(\"state\", Some(state))\n */\n\n // For more details and examples, refer to the documentation:\n // https://www.notion.so/phase3io/Convert-Code-Override-b3595988000641f7b036d75c3855e68a?pvs=4\n\n holder\n }\n}\n "
},
"codeFinal" : {
"text" : "import io.phase3.transform.service.{RuntimeOverride}\n\n\nnew RuntimeOverride {\n import com.google.i18n.phonenumbers.PhoneNumberUtil.PhoneNumberFormat\n import io.phase3.transform.model.{File, Holder}\n import io.phase3.transform.service.FieldUtilities.phoneUtil\n import io.phase3.transform.service.{RuntimeConfiguration}\n import org.joda.time.DateTime\n\n import java.nio.charset.StandardCharsets\n import java.security.MessageDigest\n\n override def setup(config: RuntimeConfiguration): Option[Any] = {\n Some(config)\n }\n\n /** Canonicalise the input email before hashing:\n * – trim leading/trailing spaces\n * – lowercase\n * – optionally normalise dots/plus‑labels for gmail, etc.\n */\n def createCanonicalEmail(email: String): String = {\n email.trim.toLowerCase\n }\n\n /** Canonicalise the input email before hashing:\n * – Parse\n * - Give formatted stirng if value\n * - Otherwise give empty string\n */\n def createCanonicalPhone(phone: String): String = {\n try {\n val proto = phoneUtil.parse(phone,\"US\")\n val formatted: String = if(phoneUtil.isValidNumber(proto)) {\n phoneUtil.format(proto, PhoneNumberFormat.E164).replaceFirst(\"^\\\\+1\", \"\")\n } else {\n phone\n }\n formatted\n } catch {\n case e: Throwable => phone\n }\n }\n\n /** Hash using any algorithm supported by `MessageDigest` (e.g. \"SHA-256\", \"SHA-1\", \"MD5\"). */\n def digest(input: String, algo: String): Array[Byte] = {\n val md = MessageDigest.getInstance(algo)\n md.update(input.getBytes(StandardCharsets.UTF_8))\n md.digest()\n }\n\n /** Convert raw hash bytes to an all‑lowercase hexadecimal string. */\n def toHex(bytes: Array[Byte]): String = {\n bytes.map(\"%02x\".format(_)).mkString\n }\n\n /** Public helpers ------------------------------------------------------- */\n\n /** MD5 HEM (legacy, weakest). */\n def md5String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"MD5\")))\n } else {\n None\n }\n }\n\n /** SHA‑1 HEM (legacy). */\n def sha1String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-1\")))\n } else {\n None\n }\n }\n\n /** SHA‑256 HEM (recommended). */\n def sha256String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-256\")))\n } else {\n None\n }\n }\n\n /** SHA‑256 HEM (recommended). */\n def sha3String(stringValue: String): Option[String] = {\n if(!stringValue.isEmpty) {\n Some(toHex(digest(stringValue, \"SHA-3\")))\n } else {\n None\n }\n }\n\n override def overrideCode(holder: Holder, setup: Option[Any]): Holder = {\n val config: RuntimeConfiguration = setup.get.asInstanceOf[RuntimeConfiguration]\n val file: File = config.file.get\n val fileId: String = file._id\n val createDate: DateTime = file.createDate.getOrElse(DateTime.now())\n val lineNumber: String = holder.lineNumber.toString\n val cid: String = file.belongsTo\n val recordId: Option[String] = Some(fileId + \"^\" + lineNumber)\n\n // HEMS\n val emailRaw: String = holder.getFieldAs[String](\"email\").getOrElse(\"\")\n val canonicalEmail: String = createCanonicalEmail(emailRaw)\n val hem_md5: Option[String] = md5String(canonicalEmail)\n val hem_sha1: Option[String] = sha1String(canonicalEmail)\n val hem_sha256: Option[String] = sha256String(canonicalEmail)\n val hem_sha3: Option[String] = sha256String(canonicalEmail)\n\n // HASHED PHONES\n val phoneRaw: String = holder.getFieldAs[String](\"phone\").getOrElse(\"\")\n val canonicalPhone: String = createCanonicalEmail(phoneRaw.toString)\n val hashed_phone_md5: Option[String] = md5String(canonicalPhone)\n val hashed_phone_sha1: Option[String] = sha1String(canonicalPhone)\n val hashed_phone_sha256: Option[String] = sha256String(canonicalPhone)\n val hashed_phone_sha3: Option[String] = sha256String(canonicalPhone)\n\n holder.upsertField(\"client_id\", Some(cid))\n .upsertField(\"file_id\", Some(fileId))\n .upsertField(\"create_date\", Some(createDate))\n .upsertField(\"hem_md5\", hem_md5)\n .upsertField(\"hem_sha1\", hem_sha1)\n .upsertField(\"hem_sha256\", hem_sha256)\n .upsertField(\"hem_sha3\", hem_sha3)\n .upsertField(\"hashed_phone_md5\", hashed_phone_md5)\n .upsertField(\"hashed_phone_sha1\", hashed_phone_sha1)\n .upsertField(\"hashed_phone_sha256\", hashed_phone_sha256)\n .upsertField(\"hashed_phone_sha3\", hashed_phone_sha3)\n .upsertField(\"record_id\", recordId)\n\n }\n}\n",
"enabled" : true
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2d9"),
"name" : "DataMart PoC with DataRelation",
"description" : "DataMart PoC with DataRelation",
"table" : "BASE_POC_RECORDS",
"enabled" : true,
"queries" : {
"datamartJoinedCount" : {
"label" : "DataMart Joined Count",
"sqlQuery" : "with base_datamart_join as (\n SELECT prov.* \n FROM DATAMART_PROVIDER_KEYED_EXAMPLE prov\n JOIN DATAMART_CUSTOMER_KEYED_DATA cust ON (\n \t(\n \t prov.aais = cust.aais AND prov.aais IS NOT NULL AND LENGTH(prov.aais) > 0\n \t)\n \tOR\n \t(\n \t prov.adid = cust.adid AND prov.adid IS NOT NULL AND LENGTH(prov.adid) > 0\n \t)\n \tOR\n \t(\n \t prov.maid = cust.maid AND prov.maid IS NOT NULL AND LENGTH(prov.maid) > 0\n \t)\n \tOR\n \t(\n \t prov.idfa = cust.idfa AND prov.idfa IS NOT NULL AND LENGTH(prov.idfa) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_md5 = cust.hem_md5 AND prov.hem_md5 IS NOT NULL AND LENGTH(prov.hem_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha1 = cust.hem_sha1 AND prov.hem_sha1 IS NOT NULL AND LENGTH(prov.hem_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha256 = cust.hem_sha256 AND prov.hem_sha256 IS NOT NULL AND LENGTH(prov.hem_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha3 = cust.hem_sha3 AND prov.hem_sha3 IS NOT NULL AND LENGTH(prov.hem_sha3) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_md5 = cust.hashed_phone_md5 AND prov.hashed_phone_md5 IS NOT NULL AND LENGTH(prov.hashed_phone_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha1 = cust.hashed_phone_sha1 AND prov.hashed_phone_sha1 IS NOT NULL AND LENGTH(prov.hashed_phone_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha256 = cust.hashed_phone_sha256 AND prov.hashed_phone_sha256 IS NOT NULL AND LENGTH(prov.hashed_phone_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha3 = cust.hashed_phone_sha3 AND prov.hashed_phone_sha3 IS NOT NULL AND LENGTH(prov.hashed_phone_sha3) > 0\n \t)\n ) \n WHERE {{WHERE}}\n AND cust.file_id IN {{CLIENT_ID | LIST }}\n),\n\ndeduplicate_by_bds_individual_id as (\n select\n *,\n ROW_NUMBER() OVER (PARTITION BY bd_individual_id ORDER BY create_date DESC) AS row_num\n from base_datamart_join\n QUALIFY row_num = 1\n) \nSELECT STATE, COUNT(*) AS STATE_COUNT\nFROM deduplicate_by_bds_individual_id\nGROUP BY STATE \n",
"exportQuery" : false
},
"staticFieldsValidation" : {
"label" : "Static Field Validation",
"sqlQuery" : "with base_datamart_join as (\n SELECT prov.* \n FROM DATAMART_PROVIDER_KEYED_EXAMPLE prov\n JOIN DATAMART_CUSTOMER_KEYED_DATA cust ON (\n \t(\n \t prov.aais = cust.aais AND prov.aais IS NOT NULL AND LENGTH(prov.aais) > 0\n \t)\n \tOR\n \t(\n \t prov.adid = cust.adid AND prov.adid IS NOT NULL AND LENGTH(prov.adid) > 0\n \t)\n \tOR\n \t(\n \t prov.maid = cust.maid AND prov.maid IS NOT NULL AND LENGTH(prov.maid) > 0\n \t)\n \tOR\n \t(\n \t prov.idfa = cust.idfa AND prov.idfa IS NOT NULL AND LENGTH(prov.idfa) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_md5 = cust.hem_md5 AND prov.hem_md5 IS NOT NULL AND LENGTH(prov.hem_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha1 = cust.hem_sha1 AND prov.hem_sha1 IS NOT NULL AND LENGTH(prov.hem_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha256 = cust.hem_sha256 AND prov.hem_sha256 IS NOT NULL AND LENGTH(prov.hem_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha3 = cust.hem_sha3 AND prov.hem_sha3 IS NOT NULL AND LENGTH(prov.hem_sha3) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_md5 = cust.hashed_phone_md5 AND prov.hashed_phone_md5 IS NOT NULL AND LENGTH(prov.hashed_phone_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha1 = cust.hashed_phone_sha1 AND prov.hashed_phone_sha1 IS NOT NULL AND LENGTH(prov.hashed_phone_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha256 = cust.hashed_phone_sha256 AND prov.hashed_phone_sha256 IS NOT NULL AND LENGTH(prov.hashed_phone_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha3 = cust.hashed_phone_sha3 AND prov.hashed_phone_sha3 IS NOT NULL AND LENGTH(prov.hashed_phone_sha3) > 0\n \t)\n ) \n WHERE {{WHERE}}\n),\n\ndeduplicate_by_bds_individual_id as (\n select\n *,\n {{ORDER_NUMBER}} as order_number,\n {{DESCRIPTION}} as description,\n ROW_NUMBER() OVER (PARTITION BY bd_individual_id ORDER BY create_date DESC) AS row_num\n from base_datamart_join\n QUALIFY row_num = 1\n) \nSELECT STATE, \ndescription, order_number, \nCOUNT(*) AS STATE_COUNT\nFROM deduplicate_by_bds_individual_id\nGROUP BY STATE\n, description, order_number\n;\n",
"exportQuery" : false
},
"datamartExport" : {
"label" : "datamartExport",
"sqlQuery" : "with base_datamart_join as (\n SELECT \n prov.* \n exclude (aais, adid, maid, idfa, hem_md5, hem_sha1, hem_sha256, hem_sha3, hashed_phone_md5, hashed_phone_sha1,\n hashed_phone_sha256, hashed_phone_sha3, file_id, client_id, record_id, BD_ADDRESS_ID, BD_HOUSEHOLD_ID, BD_INDIVIDUAL_ID, create_date),\n prov.create_date as provider_create_date,\n prov.BD_INDIVIDUAL_ID as provider_BD_INDIVIDUAL_ID,\n cust.* \n exclude (aais, adid, maid, idfa, hem_md5, hem_sha1, hem_sha256, hem_sha3, hashed_phone_md5, hashed_phone_sha1,\n hashed_phone_sha256, hashed_phone_sha3, BD_INDIVIDUAL_ID, BD_ADDRESS_ID, BD_HOUSEHOLD_ID, CREATE_DATE, file_id)\n FROM DATAMART_PROVIDER_KEYED_EXAMPLE prov\n JOIN DATAMART_CUSTOMER_KEYED_DATA cust ON (\n \t(\n \t prov.aais = cust.aais AND prov.aais IS NOT NULL AND LENGTH(prov.aais) > 0\n \t)\n \tOR\n \t(\n \t prov.adid = cust.adid AND prov.adid IS NOT NULL AND LENGTH(prov.adid) > 0\n \t)\n \tOR\n \t(\n \t prov.maid = cust.maid AND prov.maid IS NOT NULL AND LENGTH(prov.maid) > 0\n \t)\n \tOR\n \t(\n \t prov.idfa = cust.idfa AND prov.idfa IS NOT NULL AND LENGTH(prov.idfa) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_md5 = cust.hem_md5 AND prov.hem_md5 IS NOT NULL AND LENGTH(prov.hem_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha1 = cust.hem_sha1 AND prov.hem_sha1 IS NOT NULL AND LENGTH(prov.hem_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha256 = cust.hem_sha256 AND prov.hem_sha256 IS NOT NULL AND LENGTH(prov.hem_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha3 = cust.hem_sha3 AND prov.hem_sha3 IS NOT NULL AND LENGTH(prov.hem_sha3) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_md5 = cust.hashed_phone_md5 AND prov.hashed_phone_md5 IS NOT NULL AND LENGTH(prov.hashed_phone_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha1 = cust.hashed_phone_sha1 AND prov.hashed_phone_sha1 IS NOT NULL AND LENGTH(prov.hashed_phone_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha256 = cust.hashed_phone_sha256 AND prov.hashed_phone_sha256 IS NOT NULL AND LENGTH(prov.hashed_phone_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha3 = cust.hashed_phone_sha3 AND prov.hashed_phone_sha3 IS NOT NULL AND LENGTH(prov.hashed_phone_sha3) > 0\n \t)\n ) \n WHERE {{WHERE}}\n AND cust.file_id IN {{CLIENT_ID | LIST }}\n),\n\ndeduplicate_by_bds_individual_id as (\n select\n *,\n ROW_NUMBER() OVER (PARTITION BY provider_BD_INDIVIDUAL_ID ORDER BY provider_create_date DESC) AS row_num\n from base_datamart_join\n QUALIFY row_num = 1\n)\n\nSELECT * exclude( row_num, provider_BD_INDIVIDUAL_ID, provider_create_date )\nFROM deduplicate_by_bds_individual_id\n;",
"exportQuery" : true
},
"overall" : {
"label" : "Overall",
"sqlQuery" : "with base_datamart_join as (\n SELECT prov.* \n FROM DATAMART_PROVIDER_KEYED_EXAMPLE prov\n JOIN DATAMART_CUSTOMER_KEYED_DATA cust ON (\n \t(\n \t prov.aais = cust.aais AND prov.aais IS NOT NULL AND LENGTH(prov.aais) > 0\n \t)\n \tOR\n \t(\n \t prov.adid = cust.adid AND prov.adid IS NOT NULL AND LENGTH(prov.adid) > 0\n \t)\n \tOR\n \t(\n \t prov.maid = cust.maid AND prov.maid IS NOT NULL AND LENGTH(prov.maid) > 0\n \t)\n \tOR\n \t(\n \t prov.idfa = cust.idfa AND prov.idfa IS NOT NULL AND LENGTH(prov.idfa) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_md5 = cust.hem_md5 AND prov.hem_md5 IS NOT NULL AND LENGTH(prov.hem_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha1 = cust.hem_sha1 AND prov.hem_sha1 IS NOT NULL AND LENGTH(prov.hem_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha256 = cust.hem_sha256 AND prov.hem_sha256 IS NOT NULL AND LENGTH(prov.hem_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hem_sha3 = cust.hem_sha3 AND prov.hem_sha3 IS NOT NULL AND LENGTH(prov.hem_sha3) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_md5 = cust.hashed_phone_md5 AND prov.hashed_phone_md5 IS NOT NULL AND LENGTH(prov.hashed_phone_md5) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha1 = cust.hashed_phone_sha1 AND prov.hashed_phone_sha1 IS NOT NULL AND LENGTH(prov.hashed_phone_sha1) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha256 = cust.hashed_phone_sha256 AND prov.hashed_phone_sha256 IS NOT NULL AND LENGTH(prov.hashed_phone_sha256) > 0\n \t)\n \tOR\n \t(\n \t prov.hashed_phone_sha3 = cust.hashed_phone_sha3 AND prov.hashed_phone_sha3 IS NOT NULL AND LENGTH(prov.hashed_phone_sha3) > 0\n \t)\n ) \n WHERE {{WHERE}}\n\n),\n\ndeduplicate_by_bds_individual_id as (\n select\n *,\n ROW_NUMBER() OVER (PARTITION BY bd_individual_id ORDER BY create_date DESC) AS row_num\n from base_datamart_join\n QUALIFY row_num = 1\n) \nSELECT count(*) count\nFROM deduplicate_by_bds_individual_id\n\n\n",
"exportQuery" : false
}
},
"updatedAt" : "2025-08-07T18:13:16.176Z"
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2da"),
"connectionParams" : {
"account" : "jymdzxq-bxb14362",
"username" : "DATAMART_BD_USER",
"database" : "DATAMART",
"password" : "U2FsdGVkX19wM6m8Yt8cNhdT1cE8ZUxarf3zbhBRoeU+OvubSf/HitngOi7+o1J1",
"schema" : "POC",
"warehouse" : "COMPUTE_WH_MED_DEMO",
"role" : "DATAMART_BD_ROLE"
},
"origin" : "SNOWFLAKE",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"valid" : true
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f5"),
"name" : "CLIENT_ID",
"label" : "Client ID",
"displayType" : "data-relation",
"isStaticField" : false,
"categories" : [
"default"
],
"whereTags" : [
],
"skipDefaultWhere" : false,
"validations" : {
"limit" : NumberInt(100),
"multi" : true,
"where" : {
"belongsTo" : "67bf6c6b4b004e0016a1d8e4",
"types.name" : "datamart_customer",
"status.loaded.done" : "true",
"status.purged.done" : "NULL"
}
},
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9"
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f4"),
"name" : "FIRST_IN_HOUSEHOLD",
"label" : "FIRST_IN_HOUSEHOLD",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f3"),
"name" : "CHILD_PRESENT",
"label" : "CHILD_PRESENT",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f2"),
"name" : "GENDER",
"label" : "GENDER",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f1"),
"name" : "MULTIPLE_FAMILY_DWELLING_UNIT",
"label" : "MULTIPLE_FAMILY_DWELLING_UNIT",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2f0"),
"name" : "MARITAL_STATUS",
"label" : "MARITAL_STATUS",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "B",
"label" : "B"
},
{
"value" : "A",
"label" : "A"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2ef"),
"name" : "NXI",
"label" : "NXI",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2ee"),
"name" : "HOMEOWNER_TYPE",
"label" : "HOMEOWNER_TYPE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2ed"),
"name" : "PROPERTY_TYPE",
"label" : "PROPERTY_TYPE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2ec"),
"name" : "DWELLING_TYPE",
"label" : "DWELLING_TYPE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "A",
"label" : "A"
},
{
"value" : "B",
"label" : "B"
},
{
"value" : "C",
"label" : "C"
},
{
"value" : "D",
"label" : "D"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2eb"),
"name" : "DELIVERY_POINT_CHECK_DIGIT",
"label" : "DELIVERY_POINT_CHECK_DIGIT",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "4",
"label" : "4"
},
{
"value" : "1",
"label" : "1"
},
{
"value" : "2",
"label" : "2"
},
{
"value" : "5",
"label" : "5"
},
{
"value" : "9",
"label" : "9"
},
{
"value" : "6",
"label" : "6"
},
{
"value" : "7",
"label" : "7"
},
{
"value" : "8",
"label" : "8"
},
{
"value" : "0",
"label" : "0"
},
{
"value" : "3",
"label" : "3"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2ea"),
"name" : "MEDIAN_YRS_IN_SCHOOL",
"label" : "MEDIAN_YRS_IN_SCHOOL",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "C",
"label" : "C"
},
{
"value" : "B",
"label" : "B"
},
{
"value" : "E",
"label" : "E"
},
{
"value" : "D",
"label" : "D"
},
{
"value" : "A",
"label" : "A"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e9"),
"name" : "DPV_FOOTNOTES",
"label" : "DPV_FOOTNOTES",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e8"),
"name" : "DPV_MATCH_CODE",
"label" : "DPV_MATCH_CODE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e7"),
"name" : "EST_AGE",
"label" : "EST_AGE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "D",
"label" : "D"
},
{
"value" : "F",
"label" : "F"
},
{
"value" : "C",
"label" : "C"
},
{
"value" : "E",
"label" : "E"
},
{
"value" : "G",
"label" : "G"
},
{
"value" : "B",
"label" : "B"
},
{
"value" : "A",
"label" : "A"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e6"),
"name" : "DPV_VACANT",
"label" : "DPV_VACANT",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e5"),
"name" : "MEDIAN_HOME_VALUE",
"label" : "MEDIAN_HOME_VALUE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "E",
"label" : "E"
},
{
"value" : "K",
"label" : "K"
},
{
"value" : "A",
"label" : "A"
},
{
"value" : "H",
"label" : "H"
},
{
"value" : "G",
"label" : "G"
},
{
"value" : "D",
"label" : "D"
},
{
"value" : "J",
"label" : "J"
},
{
"value" : "I",
"label" : "I"
},
{
"value" : "F",
"label" : "F"
},
{
"value" : "L",
"label" : "L"
},
{
"value" : "B",
"label" : "B"
},
{
"value" : "C",
"label" : "C"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e4"),
"name" : "EST_WEALTH",
"label" : "EST_WEALTH",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e3"),
"name" : "CONGRESSIONAL_DISTRICT",
"label" : "CONGRESSIONAL_DISTRICT",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e2"),
"name" : "EST_INCOME",
"label" : "EST_INCOME",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e1"),
"name" : "STATE",
"label" : "STATE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "MO",
"label" : "MO"
},
{
"value" : "ID",
"label" : "ID"
},
{
"value" : "TX",
"label" : "TX"
},
{
"value" : "AZ",
"label" : "AZ"
},
{
"value" : "IN",
"label" : "IN"
},
{
"value" : "MS",
"label" : "MS"
},
{
"value" : "CA",
"label" : "CA"
},
{
"value" : "OR",
"label" : "OR"
},
{
"value" : "OK",
"label" : "OK"
},
{
"value" : "GA",
"label" : "GA"
},
{
"value" : "ND",
"label" : "ND"
},
{
"value" : "OH",
"label" : "OH"
},
{
"value" : "NM",
"label" : "NM"
},
{
"value" : "DE",
"label" : "DE"
},
{
"value" : "SC",
"label" : "SC"
},
{
"value" : "TN",
"label" : "TN"
},
{
"value" : "NJ",
"label" : "NJ"
},
{
"value" : "MA",
"label" : "MA"
},
{
"value" : "SD",
"label" : "SD"
},
{
"value" : "NY",
"label" : "NY"
},
{
"value" : "WI",
"label" : "WI"
},
{
"value" : "MT",
"label" : "MT"
},
{
"value" : "KY",
"label" : "KY"
},
{
"value" : "NH",
"label" : "NH"
},
{
"value" : "VA",
"label" : "VA"
},
{
"value" : "NE",
"label" : "NE"
},
{
"value" : "IL",
"label" : "IL"
},
{
"value" : "CO",
"label" : "CO"
},
{
"value" : "LA",
"label" : "LA"
},
{
"value" : "ME",
"label" : "ME"
},
{
"value" : "RI",
"label" : "RI"
},
{
"value" : "WA",
"label" : "WA"
},
{
"value" : "MN",
"label" : "MN"
},
{
"value" : "MI",
"label" : "MI"
},
{
"value" : "FL",
"label" : "FL"
},
{
"value" : "NC",
"label" : "NC"
},
{
"value" : "UT",
"label" : "UT"
},
{
"value" : "IA",
"label" : "IA"
},
{
"value" : "KS",
"label" : "KS"
},
{
"value" : "VT",
"label" : "VT"
},
{
"value" : "MD",
"label" : "MD"
},
{
"value" : "PA",
"label" : "PA"
},
{
"value" : "CT",
"label" : "CT"
}
]
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2e0"),
"name" : "STATE_ABBREVIATION",
"label" : "STATE_ABBREVIATION",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2df"),
"name" : "CITY",
"label" : "CITY",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2de"),
"name" : "DOB",
"label" : "DOB",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2dd"),
"name" : "PLUS4_CODE",
"label" : "PLUS4_CODE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2dc"),
"name" : "ZIPCODE",
"label" : "ZIPCODE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "contains",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
}
}
{
"_id" : ObjectId("6876e6ee4bca5c0017c7e2db"),
"name" : "EXACT_AGE",
"label" : "EXACT_AGE",
"categories" : [
"default"
],
"whereTags" : [
],
"displayType" : "selection-multi",
"dataSourceId" : "6876e6ee4bca5c0017c7e2d9",
"isStaticField" : false,
"skipDefaultWhere" : false,
"validations" : {
"values" : [
{
"value" : "G",
"label" : "G"
},
{
"value" : "K",
"label" : "K"
},
{
"value" : "Z",
"label" : "Z"
},
{
"value" : "#",
"label" : "#"
},
{
"value" : "@",
"label" : "@"
},
{
"value" : "A",
"label" : "A"
},
{
"value" : "P",
"label" : "P"
},
{
"value" : "T",
"label" : "T"
},
{
"value" : "2",
"label" : "2"
},
{
"value" : "6",
"label" : "6"
},
{
"value" : ">",
"label" : ">"
},
{
"value" : "N",
"label" : "N"
},
{
"value" : "H",
"label" : "H"
},
{
"value" : "%",
"label" : "%"
},
{
"value" : "M",
"label" : "M"
},
{
"value" : "E",
"label" : "E"
},
{
"value" : "W",
"label" : "W"
},
{
"value" : "5",
"label" : "5"
},
{
"value" : "I",
"label" : "I"
},
{
"value" : "F",
"label" : "F"
},
{
"value" : "O",
"label" : "O"
},
{
"value" : "R",
"label" : "R"
},
{
"value" : "3",
"label" : "3"
},
{
"value" : "Y",
"label" : "Y"
},
{
"value" : "Q",
"label" : "Q"
},
{
"value" : "1",
"label" : "1"
},
{
"value" : "S",
"label" : "S"
},
{
"value" : "V",
"label" : "V"
},
{
"value" : "L",
"label" : "L"
},
{
"value" : "C",
"label" : "C"
},
{
"value" : "9",
"label" : "9"
},
{
"value" : "J",
"label" : "J"
},
{
"value" : "D",
"label" : "D"
},
{
"value" : "X",
"label" : "X"
},
{
"value" : "?",
"label" : "?"
},
{
"value" : "B",
"label" : "B"
},
{
"value" : "U",
"label" : "U"
},
{
"value" : ")",
"label" : ")"
},
{
"value" : "4",
"label" : "4"
}
]
}
}