《表格模板-人力资源培训发展信息表数据表 精品.xls》由会员分享,可在线阅读,更多相关《表格模板-人力资源培训发展信息表数据表 精品.xls(53页珍藏版)》请在第一文库网上搜索。
1、返回总览人力资源培训发展信息表数据表序序号号表表名名1 HR_TR_TrainNotice2 HR_TR_TrainPlan3 HR_TR_TrainPlanClass4 HR_TR_TrainRequirement5 HR_TR_TrainTeacher6 HR_TR_ActivityExam7 HR_TR_ActivityExamStyle8 HR_TR_ActivityMsg9 HR_TR_ActivityQuestionnaire10 HR_TR_ActivitySummary11 HR_TR_ActivityTrainStyle12 HR_TR_AttachmentFile13 HR
2、_TR_Book14 HR_TR_BookBorrow15 HR_TR_BookCategory16 HR_TR_ClassChannel17 HR_TR_ClassMaterial18 HR_TR_ClassParticipator19 HR_TR_ClassSummary20 HR_TR_ClassTeacher21 HR_TR_EmpTrainNote22 HR_TR_ExamClass23 HR_TR_ExamPaper24 HR_TR_ExamPaperInstance25 HR_TR_NoticeProcess26 HR_TR_OnLineExam27 HR_TR_PaperExa
3、mGrade28 HR_TR_PaperExamReply29 HR_TR_PaperItem30 HR_TR_Questionnaire31 HR_TR_QuestionnaireInstance32 HR_TR_QuestionnaireItem33 HR_TR_QuestionnaireItemReply34 HR_TR_QuestionnaireLog35 HR_TR_RequirementClass36 HR_TR_Suggestion37 HR_TR_TrainActivity38 HR_TR_TrainActivityClass39 HR_TR_TrainApplication4
4、0 HR_TR_TrainApprival41 HR_TR_TrainChannel42 HR_TR_TrainClass43 HR_TR_TrainClassType44 HR_TR_TrainMaterial45 HR_TR_TrainNoteEx表表描描述述培训征集通知表培训规划表培训规划课程表部门培训申请培训讲师表培训考试表培训活动考核方式表培训活动信息发布表培训问卷表培训活动总结表培训活动培训方式表培训资料附件表图书表借书表图书类别表培训课程渠道关系表培训课程资料关系表培训课程参与者表培训课程总结培训课程讲师关系表培训记录表培训考试记录表考试试卷表试卷实例表培训征集过程表考试记录表考
5、试成绩等级表考试回复结果表试卷题目表问卷表调查问卷实例表问卷题目表问卷调查项目回复记录表问卷调查记录表部门培训申请课程表培训建议表培训活动表培训活动课程表个人培训申请综合评价表培训渠道表培训课程表培训课程类别表培训资料表员工培训记录附表返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ContentSTRING通知内容DeadLineDATETIME 期限EndDateDATETIME 结束日期FromOrgUnitUnKnown发送部门IDUnKnown唯一标识SenderUnKnown发送者IDStartdateDATETIME 开始日期StatusINTEGER状态键表键键
6、名名类类型型PK_HR_TR_TrainNotice主键索引表索索引引名名字字段段PK_HR_TR_TrainNoticeID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ApproveDateDATETIME 规划批准日期ApproveStatusINTEGER规划状态BudgetFLOAT预算费用CreateDateDATETIME 创建时间EndDateDATETIME 结束日期IDUnKnown唯一标识NameSTRING规划名称StartDateDATETIME 开始日期UnitIDUnKnown所属组织单元IDWeightFLOAT
7、课程成本权重键表键键名名类类型型PK_HR_TR_TrainPlan主键索引表索索引引名名字字段段PK_HR_TR_TrainPlanID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述AverageCostFLOAT每次课程费用ClassIDUnKnown培训课程IDCreateDateDATETIME 创建时间ExecuteStatusINTEGER实施状态ExecuteTimesINTEGER举办次数IDUnKnown唯一标识IsObjSavedINTEGER是否引用过PlanEndDateDATETIME 计划结束日期PlanHoursF
8、LOAT计划课时PlanStartDateDATETIME 计划开始日期RemarkSTRING备注TrainPlanIDUnKnown培训规划ID键表键键名名类类型型FK_HR_TR_TrainPlanClass_HR_TR_TrainClass外键FK_HR_TR_TrainPlanClass_HR_TR_TrainPlan外键PK_HR_TR_TrainPlanClass主键索引表索索引引名名字字段段PK_HR_TR_TrainPlanClassID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述AdviceTeacherSTRING建议讲
9、师ClassNameSTRING课程名称ClassTypeIDUnKnown课程类型IDNoticeIDUnKnown征集通知IDTrainPlanTimeSTRING计划培训时间ActualizeManagerIDUnKnown培训实施部门负责人IDActualizeUnitIDUnKnown培训实施部门IDAdviceChannelSTRING建议渠道AimSTRING目的ApplyDateDATETIME 申请日期ApplyOrgUnitUnKnown申请部门ApplyUnitManagerIDUnKnown申请部门负责人IDBeginDateDATETIME 开始日期Condition
10、STRING参与条件ContactWaySTRING联系方式ContentSTRING内容EndDateDATETIME 结束日期IDUnKnown唯一标识IsClassBuildedINTEGER建议课程是否创建NameSTRING申请名称OperaterIDUnKnown申请记录者IDPartNumINTEGER参与人数RemarkSTRING备注StatusINTEGER状态TrainNoSTRING申请编号键表键键名名类类型型PK_HR_TR_TrainRequirement主键索引表索索引引名名字字段段PK_HR_TR_TrainRequirementID触发器表触触发发器器名名描描
11、述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述BriefSTRING讲师简介ChannelIDUnKnown 所属渠道IDCostFLOAT费用IDUnKnown 唯一标识NameSTRING讲师姓名TypeINTEGER 讲师类型键表键键名名类类型型PK_HR_TR_TrainTeacher主键索引表索索引引名名字字段段PK_HR_TR_TrainTeacherID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ActivityIDUnKnown培训活动IDClassIDUnKnown培训课程IDCreateDateDAT
12、ETIME 建立日期EndDateDATETIME 结束日期ExamPaperIDUnKnown试卷IDIDUnKnown唯一标识键表键键名名类类型型FK_HR_TR_ActivityExam_HR_TR_ExamPaper外键FK_HR_TR_ActivityExam_HR_TR_TrainActivity外键PK_HR_TR_ActivityExam主键索引表索索引引名名字字段段PK_HR_TR_ActivityExamID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述FActivityIDUnKnown活动唯一标识FExamStyleUn
13、Known考核方式唯一标识键表键键名名类类型型FK_HR_TR_AC_REFERENCE_HR_TR_CO外键FK_HR_TR_AC_REFERENCE_HR_TR_TR外键PK_HR_TR_ACTIVITYEXAMSTYLE主键索引表索索引引名名字字段段PK_HR_TR_ACTIVITYEXAMSTYLEFActivityID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ContentSTRING活动信息内容IDUnKnown 唯一标识SendFlagINTEGER 是否已发送SubjectSTRING活动信息主题键表键键名名类类型型PK_H
14、R_TR_ActivityMsg主键索引表索索引引名名字字段段PK_HR_TR_ActivityMsgID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ActivityIDUnKnown培训活动IDClassIDUnKnown培训课程IDCreateDateDATETIME 建立日期EndDateDATETIME 结束日期IDUnKnown唯一标识QuestionnaireIDUnKnown问卷IDSourceIDUnKnown问卷对象IDSurveyResultFLOAT问卷结果SurveyTypeINTEGER问卷类型键表键键名名类类型型F
15、K_HR_TR_AC_REFERENCE_HR_TR_QU外键FK_HR_TR_ActivityQuestionnaire_HR_TR_Questionnaire外键FK_HR_TR_ActivityQuestionnaire_HR_TR_TrainActivity外键PK_HR_TR_ActivityQuestionnaire主键索引表索索引引名名字字段段PK_HR_TR_ActivityQuestionnaireID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ActivityIDUnKnown培训活动IDCreateDateDATETIM
16、E 活动总结时间IDUnKnown唯一标识RealCostFLOAT实际费用RealEndDateDATETIME 实际结束日期RealStartDateDATETIME 实际开始日期RemarkSTRING总结内容StatusINTEGER状态键表键键名名类类型型FK_HR_TR_ActivitySummary_HR_TR_TrainActivity外键PK_HR_TR_ActivitySummary主键索引表索索引引名名字字段段PK_HR_TR_ActivitySummaryID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述FActivityIDUnKnown活动唯一标识FTrainStyleUnKnown培训方式唯一标识键表键键名名类类型型PK_HR_TR_ACTIVITYTRAINSTYLE主键索引表索索引引名名字字段段PK_HR_TR_ACTIVITYTRAINSTYLEFActivityID触发器表触触发发器器名名描描述述返回人力资源培训发展信息表目录表结构字字段段名名类类型型描描述述ContentUnKnown附件内容Co