ATS考勤2.14考勤计算（ 薪酬引入关联表）

--建表脚本--

create table T_ATS_PADATA(

FID int not null  comment '主键'

,FDOCID int default null  comment '考勤档案姓名'

,FPAMGRCENTERID int default null  comment '薪酬管理中心'

,FISPAYUSE char(1) default null  comment '薪酬引用状态'

,FPAYPLANID int default null  comment '引入薪酬方案'

,FIMPORTDATE datetime default null  comment '引入日期'

,FSTARTDATE datetime default null  comment '开始日期'

,FENDDATE datetime default null  comment '结束日期'

,FSUMCALCID int default null  comment '考勤汇总数据'

,primary key (FID)

) comment = '薪酬引入关联表'

--查询--

select FID as "fid",FDOCID as "fdocid",FPAMGRCENTERID as "fpamgrcenterid",FISPAYUSE as "fispayuse",FPAYPLANID as "fpayplanid",FIMPORTDATE as "fimportdate",FSTARTDATE as "fstartdate",FENDDATE as "fenddate",FSUMCALCID as "fsumcalcid" from T_ATS_PADATA

--查询(中文字段)--

select FID as "主键",FDOCID as "考勤档案姓名",FPAMGRCENTERID as "薪酬管理中心",FISPAYUSE as "薪酬引用状态",FPAYPLANID as "引入薪酬方案",FIMPORTDATE as "引入日期",FSTARTDATE as "开始日期",FENDDATE as "结束日期",FSUMCALCID as "考勤汇总数据" from T_ATS_PADATA

--INSERT脚本--

insert into T_ATS_PADATA(FID,FDOCID,FPAMGRCENTERID,FISPAYUSE,FPAYPLANID,FIMPORTDATE,FSTARTDATE,FENDDATE,FSUMCALCID) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_PADATA set FID=?,FDOCID=?,FPAMGRCENTERID=?,FISPAYUSE=?,FPAYPLANID=?,FIMPORTDATE=?,FSTARTDATE=?,FENDDATE=?,FSUMCALCID=? where FID=?

--delete脚本--

delete from T_ATS_PADATA where FID=?

--给字段加备注--

alter table T_ATS_PADATA comment '薪酬引入关联表';

alter table T_ATS_PADATA modify column FID int not null  comment '主键';

alter table T_ATS_PADATA modify column FDOCID int default null  comment '考勤档案姓名';

alter table T_ATS_PADATA modify column FPAMGRCENTERID int default null  comment '薪酬管理中心';

alter table T_ATS_PADATA modify column FISPAYUSE char(1) default null  comment '薪酬引用状态';

alter table T_ATS_PADATA modify column FPAYPLANID int default null  comment '引入薪酬方案';

alter table T_ATS_PADATA modify column FIMPORTDATE datetime default null  comment '引入日期';

alter table T_ATS_PADATA modify column FSTARTDATE datetime default null  comment '开始日期';

alter table T_ATS_PADATA modify column FENDDATE datetime default null  comment '结束日期';

alter table T_ATS_PADATA modify column FSUMCALCID int default null  comment '考勤汇总数据';