初始化单位

初始化单位 GetInitSynHisCompanyList

select
  a.RWID00 as hisCompanyCode,
    b.TTqC00||'('||a.RWID00||')' as hisCompanyName,
  b.YYBH00 as hishospitalcode,
  a.TTID00 as groupId,
  a.RWYDRQ as examStart,
  a.YDZZRQ as examEnd,
  sysdate as insertTime,
  1 as operateType,
 1 as busiType,
 0 as upload
from HM_YW_TTRW00 a inner join HM_YW_TJTT00 b on a.TTID00=b.TTID00