FCT_CMPS_ENTITY_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ENTITY_ID INTEGER 4
2 ENTITY_TYPE CHARACTER(1) 1
3 OLD_SYSTEM_REFERENCE CHARACTER VARYING(30) 30
4 OCCUPATION CHARACTER VARYING(40) 40
5 HAZARDOUS_OCCUPATION_ID INTEGER 4
6 ANZSIC_CODE CHARACTER(4) 4
7 TITLE_ID INTEGER 4
8 NAME CHARACTER VARYING(60) 60
9 GIVEN_NAMES CHARACTER VARYING(60) 60
10 PREFERRED_NAME CHARACTER VARYING(40) 40
11 SALUTATION CHARACTER VARYING(50) 50
12 GENDER CHARACTER(1) 1
13 ACN_NUMBER NUMERIC(9,0) 19
14 HOME_PHONE_NUMBER CHARACTER(20) 20
15 WORK_PHONE_NUMBER CHARACTER(20) 20
16 MOBILE_NUMBER CHARACTER(20) 20
17 FAX_NUMBER CHARACTER(20) 20
18 EMAIL_ADDRESS CHARACTER VARYING(60) 60
19 BIRTH_DATE TIMESTAMP 8
20 DECEASED_DATE TIMESTAMP 8
21 TAX_FILE_NUMBER CHARACTER(11) 11
22 TFN_FLAG CHARACTER(1) 1
23 PASSWORD CHARACTER(10) 10
24 RETIREMENT_DATE TIMESTAMP 8
25 PREF_CORRESPONDENCE_METHOD CHARACTER(1) 1
26 NEXT_CORRESPONDENCE_METHOD CHARACTER(1) 1
27 ANNUAL_SALARY NUMERIC(18,2) 19
28 SALARY_DATE TIMESTAMP 8
29 PREVIOUS_BENEFIT_AMOUNT NUMERIC(18,2) 19
30 REPORTING_FREQUENCY_FLAG CHARACTER(1) 1
31 PREFERRED_PAYMENT_TYPE CHARACTER(1) 1
32 PAYEE_NAME CHARACTER VARYING(60) 60
33 BANK_ACCOUNT_ID INTEGER 4
34 COMBINED_GC_FLAG CHARACTER(1) 1
35 BIRTHPLACE CHARACTER VARYING(40) 40
36 USER_ID INTEGER 4
37 CAN_PASS_ON_TFN_FLAG CHARACTER(1) 1
38 SERVICE_PRIORITY_FLAG CHARACTER(1) 1
39 LAST_USED_BANK_ACCOUNT_ID INTEGER 4
40 TRANSITIONAL_PENSION_RBL NUMERIC(18,2) 19
41 TRANSITIONAL_LUMPSUM_RBL NUMERIC(18,2) 19
42 PREFERRED_NAME_TYPE CHARACTER(1) 1
43 RETURNED_MAIL_FLAG CHARACTER(1) 1
44 CONTACT_NAME CHARACTER VARYING(40) 40
45 TOPUP_FLAG CHARACTER(1) 1
46 CLIENT_TYPE CHARACTER(1) 1
47 TITLE_TEXT CHARACTER VARYING(20) 20
48 SHORT_NAME CHARACTER VARYING(30) 30
49 RESIDENT_STATUS CHARACTER(1) 1
50 RESIDENCE_COUNTRY_CODE CHARACTER(8) 8
51 ADVERTISING_MATERIAL_FLAG CHARACTER(1) 1
52 RETURNED_MAIL_DATETIME TIMESTAMP 8
53 DORMANT_FLAG CHARACTER(1) 1
54 DORMANT_SINCE_DATETIME TIMESTAMP 8
55 SUPER_FUND_FLAG CHARACTER(1) 1
56 ENTITY_STOPPED_FLAG CHARACTER(1) 1
57 ENTITY_STOPPED_DATETIME TIMESTAMP 8
58 FAX_INDEMNITY_FLAG CHARACTER(1) 1
59 EMAIL_INDEMNITY_FLAG CHARACTER(1) 1
60 TFN_EXEMPTION_ID INTEGER 4
61 MAIL_RETURNED_DATE1 TIMESTAMP 8
62 MAIL_RETURNED_DATE2 TIMESTAMP 8
63 LOCATOR_CODE INTEGER 4
64 ABN NUMERIC(11,0) 19
65 ABN_FLAG CHARACTER(1) 1
66 RCTI_AGREEMENT_FLAG CHARACTER(1) 1
67 MAILING_TITLE CHARACTER VARYING(60) 60
68 COMPANY_REGO_NO CHARACTER VARYING(20) 20
69 TAX_CODE CHARACTER VARYING(20) 20
70 SMOKER_FLAG CHARACTER(1) 1
71 GROUPING_CODE CHARACTER(10) 10
72 TAX_IDENTIFICATION_NUMBER CHARACTER VARYING(20) 20
73 TIN_SUPPLIED_FLAG CHARACTER(1) 1
74 NON_RESIDENT_TFN CHARACTER(11) 11
75 NON_RESIDENT_TFN_FLAG CHARACTER(1) 1
76 NON_RESIDENT_PASS_ON_TFN_FLAG CHARACTER(1) 1
77 NON_RESIDENT_TFN_EXEMPTION_ID INTEGER 4
78 BIRTH_DATE_CONFIRMED_FLAG CHARACTER(1) 1
79 KYC_VERIFIED_FLAG CHARACTER(1) 1
80 OTHER_REGISTRATION_NUMBER CHARACTER VARYING(20) 20
81 TEMPORARY_RESIDENT_FLAG CHARACTER(1) 1
82 TEMP_RESIDENT_SINCE_DATE DATE 4
83 TEMP_RESIDENT_TRN_FILE_ID INTEGER 4
84 PROBATE_DATE TIMESTAMP 8
85 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
86 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
87 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
88 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8