CRSTR_CRS_DD_REJECTED_CUSTOMERS

Database

SDSNZS01_CREST

Schema

CDCPADM_CREST

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RUN_DATE_TIME TIMESTAMP 8
2 GCIS_CUSTOMER_NUMBER INTEGER 4
3 CUSTOMER_TYPE CHARACTER VARYING(20) 20
4 CUSTOMER_NAME_GENERIC CHARACTER VARYING(1000) 1000
5 ADDRESS_LINE_1 CHARACTER VARYING(100) 100
6 ADDRESS_LINE_2 CHARACTER VARYING(100) 100
7 ADDRESS_LINE_3 CHARACTER VARYING(100) 100
8 ADDRESS_CITY CHARACTER VARYING(100) 100
9 ADDRESS_STATE CHARACTER VARYING(100) 100
10 ADDRESS_POST_CODE CHARACTER VARYING(100) 100
11 ADDRESS_COUNTRY CHARACTER VARYING(100) 100
12 RELATIONSHIP_MANAGER_ID CHARACTER VARYING(20) 20
13 RELATIONSHIP_MANAGER_NAME CHARACTER VARYING(100) 100
14 RELATIONSHIP_MANAGER_SOURCE CHARACTER VARYING(10) 10
15 INDV_TITLE CHARACTER VARYING(10) 10
16 INDV_FIRST_NAME CHARACTER VARYING(50) 50
17 INDV_MIDDLE_NAME_INITIAL CHARACTER VARYING(50) 50
18 INDV_LAST_NAME CHARACTER VARYING(50) 50
19 INDV_SUFFIX CHARACTER VARYING(50) 50
20 ENTITY_NAME CHARACTER VARYING(100) 100
21 GCIS_PROFILE_STATUS CHARACTER VARYING(20) 20
22 DECEASED_IND CHARACTER VARYING(3) 3
23 CHK_SUNCORP_ENTITY_FLAG CHARACTER VARYING(1) 1
24 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
25 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
26 CUSTOMER_THROUGH_FOREIGN_RELATION CHARACTER VARYING(3) 3
27 AML_BOCP_FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
28 DERIVED_CRS_ENTITY_TYPE CHARACTER VARYING(50) 50
29 DERIVED_FATCA_ENTITY_TYPE CHARACTER VARYING(50) 50
30 DERIVED_FFI_TYPE CHARACTER VARYING(50) 50
31 CURRENT_GIIN CHARACTER VARYING(50) 50
32 EMAIL_ADDRESS CHARACTER VARYING(100) 100
33 MOBILE_NUMBER CHARACTER VARYING(20) 20
34 CUSTOMER_IDENTIFIER CHARACTER VARYING(20) 20
35 REJECT_REASON CHARACTER VARYING(255) 255
36 REJECT_PROCESSING_DATE DATE 4
37 DATA_DATE DATE 4
38 LOAD_ID INTEGER 4
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8