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 "开始日期",FE