OPIC_BRPS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 BRSTATUS CHARACTER VARYING(20) 20
3 BRPROCDATE CHARACTER VARYING(8) 8
4 PREVBRPROC CHARACTER VARYING(8) 8
5 LSTMNTDTE TIMESTAMP 8
6 PRVMENDDTE CHARACTER VARYING(8) 8
7 BRANPRCDATE TIMESTAMP 8
8 PREVBRANPRCDATE TIMESTAMP 8
9 PREVMNTHENDDATE TIMESTAMP 8
10 MONTHENDDAY CHARACTER VARYING(2) 2
11 YEARENDMONTH CHARACTER VARYING(3) 3
12 MONTHENDDATE TIMESTAMP 8
13 YEARENDDATE TIMESTAMP 8
14 NEXTBRANPRCDATE TIMESTAMP 8
15 PREVPREVBRANPRCDATE TIMESTAMP 8
16 NEXTMONTHENDDATE TIMESTAMP 8
17 PREVYEARENDDATE TIMESTAMP 8
18 NEXTYEARENDDATE TIMESTAMP 8
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8