TBIST_WGROUP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 WGROUP_HIID INTEGER 4
2 PK_TBIST_WGROUP_WGROUPID INTEGER 4
3 FK_TBISR_WCOMMRATE_CATEGORYID INTEGER 4
4 TRAILINCREMENTFLAG INTEGER 4
5 FIXEDTRAILRATE NUMERIC(18,2) 19
6 GROUPDESC CHARACTER VARYING(255) 255
7 ALIASCODE CHARACTER VARYING(75) 75
8 ADD1ADDR CHARACTER VARYING(100) 100
9 ADD2ADDR CHARACTER VARYING(100) 100
10 SUBURBADDR CHARACTER VARYING(50) 50
11 STATEADDR CHARACTER VARYING(3) 3
12 POSTCODEADDR CHARACTER VARYING(4) 4
13 REG1ADDR CHARACTER VARYING(75) 75
14 REG2ADDR CHARACTER VARYING(75) 75
15 REGSUBURBADDR CHARACTER VARYING(50) 50
16 REGSTATEADDR CHARACTER VARYING(3) 3
17 REGPOSTCODEADDR CHARACTER VARYING(4) 4
18 FK_TBISR_TITLE_DIRTITLEID INTEGER 4
19 DIRLASTNAM CHARACTER VARYING(100) 100
20 DIRMIDDLENAM CHARACTER VARYING(100) 100
21 DIRFIRSTNAM CHARACTER VARYING(100) 100
22 FK_TBISR_TITLE_DIRSECTITLEID INTEGER 4
23 DIRSECLASTNAM CHARACTER VARYING(100) 100
24 DIRSECMIDDLENAM CHARACTER VARYING(100) 100
25 DIRSECFIRSTNAM CHARACTER VARYING(100) 100
26 ABNNO CHARACTER VARYING(15) 15
27 ACNNO CHARACTER VARYING(15) 15
28 BNNO CHARACTER VARYING(50) 50
29 PHONENO CHARACTER VARYING(50) 50
30 FAXNO CHARACTER VARYING(50) 50
31 MOBILENO CHARACTER VARYING(50) 50
32 STARTDATE TIMESTAMP 8
33 TERMINATIONDATE TIMESTAMP 8
34 CLAWBACKARREARSFLAG INTEGER 4
35 FPOFLAG INTEGER 4
36 SENDSMSTOTYPE CHARACTER VARYING(50) 50
37 EMAILNAM CHARACTER VARYING(100) 100
38 BPWEBEXPORTFLAG INTEGER 4
39 EMAILINVOICESFLAG INTEGER 4
40 DIVISIONIND CHARACTER VARYING(50) 50
41 SYSRL_USER CHARACTER VARYING(50) 50
42 SYSRL_TIMESTAMP TIMESTAMP 8
43 SYSR_DELETED INTEGER 4
44 SYSR_DELETEDBY CHARACTER VARYING(50) 50
45 SYSR_DELETEDON TIMESTAMP 8
46 FK_TBISR_GROUPTYPE_GROUPTYPEID INTEGER 4
47 FK_TBISR_RESOURCETYPE INTEGER 4
48 COB DATE 4
49 DELTA_TYPE CHARACTER VARYING(1) 1
50 EFFECTIVE_STRT_DT TIMESTAMP 8
51 EFFECTIVE_END_DT TIMESTAMP 8
52 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
53 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
54 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
55 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8