OBP24_CI_COUNTRY_L

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COUNTRY CHARACTER(3) 3
2 LANGUAGE_CD CHARACTER(3) 3
3 DESCR CHARACTER VARYING(60) 60
4 ADDR1_LBL CHARACTER VARYING(15) 15
5 ADDR2_LBL CHARACTER VARYING(15) 15
6 ADDR3_LBL CHARACTER VARYING(15) 15
7 ADDR4_LBL CHARACTER VARYING(15) 15
8 CITY_LBL CHARACTER VARYING(15) 15
9 NUM1_LBL CHARACTER VARYING(15) 15
10 NUM2_LBL CHARACTER VARYING(15) 15
11 HOUSE_TYPE_LBL CHARACTER VARYING(15) 15
12 COUNTY_LBL CHARACTER VARYING(15) 15
13 STATE_LBL CHARACTER VARYING(15) 15
14 POSTAL_LBL CHARACTER VARYING(15) 15
15 IN_CITY_LIM_LBL CHARACTER VARYING(15) 15
16 GEO_CODE_LBL CHARACTER VARYING(15) 15
17 VERSION INTEGER 4
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8