INT_BASE_PI_JCI_ITEM_SAS_T1

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRODUCT CHARACTER(3) 3
2 SALES_DATE INTEGER 4
3 SALESCLASS CHARACTER(3) 3
4 SALES_CVN CHARACTER VARYING(1) 1
5 SALES_POL CHARACTER VARYING(1) 1
6 PREMREASA CHARACTER(2) 2
7 RISKSTATE CHARACTER(2) 2
8 RISKDESC1 CHARACTER(50) 50
9 LOADINGPC NUMERIC(5,2) 19
10 POLICY INTEGER 4
11 SUMINS INTEGER 4
12 REP SMALLINT 2
13 ANNUALPRM NUMERIC(20,2) 19
14 AUTO_PREMIUM CHARACTER(1) 1
15 CVNDATE INTEGER 4
16 INCEPTION INTEGER 4
17 POLDATE INTEGER 4
18 QTEDATE INTEGER 4
19 YRSWITHAAMI INTEGER 4
20 TERMINCEP INTEGER 4
21 ITEMNO SMALLINT 2
22 TRANCNT SMALLINT 2
23 COMPANY SMALLINT 2
24 LOCATNREF INTEGER 4
25 COMPLTIND CHARACTER(1) 1
26 CLIENT INTEGER 4
27 PRVPOLREF CHARACTER(14) 14
28 ACTIVTO INTEGER 4