<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Leaf Generator
    $Date: Mon Sep 17 09:54:35 CST 2018  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:e="leaf.service.exception" xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features" alias="t1" baseTable="SYS_USER" needAccessControl="false">
    <bm:fields>
        <bm:field name="user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="USER_ID" prompt="SYS_USER.USER_ID"/>
        <bm:field name="user_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_NAME" prompt="SYS_USER.USER_NAME"/>
        <bm:field name="encrypted_foundation_password" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENCRYPTED_FOUNDATION_PASSWORD" prompt="SYS_USER.ENCRYPTED_FOUNDATION_PASSWORD"/>
        <bm:field name="encrypted_user_password" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENCRYPTED_USER_PASSWORD" prompt="SYS_USER.ENCRYPTED_USER_PASSWORD"/>
        <bm:field name="start_date" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE" prompt="SYS_USER.START_DATE"/>
        <bm:field name="end_date" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE" prompt="SYS_USER.END_DATE"/>
        <bm:field name="last_logon_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_LOGON_DATE" prompt="SYS_USER.LAST_LOGON_DATE"/>
        <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="SYS_USER.DESCRIPTION"/>
        <bm:field name="password_lifespan_days" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PASSWORD_LIFESPAN_DAYS" prompt="SYS_USER.PASSWORD_LIFESPAN_DAYS"/>
        <bm:field name="password_lifespan_access" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PASSWORD_LIFESPAN_ACCESS" prompt="SYS_USER.PASSWORD_LIFESPAN_ACCESS"/>
        <bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID" prompt="SYS_USER.EMPLOYEE_ID"/>
        <bm:field name="customer_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CUSTOMER_ID" prompt="SYS_USER.CUSTOMER_ID"/>
        <bm:field name="vender_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VENDER_ID" prompt="SYS_USER.VENDER_ID"/>
        <bm:field name="frozen_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FROZEN_FLAG" prompt="SYS_USER.FROZEN_FLAG"/>
        <bm:field name="frozen_date" databaseType="DATE" datatype="java.util.Date" physicalName="FROZEN_DATE" prompt="SYS_USER.FROZEN_DATE"/>
        <bm:field name="password_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="PASSWORD_START_DATE" prompt="SYS_USER.PASSWORD_START_DATE"/>
        <bm:field name="menu_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MENU_TYPE" prompt="SYS_USER.MENU_TYPE"/>
        <!--<bm:field name="last_update_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_UPDATE_DATE" prompt="SYS_USER.LAST_UPDATE_DATE"/>-->
        <!--<bm:field name="last_updated_by" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAST_UPDATED_BY" prompt="SYS_USER.LAST_UPDATED_BY"/>-->
        <!--<bm:field name="creation_date" databaseType="DATE" datatype="java.util.Date" physicalName="CREATION_DATE" prompt="SYS_USER.CREATION_DATE"/>-->
        <!--<bm:field name="created_by" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREATED_BY" prompt="SYS_USER.CREATED_BY"/>-->
        <bm:field name="bp_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CATEGORY" prompt="SYS_USER.BP_CATEGORY"/>
        <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="SYS_USER.BP_ID"/>
        <bm:field name="phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE" prompt="SYS_USER.PHONE"/>
        <bm:field name="admin_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADMIN_FLAG" prompt="SYS_USER.ADMIN_FLAG"/>
        <bm:field name="last_login_date" databaseType="TIMESTAMP(6)" datatype="java.lang.String" physicalName="LAST_LOGIN_DATE" prompt="SYS_USER.LAST_LOGIN_DATE"/>
        <bm:field name="last_password_update_date" databaseType="TIMESTAMP(6)" datatype="java.lang.String" physicalName="LAST_PASSWORD_UPDATE_DATE" prompt="SYS_USER.LAST_PASSWORD_UPDATE_DATE"/>
        <bm:field name="first_login" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_LOGIN" prompt="SYS_USER.FIRST_LOGIN"/>
        <bm:field name="supplier_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SUPPLIER_ID" prompt="SYS_USER.SUPPLIER_ID"/>
        <bm:field name="status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STATUS" prompt="SYS_USER.STATUS"/>
        <bm:field name="end_active_date" databaseType="DATE" datatype="java.util.Date" physicalName="END_ACTIVE_DATE" prompt="SYS_USER.END_ACTIVE_DATE"/>
        <bm:field name="tm_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TM_FLAG" prompt="SYS_USER.TM_FLAG"/>
        <bm:field name="user_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_TYPE" prompt="SYS_USER.USER_TYPE"/>
        <bm:field name="password_encrypted" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PASSWORD_ENCRYPTED" prompt="SYS_USER.PASSWORD_ENCRYPTED"/>
        <bm:field name="email" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMAIL" prompt="SYS_USER.EMAIL"/>
        <bm:field name="attribute1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE1" prompt="SYS_USER.ATTRIBUTE1"/>
        <bm:field name="attribute2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE2" prompt="SYS_USER.ATTRIBUTE2"/>
        <bm:field name="attribute3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE3" prompt="SYS_USER.ATTRIBUTE3"/>
        <bm:field name="attribute4" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE4" prompt="SYS_USER.ATTRIBUTE4"/>
        <bm:field name="attribute5" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE5" prompt="SYS_USER.ATTRIBUTE5"/>
        <bm:field name="attribute6" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE6" prompt="SYS_USER.ATTRIBUTE6"/>
        <bm:field name="attribute7" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE7" prompt="SYS_USER.ATTRIBUTE7"/>
        <bm:field name="attribute8" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE8" prompt="SYS_USER.ATTRIBUTE8"/>
        <bm:field name="attribute9" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE9" prompt="SYS_USER.ATTRIBUTE9"/>
        <bm:field name="attribute10" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE10" prompt="SYS_USER.ATTRIBUTE10"/>
        <bm:field name="attribute11" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE11" prompt="SYS_USER.ATTRIBUTE11"/>
        <bm:field name="attribute12" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE12" prompt="SYS_USER.ATTRIBUTE12"/>
        <bm:field name="attribute13" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE13" prompt="SYS_USER.ATTRIBUTE13"/>
        <bm:field name="attribute14" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE14" prompt="SYS_USER.ATTRIBUTE14"/>
        <bm:field name="attribute15" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE15" prompt="SYS_USER.ATTRIBUTE15"/>
        <bm:field name="start_active_date" databaseType="DATE" datatype="java.util.Date" physicalName="START_ACTIVE_DATE" prompt="SYS_USER.START_ACTIVE_DATE"/>
        <bm:field name="attribute_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTRIBUTE_CATEGORY" prompt="SYS_USER.ATTRIBUTE_CATEGORY"/>
        <!--<bm:field name="last_update_login" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAST_UPDATE_LOGIN" prompt="SYS_USER.LAST_UPDATE_LOGIN"/>-->
        <bm:field name="program_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROGRAM_ID" prompt="SYS_USER.PROGRAM_ID"/>
        <bm:field name="request_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REQUEST_ID" prompt="SYS_USER.REQUEST_ID"/>
    </bm:fields>
    <bm:features>
        <f:standard-who xmlns:f="leaf.database.features"/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field field="user_name" queryOperator="like"/>
        <bm:query-field field="description" queryOperator="like"/>
        <bm:query-field name="user_ids" queryExpression="t1.user_id in (${:@user_ids})"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter name="t1.Frozen_Flag" expression="t1.Frozen_Flag = 'N'"/>
    </bm:data-filters>
</bm:model>