TBISR_DISTRICT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DISTRICT_HIID INTEGER 4
2 PK_TBISR_DISTRICT_DISTRICTID INTEGER 4
3 FK_TBIST_INTUSER_INTUSERID INTEGER 4
4 DESCRIPTIONDESC CHARACTER VARYING(100) 100
5 FK_TBISR_STATE_STATEID INTEGER 4
6 SYSRL_USER CHARACTER VARYING(50) 50
7 SYSRL_TIMESTAMP TIMESTAMP 8
8 SYSR_DELETED INTEGER 4
9 SYSR_DELETEDBY CHARACTER VARYING(50) 50
10 SYSR_DELETEDON TIMESTAMP 8
11 COB DATE 4
12 DELTA_TYPE CHARACTER VARYING(1) 1
13 EFFECTIVE_STRT_DT TIMESTAMP 8
14 EFFECTIVE_END_DT TIMESTAMP 8
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