个人加班额度调整申请单AtsAdjustPerOTLimitBillT_ATS_AtsAdjustPerOTLimitBill名称别名数据表字段limitType管控类型FLimitTypecycleDateType周期类型FCycleDateTypeadjustReason调整原因FAdjustReasoncorrectiveAction改进措施FCorrectiveActionproposer申请人FProposerapplyDate申请日期FApplyDateadminOrg行政组织FAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDbillState单据状态FBillStateapproveType审批方式FApproveTypeisMultiEntryFIsMultiEntrynumber单据编号FNumberbizDate业务日期FBizDatehandler经手人FHandlerIDdescription参考信息FDescriptionhasEffected是否曾经生效FHasEffectedauditor审核人FAuditorIDsourceBillIdFSourceBillIDsourceFunction来源功能FSourceFunctioncreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班单调整申请单分录AtsAdjustPerOTLimitBillEntryT_ATS_AdjustPOTLimitBillEntry名称别名数据表字段limitValue申请调整管控值FLimitValuewarnValue申请调整预警值FWarnValueyear年FYeardateValue时间值FDateValuedateValueStr时间拼成的字符串FDateValueStrstartDate开始时间FStartDateendDate结束时间FEndDatebill单据头FBillIDindex编号FIndexisDefaultManage是否默认管理关系FIsDefaultManageperson事务执行人FPersonIDposition执行人职位FPositionIDadminOrgUnit执行人所在部门FAdminOrgUnitIDattAdminOrgUnit考勤地点FAttAdminOrgUnitIDseq单据分录序列号FSeqHR组织是否多分录(专员提交是1,个人提交是0)原始单据IDidIDFID部门加班额度调整申请单AtsDepOTLimitAdjustBillT_ATS_AtsDepOTLimitAdjustBill名称别名数据表字段cycleDateType周期类型FcycleDateTypeadjustReason调整原因FadjustReasoncorrectiveAction改进措施FcorrectiveActioncontrolType管控类型FcontrolTypeproposer申请人FProposerapplyDate申请日期FApplyDateadminOrg行政组织FAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDbillState单据状态FBillStateapproveType审批方式FApproveTypeisMultiEntryFIsMultiEntrynumber单据编号FNumberbizDate业务日期FBizDatehandler经手人FHandlerIDdescription参考信息FDescriptionhasEffected是否曾经生效FHasEffectedauditor审核人FAuditorIDsourceBillIdFSourceBillIDsourceFunction来源功能FSourceFunctioncreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班单调整申请单分录AtsDepOTLimitAdjustBillEntryT_ATS_AtsDepOTLimitBillEntry名称别名数据表字段OTfreeVal加班费管控值FOTfreeValOTfreeAdjustVal调整加班费管控值FOTfreeAdjustValworkTimeVal工时管控值FworkTimeValworkTimeAdjustVal调整工时管控值FworkTimeAdjustValyear年FyeardateValueStr时间拼成的字符串FDateValueStrdateValue时间拼成的字符串FDateValuestartDate开始时间FStartDateendDate结束时间FEndDateindex编号FIndexbill单据头FBillIDattenceCycle考勤周期FattenceCycleadjustAdminOrg调整额度部门FadjustAdminOrgHR组织是否多分录(专员提交是1,个人提交是0)原始单据IDisDefaultManage是否默认管理关系FIsDefaultManageperson事务执行人FPersonIDposition执行人职位FPositionIDadminOrgUnit执行人所在部门FAdminOrgUnitIDattAdminOrgUnit考勤地点FAttAdminOrgUnitIDseq单据分录序列号FSeqidIDFID部门加班额度历史AtsHistoryDepOTLimitT_ATS_AtsHistoryDepOTLimit名称别名数据表字段preOTfreeVal调整前的加班费管控值FpreOTfreeValpreWorkTimeVal调整后的管控值FpreWorkTimeValOTfreeValAdjustPercent加班费调整比例FOTfreeValAdjustPercentworkTimeAdjustPercent工时调整比例FworkTimeAdjustPercentOTfreeVal调整后的加班费管控值FOTfreeValworkTimeVal调整后的工时管控值FworkTimeValusedOTfreeVal已用加班费FusedOTfreeValusedWorkTimeVal已用工时FusedWorkTimeValremainOTfreeVal剩余加班费FRemainedremainWorkTimeVal剩余工时值FremainWorkTimeValcycleDateType管控周期类型FCycleDateTypeOTControlType加班管控类型FOTControlTypestartDatestartDateFStartDateendDateendDateFEndDateattenceCycleName周期名称FattenceCycleNameadjustReasonadjustReasonFAdjustReasonrelatedRecord关联的记录FRelatedRecordIDproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID行政组织(部门)HR组织个人加班额度历史AtsHistoryPersonOTLimitT_ATS_AtsHistoryPersonOTLimit名称别名数据表字段preWarnValue调整前的预警值FPreWarnValuepreLimitValue调整后的管控值FPreLimitValuewarnValAdjustPercent预警值调整比例FWarnValAdjustPercentlimitValAdjustPercent管控值调整比例FLimitValAdjustPercentcycleDateTypecycleDateTypeFCycleDateTypelimitTypelimitTypeFLimitTypelimitValuelimitValueFLimitValuewarnValuewarnValueFWarnValuestartDatestartDateFStartDateendDateendDateFEndDateusedusedFUsedremainedremainedFRemaineddateValuedateValueFDateValueadjustReasonadjustReasonFAdjustReasonrelatedRecord关联的记录FRelatedRecordIDisDefaultManage是否默认管理关系FIsDefaultManageattAdminOrgUnit考勤地点FAttAdminOrgUnitIDproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班额度员工范围配置AtsOTEmploeeConditionT_ATS_AtsOTEmploeeCondition名称别名数据表字段number编码FNumberconfig配置FConfiggroupgroupFGroupIDidIDFID行政组织(部门)HR组织加班额度条件和规则主表AtsOTLimitConditionGroupT_ATS_AtsOTLimitConditionGroup名称别名数据表字段groupgroupFGroupIDidIDFID加班管控规则分录AtsOTLimitRuleItemT_ATS_AtsOTLimitRuleItem名称别名数据表字段number编码FNumberlimitType管控类型FLimitTypewarnValue预警值FWarnValuelimitValue管控值FLimitValuegroupgroupFGroupIDidIDFID加班额度参数AtsOtLimitControlParamT_HR_ATS_AtsOtLimitControlPar名称别名数据表字段isUsed启用加班管控FisUsedOTfree小时加班费FOTfreeperControlType个人管控类型FperControlTypeperCycleType个人周期类型FperCycleTypeperLimitAdjust个人额度调整比例FperLimitAdjustperNotLimitWay个人没有额度记录方式FperNotLimitWaydepControlType部门管控类型FdepControlTypedepCycleType部门周期类型FdepCycleTypedepLimitAdjust部门额度调整比例FdepLimitAdjustdepNotLimitWay部门没有额度记录方式FdepNotLimitWayisPerbefAppBill允许个人补提加班单FisPerbefAppBillBillAftAppContrl加班单补提控制FBillAftAppContrlBillAftAppDay哪天前允许提交FBillAftAppDayBillBefAppContrl加班单提前申请控制FBillBefAppContrlBillBefAppOT1工作日提前几天申请FBillBefAppOT1BillBefAppOT2休息日提前几天申请FBillBefAppOT2BillBefAppOT3节假日提前几天申请FBillBefAppOT3OtrolByDateType加班类型受日期类型控制FOtrolByDateTypeadminOrgUnitFAdminOrgUnitIDshrBasicItem基础资料FShrBasicItemIDusePolicy共享策略FUsePolicyisSysPreset是否系统预置FIsSysPresetstate状态FStateindex顺序FIndexhrOrgUnit创建业务组织FHrOrgUnitIdname名称FName_l1name名称FName_l2name名称FName_l3行政组织(部门)number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID个人加班额度方案AtsOverTimeLimitRuleT_ATS_AtsOverTimeLimitRule名称别名数据表字段cycleDateType生成加班额度的周期类型FCycleDateTypestartYear开始年FStartYeardataValue开始周期值FDataValuestatus方案状态FStatusadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID个人加班额度实体AtsPersonOTLimitT_ATS_AtsPersonOTLimit名称别名数据表字段cycleDateType考勤周期FCycleDateTypelimitType管控类型FLimitTypedateValue时间值FDateValuewarnValue预警值FWarnValuelimitValue管控值FLimitValueused已用额度FUsedremained剩余额度FRemainedstartDate开始时间FStartDate行政组织(部门)HR组织endDate结束时间FEndDateotLimitControlParam加班额度控制参数FotLimitControlParamIDisDefaultManage是否默认管理关系FIsDefaultManageattAdminOrgUnit考勤地点FAttAdminOrgUnitIDproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID部门加班额度AttenceDepOTLimitT_HR_ATS_AttenceDepOTLimit名称别名数据表字段controlType管控类型FcontrolTypecontrolTimeRag管控时间范围FcontrolTimeRagstaffNum人数FstaffNumworkDay工作日天数FworkDaymonthAvgeOTfree月人均加班费用定额FmonthAvgeOTfreemonthAvgTimeVal月人均工时定额FmonthAvgTimeValworkTimeVal工时管控值FworkTimeValworkTimeAvgVal工时管控均值FworkTimeAvgValusedTimeVal已用工时FusedTimeValremainTimeVal剩余工时FremainTimeValOTfreeVal加班费管控值FOTfreeValOTfreeAvgVal加班费管控均值FOTfreeAvgValusedfreeVal已用加班费FusedfreeValremainfreeVal剩余加班费FremainfreeValbeginDate开始日期FbeginDateendDate结束日期FendDateattenceOTCycle管控周期类型FAttenceOTCyclerelatedRecord考勤周期与部门额度的关系FrelatedRecordotLimitControlParam加班额度控制参数FotLimitControlParamIDproposer员工FProposerID行政组织(部门)HR组织adminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID部门额度方案DepOTLimitSchemeT_HR_ATS_DepOTLimitScheme名称别名数据表字段realPersonNum实际人数FrealPersonNumrealStaffNum在编人数FrealStaffNummonthAvgeOTfree月人均加班费用定额FmonthAvgeOTfreemonthAvgTimeVal月人均工时定额FmonthAvgTimeValcycleType周期类型FcycleTypecontrolType管控类型FcontrolTypeproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID行政组织(部门)HR组织行政组织(部门)HR组织部门加班额度管控方案OTCtrlPlanDepT_ATS_OTCtrlPlanDep名称别名数据表字段personSource加班额度控制人群来源FPersonSourceautoRun自动执行FAutoRunstate方案状态FStatecreateNextBeforDays下周期生成时间FCreateNextBeforDayscycleType周期类型FCycleTypeupdateType额度更新方式FUpdateTypeAttenceCycle考勤周期FAttenceCycleIDlimitCtrlParam额度控制参数FLimitCtrlParamIDadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID部门加班额度方案分录OTCtrlPlanDepItemT_ATS_OTCtrlPlanDepItem名称别名数据表字段ctrlType管控类型FCtrlTypeperAveTime人均加班工时定额FPerAveTimeperAVGOTFee人均加班费定额FPerAVGOTFeegroup部门加班额度方案FGroupIDidIDFID个人额度管控方案OTCtrlPlanPerT_ATS_OTCtrlPlanPer名称别名数据表字段autoRun自动执行FAutoRunstate方案状态FStatecreateNextBeforDays下周期生成时间FCreateNextBeforDayscycleType周期类型FCycleTypeupdateType额度更新方式FUpdateTypeAttenceCycle考勤周期FAttenceCycleIDlimitCtrlParam额度控制参数FLimitCtrlParamIDadminOrgUnitFAdminOrgUnitID行政组织(部门)HR组织行政组织(部门)hrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID个人加班额度管控方案分OTCtrlPlanPerItemT_ATS_OTCtrlPlanPerItem名称别名数据表字段rangeAdmins行政组织FRangeAdminsrangePersons员工FRangePersonsrangeOther其他人员选择器FRangeOtherincludeEscrow包含代管FIncludeEscrowincludeSubAdmin包含下级行政组织FIncludeSubAdminrules加班额度个人管控方案规则FRulesIDgroup个人加班额度管控方案FGroupIDidIDFID加班额度个人管控方案规OTCtrlPlanPerRuleT_ATS_OTCtrlPlanPerRule名称别名数据表字段warnValwarnValFWarnValctrlVal管控值FCtrlValctrlType管控类型FCtrlTypegroup所属方案分录FGroupIDidIDFID加班额度控制可使用OtLimitControlAvailableT_ATS_OtLimitControlAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeTypebosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValueHR组织基础资料IDcreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID部门加班管控设置OtLimitCtrlDepSettingT_ATS_OtLimitCtrlDepSetting名称别名数据表字段ctrlType管控类型FCtrlTypecycleType周期类型FCycleTypelimitAdjustRatio额度调整比例FLimitAdjustRationoLimitWay没有额度记录方式FNoLimitWayotLimitCtrlParam加班额度控制参数FOtLimitCtrlParamIDmonthAvgOTfree月人均加班费定额FMonthAvgOTfreemonthAvgTimeVal月人均加班工时定额FMonthAvgTimeValadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班额度控制启用设置OtLimitCtrlEnableSettingT_ATS_OtLimitCtrlEnableSetting名称别名数据表字段perNoOtLimitWay个人没有加班额度记录方式FPerNoOtLimitWaydepNoOtLimitWay部分没有额度记录方式FDepNoOtLimitWaystate启用禁用状态FStateenableDate启用日期FEnableDateadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumber行政组织(部门)HR组织行政组织(部门)HR组织description描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID个人加班管控设置OtLimitCtrlPerSettingT_ATS_OtLimitCtrlPerSetting名称别名数据表字段ctrlType管控类型FCtrlTypecycleType周期类型FCycleTypelimitAdjustRatio额度调整比例FLimitAdjustRationoLimitWay没有额度记录方式FNoLimitWayotLimitCtrlParam加班额度控制参数FOtLimitCtrlParamIDlimitValue额度管控值FLimitValuewarnValue额度预警值FWarnValueadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID考勤周期可使用AtsAttenceCycleAvailableT_ATS_AtsAttenceCycleAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeType行政组织(部门)HR组织基础资料IDbosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValuecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID考勤设备可使用AtsAttendEquipAvailableT_ATS_AtsAttendEquipAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeTypebosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValuecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID考勤计算公式AtsCalFormulaT_HR_ATS_CalFormula名称别名数据表字段attencePolicyFAttencePolicyIDholidayRuleFHolidayRuleIDformulaType计算公式类型FormulaTypecontent公式内容FContentexpress公式表达式FExpresscalItem计算项目列表FCalItemlistItem包含项目列表FListItemlistFunc包含函数列表FListFunclistVar包含变量列表FListVarlistTable包含临时表列表FListTablesortSn公式排序FSortSnisCal是否参与计算FIsCaltableToConfigId表名和信息集组合FTableToConfigIdname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumber基础资料ID考勤制度ID假期额度规则IDdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID考勤计算方案AtsCalSchemeT_HR_ATS_CalScheme名称别名数据表字段calTimes计算次数FCalTimesbeginDate计算开始日期FBeginDateendDate计算结束日期FEndDateremark备注FRemarkadminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID调班单AtsChangeShiftBillT_HR_ATS_ChangeShiftBill名称别名数据表字段defaultShift1班次名称FDefaultShift1proposer1调班人员FProposer1attendDate1考勤日期FAttendDate1dayType1日期类型FDayType1isGenerateRecord1是否生成休息日排班FIsGenerateRecord1defaultShift2班次名称FDefaultShift2proposer2调班人员FProposer2attendDate2考勤日期FAttendDate2dayType2FDayType2行政组织(部门)HR组织日期类型2isGenerateRecord2是否生成休息日排班FIsGenerateRecord2adminOrgUnitFAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID补签卡原因可使用AtsFSReasonAvailableT_ATS_AtsFSReasonAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeTypebosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValuecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID假期档案AtsHolidayFileT_HR_ATS_AtsHolidayFile名称别名数据表字段holidayPolicySet假期制度FHolidayPolicySetIDEFFDT生效日期FEFFDTLEFFDT失效日期FLEFFDTremark备注FRemarkmanageRelationFManageRelationIdisDefaultManage是否默认管理FIsDefaultManageattendFileState考勤档案状态FAttendFileStateproposer员工FProposerID行政组织(部门)HR组织基础资料ID员工业务管理关系(管理关系ID)adminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID假期档案历史AtsHolidayFileHisT_HR_ATS_AtsHolidayFileHis名称别名数据表字段holidayPolicySet假期制度FHolidayPolicySetIDEFFDT生效日期FEFFDTLEFFDT失效日期FLEFFDTremark备注FRemarkmanageRelationFManageRelationIdisDefaultManage是否默认管理FIsDefaultManageattendFileState考勤档案状态FAttendFileStateproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID行政组织(部门)HR组织员工业务管理关系(管理关系ID)行政组织(部门)HR组织额度规则可使用AtsHolidayRuleAvailableT_ATS_AtsHolidayRuleAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeTypebosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValuecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID导入考勤结果实体AtsImportAttendanceResultT_HR_ATS_ImpAttendanceRslt名称别名数据表字段attandenceDate考勤日期FAttandenceDatetotalLeaveNum请假总人数FTotalLeaveNumtotalIndustryInjuryNum工伤假总人数FTotalIndustryInjuryNumtotalMaternityNum产假总人数FTotalMaternityNumtotalMarryNum婚假总人数FTotalMarryNumtotalFuneralNum丧假总人数FTotalFuneralNumtotalSickNum病假总人数FTotalSickNumtotalAbsenceNum事假总人数FTotalAbsenceNumabLeaveOneDay一天事假人数FAbLeaveOneDayabLeaveTwoDay两天事假人数FAbLeaveTwoDayabLeaveThreeDay三天事假人数FAbLeaveThreeDayabLeaveMtThreeDay超过三天事假总人数FAbLeaveMtThreeDayabsencePeopleNum旷工未到岗人数FAbsencePeopleNumtotalAbPersonNum未到岗人数合计FTotalAbPersonNumtotalAttendanceNum日实际出勤人数FTotalAttendanceNumdismissionNum待离职人数FDismissionNumorgFunctionType职能类别FOrgFunctionTypeIDproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumber基础资料ID行政组织(部门)HR组织description描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID打卡数据导入方案AtsImportPlanT_HR_ATS_ImportPlan名称别名数据表字段name名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID打卡数据导入方案明细项AtsImportPlanItemT_HR_ATS_ImportPlanItem名称别名数据表字段filedName列的名字FiledNamepunchCardMapp列名与打卡记录表对应关系FPunchCardMappfileDir文件存放位置FileDirgroup打卡数据导入模板组FGroupIDidIDFID请假单AtsLeaveBillT_HR_ATS_LeaveBill名称别名数据表字段remark备注FRemarkbillType请假单类型FBillTypeproposer申请人FProposerapplyDate申请日期FApplyDateadminOrg行政组织FAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDbillState单据状态FBillStateHR组织approveType审批方式FApproveTypeisMultiEntryFIsMultiEntrynumber单据编号FNumberbizDate业务日期FBizDatehandler经手人FHandlerIDdescription参考信息FDescriptionhasEffected是否曾经生效FHasEffectedauditor审核人FAuditorIDsourceBillIdFSourceBillIDsourceFunction来源功能FSourceFunctioncreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID请假单明细记录实体AtsLeaveBillDetailT_HR_ATS_LeaveBillDetail名称别名数据表字段leavebill请假单据FLeavebillIDleaveDate请假日期FLeaveDateleaveLength请假时长FLeaveLengthleaveUnit请假单位FLeaveUnitpolicyFPolicyIDholidayResult请假汇总记录FHolidayResultIDproposer员工FProposerIDadminOrgUnitFAdminOrgUnitIDposition职位FPositionIDhrOrgUnitFHrOrgUnitIDname名称FName_l1name名称FName_l2name名称FName_l3number编码FNumberdescription描述FDescription_l1description描述FDescription_l2description描述FDescription_l3simpleName简称FSimpleNamecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID请假单分录实体AtsLeaveBillEntryT_HR_ATS_LeaveBillEntry是否多分录(专员提交是1,个人提交是0)原始单据ID假期制度-假期类型行政组织(部门)HR组织名称别名数据表字段bill所属单据体FBillIDbeginTime请假开始时间FBeginTimeendTime请假结束时间FEndTimeleaveLength请假长度FLeaveLengthpolicy假期制度FPolicyIDreason请假原因FReasonremark备注FRemarkrealBeginTime实际请假开始时间FRealBeginTimerealEndTime实际请假结束时间FRealEndTimerealLeaveLength实际的请假实际长度FRealLeaveLengthrealUnit实际请假时长对应的单位FRealUnitisCancelLeave是否销假FIsCancelLeaveisDefaultManageisDefaultManageFIsDefaultManageisElasticCalLen弹性时段算时长FIsElasticCalLenperson事务执行人FPersonIDposition执行人职位FPositionIDadminOrgUnit执行人所在部门FAdminOrgUnitIDattAdminOrgUnit考勤地点FAttAdminOrgUnitIDseq单据分录序列号FSeqidIDFID点赞AtsLikeT_ATS_AtsLike名称别名数据表字段proposer点赞人员FProposerIdbeLikeProposer被点赞人员FBeLikeProposerIdlikeDate点赞日期FLikeDatelikeTime点赞时间FLikeTimelikeSource点赞来源FLikeSourcelikeProject点赞项目FLikeProjectidIDFID补偿方式可使用AtsOTCompensAvailableT_ATS_AtsOTCompensAvailable名称别名数据表字段baseInfoIdFBaseInfoIdhrOrgUse可使用业务组织FHrOrgUseIdisComUse是否常用FIsComUseindex顺序码FIndexstate状态FStatechangeType变动类型FChangeTypebosTypeIdBOSTYPEIDFBosTypeIdisDefaultValue是否默认值FIsDefaultValuecreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserID基础资料IDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班单AtsOverTimeBillT_HR_ATS_OverTimeBill名称别名数据表字段remark说明FRemarkbillSubmitType加班单提交类别FBillSubmitTypeproposer申请人FProposerapplyDate申请日期FApplyDateadminOrg行政组织FAdminOrgUnitIDhrOrgUnitFHrOrgUnitIDbillState单据状态FBillStateapproveType审批方式FApproveTypeisMultiEntryFIsMultiEntrynumber单据编号FNumberbizDate业务日期FBizDatehandler经手人FHandlerIDdescription参考信息FDescriptionhasEffected是否曾经生效FHasEffectedauditor审核人FAuditorIDsourceBillIdFSourceBillIDsourceFunction来源功能FSourceFunctioncreator创建者FCreatorIDcreateTime创建时间FCreateTimelastUpdateUser最后修改者FLastUpdateUserIDlastUpdateTime最后修改时间FLastUpdateTimeCU控制单元FControlUnitIDidIDFID加班单分录实体AtsOverTimeBillEntryT_HR_ATS_OverTimeBillEntry名称别名数据表字段otDate加班日期FOTDatestartTime计划加班开始时间FStartT...
