INT_PCSRCPN_FITAIL

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 FIROCCUP CHARACTER VARYING(4) 4
17 FIEMPCSH SMALLINT 2
18 FIEMPOUT SMALLINT 2
19 FIEMPOTH SMALLINT 2
20 FIEMPNRSP SMALLINT 2
21 FIEMPTOT INTEGER 4
22 FILMTEMP INTEGER 4
23 FIDEDEMP INTEGER 4
24 FILMTALL INTEGER 4
25 FIDEDALL INTEGER 4
26 FIBLKTCVR CHARACTER VARYING(1) 1
27 FIEMPNME1 CHARACTER VARYING(27) 27
28 FIEMPDUT1 CHARACTER VARYING(18) 18
29 FICLASS1 CHARACTER VARYING(1) 1
30 FIGTAMT1 INTEGER 4
31 FIDEDTBL1 INTEGER 4
32 FIEMPNME2 CHARACTER VARYING(27) 27
33 FIEMPDUT2 CHARACTER VARYING(18) 18
34 FICLASS2 CHARACTER VARYING(1) 1
35 FIGTAMT2 INTEGER 4
36 FIDEDTBL2 INTEGER 4
37 FIEMPNME3 CHARACTER VARYING(27) 27
38 FIEMPDUT3 CHARACTER VARYING(18) 18
39 FICLASS3 CHARACTER VARYING(1) 1
40 FIGTAMT3 INTEGER 4
41 FIDEDTBL3 INTEGER 4
42 FIEMPNME4 CHARACTER VARYING(27) 27
43 FIEMPDUT4 CHARACTER VARYING(18) 18
44 FICLASS4 CHARACTER VARYING(1) 1
45 FIGTAMT4 INTEGER 4
46 FIDEDTBL4 INTEGER 4
47 FIEMPNME5 CHARACTER VARYING(27) 27
48 FIEMPDUT5 CHARACTER VARYING(18) 18
49 FICLASS5 CHARACTER VARYING(1) 1
50 FIGTAMT5 INTEGER 4
51 FIDEDTBL5 INTEGER 4
52 FIEMPNME6 CHARACTER VARYING(27) 27
53 FIEMPDUT6 CHARACTER VARYING(18) 18
54 FICLASS6 CHARACTER VARYING(1) 1
55 FIGTAMT6 INTEGER 4
56 FIDEDTBL6 INTEGER 4
57 FIEMPNME7 CHARACTER VARYING(27) 27
58 FIEMPDUT7 CHARACTER VARYING(18) 18
59 FICLASS7 CHARACTER VARYING(1) 1
60 FIGTAMT7 INTEGER 4
61 FIDEDTBL7 INTEGER 4