<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HN_INTERMEDIARY_HIRED_REQ_LV">
    <bm:fields>
        <bm:field name="hired_req_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HIRED_REQ_ID" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_REQ_ID"/>
        <bm:field name="hired_req_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HIRED_REQ_NUMBER" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_REQ_NUMBER"/>
        <bm:field name="hired_req_date" databaseType="DATE" datatype="java.util.Date" physicalName="HIRED_REQ_DATE" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_REQ_DATE"/>
        <bm:field name="hired_req_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HIRED_REQ_STATUS" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_REQ_STATUS"/>
        <bm:field name="hired_req_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HIRED_REQ_STATUS_N" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_REQ_STATUS_N"/>
        <bm:field name="owner_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OWNER_USER_ID" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.OWNER_USER_ID"/>
        <bm:field name="owner_user_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNER_USER_ID_N" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.OWNER_USER_ID_N"/>
        <bm:field name="unit_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNIT_NAME" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.UNIT_NAME"/>
        <bm:field name="owner_user_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNER_USER_PHONE" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.OWNER_USER_PHONE"/>
        <bm:field name="hired_necessity" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HIRED_NECESSITY" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.HIRED_NECESSITY"/>
        <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.BP_ID"/>
        <bm:field name="bp_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_N" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.BP_ID_N"/>
        <bm:field name="intermediary_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTERMEDIARY_TYPE" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.INTERMEDIARY_TYPE"/>
        <bm:field name="intermediary_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTERMEDIARY_TYPE_N" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.INTERMEDIARY_TYPE_N"/>
        <bm:field name="bp_branch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_BRANCH_ID" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.BP_BRANCH_ID"/>
        <bm:field name="bp_branch_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_BRANCH_ID_N" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.BP_BRANCH_ID_N"/>
        <bm:field name="bp_branch_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_BRANCH_PHONE" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.BP_BRANCH_PHONE"/>
        <bm:field name="service_matters" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERVICE_MATTERS" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.SERVICE_MATTERS"/>
        <bm:field name="job_content" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="JOB_CONTENT" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.JOB_CONTENT"/>
        <bm:field name="service_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SERVICE_AMOUNT" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.SERVICE_AMOUNT"/>
        <bm:field name="vat_service_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VAT_SERVICE_AMOUNT" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.VAT_SERVICE_AMOUNT"/>
        <bm:field name="amount_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AMOUNT_DESCRIPTION" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.AMOUNT_DESCRIPTION"/>
        <bm:field name="work_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PERIOD" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.WORK_PERIOD"/>
        <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.DESCRIPTION"/>
        <bm:field name="wfl_instance_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="WFL_INSTANCE_ID" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.WFL_INSTANCE_ID"/>
        <bm:field name="close_reason" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLOSE_REASON" prompt="HN_INTERMEDIARY_HIRED_REQ_LV.CLOSE_REASON"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field name="hired_req_id" queryExpression="t1.hired_req_id=${@hired_req_id}"/>
    </bm:query-fields>
</bm:model>
