考勤系统数据表结构.doc

考勤系统数据表结构考勤员信息设置 T_KQEMP_INFOMAN_IDVARCHAR2(20)N工号POST_INFOVARCHAR2(20)Y岗位描述POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮排班设置 T_KQPB_SETMAN_IDVARCHAR2(20)N员工编号DEPARTMENT_CODEVARCHAR2(20)Y部门编号CLASS_CODEVARCHAR2(10)Y班次编号CYC_DAYSNUMBERY循环天数CYC_NONUMBERY循环序号CYC_BEGINDATEN开始日期CYC_ENDDATEN结束日期IF_RESTVARCHAR2(2)Y是否休息POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮IDNUMBERN职工请假申请 T_KQQJ_APPLYMAN_IDVARCHAR2(20)N员工编号APPLY_DATEDATEN申请日期KIND_CODEVARCHAR2(10)Y类别编号START_DATEDATEY假期开始时间END_DATEDATEY假期结束时间APPLY_DAYSNUMBERY请假天数FAKE_CAUSEVARCHAR2(200)Y请假原因POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮APPLY_CODENUMBERN编号FLOW_STATEVARCHAR2(1)Y0流程审批状态:0:未启用,1:执行中,2:执行完毕CUROPERATORIDVARCHAR2(1000)Y当前执行人CUROPERATORID_ALLVARCHAR2(2000)Y全部执行人CURNODENAMEVARCHAR2(100)Y当前步聚SUB_TIMEDATEYDEPT_CODEVARCHAR2(20)Y员工部门DB_CODEVARCHAR2(20)Y调班后的部门DB_MANIDVARCHAR2(20)Y替班人姓名DB_DATEDATEY换班日期DB_CLASSVARCHAR2(20)Y换班班次THIS_CLASSVARCHAR2(20)Y换班人班次LAST_MOITYMANVARCHAR2(20)Y最后修改人LAST_MOITYDATEDATEY最后修改日期职工销假管理 T_KQQJ_SELLMAN_IDVARCHAR2(20)N员工编号APPLY_DATEDATEN申请日期START_DATEDATEY假期开始时间END_DATEDATEY假期结束时间APPLY_DAYSNUMBERY请假天数FAKE_TYPEVARCHAR2(20)Y请假类别FAKE_CAUSEVARCHAR2(200)Y请假原因APPLY_STATEVARCHAR2(10)Y审批状态TYPE_KINDVARCHAR2(20)Y类别POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮APPLY_CODENUMBERN编号DEPT_CODEVARCHAR2(20)Y部门LAST_MOITYMANVARCHAR2(20)Y最后修改人LAST_MOITYDATEDATEY最后修改日期日历设置 T_KQ_CALENDARSETUP_DATEDATEN日期WEEK_DAYVARCHAR2(10)Y星期IS_RESTVARCHAR2(2)Y是否休息FEAST_NAMEVARCHAR2(20)Y节日名称POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮班次设置 T_KQ_CLASS_SETCLASS_CODEVARCHAR2(10)N班次编号CLASS_NAMEVARCHAR2(20)Y班次名称ON_DUTYVARCHAR2(20)Y上班类型ON_TIMEVARCHAR2(20)Y上班时间OFF_DUTYVARCHAR2(20)Y下班类型OFF_TIMEVARCHAR2(20)Y下班时间POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_USERVARCHAR2(20)Y创建人POWER_POPEDOMVARCHAR2(1)Y锁定按钮LATE_ON_TIMEVARCHAR2(20)Y最迟时间IS_RESTVARCHAR2(2)Y休息日T_KQ_DUTYSUM 考勤统计明细DUTY_DATEDATEN上班日期MAN_IDVARCHAR2(20)N工号DEPT_CODEVARCHAR2(20)Y部门CLASS_CODEVARCHAR2(10)Y班次DUTY_COUNTNUMBERY应出勤数DUTY_PERFITNUMBERY实际出勤数BE_LATENUMBERY 是否迟到LEAVE_EARLYNUMBERY是否早退ABSENTNUMBERY 是否缺席DESCRIPTIONVARCHAR2(100)Y备注POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_USERVARCHAR2(20)Y创建人POWER_POPEDOMVARCHAR2(1)Y锁定按钮员工假期表 T_KQ_EMPLOYEE_HOLSHOLS_CODENUMBERN假期编号MAN_IDVARCHAR2(20)Y员工姓名DEPT_CODEVARCHAR2(20)Y部门名称HOLS_YEARVARCHAR2(4)Y年份KIND_CODEVARCHAR2(10)Y请假类别HOLS_DAYSNUMBERY假期天数START_DATEDATEY有效开始期限END_DATEDATEY有效期限结束LIMIT_COUNTNUMBERY限制次数FAKE_TYPEVARCHAR2(2)Y允许休假方式POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮USE_LIMITNUMBERY已使用次数LEFT_DAYSNUMBERY剩余天数USE_DAYSNUMBERY使用天娄LEAVE_TIMENUMBERY剩余次数假别定义 T_KQ_FAKESETFAKE_CODENUMBERN假别编号FAKE_DESCVARCHAR2(50)Y假别描述POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮考勤原始数据表 T_KQ_HIS_RECORDMAN_IDVARCHAR2(20)Y工号CAR_DATEDATEY上班时间CAR_TIMEVARCHAR2(20)Y下班时间POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮DEPT_CODEVARCHAR2(20)Y所属部门请假类别表 T_KQ_LEAVEKINDKIND_CODEVARCHAR2(10)N类别编号KIND_NAMEVARCHAR2(50)Y类别名称FAKE_CODENUMBERY假别MAX_DAYSNUMBERY天数限制DEGREENUMBERY次数限制POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮夜班明细表 T_KQ_NIGHT_DETAILCAR_DATEDATEY日期MANIDVARCHAR2(20)Y工号MAN_IDVARCHAR2(20)Y工号DEPT_CODEVARCHAR2(20)Y部门CLASS_CODEVARCHAR2(20)Y班次POWER_USERVARCHAR2(20)YPOWER_DATEDATEYPOWER_USER_DEPTVARCHAR2(20)YPOWER_POPEDOMVARCHAR2(22)Y0IFWORKVARCHAR2(5)Y是否加夜班出勤统计 T_KQ_ONDUTYSUMDUTY_DATEDATEN日期MAN_IDVARCHAR2(20)N工号DEPT_CODEVARCHAR2(20)Y部门CLASS_CODEVARCHAR2(10)Y班次DUTY_COUNTNUMBERY应出勤DUTY_PERFITNUMBERY实际出勤BE_LATENUMBERY迟到LEAVE_EARLYNUMBERY早退ABSENTNUMBERY旷工DESCRIPTIONVARCHAR2(100)Y备注POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮系统代码设定 T_KQ_OTHERCODEOTHER_IDVARCHAR2(20)N系统代码编号OTHER_NAMEVARCHAR2(30)Y系统代码名称POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮系统代码明细表 T_KQ_OTHEROTHER_IDVARCHAR2(20)N系统代码编号OTHER_CODEVARCHAR2(2)N系统代码明细编号OTHER_NAMEVARCHAR2(30)Y系统代码明细名称加班统计 T_KQ_OUTTIMEMAN_IDVARCHAR2(50)Y工号DEPT_CODEVARCHAR2(50)Y部门CAR_DATEDATEY日期CAR_TIMEVARCHAR2(50)Y下班时间COUNT_TIMENUMBERY加班小时POWER_USERVARCHAR2(50)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮MEMOVARCHAR2(50)Y加班类型说明排班表 T_KQ_PBMAN_IDVARCHAR2(20)N员工编号DEPARTMENT_CODEVARCHAR2(20)Y部门编号D_DATEDATEN排班日期CLASS_CODEVARCHAR2(10)Y班次编号POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮IS_RESTVARCHAR2(2)Y是否休息考勤数据表 T_KQ_RECORDMAN_IDVARCHAR2(20)Y工号DUTY_TIMEDATEY上班时间OFF_TIMEDATEY下班时间WORK_DATEDATEY考勤日期POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮补充打卡 T_KQ_RENEWFINGER_NOVARCHAR2(20)Y指模号MAN_IDVARCHAR2(20)Y工号DEPT_CODEVARCHAR2(20)Y部门编号DK_TIMEDATEY打卡时间DK_FLAGVARCHAR2(1)Y1打卡标志POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按钮DK_CODENUMBERN编号考勤修改人员 T_KQ_REPIARMANMAN_IDVARCHAR2(20)N员工编号POWER_USERVARCHAR2(20)Y创建人POWER_DATEDATEY创建时间POWER_USER_DEPTVARCHAR2(20)Y创建人部门POWER_POPEDOMVARCHAR2(1)Y锁定按