<?xml version="1.0" encoding="UTF-8"?>
<spine xmlns="http://memeroot.io/spine/v1" version="1">
  <metadata>
    <composed-at>2026-05-23T09:23:50Z</composed-at>
    <composed-by>compose-unit.sh</composed-by>
  </metadata>
<table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_CATEGORY" datatype="VARCHAR2(50)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_CATEGORY" datatype="VARCHAR2(50)" id="1" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="OBJECT_TYPE" datatype="VARCHAR2(50)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="OBJECT_TYPE" datatype="VARCHAR2(50)" id="2" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_NAME" datatype="VARCHAR2(100)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_NAME" datatype="VARCHAR2(100)" id="3" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_SEQUENCE" datatype="NUMBER"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_SEQUENCE" datatype="NUMBER" id="4" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" id="5" nullable="N"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="IS_LOOP" datatype="VARCHAR2(1)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="IS_LOOP" datatype="VARCHAR2(1)" id="6" nullable="Y" default="'N'"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="LOOP_DELIMITER" datatype="VARCHAR2(20)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="LOOP_DELIMITER" datatype="VARCHAR2(20)" id="7" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="INDENT_LEVEL" datatype="NUMBER"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="INDENT_LEVEL" datatype="NUMBER" id="8" nullable="Y" default="0"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_MBI" name="MBI_SCRIPT" attribute="CONDITION_TOKEN" datatype="VARCHAR2(100)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="CONDITION_TOKEN" datatype="VARCHAR2(100)" id="9" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_MBI" prefix="MBI"/>
  <ext>
    <field name="block-id">ts-MBI_SCRIPT</field>
  </ext>
</table-spec>
<table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="SOURCE_OWNER" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="SOURCE_OWNER" datatype="VARCHAR2(128)" id="1" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="SOURCE_NAME" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="SOURCE_NAME" datatype="VARCHAR2(128)" id="2" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="SOURCE_ATTRIBUTE" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="SOURCE_ATTRIBUTE" datatype="VARCHAR2(128)" id="3" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="SOURCE_DATATYPE" datatype="VARCHAR2(200)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="SOURCE_DATATYPE" datatype="VARCHAR2(200)" id="4" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_OWNER" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_OWNER" datatype="VARCHAR2(128)" id="5" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_NAME" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_NAME" datatype="VARCHAR2(128)" id="6" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_PREFIX" datatype="VARCHAR2(20)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_PREFIX" datatype="VARCHAR2(20)" id="7" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_ATTRIBUTE" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_ATTRIBUTE" datatype="VARCHAR2(128)" id="8" nullable="N"/>
  <index type="pk"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_FUNCTION" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_FUNCTION" datatype="VARCHAR2(4000)" id="9" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_ID" datatype="NUMBER"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_ID" datatype="NUMBER" id="10" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="INDEX_TYPE" datatype="VARCHAR2(10)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="INDEX_TYPE" datatype="VARCHAR2(10)" id="11" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_NULL" datatype="VARCHAR2(1)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_NULL" datatype="VARCHAR2(1)" id="12" nullable="Y" default="'Y'"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_DATATYPE" datatype="VARCHAR2(200)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_DATATYPE" datatype="VARCHAR2(200)" id="13" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="TARGET_DEFAULT" datatype="VARCHAR2(200)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="TARGET_DEFAULT" datatype="VARCHAR2(200)" id="14" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="AGGREGATE" datatype="VARCHAR2(50)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="AGGREGATE" datatype="VARCHAR2(50)" id="15" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="FILTER_FLAG" datatype="VARCHAR2(1)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="FILTER_FLAG" datatype="VARCHAR2(1)" id="16" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="CONDITION" datatype="VARCHAR2(200)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="CONDITION" datatype="VARCHAR2(200)" id="17" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="JOIN_CONDITION" datatype="VARCHAR2(400)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="JOIN_CONDITION" datatype="VARCHAR2(400)" id="18" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="VIEW_OWNER" datatype="VARCHAR2(128)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="VIEW_OWNER" datatype="VARCHAR2(128)" id="19" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="VIEW_FILTER" datatype="VARCHAR2(400)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="VIEW_FILTER" datatype="VARCHAR2(400)" id="20" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="schema-block">
  <source owner="OWNER_META" name="TABLE_SPECIFICATIONS" attribute="VIEW_PREFIX" datatype="VARCHAR2(20)"/>
  <target owner="OWNER_META" name="TABLE_SPECIFICATIONS" prefix="TS" attribute="VIEW_PREFIX" datatype="VARCHAR2(20)" id="21" nullable="Y"/>
  <constraint filter-flag="i"/>
  <view owner="OWNER_META" prefix="TS"/>
  <ext>
    <field name="block-id">ts-TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec>
<table-spec spec-source="script-block">
  <source owner="HC" name="sc-exe_var_deletefolder" attribute="exe_var_deletefolder.BODY" datatype="ksh"/>
  <target owner="EDW_CLC" name="exe_var_deletefolder" attribute="SCRIPT_BODY" datatype="ksh" id="0">
    <function>#!/usr/bin/ksh
if [ -d "$1" ]; then
  print "Deleting folder: $1"
  rm -rf "$1"
  print "COMPLETED"
else
  print "Folder does not exist: $1"
  exit 1
fi
</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="EDW_CLC"/>
  <ext>
    <field name="block-id">sc-exe_var_deletefolder</field>
    <field name="script-language">ksh</field>
    <field name="script-runtime">POSIX shell</field>
    <field name="script-author">Robert Anderson</field>
    <field name="script-created"/>
  </ext>
</table-spec><table-spec spec-source="script-block">
  <source owner="HC" name="sc-exe_var_deletefolder" attribute="parameter.1" datatype="path"/>
  <target owner="EDW_CLC" name="exe_var_deletefolder" attribute="INPUT.folder_path" datatype="path" id="1" nullable="N"/>
  <constraint filter-flag="i"/>
  <view owner="EDW_CLC"/>
  <ext>
    <field name="block-id">sc-exe_var_deletefolder</field>
    <field name="parameter-position">1</field>
    <field name="parameter-allowed"/>
  </ext>
</table-spec>
<table-spec spec-source="script-block">
  <source owner="HC" name="sc-pmexecutequery" attribute="pmexecutequery.BODY" datatype="ksh"/>
  <target owner="EDW_CLC" name="pmexecutequery" attribute="SCRIPT_BODY" datatype="ksh" id="0">
    <function>#!/usr/bin/ksh
print "query name =          "$1
print "Process type   =      "$2
print "\n==============================================================================="
print " Start Informatica query ($1):  $(date +"%d-%b-%Y %H:%M:%S")"
print "=================================================================================\n"
print "\nEXECUTING COMMAND =&gt;    pmrep connect -r RS_SNI_DV2 -d $INFA_DEFAULT_DOMAIN -n $PM_USERNAME -x $PM_PASSWORD "
pmrep connect -r RS_SNI_DV2 -d $INFA_DEFAULT_DOMAIN -n $PM_USERNAME -x $PM_PASSWORD
print "\nEXECUTING COMMAND =&gt;    pmrep executequery -q $1 -t Shared -u $1_output.txt "
pmrep executequery -q $1 -t Shared -u $1_output.txt
if [ $2 = "validate" ]
then
print "\nEXECUTING COMMAND =&gt;    pmrep validate -i $1_output.txt -s -k -m Validated"
pmrep validate -i $1_output.txt -s -k -m Validated
fi
print "\nCOMPLETED"
</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="EDW_CLC"/>
  <ext>
    <field name="block-id">sc-pmexecutequery</field>
    <field name="script-language">ksh</field>
    <field name="script-runtime">POSIX shell + Informatica pmrep CLI</field>
    <field name="script-author">Robert Anderson</field>
    <field name="script-created">2017-05-11</field>
  </ext>
</table-spec><table-spec spec-source="script-block">
  <source owner="HC" name="sc-pmexecutequery" attribute="parameter.1" datatype="string"/>
  <target owner="EDW_CLC" name="pmexecutequery" attribute="INPUT.query_name" datatype="string" id="1" nullable="N"/>
  <constraint filter-flag="i"/>
  <view owner="EDW_CLC"/>
  <ext>
    <field name="block-id">sc-pmexecutequery</field>
    <field name="parameter-position">1</field>
    <field name="parameter-allowed"/>
  </ext>
</table-spec><table-spec spec-source="script-block">
  <source owner="HC" name="sc-pmexecutequery" attribute="parameter.2" datatype="enum"/>
  <target owner="EDW_CLC" name="pmexecutequery" attribute="INPUT.process_type" datatype="enum" id="2" nullable="N"/>
  <constraint filter-flag="i"/>
  <view owner="EDW_CLC"/>
  <ext>
    <field name="block-id">sc-pmexecutequery</field>
    <field name="parameter-position">2</field>
    <field name="parameter-allowed">validate</field>
  </ext>
</table-spec>
<table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.TABLE.CREATE_TABLE.0010" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0010">
    <function>CREATE TABLE &lt;&lt;TARGET_OWNER&gt;&gt;.&lt;&lt;TARGET_NAME&gt;&gt; (</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="OWNER_MBI" prefix="TABL" filter="OBJECT_TYPE = 'TABLE' AND SCRIPT_NAME = 'CREATE_TABLE'"/>
  <ext>
    <field name="block-id">tp-CREATE_TABLE</field>
    <field name="category">DDL</field>
    <field name="object-type">TABLE</field>
    <field name="script-name">CREATE_TABLE</field>
    <field name="sequence">0010</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">0</field>
    <field name="condition-token"/>
  </ext>
</table-spec><table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.TABLE.CREATE_TABLE.0020" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0020">
    <function>&lt;&lt;COLUMN_NAME&gt;&gt; &lt;&lt;COLUMN_DATATYPE&gt;&gt;&lt;&lt;NULL_CLAUSE&gt;&gt;</function>
  </target>
  <constraint filter-flag="L"/>
  <view owner="OWNER_MBI" prefix="TABL" filter="OBJECT_TYPE = 'TABLE' AND SCRIPT_NAME = 'CREATE_TABLE'"/>
  <ext>
    <field name="block-id">tp-CREATE_TABLE</field>
    <field name="category">DDL</field>
    <field name="object-type">TABLE</field>
    <field name="script-name">CREATE_TABLE</field>
    <field name="sequence">0020</field>
    <field name="is-loop">Y</field>
    <field name="loop-delimiter">,
</field>
    <field name="indent-level">2</field>
    <field name="condition-token"/>
  </ext>
</table-spec><table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.TABLE.CREATE_TABLE.0030" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0030">
    <function>,CONSTRAINT pk_&lt;&lt;TARGET_NAME&gt;&gt; PRIMARY KEY (&lt;&lt;PRIMARY_KEY_COLS&gt;&gt;)</function>
  </target>
  <constraint filter-flag="S" condition="&lt;&lt;HAS_PRIMARY_KEY&gt;&gt;"/>
  <view owner="OWNER_MBI" prefix="TABL" filter="OBJECT_TYPE = 'TABLE' AND SCRIPT_NAME = 'CREATE_TABLE'"/>
  <ext>
    <field name="block-id">tp-CREATE_TABLE</field>
    <field name="category">DDL</field>
    <field name="object-type">TABLE</field>
    <field name="script-name">CREATE_TABLE</field>
    <field name="sequence">0030</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">2</field>
    <field name="condition-token">&lt;&lt;HAS_PRIMARY_KEY&gt;&gt;</field>
  </ext>
</table-spec><table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.TABLE.CREATE_TABLE.0040" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0040">
    <function>);</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="OWNER_MBI" prefix="TABL" filter="OBJECT_TYPE = 'TABLE' AND SCRIPT_NAME = 'CREATE_TABLE'"/>
  <ext>
    <field name="block-id">tp-CREATE_TABLE</field>
    <field name="category">DDL</field>
    <field name="object-type">TABLE</field>
    <field name="script-name">CREATE_TABLE</field>
    <field name="sequence">0040</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">0</field>
    <field name="condition-token"/>
  </ext>
</table-spec>
<table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.VIEW.GEN_LPV_TRANS_FEAT.0010" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0010">
    <function>create or replace view EDW_CLC_LDR.&lt;&lt;TARGET_VIEW_NAME&gt;&gt; as select</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="OWNER_MBI" prefix="VIEW" filter="OBJECT_TYPE = 'VIEW' AND SCRIPT_NAME = 'GEN_LPV_TRANS_FEAT'"/>
  <ext>
    <field name="block-id">tp-GEN_LPV_TRANS_FEAT</field>
    <field name="category">DDL</field>
    <field name="object-type">VIEW</field>
    <field name="script-name">GEN_LPV_TRANS_FEAT</field>
    <field name="sequence">0010</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">0</field>
    <field name="condition-token"/>
  </ext>
</table-spec><table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.VIEW.GEN_LPV_TRANS_FEAT.0020" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0020">
    <function>&lt;&lt;TARGET_KEY&gt;&gt; &lt;&lt;ATTRIBUTES&gt;&gt;</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="OWNER_MBI" prefix="VIEW" filter="OBJECT_TYPE = 'VIEW' AND SCRIPT_NAME = 'GEN_LPV_TRANS_FEAT'"/>
  <ext>
    <field name="block-id">tp-GEN_LPV_TRANS_FEAT</field>
    <field name="category">DDL</field>
    <field name="object-type">VIEW</field>
    <field name="script-name">GEN_LPV_TRANS_FEAT</field>
    <field name="sequence">0020</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">2</field>
    <field name="condition-token"/>
  </ext>
</table-spec><table-spec spec-source="template-block">
  <source owner="HC" name="MBI_SCRIPT" attribute="DDL.VIEW.GEN_LPV_TRANS_FEAT.0030" datatype="VARCHAR2(4000)"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" prefix="MBI" attribute="SCRIPT_TEXT" datatype="VARCHAR2(4000)" nullable="Y" id="0030">
    <function>from &lt;&lt;OWNER_NAME&gt;&gt;.&lt;&lt;SOURCE_VIEW_NAME&gt;&gt;;</function>
  </target>
  <constraint filter-flag="S"/>
  <view owner="OWNER_MBI" prefix="VIEW" filter="OBJECT_TYPE = 'VIEW' AND SCRIPT_NAME = 'GEN_LPV_TRANS_FEAT'"/>
  <ext>
    <field name="block-id">tp-GEN_LPV_TRANS_FEAT</field>
    <field name="category">DDL</field>
    <field name="object-type">VIEW</field>
    <field name="script-name">GEN_LPV_TRANS_FEAT</field>
    <field name="sequence">0030</field>
    <field name="is-loop">N</field>
    <field name="loop-delimiter"/>
    <field name="indent-level">0</field>
    <field name="condition-token"/>
  </ext>
</table-spec>
<table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.SCRIPT_CATEGORY" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_CATEGORY" id="1">
    <function>DDL</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.OBJECT_TYPE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="OBJECT_TYPE" id="1">
    <function>TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.SCRIPT_NAME" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_NAME" id="1">
    <function>CREATE_TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.SCRIPT_SEQUENCE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_SEQUENCE" id="1">
    <function>10</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.SCRIPT_TEXT" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_TEXT" id="1">
    <function>CREATE TABLE &lt;&lt;TARGET_OWNER&gt;&gt;.&lt;&lt;TARGET_NAME&gt;&gt; (</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.IS_LOOP" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="IS_LOOP" id="1">
    <function>N</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.1.INDENT_LEVEL" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="INDENT_LEVEL" id="1">
    <function>0</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">1</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.SCRIPT_CATEGORY" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_CATEGORY" id="2">
    <function>DDL</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.OBJECT_TYPE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="OBJECT_TYPE" id="2">
    <function>TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.SCRIPT_NAME" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_NAME" id="2">
    <function>CREATE_TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.SCRIPT_SEQUENCE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_SEQUENCE" id="2">
    <function>20</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.SCRIPT_TEXT" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_TEXT" id="2">
    <function>&lt;&lt;COLUMN_NAME&gt;&gt; &lt;&lt;COLUMN_DATATYPE&gt;&gt;&lt;&lt;NULL_CLAUSE&gt;&gt;</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.IS_LOOP" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="IS_LOOP" id="2">
    <function>Y</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.LOOP_DELIMITER" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="LOOP_DELIMITER" id="2">
    <function>,
</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.2.INDENT_LEVEL" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="INDENT_LEVEL" id="2">
    <function>2</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">2</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.SCRIPT_CATEGORY" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_CATEGORY" id="3">
    <function>DDL</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.OBJECT_TYPE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="OBJECT_TYPE" id="3">
    <function>TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.SCRIPT_NAME" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_NAME" id="3">
    <function>CREATE_TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.SCRIPT_SEQUENCE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_SEQUENCE" id="3">
    <function>30</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.SCRIPT_TEXT" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_TEXT" id="3">
    <function>,CONSTRAINT pk_&lt;&lt;TARGET_NAME&gt;&gt; PRIMARY KEY (&lt;&lt;PRIMARY_KEY_COLS&gt;&gt;)</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.IS_LOOP" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="IS_LOOP" id="3">
    <function>N</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.INDENT_LEVEL" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="INDENT_LEVEL" id="3">
    <function>2</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.3.CONDITION_TOKEN" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="CONDITION_TOKEN" id="3">
    <function>&lt;&lt;HAS_PRIMARY_KEY&gt;&gt;</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">3</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.SCRIPT_CATEGORY" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_CATEGORY" id="4">
    <function>DDL</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.OBJECT_TYPE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="OBJECT_TYPE" id="4">
    <function>TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.SCRIPT_NAME" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_NAME" id="4">
    <function>CREATE_TABLE</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.SCRIPT_SEQUENCE" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_SEQUENCE" id="4">
    <function>40</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.SCRIPT_TEXT" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="SCRIPT_TEXT" id="4">
    <function>);</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.IS_LOOP" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="IS_LOOP" id="4">
    <function>N</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="data-block">
  <source owner="HC" name="dt-MBI_SCRIPT-rows-CREATE_TABLE" attribute="row.4.INDENT_LEVEL" datatype="value"/>
  <target owner="OWNER_MBI" name="MBI_SCRIPT" attribute="INDENT_LEVEL" id="4">
    <function>0</function>
  </target>
  <constraint filter-flag="d"/>
  <view owner="OWNER_MBI"/>
  <ext>
    <field name="block-id">dt-MBI_SCRIPT-rows-CREATE_TABLE</field>
    <field name="data-row-id">4</field>
    <field name="schema-ref">OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT</field>
  </ext>
</table-spec>
<table-spec spec-source="process-block">
  <source owner="HC" name="pr-bounded-dispatch" attribute="step.1.invokes" datatype="address"/>
  <target owner="OWNER_MEMEROOT" name="BOUNDED_DISPATCH" attribute="STEP.read-metadata" id="1">
    <function>schema-block@OWNER_META.TABLE_SPECIFICATIONS</function>
  </target>
  <constraint filter-flag="p"/>
  <view owner="OWNER_MEMEROOT"/>
  <ext>
    <field name="block-id">pr-bounded-dispatch</field>
    <field name="step-seq">1</field>
    <field name="step-name">read-metadata</field>
    <field name="invokes-kind">schema-block</field>
    <field name="invokes-address">OWNER_META.TABLE_SPECIFICATIONS</field>
  </ext>
</table-spec><table-spec spec-source="process-block">
  <source owner="HC" name="pr-bounded-dispatch" attribute="step.1.invokes" datatype="address"/>
  <target owner="OWNER_MEMEROOT" name="BOUNDED_DISPATCH" attribute="STEP.read-metadata" id="1">
    <function>schema-block@OWNER_MBI.MBI_SCRIPT</function>
  </target>
  <constraint filter-flag="p"/>
  <view owner="OWNER_MEMEROOT"/>
  <ext>
    <field name="block-id">pr-bounded-dispatch</field>
    <field name="step-seq">1</field>
    <field name="step-name">read-metadata</field>
    <field name="invokes-kind">schema-block</field>
    <field name="invokes-address">OWNER_MBI.MBI_SCRIPT</field>
  </ext>
</table-spec><table-spec spec-source="process-block">
  <source owner="HC" name="pr-bounded-dispatch" attribute="step.2.invokes" datatype="address"/>
  <target owner="OWNER_MEMEROOT" name="BOUNDED_DISPATCH" attribute="STEP.generate-artifact" id="2">
    <function>template-block@OWNER_MBI.CREATE_TABLE</function>
  </target>
  <constraint filter-flag="p"/>
  <view owner="OWNER_MEMEROOT"/>
  <ext>
    <field name="block-id">pr-bounded-dispatch</field>
    <field name="step-seq">2</field>
    <field name="step-name">generate-artifact</field>
    <field name="invokes-kind">template-block</field>
    <field name="invokes-address">OWNER_MBI.CREATE_TABLE</field>
  </ext>
</table-spec><table-spec spec-source="process-block">
  <source owner="HC" name="pr-bounded-dispatch" attribute="step.3.invokes" datatype="address"/>
  <target owner="OWNER_MEMEROOT" name="BOUNDED_DISPATCH" attribute="STEP.dispatch-bounded" id="3">
    <function>script-block@EDW_CLC.pmexecutequery</function>
  </target>
  <constraint filter-flag="p"/>
  <view owner="OWNER_MEMEROOT"/>
  <ext>
    <field name="block-id">pr-bounded-dispatch</field>
    <field name="step-seq">3</field>
    <field name="step-name">dispatch-bounded</field>
    <field name="invokes-kind">script-block</field>
    <field name="invokes-address">EDW_CLC.pmexecutequery</field>
  </ext>
</table-spec><table-spec spec-source="process-block">
  <source owner="HC" name="pr-bounded-dispatch" attribute="step.4.invokes" datatype="address"/>
  <target owner="OWNER_MEMEROOT" name="BOUNDED_DISPATCH" attribute="STEP.audit-emit" id="4">
    <function>script-block@OWNER_AUDIT.append-blockchain-table</function>
  </target>
  <constraint filter-flag="p"/>
  <view owner="OWNER_MEMEROOT"/>
  <ext>
    <field name="block-id">pr-bounded-dispatch</field>
    <field name="step-seq">4</field>
    <field name="step-name">audit-emit</field>
    <field name="invokes-kind">script-block</field>
    <field name="invokes-address">OWNER_AUDIT.append-blockchain-table</field>
  </ext>
</table-spec>
</spine>
