CFD_TCFDW_DOM_CLOSEST_DOMICILE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COST_CTR BIGINT 8
2 BRANCH_NAME CHARACTER VARYING(255) 255
3 SUBURB CHARACTER VARYING(255) 255
4 STATE CHARACTER VARYING(255) 255
5 POSTCODE BIGINT 8
6 REGION CHARACTER VARYING(255) 255
7 XX BIGINT 8
8 YY BIGINT 8
9 FLAG CHARACTER VARYING(255) 255
10 COST_CTR2 BIGINT 8
11 POST_CODE BIGINT 8
12 BRCH_ID BIGINT 8
13 DOM_X BIGINT 8
14 DOM_Y BIGINT 8
15 POA_ID BIGINT 8
16 SQ_KMS BIGINT 8
17 STE_CODE BIGINT 8
18 STE_NAME CHARACTER VARYING(255) 255
19 CENTROID_X BIGINT 8
20 CENTROID_Y BIGINT 8
21 RESBRCHDIST BIGINT 8
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8