OCH24_HST_S_ORG_GROUP

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 ASGN_USR_EXCLD_FLG CHARACTER(1) 1
10 BU_ID CHARACTER VARYING(15) 15
11 NAME CHARACTER VARYING(100) 100
12 ANNUAL_VALUE NUMERIC(22,7) 19
13 ASGN_DT TIMESTAMP 8
14 AVERAGE_AGE BIGINT 8
15 CHILD_0TO6_NUM BIGINT 8
16 CHILD_13TO18_NUM BIGINT 8
17 CHILD_7TO12_NUM BIGINT 8
18 DB_LAST_UPD TIMESTAMP 8
19 DEPENDS_NUM BIGINT 8
20 ENTERPRISE_FLG CHARACTER(1) 1
21 GRP_CREATED_DT TIMESTAMP 8
22 HH_INCOME NUMERIC(22,7) 19
23 HH_SIZE BIGINT 8
24 HOUSEHOLD_SCORE NUMERIC(22,7) 19
25 INCOME_AMT NUMERIC(22,7) 19
26 INCOME_DT TIMESTAMP 8
27 MEDIAN_AGE BIGINT 8
28 MNTHLY_HS_COST_AMT BIGINT 8
29 PR_REP_DNRM_FLG CHARACTER(1) 1
30 PR_REP_MANL_FLG CHARACTER(1) 1
31 PR_REP_SYS_FLG CHARACTER(1) 1
32 SUPPRESS_CALL_FLG CHARACTER(1) 1
33 SUPPRESS_MAIL_FLG CHARACTER(1) 1
34 WEALTH_AMT NUMERIC(22,7) 19
35 AIA_INTEG1_ID CHARACTER VARYING(500) 500
36 AIA_INTEG_ID CHARACTER VARYING(150) 150
37 ANNUAL_INCOME CHARACTER VARYING(30) 30
38 ANNUAL_INCOME_CD CHARACTER VARYING(30) 30
39 CATEGORY_CD CHARACTER VARYING(30) 30
40 COMMENTS CHARACTER VARYING(255) 255
41 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
42 GROUP_NAME CHARACTER VARYING(50) 50
43 GROUP_TYPE_CD CHARACTER VARYING(30) 30
44 GRP_CREATED_BY CHARACTER VARYING(15) 15
45 GR_ALIAS CHARACTER VARYING(50) 50
46 INCOME_CURCY_CD CHARACTER VARYING(20) 20
47 INCOME_RANGE_CD CHARACTER VARYING(30) 30
48 INTEGRATION_ID CHARACTER VARYING(30) 30
49 LIFESTYLE_CD CHARACTER VARYING(30) 30
50 LOC CHARACTER VARYING(50) 50
51 MAIN_PH_FAX_NUM CHARACTER VARYING(40) 40
52 MAIN_PH_NUM CHARACTER VARYING(40) 40
53 MKT_SEGMENT CHARACTER VARYING(30) 30
54 MKT_SEGMENT_CD CHARACTER VARYING(30) 30
55 OWNERSHIP_CD CHARACTER VARYING(30) 30
56 PAR_GROUP_OU_ID CHARACTER VARYING(15) 15
57 PRIVACY_CD CHARACTER VARYING(30) 30
58 PR_ADDR_PER_ID CHARACTER VARYING(15) 15
59 PR_CON_ID CHARACTER VARYING(15) 15
60 PR_DOMESTC_LANG_ID CHARACTER VARYING(5) 5
61 PR_POSTN_ID CHARACTER VARYING(15) 15
62 PR_TERR_ID CHARACTER VARYING(15) 15
63 REGION_CD CHARACTER VARYING(30) 30
64 REGION_ID CHARACTER VARYING(15) 15
65 STATUS CHARACTER VARYING(30) 30
66 STATUS_CD CHARACTER VARYING(30) 30
67 TYPE CHARACTER VARYING(30) 30
68 TYPE_CD CHARACTER VARYING(30) 30
69 WEALTH_RANGE_CD CHARACTER VARYING(30) 30
70 X_ANZSIC_CODE CHARACTER VARYING(30) 30
71 X_CREATED_SYS CHARACTER VARYING(50) 50
72 X_GROUP_NAME CHARACTER VARYING(100) 100
73 X_INDUSTRY CHARACTER VARYING(30) 30
74 X_LAST_UPD_DT TIMESTAMP 8
75 X_LAST_UPD_SYS CHARACTER VARYING(50) 50
76 X_LEGACY_ID CHARACTER VARYING(30) 30
77 X_OCCUPATION CHARACTER VARYING(30) 30
78 X_SYS_OF_ORIGIN CHARACTER VARYING(50) 50
79 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
80 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
81 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
82 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8