CFD_TCFDR_MOSAIC_SEGMENT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPID CHARACTER VARYING(15) 15
2 MICRO_SGMT_MOSC_TYP_CDE_2010 CHARACTER VARYING(4) 4
3 FACTORS_SCORES_1 INTEGER 4
4 FACTORS_SCORES_2 INTEGER 4
5 FACTORS_SCORES_3 INTEGER 4
6 FACTORS_SCORES_4 INTEGER 4
7 FACTORS_SCORES_5 INTEGER 4
8 FACTORS_SCORES_6 INTEGER 4
9 FACTORS_PC_1 INTEGER 4
10 FACTORS_PC_2 INTEGER 4
11 FACTORS_PC_3 INTEGER 4
12 FACTORS_PC_4 INTEGER 4
13 FACTORS_PC_5 INTEGER 4
14 FACTORS_PC_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 MICRO_SGMT_MOSC_TYP_CDE_2013 CHARACTER VARYING(4) 4
20 SA1 CHARACTER VARYING(10) 10
21 RELATIONS_TYP_CODE_2013 CHARACTER VARYING(4) 4
22 FACTORS_SCORES_2013_1 INTEGER 4
23 FACTORS_SCORES_2013_2 INTEGER 4
24 FACTORS_SCORES_2013_3 INTEGER 4
25 FACTORS_SCORES_2013_4 INTEGER 4
26 FACTORS_SCORES_2013_5 INTEGER 4
27 FACTORS_PC_2013_1 INTEGER 4
28 FACTORS_PC_2013_2 INTEGER 4
29 FACTORS_PC_2013_3 INTEGER 4
30 FACTORS_PC_2013_4 INTEGER 4
31 FACTORS_PC_2013_5 INTEGER 4
32 MCV_CREATE_DATE TIMESTAMP 8
33 MCV_UPD_DATE TIMESTAMP 8
34 DATA_LOAD_DATE TIMESTAMP 8
35 SNPSHT_DATE TIMESTAMP 8
36 LOAD_ID BIGINT 8
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8