PRT_FITAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 FIROCCUP CHARACTER VARYING(4) 4
10 FIEMPCSH SMALLINT 2
11 FIEMPOUT SMALLINT 2
12 FIEMPOTH SMALLINT 2
13 FIEMPNRSP SMALLINT 2
14 FIEMPTOT INTEGER 4
15 FILMTEMP INTEGER 4
16 FIDEDEMP INTEGER 4
17 FILMTALL INTEGER 4
18 FIDEDALL INTEGER 4
19 FIBLKTCVR CHARACTER VARYING(1) 1
20 FIEMPNME1 CHARACTER VARYING(27) 27
21 FIEMPDUT1 CHARACTER VARYING(18) 18
22 FICLASS1 CHARACTER VARYING(1) 1
23 FIGTAMT1 INTEGER 4
24 FIDEDTBL1 INTEGER 4
25 FIEMPNME2 CHARACTER VARYING(27) 27
26 FIEMPDUT2 CHARACTER VARYING(18) 18
27 FICLASS2 CHARACTER VARYING(1) 1
28 FIGTAMT2 INTEGER 4
29 FIDEDTBL2 INTEGER 4
30 FIEMPNME3 CHARACTER VARYING(27) 27
31 FIEMPDUT3 CHARACTER VARYING(18) 18
32 FICLASS3 CHARACTER VARYING(1) 1
33 FIGTAMT3 INTEGER 4
34 FIDEDTBL3 INTEGER 4
35 FIEMPNME4 CHARACTER VARYING(27) 27
36 FIEMPDUT4 CHARACTER VARYING(18) 18
37 FICLASS4 CHARACTER VARYING(1) 1
38 FIGTAMT4 INTEGER 4
39 FIDEDTBL4 INTEGER 4
40 FIEMPNME5 CHARACTER VARYING(27) 27
41 FIEMPDUT5 CHARACTER VARYING(18) 18
42 FICLASS5 CHARACTER VARYING(1) 1
43 FIGTAMT5 INTEGER 4
44 FIDEDTBL5 INTEGER 4
45 FIEMPNME6 CHARACTER VARYING(27) 27
46 FIEMPDUT6 CHARACTER VARYING(18) 18
47 FICLASS6 CHARACTER VARYING(1) 1
48 FIGTAMT6 INTEGER 4
49 FIDEDTBL6 INTEGER 4
50 FIEMPNME7 CHARACTER VARYING(27) 27
51 FIEMPDUT7 CHARACTER VARYING(18) 18
52 FICLASS7 CHARACTER VARYING(1) 1
53 FIGTAMT7 INTEGER 4
54 FIDEDTBL7 INTEGER 4
55 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
56 RECORD_TYPE CHARACTER VARYING(16) 16
57 COMMIT_TIMESTAMP TIMESTAMP 8
58 EXTRACT_TIMESTAMP TIMESTAMP 8
59 CDC_ID BIGINT 8
60 COMPANY_CDC SMALLINT 2
61 POLICY_CDC BIGINT 8
62 ACTIVTO_CDC DATE 4
63 EFFECTDTE_CDC DATE 4
64 DW_TIMESTAMP TIMESTAMP 8