<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<WorkflowProcess Version="12.1.0.2.1" DBVersion="12.1.0.2.0" xmlns="http://xmlns.oracle.com/odmr11">
    <Nodes>
        <DataSource Id="10003" Name="INSUR_CUST_LTV_SAMPLE APPLY" Status="Complete">
            <Icon XCOORD="135" YCOORD="248"></Icon>
            <Messages/>
            <CacheSettings UseFullData="false" GenerateCache="false">
                <NumberOfRows>2000</NumberOfRows>
                <Method>
                    <TopN/>
                </Method>
            </CacheSettings>
            <SQLExpression>"N$10003" as (select "INSUR_CUST_LTV_SAMPLE"."MARITAL_STATUS", 
"INSUR_CUST_LTV_SAMPLE"."STATE", 
"INSUR_CUST_LTV_SAMPLE"."CREDIT_BALANCE", 
"INSUR_CUST_LTV_SAMPLE"."TIME_AS_CUSTOMER", 
"INSUR_CUST_LTV_SAMPLE"."CUSTOMER_ID", 
"INSUR_CUST_LTV_SAMPLE"."MORTGAGE_AMOUNT", 
"INSUR_CUST_LTV_SAMPLE"."BANK_FUNDS", 
"INSUR_CUST_LTV_SAMPLE"."N_OF_DEPENDENTS", 
"INSUR_CUST_LTV_SAMPLE"."HAS_CHILDREN", 
"INSUR_CUST_LTV_SAMPLE"."SALARY", 
"INSUR_CUST_LTV_SAMPLE"."SEX", 
"INSUR_CUST_LTV_SAMPLE"."PROFESSION", 
"INSUR_CUST_LTV_SAMPLE"."CREDIT_CARD_LIMITS", 
"INSUR_CUST_LTV_SAMPLE"."REGION", 
"INSUR_CUST_LTV_SAMPLE"."HOUSE_OWNERSHIP", 
"INSUR_CUST_LTV_SAMPLE"."N_TRANS_WEB_BANK", 
"INSUR_CUST_LTV_SAMPLE"."BUY_INSURANCE", 
"INSUR_CUST_LTV_SAMPLE"."MONTHLY_CHECKS_WRITTEN", 
"INSUR_CUST_LTV_SAMPLE"."N_TRANS_KIOSK", 
"INSUR_CUST_LTV_SAMPLE"."AGE", 
"INSUR_CUST_LTV_SAMPLE"."MONEY_MONTLY_OVERDRAWN", 
"INSUR_CUST_LTV_SAMPLE"."LTV", 
"INSUR_CUST_LTV_SAMPLE"."T_AMOUNT_AUTOM_PAYMENTS", 
"INSUR_CUST_LTV_SAMPLE"."N_TRANS_TELLER", 
"INSUR_CUST_LTV_SAMPLE"."CHECKING_AMOUNT", 
"INSUR_CUST_LTV_SAMPLE"."N_TRANS_ATM", 
"INSUR_CUST_LTV_SAMPLE"."LTV_BIN", 
"INSUR_CUST_LTV_SAMPLE"."LAST", 
"INSUR_CUST_LTV_SAMPLE"."N_MORTGAGES", 
"INSUR_CUST_LTV_SAMPLE"."CAR_OWNERSHIP", 
"INSUR_CUST_LTV_SAMPLE"."FIRST" 
from "DMUSER"."INSUR_CUST_LTV_SAMPLE"  )</SQLExpression>
            <Attributes>
                <Attribute Name="MARITAL_STATUS" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="STATE" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="CREDIT_BALANCE" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="TIME_AS_CUSTOMER" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="CUSTOMER_ID" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="MORTGAGE_AMOUNT" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="BANK_FUNDS" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="N_OF_DEPENDENTS" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="HAS_CHILDREN" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="SALARY" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="SEX" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="PROFESSION" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="CREDIT_CARD_LIMITS" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="REGION" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="HOUSE_OWNERSHIP" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="N_TRANS_WEB_BANK" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="BUY_INSURANCE" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="MONTHLY_CHECKS_WRITTEN" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="N_TRANS_KIOSK" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="AGE" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="MONEY_MONTLY_OVERDRAWN" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="LTV" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="T_AMOUNT_AUTOM_PAYMENTS" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="N_TRANS_TELLER" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="CHECKING_AMOUNT" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="N_TRANS_ATM" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="LTV_BIN" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="LAST" DataType="VARCHAR2" Status="Valid"/>
                <Attribute Name="N_MORTGAGES" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="CAR_OWNERSHIP" DataType="NUMBER" Status="Valid"/>
                <Attribute Name="FIRST" DataType="VARCHAR2" Status="Valid"/>
            </Attributes>
            <SourceTable Schema="" Name="INSUR_CUST_LTV_SAMPLE"/>
        </DataSource>
        <CreateTable TableName="SCORED_CUSTOMERS_TBL" Table="true" Id="10004" Name="SCORED_CUSTOMERS" Status="Complete">
            <Icon XCOORD="502" YCOORD="247"></Icon>
            <Messages/>
            <CacheSettings UseFullData="false" GenerateCache="false">
                <NumberOfRows>2000</NumberOfRows>
                <Method>
                    <TopN/>
                </Method>
            </CacheSettings>
            <SQLExpression>"N$10004" AS ( SELECT  "CLAS_SVM_MODEL_PRED" ,
 "CLAS_SVM_MODEL_PROB" ,
 "CUSTOMER_ID"  FROM "SCORED_CUSTOMERS_TBL")</SQLExpression>
            <DBAttributes>
                <DBAttribute Key="No" Index="No" Name="CLAS_SVM_MODEL_PRED" DataType="VARCHAR2" Status="Valid"/>
                <DBAttribute Key="No" Index="No" Name="CLAS_SVM_MODEL_PROB" DataType="BINARY_DOUBLE" Status="Valid"/>
                <DBAttribute Key="No" Index="No" Name="CUSTOMER_ID" DataType="VARCHAR2" Status="Valid"/>
            </DBAttributes>
        </CreateTable>
        <Model Id="10006" Name="Model" Status="Complete">
            <Icon XCOORD="330" YCOORD="131"></Icon>
            <Messages/>
            <Parallelism Enable="false">
                <SystemDetermined/>
            </Parallelism>
            <MiningFunction>CLASSIFICATION</MiningFunction>
            <Models>
                <Model Schema="" Name="CLAS_SVM_MODEL_2" MiningFunction="CLASSIFICATION" MiningAlgorithm="SUPPORT_VECTOR_MACHINES" Status="Valid" UseForOutput="true" ModelId="10009">
                    <ModelSettingsODM>
                        <ModelSettingODM Name="ALGO_NAME" Value="ALGO_SUPPORT_VECTOR_MACHINES" Type="INPUT"/>
                        <ModelSettingODM Name="SVMS_CONV_TOLERANCE" Value="0.001" Type="INPUT"/>
                        <ModelSettingODM Name="CLAS_WEIGHTS_TABLE_NAME" Value="ODMR$18_40_48_139282TWHQCEV" Type="INPUT"/>
                        <ModelSettingODM Name="SVMS_ACTIVE_LEARNING" Value="SVMS_AL_ENABLE" Type="INPUT"/>
                        <ModelSettingODM Name="SVMS_KERNEL_FUNCTION" Value="SVMS_LINEAR" Type="INPUT"/>
                        <ModelSettingODM Name="SVMS_COMPLEXITY_FACTOR" Value="0.218007" Type="DEFAULT"/>
                        <ModelSettingODM Name="PREP_AUTO" Value="ON" Type="INPUT"/>
                    </ModelSettingsODM>
                </Model>
            </Models>
            <TargetAttribute Name="BUY_INSURANCE" DataType="VARCHAR2" Status="Valid"/>
            <TargetValues>
                <TargetValueString>Yes</TargetValueString>
                <TargetValueString>No</TargetValueString>
            </TargetValues>
        </Model>
        <Apply ColumnOutputOrder="SupplementalColumns" Id="10005" Name="Apply" Status="Complete">
            <Icon XCOORD="330" YCOORD="248"></Icon>
            <Messages/>
            <CacheSettings UseFullData="false" GenerateCache="false">
                <NumberOfRows>2000</NumberOfRows>
                <Method>
                    <TopN/>
                </Method>
            </CacheSettings>
            <SQLExpression>"N$10005" as (SELECT 
"CUSTOMER_ID", 
PREDICTION(  "DMUSER"."CLAS_SVM_MODEL_2" USING *) "CLAS_SVM_MODEL_PRED", 
PREDICTION_PROBABILITY("DMUSER"."CLAS_SVM_MODEL_2" USING *) "CLAS_SVM_MODEL_PROB"
FROM {INPUT_SOURCE} )</SQLExpression>
            <SupplementalAttributes AutoSpec="No">
                <Attribute Name="CUSTOMER_ID" DataType="VARCHAR2" Status="Valid"/>
            </SupplementalAttributes>
            <OutputColumns AutoSpec="Yes">
                <OutputColumn>
                    <Model IsModelBuilt="true" NodeId="10006" Schema="" Name="CLAS_SVM_MODEL_2" MiningFunction="CLASSIFICATION" MiningAlgorithm="SUPPORT_VECTOR_MACHINES" Status="Valid" UseForOutput="true" ModelId="10009"/>
                    <Prediction>
                        <CostOption>
                            <None/>
                        </CostOption>
                        <Column Name="CLAS_SVM_MODEL_PRED"/>
                    </Prediction>
                </OutputColumn>
                <OutputColumn>
                    <Model IsModelBuilt="true" NodeId="10006" Schema="" Name="CLAS_SVM_MODEL_2" MiningFunction="CLASSIFICATION" MiningAlgorithm="SUPPORT_VECTOR_MACHINES" Status="Valid" UseForOutput="true" ModelId="10009"/>
                    <PredictionProbability>
                        <Column Name="CLAS_SVM_MODEL_PROB"/>
                    </PredictionProbability>
                </OutputColumn>
            </OutputColumns>
        </Apply>
    </Nodes>
    <Links>
        <Link Id="10001" From="10003" To="10005" Name="Link" Label="From &quot;INSUR_CUST_LTV_SAMPLE APPLY&quot; to &quot;Apply&quot;">
            <ConnectorGraphicsInfo>
                <Coordinates XCoordinate="0.0" YCoordinate="0.0"/>
            </ConnectorGraphicsInfo>
        </Link>
        <Link Id="10002" From="10005" To="10004" Name="Link" Label="From &quot;Apply&quot; to &quot;SCORED_CUSTOMERS&quot;">
            <ConnectorGraphicsInfo>
                <Coordinates XCoordinate="0.0" YCoordinate="0.0"/>
            </ConnectorGraphicsInfo>
        </Link>
        <Link Id="10008" From="10006" To="10005" Name="Link" Label="From &quot;Model&quot; to &quot;Apply&quot;">
            <ConnectorGraphicsInfo>
                <Coordinates XCoordinate="0.0" YCoordinate="0.0"/>
            </ConnectorGraphicsInfo>
        </Link>
    </Links>
</WorkflowProcess>
