yes the variable is decimal 10.0 field in the Teradata. I have checked Teradata table and it has same fields/columns.
below is the ddl for the same.
CREATE MULTISET TABLE P_WDM_S_WCIS_UMD.WCIS_CLNT_DISP_IN ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO,
MAP = TD_MAP2
(
REQUEST_ID DECIMAL(10,0),
USER_ID VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
WCIS_CLIENT_ID DECIMAL(10,0),
REQUEST_DEPT VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
REQUEST_DATE DATE FORMAT 'YYYY-MM-DD',
STATUS VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX PI_WCIS_CLNT_DISP_IN ( REQUEST_ID ,USER_ID ,WCIS_CLIENT_ID ,
REQUEST_DEPT );
... View more