tbm_timedata - 2.01考勤数据
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_timedata | 考勤主键 | CHAR | Y | 20 | 0 | | | | |
applier | 申请人 | CHAR | | 20 | 0 | | | | |
approveidea | 审批意见 | VARCHAR | | 512 | 0 | | | | |
approvestatus | 审批状态 | SMALLINT | | 2 | 0 | | | | |
calendar | 日历 | CHAR | | 10 | 0 | | | | |
censor | 审批人 | CHAR | | 20 | 0 | | | | |
dr | 删除标志dr | SMALLINT | | 2 | 0 | | | | |
fourabsentlen | 时段四旷工时长 | DECIMAL | | 16 | 4 | 0 | | | |
fourbeginremark | 时段四开始时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
fourbegintime | 时段四开始时刻 | CHAR | | 19 | 0 | | | | |
fourearlylen | 时段四早退时长 | DECIMAL | | 16 | 4 | 0 | | | |
fourendremark | 时段四结束时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
fourendtime | 时段四结束时刻 | CHAR | | 19 | 0 | | | | |
fourisabsent | 时段四是否旷工 | SMALLINT | | 2 | 0 | 0 | | | |
fourisearly | 时段四是否早退 | SMALLINT | | 2 | 0 | 0 | | | |
fourisearlyabsent | 时段四是否早退引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
fourislate | 时段四是否迟到 | SMALLINT | | 2 | 0 | 0 | | | |
fourislateabsent | 时段四是否迟到引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
fourlatelen | 时段四迟到时长 | DECIMAL | | 16 | 4 | 0 | | | |
fournightlen | 时段四夜班时长 | DECIMAL | | 16 | 4 | 0 | | | |
ismidwayout | 是否中途外出 | SMALLINT | | 2 | 0 | 0 | | | |
midwayoutcount | 中途外出次数 | SMALLINT | | 2 | 0 | 0 | | | |
midwayouttime | 中途外出时长 | DECIMAL | | 16 | 4 | 0.0 | | | |
oneabsentlen | 时段一旷工时长 | DECIMAL | | 16 | 4 | 0 | | | |
onebeginremark | 时段一开始时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
onebegintime | 时段一开始时刻 | CHAR | | 19 | 0 | | | | |
oneearlylen | 时段一早退时长 | DECIMAL | | 16 | 4 | 0 | | | |
oneendremark | 时段一结束时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
oneendtime | 时段一结束时刻 | CHAR | | 19 | 0 | | | | |
oneisabsent | 时段一是否旷工 | SMALLINT | | 2 | 0 | 0 | | | |
oneisearly | 时段一是否早退 | SMALLINT | | 2 | 0 | 0 | | | |
oneisearlyabsent | 时段一是否早退引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
oneislate | 时段一是否迟到 | SMALLINT | | 2 | 0 | 0 | | | |
oneislateabsent | 时段一是否迟到引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
onelatelen | 时段一迟到时长 | DECIMAL | | 16 | 4 | 0 | | | |
onenightlen | 时段一夜班时长 | DECIMAL | | 16 | 4 | 0 | | | |
pk_busitype | 业务类型 | CHAR | | 20 | 0 | | | | |
pk_corp | 公司主键 | CHAR | | 4 | 0 | | | | |
pk_deptcalendar | 部门工作日历主键 | CHAR | | 20 | 0 | | | | |
pk_psncalendar | 人员工作日历主键 | CHAR | | 20 | 0 | | | | |
pk_psndoc | 人员主键 | CHAR | | 20 | 0 | | | | |
remark | 考勤说明 | VARCHAR | | 512 | 0 | | | | |
tbmstatus | 出勤状态 | VARCHAR | | 128 | 0 | | | | |
threeabsentlen | 时段三旷工时长 | DECIMAL | | 16 | 4 | 0 | | | |
threebeginremark | 时段三开始时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
threebegintime | 时段三开始时刻 | CHAR | | 19 | 0 | | | | |
threeearlylen | 时段三早退时长 | DECIMAL | | 16 | 4 | 0 | | | |
threeendremark | 时段三结束时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
threeendtime | 时段三结束时刻 | CHAR | | 19 | 0 | | | | |
threeisabsent | 时段三是否旷工 | SMALLINT | | 2 | 0 | 0 | | | |
threeisearly | 时段三是否早退 | SMALLINT | | 2 | 0 | 0 | | | |
threeisearlyabsent | 时段三是否早退引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
threeislate | 时段三是否迟到 | SMALLINT | | 2 | 0 | 0 | | | |
threeislateabsent | 时段三是否迟到引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
threelatelen | 时段三迟到时长 | DECIMAL | | 16 | 4 | 0 | | | |
threenightlen | 时段三夜班时长 | DECIMAL | | 16 | 4 | 0 | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
twoabsentlen | 时段二旷工时长 | DECIMAL | | 16 | 4 | 0 | | | |
twobeginremark | 时段二开始时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
twobegintime | 时段二开始时刻 | CHAR | | 19 | 0 | | | | |
twoearlylen | 时段二早退时长 | DECIMAL | | 16 | 4 | 0 | | | |
twoendremark | 时段二结束时刻考勤说明 | VARCHAR | | 128 | 0 | | | | |
twoendtime | 时段二结束时刻 | CHAR | | 19 | 0 | | | | |
twoisabsent | 时段二是否旷工 | SMALLINT | | 2 | 0 | 0 | | | |
twoisearly | 时段二是否早退 | SMALLINT | | 2 | 0 | 0 | | | |
twoisearlyabsent | 时段二是否早退引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
twoislate | 时段二是否迟到 | SMALLINT | | 2 | 0 | 0 | | | |
twoislateabsent | 时段二是否迟到引起旷工 | SMALLINT | | 2 | 0 | 0 | | | |
twolatelen | 时段二迟到时长 | DECIMAL | | 16 | 4 | 0 | | | |
twonightlen | 时段二夜班时长 | DECIMAL | | 16 | 4 | 0 | | | |
外键列表
索引列表
编码 | 显示名称 | i_tbm_timedata | i_tbm_timedata |