PRT_CLTMRKT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLTMKTREF INTEGER 4
2 MARITAL CHARACTER VARYING(1) 1
3 DEPENDANT SMALLINT 2
4 INCOME CHARACTER VARYING(4) 4
5 IDENTTYPE CHARACTER VARYING(4) 4
6 IDENTVAL CHARACTER VARYING(20) 20
7 CRDRATE INTEGER 4
8 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
9 RECORD_TYPE CHARACTER VARYING(16) 16
10 COMMIT_TIMESTAMP TIMESTAMP 8
11 EXTRACT_TIMESTAMP TIMESTAMP 8
12 CDC_ID BIGINT 8
13 DW_TIMESTAMP TIMESTAMP 8