DIM_CUST_DNB_DUNS_MASTER

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DUNS CHARACTER VARYING(255) 255
2 CUST_NUM BIGINT 8
3 PRDT_SYS_CODE CHARACTER VARYING(3) 3
4 POLICY_NUMBER CHARACTER VARYING(30) 30
5 LOB_CODE CHARACTER VARYING(20) 20
6 PRDT_CAT_1 CHARACTER VARYING(50) 50
7 PRDT_CAT_TYP_DESC CHARACTER VARYING(50) 50
8 COVERAGEKEY BIGINT 8
9 BRAND_KEY BIGINT 8
10 KEYACT_KEY BIGINT 8
11 AAMI_DIGITAL_KEY BIGINT 8
12 CANCELREASON_KEY BIGINT 8
13 INSTALFRQ_KEY BIGINT 8
14 RISKINCEPTDATE_KEY INTEGER 4
15 EFFECTIVEDATE_KEY INTEGER 4
16 DUEDATE_KEY INTEGER 4
17 POLICYINCEPTDATE_KEY INTEGER 4
18 TRANSACTIONDATE_KEY INTEGER 4
19 POLICY_STAGE_KEY INTEGER 4
20 GLMONTH_KEY INTEGER 4
21 PRODHIER_KEY BIGINT 8
22 SOURCE_KEY1 CHARACTER VARYING(20) 20
23 SOURCE_KEY2 CHARACTER VARYING(20) 20
24 SOURCE_KEY3 CHARACTER VARYING(20) 20
25 SOURCE_KEY4 CHARACTER VARYING(20) 20
26 PACKAGETYPE_KEY BIGINT 8
27 ANZSIC_KEY BIGINT 8
28 STATEISSUE_KEY BIGINT 8
29 CPR_KEY BIGINT 8
30 BUSNESSRC_KEY BIGINT 8
31 PREVINS_KEY BIGINT 8
32 STATERISK_KEY BIGINT 8
33 ICAZONE_KEY BIGINT 8
34 STATEBDM_KEY BIGINT 8
35 CHANNEL_KEY BIGINT 8
36 ADVOCATE_KEY BIGINT 8
37 CLIENT_MISC_DTLS_KEY BIGINT 8
38 CLIENT_KEY BIGINT 8
39 QANTAS_KEY BIGINT 8
40 ACN CHARACTER VARYING(255) 255
41 ABN CHARACTER VARYING(255) 255
42 ENTITY_NAME CHARACTER VARYING(1000) 1000
43 ADDRESS_LINE_1 CHARACTER VARYING(255) 255
44 ADDRESS_LINE_2 CHARACTER VARYING(255) 255
45 SUBURB CHARACTER VARYING(100) 100
46 STATE CHARACTER VARYING(100) 100
47 POSTCODE CHARACTER VARYING(100) 100
48 DPID CHARACTER VARYING(255) 255
49 EMAIL CHARACTER VARYING(255) 255
50 WEBSITE CHARACTER VARYING(255) 255
51 PHONESTD CHARACTER VARYING(100) 100
52 PHONENO CHARACTER VARYING(100) 100
53 FAXSTD CHARACTER VARYING(100) 100
54 FAXNO CHARACTER VARYING(100) 100
55 LINEOFBUSINESS CHARACTER VARYING(255) 255
56 PRIMARY_ANZSIC CHARACTER VARYING(255) 255
57 PRIMARY_ANZSIC_DESC CHARACTER VARYING(255) 255
58 PRIMARY_ANZSIC_3_DIGIT CHARACTER VARYING(255) 255
59 PRIMARY_ANZSIC_3_DIGIT_DESC CHARACTER VARYING(255) 255
60 PRIMARY_ANZSIC_2_DIGIT CHARACTER VARYING(255) 255
61 PRIMARY_ANZSIC_2_DIGIT_DESC CHARACTER VARYING(255) 255
62 PRIMARY_ANZSIC_DIVISION CHARACTER VARYING(100) 100
63 PRIMARY_ANZSIC_DIVISION_DESC CHARACTER VARYING(255) 255
64 IMPORT_EXPORT_FLAG CHARACTER VARYING(100) 100
65 ABNSTATUS CHARACTER VARYING(100) 100
66 ABN_STATUSFROMDATE CHARACTER VARYING(50) 50
67 ABN_ENTITY_TYPE CHARACTER VARYING(100) 100
68 ASIC_ENTITY_STATUS CHARACTER VARYING(100) 100
69 ASIC_ENTITY_TYPE CHARACTER VARYING(100) 100
70 ASIC_ENTITY_CLASS CHARACTER VARYING(100) 100
71 ASIC_ENTITY_SUBCLASS CHARACTER VARYING(100) 100
72 GST_STATUS CHARACTER VARYING(100) 100
73 GST_STATUSFROMDATE CHARACTER VARYING(50) 50
74 TRADE_EXPERIENCE_DATE CHARACTER VARYING(50) 50
75 FIRST_CREDIT_INQUIRY CHARACTER VARYING(50) 50
76 DATE_OF_INCORPORATION_REG CHARACTER VARYING(50) 50
77 RISK_OF_FAILURE_BANDED CHARACTER VARYING(100) 100
78 RISK_OF_LATE_PAYMENT_BANDED CHARACTER VARYING(100) 100
79 DAILY_TRANSACTIONAL_BANK CHARACTER VARYING(255) 255
80 ENTITY_AGE_YEARS CHARACTER VARYING(255) 255
81 NUMBER_OF_EMPLOYEES CHARACTER VARYING(255) 255
82 EMPLOYEE_INDICATOR CHARACTER VARYING(100) 100
83 REVENUE CHARACTER VARYING(255) 255
84 REVEUE_INDICATOR CHARACTER VARYING(100) 100
85 KEY_DECISION_MAKER_SALUTATION CHARACTER VARYING(100) 100
86 KEY_DECISION_MAKER_FIRST_NAME CHARACTER VARYING(100) 100
87 KEY_DECISION_MAKER_MIDDLE_NAME CHARACTER VARYING(100) 100
88 KEY_DECISION_MAKER_LAST_NAME CHARACTER VARYING(100) 100
89 KEY_DECISION_MAKER_GENDER CHARACTER VARYING(100) 100
90 KEY_DECISION_MAKER_POSITION CHARACTER VARYING(100) 100
91 HIERARCHICAL_LEVEL CHARACTER VARYING(255) 255
92 NUMBER_OF_MEMBERS_IN_HIERACHY CHARACTER VARYING(255) 255
93 ENTITY_HIERACHY_TYPE CHARACTER VARYING(100) 100
94 IMMEDIATE_PARENT_DUNS CHARACTER VARYING(255) 255
95 IMMEDIATE_PARENT_NAME CHARACTER VARYING(1000) 1000
96 IMMEDIATE_PARENT_COUNTRY CHARACTER VARYING(100) 100
97 DOMESTIC_PARENT_DUNS CHARACTER VARYING(255) 255
98 DOMESTIC_PARENT_NAME CHARACTER VARYING(1000) 1000
99 DOMESTIC_PARENT_COUNTRY CHARACTER VARYING(100) 100
100 GLOBAL_ULTIMATE_PARENT_DUNS CHARACTER VARYING(255) 255
101 GLOBAL_ULTIMATE_PARENT_NAME CHARACTER VARYING(1000) 1000
102 GLOBAL_ULTIMATE_PARENT_COUNTRY CHARACTER VARYING(100) 100
103 OFFSHORE_OWNRD_CNTRY_UNKNWN CHARACTER VARYING(100) 100
104 IMM_PARENT_NAME_CNTRY_UNKNWN CHARACTER VARYING(100) 100
105 UPDATE_DATE_RECENCY_INDICATOR CHARACTER VARYING(100) 100
106 DO_NOT_MAIL CHARACTER VARYING(100) 100
107 DO_NOT_TELE CHARACTER VARYING(100) 100
108 BUSINESS_NAME CHARACTER VARYING(255) 255
109 MATCH_VIA CHARACTER VARYING(255) 255
110 CONFIDENCE_LEVEL CHARACTER VARYING(255) 255
111 M3_SCORE CHARACTER VARYING(255) 255
112 ABNLOOKUP_SCORE CHARACTER VARYING(255) 255
113 ACTIVE_INDICATOR CHARACTER VARYING(20) 20
114 MODELLED_MICRO_FLAG INTEGER 4
115 SNPSHT_DATE TIMESTAMP 8