KRONOS
orientlight
这个作者很懒,什么都没留下…
展开
-
Kronos员工雇用状态与账户状态
kronos开发查询员工雇佣状态与账户状态关系原创 2015-07-02 12:58:38 · 643 阅读 · 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 · 500 阅读 · 0 评论 -
KRONOS查看设备信息
select * from WDMDEVACTIONS where WDMDEVACTNTYPID <> 2 and WDMDEVACTNSTATID in (0,2) and WDMDEVICEID = ;原创 2015-07-02 11:00:17 · 417 阅读 · 0 评论 -
kronos获取假期
获取Kronos系统中的法定节假日原创 2015-05-20 17:29:18 · 536 阅读 · 0 评论 -
Kronos获取自定义信息
SELECT VPAP.PERSONNUM ,PCD.PERSONCSTMDATATXTFROM VP_ALLPERSONV42 VPAPLEFT JOIN PERSONCSTMDATA PCD ON (VPAP.PERSONID= PCD.PERSONID AND PCD.CUSTOMDATADEFID= (select CUSTOMDATADEFID from CUSTOMDA原创 2015-05-30 17:27:24 · 493 阅读 · 0 评论 -
KRONOS 基表解析
select * from WTKCASCPROFILE;WTKCASCPROFILEID PROFILENM PROFILEDSC ACTIVESW UPDATEDBYUSRACCTID UPDATEDTM VERSIONCNT1 经理级联政策 NULL 1 -1 2015-04-16 18:04:38.947 351 香港级联政策 NULL 1 -1 2015-04-16 20:09:4原创 2015-04-16 20:41:24 · 542 阅读 · 0 评论