/*
================================================================================
档案代号:dpa_file
档案名称:薪资级距资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table dpa_file
(
dpa01       varchar2(4) NOT NULL,    /*级距等级                               */
dpa02       number(20,6),            /*薪资金额之下限                         */
                                     /*薪资金额之下限        NO.A066          */
dpa03       number(20,6),            /*薪资金额之上限                         */
                                     /*薪资金额之上限        NO.A066          */
dpa04       number(20,6),            /*级距金额                               */
                                     /*级距金额              NO.A066          */
dpaacti     varchar2(1),             /*资料有效否                             */
dpauser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
dpagrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
dpamodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
dpadate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index dpa_pk on dpa_file (dpa01);
alter table dpa_file add  constraint dpa_pk primary key  (dpa01) enable validate;
grant select on dpa_file to public;
grant index on dpa_file to public;
grant update on dpa_file to public;
grant delete on dpa_file to public;
grant insert on dpa_file to public;