<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Aurora Generator  
    $Date: Mon Aug 13 15:25:25 CST 2018  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false" xmlns:f="leaf.database.features" alias="t1" baseTable="ds_user_info_ad_v">
    <bm:fields>
        <bm:field name="userid" databaseType="VARCHAR2" forDisplay="true" forQuery="true" datatype="java.lang.String" physicalName="USERID" prompt="员工号"/>
        <bm:field name="name_zh" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="NAME_ZH" prompt="员工姓名"/>
        <bm:field name="mail" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="MAIL" prompt="EMAIL"/>
        <bm:field name="orgunitid" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ORGUNITID" prompt="AD_MASTER_USER_V.ORGUNITID"/>
        <bm:field name="employeeid" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEEID" prompt="AD_MASTER_USER_V.EMPLOYEEID"/>
        <bm:field name="firstemployeeid" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRSTEMPLOYEEID" prompt="AD_MASTER_USER_V.FIRSTEMPLOYEEID"/>
        <bm:field name="workpersonnelareacode" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORKPERSONNELAREACODE" prompt="AD_MASTER_USER_V.WORKPERSONNELAREACODE"/>
        <bm:field name="originpersonnelareacode" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ORIGINPERSONNELAREACODE" prompt="AD_MASTER_USER_V.ORIGINPERSONNELAREACODE"/>
        <bm:field name="mobilenumber" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="MOBILENUMBER" prompt="手机号"/>
        <bm:field name="employeestatus" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEESTATUS" prompt="AD_MASTER_USER_V.EMPLOYEESTATUS"/>
        <bm:field name="source_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_TYPE" prompt="AD_MASTER_USER_V.SOURCE_TYPE"/>
    </bm:fields>
    <bm:features>
        <f:standard-who xmlns:f="leaf.database.features"/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field name ="userid" queryExpression="t1.userid like  &apos;%&apos; || ${@userid} || &apos;%&apos; "/>
        <bm:query-field name ="name_zh" queryExpression="t1.name_zh like  &apos;%&apos; || ${@name_zh} || &apos;%&apos; "/>
        <bm:query-field name ="mail" queryExpression="t1.mail like  &apos;%&apos; || ${@mail} || &apos;%&apos; "/>
        <bm:query-field name ="mobilenumber" queryExpression="t1.mobilenumber like  &apos;%&apos; || ${@mobilenumber} || &apos;%&apos; "/>
        <bm:query-field name ="source_type" queryExpression="t1.source_type = ${@source_type}"/>
    </bm:query-fields>
</bm:model>