trm_dept_req_dt - 部门_员工培训需求数据表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_dept_req_dt | 部门培训需求数据表主键 | CHAR | Y | 20 | 0 | | | | |
begin_dt | 预计开始时间 | CHAR | | 10 | 0 | | | | |
budget_fee_sum | 预计费用总额 | DECIMAL | | 16 | 4 | 0 | | | |
budget_psn_num | 预计参训人数 | SMALLINT | | 2 | 0 | 0 | | | |
checknote | 审批意见 | VARCHAR | | 100 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
end_dt | 预计结束时间 | CHAR | | 10 | 0 | | | | |
groupdef1 | groupdef1 | VARCHAR | | 128 | 0 | | | | |
groupdef10 | groupdef10 | VARCHAR | | 128 | 0 | | | | |
groupdef11 | groupdef11 | VARCHAR | | 128 | 0 | | | | |
groupdef12 | groupdef12 | VARCHAR | | 128 | 0 | | | | |
groupdef13 | groupdef13 | VARCHAR | | 128 | 0 | | | | |
groupdef14 | groupdef14 | VARCHAR | | 128 | 0 | | | | |
groupdef15 | groupdef15 | VARCHAR | | 128 | 0 | | | | |
groupdef16 | groupdef16 | VARCHAR | | 128 | 0 | | | | |
groupdef17 | groupdef17 | VARCHAR | | 128 | 0 | | | | |
groupdef18 | groupdef18 | VARCHAR | | 128 | 0 | | | | |
groupdef19 | groupdef19 | VARCHAR | | 128 | 0 | | | | |
groupdef2 | groupdef2 | VARCHAR | | 128 | 0 | | | | |
groupdef20 | groupdef20 | VARCHAR | | 128 | 0 | | | | |
groupdef3 | groupdef3 | VARCHAR | | 128 | 0 | | | | |
groupdef4 | groupdef4 | VARCHAR | | 128 | 0 | | | | |
groupdef5 | groupdef5 | VARCHAR | | 128 | 0 | | | | |
groupdef6 | groupdef6 | VARCHAR | | 128 | 0 | | | | |
groupdef7 | groupdef7 | VARCHAR | | 128 | 0 | | | | |
groupdef8 | groupdef8 | VARCHAR | | 128 | 0 | | | | |
groupdef9 | groupdef9 | VARCHAR | | 128 | 0 | | | | |
item_intention | 培训目标 | VARCHAR | | 128 | 0 | | | | |
item_name | 项目名称 | VARCHAR | | 50 | 0 | | | | |
item_type | 培训需求类型 | SMALLINT | | 2 | 0 | 0 | | | |
note | 备注 | VARCHAR | | 100 | 0 | | | | |
pk_trm_course | 培训课程 | CHAR | | 20 | 0 | | | | |
pk_trm_dept_req | 部门培训需求单据主键 | CHAR | | 20 | 0 | | | | |
pk_trm_item | 培训类别 | CHAR | | 20 | 0 | | | | |
pk_trm_org | 培训机构 | CHAR | | 20 | 0 | | | | |
pri_type | 紧迫程度 | CHAR | | 20 | 0 | | | | |
req_reson | 需求原因 | VARCHAR | | 128 | 0 | | | | |
time_length | 时间长度 | DECIMAL | | 16 | 6 | 0 | | | |
time_unit | 培训时长单位 | SMALLINT | | 2 | 0 | 0 | | | |
trm_act_name | 培训名称 | VARCHAR | | 100 | 0 | | | | |
trm_content | 培训内容 | VARCHAR | | 128 | 0 | | | | |
trm_location | 培训地点 | VARCHAR | | 60 | 0 | | | | |
trm_method | 培训方式 | CHAR | | 20 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
write_dt | 填报时间 | CHAR | | 10 | 0 | | | | |
外键列表
索引列表