OPC_HST_ZCUSTCHILDSML

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_OPC_HST_ZCUSTCHILDSML

SDSNZP02_BANK..EFS_OPC_HST_ZCUSTCHILDSML

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ZCUSTCNO CHARACTER VARYING(11) 11
3 ZCUSTCNOID CHARACTER VARYING(5) 5
4 ATOCATEGORISATION CHARACTER VARYING(50) 50
5 DATEOFBIRTH CHARACTER VARYING(10) 10
6 NONAUTAX CHARACTER VARYING(1) 1
7 PAYTAXINCTRY CHARACTER VARYING(2) 2
8 TITLE CHARACTER VARYING(20) 20
9 FIRSTNAME CHARACTER VARYING(200) 200
10 MIDDLENAME CHARACTER VARYING(50) 50
11 LASTNAME CHARACTER VARYING(50) 50
12 SEX CHARACTER VARYING(1) 1
13 DECEASED CHARACTER VARYING(1) 1
14 DATETORESIDENT CHARACTER VARYING(10) 10
15 DATETONONRESIDENT CHARACTER VARYING(10) 10
16 HOMENUMBER CHARACTER VARYING(20) 20
17 MOBILENUMBER CHARACTER VARYING(20) 20
18 OFFICENUMBER CHARACTER VARYING(20) 20
19 FAXNUMBER CHARACTER VARYING(20) 20
20 EMAIL CHARACTER VARYING(50) 50
21 RESFLOOR CHARACTER VARYING(10) 10
22 RESUNITNUMBER CHARACTER VARYING(10) 10
23 RESHOUSENUMBER CHARACTER VARYING(10) 10
24 RESSTREETNAME CHARACTER VARYING(50) 50
25 RESSUBURB CHARACTER VARYING(50) 50
26 RESTOWN CHARACTER VARYING(50) 50
27 RESSTATE CHARACTER VARYING(50) 50
28 RESPOSTCODE CHARACTER VARYING(20) 20
29 RESCOUNTRY CHARACTER VARYING(2) 2
30 POSTALFLOOR CHARACTER VARYING(10) 10
31 POSTALUNITNUMBER CHARACTER VARYING(10) 10
32 POSTALHOUSENUMBER CHARACTER VARYING(10) 10
33 POSTALSTREETNAME CHARACTER VARYING(50) 50
34 POSTALSUBURB CHARACTER VARYING(50) 50
35 POSTALTOWN CHARACTER VARYING(50) 50
36 POSTALSTATE CHARACTER VARYING(50) 50
37 POSTALPOSTCODE CHARACTER VARYING(20) 20
38 POSTALCOUNTRY CHARACTER VARYING(2) 2
39 TEXT1 CHARACTER VARYING(50) 50
40 TEXT2 CHARACTER VARYING(50) 50
41 TEXT3 CHARACTER VARYING(50) 50
42 TEXT4 CHARACTER VARYING(50) 50
43 TEXT5 CHARACTER VARYING(50) 50
44 DELETEDATE CHARACTER VARYING(10) 10
45 IOPER CHARACTER VARYING(4) 4
46 LSTMNTDATE CHARACTER VARYING(10) 10
47 LSTMNTTIME CHARACTER VARYING(8) 8
48 DELTA_TYPE CHARACTER VARYING(1) 1
49 EFFECTIVE_STRT_DT TIMESTAMP 8
50 EFFECTIVE_END_DT TIMESTAMP 8
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8