<?xml version="1.0" encoding="utf-8" ?>
<!--<sqlMap namespace="CLIP.e-Form.Consent.Dfh" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >-->
<sqlMap namespace="CLIP.e-Form.Consent.Knuh" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  <alias>
    <typeAlias type="CLIP.eForm.Consent.Entity.CategoryForDropdownVO, CLIP.e-Form.Consent.Entity" alias="CategoryForDropdownVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ConsentBySearchVO, CLIP.e-Form.Consent.Entity" alias="ConsentBySearchVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ConsentFormListVO, CLIP.e-Form.Consent.Entity" alias="ConsentFormListVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ConsentVO, CLIP.e-Form.Consent.Entity" alias="ConsentVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ConsentImageVO, CLIP.e-Form.Consent.Entity" alias="ConsentImageVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.ImageServerPropsVO, CLIP.e-Form.Consent.Entity" alias="ImageServerPropsVO"/>
    <typeAlias type="CLIP.eForm.Consent.Entity.AgmtVo, CLIP.e-Form.Consent.Entity" alias="AgmtVo"/>

    <typeAlias type="CLIP.eForm.Server.VO.Code, CLIP.e-Form.Server.VO" alias="Code"/>
    <typeAlias type="CLIP.eForm.Server.VO.PageList, CLIP.e-Form.Server.VO" alias="PageList"/>
    <typeAlias type="CLIP.eForm.Server.VO.EFormData, CLIP.e-Form.Server.VO" alias="EFormData"/>
    <typeAlias type="CLIP.eForm.Server.VO.DocumentCustomField, CLIP.e-Form.Server.VO" alias="DocumentCustomField"/>
    <typeAlias type="CLIP.eForm.Server.VO.DocumentOutputField, CLIP.e-Form.Server.VO" alias="DocumentOutputField"/>
  </alias>

  <resultMaps>

    <resultMap id="CategoryForDropdownMap" class="CategoryForDropdownVO">
      <result property="CategoryType" column="CATEGORY_TYPE" />
      <result property="CategoryId" column="CATEGORY_ID" />
      <result property="CategoryName" column="CATEGORY_NAME" />
    </resultMap>

    <resultMap id="ConsentImageMap" class="ConsentImageVO">
      <result property="ConsentMstRid" column="CONSENT_MST_RID" />
      <result property="ConsentImageRid" column="CONSENT_IMAGE_RID" />
      <result property="FormRid" column="FORM_RID" />
      <result property="ImagePath" column="IMAGE_PATH" />
      <result property="ImageFilename" column="IMAGE_FILENAME" />
      <result property="CompleteYn" column="COMPLETE_YN" />
      <result property="CreateUserId" column="CREATE_USER_ID" />
      <result property="CreateDatetime" column="CREATE_DATETIME" />
    </resultMap>
    
    <resultMap id="ConsentMap" class="ConsentVO">
      <result property="ConsentMstRid" column="CONSENT_MST_RID" />
      <result property="ConsentStateDisp" column="CONSENT_STATE_DISP" />      
      <result property="ConsentName" column="CONSENT_NAME" />
      <result property="HosType" column="HOS_TYPE" />
      <result property="PatientCode" column="PID" />
      <result property="PatientName" column="HNGNM" />
      <result property="VisitType" column="VISIT_TYPE" />
      <result property="VisitTypeName" column="VISIT_TYPE_NM" />
      <result property="OrderNo" column="ORDER_NO" />
      <result property="OrderCd" column="ORDER_CD" />
      <result property="OrderNm" column="ORDER_NAME" />
      <result property="ClnDeptCd" column="CLN_DEPT_CD" />
      <result property="ClnDeptNm" column="CLN_DEPT_NM" />
      <result property="Ward" column="WARDCD" />
      <result property="RoomCd" column="ROOMCD" />
      <result property="FormRid" column="FORM_RID" />
      <result property="FormCd" column="FORM_CD" />
      <result property="FormGuid" column="FORM_GUID" />
      <result property="PrntCnt" column="PRNTCNT" />
      <result property="OcrNumber" column="OCR_NUMBER" />
      <result property="ConsentState" column="CONSENT_STATE" />
      <result property="CosignDcId" column="COSIGN_DC_ID" />
      <result property="CosignDcName" column="COSIGN_DC_NAME" />
      <result property="CreateUserId" column="CREATE_USER_ID" />
      <result property="CreateUserName" column="CREATE_USER_NAME" />
      <result property="CreateDateTime" column="CREATE_DATETIME" />
      <result property="ClnDate" column="CLN_DATE" />
      <result property="Cretno" column="CRETNO" />
      <result property="OcrTagYN" column="OCRTAGPRNTYN"/>
      <result property="FormPrintName" column="formprntnm"/>
      <result property="UserDrFlag" column="userdrflag"/>
      <result property="PrntOnly" column="print_only"/>
      <result property="OpDiagName" column="opdiagnm"/>
      <result property="OpName" column="opnm"/>
      <result property="OpRsrvNo" column="oprsrvno"/>
    </resultMap>

    <resultMap id="ConsentBySearchMap" class="ConsentBySearchVO">
      <result property="FormCd" column="FORM_CD" />
      <result property="FormGuid" column="FORM_GUID" />
      <result property="FormName" column="FORM_NAME" />
      <result property="FullCategoryName" column="FULL_CATEGORY_NAME" />
      <result property="FormRid" column="FORM_RID" />
      <result property="PrntCnt" column="PRNTCNT"/>
      <result property="PrntOnly" column="PRINT_ONLY"/>
      <result property="OcrTagYN" column="OCRTAGPRNTYN"/>
      <result property="FormPrintName" column="formprntnm"/>
      <result property="OpDiagName" column="opdiagnm"/>
      <result property="OpName" column="opnm"/>
      <result property="UserDrFlag" column="userdrflag"/>
      <result property="LinkFormCd" column="lnkformcd"/>
    </resultMap>

    <resultMap id="ConsentFormMap" class="ConsentFormListVO">
      <result property="consentMstRid"    column="CONSENT_MST_RID" />
      <result property="createUserId"     column="CREATE_USER_ID"       nullValue="" />
      <result property="createUserName"   column="CREATE_USER_NAME"     nullValue="" />
      <result property="modifyUserId"     column="MODIFY_USER_ID"       nullValue="" />
      <result property="modifyUserName"   column="MODIFY_USER_NAME"     nullValue="" />
      <result property="createDatetime"   column="CREATE_DATETIME"      nullValue="" />
      <result property="ocrTag"           column="OCR_TAG"              nullValue="" />
      <result property="pid"              column="PID"                  nullValue="" />
      <result property="inDd"             column="INDD"                 nullValue="" />
      <result property="ordType"          column="ORD_TYPE"             nullValue="" />
      <result property="ordDeptCd"        column="ORD_DEPT_CD"          nullValue="" />
      <result property="cretNo"           column="CRET_NO"                           />
      <result property="opRsrvNo"         column="OPRSRVNO"             nullValue="" />
      <result property="patientName"      column="PATIENT_NAME"         nullValue="" />
      <result property="consentState"     column="CONSENT_STATE"        nullValue="" />
      <result property="consentStateEng"  column="CONSENT_STATE_ENG" nullValue="" />
      <result property="formCd"           column="FORM_CD"              nullValue="" />
      <result property="formGuid"         column="FORM_GUID"            nullValue="" />
      <result property="formName"         column="FORM_NAME"            nullValue="" />
      <result property="formRid"          column="FORM_RID"                          />
      <result property="printOnly"        column="PRNT_ONLY"            nullValue="" />
      <result property="printCnt"         column="PRINT_CNT"                         />
      <result property="ocrTagPrntYn"     column="OCR_TAG_PRNT_YN"      nullValue="" />
      <result property="formPrntNm"       column="FORM_PRNT_NM"         nullValue="" />
      <result property="certUseYn"        column="CERT_USE_YN"          nullValue="" />
      <result property="opDiagNm"         column="OP_DIAG_NM"           nullValue="" />
      <result property="opNm"             column="OP_NM"                nullValue="" />
      <result property="userDrFlag"       column="USERDRFLAG"           nullValue="" />
      <result property="linkFormCd"       column="LNKFORMCD"            nullValue="" />
      <result property="jinjeongCd"       column="JINJEONGCD"           nullValue="" />
      <result property="DrOnly"           column="DRONLY"               nullValue="" />
    </resultMap>

    <resultMap id="ImageServerPropsMap" class="ImageServerPropsVO">
      <result property="ipaddr" column="IPADDRESS"/>
      <result property="localpath" column="LOCALPATH"/>
      <result property="active" column="ACTIVE"/>
      <result property="username" column="CIFSUSER"/>
      <result property="userpasswd" column="CIFSPASS"/>
    </resultMap>

    <resultMap id="AgmtVoMap" class="AgmtVo">
      <result property="consentMstRid"    column="CONSENT_MST_RID"                 />
      <result property="cretno"           column="CRETNO"                        />
      <result property="formRid"          column="FORMRID"                       />
      <result property="instcd"           column="INSTCD"           nullValue="" />
      <result property="pid"              column="PID"              nullValue="" />
      <result property="ordtype"          column="ORDTYPE"          nullValue="" />
      <result property="deptcd"           column="DEPTCD"           nullValue="" />
      <result property="wardcd"           column="WARDCD"           nullValue="" />
      <result property="roomCd"           column="ROOMCD"           nullValue="" />
      <result property="ocrtag"           column="OCRTAG"           nullValue="" />
      <result property="createUserId"     column="CREATEUSERID"     nullValue="" />
      <result property="createDateTime"   column="CREATEDATETIME"   nullValue="" />
      <result property="CreateUserName"   column="CREATEUSERNAME"   nullValue="" />
      <result property="clnDate"          column="CLNDATE"          nullValue="" />
      <result property="formCd"           column="FORMCD"           nullValue="" />
      <result property="orddrid"          column="ORDDRID"          nullValue="" />
      
    </resultMap>
  </resultMaps>
</sqlMap>