![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
KRONOS
orientlight
这个作者很懒,什么都没留下…
展开
-
Kronos员工雇用状态与账户状态
kronos开发查询员工雇佣状态与账户状态关系原创 2015-07-02 12:58:38 · 634 阅读 · 0 评论 -
Kronos获取累计池数量
SELECT SUM(ACCRUALTRAN.AMOUNT) FROM ACCRUALTRAN WHERE ( ACCRUALTRAN.ACCRUALCODEID=@accrualcodeid AND ACCRUALTRAN.EFFECTIVEDATE <=@enddate AND (ACCRUALTRAN.EFFECTIVEDATE>= (SELECT MAX原创 2015-05-20 11:30:05 · 490 阅读 · 0 评论 -
KRONOS查看设备信息
select * from WDMDEVACTIONS where WDMDEVACTNTYPID <> 2 and WDMDEVACTNSTATID in (0,2) and WDMDEVICEID = ;原创 2015-07-02 11:00:17 · 410 阅读 · 0 评论 -
kronos获取假期
获取Kronos系统中的法定节假日原创 2015-05-20 17:29:18 · 523 阅读 · 0 评论 -
Kronos获取自定义信息
SELECT VPAP.PERSONNUM ,PCD.PERSONCSTMDATATXT FROM VP_ALLPERSONV42 VPAP LEFT JOIN PERSONCSTMDATA PCD ON (VPAP.PERSONID= PCD.PERSONID AND PCD.CUSTOMDATADEFID= (select CUSTOMDATADEFID from CUSTOMDA原创 2015-05-30 17:27:24 · 479 阅读 · 0 评论 -
KRONOS 基表解析
select * from WTKCASCPROFILE; WTKCASCPROFILEID PROFILENM PROFILEDSC ACTIVESW UPDATEDBYUSRACCTID UPDATEDTM VERSIONCNT 1 经理级联政策 NULL 1 -1 2015-04-16 18:04:38.947 3 51 香港级联政策 NULL 1 -1 2015-04-16 20:09:4原创 2015-04-16 20:41:24 · 530 阅读 · 0 评论