FCT_VOC_INQUBA_SURV_REF

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VOC_INQUBA_SURV_REF_HIID BIGINT 8
2 SURVEY_ID CHARACTER VARYING(10) 10
3 AGENCY CHARACTER VARYING(50) 50
4 SURVEY_NAME CHARACTER VARYING(200) 200
5 QUALITY_DIMENSION CHARACTER VARYING(200) 200
6 QUESTION_ID CHARACTER VARYING(50) 50
7 QUESTION_WORDING CHARACTER VARYING(2000) 2000
8 QUESTION_RESPONSE_VALUES CHARACTER VARYING(8000) 8000
9 QUESTION_IDENTIFIER CHARACTER VARYING(20) 20
10 DELTA_TYPE CHARACTER(1) 1
11 EFFECTIVE_STRT_DT TIMESTAMP 8
12 EFFECTIVE_END_DT TIMESTAMP 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8