CFD_TCFDR_CENSUS_GEOG_HIER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCD_CODE CHARACTER VARYING(20) 20
2 AUS CHARACTER VARYING(20) 20
3 CED_2004_CODE CHARACTER VARYING(20) 20
4 LGA CHARACTER VARYING(20) 20
5 MSR CHARACTER VARYING(20) 20
6 POA CHARACTER VARYING(20) 20
7 SD CHARACTER VARYING(20) 20
8 SDI CHARACTER VARYING(20) 20
9 SED CHARACTER VARYING(20) 20
10 SLA CHARACTER VARYING(20) 20
11 SR CHARACTER VARYING(20) 20
12 SRS CHARACTER VARYING(20) 20
13 SSC CHARACTER VARYING(20) 20
14 SSD CHARACTER VARYING(20) 20
15 STE CHARACTER VARYING(20) 20
16 IREG CHARACTER VARYING(20) 20
17 IARE CHARACTER VARYING(20) 20
18 ILOC CHARACTER VARYING(20) 20
19 CED_2007_CODE CHARACTER VARYING(20) 20
20 SOS CHARACTER VARYING(20) 20
21 SOSR CHARACTER VARYING(20) 20
22 UCL CHARACTER VARYING(20) 20
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8