INT_PCSRCPN_SLTAIL

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 PRODUCT CHARACTER VARYING(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 TRANCNT SMALLINT 2
15 IMAGEFLAG CHARACTER VARYING(1) 1
16 SLGENLIAB NUMERIC(11,0) 19
17 SLPRDLIAB NUMERIC(11,0) 19
18 SLROCCUP CHARACTER VARYING(4) 4
19 SLSICCODE CHARACTER VARYING(3) 3
20 SLRATEMTH CHARACTER VARYING(2) 2
21 SLFACTNO INTEGER 4
22 SLWAGES NUMERIC(11,0) 19
23 SLTURNOVR NUMERIC(11,0) 19
24 SLCONTAMT NUMERIC(11,0) 19
25 SLCVRTYPE CHARACTER VARYING(2) 2
26 SLTOCPOLT CHARACTER VARYING(1) 1
27 SLLOIPOLT NUMERIC(11,0) 19
28 SLNODIR SMALLINT 2
29 SLTOTASS NUMERIC(11,0) 19
30 SLTOTLIAB NUMERIC(11,0) 19
31 SLLOICO NUMERIC(11,0) 19
32 SLLOIIND NUMERIC(11,0) 19
33 SLPUBINSR CHARACTER VARYING(20) 20
34 SLPUBPOL CHARACTER VARYING(20) 20
35 SLPUBLOI NUMERIC(11,0) 19
36 SLPRDINSR CHARACTER VARYING(20) 20
37 SLPRDPOL CHARACTER VARYING(20) 20
38 SLPRDLOI NUMERIC(11,0) 19
39 SLMOTINSR CHARACTER VARYING(20) 20
40 SLMOTPOL CHARACTER VARYING(20) 20
41 SLMOTLOI NUMERIC(11,0) 19
42 SLWKRINSR CHARACTER VARYING(20) 20
43 SLWKRPOL CHARACTER VARYING(20) 20
44 SLWKRLOI NUMERIC(11,0) 19
45 SLMARINSR CHARACTER VARYING(20) 20
46 SLMARPOL CHARACTER VARYING(20) 20
47 SLMARLOI NUMERIC(11,0) 19
48 SLAVNINSR CHARACTER VARYING(20) 20
49 SLAVNPOL CHARACTER VARYING(20) 20
50 SLAVNLOI NUMERIC(11,0) 19
51 SLOTHINSR CHARACTER VARYING(20) 20
52 SLOTHPOL CHARACTER VARYING(20) 20
53 SLOTHLOI NUMERIC(11,0) 19
54 SLUWINFO CHARACTER VARYING(212) 212