HB_RTGK
/
sicuan_lims
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
sicuan_lims/sql/oracle/质量体系管理/满意度调查.txt

254 lines
29 KiB
Plaintext
Raw Permalink Blame History

-- ----------------------------- 2022-09-15 add by qiuyf--------------begin
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('7007','满意度调查',NULL,70,'7007','满意度调查',NULL,NULL,NULL,'005.svg',NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700701','发起满意度调查','/secure/basemodule/qms/satisfactions/page/edit-list','7007',1,'发起满意度调查',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700702','满意度调查填写','/secure/basemodule/qms/satisfactions-users/page/inprocess-edit-list?bpmn_statusCode=InProcess','7007',2,'满意度调查填写',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700703','确认意见','/secure/basemodule/qms/satisfactions-users/page/confirm-audit-list?bpmn_statusCode=Confirm','7007',3,'确认意见',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700704','客户意见处理','/secure/basemodule/qms/satisfactions-users/page/analyse-audit-list?bpmn_statusCode=Analyse','7007',4,'客户意见处理',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700705','满意度结果汇总','/secure/basemodule/qms/satisfactions/page/upload-attachment?bpmn_statusCode=Upload','7007',5,'满意度结果汇总',NULL,NULL,NULL,'014.svg',NULL,NULL);
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700706','满意度调查查询','/secure/basemodule/qms/satisfactions/page/search-list','7007',6,'满意度调查查询',NULL,NULL,NULL,NULL,NULL,NULL);
/*满意度调查*/
CREATE TABLE T_LIMS_SATISFACTION
(
ID NUMBER NOT NULL,
CREATEDBYID VARCHAR2(36),
CREATEDBYNAME VARCHAR2(36),
CREATEDTIME DATE,
CREATEDBYORGID VARCHAR2(36),
CREATEDBYORGNAME VARCHAR2(300),
SATISFACTIONCODE VARCHAR2(36),
SATISFACTIONNAME VARCHAR2(40),
VALIDITYDATE DATE,
QUALITYWORKDETAILID NUMBER,
PROCESSSTATUS VARCHAR2(36)
);
ALTER TABLE T_LIMS_SATISFACTION ADD CONSTRAINT PK_T_LIMS_SATISFACTION PRIMARY KEY (ID);
INSERT INTO T_CORE_TABLE(ID, AUDITABLE, ATTACHMENT) VALUES('T_LIMS_SATISFACTION', '0', '0');
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE) VALUES('2021081001', '满意度调查', 'T_LIMS_SATISFACTION', 'audit_def', '1');
COMMENT ON COLUMN T_LIMS_SATISFACTION.ID IS 'ID';
COMMENT ON COLUMN T_LIMS_SATISFACTION.CREATEDBYID IS '创建人账号';
COMMENT ON COLUMN T_LIMS_SATISFACTION.CREATEDBYNAME IS '创建人姓名';
COMMENT ON COLUMN T_LIMS_SATISFACTION.CREATEDTIME IS '创建时间';
COMMENT ON COLUMN T_LIMS_SATISFACTION.CREATEDBYORGID IS '创建人所属组织ID';
COMMENT ON COLUMN T_LIMS_SATISFACTION.CREATEDBYORGNAME IS '创建人所属组织名称';
COMMENT ON COLUMN T_LIMS_SATISFACTION.SATISFACTIONCODE IS '调查编号';
COMMENT ON COLUMN T_LIMS_SATISFACTION.SATISFACTIONNAME IS '调查名称';
COMMENT ON COLUMN T_LIMS_SATISFACTION.VALIDITYDATE IS '有效期';
CALL INSERTI18N('T_LIMS_SATISFACTION.SATISFACTIONCODE','满意度调查编号','调查编号','zh-CN','调查编号');
CALL INSERTI18N('T_LIMS_SATISFACTION.SATISFACTIONCODE','满意度调查编号','调查编号','en-US','Satisfaction Survey Code');
CALL INSERTI18N('T_LIMS_SATISFACTION.SATISFACTIONNAME','满意度调查名称','调查名称','zh-CN','调查名称');
CALL INSERTI18N('T_LIMS_SATISFACTION.SATISFACTIONNAME','满意度调查名称','调查名称','en-US','Satisfaction Survey Name');
CALL INSERTI18N('T_LIMS_SATISFACTION.VALIDITYDATE','满意度调查有效期','有效期','zh-CN','有效期');
CALL INSERTI18N('T_LIMS_SATISFACTION.VALIDITYDATE','满意度调查有效期','有效期','en-US','Validity Date');
CALL INSERTI18N('T_LIMS_SATISFACTION.PROCESSSTATUS','满意度调查状态','状态','zh-CN','状态');
CALL INSERTI18N('T_LIMS_SATISFACTION.PROCESSSTATUS','满意度调查状态','状态','en-US','State');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.TAB.TITLE','满意度调查计划','满意度调查计划','zh-CN','满意度调查计划');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.TAB.TITLE','满意度调查计划','满意度调查计划','en-US','Satisfaction Survey Scheme');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.TAB.USERS','满意度调查人员','满意度调查人员','zh-CN','满意度调查人员');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.TAB.USERS','满意度调查人员','满意度调查人员','en-US','Satisfaction Survey Users');
INSERT INTO T_CORE_SEQUENCE("ID", "PATTERN", "JSONPARAM") VALUES ('T_LIMS_SATISFACTION_CODE', '[yyyy][nn]', NULL);
/*满意度调查详情*/
CREATE TABLE T_LIMS_SATISFACTION_USERS
(
ID NUMBER NOT NULL,
CREATEDBYID VARCHAR2(36),
CREATEDBYNAME VARCHAR2(36),
CREATEDTIME DATE,
CREATEDBYORGID VARCHAR2(36),
CREATEDBYORGNAME VARCHAR2(300),
USERID VARCHAR2(36),
USERNAME VARCHAR2(36),
PHONE VARCHAR2(36),
CUSTOMERUNITID VARCHAR2(36),
CUSTOMERUNITNAME VARCHAR2(300),
SERVICE NUMBER,
COMMUNICATION NUMBER,
REPLYTIMELINESS NUMBER,
RESULTTIMELINESS NUMBER,
RESULTACCURACY NUMBER,
EASYUNDERSTANDING NUMBER,
COMPLAINTSTIMELINESS NUMBER,
PROFESSIONALEVALUATION NUMBER,
SUGGEST VARCHAR2(300),
FRACTION NUMBER,
RESPONSIBLEPERSONID VARCHAR2(36),
RESPONSIBLEPERSON VARCHAR2(36),
REASONDESC VARCHAR2(800),
CORRECT VARCHAR2(800),
SATISID NUMBER,
PROCESSSTATUS VARCHAR2(36)
);
ALTER TABLE T_LIMS_SATISFACTION_USERS ADD CONSTRAINT PK_T_LIMS_SATISFACTION_USERS PRIMARY KEY (ID);
INSERT INTO T_CORE_TABLE(ID, AUDITABLE, ATTACHMENT) VALUES('T_LIMS_SATISFACTION_USERS', '0', '0');
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE) VALUES('2021081002', '满意度调查详情', 'T_LIMS_SATISFACTION_USERS', 'audit_def', '1');
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.ID IS 'ID';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CREATEDBYID IS '创建人账号';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CREATEDBYNAME IS '创建人姓名';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CREATEDTIME IS '创建时间';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CREATEDBYORGID IS '创建人所属组织ID';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CREATEDBYORGNAME IS '创建人所属组织名称';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.USERID IS '客户帐号';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.USERNAME IS '客户名称';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.PHONE IS '联系电话';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CUSTOMERUNITID IS '客户单位ID';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CUSTOMERUNITNAME IS '客户单位';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.SERVICE IS '接待人员的服务态度';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.COMMUNICATION IS '接待人员的沟通能力';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS IS '接待人员的响应速度或回复及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS IS '出具检测报告的及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESULTACCURACY IS '检测结果的准确性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING IS '检测报告内容表达清晰，编排合理并易于理解';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS IS '处理投诉抱怨的及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION IS '对我中心服务的专业性评价';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.SUGGEST IS '建议';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.FRACTION IS '客户评分';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSONID IS '责任人帐号';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSON IS '责任人';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.REASONDESC IS '原因描述';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.CORRECT IS '整改措施';
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.USERID','满意度调查客户帐号','客户帐号','zh-CN','客户帐号');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.USERID','满意度调查客户帐号','客户帐号','en-US','User Id');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.USERNAME','满意度调查客户名称','客户名称','zh-CN','客户名称');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.USERNAME','满意度调查客户名称','客户名称','en-US','Customer Name');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PHONE','满意度调查联系电话','联系电话','zh-CN','联系电话');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PHONE','满意度调查联系电话','联系电话','en-US','Phone');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CUSTOMERUNITID','满意度调查客户单位ID','客户单位ID','zh-CN','客户单位ID');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CUSTOMERUNITID','满意度调查客户单位ID','客户单位ID','en-US','Customer Unit Id');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CUSTOMERUNITNAME','满意度调查客户单位','客户单位','zh-CN','客户单位');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CUSTOMERUNITNAME','满意度调查客户单位','客户单位','en-US','Customer Unit');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SERVICE','满意度调查接待人员的服务态度','接待人员的服务态度','zh-CN','接待人员的服务态度');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SERVICE','满意度调查接待人员的服务态度','接待人员的服务态度','en-US','Service Attitude');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMMUNICATION','满意度调查接待人员的沟通能力','接待人员的沟通能力','zh-CN','接待人员的沟通能力');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMMUNICATION','满意度调查接待人员的沟通能力','接待人员的沟通能力','en-US','Communication');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS','满意度调查接待人员的响应速度或回复及时性','接待人员的响应速度或回复及时性','zh-CN','接待人员的响应速度或回复及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS','满意度调查接待人员的响应速度或回复及时性','接待人员的响应速度或回复及时性','en-US','Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS','满意度调查出具检测报告的及时性','出具检测报告的及时性','zh-CN','出具检测报告的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS','满意度调查出具检测报告的及时性','出具检测报告的及时性','en-US','Result Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTACCURACY','满意度调查检测结果的准确性','检测结果的准确性','zh-CN','检测结果的准确性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTACCURACY','满意度调查检测结果的准确性','检测结果的准确性','en-US','Result Accuracy');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING','满意度调查检测报告内容表达清晰，编排合理并易于理解','检测报告内容表达清晰，编排合理并易于理解','zh-CN','检测报告内容表达清晰，编排合理并易于理解');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING','满意度调查检测报告内容表达清晰，编排合理并易于理解','检测报告内容表达清晰，编排合理并易于理解','en-US','Easy Understanding');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','处理投诉抱怨的及时性','zh-CN','处理投诉抱怨的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','处理投诉抱怨的及时性','en-US','Handle Complaints Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','对我中心服务的专业性评价','zh-CN','对我中心服务的专业性评价');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','对我中心服务的专业性评价','en-US','Professional Evaluation');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SUGGEST','满意度调查建议','其他要求、意见/建议','zh-CN','其他要求、意见/建议');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SUGGEST','满意度调查建议','其他要求、意见/建议','en-US','Other Requests, Comments/Suggestions');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.FRACTION','满意度调查客户评分','客户评分','zh-CN','客户评分');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.FRACTION','满意度调查客户评分','客户评分','en-US','Fraction');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSONID','满意度调查责任人帐号','责任人帐号','zh-CN','责任人帐号');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSONID','满意度调查责任人帐号','责任人帐号','en-US','Responsible Person Id');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSON','满意度调查责任人','责任人','zh-CN','责任人');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESPONSIBLEPERSON','满意度调查责任人','责任人','en-US','Responsible Person');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REASONDESC','满意度调查原因描述','原因描述','zh-CN','原因描述');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REASONDESC','满意度调查原因描述','原因描述','en-US','Reason Description');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CORRECT','满意度调查整改措施','整改措施','zh-CN','整改措施');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.CORRECT','满意度调查整改措施','整改措施','en-US','Rectification Measures');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.SERVICE','满意度调查接待人员的服务态度','1.接待人员的服务态度','zh-CN','1.接待人员的服务态度');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.SERVICE','满意度调查接待人员的服务态度','1.接待人员的服务态度','en-US','1.Service Attitude');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMMUNICATION','满意度调查接待人员的沟通能力','2.接待人员的沟通能力','zh-CN','2.接待人员的沟通能力');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMMUNICATION','满意度调查接待人员的沟通能力','2.接待人员的沟通能力','en-US','Communication');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.REPLYTIMELINESS','满意度调查接待人员的响应速度或回复及时性','3.接待人员的响应速度或回复及时性','zh-CN','3.接待人员的响应速度或回复及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.REPLYTIMELINESS','满意度调查接待人员的响应速度或回复及时性','3.接待人员的响应速度或回复及时性','en-US','Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTTIMELINESS','满意度调查出具检测报告的及时性','4.出具检测报告的及时性','zh-CN','4.出具检测报告的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTTIMELINESS','满意度调查出具检测报告的及时性','4.出具检测报告的及时性','en-US','4.Result Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTACCURACY','满意度调查检测结果的准确性','5.检测结果的准确性','zh-CN','5.检测结果的准确性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTACCURACY','满意度调查检测结果的准确性','5.检测结果的准确性','en-US','5.Result Accuracy');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.EASYUNDERSTANDING','满意度调查检测报告内容表达清晰，编排合理并易于理解','6.检测报告内容表达清晰，编排合理并易于理解','zh-CN','6.检测报告内容表达清晰，编排合理并易于理解');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.EASYUNDERSTANDING','满意度调查检测报告内容表达清晰，编排合理并易于理解','6.检测报告内容表达清晰，编排合理并易于理解','en-US','6.Easy Understanding');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','7.处理投诉抱怨的及时性','zh-CN','7.处理投诉抱怨的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','7.处理投诉抱怨的及时性','en-US','7.Handle Complaints Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','8.对我中心服务的专业性评价','zh-CN','8.对我中心服务的专业性评价');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','8.对我中心服务的专业性评价','en-US','8.Professional Evaluation');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.USERS.CENTER.INFO.TAB.TITLE','满意度调查问卷','调查问卷','zh-CN','调查问卷');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.USERS.CENTER.INFO.TAB.TITLE','满意度调查问卷','调查问卷','en-US','Questionnaire');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_WISHES','满意度调查问卷客户寄语','客户寄语','zh-CN','客户寄语');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_WISHES','满意度调查问卷客户寄语','客户寄语','en-US','Wishes');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_CONTENT','满意度调查问卷内容','问卷内容','zh-CN','问卷内容');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_CONTENT','满意度调查问卷内容','问卷内容','en-US','Questionnaire Content');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_CONFIRM','满意度调查意见确认','意见确认','zh-CN','意见确认');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_CONFIRM','满意度调查意见确认','意见确认','en-US','Confirm');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_OPINIONPROCESS','满意度调查意见处理','意见处理','zh-CN','意见处理');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS_SURVEY_OPINIONPROCESS','满意度调查意见处理','意见处理','en-US','Opinion Processing');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.MODAL.ADD','新增满意度调查','新增满意度调查','zh-CN','新增满意度调查');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTIONS.MODAL.ADD','新增满意度调查','新增满意度调查','en-US','Add');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTION.TAB.BASE_INFO','满意度调查详情','满意度调查详情','zh-CN','满意度调查详情');
CALL INSERTI18N('LIMS.QUALITY.SATISFACTION.TAB.BASE_INFO','满意度调查详情','满意度调查详情','en-US','Details');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.DETAIL','查看','查看','zh-CN','查看');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.DETAIL','查看','查看','en-US','Details');
CALL INSERTI18N('T_LIMS_SATISFACTIONS.USERS.ADD','添加满意度调查人员','添加满意度调查人员','zh-CN','添加满意度调查人员');
CALL INSERTI18N('T_LIMS_SATISFACTIONS.USERS.ADD','添加满意度调查人员','添加满意度调查人员','en-US','Add');
ALTER TABLE T_LIMS_SATISFACTION_USERS ADD ABNORMALREPLYTIMELINESS NUMBER;
ALTER TABLE T_LIMS_SATISFACTION_USERS ADD TESTFAIRNESS NUMBER;
ALTER TABLE T_LIMS_SATISFACTION_USERS ADD RECEIVEARRANGETIMELINESS NUMBER;
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.SERVICE IS '接待人员的服务态度';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.COMMUNICATION IS '接待人员的沟通能力';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS IS '接待人员回复及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESULTACCURACY IS '检测结果的准确性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.ABNORMALREPLYTIMELINESS IS '检测异常反馈的及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS IS '出具检测报告的及时性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING IS '检测报告内容清晰，数据详细准确';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.TESTFAIRNESS IS '检测工作的公正性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION IS '实验室人员的专业性';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS IS '对抱怨、投诉处理的满意程度';
COMMENT ON COLUMN T_LIMS_SATISFACTION_USERS.RECEIVEARRANGETIMELINESS IS '接单排单及时性';
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SERVICE','满意度调查接待人员的服务态度','接待人员的服务态度','zh-CN','接待人员的服务态度');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.SERVICE','满意度调查接待人员的服务态度','接待人员的服务态度','en-US','Service Attitude');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMMUNICATION','满意度调查接待人员的沟通能力','接待人员的沟通能力','zh-CN','接待人员的沟通能力');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMMUNICATION','满意度调查接待人员的沟通能力','接待人员的沟通能力','en-US','Communication');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS','满意度调查接待人员回复及时性','接待人员回复及时性','zh-CN','接待人员回复及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.REPLYTIMELINESS','满意度调查接待人员回复及时性','接待人员回复及时性','en-US','Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTACCURACY','满意度调查检测结果的准确性','检测结果的准确性','zh-CN','检测结果的准确性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTACCURACY','满意度调查检测结果的准确性','检测结果的准确性','en-US','Result Accuracy');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.ABNORMALREPLYTIMELINESS','满意度调查检测异常反馈的及时性','检测异常反馈的及时性','zh-CN','检测异常反馈的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.ABNORMALREPLYTIMELINESS','满意度调查检测异常反馈的及时性','检测异常反馈的及时性','en-US','Abnormal Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS','满意度调查出具检测报告的及时性','出具检测报告的及时性','zh-CN','出具检测报告的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RESULTTIMELINESS','满意度调查出具检测报告的及时性','出具检测报告的及时性','en-US','Result Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING','满意度调查检测报告内容清晰，数据详细准确','检测报告内容清晰，数据详细准确','zh-CN','检测报告内容清晰，数据详细准确');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.EASYUNDERSTANDING','满意度调查检测报告内容清晰，数据详细准确','检测报告内容清晰，数据详细准确','en-US','Easy Understanding');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.TESTFAIRNESS','满意度调查检测工作的公正性','检测工作的公正性','zh-CN','检测工作的公正性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.TESTFAIRNESS','满意度调查检测工作的公正性','检测工作的公正性','en-US','Test Fairness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','实验室人员的专业性','zh-CN','实验室人员的专业性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','实验室人员的专业性','en-US','Professional Evaluation');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','处理投诉抱怨的及时性','zh-CN','处理投诉抱怨的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','处理投诉抱怨的及时性','en-US','Handle Complaints Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RECEIVEARRANGETIMELINESS','满意度调查接单排单及时性','接单排单及时性','zh-CN','接单排单及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RECEIVEARRANGETIMELINESS','满意度调查接单排单及时性','接单排单及时性','en-US','Receive/Arrange Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.SERVICE','满意度调查接待人员的服务态度','1.接待人员的服务态度','zh-CN','1.接待人员的服务态度');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.SERVICE','满意度调查接待人员的服务态度','1.接待人员的服务态度','en-US','1.Service Attitude');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMMUNICATION','满意度调查接待人员的沟通能力','2.接待人员的沟通能力','zh-CN','2.接待人员的沟通能力');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMMUNICATION','满意度调查接待人员的沟通能力','2.接待人员的沟通能力','en-US','Communication');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.REPLYTIMELINESS','满意度调查接待人员回复及时性','3.接待人员回复及时性','zh-CN','3.接待人员回复及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.REPLYTIMELINESS','满意度调查接待人员回复及时性','3.接待人员回复及时性','en-US','Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTACCURACY','满意度调查检测结果的准确性','4.检测结果的准确性','zh-CN','4.检测结果的准确性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTACCURACY','满意度调查检测结果的准确性','4.检测结果的准确性','en-US','4.Result Accuracy');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.ABNORMALREPLYTIMELINESS','满意度调查检测异常反馈的及时性','5.检测异常反馈的及时性','zh-CN','5.检测异常反馈的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.ABNORMALREPLYTIMELINESS','满意度调查检测异常反馈的及时性','5.检测异常反馈的及时性','en-US','5.Abnormal Reply Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTTIMELINESS','满意度调查出具检测报告的及时性','6.出具检测报告的及时性','zh-CN','6.出具检测报告的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RESULTTIMELINESS','满意度调查出具检测报告的及时性','6.出具检测报告的及时性','en-US','6.Result Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.EASYUNDERSTANDING','满意度调查检测报告内容清晰，数据详细准确','7.满意度调查检测报告内容清晰，数据详细准确','zh-CN','7.满意度调查检测报告内容清晰，数据详细准确');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.EASYUNDERSTANDING','满意度调查检测报告内容清晰，数据详细准确','7.满意度调查检测报告内容清晰，数据详细准确','en-US','7.Easy Understanding');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.TESTFAIRNESS','满意度调查检测工作的公正性','8.检测工作的公正性','zh-CN','8.检测工作的公正性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.TESTFAIRNESS','满意度调查检测工作的公正性','8.检测工作的公正性','en-US','8.Test Fairness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','9.实验室人员的专业性','zh-CN','9.实验室人员的专业性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.PROFESSIONALEVALUATION','满意度调查对我中心服务的专业性评价','9.实验室人员的专业性','en-US','9.Professional Evaluation');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','10.处理投诉抱怨的及时性','zh-CN','10.处理投诉抱怨的及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.COMPLAINTSTIMELINESS','满意度调查处理投诉抱怨的及时性','10.处理投诉抱怨的及时性','en-US','10.Handle Complaints Timeliness');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RECEIVEARRANGETIMELINESS','满意度调查接单排单及时性','10.接单/排单及时性','zh-CN','10.接单/排单及时性');
CALL INSERTI18N('T_LIMS_SATISFACTION_USERS.RADIO.RECEIVEARRANGETIMELINESS','满意度调查接单排单及时性','10.接单/排单及时性','en-US','10.Receive/Arrange Timeliness');
COMMIT;
-- ----------------------------- 2022-09-15 add by qiuyf--------------end
Reference in New Issue View Git Blame Copy Permalink