1、业务分析宗谱图之人力

1、人力资本分析1.1 宗谱图专题分类类型业务描述源表直接目标表商业分析平台主数据特性用工类型BD_DEFDOCBA_HR_BS_BDDEFDOC商业分析平台主数据特性用工类型BA_HR_BS_BDDEFD OCBA_HR_DW_BDDEFDOC商业分析平台主数据特性用工类型BA_HR_DW_BDDEF DOCBA_HR_DIM_EMPFORMS商业分析平台主数据特性岗位编制HRP_TBUDGETBA_HR_BS_HRPTBT商业分析平台主数据特性岗位编制BA_HR_BS_HRP TBTBA_HR_DW_HRPTBT商业分析平台主数据特性岗位编制BA_HR_DW_HRPPO STBTBA_HR_D

2、M_TBT商业分析平台主数据特性部门编制HRP_DEPTBUDGETBA_HR_BS_HRPDEPTBT商业分析平台主数据特性岗位编制BA_HR_BS_HRPDEP TBTBA_HR_DW_HRPTBT商业分析平台主数据特性组织编制HRP_BUDGETBA_HR_BS_HRPBT商业分析平台主数据特性岗位编制BA_HR_BS_HRPOR GBTBA_HR_DW_HRPTBT商业分析平台主数据特性岗位OM_TBA_HR_BS_OMT商业分析平台主数据特性岗位编制BA_HR_BS_OM TBA_HR_DW_HRPTBT商业分析平台主数据特性信息BD_PSNDOCBA_HR_BS_BDPSNDOC商

3、业分析平台主数据特性信息表BA_HR_BS_BDPSND OCBA_HR_DW_BDPSNDOC商业分析平台主数据特性信息表快照BA_HR_DW_BDPSN DOCBA_HR_DW_PSINFO_C商业分析平台主数据特性信息表BA_HR_DW_PSINFO_CBA_HR_DW_PSINFO商业分析平台主数据特性信息表BA_HR_DW_PSINF OBA_HR_DIM_PSINFO商业分析平主数据特性关键BA_HR_DW_PSINFBA_HR_DM_KEYPS_C台信息快照O_C商业分析平台主数据特性学历信息HI_PSNDOC_EDUBA_HR_BS_HIPSNDOC_EDU商业分析平台主数据特

4、性信息表快照BA_HR_BS_HIPSND OC_EDUBA_HR_DW_PSINFO_C商业分析平台主数据特性组织关系HI_PSNBA_HR_BS_HIPSN商业分析平台主数据特性组织关系BA_HR_BS_HIPSNO RGBA_HR_DW_HIPSN商业分析平台主数据特性信息表快照BA_HR_DW_HIPSNBA_HR_DW_PSINFO_C商业分析平台主数据特性信息HI_PSNDOC_TITA_HR_BS_HIPSNDOC_TITLE商业分析平台主数据特性信息BA_HR_BS_HIPSND OC_TITLEBA_HR_DW_HIPSNDOC_TIT LE商业分析平台主数据特性信息表快照B

5、A_HR_DW_HIPSN DOC_TITLEBA_HR_DW_PSINFO_C商业分析平台主数据过程 PROC_HR_ALLCOD E_INITBA_HR_DW_CITYAREA特市地区商业分析平台主数据特性信息表快照BA_HR_DW_CITYAR EABA_HR_DW_PSINFO_C商业分析平台主数据特性成本项目过程 PROC_HR_ALLCOD E_INITBA_HR_DIM_COSTPROJ商业分析平台主数据特性岗位序列OM_TSERIESBA_HR_BS_OMTSERIES商业分析平台主数据特性岗位序列BA_HR_BS_OM TSERIESBA_HR_DIM_TSERIES商业分析

6、平台主数据特性司龄区间过程 PROC_HR_ALLCOD E_INITBA_HR_DIMDW_WORK AGE商业分析平台主数据特性区间过程 PROC_HR_ALLCOD E_INITBA_HR_DIMDW_AGE商业分析平台主数据特性职等OM_JOBRBA_HR_BS_OMJOBR商业分析平台主数据特性职等BA_HR_BS_OMJOB RBA_HR_DIM_JOBR商业分析平台主数据特性职级OM_JOBGRADEBA_HR_BS_OMJOBGRADE商业分析平台主数据特性职级BA_HR_BS_OMJOB GRADEBA_HR_DIM_JOBGRADE商业分析平主数据特性过程BA_HR_DIM

7、_SEX台(PROC_HR_ALLCOD E_INIT)商业分析平台主数据特性异动类型HR_TRNSTYPEBA_HR_BS_HRTRNSTYPE商业分析平台主数据特性异动类型BA_HR_BS_HRTRNS TYPEBA_HR_DIM_TRNSTYPE商业分析平台主数据特性数据地区(自定义)BD_DEFDOCBA_HR_BS_BDDEFDOC商业分析平台主数据特性自定义档案BA_HR_BS_BDDEFD OCBA_HR_DW_BDDEFDOC商业分析平台主数据特性BA_HR_DW_BDDEF DOCBA_HR_DIM_SEX商业分析平台主数据特性用工类型BA_HR_DW_BDDEF DOCBA

8、_HR_DIM_EMPFORMS商业分析平台主数据特性科目关联信息BD_ACCASOABA_FI_BS_BD_ACCASOA商业分析平台主数据特性科目关联信息BA_FI_BS_BD_ACCA SOABA_FI_DW_BD_ACCASOA商业分析平台主数据特性科目BD_ACCOUNTBA_FI_BS_BD_ACCOUNT商业分析平台主数据特性科目BA_FI_BS_BD_ACCO UNTBA_FI_DW_GL_BALANCE商业分析平台主数据特性科目BA_FI_DW_GL_BAL ANCEBA_FI_DIM_SUBJECTINFO公共主数据商业分析平台主数据公共时间过程PROC_HR_DIM_DA

9、TE_MBA_HR_DIM_DATE_M商业分析平台主数据公共组织机构_ADMINBA_HR_BS_ADMIN业务数据商业分析平台业务数据特性薪资汇总WA_DATABA_HR_BS_WADATA商业分析平台业务数据特性薪资汇总BA_HR_BS_WADAT ABA_HR_DW_WADATA商业分析平台业务数据特性薪资汇总BA_HR_DW_WADA TABA_HR_DIM_WADATA商业分析平台业务数据特性情况HI_PSNDOC_P HGBA_H R_BS_HIPSNDOC_CHG商业分析平台业务数据特性情况BA_H R_BS_HIPSNDOC_C HGBA_HR_DW_HIPSNDOC_CH

10、G商业分析平业务数据特性报表科目过程BA_FI_DWP_ITEMMAP1.1.1 主数据1.1.1.1 用工类型 BD_DEFDOC总量分析表结构 用工类型(表名：BD_DEFDOC)PK_DEFDOCCHAR(20)自定义主键PK_DEFDOCLISTCHAR(20)自定义列表主键PK_CHAR(20)所属组织PK_GROUPVARCHAR(20)所属CODEVARCHAR(40)编码NAMEVARCHAR(300)名称台关系(PROC_HR_ALLCOD E_INIT)商业分析平台业务数据特性科目余额GL_BALANCEBA_FI_BS_GL_BALANCE商业分析平台业务数据特性科目余额

11、BA_FI_BS_GL_BALA NCEBA_FI_DW_GL_BALANCE商业分析平台业务数据特性年度HRP_BUDGET_COR PYEARBA_HR_BS_BUDGETCORPYE AR商业分析平台业务数据特性BA_HR_BS_BUDGET CORPYEARBA_HR_DM_BUDGET商业分析平台业务数据特性月度HRP_BUDGET_COR PPERIODBA_HR_BS_BUDGETCORPPE RIOD商业分析平台业务数据特性BA_HR_BS_BUDGET CORPPERIODBA_HR_DM_BUDGET商业分析平台业务数据特性部门年度HRP_BUDGET_DEPT YEARB

12、A_HR_BS_BUDGETDEPTYE AR商业分析平台业务数据特性BA_HR_BS_BUDGET DEPTYEARBA_HR_DM_BUDGET商业分析平台业务数据特性部门月度HRP_BUDGET_DEPT PERIODBA_HR_BS_BUDGETDEPTPE RIOD商业分析平台业务数据特性BA_HR_BS_BUDGET DEPTPERIODBA_HR_DM_BUDGET商业分析平台业务数据特性项目额HRP_BUDGET_AMO UNTBA_HR_BS_BUDGETAMOUN T商业分析平台业务数据特性BA_HR_BS_BUDGET AMOUNTBA_HR_DM_BUDGET信息 BD

13、_PSNDOC1.1.1.21.1.1.3 岗位编制 HRP_TBUDGET1.1.1.4 部门编制 HRP_DEPTBUDGET总量分析表结构 部门编制(表名：HRP_DEPTBUDGET)PK_DEPT_BUDGETCHAR (20)部门编制主键PK_BUDGETVARCHAR (20)编制主键PK_GROUPVARCHAR (20)主键PK_VARCHAR (20)业务单元主键PK_DEPTVARCHAR (20)部门主键BUDGET_SELF(38)本部门编制BUDGET_ACTUAL(38)本部门占编人数BUDGET_LEFTOVER(38)本部门超（缺）编人数去向：BA_HR_BS

14、_HRPDEPTBT总量分析表结构 岗位编制(表名：HRP_TBUDGET)PK_T_BUDGETCHAR (20)岗位编制主键PK_DEPT_BUDGETCHAR (20)部门编制主键PK_TVARCHAR(20)岗位主键BUDGET_SELF(38)岗位编制BUDGET_ACTUAL(38)占编人数BUDGET_LEFTOVER(38)超（缺）编人数去向：BA_HR_BS_HRPTBT总量分析表结构信息(表名：BD_PSNDOC)CODEVARCHAR(50)编码NAMEVARCHAR(300)PK_PSNDOCCHAR(20)基本信息主键PK_CHAR(20)所属组织PK_GROUPCH

15、AR(20)所属去向：BA_HR_BS_BDPSNDOC去向：BA_HR_BS_BDDEFDOC1.1.1.5 组织编制 BD_PSNDOC1.1.1.6 人力资源管理_岗位 OM_T1.1.1.7 学历信息 HI_PSNDOC_EDU总量分析表结构 学历信息(表名：HI_PSNDOC_EDU)EDUCATIONCTIFCODECHAR (42)学历CERTIFCODECHAR (40)学位PK_PSNDOCCHAR (20)主键PK_PSNDOC_SUBCHAR (20)子表主键EDUCATIONVARCHAR (20)学历PK_DEGREEVARCHAR (20)学位去向：BA_HR_BS

16、_HIPSNDOC_EDU总量分析表结构 人力资源管理_岗位(表名：OM_T)PK_TCHAR (20)岗位主键TCODEVARCHAR (40)岗位编码TNAMEVARCHAR (300)岗位名称PK_GROUPVARCHAR (20)所属PK_VARCHAR (20)所属组织/公司PK_DEPTVARCHAR (20)所属部门PK_JOBVARCHAR (20)所属职务PK_TSERIESVARCHAR (20)岗位序列去向：BA_HR_BS_OMT总量分析表结构 组织编制(表名：HRP_BUDGET)PK_BUDGETCHAR (20)组织编制主键PK_GROUPVARCHAR (20)

17、主键PK_VARCHAR (20)业务单元主键BUDGET_SELF(38)本业务单元编制BUDGET_ACTUAL(38)本业务单元占编人数BUDGET_LEFTOVER(38)本业务单元超（缺）编人数去向：BA_HR_BS_HRPBT1.1.1.8 组织关系 HI_PSN信息 HI_PSNDOC_TITLE1.1.1.91.1.1.10 岗位序列 OM_TSERIES1.1.1.11 职等 OM_JOBR职等 (表名：OM_JOBR)PK_JOBRCHAR(20)职等主键JOBRCODEVARCHAR2(28)职等编码JOBRNAMEVARCHAR2(1536)职等名称PK_GROUPCH

18、AR(20)所属岗位序列 (表名：OM_TSERIES)PK_TSERIESVARCHAR2(20)岗位序列主键TSERIESCODEVARCHAR2(40)岗位序列编码TSERIESNAMEVARCHAR2(300)岗位序列名称TSERIESDESCVARCHAR2(1536)岗位序列描述去向：BA_HR_BS_OMTSERIES总量分析表结构信息(表名：HI_PSNDOC_TITLE)PK_PSNDOC_SUBCHAR (20)子表主键PK_PSNDOCCHAR (20)主键PK_GROUPCHAR (20)所属PK_CHAR (20)所属组织PK_TECHTTITLECHAR (20)获

19、得TITLERVARCHAR (20)等级去向：BA_HR_BS_HIPSNDOC_TITLE总量分析表结构 组织关系(表名：HI_PSN)PK_PSNCHAR (20)组织关系主键PK_PSNDOCVARCHAR (20)主键RELAID(38)组织关系 IDPK_GROUPCHAR (20)所属PK_CHAR (20)所属组织去向：BA_HR_BS_HIPSN1.1.1.12 职级 OM_JOBGRADE1.1.1.13 异动类型 HR_TRNSTYPE1.1.1.14 机构 公共机构(表名：_ADMIN)NAMEVARCHAR (300)名称CODEVARCHAR (50)编码CREAT

20、IONTIMECHAR (19)创建时间SHORTNAMEVARCHAR (300)简称ENABLESE(38)启用状态INNERCODEVARCHAR (200)编码去向：BA_HR_BS_ADMIN信息(表名：BD_PSNDOC)PK_TRNSTYPECHAR (50)异动类型主键TRNSEVENT(300)异动事件TRNSTYPECODEVARCHAR(20)编码TRNSTYPENAMEVARCHAR(20)名称PK_GROUPCHAR(20)所属PK_CHAR(20)所属组织去向：BA_HR_BS_HRTRNSTYPE职等 (表名：OM_JOBGRADE)PK_JOBGRADECHAR

21、(20)职级主键JOBGRADECODEVARCHAR2(28)职级编码JOBGRADENAMEVARCHAR2(150)职级名称PK_GROUPCHAR(20)所属PK_CHAR(20)所属组织去向：BA_HR_BS_OMJOBGRADEPK_CHAR(20)所属组织去向：BA_HR_BS_OMJOBR1.1.1.15 数据地区(自定义)BD_DEFDOC1.1.1.16 科目关联信息 BD_ACCASOA1.1.1.17 科目 BD_ACCOUNT职等 (表名：OM_JOBR)PK_ACCOUNTCHAR(20)主键PK_ACCCHARTCHAR(20)创建科目表PK_ACCTYPECHA

22、R(20)科目类型CODEVARCHAR(40)科目编码VARCHAR(20)科目去向：BA_FI_BS_BD_ACCOUNT职等 (表名：OM_JOBR)PK_ASSASOACHAR(20)主键PK_ACCOUNTCHAR(20)科目主键PK_ACCCHARTCHAR(20)所属科目表NAMEVARCHAR(300)科目名称QUNTITYCHAR(1)数量PRICECHAR(1)单价去向：BA_FI_BS_BD_ACCASOA数据地区(自定义) (表名：BD_DEFDOC)PK_DEFDOCCHAR (20)自定义主键PK_DEFDOCLISTCHAR (20)自定义列表主键PK_GROUP

23、VARCHAR (20)所属PK_CHAR (20)所属组织CODEVARCHAR (40)编码NAMEVARCHAR (300)名称去向：BA_HR_BS_BDDEFDOC, BA_HR_BS_BDDEFDOC1.1.2 业务数据1.1.2.1 薪资汇总 WA_DATA情况 HI_PSNDOC_P1.1.2.2HG1.1.2.3 报表科目关系 BA_FI_DWP_ITEMMAP维度ITEMCODE项目编码VARCHAR(50)ITEMNAME项目名称VARCHAR(200)SUBJECT_ID科目主键VARCHAR(50)SUBJECTCODE科目编码VARCHAR(50)维度PK_PSND

24、OC_SUB子表主键PK_PSNDOC主键PK_PSN组织关系主键PK_GROUP所属PK_所属组织ASSGID任职 IDBEGINDATE到职日期度量ENDDATE离职日期去向：BA_H R_BS_HIPSNDOC_CHG维度PK_WA_DATA薪资主键PK_WA_CLASS薪资类别主键PK_PSNDOC基本信息CYEAR年度CPERIOD期间WORKDEPT任职部门WORK任职组织PK_GROUP所属PK_薪资组织度量E应纳税所得额去向：BA_HR_BS_WADATA1.1.2.4 科目余额 GL_BALANCE年度1.1.2.5HRP_BUDGET_CORPYEAR月度1.1.2.6HR

25、P_BUDGET_CORPPERIOD维度PERIOD月度CHAR(2)PK_CORP公司主键CHAR(20)PK_GROUP所属CHAR(20)PK_薪资组织CHAR(20)度量PK_BUDGET_CORPPERIOD月度计划主键CHAR(20)去向：BA_HR_BS_BUDGETCORPPERIOD维度CORPYEAR年度CHAR(4)PK_CORP公司主键CHAR(20)PK_GROUP所属CHAR(20)PK_薪资组织CHAR(20)度量YEAR_CONTROL年度控制CHAR(1)去向：BA_HR_BS_BUDGETCORPYEAR维度PK_ACCASOA科目主键CHAR(20)PK

26、_UNIT业务单元VARCHAR(20)ACCOUNTCODE科目编码VARCHAR(40)TS时间戳VARCHAR(19)度量DEBITAMOUNT原币借发生额DECIMAL(28,8)去向：BA_FI_BS_GL_BALANCESUBJECTNAME科目名称VARCHAR(200)UNARYOPERATOR汇总符号VARCHAR(50)ISINCLUDE科目子集VARCHAR(50)度量1.1.2.7 部门年度HRP_BUDGET_DEPTYEAR1.1.2.8 部门月度HRP_BUDGET_DEPTPERIOD项目额 HRP_BUDGET_AMOUNT1.1.2.9维度PK_BUDGET

27、_AMOUNT子表主键CHAR(20)PK_BUDGET_ITEM项目主键VARCHAR(20)PK_BUDGET_CORPPERIOD月度_主键CHAR(20)PK_BUDGET_ITEM_DEF项目主键CHAR(20)PK_BUDGET_DEPTYEAR部门_主键CHAR(20)PK_BUDGET_CORPYEAR_主键CHAR(20)度量VALUE_SELF本级额DECIMAL(31,8)去向：BA_HR_BS_BUDGETAMOUNT维度DEPTPERIOD月度CHAR(2)PK_DEPT部门主键CHAR(20)PK_GROUP所属CHAR(20)PK_薪资组织CHAR(20)度量PK

28、_BUDGET_DEPTPERIOD部门月度主键CHAR(20)去向：BA_HR_BS_BUDGETDEPTPERIOD维度DEPTYEAR年度CHAR(4)PK_DEPT部门主键CHAR(20)PK_GROUP所属CHAR(20)PK_薪资组织CHAR(20)度量PK_BUDGET_DEPTYEAR部门年度主键CHAR(20)去向：BA_HR_BS_BUDGETDEPTYEAR1.1.3 码表1.1.3.1 城市地区 (E.8E*=E)/:?8+1.1.3.2 成本项目 (E.8E*/3E)59:68501.1.3.3 司龄间 (E.8E*/3*=E=581-+区间 (E.8E*/3*=E-

29、+1.1.3.4区间 (表名：BA_HR_ DIMDW_AGE)AGE_REGIONVARCHAR(10)区间编码PSTYPEVARCHAR(20类型REGION_NAMEVARCHAR(100)区间名称司龄区间 (表名：BA_HR_DIMDW_WORKAGE)WORKAGE_REGIONVARCHAR(10)区间编码PSTYPEVARCHAR(20类型REGION_NAMEVARCHAR(100)区间名称区成本项目 (表名：BA_HR_DIM_COSTPROJ)COSTPROJIDVARCHAR(50)项目主键PROJCODEVARCHAR(50)项目编码PROJNAMEVARCHAR(50

30、)项目名称SYSVARCHAR(50)数据来源PROJPROPVARCHAR(50)项目属性城市地区 (表名：BA_HR_DW_CITYAREA)CITYIDVARCHAR(30)城市主键CITYNAMEVARCHAR(100)城市名称AREACODEVARCHAR(30)地区编码AREANAMEVARCHAR(100)地区名称1.1.3.5 时间 BA_HR_DIM_DATE_M1.1.3.6 报表科目关系 BA_FI_DWP_ITEMMAP报表科目关系 (表名：BA_FI_DWP_ITEMMAP)ITEMCODEVARCHAR(50)项目编码ITEMNAMEVARCHAR(200)项目名称

31、SUBJECT_IDVARCHAR(50)科目主键SUBJECTCODEVARCHAR(50)科目编码SUBJECTNAMEVARCHAR(200)科目名称UNARYOPERATORVARCHAR(50)汇总符号ISINCLUDEVARCHAR(50)科目子集SUBJECTCSUBJECTNUNARYOPERAISINCLU ITEMCODEITEMNAMESUBJECT_IDODEAMETORDE1002PP100000000P08住房公积金025GX221104+1002PP100000000P09社会保险费024MN221103+1002PP100000000P10福利费用0264166

32、020102+1002PP100000000P07教育经费0264566020104+0001Z01000ACCOUP05净利润NT1144103+1002PP100000000P05净利润024PJ4103+0001Z01000ACCOUP01营业收入NT1246001+1002PP100000000P09养老保险金024MP22110301+1002PP100000000P09失业保险金025GR22110302+时间 (表名：BA_HR_DIM_DATE_M)PK_DATEVARCHAR2(30)日期F_YEARVARCHAR2(30)年份NAME_YEARVARCHAR2(30)年份描

33、述F_QUARTERVARCHAR2(30)季度NAME_QUARTERVARCHAR2(30)季度描述F_MONTHVARCHAR2(30)月份NAME_MONTHVARCHAR2(30)月份描述1002PP100000000025GT1002PP100000000025GV1002PP100000000024MR1002PP100000000025OR1002PP100000000025P11002PP100000000025P31002PP100000000025QB1002PP100000000025OV1002PP100000000024YP1002PP100000000024YR1

34、002PP100000000025OX1002PP100000000025OZ1002P11000000002QITA1002PP1000000000250H1002PP1000000000250J1002PP1000000000250N1002PP1000000000250P1002PP1000000000250R1002P1100000001 KI2T2 1002P1100000001 KSZH5 1002P1100000001 KSZH7 1002P1100000001KZH0UP09医疗保险金22110303+P09工伤保险22110304+P09保险22110305+P01营业收入6

35、001+P01铸造板块收入600102+P01铝业收入600103+P01煤电板块收入水泥板块收入自销水泥板块收入统销水泥板块收入代销600105+P0160010101+P0160010102+P0160010103+P01外贸出口60010104+P01中转库60010105+P01未开票60010106+P01售房收入60010601+P01租赁收入60010602+P01发电类收入60010701+P01商贸业收入60010702+P01物流收入60010703+P01装卸收入60010704+P01捐赠收入60010705+P01会员收入60010706+P01加工修理费600107

36、07+1.1.3.7BA_HR_DIM_SEX1.1.3.8 码值转换 BA_HR_DWP_SWAPCODE码值转换 (表名：BA_HR_DWP_SWAPCODE)SYS_SOURCEVARCHAR(50)业务系统BSTYPEVARCHAR(50)业务类型DIRCODEVARCHAR(50)目标码值INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, B

37、SDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, eba2ca49-d18f-44d1-a54e- 505ac6666ace, 合同期限类型, TERMTYPE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, NULL, 合同期限类型);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, D

38、IRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, 847f89c5-dccb-487b-91cd-ace195d62, 试用结果, TRIALRESULT, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, 1:转正；2:延长试用期；3:

39、未通过试用, 试用结果);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, 4a9fb-5b00-4f94-b36e- 4aeb051e2dda, 试用类型, TRIALTYPE, NUL

40、L, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, 1:入职试用；2:岗位试用, 试用类型); INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4,BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)(表名：BA_HR_DIM_

41、SEX)SEXIDVARCHAR(50)主键SEXCODEVARCHAR(50)编码SEXNAMEVARCHAR(100)名称SEXID SEXCODE SEXNAMESEX男SEX女1002P1100000001P01废钢KZH1260010708+VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, de033519-b611-41cd-bd6e- ab948608ad54, 应聘来源, EMPLOYSOURCE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, NULL

42、, 应聘来源);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, 5c180da2-0e25-41ee-8bf8- 34abf43bacab, 合同签订状态, CONTSUS, NULL,

43、 NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, NULL, 合同签订状态);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDE

44、NUMVALUE, 枚举, 9273a5bc-3911-4817-8906- 1185f01c9358, 合同签订类型, CONTTYPE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, NULL, 合同签订类型);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DI

45、RCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, 04dfe53c-46e0-4536-a26a- f6deeec3180d, , SEX, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, NULL, );INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE,

46、BSDESC, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK)VALUES(HR, BA_HR_BS_MDENUMVALUE, 枚举, 61e755c3-607e-4ca6-b9a5- d5daf7002c4d, 异动事件, TRNSEVENT, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ID, BA_HR_BS_MDENUMVALUE, 异动事件);INSERTO B

47、A_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z710000000016XLE, 等级, TITLELEVE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N

48、ULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 等级);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义 , 1001Z71000000000GP4T,

49、 用工类型, EMPFORMS, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 用工类型);INSERT O BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME,DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BS

50、DESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000GP4V, 学历, EDUCATION, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 学历);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, B

51、SDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000GP4X, 专业类别, MAJORTYPE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 专业类别);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNA

52、ME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000S19Q, 状况, MARITAL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 状况);INSERTO BA_HR

53、_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1009ZZ100000000030SP, 工种, WORKTYPE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

54、PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 工种);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000GPD1, 异动原因,

55、 CHGRS, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 异动原因);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALU

56、ES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000GP4Y, 政治面貌, POLITY, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 政治面貌);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3,

57、DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义, 1001Z71000000000GP55, 职业资格, NATIONDUTY, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 职业资格);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME,DIRC

58、ODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, BA_HR_BS_BDDEFDOC, 自定义 , 1001Z71000000000GP55, 资格等级, DUTYLEVE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PK_DEFDOCLIST, BA_HR_BS_BDDEFDOC, NULL, 资格等级);INSERTO BA_HR_D

59、WP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, TBM_ITEM, 考勤项目, 0000Z700000000000014, 应出勤班数, 4, 401, NULL, WORKDAYS, NULL, NULL, NULL, NULL, NULL, PK_ITEM,BA_

60、HR_BS_TBM_ITEM, 401：应出勤班数 402：出勤班数 403：应出勤工时 404：出勤工时 , NULL);INSERTO BA_HR_DWP_SWAPCODE(SYS_SOURCE, BSTYPE, TYPEDESC, BSCODE, BSNAME, DIRCODE, DIRCODE1, BSDESC1, DIRCODE2, BSDESC2, DIRCODE3, BSDESC3, DIRCODE4, BSDESC4, BS_COLUMN, BS_TABLE, REMARK, BSDESC)VALUES(HR, TBM_ITEM, 考勤项目, 0000Z700000000000