TRPMT_SECTYPE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SECTYPE_ID CHARACTER VARYING(255) 255
2 SECTYPE_RV_ID BIGINT 8
3 SECTYPE_DESCRIPTION CHARACTER VARYING(255) 255
4 SECTYPE_ECON_RISK DOUBLE PRECISION 8
5 SECTYPE_LVR DOUBLE PRECISION 8
6 SECTYPE_REG_RISK DOUBLE PRECISION 8
7 SECTYPE_ACTIVE INTEGER 4
8 SECTYPE_PRIMARY INTEGER 4
9 SECTYPE_RESI INTEGER 4
10 SECTYPE_STANDALONE INTEGER 4
11 DATE_CREATED TIMESTAMP 8
12 CREATED_BY CHARACTER VARYING(255) 255
13 DATE_MODIFIED TIMESTAMP 8
14 MODIFIED_BY CHARACTER VARYING(255) 255
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8