create table appdata.SLIS_BATCH_PLAN
(
  sequence             VARCHAR2(20) not null,
  proc_code            VARCHAR2(4),
  branch_code          VARCHAR2(10),
  parameters           VARCHAR2(2000),
  scheduled_start_date DATE,
  priority             INTEGER,
  proc_flag            VARCHAR2(2),
  create_date          DATE,
  create_user          VARCHAR2(100),
  fcu                  VARCHAR2(100),
  fcd                  DATE,
  lcu                  VARCHAR2(100),
  lcd                  DATE,
  job_no               NUMBER,
  job_source_module    VARCHAR2(4),
  start_date           DATE,
  end_date             DATE
)
comment on table appdata.SLIS_BATCH_PLAN
  is '任务计划表';
-- Add comments to the columns 
comment on column appdata.SLIS_BATCH_PLAN.sequence
  is '流水号';
comment on column appdata.SLIS_BATCH_PLAN.proc_code
  is '批处理代码';
comment on column appdata.SLIS_BATCH_PLAN.branch_code
  is '机构代码';
comment on column appdata.SLIS_BATCH_PLAN.parameters
  is '批处理参数';
comment on column appdata.SLIS_BATCH_PLAN.scheduled_start_date
  is '任务计划启动时间';
comment on column appdata.SLIS_BATCH_PLAN.priority
  is '优先级';
comment on column appdata.SLIS_BATCH_PLAN.proc_flag
  is '批处理状态';
comment on column appdata.SLIS_BATCH_PLAN.create_date
  is '写入时间';
comment on column appdata.SLIS_BATCH_PLAN.create_user
  is '写入用户';
comment on column appdata.SLIS_BATCH_PLAN.fcu
  is '创建人';
comment on column appdata.SLIS_BATCH_PLAN.fcd
  is '创建日期';
comment on column appdata.SLIS_BATCH_PLAN.lcu
  is '修改人';
comment on column appdata.SLIS_BATCH_PLAN.lcd
  is '修改日期';
comment on column appdata.SLIS_BATCH_PLAN.job_no
  is 'job号';
comment on column appdata.SLIS_BATCH_PLAN.job_source_module
  is 'job模块号';
comment on column appdata.SLIS_BATCH_PLAN.start_date
  is '任务起始时间';
comment on column appdata.SLIS_BATCH_PLAN.end_date
  is '任务结束时间(不精确,间隔时间越大差异越大)';
  
  
  
  
  
  
  
  create table rendata.RN_ASSIGN_BATCH_RECORD
   branch_code  VARCHAR2(10) not null,
  due_month    DATE not null,
  batch_code   VARCHAR2(20) not null,
  batch_seq    VARCHAR2(20),
  finish_flag  VARCHAR2(1),
  pk_serial    VARCHAR2(20) not null,
  created_user VARCHAR2(100) not null,
  created_date DATE default sysdate not null,
  updated_user VARCHAR2(100) not null,
  updated_date DATE default sysdate not null
  
  
  comment on table rendata.RN_ASSIGN_BATCH_RECORD
  is '机构分单批次申请记录表';
-- Add comments to the columns 
comment on column rendata.RN_ASSIGN_BATCH_RECORD.due_month
  is '应缴月';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_code
  is '批处理代码';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_seq
  is '批处理流水';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.finish_flag
  is '完成状态';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.pk_serial
  is '数据主键';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_user
  is '录入人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_date
  is '录入日期';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_user
  is '修改人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_date
  is '修改日期';
  
  
  
  create table appdata.SLIS_BATCH_PROC_ERROR_RECORD
(
  sequence       VARCHAR2(20) not null,
  proc_code      VARCHAR2(4),
  ctrl_no        VARCHAR2(40),
  ora_error_code NUMBER(6),
  error_message  VARCHAR2(300),
  operating_user VARCHAR2(100),
  operating_date DATE,
  sid            NUMBER,
  serial         NUMBER,
  branch_code    VARCHAR2(10)
)

comment on table appdata.SLIS_BATCH_PROC_ERROR_RECORD
  is 'SLIS系统批处理出错信息表';
-- Add comments to the columns 
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.sequence
  is '流水号-用于对应执行信息表数据';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.proc_code
  is '批处理代码';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.ctrl_no
  is '出错控制号';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.ora_error_code
  is 'ora出错代码';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.error_message
  is '出错信息';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.operating_user
  is '操作执行用户';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.operating_date
  is '操作执行时间';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.sid
  is '运行该JOB的SID';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.serial
  is 'SID对应的SERIAL#';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.branch_code
  is '机构代码';
  
  
  
  
  
  select sbp.sequence,sbp.proc_code,sbp.branch_code,sbp.create_user,sbp.create_date,sbp.parameters,sbp.proc_flag,sbp.start_date,sbp.end_date
 from SLIS_BATCH_PLAN sbp
 where sbp.branch_code='865109'
 and sbp.proc_code='R113'
 and sbp.sequence='20150000000003992071'
 and sbp.start_date
 and sbp.end_date
 ;