OBP24_HST_FLX_PI_DEMOGRAPH_LEGISLATION_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_PI_DEMOGRAPH_LEGISLATION_B

Columns
# Name Data Type Length
1 PARTY_ID CHARACTER VARYING(40) 40
2 DETERMINANT_VALUE CHARACTER VARYING(40) 40
3 LEGAL_MAJOR CHARACTER(1) 1
4 OPERATIONAL_MAJOR CHARACTER(1) 1
5 BANKRUPT_FLAG CHARACTER(1) 1
6 MARITAL_STATUS CHARACTER(3) 3
7 MARITAL_STATUS_DATE TIMESTAMP 8
8 NATIONALITY_CODE CHARACTER VARYING(40) 40
9 TAX_CIRCLE CHARACTER VARYING(40) 40
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8