0100_ddl_slisintf_tables.sql

prompt Creating slisintf.BRANCH_CODE_RELATION...
create table slisintf.BRANCH_CODE_RELATION
(
  BRANCH_CODE          VARCHAR2(10) not null,
  RELATIVE_BRANCH_CODE VARCHAR2(10) not null,
  RELATIVE_GRADE       NUMBER(2) not null,
  CREATED_USER         VARCHAR2(100) not null,
  CREATED_DATE         DATE not null,
  UPDATED_USER         VARCHAR2(100) not null,
  UPDATED_DATE         DATE not null
)
;
comment on table slisintf.BRANCH_CODE_RELATION
  is '机构隶属关系';
comment on column slisintf.BRANCH_CODE_RELATION.BRANCH_CODE
  is '机构代码';
comment on column slisintf.BRANCH_CODE_RELATION.RELATIVE_BRANCH_CODE
  is '隶属机构';
comment on column slisintf.BRANCH_CODE_RELATION.RELATIVE_GRADE
  is '隶属关系：1—branch_code上级；0—branch_code自己；-1—branch_code下级；';
comment on column slisintf.BRANCH_CODE_RELATION.CREATED_USER
  is '录入人';
comment on column slisintf.BRANCH_CODE_RELATION.CREATED_DATE
  is '录入日期';
comment on column slisintf.BRANCH_CODE_RELATION.UPDATED_USER
  is '修改人';
comment on column slisintf.BRANCH_CODE_RELATION.UPDATED_DATE
  is '修改日期';
alter table slisintf.BRANCH_CODE_RELATION
  add constraint PK_BRANCH_CODE_RELATION primary key (BRANCH_CODE, RELATIVE_BRANCH_CODE);

--create index slisintf.IX_BRANCH_CODE_RELATION_1 on slisintf.BRANCH_CODE_RELATION (BRANCH_CODE);
--create index slisintf.IX_BRANCH_CODE_RELATION_2 on slisintf.BRANCH_CODE_RELATION (RELATIVE_BRANCH_CODE, BRANCH_CODE);

prompt Creating slisintf.CLIENT_INFORMATION...
create table slisintf.CLIENT_INFORMATION
(
  CLIENT_NO             VARCHAR2(20) not null,
  CLIENT_NAME           VARCHAR2(50) not null,
  BIRTHDAY              DATE not null,
  SEX_CODE              VARCHAR2(1) not null,
  ID_TYPE               VARCHAR2(2),
  IDNO                  VARCHAR2(50),
  IDNO_VALIDITY_DATE    DATE,
  NATION_CODE           VARCHAR2(2),
  COUNTRY_CODE          VARCHAR2(3),
  EDUCATION_CODE        VARCHAR2(2),
  MARRIAGE_CODE         VARCHAR2(2),
  OCCUPATION_CODE       VARCHAR2(7),
  PK_SERIAL             VARCHAR2(20) not null,
  WORK_UNIT             VARCHAR2(100),
  POSITION              VARCHAR2(50),
  DEATH_DATE            DATE,
  REGISTER_PLACE        VARCHAR2(50),
  PHONETICIZE_LASTNAME  VARCHAR2(50),
  PHONETICIZE_FIRSTNAME VARCHAR2(50),
  CREATED_USER          VARCHAR2(100) not null,
  CREATED_DATE          DATE not null,
  UPDATED_USER          VARCHAR2(100) not null,
  UPDATED_DATE          DATE not null,
  INDUSTRY              VARCHAR2(50),
  OCCUPATION_ADDED_DESC VARCHAR2(100),
  DATA_STATUS           NUMBER(1) default 1 not null,
  MERGE_TO_CLIENTNO     VARCHAR2(20)
)
;
comment on table slisintf.CLIENT_INFORMATION
  is '客户基本信息表';
comment on column slisintf.CLIENT_INFORMATION.CLIENT_NO
  is '客户号';
comment on column slisintf.CLIENT_INFORMATION.CLIENT_NAME
  is '姓名';
comment on column slisintf.CLIENT_INFORMATION.BIRTHDAY
  is '生日';
comment on column slisintf.CLIENT_INFORMATION.SEX_CODE
  is '性别代码';
comment on column slisintf.CLIENT_INFORMATION.ID_TYPE
  is '证件类型代码';
comment on column slisintf.CLIENT_INFORMATION.IDNO
  is '证件号码';
comment on column slisintf.CLIENT_INFORMATION.IDNO_VALIDITY_DATE
  is '证件有效期截止日期';
comment on column slisintf.CLIENT_INFORMATION.NATION_CODE
  is '民族代码';
comment on column slisintf.CLIENT_INFORMATION.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.CLIENT_INFORMATION.EDUCATION_CODE
  is '学历代码';
comment on column slisintf.CLIENT_INFORMATION.MARRIAGE_CODE
  is '婚姻状况代码';
comment on column slisintf.CLIENT_INFORMATION.OCCUPATION_CODE
  is '职业代码';
comment on column slisintf.CLIENT_INFORMATION.PK_SERIAL
  is '客户流水号（写日志用）';
comment on column slisintf.CLIENT_INFORMATION.WORK_UNIT
  is '工作单位';
comment on column slisintf.CLIENT_INFORMATION.POSITION
  is '职务';
comment on column slisintf.CLIENT_INFORMATION.DEATH_DATE
  is '死亡日期';
comment on column slisintf.CLIENT_INFORMATION.REGISTER_PLACE
  is '户籍';
comment on column slisintf.CLIENT_INFORMATION.PHONETICIZE_LASTNAME
  is '姓拼音';
comment on column slisintf.CLIENT_INFORMATION.PHONETICIZE_FIRSTNAME
  is '名拼音';
comment on column slisintf.CLIENT_INFORMATION.CREATED_USER
  is '创建人';
comment on column slisintf.CLIENT_INFORMATION.CREATED_DATE
  is '创建时间';
comment on column slisintf.CLIENT_INFORMATION.UPDATED_USER
  is '更新人';
comment on column slisintf.CLIENT_INFORMATION.UPDATED_DATE
  is '更新时间';
comment on column slisintf.CLIENT_INFORMATION.INDUSTRY
  is '行业';
comment on column slisintf.CLIENT_INFORMATION.OCCUPATION_ADDED_DESC
  is '职业补充说明';
comment on column slisintf.CLIENT_INFORMATION.DATA_STATUS
  is '数据状态(1：在用；0：被合并)';
comment on column slisintf.CLIENT_INFORMATION.MERGE_TO_CLIENTNO
  is '被合并至的客户号';
alter table slisintf.CLIENT_INFORMATION
  add constraint PK_CLIENT_INFORMATION primary key (CLIENT_NO);
create index slisintf.IX_CLIENT_INFORMATION_1 on slisintf.CLIENT_INFORMATION (CLIENT_NAME);
--create index slisintf.IX_CLIENT_INFORMATION_2 on slisintf.CLIENT_INFORMATION (IDNO);
--create index slisintf.IX_CLIENT_INFORMATION_3 on slisintf.CLIENT_INFORMATION (PK_SERIAL);
--create index slisintf.IX_CLIENT_INFORMATION_4 on slisintf.CLIENT_INFORMATION (CLIENT_NAME, BIRTHDAY, IDNO);

prompt Creating slisintf.CLIENT_ADDRESS...
create table slisintf.CLIENT_ADDRESS
(
  ADDRESS_SEQ    VARCHAR2(20) not null,
  ADDRESS_TYPE   VARCHAR2(1) not null,
  CLIENT_NO      VARCHAR2(20) not null,
  COUNTRY_CODE   VARCHAR2(3) default '156' not null,
  PROVINCE_CODE  VARCHAR2(6),
  CITY_CODE      VARCHAR2(6),
  AREA_CODE      VARCHAR2(6),
  DETAIL_ADDRESS VARCHAR2(100) not null,
  POSTALCODE     VARCHAR2(6) not null,
  FULL_ADDRESS   VARCHAR2(150),
  ADDRESS_STATUS NUMBER(1) not null,
  CREATED_USER   VARCHAR2(100) not null,
  CREATED_DATE   DATE not null,
  UPDATED_USER   VARCHAR2(100) not null,
  UPDATED_DATE   DATE not null
)
;
comment on table slisintf.CLIENT_ADDRESS
  is '客户地址表';
comment on column slisintf.CLIENT_ADDRESS.ADDRESS_SEQ
  is '客户地址编号';
comment on column slisintf.CLIENT_ADDRESS.ADDRESS_TYPE
  is '地址类型';
comment on column slisintf.CLIENT_ADDRESS.CLIENT_NO
  is '客户号';
comment on column slisintf.CLIENT_ADDRESS.COUNTRY_CODE
  is '国家代码(默认中国)';
comment on column slisintf.CLIENT_ADDRESS.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.CLIENT_ADDRESS.CITY_CODE
  is '城市代码';
comment on column slisintf.CLIENT_ADDRESS.AREA_CODE
  is '区/县代码';
comment on column slisintf.CLIENT_ADDRESS.DETAIL_ADDRESS
  is '详细地址（街道，门牌号）';
comment on column slisintf.CLIENT_ADDRESS.POSTALCODE
  is '邮政编码';
comment on column slisintf.CLIENT_ADDRESS.FULL_ADDRESS
  is '完整地址';
comment on column slisintf.CLIENT_ADDRESS.ADDRESS_STATUS
  is '状态（1：在用；0：停用）';
comment on column slisintf.CLIENT_ADDRESS.CREATED_USER
  is '创建人';
comment on column slisintf.CLIENT_ADDRESS.CREATED_DATE
  is '创建时间';
comment on column slisintf.CLIENT_ADDRESS.UPDATED_USER
  is '更新人';
comment on column slisintf.CLIENT_ADDRESS.UPDATED_DATE
  is '更新时间';
alter table slisintf.CLIENT_ADDRESS
  add constraint PK_CLIENT_ADDRESS primary key (ADDRESS_SEQ);
create index slisintf.IX_CLIENT_ADDRESS_1 on slisintf.CLIENT_ADDRESS (CLIENT_NO);
--create index slisintf.IX_CLIENT_ADDRESS_2 on slisintf.CLIENT_ADDRESS (DETAIL_ADDRESS, ADDRESS_STATUS, ADDRESS_TYPE);
--create index slisintf.IX_CLIENT_ADDRESS_3 on slisintf.CLIENT_ADDRESS (FULL_ADDRESS, ADDRESS_STATUS, ADDRESS_TYPE);
--create index slisintf.IX_CLIENT_ADDRESS_4 on slisintf.CLIENT_ADDRESS (FULL_ADDRESS, ADDRESS_STATUS, ADDRESS_TYPE, CLIENT_NO);

prompt Creating slisintf.STAFF_INFO...
create table slisintf.STAFF_INFO
(
  EMP_NO              VARCHAR2(20) not null,
  DEPT_NO             VARCHAR2(20) not null,
  EMP_NAME            VARCHAR2(100),
  SEX_CODE            VARCHAR2(1),
  BIRTH_DATE          DATE,
  ID_TYPE             VARCHAR2(2),
  EMP_IDNO            VARCHAR2(50),
  HOME_ADDRESS        VARCHAR2(300),
  POSTCODE            VARCHAR2(6),
  HIRE_DATE           DATE,
  LEAVE_DATE          DATE,
  POSITION            VARCHAR2(2),
  RANK                VARCHAR2(4),
  CREATED_USER        VARCHAR2(100) not null,
  CREATED_DATE        DATE not null,
  UPDATED_USER        VARCHAR2(100) not null,
  UPDATED_DATE        DATE not null,
  IS_VALID            VARCHAR2(1),
  SECOND_ENTRY_FLAG   VARCHAR2(1) default 'N' not null,
  CONTRACT_SIGN_DATE  DATE,
  EMP_STATUS_CODE     VARCHAR2(4) not null,
  AGENT_QUALIFICATION VARCHAR2(1),
  AGENT_GRADE         VARCHAR2(2),
  AGENT_DATE          DATE
)
;
comment on table slisintf.STAFF_INFO
  is '人员信息';
comment on column slisintf.STAFF_INFO.EMP_NO
  is '员工代码';
comment on column slisintf.STAFF_INFO.DEPT_NO
  is '部门代码';
comment on column slisintf.STAFF_INFO.EMP_NAME
  is '姓名';
comment on column slisintf.STAFF_INFO.SEX_CODE
  is '性别';
comment on column slisintf.STAFF_INFO.BIRTH_DATE
  is '生日';
comment on column slisintf.STAFF_INFO.ID_TYPE
  is '证件类型代码';
comment on column slisintf.STAFF_INFO.EMP_IDNO
  is '证件号码';
comment on column slisintf.STAFF_INFO.HOME_ADDRESS
  is '家庭地址';
comment on column slisintf.STAFF_INFO.POSTCODE
  is '邮编';
comment on column slisintf.STAFF_INFO.HIRE_DATE
  is '入司时间';
comment on column slisintf.STAFF_INFO.LEAVE_DATE
  is '离职时间';
comment on column slisintf.STAFF_INFO.POSITION
  is '职务';
comment on column slisintf.STAFF_INFO.RANK
  is '职级';
comment on column slisintf.STAFF_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.STAFF_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.STAFF_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.STAFF_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.STAFF_INFO.IS_VALID
  is '是否有效';
comment on column slisintf.STAFF_INFO.SECOND_ENTRY_FLAG
  is '二次入司标志';
comment on column slisintf.STAFF_INFO.CONTRACT_SIGN_DATE
  is '合同签订日期';
comment on column slisintf.STAFF_INFO.EMP_STATUS_CODE
  is '人员状态代码';
comment on column slisintf.STAFF_INFO.AGENT_QUALIFICATION
  is '代审资格';
comment on column slisintf.STAFF_INFO.AGENT_GRADE
  is '代审等级';
comment on column slisintf.STAFF_INFO.AGENT_DATE
  is '代审协议时间';
alter table slisintf.STAFF_INFO
  add constraint PK_STAFF_INFO primary key (EMP_NO);

create index slisintf.IX_STAFF_INFO_1 on slisintf.STAFF_INFO (DEPT_NO);


prompt Creating slisintf.POLICY...
create table slisintf.POLICY
(
  POLICY_NO        VARCHAR2(20) not null,
  APPLICANT_NO     VARCHAR2(20) not null,
  BRANCH_CODE      VARCHAR2(10) not null,
  DEPARTMENT_NO    VARCHAR2(20) not null,
  DUTY_STATUS      VARCHAR2(2) not null,
  APL_OPTION       VARCHAR2(2),
  CHANNEL_TYPE     VARCHAR2(2),
  AGENT_NO         VARCHAR2(20),
  APPLY_NO         VARCHAR2(20) not null,
  OLD_POLICY_NO    VARCHAR2(20),
  APPLY_DATE       DATE not null,
  ISSUE_DATE       DATE not null,
  EFFECT_DATE      DATE not null,
  SERVICE_STATUS   VARCHAR2(1) default 'Y' not null,
  PK_SERIAL        VARCHAR2(20) not null,
  UPDATED_USER     VARCHAR2(50) not null,
  UPDATED_DATE     DATE default SYSDATE not null,
  CREATED_USER     VARCHAR2(50) not null,
  CREATED_DATE     DATE default SYSDATE not null,
  COMBINATION_CODE VARCHAR2(10),
  BUSINESS_SOURCE  VARCHAR2(3) not null
)
;
comment on table slisintf.POLICY
  is '保单';
comment on column slisintf.POLICY.POLICY_NO
  is '保单号';
comment on column slisintf.POLICY.APPLICANT_NO
  is '投保人客户号';
comment on column slisintf.POLICY.BRANCH_CODE
  is '机构代码';
comment on column slisintf.POLICY.DEPARTMENT_NO
  is '部门代码';
comment on column slisintf.POLICY.DUTY_STATUS
  is '保单责任状态';
comment on column slisintf.POLICY.APL_OPTION
  is '自垫选择';
comment on column slisintf.POLICY.CHANNEL_TYPE
  is '业务渠道';
comment on column slisintf.POLICY.AGENT_NO
  is '业务员编码';
comment on column slisintf.POLICY.APPLY_NO
  is '投保单号';
comment on column slisintf.POLICY.OLD_POLICY_NO
  is '原保单号';
comment on column slisintf.POLICY.APPLY_DATE
  is '投保日期';
comment on column slisintf.POLICY.ISSUE_DATE
  is '承保日期';
comment on column slisintf.POLICY.EFFECT_DATE
  is '保单生效日期';
comment on column slisintf.POLICY.SERVICE_STATUS
  is '保单服务状态:  Y：正常服务中; N：停止部分或全部服务，具体停止哪些服务，要根据暂停记录表去判断';
comment on column slisintf.POLICY.PK_SERIAL
  is '业务流水';
comment on column slisintf.POLICY.UPDATED_USER
  is '修改人';
comment on column slisintf.POLICY.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POLICY.CREATED_USER
  is '录入人';
comment on column slisintf.POLICY.CREATED_DATE
  is '录入日期';
comment on column slisintf.POLICY.COMBINATION_CODE
  is '产品组合代码';
comment on column slisintf.POLICY.BUSINESS_SOURCE
  is '业务来源';
alter table slisintf.POLICY
  add constraint PK_POLICY primary key (POLICY_NO);

create index slisintf.IX_POLICY_1 on slisintf.POLICY (BRANCH_CODE);
create index slisintf.IX_POLICY_2 on slisintf.POLICY (UPDATED_DATE);


prompt Creating slisintf.POLICY_CONTACT_INFO...
create table slisintf.POLICY_CONTACT_INFO
(
  POLICY_NO        VARCHAR2(20) not null,
  ADDRESS_SEQ      VARCHAR2(20),
  EMAIL_SEQ        VARCHAR2(20),
  PHONE_SEQ        VARCHAR2(20),
  UPDATED_USER     VARCHAR2(50) not null,
  UPDATED_DATE     DATE default SYSDATE not null,
  CREATED_USER     VARCHAR2(50) not null,
  CREATED_DATE     DATE default SYSDATE not null,
  PK_SERIAL        VARCHAR2(20) not null,
  SMS_SERVICE      VARCHAR2(1) default 'N',
  NEED_POS_LETTER  VARCHAR2(1) default 'Y' not null,
  MOBILE_PHONE_SEQ VARCHAR2(20),
  HOME_PHONE_SEQ   VARCHAR2(20),
  OFFICE_PHONE_SEQ VARCHAR2(20)
)
;
comment on table slisintf.POLICY_CONTACT_INFO
  is '保单联系信息';
comment on column slisintf.POLICY_CONTACT_INFO.POLICY_NO
  is '保单号';
comment on column slisintf.POLICY_CONTACT_INFO.ADDRESS_SEQ
  is '客户地址编号';
comment on column slisintf.POLICY_CONTACT_INFO.EMAIL_SEQ
  is '客户Email编号';
comment on column slisintf.POLICY_CONTACT_INFO.PHONE_SEQ
  is '客户联系电话编号';
comment on column slisintf.POLICY_CONTACT_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.POLICY_CONTACT_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POLICY_CONTACT_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.POLICY_CONTACT_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.POLICY_CONTACT_INFO.PK_SERIAL
  is '业务流水';
comment on column slisintf.POLICY_CONTACT_INFO.SMS_SERVICE
  is '短信服务选项';
comment on column slisintf.POLICY_CONTACT_INFO.NEED_POS_LETTER
  is '是否寄送保全信函';
comment on column slisintf.POLICY_CONTACT_INFO.MOBILE_PHONE_SEQ
  is '客户移动电话编号';
comment on column slisintf.POLICY_CONTACT_INFO.HOME_PHONE_SEQ
  is '客户家庭电话编号';
comment on column slisintf.POLICY_CONTACT_INFO.OFFICE_PHONE_SEQ
  is '客户办公电话编号';
alter table slisintf.POLICY_CONTACT_INFO
  add constraint PK_POLICY_CONTACT_INFO primary key (POLICY_NO);

create index slisintf.IX_POLICY_CONTACT_INFO_1 on slisintf.POLICY_CONTACT_INFO (ADDRESS_SEQ);


prompt Creating slisintf.POLICY_PREM_INFO...
create table slisintf.POLICY_PREM_INFO
(
  POLICY_NO        VARCHAR2(20) not null,
  PREM_STATUS      VARCHAR2(2) not null,
  CHARGING_METHOD  VARCHAR2(2) not null,
  PREM_SOURCE      VARCHAR2(1) not null,
  FREQUENCY        VARCHAR2(1) not null,
  PREM_DUE_DATE    DATE not null,
  MODAL_TOTAL_PREM NUMBER(16,2) default 0 not null,
  POLICY_BALANCE   NUMBER(16,2) default 0 not null,
  UPDATED_USER     VARCHAR2(50) not null,
  UPDATED_DATE     DATE default SYSDATE not null,
  CREATED_USER     VARCHAR2(50) not null,
  CREATED_DATE     DATE default SYSDATE not null,
  PK_SERIAL        VARCHAR2(20) not null
)
;
comment on table slisintf.POLICY_PREM_INFO
  is '保单缴费信息';
comment on column slisintf.POLICY_PREM_INFO.POLICY_NO
  is '保单号';
comment on column slisintf.POLICY_PREM_INFO.PREM_STATUS
  is '缴费状态';
comment on column slisintf.POLICY_PREM_INFO.CHARGING_METHOD
  is '下期保费收费方式';
comment on column slisintf.POLICY_PREM_INFO.PREM_SOURCE
  is '保费来源';
comment on column slisintf.POLICY_PREM_INFO.FREQUENCY
  is '频次';
comment on column slisintf.POLICY_PREM_INFO.PREM_DUE_DATE
  is '应缴日';
comment on column slisintf.POLICY_PREM_INFO.MODAL_TOTAL_PREM
  is '期缴保费合计';
comment on column slisintf.POLICY_PREM_INFO.POLICY_BALANCE
  is '保单余额';
comment on column slisintf.POLICY_PREM_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.POLICY_PREM_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POLICY_PREM_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.POLICY_PREM_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.POLICY_PREM_INFO.PK_SERIAL
  is '业务流水';
alter table slisintf.POLICY_PREM_INFO
  add constraint PK_POLICY_PREM_INFO primary key (POLICY_NO);

create index slisintf.IX_POLICY_PREM_INFO_1 on slisintf.POLICY_PREM_INFO (PREM_DUE_DATE);
create index slisintf.IX_POLICY_PREM_INFO_2 on slisintf.POLICY_PREM_INFO (MODAL_TOTAL_PREM);

prompt Creating slisintf.POLICY_PRODUCT...
create table slisintf.POLICY_PRODUCT
(
  POLICY_NO         VARCHAR2(20) not null,
  PROD_SEQ          NUMBER(2) not null,
  PRODUCT_CODE      VARCHAR2(10) not null,
  RELATIONSHIP      VARCHAR2(2) not null,
  INSURED_NO        VARCHAR2(20) not null,
  DUTY_STATUS       VARCHAR2(2) not null,
  LAPSE_REASON      VARCHAR2(2),
  EFFECT_DATE       DATE not null,
  UNITS             NUMBER(10),
  PRODUCT_LEVEL     VARCHAR2(2),
  BASE_SUM_INS      NUMBER(16,2) default 0 not null,
  DIVIDEND_SUM_INS  NUMBER(16,2) default 0 not null,
  COVERAGE_PERIOD   NUMBER(3) not null,
  MATURITY_DATE     DATE not null,
  SPECIAL_TERM      VARCHAR2(500),
  IS_PRIMARY_PLAN   VARCHAR2(1) not null,
  PK_SERIAL         VARCHAR2(20) not null,
  UPDATED_USER      VARCHAR2(50) not null,
  UPDATED_DATE      DATE default SYSDATE not null,
  CREATED_USER      VARCHAR2(50) not null,
  CREATED_DATE      DATE default SYSDATE not null,
  COVER_PERIOD_TYPE VARCHAR2(2),
  RELATION_DESC     VARCHAR2(80),
  RENEWAL_PERMIT    VARCHAR2(1),
  INSURED_SEQ       NUMBER(2) default 1 not null
)
;
comment on table slisintf.POLICY_PRODUCT
  is '保单险种信息';
comment on column slisintf.POLICY_PRODUCT.POLICY_NO
  is '保单号';
comment on column slisintf.POLICY_PRODUCT.PROD_SEQ
  is '产品序号';
comment on column slisintf.POLICY_PRODUCT.PRODUCT_CODE
  is '产品代码';
comment on column slisintf.POLICY_PRODUCT.RELATIONSHIP
  is '投保人与被保人关系';
comment on column slisintf.POLICY_PRODUCT.INSURED_NO
  is '被保人客户号';
comment on column slisintf.POLICY_PRODUCT.DUTY_STATUS
  is '责任状态';
comment on column slisintf.POLICY_PRODUCT.LAPSE_REASON
  is '失效原因';
comment on column slisintf.POLICY_PRODUCT.EFFECT_DATE
  is '生效日期';
comment on column slisintf.POLICY_PRODUCT.UNITS
  is '份数';
comment on column slisintf.POLICY_PRODUCT.PRODUCT_LEVEL
  is '险种档次';
comment on column slisintf.POLICY_PRODUCT.BASE_SUM_INS
  is '和客户约定的基本保额';
comment on column slisintf.POLICY_PRODUCT.DIVIDEND_SUM_INS
  is '红利保额';
comment on column slisintf.POLICY_PRODUCT.COVERAGE_PERIOD
  is '保险年期';
comment on column slisintf.POLICY_PRODUCT.MATURITY_DATE
  is '满期日期';
comment on column slisintf.POLICY_PRODUCT.SPECIAL_TERM
  is '特别约定条款';
comment on column slisintf.POLICY_PRODUCT.IS_PRIMARY_PLAN
  is '是否主险标志';
comment on column slisintf.POLICY_PRODUCT.PK_SERIAL
  is '业务流水';
comment on column slisintf.POLICY_PRODUCT.UPDATED_USER
  is '修改人';
comment on column slisintf.POLICY_PRODUCT.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POLICY_PRODUCT.CREATED_USER
  is '录入人';
comment on column slisintf.POLICY_PRODUCT.CREATED_DATE
  is '录入日期';
comment on column slisintf.POLICY_PRODUCT.COVER_PERIOD_TYPE
  is '保障期类型';
comment on column slisintf.POLICY_PRODUCT.RELATION_DESC
  is '被保人与投保人其他关系描述';
comment on column slisintf.POLICY_PRODUCT.RENEWAL_PERMIT
  is '自动续保';
comment on column slisintf.POLICY_PRODUCT.INSURED_SEQ
  is '被保人序号';
alter table slisintf.POLICY_PRODUCT
  add constraint PK_POLICY_PRODUCT primary key (POLICY_NO, PROD_SEQ);


create index slisintf.IX_POLICY_PRODUCT_1 on slisintf.POLICY_PRODUCT (PRODUCT_CODE);

prompt Creating slisintf.POLICY_PRODUCT_PREM...
create table slisintf.POLICY_PRODUCT_PREM
(
  POLICY_NO            VARCHAR2(20) not null,
  PROD_SEQ             NUMBER(2) not null,
  FREQUENCY            VARCHAR2(1) not null,
  PREM_SOURCE          VARCHAR2(1) not null,
  PREM_STATUS          VARCHAR2(2) not null,
  PREM_TERM            NUMBER(3) not null,
  ANN_STANDARD_PREM    NUMBER(16,2) default 0 not null,
  ANN_WEAK_ADD_PREM    NUMBER(16,2) default 0 not null,
  ANN_OCCU_ADD_PREM    NUMBER(16,2) default 0 not null,
  PERIOD_STANDARD_PREM NUMBER(16,2) default 0 not null,
  PERIOD_OCCU_ADD_PREM NUMBER(16,2) default 0 not null,
  PERIOD_WEAK_ADD_PREM NUMBER(16,2) default 0 not null,
  PERIOD_PREM_SUM      NUMBER(16,2) default 0 not null,
  PAY_TO_DATE          DATE not null,
  ADD_PREM_TERM        NUMBER(6),
  ADD_PREM_EFF_DATE    DATE,
  UPDATED_USER         VARCHAR2(50) not null,
  UPDATED_DATE         DATE default SYSDATE not null,
  CREATED_USER         VARCHAR2(50) not null,
  CREATED_DATE         DATE default SYSDATE not null,
  PK_SERIAL            VARCHAR2(20) not null,
  PREM_PERIOD_TYPE     VARCHAR2(2),
  SEX_CODE             VARCHAR2(1) not null,
  INS_AGE              NUMBER(3),
  OCCUPATION_CODE      VARCHAR2(7),
  PREM_DISCOUNT        NUMBER(7,6) default 1 not null,
  PAYOUT_FEE           NUMBER(16,2) default 0 not null,
  CONSULT_FEE          NUMBER(16,2) default 0 not null
)
;
comment on table slisintf.POLICY_PRODUCT_PREM
  is '保单险种缴费控制信息';
comment on column slisintf.POLICY_PRODUCT_PREM.POLICY_NO
  is '保单号';
comment on column slisintf.POLICY_PRODUCT_PREM.PROD_SEQ
  is '产品序号';
comment on column slisintf.POLICY_PRODUCT_PREM.FREQUENCY
  is '频次';
comment on column slisintf.POLICY_PRODUCT_PREM.PREM_SOURCE
  is '保费来源';
comment on column slisintf.POLICY_PRODUCT_PREM.PREM_STATUS
  is '缴费状态';
comment on column slisintf.POLICY_PRODUCT_PREM.PREM_TERM
  is '缴费期';
comment on column slisintf.POLICY_PRODUCT_PREM.ANN_STANDARD_PREM
  is '年缴标准保费';
comment on column slisintf.POLICY_PRODUCT_PREM.ANN_WEAK_ADD_PREM
  is '年缴弱体加费';
comment on column slisintf.POLICY_PRODUCT_PREM.ANN_OCCU_ADD_PREM
  is '年缴职业加费';
comment on column slisintf.POLICY_PRODUCT_PREM.PERIOD_STANDARD_PREM
  is '期缴标准保费';
comment on column slisintf.POLICY_PRODUCT_PREM.PERIOD_OCCU_ADD_PREM
  is '期缴职业加费';
comment on column slisintf.POLICY_PRODUCT_PREM.PERIOD_WEAK_ADD_PREM
  is '期缴弱体加费';
comment on column slisintf.POLICY_PRODUCT_PREM.PERIOD_PREM_SUM
  is '期缴保费合计';
comment on column slisintf.POLICY_PRODUCT_PREM.PAY_TO_DATE
  is '缴至日期';
comment on column slisintf.POLICY_PRODUCT_PREM.ADD_PREM_TERM
  is '加费期限';
comment on column slisintf.POLICY_PRODUCT_PREM.ADD_PREM_EFF_DATE
  is '加费生效日';
comment on column slisintf.POLICY_PRODUCT_PREM.UPDATED_USER
  is '修改人';
comment on column slisintf.POLICY_PRODUCT_PREM.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POLICY_PRODUCT_PREM.CREATED_USER
  is '录入人';
comment on column slisintf.POLICY_PRODUCT_PREM.CREATED_DATE
  is '录入日期';
comment on column slisintf.POLICY_PRODUCT_PREM.PK_SERIAL
  is '业务流水';
comment on column slisintf.POLICY_PRODUCT_PREM.PREM_PERIOD_TYPE
  is '缴费期类型';
comment on column slisintf.POLICY_PRODUCT_PREM.SEX_CODE
  is '被保人性别（用于保费计算）';
comment on column slisintf.POLICY_PRODUCT_PREM.INS_AGE
  is '被保人年龄（用于保费计算）';
comment on column slisintf.POLICY_PRODUCT_PREM.OCCUPATION_CODE
  is '被保人职业（用于保费计算）';
comment on column slisintf.POLICY_PRODUCT_PREM.PREM_DISCOUNT
  is '投保单传入，投保时根据规则确定';
comment on column slisintf.POLICY_PRODUCT_PREM.PAYOUT_FEE
  is '支出类费用';
comment on column slisintf.POLICY_PRODUCT_PREM.CONSULT_FEE
  is '咨询类费用';
alter table slisintf.POLICY_PRODUCT_PREM
  add constraint PK_POLICY_PRODUCT_PREM primary key (POLICY_NO, PROD_SEQ);

--create index slisintf.IX_POLICY_PRODUCT_PREM_1 on slisintf.POLICY_PRODUCT_PREM (PAY_TO_DATE);
--create index slisintf.IX_POLICY_PRODUCT_PREM_2 on slisintf.POLICY_PRODUCT_PREM (PK_SERIAL);


-- Create table
create table slisintf.POS_VIP_CLIENT
(
  CLIENT_NO        VARCHAR2(20) not null,
  VIP_TYPE         VARCHAR2(2) not null,
  VIP_GRADE        VARCHAR2(2) not null,
  VIP_EFFECT_DATE  DATE not null,
  VIP_END_DATE     DATE,
  VIP_PREM_SUM     NUMBER(14,2),
  UPDATED_USER     VARCHAR2(100) not null,
  UPDATED_DATE     DATE default SYSDATE not null,
  CREATED_USER     VARCHAR2(100) not null,
  CREATED_DATE     DATE default SYSDATE not null,
  PK_SERIAL        VARCHAR2(20) not null,
  IS_MANUAL_FLAG   VARCHAR2(1) default 'N' not null,
  REMARK           VARCHAR2(2000),
  VIP_BRANCH       VARCHAR2(10),
  BRANCH_CODE      VARCHAR2(10),
  DELAY_DEGRADE    VARCHAR2(1),
  UPGRADE_LEVEL    NUMBER(2),
  UPGRADE_REASON   VARCHAR2(2),
  UPGRADE_SET_DATE DATE
);
-- Add comments to the table 
comment on table slisintf.POS_VIP_CLIENT
  is 'VIP客户表';
-- Add comments to the columns 
comment on column slisintf.POS_VIP_CLIENT.CLIENT_NO
  is '客户号';
comment on column slisintf.POS_VIP_CLIENT.VIP_TYPE
  is 'vip类型';
comment on column slisintf.POS_VIP_CLIENT.VIP_GRADE
  is 'vip等级';
comment on column slisintf.POS_VIP_CLIENT.VIP_EFFECT_DATE
  is 'vip生效日期';
comment on column slisintf.POS_VIP_CLIENT.VIP_END_DATE
  is 'vip结束日期';
comment on column slisintf.POS_VIP_CLIENT.VIP_PREM_SUM
  is 'VIP客户保费';
comment on column slisintf.POS_VIP_CLIENT.UPDATED_USER
  is '修改人';
comment on column slisintf.POS_VIP_CLIENT.UPDATED_DATE
  is '修改日期';
comment on column slisintf.POS_VIP_CLIENT.CREATED_USER
  is '录入人';
comment on column slisintf.POS_VIP_CLIENT.CREATED_DATE
  is '录入日期';
comment on column slisintf.POS_VIP_CLIENT.PK_SERIAL
  is '数据主键';
comment on column slisintf.POS_VIP_CLIENT.IS_MANUAL_FLAG
  is '是否手工标注(Y是,N否)';
comment on column slisintf.POS_VIP_CLIENT.REMARK
  is '备注';
comment on column slisintf.POS_VIP_CLIENT.VIP_BRANCH
  is 'VIP机构';
comment on column slisintf.POS_VIP_CLIENT.BRANCH_CODE
  is '最近承保保单机构';
comment on column slisintf.POS_VIP_CLIENT.DELAY_DEGRADE
  is '暂缓降级标志';
comment on column slisintf.POS_VIP_CLIENT.UPGRADE_LEVEL
  is '上浮级别';
comment on column slisintf.POS_VIP_CLIENT.UPGRADE_REASON
  is '上浮原因';
comment on column slisintf.POS_VIP_CLIENT.UPGRADE_SET_DATE
  is '上浮评定时间';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.POS_VIP_CLIENT
  add constraint PK_POS_VIP_CLIENT primary key (CLIENT_NO, VIP_EFFECT_DATE);
  
create index slisintf.IX_POS_VIP_CLIENT_1 on slisintf.POS_VIP_CLIENT (VIP_TYPE);

  
prompt Creating slisintf.RN_POLICY_SERVICE_INFO...
create table slisintf.RN_POLICY_SERVICE_INFO
(
  POLICY_NO           VARCHAR2(20) not null,
  AGENT_NO            VARCHAR2(20),
  SERVICE_NO          VARCHAR2(20),
  SURPERVISE_NO       VARCHAR2(20),
  PK_SERIAL           VARCHAR2(20) not null,
  CREATED_USER        VARCHAR2(100) not null,
  CREATED_DATE        DATE not null,
  UPDATED_USER        VARCHAR2(100) not null,
  UPDATED_DATE        DATE not null,
  ORPHAN_MARK         VARCHAR2(1) not null,
  PAY_TIMES           NUMBER(4) not null,
  ACTURAL_PAY_TIMES   NUMBER(4),
  ASSIGN_MODE         VARCHAR2(2),
  LAST_ASSIGN_USER    VARCHAR2(100),
  LAST_ASSIGN_DATE    DATE,
  ASSIGN_RULE         VARCHAR2(2),
  ASSIGN_BRANCH_CODE  VARCHAR2(10),
  ASSIGN_CHANNEL_TYPE VARCHAR2(2)
)
;
comment on table slisintf.RN_POLICY_SERVICE_INFO
  is '续期保单服务状态表';
comment on column slisintf.RN_POLICY_SERVICE_INFO.POLICY_NO
  is '保单号';
comment on column slisintf.RN_POLICY_SERVICE_INFO.AGENT_NO
  is '业务员代码';
comment on column slisintf.RN_POLICY_SERVICE_INFO.SERVICE_NO
  is '服务人员代码';
comment on column slisintf.RN_POLICY_SERVICE_INFO.SURPERVISE_NO
  is '督导人员代码';
comment on column slisintf.RN_POLICY_SERVICE_INFO.PK_SERIAL
  is '数据主键';
comment on column slisintf.RN_POLICY_SERVICE_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.RN_POLICY_SERVICE_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.RN_POLICY_SERVICE_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.RN_POLICY_SERVICE_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ORPHAN_MARK
  is '0在职单1孤儿单';
comment on column slisintf.RN_POLICY_SERVICE_INFO.PAY_TIMES
  is '缴次';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ACTURAL_PAY_TIMES
  is '实际缴次';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ASSIGN_MODE
  is '分单模式';
comment on column slisintf.RN_POLICY_SERVICE_INFO.LAST_ASSIGN_USER
  is '上次分单用户';
comment on column slisintf.RN_POLICY_SERVICE_INFO.LAST_ASSIGN_DATE
  is '上次分单时间';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ASSIGN_RULE
  is '分单规则';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ASSIGN_BRANCH_CODE
  is '特殊分单机构';
comment on column slisintf.RN_POLICY_SERVICE_INFO.ASSIGN_CHANNEL_TYPE
  is '特殊分单渠道';
alter table slisintf.RN_POLICY_SERVICE_INFO
  add constraint PK_RN_POLICY_SERVICE_INFO primary key (POLICY_NO);

create index slisintf.IX_RN_POLICY_SERVICE_INFO_1 on slisintf.RN_POLICY_SERVICE_INFO (SERVICE_NO);


prompt Creating slisintf.RN_PREM_DUE_ACCOMPLISH...
create table slisintf.RN_PREM_DUE_ACCOMPLISH
(
  FLOW_SEQ             VARCHAR2(20) not null,
  ACCOMPLISH_STA_MONTH VARCHAR2(6),
  BRANCH_CODE          VARCHAR2(10),
  POLICY_NO            VARCHAR2(20),
  PROD_SEQ             NUMBER(2),
  AGENT_NO             VARCHAR2(20),
  DEPT_NO              VARCHAR2(20),
  SERVICE_NO           VARCHAR2(20),
  CHANNEL_TYPE         VARCHAR2(2),
  PRODUCT_CODE         VARCHAR2(10),
  SHORT_PRODUCT_FLAG   VARCHAR2(2),
  IS_PRIMARY_PLAN      VARCHAR2(2),
  PREM_DUE_DATE        DATE,
  EFFECT_DATE          DATE,
  COVERAGE_YEAR        NUMBER(3),
  PAY_TIMES            NUMBER(3),
  MODAL_TOTAL_PREM     NUMBER(16,2),
  FREQUENCY            VARCHAR2(1),
  CHARGING_METHOD      VARCHAR2(2),
  ORPHAN_MARK          VARCHAR2(1),
  ACCOMPLISH_STA_FLAG  VARCHAR2(1),
  UPDATED_USER         VARCHAR2(100) not null,
  UPDATED_DATE         DATE default sysdate not null,
  CREATED_USER         VARCHAR2(100) not null,
  CREATED_DATE         DATE default sysdate not null
)
;
comment on table slisintf.RN_PREM_DUE_ACCOMPLISH
  is '达成率应收表';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.FLOW_SEQ
  is '流水';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.ACCOMPLISH_STA_MONTH
  is '达成率年月';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.BRANCH_CODE
  is '管理机构';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.POLICY_NO
  is '保单号';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.PROD_SEQ
  is '产品序号';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.AGENT_NO
  is '业务员代码';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.DEPT_NO
  is '部门代码';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.SERVICE_NO
  is '服务人员代码';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.CHANNEL_TYPE
  is '渠道码';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.PRODUCT_CODE
  is '产品代码';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.SHORT_PRODUCT_FLAG
  is '长短险标识';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.IS_PRIMARY_PLAN
  is '是否主险';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.PREM_DUE_DATE
  is '应缴日';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.EFFECT_DATE
  is '生效日';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.COVERAGE_YEAR
  is '保单年度';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.PAY_TIMES
  is '缴费次数';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.MODAL_TOTAL_PREM
  is '期缴保费合计';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.FREQUENCY
  is '缴费频次';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.CHARGING_METHOD
  is '收费方式';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.ORPHAN_MARK
  is '在离职单标识';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.ACCOMPLISH_STA_FLAG
  is '达成率计算标识';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.UPDATED_USER
  is '修改人';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.UPDATED_DATE
  is '修改日期';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.CREATED_USER
  is '录入人';
comment on column slisintf.RN_PREM_DUE_ACCOMPLISH.CREATED_DATE
  is '录入日期';
alter table slisintf.RN_PREM_DUE_ACCOMPLISH
  add constraint PK_RN_PREM_DUE_ACCOMPLISH primary key (FLOW_SEQ);
--create index slisintf.IX_RN_PREM_DUE_ACCOMPLISH_1 on slisintf.RN_PREM_DUE_ACCOMPLISH (BRANCH_CODE);
--create index slisintf.IX_RN_PREM_DUE_ACCOMPLISH_2 on slisintf.RN_PREM_DUE_ACCOMPLISH (POLICY_NO);
--create index slisintf.IX_RN_PREM_DUE_ACCOMPLISH_3 on slisintf.RN_PREM_DUE_ACCOMPLISH (SERVICE_NO);
--create index slisintf.IX_RN_PREM_DUE_ACCOMPLISH_4 on slisintf.RN_PREM_DUE_ACCOMPLISH (CHANNEL_TYPE);
--create index slisintf.IX_RN_PREM_DUE_ACCOMPLISH_5 on slisintf.RN_PREM_DUE_ACCOMPLISH (PREM_DUE_DATE);

prompt Creating slisintf.BANK_CATEGORY...
create table slisintf.BANK_CATEGORY
(
  BANK_CATEGORY           VARCHAR2(12) not null,
  DESCRIPTION             VARCHAR2(100),
  UPDATED_USER            VARCHAR2(100) not null,
  UPDATED_DATE            DATE default SYSDATE not null,
  CREATED_USER            VARCHAR2(100) not null,
  CREATED_DATE            DATE default SYSDATE not null,
  USING_FLAG              VARCHAR2(1),
  CREDIT_TRANS_USING_FLAG VARCHAR2(1) default 'N' not null
)
;
comment on table slisintf.BANK_CATEGORY
  is '银行大类基表';
comment on column slisintf.BANK_CATEGORY.BANK_CATEGORY
  is '银行大类';
comment on column slisintf.BANK_CATEGORY.DESCRIPTION
  is '描述';
comment on column slisintf.BANK_CATEGORY.UPDATED_USER
  is '修改人';
comment on column slisintf.BANK_CATEGORY.UPDATED_DATE
  is '修改日期';
comment on column slisintf.BANK_CATEGORY.CREATED_USER
  is '录入人';
comment on column slisintf.BANK_CATEGORY.CREATED_DATE
  is '录入日期';
comment on column slisintf.BANK_CATEGORY.USING_FLAG
  is '启用标志:Y启用；N未启用';
comment on column slisintf.BANK_CATEGORY.CREDIT_TRANS_USING_FLAG
  is '信用卡转账启用标志(Y已启用,N未启用)';
alter table slisintf.BANK_CATEGORY
  add constraint PK_BANK_CATEGORY primary key (BANK_CATEGORY);

prompt Creating slisintf.BANK_INFO...
create table slisintf.BANK_INFO
(
  BANK_CODE       VARCHAR2(12) not null,
  DESCRIPTION     VARCHAR2(100),
  BANK_ABBR       VARCHAR2(100),
  UPDATED_USER    VARCHAR2(100) not null,
  UPDATED_DATE    DATE default SYSDATE not null,
  CREATED_USER    VARCHAR2(100) not null,
  CREATED_DATE    DATE default SYSDATE not null,
  BANK_CATEGORY   VARCHAR2(12),
  INVALID_FLAG    VARCHAR2(1),
  COUNTRY_CODE    VARCHAR2(3) not null,
  PROVINCE_CODE   VARCHAR2(6) not null,
  CITY_CODE       VARCHAR2(6),
  CMS_BRANCH_CODE VARCHAR2(10)
)
;
comment on table slisintf.BANK_INFO
  is '银行代码基表';
comment on column slisintf.BANK_INFO.BANK_CODE
  is '银行代码';
comment on column slisintf.BANK_INFO.DESCRIPTION
  is '描述';
comment on column slisintf.BANK_INFO.BANK_ABBR
  is '银行简称';
comment on column slisintf.BANK_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.BANK_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.BANK_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.BANK_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.BANK_INFO.INVALID_FLAG
  is '作废标志';
comment on column slisintf.BANK_INFO.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.BANK_INFO.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.BANK_INFO.CITY_CODE
  is '城市代码';
comment on column slisintf.BANK_INFO.CMS_BRANCH_CODE
  is '资金系统区域码';
alter table slisintf.BANK_INFO
  add constraint PK_BANK_INFO primary key (BANK_CODE);
--create index slisintf.IDX_BANK_INFO_01 on slisintf.BANK_INFO (BANK_CATEGORY);

prompt Creating slisintf.BRANCH_INFO...
create table slisintf.BRANCH_INFO
(
  BRANCH_CODE       VARCHAR2(10) not null,
  BRANCH_FULL_NAME  VARCHAR2(100) not null,
  BRANCH_NAME       VARCHAR2(60),
  BRANCH_SETUP_DATE DATE not null,
  BRANCH_CLOSE_DATE DATE,
  BRANCH_ADDRESS    VARCHAR2(300),
  PHONE             VARCHAR2(30),
  FAX               VARCHAR2(18),
  POSTCODE          VARCHAR2(6),
  EMAIL             VARCHAR2(60),
  BRANCH_LEVEL      VARCHAR2(4) not null,
  PARENT_BRANCH     VARCHAR2(10),
  IS_VALID          VARCHAR2(1) not null,
  CREATED_USER      VARCHAR2(100) not null,
  CREATED_DATE      DATE not null,
  UPDATED_USER      VARCHAR2(100) not null,
  UPDATED_DATE      DATE not null,
  BIZ_LICENSE_NAME  VARCHAR2(300),
  IS_HEADQUARTER    VARCHAR2(4),
  SERVICE_PHONE     VARCHAR2(30),
  SERVICE_ADDRESS   VARCHAR2(300),
  BIZ_LICENSE_NO    VARCHAR2(20),
  COUNTRY_CODE      VARCHAR2(3) not null,
  PROVINCE_CODE     VARCHAR2(6) not null,
  CITY_CODE         VARCHAR2(6) not null,
  AREA_CODE         VARCHAR2(6),
  BRANCH_CLASS      VARCHAR2(2),
  CIRC_BRANCH_CODE  VARCHAR2(30)
)
;
comment on table slisintf.BRANCH_INFO
  is '机构信息';
comment on column slisintf.BRANCH_INFO.BRANCH_CODE
  is '机构代码';
comment on column slisintf.BRANCH_INFO.BRANCH_FULL_NAME
  is '机构全称';
comment on column slisintf.BRANCH_INFO.BRANCH_NAME
  is '机构简称';
comment on column slisintf.BRANCH_INFO.BRANCH_SETUP_DATE
  is '成立日期';
comment on column slisintf.BRANCH_INFO.BRANCH_CLOSE_DATE
  is '关闭日期';
comment on column slisintf.BRANCH_INFO.BRANCH_ADDRESS
  is '机构地址';
comment on column slisintf.BRANCH_INFO.PHONE
  is '电话';
comment on column slisintf.BRANCH_INFO.FAX
  is '传真';
comment on column slisintf.BRANCH_INFO.POSTCODE
  is '邮编';
comment on column slisintf.BRANCH_INFO.EMAIL
  is 'EMail';
comment on column slisintf.BRANCH_INFO.BRANCH_LEVEL
  is '机构层级';
comment on column slisintf.BRANCH_INFO.PARENT_BRANCH
  is '上级机构';
comment on column slisintf.BRANCH_INFO.IS_VALID
  is '是否有效';
comment on column slisintf.BRANCH_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.BRANCH_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.BRANCH_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.BRANCH_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.BRANCH_INFO.BIZ_LICENSE_NAME
  is '营业执照名称';
comment on column slisintf.BRANCH_INFO.IS_HEADQUARTER
  is '是否本部';
comment on column slisintf.BRANCH_INFO.SERVICE_PHONE
  is '客户服务电话';
comment on column slisintf.BRANCH_INFO.SERVICE_ADDRESS
  is '客户服务投递地址';
comment on column slisintf.BRANCH_INFO.BIZ_LICENSE_NO
  is '营业执照编码';
comment on column slisintf.BRANCH_INFO.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.BRANCH_INFO.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.BRANCH_INFO.CITY_CODE
  is '城市代码';
comment on column slisintf.BRANCH_INFO.AREA_CODE
  is '区/县代码';
comment on column slisintf.BRANCH_INFO.BRANCH_CLASS
  is '机构类型：01本级营服;02营销服务部;03支公司';
comment on column slisintf.BRANCH_INFO.CIRC_BRANCH_CODE
  is '保监机构代码';
alter table slisintf.BRANCH_INFO
  add constraint PK_BRANCH_INFO primary key (BRANCH_CODE);
--create index slisintf.IX_BRANCH_INFO_2 on slisintf.BRANCH_INFO (PARENT_BRANCH);
--create index slisintf.IX_BRANCH_INFO_3 on slisintf.BRANCH_INFO (BRANCH_CODE, BRANCH_NAME);

prompt Creating slisintf.DEPARTMENT_INFO...
create table slisintf.DEPARTMENT_INFO
(
  DEPT_NO         VARCHAR2(20) not null,
  DEPT_FULL_NAME  VARCHAR2(100),
  DEPT_NAME       VARCHAR2(60),
  DEPT_SETUP_DATE DATE,
  DEPT_CLOSE_DATE DATE,
  DEPT_ADDRESS    VARCHAR2(300),
  PHONE           VARCHAR2(30),
  FAX             VARCHAR2(18),
  POSTCODE        VARCHAR2(6),
  DEPT_LEVEL      VARCHAR2(4),
  DEPT_TYPE       VARCHAR2(2) not null,
  PARENT_DEPT     VARCHAR2(20),
  BRANCH_CODE     VARCHAR2(10) not null,
  IS_VALID        VARCHAR2(1) not null,
  CREATED_USER    VARCHAR2(100) not null,
  CREATED_DATE    DATE not null,
  UPDATED_USER    VARCHAR2(100) not null,
  UPDATED_DATE    DATE not null,
  CHANNEL_TYPE    VARCHAR2(2) not null,
  DEPT_STATUS     VARCHAR2(1) not null,
  AGENT_START     DATE,
  AGENT_END       DATE
)
;
comment on table slisintf.DEPARTMENT_INFO
  is '部门信息';
comment on column slisintf.DEPARTMENT_INFO.DEPT_NO
  is '部门代码';
comment on column slisintf.DEPARTMENT_INFO.DEPT_FULL_NAME
  is '部门全称';
comment on column slisintf.DEPARTMENT_INFO.DEPT_NAME
  is '部门简称';
comment on column slisintf.DEPARTMENT_INFO.DEPT_SETUP_DATE
  is '成立日期';
comment on column slisintf.DEPARTMENT_INFO.DEPT_CLOSE_DATE
  is '停业日期';
comment on column slisintf.DEPARTMENT_INFO.DEPT_ADDRESS
  is '部门地址';
comment on column slisintf.DEPARTMENT_INFO.PHONE
  is '电话';
comment on column slisintf.DEPARTMENT_INFO.FAX
  is '传真';
comment on column slisintf.DEPARTMENT_INFO.POSTCODE
  is '邮编';
comment on column slisintf.DEPARTMENT_INFO.DEPT_LEVEL
  is '部门层级';
comment on column slisintf.DEPARTMENT_INFO.DEPT_TYPE
  is '部门类型';
comment on column slisintf.DEPARTMENT_INFO.PARENT_DEPT
  is '上级部门';
comment on column slisintf.DEPARTMENT_INFO.BRANCH_CODE
  is '隶属机构';
comment on column slisintf.DEPARTMENT_INFO.IS_VALID
  is '是否有效';
comment on column slisintf.DEPARTMENT_INFO.CREATED_USER
  is '录入人';
comment on column slisintf.DEPARTMENT_INFO.CREATED_DATE
  is '录入日期';
comment on column slisintf.DEPARTMENT_INFO.UPDATED_USER
  is '修改人';
comment on column slisintf.DEPARTMENT_INFO.UPDATED_DATE
  is '修改日期';
comment on column slisintf.DEPARTMENT_INFO.CHANNEL_TYPE
  is '渠道类型';
comment on column slisintf.DEPARTMENT_INFO.DEPT_STATUS
  is '部门状态';
comment on column slisintf.DEPARTMENT_INFO.AGENT_START
  is '代审签订日期';
comment on column slisintf.DEPARTMENT_INFO.AGENT_END
  is '代审截止日期';
alter table slisintf.DEPARTMENT_INFO
  add constraint PK_DEPARTMENT_INFO primary key (DEPT_NO);
  
create index slisintf.IX_DEPARTMENT_INFO_1 on slisintf.DEPARTMENT_INFO (BRANCH_CODE);  
create index slisintf.IX_DEPARTMENT_INFO_2 on slisintf.DEPARTMENT_INFO (CHANNEL_TYPE);



prompt Creating slisintf.ADDRESS_TYPE...
create table slisintf.ADDRESS_TYPE
(
  ADDRESS_TYPE      VARCHAR2(1) not null,
  ADDRESS_TYPE_NAME VARCHAR2(16) not null,
  UPDATED_DATE      DATE not null,
  UPDATED_USER      VARCHAR2(100) not null,
  CREATED_DATE      DATE not null,
  CREATED_USER      VARCHAR2(100) not null
)
;
comment on table slisintf.ADDRESS_TYPE
  is '地址类型定义表';
comment on column slisintf.ADDRESS_TYPE.ADDRESS_TYPE
  is '地址类型';
comment on column slisintf.ADDRESS_TYPE.ADDRESS_TYPE_NAME
  is '地址类型名称';
comment on column slisintf.ADDRESS_TYPE.UPDATED_DATE
  is '更新时间';
comment on column slisintf.ADDRESS_TYPE.UPDATED_USER
  is '更新人';
comment on column slisintf.ADDRESS_TYPE.CREATED_DATE
  is '创建时间';
comment on column slisintf.ADDRESS_TYPE.CREATED_USER
  is '创建人';
alter table slisintf.ADDRESS_TYPE
  add constraint PK_ADDRESS_TYPE primary key (ADDRESS_TYPE);

prompt Creating slisintf.COUNTRY...
create table slisintf.COUNTRY
(
  COUNTRY_CODE  VARCHAR2(3) not null,
  COUNTRY_NAME  VARCHAR2(40) not null,
  CREATED_USER  VARCHAR2(100) not null,
  CREATED_DATE  DATE not null,
  UPDATED_USER  VARCHAR2(100) not null,
  UPDATED_DATE  DATE not null,
  COUNTRY_ALIAS VARCHAR2(100),
  COUNTRY_TYPE  VARCHAR2(2),
  COUNTRY_ABBR  VARCHAR2(100)
)
;
comment on table slisintf.COUNTRY
  is '国家代码定义表';
comment on column slisintf.COUNTRY.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.COUNTRY.COUNTRY_NAME
  is '国家名称';
comment on column slisintf.COUNTRY.CREATED_USER
  is '创建人';
comment on column slisintf.COUNTRY.CREATED_DATE
  is '创建时间';
comment on column slisintf.COUNTRY.UPDATED_USER
  is '更新人';
comment on column slisintf.COUNTRY.UPDATED_DATE
  is '更新时间';
comment on column slisintf.COUNTRY.COUNTRY_ALIAS
  is '国家英文名称';
comment on column slisintf.COUNTRY.COUNTRY_TYPE
  is '国家类别（0拒保国家，1正常承保国家，2保额上限为10万的国家，3申根协议国）';
comment on column slisintf.COUNTRY.COUNTRY_ABBR
  is '国家英文名称缩写';
alter table slisintf.COUNTRY
  add constraint PK_COUNTRY primary key (COUNTRY_CODE);
--create index slisintf.IX_COUNTRY_1 on slisintf.COUNTRY (COUNTRY_NAME);

prompt Creating slisintf.PROVINCE...
create table slisintf.PROVINCE
(
  PROVINCE_CODE VARCHAR2(6) not null,
  PROVINCE_NAME VARCHAR2(50) not null,
  COUNTRY_CODE  VARCHAR2(3) not null,
  CREATED_USER  VARCHAR2(100) not null,
  CREATED_DATE  DATE not null,
  UPDATED_USER  VARCHAR2(100) not null,
  UPDATED_DATE  DATE not null,
  IS_VALID      VARCHAR2(1) default 'Y' not null
)
;
comment on table slisintf.PROVINCE
  is '省/直辖市定义表';
comment on column slisintf.PROVINCE.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.PROVINCE.PROVINCE_NAME
  is '省/直辖市名称';
comment on column slisintf.PROVINCE.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.PROVINCE.CREATED_USER
  is '创建人';
comment on column slisintf.PROVINCE.CREATED_DATE
  is '创建时间';
comment on column slisintf.PROVINCE.UPDATED_USER
  is '更新人';
comment on column slisintf.PROVINCE.UPDATED_DATE
  is '更新时间';
comment on column slisintf.PROVINCE.IS_VALID
  is '是否有效';
alter table slisintf.PROVINCE
  add constraint PK_PROVINCE primary key (PROVINCE_CODE, COUNTRY_CODE);
--create index slisintf.IX_PROVINCE_1 on slisintf.PROVINCE (PROVINCE_NAME);

prompt Creating slisintf.CITY...
create table slisintf.CITY
(
  CITY_CODE     VARCHAR2(6) not null,
  CITY_NAME     VARCHAR2(50) not null,
  PROVINCE_CODE VARCHAR2(6) not null,
  COUNTRY_CODE  VARCHAR2(3) not null,
  CREATED_USER  VARCHAR2(100) not null,
  CREATED_DATE  DATE not null,
  UPDATED_USER  VARCHAR2(100) not null,
  UPDATED_DATE  DATE not null,
  IS_VALID      VARCHAR2(1) default 'Y' not null
)
;
comment on table slisintf.CITY
  is '城市定义表';
comment on column slisintf.CITY.CITY_CODE
  is '城市代码';
comment on column slisintf.CITY.CITY_NAME
  is '城市名称';
comment on column slisintf.CITY.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.CITY.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.CITY.CREATED_USER
  is '创建人';
comment on column slisintf.CITY.CREATED_DATE
  is '创建时间';
comment on column slisintf.CITY.UPDATED_USER
  is '更新人';
comment on column slisintf.CITY.UPDATED_DATE
  is '更新时间';
comment on column slisintf.CITY.IS_VALID
  is '是否有效';
alter table slisintf.CITY
  add constraint PK_CITY primary key (CITY_CODE, PROVINCE_CODE, COUNTRY_CODE);
--create index slisintf.IX_CITY_1 on slisintf.CITY (CITY_NAME);

prompt Creating slisintf.AREA_DEFINE...
create table slisintf.AREA_DEFINE
(
  AREA_CODE     VARCHAR2(6) not null,
  CITY_CODE     VARCHAR2(6) not null,
  PROVINCE_CODE VARCHAR2(6) not null,
  COUNTRY_CODE  VARCHAR2(3) not null,
  AREA_NAME     VARCHAR2(30) not null,
  CREATED_USER  VARCHAR2(100) not null,
  CREATED_DATE  DATE not null,
  UPDATED_USER  VARCHAR2(100) not null,
  UPDATED_DATE  DATE not null,
  IS_VALID      VARCHAR2(1) default 'Y' not null
)
;
comment on table slisintf.AREA_DEFINE
  is '区/县定义表';
comment on column slisintf.AREA_DEFINE.AREA_CODE
  is '区/县代码';
comment on column slisintf.AREA_DEFINE.CITY_CODE
  is '城市代码';
comment on column slisintf.AREA_DEFINE.PROVINCE_CODE
  is '省/直辖市代码';
comment on column slisintf.AREA_DEFINE.COUNTRY_CODE
  is '国家代码';
comment on column slisintf.AREA_DEFINE.AREA_NAME
  is '区/县名称';
comment on column slisintf.AREA_DEFINE.CREATED_USER
  is '创建人';
comment on column slisintf.AREA_DEFINE.CREATED_DATE
  is '创建时间';
comment on column slisintf.AREA_DEFINE.UPDATED_USER
  is '更新人';
comment on column slisintf.AREA_DEFINE.UPDATED_DATE
  is '更新时间';
comment on column slisintf.AREA_DEFINE.IS_VALID
  is '是否有效';
alter table slisintf.AREA_DEFINE
  add constraint PK_AREA_DEFINE primary key (AREA_CODE, CITY_CODE, PROVINCE_CODE, COUNTRY_CODE);
--create index slisintf.IX_AREA_DEFINE_1 on slisintf.AREA_DEFINE (AREA_NAME);

prompt Creating slisintf.CHANNEL_TYPE_TBL...
create table slisintf.CHANNEL_TYPE_TBL
(
  CHANNEL_TYPE VARCHAR2(2) not null,
  DESCRIPTION  VARCHAR2(100),
  UPDATED_USER VARCHAR2(100) not null,
  UPDATED_DATE DATE default SYSDATE not null,
  CREATED_USER VARCHAR2(100) not null,
  CREATED_DATE DATE default SYSDATE not null
)
;
comment on table slisintf.CHANNEL_TYPE_TBL
  is '个险销售的渠道类型';
comment on column slisintf.CHANNEL_TYPE_TBL.CHANNEL_TYPE
  is '渠道类型';
comment on column slisintf.CHANNEL_TYPE_TBL.DESCRIPTION
  is '描述';
comment on column slisintf.CHANNEL_TYPE_TBL.UPDATED_USER
  is '修改人';
comment on column slisintf.CHANNEL_TYPE_TBL.UPDATED_DATE
  is '修改日期';
comment on column slisintf.CHANNEL_TYPE_TBL.CREATED_USER
  is '录入人';
comment on column slisintf.CHANNEL_TYPE_TBL.CREATED_DATE
  is '录入日期';
alter table slisintf.CHANNEL_TYPE_TBL
  add constraint PK_CHANNEL_TYPE_TBL primary key (CHANNEL_TYPE);



-- Create table
create table slisintf.RN_ASSIGN_MODE
(
  ASSIGN_MODE  VARCHAR2(2) not null,
  DESCRIPTION  VARCHAR2(100) not null,
  CREATED_USER VARCHAR2(100) not null,
  CREATED_DATE DATE not null,
  UPDATED_USER VARCHAR2(100) not null,
  UPDATED_DATE DATE not null
);
-- Add comments to the table 
comment on table slisintf.RN_ASSIGN_MODE
  is '分单模式基表';
-- Add comments to the columns 
comment on column slisintf.RN_ASSIGN_MODE.ASSIGN_MODE
  is '分单模式代码';
comment on column slisintf.RN_ASSIGN_MODE.DESCRIPTION
  is '描述';
comment on column slisintf.RN_ASSIGN_MODE.CREATED_USER
  is '录入人';
comment on column slisintf.RN_ASSIGN_MODE.CREATED_DATE
  is '录入日期';
comment on column slisintf.RN_ASSIGN_MODE.UPDATED_USER
  is '修改人';
comment on column slisintf.RN_ASSIGN_MODE.UPDATED_DATE
  is '修改日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.RN_ASSIGN_MODE
  add constraint PK_RN_ASSIGN_MODE primary key (ASSIGN_MODE);

-- Create table
create table slisintf.RN_ASSIGN_RULE
(
  ASSIGN_RULE  VARCHAR2(2) not null,
  DESCRIPTION  VARCHAR2(100) not null,
  CREATED_USER VARCHAR2(100) not null,
  CREATED_DATE DATE not null,
  UPDATED_USER VARCHAR2(100) not null,
  UPDATED_DATE DATE not null
);
-- Add comments to the table 
comment on table slisintf.RN_ASSIGN_RULE
  is '分单规则';
-- Add comments to the columns 
comment on column slisintf.RN_ASSIGN_RULE.ASSIGN_RULE
  is '分单规则';
comment on column slisintf.RN_ASSIGN_RULE.DESCRIPTION
  is '描述';
comment on column slisintf.RN_ASSIGN_RULE.CREATED_USER
  is '录入人';
comment on column slisintf.RN_ASSIGN_RULE.CREATED_DATE
  is '录入日期';
comment on column slisintf.RN_ASSIGN_RULE.UPDATED_USER
  is '修改人';
comment on column slisintf.RN_ASSIGN_RULE.UPDATED_DATE
  is '修改日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.RN_ASSIGN_RULE
  add constraint PK_RN_ASSIGN_RULE primary key (ASSIGN_RULE);

-- Create table
create table slisintf.POS_VIP_TYPE
(
  vip_type     VARCHAR2(2) not null,
  description  VARCHAR2(100),
  updated_user VARCHAR2(100) not null,
  updated_date DATE default SYSDATE not null,
  created_user VARCHAR2(100) not null,
  created_date DATE default SYSDATE not null
);
-- Add comments to the table 
comment on table slisintf.POS_VIP_TYPE
  is 'VIP类型';
-- Add comments to the columns 
comment on column slisintf.POS_VIP_TYPE.vip_type
  is 'vip类型';
comment on column slisintf.POS_VIP_TYPE.description
  is '描述';
comment on column slisintf.POS_VIP_TYPE.updated_user
  is '修改人';
comment on column slisintf.POS_VIP_TYPE.updated_date
  is '修改日期';
comment on column slisintf.POS_VIP_TYPE.created_user
  is '录入人';
comment on column slisintf.POS_VIP_TYPE.created_date
  is '录入日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.POS_VIP_TYPE
  add constraint PK_POS_VIP_TYPE primary key (VIP_TYPE);

-- Create table
create table slisintf.POS_VIP_GRADE
(
  vip_grade    VARCHAR2(2) not null,
  description  VARCHAR2(100),
  updated_user VARCHAR2(100) not null,
  updated_date DATE default SYSDATE not null,
  created_user VARCHAR2(100) not null,
  created_date DATE default SYSDATE not null
);
-- Add comments to the table 
comment on table slisintf.POS_VIP_GRADE
  is 'VIP等级';
-- Add comments to the columns 
comment on column slisintf.POS_VIP_GRADE.vip_grade
  is 'vip等级';
comment on column slisintf.POS_VIP_GRADE.description
  is '描述';
comment on column slisintf.POS_VIP_GRADE.updated_user
  is '修改人';
comment on column slisintf.POS_VIP_GRADE.updated_date
  is '修改日期';
comment on column slisintf.POS_VIP_GRADE.created_user
  is '录入人';
comment on column slisintf.POS_VIP_GRADE.created_date
  is '录入日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.POS_VIP_GRADE
  add constraint PK_POS_VIP_GRADE primary key (VIP_GRADE);

-- Create table
create table slisintf.RN_POLICY_SERVICER_CHG_RECORD
(
  change_seq         VARCHAR2(20) not null,
  policy_no          VARCHAR2(20) not null,
  branch_code        VARCHAR2(10) not null,
  earlier_agent      VARCHAR2(20),
  next_agent         VARCHAR2(20),
  change_date        DATE not null,
  change_mode        VARCHAR2(1) not null,
  prem_due_date      DATE,
  created_user       VARCHAR2(100) not null,
  created_date       DATE not null,
  updated_user       VARCHAR2(100) not null,
  updated_date       DATE not null,
  pk_serial          VARCHAR2(20) not null,
  assign_policy_type VARCHAR2(2)
);
-- Add comments to the table 
comment on table slisintf.RN_POLICY_SERVICER_CHG_RECORD
  is '保单服务人员交接记录表';
-- Add comments to the columns 
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.change_seq
  is '交接流水号';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.policy_no
  is '保单号';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.branch_code
  is '机构代码';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.earlier_agent
  is '交出业务员';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.next_agent
  is '接收业务员';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.change_date
  is '交接日期';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.change_mode
  is '0 业务员 1 督导';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.prem_due_date
  is '应缴日';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.created_user
  is '录入人';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.created_date
  is '录入日期';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.updated_user
  is '修改人';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.updated_date
  is '修改日期';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.pk_serial
  is '数据主键';
comment on column slisintf.RN_POLICY_SERVICER_CHG_RECORD.assign_policy_type
  is '分单保单类别';
-- Create/Recreate primary, unique and foreign key constraints 
alter table slisintf.RN_POLICY_SERVICER_CHG_RECORD
  add constraint PK_RN_POLICY_SERVICER_CHG_RECO primary key (CHANGE_SEQ);

create index slisintf.IX_RN_POLICY_SVCER_CHG_REC_1 on slisintf.RN_POLICY_SERVICER_CHG_RECORD (POLICY_NO);


create table SLISINTF.GGSYNC_SLIS
(
  SOURCE_DB  VARCHAR2(20) not null,
  TARGET_DB  VARCHAR2(20) not null,
  EXT_NAME   VARCHAR2(20),
  DPE_NAME   VARCHAR2(20),
  REP_NAME   VARCHAR2(20),
  CHECK_FLAG VARCHAR2(20),
  CHECK_TIME VARCHAR2(30) default SYSDATE,
  REMARK     VARCHAR2(10)
);
alter table SLISINTF.GGSYNC_SLIS
  add constraint PK_GGSYNC_SLIS primary key (SOURCE_DB, TARGET_DB);

create table SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY
(
  change_apply_no        VARCHAR2(20) not null,
  emp_no                 VARCHAR2(20) not null,
  emp_status_code        VARCHAR2(4) not null,
  dept_no                VARCHAR2(20) not null,
  rank_code              VARCHAR2(4) not null,
  post_code              VARCHAR2(3),
  bank_flag              VARCHAR2(1) not null,
  salary_level           VARCHAR2(2),
  subsidy_code           VARCHAR2(2) not null,
  start_date             DATE not null,
  change_type            VARCHAR2(2),
  change_status          VARCHAR2(1) not null,
  pk_serial              VARCHAR2(20) not null,
  updated_user           VARCHAR2(100) not null,
  updated_date           DATE not null,
  created_user           VARCHAR2(100) not null,
  created_date           DATE not null,
  apply_date             DATE,
  apply_reason           VARCHAR2(1000),
  agent_qualification    VARCHAR2(1),
  agent_grade            VARCHAR2(2),
  agent_date             DATE,
  agent_flag             VARCHAR2(1),
  agent_salary_level_k2  VARCHAR2(2),
  agent_salary_level_k3  VARCHAR2(2),
  agent_salary_eff_date  DATE,
  market_flag            VARCHAR2(1),
  market_salary_level    VARCHAR2(2),
  market_salary_eff_date DATE
);
comment on table SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY
  is '续收人员变更轨迹记录';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.change_apply_no
  is '变更申请流水号';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.emp_no
  is '人员代码';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.emp_status_code
  is '人员状态';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.dept_no
  is '部门';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.rank_code
  is '职级';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.post_code
  is '岗位';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.bank_flag
  is '是否银代兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.salary_level
  is '薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.subsidy_code
  is '特殊津贴代码';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.start_date
  is '开始时间';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.change_type
  is '变更类型';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.change_status
  is '申请状态';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.pk_serial
  is '数据主键';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.updated_user
  is '修改人';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.updated_date
  is '修改日期';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.created_user
  is '录入人';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.created_date
  is '录入日期';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.apply_date
  is '申请时间';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.apply_reason
  is '申请原因';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_qualification
  is '代审资格';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_grade
  is '代审等级';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_date
  is '代审协议时间';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_flag
  is '是否经代兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_salary_level_k2
  is '经代兼收宽二薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_salary_level_k3
  is '经代兼收宽三薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.agent_salary_eff_date
  is '经代薪资起始时间';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.market_flag
  is '是否个险兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.market_salary_level
  is '薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY.market_salary_eff_date
  is '个险兼收薪资起始时间';
alter table SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY
  add constraint PK_RENEWAL_STAFF_CHANGE_HISTOR primary key (CHANGE_APPLY_NO);
create index SLISINTF.IX_RENEWAL_STAFF_CH_1 on SLISINTF.RENEWAL_STAFF_CHANGE_HISTORY (EMP_NO);

create table SLISINTF.RENEWAL_STAFF_INFO_OTHER
(
  emp_no                     VARCHAR2(20) not null,
  emergency_contact          VARCHAR2(100) not null,
  emergency_phone            VARCHAR2(20) not null,
  subsidy_code               VARCHAR2(2) not null,
  salary_level               VARCHAR2(2),
  bank_flag                  VARCHAR2(1) not null,
  work_date                  DATE,
  rank_eff_date              DATE,
  salary_eff_date            DATE,
  updated_user               VARCHAR2(100) not null,
  updated_date               DATE not null,
  created_user               VARCHAR2(100) not null,
  created_date               DATE not null,
  agent_flag                 VARCHAR2(1) default 'N' not null,
  agent_salary_level_k2      VARCHAR2(2),
  agent_salary_level_k3      VARCHAR2(2),
  agent_salary_eff_date      DATE,
  market_flag                VARCHAR2(1),
  market_salary_level        VARCHAR2(2),
  market_salary_eff_date     DATE,
  card_sell_flag             VARCHAR2(1),
  id_valid_date              DATE,
  id_is_long_valid           VARCHAR2(1),
  contract_type_id           VARCHAR2(2),
  agent_contract_date        DATE,
  labour_contract_renew_date DATE
);
comment on table SLISINTF.RENEWAL_STAFF_INFO_OTHER
  is '续收人员附加信息';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.emp_no
  is '人员代码';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.emergency_contact
  is '紧急联系人';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.emergency_phone
  is '紧急联系人电话';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.subsidy_code
  is '特殊津贴代码';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.salary_level
  is '兼收人员薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.bank_flag
  is '是否银代兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.work_date
  is '上岗日期';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.rank_eff_date
  is '职级起始时间';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.salary_eff_date
  is '薪资起始时间';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.updated_user
  is '修改人';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.updated_date
  is '修改日期';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.created_user
  is '录入人';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.created_date
  is '录入日期';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.agent_flag
  is '是否经代兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.agent_salary_level_k2
  is '经代兼收宽二薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.agent_salary_level_k3
  is '经代兼收宽三薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.agent_salary_eff_date
  is '经代薪资起始时间';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.market_flag
  is '是否个险兼收人员';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.market_salary_level
  is '薪资级别';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.market_salary_eff_date
  is '个险兼收薪资起始时间';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.card_sell_flag
  is '激活卡销售资格:y 有,n 无';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.id_valid_date
  is '证件有效期';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.id_is_long_valid
  is '证件是否长期有效(Y-是;N-否)';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.contract_type_id
  is '合同类型';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.agent_contract_date
  is '代理合同签订日期';
comment on column SLISINTF.RENEWAL_STAFF_INFO_OTHER.labour_contract_renew_date
  is '劳动合同续签日期';
alter table SLISINTF.RENEWAL_STAFF_INFO_OTHER
  add constraint PK_RENEWAL_STAFF_INFO_OTHER primary key (EMP_NO);

create table SLISINTF.BANK_STAFF_INFO_OTHER
(
  emp_no             VARCHAR2(20) not null,
  emp_attribute_code VARCHAR2(2) not null,
  rank_eff_date      DATE not null,
  same_trade_year    VARCHAR2(2),
  updated_user       VARCHAR2(100) not null,
  updated_date       DATE not null,
  created_user       VARCHAR2(100) not null,
  created_date       DATE not null,
  card_sell_flag     VARCHAR2(1)
);
comment on table SLISINTF.BANK_STAFF_INFO_OTHER
  is '银代人员附加信息';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.emp_no
  is '人员代码';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.emp_attribute_code
  is '银代人员特性代码:01-一般银代;02-创新银代;03-经纪公司代理;04-PWM客户经理';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.rank_eff_date
  is '职级起始时间';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.same_trade_year
  is '同业年限';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.updated_user
  is '修改人';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.updated_date
  is '修改日期';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.created_user
  is '录入人';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.created_date
  is '录入日期';
comment on column SLISINTF.BANK_STAFF_INFO_OTHER.card_sell_flag
  is '激活卡销售资格:y 有,n 无';
alter table SLISINTF.BANK_STAFF_INFO_OTHER
  add constraint PK_BANK_STAFF_INFO_OTHER primary key (EMP_NO);

-- Create table
create table SLISINTF.EMP_STATUS
(
  emp_status_code VARCHAR2(4) not null,
  description     VARCHAR2(100) not null,
  channel_type    VARCHAR2(2) not null,
  updated_user    VARCHAR2(100) not null,
  updated_date    DATE not null,
  created_user    VARCHAR2(100) not null,
  created_date    DATE not null
);
-- Add comments to the table 
comment on table SLISINTF.EMP_STATUS
  is '人员状态基表';
-- Add comments to the columns 
comment on column SLISINTF.EMP_STATUS.emp_status_code
  is '人员状态代码';
comment on column SLISINTF.EMP_STATUS.description
  is '描述';
comment on column SLISINTF.EMP_STATUS.channel_type
  is '渠道类型';
comment on column SLISINTF.EMP_STATUS.updated_user
  is '修改人';
comment on column SLISINTF.EMP_STATUS.updated_date
  is '修改日期';
comment on column SLISINTF.EMP_STATUS.created_user
  is '录入人';
comment on column SLISINTF.EMP_STATUS.created_date
  is '录入日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table SLISINTF.EMP_STATUS
  add constraint PK_EMP_STATUS primary key (EMP_STATUS_CODE);
  
-- Create table
create table SLISINTF.EMP_POSITION_TBL
(
  position     VARCHAR2(2) not null,
  description  VARCHAR2(100) not null,
  created_user VARCHAR2(100) not null,
  created_date DATE not null,
  updated_user VARCHAR2(100) not null,
  updated_date DATE not null
);
-- Add comments to the table 
comment on table SLISINTF.EMP_POSITION_TBL
  is '职务';
-- Add comments to the columns 
comment on column SLISINTF.EMP_POSITION_TBL.position
  is '职务';
comment on column SLISINTF.EMP_POSITION_TBL.description
  is '描述';
comment on column SLISINTF.EMP_POSITION_TBL.created_user
  is '录入人';
comment on column SLISINTF.EMP_POSITION_TBL.created_date
  is '录入日期';
comment on column SLISINTF.EMP_POSITION_TBL.updated_user
  is '修改人';
comment on column SLISINTF.EMP_POSITION_TBL.updated_date
  is '修改日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table SLISINTF.EMP_POSITION_TBL
  add constraint PK_EMP_POSITION_TBL primary key (POSITION);

create table SLISINTF.PRODUCT
(
  product_code          VARCHAR2(10) not null,
  currency_code         VARCHAR2(3) default '01',
  full_name             VARCHAR2(100) not null,
  abbr_name             VARCHAR2(100) not null,
  english_full_name     VARCHAR2(100),
  english_abbr_name     VARCHAR2(100),
  ins_type              VARCHAR2(1) not null,
  unit                  VARCHAR2(1) not null,
  renewal_permit        VARCHAR2(1),
  created_user          VARCHAR2(50) not null,
  created_date          DATE not null,
  updated_user          VARCHAR2(50) not null,
  updated_date          DATE not null,
  review_status         VARCHAR2(1) default '0' not null,
  shortcut_product_code VARCHAR2(4),
  provision_name        VARCHAR2(100) not null
);
-- Add comments to the table 
comment on table SLISINTF.PRODUCT
  is '保险产品代码';
-- Add comments to the columns 
comment on column SLISINTF.PRODUCT.product_code
  is '产品代码';
comment on column SLISINTF.PRODUCT.currency_code
  is '币种代码';
comment on column SLISINTF.PRODUCT.full_name
  is '产品全称';
comment on column SLISINTF.PRODUCT.abbr_name
  is '产品简称';
comment on column SLISINTF.PRODUCT.english_full_name
  is '英文全称';
comment on column SLISINTF.PRODUCT.english_abbr_name
  is '英文简称';
comment on column SLISINTF.PRODUCT.ins_type
  is '主附约：1,主险;2,附加险;3,主险和附加险';
comment on column SLISINTF.PRODUCT.unit
  is '保额份数选择';
comment on column SLISINTF.PRODUCT.renewal_permit
  is '可否续保';
comment on column SLISINTF.PRODUCT.created_user
  is '录入人';
comment on column SLISINTF.PRODUCT.created_date
  is '录入日期';
comment on column SLISINTF.PRODUCT.updated_user
  is '修改人';
comment on column SLISINTF.PRODUCT.updated_date
  is '修改日期';
comment on column SLISINTF.PRODUCT.review_status
  is '审核状态:0待审核1审核通过2审核不通过';
comment on column SLISINTF.PRODUCT.shortcut_product_code
  is '纯数字，方便用户录入,不作系统表之间的关联';
comment on column SLISINTF.PRODUCT.provision_name
  is '产品条款名称，主要用于保单等单证上的产品名称打印';
  alter table SLISINTF.PRODUCT
  add constraint PK_PRODUCT_PRODUCT_CODE primary key (PRODUCT_CODE);
alter table SLISINTF.PRODUCT
  add constraint CK_INS_TYPE_PRODUCT
  check (INS_TYPE in ('1','2','3'));
alter table SLISINTF.PRODUCT
  add constraint CK_PRODUCT_REVIEW_STATUS
  check (review_status in ('0','1','2'));

create index SLISINTF.IX_PRODUCT_1 on SLISINTF.PRODUCT(FULL_NAME);
create index SLISINTF.IX_PRODUCT_2 on SLISINTF.PRODUCT(ABBR_NAME);

create public synonym BRANCH_CODE_RELATION       for slisintf.BRANCH_CODE_RELATION      ;
create public synonym CLIENT_INFORMATION         for slisintf.CLIENT_INFORMATION        ;
create public synonym CLIENT_ADDRESS             for slisintf.CLIENT_ADDRESS            ;
create public synonym STAFF_INFO                 for slisintf.STAFF_INFO                ;
create public synonym POLICY                     for slisintf.POLICY                    ;
create public synonym POLICY_CONTACT_INFO        for slisintf.POLICY_CONTACT_INFO       ;
create public synonym POLICY_PREM_INFO           for slisintf.POLICY_PREM_INFO          ;
create public synonym POLICY_PRODUCT             for slisintf.POLICY_PRODUCT            ;
create public synonym POLICY_PRODUCT_PREM        for slisintf.POLICY_PRODUCT_PREM       ;
create public synonym POS_VIP_CLIENT             for slisintf.POS_VIP_CLIENT            ;
create public synonym RN_POLICY_SERVICE_INFO     for slisintf.RN_POLICY_SERVICE_INFO    ;
create public synonym RN_PREM_DUE_ACCOMPLISH     for slisintf.RN_PREM_DUE_ACCOMPLISH    ;
create public synonym BANK_CATEGORY              for slisintf.BANK_CATEGORY             ;
create public synonym BANK_INFO                  for slisintf.BANK_INFO                 ;
create public synonym BRANCH_INFO                for slisintf.BRANCH_INFO               ;
create public synonym DEPARTMENT_INFO            for slisintf.DEPARTMENT_INFO           ;
create public synonym ADDRESS_TYPE               for slisintf.ADDRESS_TYPE              ;
create public synonym COUNTRY                    for slisintf.COUNTRY                   ;
create public synonym PROVINCE                   for slisintf.PROVINCE                  ;
create public synonym CITY                       for slisintf.CITY                      ;
create public synonym AREA_DEFINE                for slisintf.AREA_DEFINE               ;
create public synonym CHANNEL_TYPE_TBL           for slisintf.CHANNEL_TYPE_TBL          ;
create public synonym RN_ASSIGN_MODE             for slisintf.RN_ASSIGN_MODE            ;
create public synonym RN_ASSIGN_RULE             for slisintf.RN_ASSIGN_RULE            ;
create public synonym GGSYNC_SLIS                for slisintf.GGSYNC_SLIS               ;
create public synonym POS_VIP_TYPE               for slisintf.POS_VIP_TYPE              ;
create public synonym POS_VIP_GRADE              for slisintf.POS_VIP_GRADE             ;
create public synonym RN_POLICY_SERVICER_CHG_RECORD      for slisintf.RN_POLICY_SERVICER_CHG_RECORD;
create public synonym RENEWAL_STAFF_CHANGE_HISTORY       for slisintf.RENEWAL_STAFF_CHANGE_HISTORY;
create public synonym RENEWAL_STAFF_INFO_OTHER           for slisintf.RENEWAL_STAFF_INFO_OTHER;
create public synonym BANK_STAFF_INFO_OTHER              for slisintf.BANK_STAFF_INFO_OTHER;
create public synonym EMP_STATUS                         for slisintf.EMP_STATUS;
create public synonym EMP_POSITION_TBL                   for slisintf.EMP_POSITION_TBL;
create public synonym PRODUCT                   		 for slisintf.PRODUCT;




grant select on slisintf.BRANCH_CODE_RELATION      to gracde,graopr;
grant select on slisintf.CLIENT_INFORMATION        to gracde,graopr;
grant select on slisintf.CLIENT_ADDRESS            to gracde,graopr;
grant select on slisintf.STAFF_INFO                to gracde,graopr;
grant select on slisintf.POLICY                    to gracde,graopr;
grant select on slisintf.POLICY_CONTACT_INFO       to gracde,graopr;
grant select on slisintf.POLICY_PREM_INFO          to gracde,graopr;
grant select on slisintf.POLICY_PRODUCT            to gracde,graopr;
grant select on slisintf.POLICY_PRODUCT_PREM       to gracde,graopr;
grant select on slisintf.POS_VIP_CLIENT            to gracde,graopr;
grant select on slisintf.RN_POLICY_SERVICE_INFO    to gracde,graopr;
grant select on slisintf.RN_PREM_DUE_ACCOMPLISH    to gracde,graopr;
grant select on slisintf.BANK_CATEGORY             to gracde,graopr;
grant select on slisintf.BANK_INFO                 to gracde,graopr;
grant select on slisintf.BRANCH_INFO               to gracde,graopr;
grant select on slisintf.DEPARTMENT_INFO           to gracde,graopr;
grant select on slisintf.ADDRESS_TYPE              to gracde,graopr;
grant select on slisintf.COUNTRY                   to gracde,graopr;
grant select on slisintf.PROVINCE                  to gracde,graopr;
grant select on slisintf.CITY                      to gracde,graopr;
grant select on slisintf.AREA_DEFINE               to gracde,graopr;
grant select on slisintf.CHANNEL_TYPE_TBL          to gracde,graopr;
grant select on slisintf.RN_ASSIGN_MODE            to gracde,graopr;
grant select on slisintf.RN_ASSIGN_RULE            to gracde,graopr;
grant select on slisintf.GGSYNC_SLIS               to gracde,graopr;
grant select on slisintf.POS_VIP_TYPE              to gracde,graopr;
grant select on slisintf.POS_VIP_GRADE             to gracde,graopr;
grant select on slisintf.RN_POLICY_SERVICER_CHG_RECORD     to gracde,graopr;
grant select on slisintf.RENEWAL_STAFF_CHANGE_HISTORY      to gracde,graopr;
grant select on slisintf.RENEWAL_STAFF_INFO_OTHER          to gracde,graopr;
grant select on slisintf.BANK_STAFF_INFO_OTHER             to gracde,graopr;
grant select on slisintf.EMP_STATUS                        to gracde,graopr;
grant select on slisintf.EMP_POSITION_TBL                  to gracde,graopr;
grant select on slisintf.PRODUCT                  		   to gracde,graopr;

grant references on slisintf.CHANNEL_TYPE_TBL        to gradata;
grant references on slisintf.BRANCH_INFO             to gradata;
grant references on slisintf.STAFF_INFO              to gradata;
grant references on slisintf.POLICY                  to gradata;
grant references on slisintf.BANK_INFO               to gradata;