INT_PCSRCPN_PRT_CLASSTYP

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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