<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2015-5-19 下午04:20:04  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="PRJ_MEETING_ASSIGN_WFL" needAccessControl="false">
    <bm:fields>
        <bm:field name="prj_mt_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRJ_MT_ID" prompt="PRJ_MEETING_ASSIGN_WFL.PRJ_MT_ID"/>
        <bm:field name="instance_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INSTANCE_ID" prompt="PRJ_MEETING_ASSIGN_WFL.INSTANCE_ID"/>
        <bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID" prompt="PRJ_MEETING_ASSIGN_WFL.EMPLOYEE_ID"/>
        <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" prompt="PRJ_MEETING_ASSIGN_WFL.PROJECT_ID"/>
        <bm:field name="approval_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPROVAL_TYPE" prompt="PRJ_MEETING_ASSIGN_WFL.APPROVAL_TYPE"/>
        <bm:field name="employee_code" expression="(select employee_code from exp_employees ee where ee.employee_id=t1.employee_id)" forDisplay="true" forQuery="true"/>
        <bm:field name="employee_name" expression="(select name from exp_employees ee where ee.employee_id=t1.employee_id)" forDisplay="true" forQuery="true"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="prj_mt_id"/>
    </bm:primary-key>
    <bm:data-filters>
        <bm:data-filter name="query" expression="t1.instance_id = ${@instance_id} and t1.approval_type=${@approval_type}"/>
    </bm:data-filters>
</bm:model>
