TBIST_INTUSER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INTUSER_HIID INTEGER 4
2 PK_TBIST_INTUSER_INTUSERID INTEGER 4
3 INTERNALUSERIDCODE CHARACTER VARYING(7) 7
4 FK_TBISR_POSITION_POSITIONID INTEGER 4
5 REGIONCODE INTEGER 4
6 FK_TTRKR_TEAM_TEAMID INTEGER 4
7 FIRSTNAM CHARACTER VARYING(50) 50
8 LASTNAM CHARACTER VARYING(50) 50
9 EMAILADDR CHARACTER VARYING(100) 100
10 PPMFLAG INTEGER 4
11 PPMBRANCHCODE CHARACTER VARYING(50) 50
12 SBBMFLAG INTEGER 4
13 SBBMBRANCHCODE CHARACTER VARYING(50) 50
14 LSOLUTIONSOFFICERFLAG INTEGER 4
15 LSUPPORTOFFICERFLAG INTEGER 4
16 LOFFICERFLAG INTEGER 4
17 BCADMINFLAG INTEGER 4
18 LEADERFLAG INTEGER 4
19 COPSFLAG INTEGER 4
20 SETTLEMENTOFFICERFLAG INTEGER 4
21 PAYMENTOFFICERFLAG INTEGER 4
22 SUPERADMIN INTEGER 4
23 BPACCESSFLAG INTEGER 4
24 FK_TBISR_AUTHTYPE_AUTHTYPEID INTEGER 4
25 ACTIVEFLAG INTEGER 4
26 ICSSFLAG INTEGER 4
27 SYSRL_USER CHARACTER VARYING(50) 50
28 SYSRL_TIMESTAMP TIMESTAMP 8
29 SYSR_DELETED INTEGER 4
30 SYSR_DELETEDBY CHARACTER VARYING(50) 50
31 SYSR_DELETEDON TIMESTAMP 8
32 CONTACTNO CHARACTER VARYING(50) 50
33 BBMFLAG INTEGER 4
34 COB DATE 4
35 DELTA_TYPE CHARACTER VARYING(1) 1
36 EFFECTIVE_STRT_DT TIMESTAMP 8
37 EFFECTIVE_END_DT TIMESTAMP 8
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8