?? sds.sql
字號:
'出院床位';
comment on column SDS.BY08CRYDJ.CYJBR is
'出院經辦人';
comment on column SDS.BY08CRYDJ.RYJBSJ is
'入院經辦時間';
comment on column SDS.BY08CRYDJ.CYJBSJ is
'出院經辦時間';
comment on column SDS.BY08CRYDJ.BZ is
'備注';
comment on column SDS.BY08CRYDJ.SJZT is
'數據傳輸狀態';
comment on column SDS.BY08CRYDJ.SWSXH is
'事務順序號';
comment on column SDS.BY08CRYDJ.ZDYS is
'診斷醫生';
comment on column SDS.BY08CRYDJ.ZFLB is
'支付類別';
comment on column SDS.BY08CRYDJ.ICNO is
'IC卡號';
/*==============================================================*/
/* Index: IDX_BY08CRYDJ_GRBM */
/*==============================================================*/
create index IDX_BY08CRYDJ_GRBM on SDS.BY08CRYDJ (
GRBM ASC
)
tablespace SDSIDX_TBS;
/*==============================================================*/
/* Index: IDX_BY08CRYDJ_YYBM */
/*==============================================================*/
create index IDX_BY08CRYDJ_YYBM on SDS.BY08CRYDJ (
YYBM ASC
)
tablespace SDSIDX_TBS;
/*==============================================================*/
/* Table: BY09ZXWZHZF */
/*==============================================================*/
create table SDS.BY09ZXWZHZF (
SXH VARCHAR2(15) not null,
GRBM VARCHAR2(15) not null,
YYBM VARCHAR2(8) not null,
FYBM VARCHAR2(3),
ZFSJ DATE not null,
ZFLB VARCHAR2(3) not null,
JBR VARCHAR2(8),
ZFYY VARCHAR2(30),
ZFE NUMBER(14,2),
BS VARCHAR2(5),
SJZT VARCHAR2(3),
YAB060 VARCHAR2(4) not null,
SWSXH VARCHAR2(20),
constraint PK_BY09ZXWZHZF primary key (SXH, ZFSJ, ZFLB)
using index
tablespace SDSIDX_TBS
)
tablespace SDS_TBS;
comment on table SDS.BY09ZXWZHZF is
'by09中心外帳戶支付記錄';
comment on column SDS.BY09ZXWZHZF.SXH is
'順序號';
comment on column SDS.BY09ZXWZHZF.GRBM is
'個人編碼';
comment on column SDS.BY09ZXWZHZF.YYBM is
'醫院編碼';
comment on column SDS.BY09ZXWZHZF.FYBM is
'分醫院編碼';
comment on column SDS.BY09ZXWZHZF.ZFSJ is
'支付時間';
comment on column SDS.BY09ZXWZHZF.ZFLB is
'支付類別';
comment on column SDS.BY09ZXWZHZF.JBR is
'經辦人';
comment on column SDS.BY09ZXWZHZF.ZFYY is
'支付原因';
comment on column SDS.BY09ZXWZHZF.ZFE is
'支付額';
comment on column SDS.BY09ZXWZHZF.BS is
'標識';
comment on column SDS.BY09ZXWZHZF.SJZT is
'數據傳輸狀態';
comment on column SDS.BY09ZXWZHZF.YAB060 is
'分中心編號';
comment on column SDS.BY09ZXWZHZF.SWSXH is
'事務順序號';
/*==============================================================*/
/* Index: IDX_BY09ZXWZHZF_GRBM */
/*==============================================================*/
create index IDX_BY09ZXWZHZF_GRBM on SDS.BY09ZXWZHZF (
GRBM ASC
)
tablespace SDSIDX_TBS;
/*==============================================================*/
/* Table: BY09ZYFYMX */
/*==============================================================*/
create table SDS.BY09ZYFYMX (
SXH VARCHAR2(15) not null,
SFSJ DATE not null,
YAB060 VARCHAR2(4) not null,
YYBM VARCHAR2(8),
SFDLBM VARCHAR2(3),
SFXMBM VARCHAR2(12),
SL NUMBER(8,2),
SJJG NUMBER(14,3),
CD VARCHAR2(30),
GG VARCHAR2(30),
YFYL VARCHAR2(30),
FYZE NUMBER(14,2),
ZFBL NUMBER(6,4),
TXBZ VARCHAR2(3),
BPBZ VARCHAR2(3),
QZFBF NUMBER(14,2),
GGZFBF NUMBER(14,2),
YXBXBF NUMBER(14,2),
FYSHBZ VARCHAR2(3),
SFY VARCHAR2(8),
BZ VARCHAR2(56),
TJDM VARCHAR2(12),
KSMC VARCHAR2(48),
SFXMMC VARCHAR2(48),
DW VARCHAR2(16),
JSBH VARCHAR2(18),
ZFLB VARCHAR2(3) not null,
ZFDD VARCHAR2(3),
XH VARCHAR2(18) not null,
SJZT VARCHAR2(3),
SWSXH VARCHAR2(20),
FZXSHBZ VARCHAR2(3),
FZXSHYY VARCHAR2(56),
SHJBR VARCHAR2(20),
MXLB VARCHAR2(3),
KDBXJE NUMBER(14,2),
BHLJE NUMBER(14,2),
JLSJ DATE,
SZSHSHBZ VARCHAR(3),
BHLJE_SH NUMBER(14,2),
SZSHRQ DATE,
SHSHRQ DATE,
constraint PK_BY09ZYFYMX primary key (SXH, SFSJ, ZFLB, XH)
using index
tablespace SDSIDX_TBS
)
tablespace SDS_TBS;
comment on table SDS.BY09ZYFYMX is
'BY09ZYFYMX費用明細住院';
comment on column SDS.BY09ZYFYMX.SXH is
'順序號（就診登記號）';
comment on column SDS.BY09ZYFYMX.SFSJ is
'收費時間';
comment on column SDS.BY09ZYFYMX.YAB060 is
'分中心編號';
comment on column SDS.BY09ZYFYMX.YYBM is
'醫院編碼';
comment on column SDS.BY09ZYFYMX.SFDLBM is
'大類編碼';
comment on column SDS.BY09ZYFYMX.SFXMBM is
'項目編碼';
comment on column SDS.BY09ZYFYMX.SL is
'數量';
comment on column SDS.BY09ZYFYMX.SJJG is
'實際價格';
comment on column SDS.BY09ZYFYMX.CD is
'產地';
comment on column SDS.BY09ZYFYMX.GG is
'規格';
comment on column SDS.BY09ZYFYMX.YFYL is
'用法用量';
comment on column SDS.BY09ZYFYMX.FYZE is
'費用總額';
comment on column SDS.BY09ZYFYMX.ZFBL is
'自費比例';
comment on column SDS.BY09ZYFYMX.TXBZ is
'特項標志';
comment on column SDS.BY09ZYFYMX.BPBZ is
'報批標志';
comment on column SDS.BY09ZYFYMX.QZFBF is
'全自費部分';
comment on column SDS.BY09ZYFYMX.GGZFBF is
'掛鉤自費部分';
comment on column SDS.BY09ZYFYMX.YXBXBF is
'允許報銷部分';
comment on column SDS.BY09ZYFYMX.FYSHBZ is
'費用審核標志';
comment on column SDS.BY09ZYFYMX.SFY is
'收費員';
comment on column SDS.BY09ZYFYMX.BZ is
'備注';
comment on column SDS.BY09ZYFYMX.TJDM is
'統計編碼';
comment on column SDS.BY09ZYFYMX.KSMC is
'科室名稱';
comment on column SDS.BY09ZYFYMX.SFXMMC is
'收費項目名稱';
comment on column SDS.BY09ZYFYMX.DW is
'計量單位';
comment on column SDS.BY09ZYFYMX.JSBH is
'結算編號';
comment on column SDS.BY09ZYFYMX.ZFLB is
'支付類別';
comment on column SDS.BY09ZYFYMX.ZFDD is
'支付地點';
comment on column SDS.BY09ZYFYMX.XH is
'序號';
comment on column SDS.BY09ZYFYMX.SJZT is
'數據傳輸狀態';
comment on column SDS.BY09ZYFYMX.SWSXH is
'事務順序號';
comment on column SDS.BY09ZYFYMX.FZXSHBZ is
'分中心審核標志';
comment on column SDS.BY09ZYFYMX.FZXSHYY is
'分中心審核原因';
comment on column SDS.BY09ZYFYMX.SHJBR is
'審核經辦人';
comment on column SDS.BY09ZYFYMX.MXLB is
'明細類別';
comment on column SDS.BY09ZYFYMX.KDBXJE is
'跨段報銷金額';
comment on column SDS.BY09ZYFYMX.BHLJE is
'事中不合理金額';
comment on column SDS.BY09ZYFYMX.JLSJ is
'錄入時間';
comment on column SDS.BY09ZYFYMX.SZSHSHBZ is
'事中事后審核標志';
comment on column SDS.BY09ZYFYMX.BHLJE_SH is
'事后不合理金額';
comment on column SDS.BY09ZYFYMX.SZSHRQ is
'事中審核日期';
comment on column SDS.BY09ZYFYMX.SHSHRQ is
'事后審核日期';
/*==============================================================*/
/* Index: IDX_BY09ZYFYMX_SFDLBM */
/*==============================================================*/
create index IDX_BY09ZYFYMX_SFDLBM on SDS.BY09ZYFYMX (
SFDLBM ASC
)
tablespace SDSIDX_TBS;
/*==============================================================*/
/* Index: IDX_BY09ZYFYMX_YYBM */
/*==============================================================*/
create index IDX_BY09ZYFYMX_YYBM on SDS.BY09ZYFYMX (
YYBM ASC
)
tablespace SDSIDX_TBS;
/*==============================================================*/
/* Table: BY10CYJSB */
/*==============================================================*/
create table SDS.BY10CYJSB (
SXH VARCHAR2(15) not null,
DWBM VARCHAR2(12),
GRBM VARCHAR2(20) not null,
XM VARCHAR2(8),
XB VARCHAR2(3),
CSRQ DATE,
RYZT VARCHAR2(3),
XNL NUMBER,
YYBM VARCHAR2(8) not null,
FYBM VARCHAR2(3) not null,
JFNX NUMBER(8,2),
ZYJS NUMBER(10,2),
FYZE NUMBER(14,2),
QZFBF NUMBER(14,2),
GGZFBF NUMBER(14,2),
YXBXBF NUMBER(14,2),
JRJSBF NUMBER(14,2),
TCZIFBF NUMBER(14,2),
TCZHIFBF NUMBER(14,2),
YDCZGGZF NUMBER(14,2),
SBJKC NUMBER(14,2),
ZFSM VARCHAR2(255),
JBSJ DATE not null,
CWSXH VARCHAR2(15),
BZ VARCHAR2(56),
SFY VARCHAR2(8),
JSBH VARCHAR2(8),
ZFLB VARCHAR2(3) not null,
ZFDD VARCHAR2(3),
BZBM VARCHAR2(8),
BZXE NUMBER(14,2),
BCZFXE NUMBER(14,2),
SFTD VARCHAR2(3),
SJZT VARCHAR2(3),
CXZFBF NUMBER(14,2),
TCZFBL NUMBER(8,4),
DBZC NUMBER(14,2),
SHBZ VARCHAR2(3),
KKYY VARCHAR2(255),
YAB060 VARCHAR2(4) not null,
DBZIF2 NUMBER(14,2),
SWSXH2 VARCHAR2(20),
GWYTCZHF2 NUMBER(14,2),
FZXSHBZ2 VARCHAR2(3),
TSGGZFBF2 NUMBER(14,2),
DWMC2 VARCHAR2(20),
GWYCXBZ2 NUMBER(14,2),
XJZF2 NUMBER(14,2),
KZF2 NUMBER(14,2),
TGBZ2 NUMBER(14,2),
FSSJ2 DATE,
TXBZ2 NUMBER(14,2),
RYSW2 VARCHAR2(3),
SBJKC_SZ2 NUMBER(14,2),
SBJKC_DB_SZ2 NUMBER(14,2),
SBJKC_DB2 NUMBER(14,2),
constraint PK_BY10CYJSB primary key (SXH, GRBM, YYBM, ZFLB)
using index
tablespace SDSIDX_TBS
)
tablespace SDS_TBS;
comment on table SDS.BY10CYJSB is
'BY10CYJSB費用結算表';
comment on column SDS.BY10CYJSB.SXH is
'順序號（就診登記號）';
comment on column SDS.BY10CYJSB.DWBM is
'單位編碼';
comment on column SDS.BY10CYJSB.GRBM is
'個人編碼';
comment on column SDS.BY10CYJSB.XM is
'姓名';
comment on column SDS.BY10CYJSB.XB is
'性別';
comment on column SDS.BY10CYJSB.CSRQ is
'出生日期';
comment on column SDS.BY10CYJSB.RYZT is
'人員狀態';
comment on column SDS.BY10CYJSB.XNL is
'現年齡';
comment on column SDS.BY10CYJSB.YYBM is
'醫院編碼';
comment on column SDS.BY10CYJSB.FYBM is
'分醫院編碼';
comment on column SDS.BY10CYJSB.JFNX is
'經費年限';
comment on column SDS.BY10CYJSB.ZYJS is
'住院基數';
comment on column SDS.BY10CYJSB.FYZE is
'費用總額';
comment on column SDS.BY10CYJSB.QZFBF is
'全自費部分';
comment on column SDS.BY10CYJSB.GGZFBF is
'掛鉤自費部分';
comment on column SDS.BY10CYJSB.YXBXBF is
'允許報銷部分';
comment on column SDS.BY10CYJSB.JRJSBF is
'進入基數部分';
comment on column SDS.BY10CYJSB.TCZIFBF is
'統籌自付部分';
comment on column SDS.BY10CYJSB.TCZHIFBF is
'統籌支付部分';
comment on column SDS.BY10CYJSB.YDCZGGZF is
'異地超支掛鉤自付部分';
comment on column SDS.BY10CYJSB.SBJKC is
'社保局扣除';
comment on column SDS.BY10CYJSB.ZFSM is
'支付說明';
comment on column SDS.BY10CYJSB.JBSJ is
'經辦時間';
comment on column SDS.BY10CYJSB.CWSXH is
'財務順序號';
comment on column SDS.BY10CYJSB.BZ is
'備注';
comment on column SDS.BY10CYJSB.SFY is
'收費員';
comment on column SDS.BY10CYJSB.JSBH is
'結算編號';
comment on column SDS.BY10CYJSB.ZFLB is
'支付類別';
comment on column SDS.BY10CYJSB.ZFDD is
'支付地點';
comment on column SDS.BY10CYJSB.BZBM is
'病種編碼';
comment on column SDS.BY10CYJSB.BZXE is
'病種限額';
comment on column SDS.BY10CYJSB.BCZFXE is
'本次支付限額';
comment on column SDS.BY10CYJSB.SFTD is
'是否退單';
comment on column SDS.BY10CYJSB.SJZT is
'數據傳輸狀態';
comment on column SDS.BY10CYJSB.CXZFBF is
'超限自付部分';
comment on column SDS.BY10CYJSB.TCZFBL is
'統籌支付比例';
comment on column SDS.BY10CYJSB.DBZC is
'大病支出';
comment on column SDS.BY10CYJSB.SHBZ is
'審核標志';
comment on column SDS.BY10CYJSB.KKYY is
'扣款原因';
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -