/*
================================================================================
档案代号:tpk_file
档案名称:员工底薪异动明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tpk_file
(
tpk01       varchar2(16) NOT NULL,   /*异动单号                               */
tpk02       number(5) NOT NULL,      /*行序                                   */
tpk03       varchar2(10),            /*员工代号                               */
tpk04       varchar2(10),            /*原职等                                 */
tpk05       varchar2(10),            /*新职等                                 */
tpk06       number(5),               /*原职级                                 */
tpk07       number(5),               /*新职级                                 */
tpk08       number(20,6),            /*原底薪金额                             */
                                     /*原底薪金额          NO.A066            */
tpk09       number(20,6),            /*新底薪金额                             */
                                     /*新底薪金额          NO.A066            */
tpk10       varchar2(6),             /*原因代码                               */
tpk11       varchar2(255),           /*备注                                   */
tpk12       varchar2(1),             /*No Use                                 */
tpk13       varchar2(1),             /*No Use                                 */
tpk14       varchar2(1),             /*No Use                                 */
tpk15       varchar2(1),             /*No Use                                 */
tpkud01     varchar2(255),           /*自订栏位-Textedit                      */
tpkud02     varchar2(40),            /*自订栏位-文字                          */
tpkud03     varchar2(40),            /*自订栏位-文字                          */
tpkud04     varchar2(40),            /*自订栏位-文字                          */
tpkud05     varchar2(40),            /*自订栏位-文字                          */
tpkud06     varchar2(40),            /*自订栏位-文字                          */
tpkud07     number(15,3),            /*自订栏位-数值                          */
tpkud08     number(15,3),            /*自订栏位-数值                          */
tpkud09     number(15,3),            /*自订栏位-数值                          */
tpkud10     number(10),              /*自订栏位-整数                          */
tpkud11     number(10),              /*自订栏位-整数                          */
tpkud12     number(10),              /*自订栏位-整数                          */
tpkud13     date,                    /*自订栏位-日期                          */
tpkud14     date,                    /*自订栏位-日期                          */
tpkud15     date                     /*自订栏位-日期                          */
);

create unique index tpk_pk on tpk_file (tpk01,tpk02);
alter table tpk_file add  constraint tpk_pk primary key  (tpk01,tpk02) enable validate;
grant select on tpk_file to public;
grant index on tpk_file to public;
grant update on tpk_file to public;
grant delete on tpk_file to public;
grant insert on tpk_file to public;