PRT_CLASSTYP

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 STDEXCESS INTEGER 4
5 AUTOINDEX CHARACTER(1) 1
6 DSTRCTIND CHARACTER(1) 1
7 FIREBRIND CHARACTER(1) 1
8 RISKIND CHARACTER(1) 1
9 OCCUPIND CHARACTER(1) 1
10 BASICMCI CHARACTER(1) 1
11 PREMALPSI CHARACTER(1) 1
12 STPDTYMCI CHARACTER(1) 1
13 SDALPHASI CHARACTER(1) 1
14 CHGMCI CHARACTER(1) 1
15 CHGALPHSI CHARACTER(1) 1
16 COMISNMCI CHARACTER(1) 1
17 BALSCHED CHARACTER(1) 1
18 COMPRODCT CHARACTER(1) 1
19 COMSUBCLS CHARACTER(1) 1
20 FLEETVEH CHARACTER(1) 1
21 DRVDETIND CHARACTER(1) 1
22 NCBIND CHARACTER(1) 1
23 RATINGIND CHARACTER(1) 1
24 BURGLARY CHARACTER(1) 1
25 REMOVEDEB CHARACTER(1) 1
26 CONSYRIND CHARACTER(1) 1
27 CONSCDIND CHARACTER(1) 1
28 CYCLONE CHARACTER(1) 1
29 ILLSIIND CHARACTER(1) 1
30 SIGREATER INTEGER 4
31 FFOODIND CHARACTER(1) 1
32 FROZEFOOD INTEGER 4
33 COINS CHARACTER(1) 1
34 NATCOVER CHARACTER(1) 1
35 NBINHIBIT CHARACTER(1) 1
36 DWELLIND CHARACTER(1) 1
37 OCCUPYIND CHARACTER(1) 1
38 LIABILITY INTEGER 4
39 PERLIABIN CHARACTER(1) 1
40 PERLIABEX CHARACTER(1) 1
41 INDOCCIND CHARACTER(1) 1
42 ASICIND CHARACTER(1) 1
43 CLTLOCIND CHARACTER(1) 1
44 COMLAWIND CHARACTER(1) 1
45 WAGENOIND CHARACTER(1) 1
46 ITMOCCUP CHARACTER(1) 1
47 RDESCIND CHARACTER(1) 1
48 GLASSES CHARACTER(1) 1
49 EXWORD CHARACTER(1) 1
50 FINANCE CHARACTER(1) 1
51 CLMTHSYR SMALLINT 2
52 CLMLSTYR SMALLINT 2
53 CLMLSTYRN SMALLINT 2
54 CLMTHSPOL SMALLINT 2
55 CLMLSTPOL SMALLINT 2
56 CLMPOLNO SMALLINT 2
57 CLMGRTER INTEGER 4
58 NCBEFFIND CHARACTER(1) 1
59 CLMMOVMT INTEGER 4
60 CLMINACT INTEGER 4
61 EMLSI CHARACTER(1) 1
62 MVREG CHARACTER(1) 1
63 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
64 RECORD_TYPE CHARACTER VARYING(16) 16
65 COMMIT_TIMESTAMP TIMESTAMP 8
66 EXTRACT_TIMESTAMP TIMESTAMP 8
67 CDC_ID BIGINT 8
68 COMPANY_CDC SMALLINT 2
69 DW_TIMESTAMP TIMESTAMP 8
70 CLASS CHARACTER(3) 3
71 SUBCLASS CHARACTER(3) 3
72 TAILORGRP CHARACTER(2) 2
73 MULTIGRP CHARACTER(2) 2
74 MAJORGRP CHARACTER(3) 3
75 SITCODE CHARACTER(2) 2
76 RISKDESC CHARACTER(50) 50
77 SICODE1 CHARACTER(3) 3
78 SICODE2 CHARACTER(3) 3
79 CHGCODE CHARACTER(2) 2
80 LOCALGRP CHARACTER(2) 2
81 PCODEGRP CHARACTER(2) 2
82 OCCUPGRP CHARACTER(2) 2
83 CLASIFIND CHARACTER(3) 3
84 CLMCLASS1 CHARACTER(3) 3
85 CLMSUBCL1 CHARACTER(3) 3
86 CLMCLASS2 CHARACTER(3) 3
87 CLMSUBCL2 CHARACTER(3) 3
88 WRK3RDIND CHARACTER(2) 2