TRPMT_SECURITY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SECURITY_ID CHARACTER VARYING(255) 255
2 SECURITY_RV_ID BIGINT 8
3 SECURITY_SECTYPE_ID CHARACTER VARYING(255) 255
4 SECURITY_VALUE DOUBLE PRECISION 8
5 SECURITY_VALUEEXC DOUBLE PRECISION 8
6 DATE_CREATED TIMESTAMP 8
7 CREATED_BY CHARACTER VARYING(255) 255
8 DATE_MODIFIED TIMESTAMP 8
9 MODIFIED_BY CHARACTER VARYING(255) 255
10 SECURITY_SECSTR_ID CHARACTER VARYING(255) 255
11 SECURITY_SECTYPE_IDX CHARACTER VARYING(255) 255
12 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
13 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
14 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
15 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8