PRT_USERID

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 USERID CHARACTER(8) 8
2 COMPANY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 SUBCOY SMALLINT 2
6 MAINTDATE INTEGER 4
7 MAINTUSER CHARACTER(8) 8
8 USERLEVEL CHARACTER(1) 1
9 WORKSTNID CHARACTER(8) 8
10 PASSWORD CHARACTER(8) 8
11 PSWDHIST1 CHARACTER(8) 8
12 PSWDHIST2 CHARACTER(8) 8
13 PSWDHIST3 CHARACTER(8) 8
14 PSWDHIST4 CHARACTER(8) 8
15 PSWDHIST5 CHARACTER(8) 8
16 TITLE CHARACTER(30) 30
17 FIRSTNAME CHARACTER(30) 30
18 SURNAME CHARACTER(40) 40
19 ADDRESS1 CHARACTER(31) 31
20 ADDRESS2 CHARACTER(31) 31
21 POSTCODE NUMERIC(6,0) 19
22 SECURTY01 CHARACTER(1) 1
23 SECURTY02 CHARACTER(1) 1
24 SECURTY03 CHARACTER(1) 1
25 SECURTY04 CHARACTER(1) 1
26 SECURTY05 CHARACTER(1) 1
27 SECURTY06 CHARACTER(1) 1
28 SECURTY07 CHARACTER(1) 1
29 SECURTY08 CHARACTER(1) 1
30 SECURTY09 CHARACTER(1) 1
31 SECURTY10 CHARACTER(1) 1
32 SECURTY11 CHARACTER(1) 1
33 SECURTY12 CHARACTER(1) 1
34 SECURTY13 CHARACTER(1) 1
35 SECURTY14 CHARACTER(1) 1
36 SECURTY15 CHARACTER(1) 1
37 SECURTY16 CHARACTER(1) 1
38 SECURTY17 CHARACTER(1) 1
39 SECURTY18 CHARACTER(1) 1
40 SECURTY19 CHARACTER(1) 1
41 SECURTY20 CHARACTER(1) 1
42 PF14PROG CHARACTER(8) 8
43 PF15PROG CHARACTER(8) 8
44 PF16PROG CHARACTER(8) 8
45 PF17PROG CHARACTER(8) 8
46 PF18PROG CHARACTER(8) 8
47 PF19PROG CHARACTER(8) 8
48 PF20PROG CHARACTER(8) 8
49 PF21PROG CHARACTER(8) 8
50 PF22PROG CHARACTER(8) 8
51 PF23PROG CHARACTER(8) 8
52 LASTPROG CHARACTER(8) 8
53 MONYLIM01 INTEGER 4
54 MONYLIM02 INTEGER 4
55 MONYLIM03 INTEGER 4
56 MONYLIM04 INTEGER 4
57 MONYLIM05 INTEGER 4
58 MONYLIM06 INTEGER 4
59 MONYLIM07 INTEGER 4
60 MONYLIM08 INTEGER 4
61 MONYLIM09 INTEGER 4
62 MONYLIM10 INTEGER 4
63 MONYLIM11 INTEGER 4
64 MONYLIM12 INTEGER 4
65 PRINTER CHARACTER(8) 8
66 UNDERSCOR CHARACTER(1) 1
67 ACCOUNT CHARACTER(11) 11
68 PROFILE CHARACTER(4) 4
69 CLMFCEPRT CHARACTER(8) 8
70 CERTIFPRT CHARACTER(8) 8
71 CHEQUEPRT CHARACTER(8) 8
72 RECEPTPRT CHARACTER(8) 8
73 STATMTPRT CHARACTER(8) 8
74 STDLTRPRT CHARACTER(8) 8
75 MAILCOUNT INTEGER 4
76 UBIUSERIND CHARACTER(1) 1
77 COSTCNTR CHARACTER(4) 4
78 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 RECORD_TYPE CHARACTER VARYING(16) 16
80 COMMIT_TIMESTAMP TIMESTAMP 8
81 EXTRACT_TIMESTAMP TIMESTAMP 8
82 CDC_ID BIGINT 8
83 COMPANY_CDC SMALLINT 2
84 DW_TIMESTAMP TIMESTAMP 8