INT_AML_HIST_RELATED_PARTY

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_AML_HIST_RELATED_PARTY_V

Columns
# Name Data Type Length
1 RELATED_PARTY_ID BIGINT 8
2 CONNECTED_PARTY_SRC_UNIQUE_ID CHARACTER VARYING(35) 35
3 BENOWNER_IP_ID BIGINT 8
4 BENOWNER_SRC_CODE CHARACTER VARYING(20) 20
5 BENOWNER_OBP_PARTY_ID CHARACTER VARYING(40) 40
6 BENOWNER_GCIS_PARTY_ID CHARACTER VARYING(400) 400
7 BENOWNER_SNTA_CUST_UNIQUE_ID CHARACTER VARYING(13) 13
8 ENTITY_IP_ID BIGINT 8
9 ENTITY_OBP_PARTY_ID CHARACTER VARYING(40) 40
10 ENTITY_SNTA_CUST_UNIQUE_ID CHARACTER VARYING(13) 13
11 CUSTOMER_ID BIGINT 8
12 HUB_CUSTOMER_ID BIGINT 8
13 CLASSIFICATION_ID BIGINT 8
14 CLASSIFICATION_DESC CHARACTER VARYING(100) 100
15 KYC_STATUS CHARACTER VARYING(1) 1
16 ACTIVE_STATUS CHARACTER VARYING(10) 10
17 VERIFIED_CUSTOMER_ID BIGINT 8
18 RELATED_PARTY_TYPE_ID BIGINT 8
19 RELATED_PARTY_TYPE_DESC CHARACTER VARYING(30) 30
20 STATUS CHARACTER VARYING(10) 10
21 RP_NAME CHARACTER VARYING(100) 100
22 CREATED_DATETIME TIMESTAMP 8
23 DOB DATE 4
24 AML_STATUS CHARACTER VARYING(1) 1
25 AML_METHOD CHARACTER VARYING(5) 5
26 AML_DETAILS CHARACTER VARYING(50) 50
27 RP_GCIS_CUSTOMER_NUMBER CHARACTER VARYING(50) 50
28 RP_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
29 RP_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
30 RP_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
31 RP_SUBURB CHARACTER VARYING(50) 50
32 PR_STATE CHARACTER VARYING(30) 30
33 RP_POST_CODE CHARACTER VARYING(10) 10
34 RP_COUNTRY_CODE CHARACTER VARYING(2) 2
35 TITLE CHARACTER VARYING(30) 30
36 FIRST_NAME CHARACTER VARYING(30) 30
37 MIDDLE_NAME CHARACTER VARYING(60) 60
38 LAST_NAME CHARACTER VARYING(40) 40
39 SUFFIX CHARACTER VARYING(30) 30
40 CUSTOMER_NAME CHARACTER VARYING(132) 132
41 COMPANY_NAME CHARACTER VARYING(120) 120
42 DATE_OF_BIRTH DATE 4
43 NAME_OF_BIRTH CHARACTER VARYING(1) 1
44 ADDRESS_LINE_1 CHARACTER VARYING(50) 50
45 ADDRESS_LINE_2 CHARACTER VARYING(50) 50
46 ADDRESS_LINE_3 CHARACTER VARYING(50) 50
47 SUBURB CHARACTER VARYING(50) 50
48 STATE CHARACTER VARYING(30) 30
49 POST_CODE CHARACTER VARYING(10) 10
50 COUNTRY_CODE CHARACTER VARYING(2) 2
51 DELETED_FLAG CHARACTER VARYING(1) 1
52 CANCELLED_DATE TIMESTAMP 8
53 EVENT_DATE TIMESTAMP 8
54 PARTY_TYPE_CODE CHARACTER VARYING(1) 1
55 GCIS_CUSTOMER_NUMBER INTEGER 4
56 GCIS_TITLE CHARACTER VARYING(30) 30
57 GCIS_FIRST_NAME CHARACTER VARYING(30) 30
58 GCIS_MIDDLE_NAME_INITIAL CHARACTER VARYING(60) 60
59 GCIS_SURNAME CHARACTER VARYING(40) 40
60 GCIS_SUFFIX CHARACTER VARYING(30) 30
61 GCIS_ENTITY_NAME CHARACTER VARYING(120) 120
62 GCIS_DATE_OF_BIRTH DATE 4
63 GENDER_CODE CHARACTER VARYING(1) 1
64 GCIS_RESIDENTIAL_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
65 GCIS_RESIDENTIAL_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
66 GCIS_RESIDENTIAL_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
67 GCIS_RESIDENTIAL_CITY_TWN_SUBURB CHARACTER VARYING(40) 40
68 GCIS_RESIDENTIAL_STATE CHARACTER VARYING(30) 30
69 GCIS_RESIDENTIAL_POST_CODE CHARACTER VARYING(10) 10
70 GCIS_RESIDENTIAL_COUNTRY CHARACTER VARYING(2) 2
71 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
72 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
73 EOD_RNK BIGINT 8
74 ALL_RNK BIGINT 8