CFD_TCFDR_MOSAIC_SEGMENT_2008

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPID CHARACTER VARYING(15) 15
2 MICRO_SEGMENT_MOSAIC_TYP_CODE CHARACTER VARYING(4) 4
3 FACTORS_SCORES_2008_1 INTEGER 4
4 FACTORS_SCORES_2008_2 INTEGER 4
5 FACTORS_SCORES_2008_3 INTEGER 4
6 FACTORS_SCORES_2008_4 INTEGER 4
7 FACTORS_SCORES_2008_5 INTEGER 4
8 FACTORS_SCORES_2008_6 INTEGER 4
9 FACTORS_PC_2008_1 INTEGER 4
10 FACTORS_PC_2008_2 INTEGER 4
11 FACTORS_PC_2008_3 INTEGER 4
12 FACTORS_PC_2008_4 INTEGER 4
13 FACTORS_PC_2008_5 INTEGER 4
14 FACTORS_PC_2008_6 INTEGER 4
15 RELATIONS_TYP_CODE CHARACTER VARYING(4) 4
16 ESTMD_INC BIGINT 8
17 AFFLUENCE_CODE INTEGER 4
18 CENSUS_COLCTIVE_DISTRICT_CODE CHARACTER VARYING(10) 10
19 MCV_CREATE_DATE TIMESTAMP 8
20 MCV_UPD_DATE TIMESTAMP 8
21 DATA_LOAD_DATE TIMESTAMP 8
22 SNPSHT_DATE TIMESTAMP 8
23 LOAD_ID BIGINT 8
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8