HRCM_AGREEMENT 岗位协议返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | AGREEMENT_UNIT | NUMBER | 38 | 0 | | | √ | | 协议期限单位 |
2 | AGREEMENTCODE | VARCHAR2 | 28 | | | | √ | | 终止协议证明编号 |
3 | AGREEMENTID | NUMBER | 38 | 0 | | | √ | | 协议id |
4 | AGREEMENTTYPE | VARCHAR2 | 50 | | | | √ | | 协议类型 |
5 | ASSGID | NUMBER | 38 | 0 | | | | | 人员任职ID |
6 | BEGINDATE | CHAR | 10 | | | | √ | | 协议开始日期 |
7 | BREACHMONEY | NUMBER | 28 | 8 | | | √ | | 赔偿金 |
8 | CONTCODE | VARCHAR2 | 42 | | | | √ | | 岗位协议编号 |
9 | CONTTYPE | NUMBER | 38 | 0 | | | | | 业务类型 |
10 | CREATIONTIME | CHAR | 19 | | | | | | 创建时间 |
11 | CREATOR | VARCHAR2 | 20 | | | | | | 创建人 |
12 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
13 | ENDDATE | CHAR | 10 | | | | √ | | 协议结束日期 |
14 | IFPROP | CHAR | 1 | | | | √ | | 需要试用 |
15 | ISREFER | CHAR | 1 | | | | | | 是否生效 |
16 | LASTFLAG | CHAR | 1 | | | | | | 是否最新 |
17 | MEMO | VARCHAR2 | 2250 | | | | √ | | 备注 |
18 | MODIFIEDTIME | CHAR | 19 | | | | √ | | 最后修改时间 |
19 | MODIFIER | VARCHAR2 | 20 | | | | √ | | 最后修改人 |
20 | NECONOMY | NUMBER | 28 | 8 | | | √ | | 经济补偿金 |
21 | NTRMONEY | NUMBER | 28 | 8 | | | √ | | 培训费用 |
22 | NTRPSNMONEY | NUMBER | 28 | 8 | | | √ | | 学员学费 |
23 | PAYMETHOD | VARCHAR2 | 128 | | | | √ | | 违约赔偿办法 |
24 | PK_AGREEMENT | CHAR | 20 | | √ | | | | 协议主键 |
25 | PK_CONTTEXT | VARCHAR2 | 20 | | | | √ | | 岗位协议模板 |
26 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | 所属集团 |
27 | PK_MAJORCORP | VARCHAR2 | 20 | | | | √ | | 协议主体单位 |
28 | PK_ORG | VARCHAR2 | 20 | | | | | | 业务发生组织 |
29 | PK_POST | VARCHAR2 | 300 | | | | √ | | 任职岗位 |
30 | PK_POST_ORG | VARCHAR2 | 20 | | | | √ | | 任职组织 |
31 | PK_PSNDOC | VARCHAR2 | 20 | | | | √ | | 人员 |
32 | PK_PSNJOB | VARCHAR2 | 20 | | | | | | 任职记录 |
33 | PK_PSNORG | VARCHAR2 | 20 | | | | | | 组织关系 |
34 | PK_TRAIN | CHAR | 20 | | | | √ | | 培训计划主键 |
35 | PK_UNCHREASON | VARCHAR2 | 20 | | | | √ | | 解除协议原因 |
36 | PROBEGINDATE | CHAR | 10 | | | | √ | | 试用开始日期 |
37 | PROBENDDATE | CHAR | 10 | | | | √ | | 试用结束日期 |
38 | PROBMONTH | NUMBER | 38 | 0 | | | √ | | 试用期限 |
39 | PROBSALARY | NUMBER | 28 | 8 | | | √ | | 试用期工资 |
40 | PROP_UNIT | NUMBER | 38 | 0 | | | √ | | 试用期限单位 |
41 | SERVICEYEAR | NUMBER | 38 | 0 | | | √ | | 服务年限 |
42 | SIGNADDR | VARCHAR2 | 150 | | | | √ | | 业务发生地点 |
43 | SIGNDATE | CHAR | 10 | | | | √ | | 业务发生日期 |
44 | STARTSALARY | NUMBER | 28 | 8 | | | √ | | 试用期满工资 |
45 | TERMMONTH | NUMBER | 38 | 0 | | | √ | | 协议期限 |
46 | TRAINADDR | VARCHAR2 | 512 | | | | √ | | 培训地点 |
47 | TRAINCODE | VARCHAR2 | 50 | | | | √ | | 培训活动编码 |
48 | TRAINCONTENT | VARCHAR2 | 128 | | | | √ | | 培训内容 |
49 | TRAINDAYS | NUMBER | 38 | 0 | | | √ | | 培训天数 |
50 | TRAINMETHOD | VARCHAR2 | 30 | | | | √ | | 培训方式 |
51 | TRAINNAME | VARCHAR2 | 128 | | | | √ | | 培训活动名称 |
52 | TRAINORG | VARCHAR2 | 20 | | | | √ | | 培训机构 |
53 | TRAINPERIOD | NUMBER | 38 | 0 | | | √ | | 培训学时 |
54 | TRAINTYPE | VARCHAR2 | 20 | | | | √ | | 培训类别 |
55 | TRMBEGINDTATE | CHAR | 10 | | | | √ | | 培训开始日期 |
56 | TRMENDDATE | CHAR | 10 | | | | √ | | 培训结束日期 |
57 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|