CREATE TABLE SQD_SAMCHLD1_NATIVE_LANG_TEXT
(
ETL_SOURCE_APPLY_DTTM TIMESTAMP NOT NULL
,ETL_SOURCE_CAPTURE_DTTM TIMESTAMP NOT NULL
,ETL_SOURCE_CDC_ACTION_CODE CHAR(1 BYTE) NOT NULL
,ETL_SOURCE_KEY VARCHAR2(256 BYTE) NOT NULL
,ETL_SOURCE_SYSTEM_INSTANCE VARCHAR2(15 BYTE) NOT NULL
,ETL_SOURCE_SYSTEM_ORIGIN VARCHAR2(10 BYTE) NOT NULL
-- Parent Keys
,RT_BRANCH VARCHAR2(4 CHAR) NOT NULL
,RT_ACCT_OFFICER VARCHAR2(4 CHAR) NOT NULL
-- Segment Key
,C1_TEXT_LINE_NO NUMBER(5,0) NOT NULL
-- Segment Data
,C1_RCRD_TYPE VARCHAR2(3 CHAR)
,C1_TEXT_LINE_TYPE INTEGER
,C1_NON_ROMAN_TEXT NVARCHAR2(70)
);