OCH24_S_EMP_PER

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ROW_ID CHARACTER VARYING(15) 15
2 CREATED TIMESTAMP 8
3 CREATED_BY CHARACTER VARYING(15) 15
4 LAST_UPD TIMESTAMP 8
5 LAST_UPD_BY CHARACTER VARYING(15) 15
6 MODIFICATION_NUM BIGINT 8
7 CONFLICT_ID CHARACTER VARYING(15) 15
8 PAR_ROW_ID CHARACTER VARYING(15) 15
9 ACCEPT_SR_ASGN_FLG CHARACTER(1) 1
10 BONUS_ELIGIBLE_FLG CHARACTER(1) 1
11 CNTRCTR_FLG CHARACTER(1) 1
12 CP_FINAL_APPR_FLG CHARACTER(1) 1
13 INT_NEWS_APPR_FLG CHARACTER(1) 1
14 LOY_TIER_APPR_FLG CHARACTER(1) 1
15 MERIT_ELIGIBLE_FLG CHARACTER(1) 1
16 PROMO_ELIGIBLE_FLG CHARACTER(1) 1
17 STOCK_ELIGIBLE_FLG CHARACTER(1) 1
18 STORE_BUDGET_FLG CHARACTER(1) 1
19 STORE_FORECAST_FLG CHARACTER(1) 1
20 SYNC_SUCCESS_FLG CHARACTER(1) 1
21 EXP_APPR_LMT NUMERIC(22,7) 19
22 MDF_APPR_LMT NUMERIC(22,7) 19
23 SHARE_ADDR_FLG CHARACTER(1) 1
24 SHARE_HOME_PH_FLG CHARACTER(1) 1
25 TMSHT_APPR_BL_LMT NUMERIC(22,7) 19
26 TMSHT_APPR_HRS_LMT NUMERIC(22,7) 19
27 APPR_EXCH_DT TIMESTAMP 8
28 ASSIGN_EVT_FLG CHARACTER(1) 1
29 AVL_SCH_END_DT TIMESTAMP 8
30 AVL_SCH_START_DT TIMESTAMP 8
31 BURDENED_RATE NUMERIC(22,7) 19
32 COST_EXCH_DT TIMESTAMP 8
33 COST_PER_HR NUMERIC(22,7) 19
34 CURR_AVAIL_UNTIL TIMESTAMP 8
35 CURR_BONUS_TGT_PCT NUMERIC(22,7) 19
36 CURR_SALARY_AMT NUMERIC(22,7) 19
37 DB_LAST_UPD TIMESTAMP 8
38 EXT_SYS_SYNC_TS TIMESTAMP 8
39 HIRE_DT TIMESTAMP 8
40 LAST_ANNUAL_RVW_DT TIMESTAMP 8
41 LAST_PROMO_DT TIMESTAMP 8
42 LOA_END_DT TIMESTAMP 8
43 LOA_START_DT TIMESTAMP 8
44 LOY_LOAN_APPR_LMT NUMERIC(22,7) 19
45 LOY_TXN_APPR_LMT NUMERIC(22,7) 19
46 NEXT_ANNUAL_RVW_DT TIMESTAMP 8
47 TENURE_START_DT TIMESTAMP 8
48 TERMINATION_DT TIMESTAMP 8
49 TOT_AMT_EXCH_DT TIMESTAMP 8
50 TOT_PYMT_AMT_LMT NUMERIC(22,7) 19
51 TOT_RSRV_AMT_LMT NUMERIC(22,7) 19
52 APPR_CURCY_CD CHARACTER VARYING(20) 20
53 COST_CURCY_CD CHARACTER VARYING(20) 20
54 CP_REGN_ID CHARACTER VARYING(15) 15
55 CURR_AVAIL_CD CHARACTER VARYING(30) 30
56 CURR_JOB_CODE_ID CHARACTER VARYING(15) 15
57 CURR_JOB_PRFL_ID CHARACTER VARYING(15) 15
58 CUR_WRK_SHFT_ID CHARACTER VARYING(15) 15
59 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
60 EMERG_NOTIFY_CD CHARACTER VARYING(30) 30
61 EMPLOYEE_TYPE_CD CHARACTER VARYING(30) 30
62 EMP_PH_NUM_EXT CHARACTER VARYING(10) 10
63 EMP_STAT_CD CHARACTER VARYING(30) 30
64 END_ADDR_CD CHARACTER VARYING(30) 30
65 END_ADDR_ORG_ID CHARACTER VARYING(15) 15
66 END_ADDR_PER_ID CHARACTER VARYING(15) 15
67 EXT_SYS_SYNC_MSG CHARACTER VARYING(250) 250
68 INT_JOB_PRFL_ID CHARACTER VARYING(15) 15
69 LIC_PLATE_NUM CHARACTER VARYING(50) 50
70 LS_APPROVER_ID CHARACTER VARYING(15) 15
71 NEXT_AVAIL_CD CHARACTER VARYING(30) 30
72 OFFICE_BLDG_CD CHARACTER VARYING(30) 30
73 OFFICE_NUM CHARACTER VARYING(20) 20
74 OVERTIME_CD CHARACTER VARYING(30) 30
75 PCD_TBAR_ALIGN_CD CHARACTER VARYING(30) 30
76 PR_QUOTA_ID CHARACTER VARYING(15) 15
77 PR_WRK_EXP_ID CHARACTER VARYING(15) 15
78 READY_FOR_PROMO_CD CHARACTER VARYING(30) 30
79 SALARY_CURCY_CD CHARACTER VARYING(20) 20
80 SALARY_GRADE_ID CHARACTER VARYING(15) 15
81 SALARY_PLAN_ID CHARACTER VARYING(15) 15
82 SHORT_BIO_TEXT CHARACTER VARYING(2000) 2000
83 SRV_REGN_ID CHARACTER VARYING(15) 15
84 SRV_ROLE_CD CHARACTER VARYING(30) 30
85 START_ADDR_CD CHARACTER VARYING(30) 30
86 START_ADDR_ORG_ID CHARACTER VARYING(15) 15
87 START_ADDR_PER_ID CHARACTER VARYING(15) 15
88 STD_NOTIFY_CD CHARACTER VARYING(30) 30
89 TOT_AMT_CURCY_CD CHARACTER VARYING(20) 20
90 UPG_COMP_ID CHARACTER VARYING(15) 15
91 UQ_CLIENT_KEY CHARACTER VARYING(250) 250
92 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
93 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
94 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
95 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8