PRT_PATAIL

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 PABTHDTE INTEGER 4
10 PADEATH INTEGER 4
11 PAWKSIACC SMALLINT 2
12 PAACWKPAY SMALLINT 2
13 PAWKSIILL SMALLINT 2
14 PAILWKPAY SMALLINT 2
15 PAGENDER CHARACTER VARYING(1) 1
16 PASMOKER CHARACTER VARYING(1) 1
17 PAEYELIMB INTEGER 4
18 PAEYELIMS INTEGER 4
19 PATOTDIS INTEGER 4
20 PABLDPARA INTEGER 4
21 PAROCCUP CHARACTER VARYING(4) 4
22 PAWRKPERF CHARACTER VARYING(1) 1
23 PABENFTWK SMALLINT 2
24 PACOVREST CHARACTER VARYING(1) 1
25 PAPARTACC SMALLINT 2
26 PACVRRST1 CHARACTER VARYING(1) 1
27 PACVRRST2 CHARACTER VARYING(1) 1
28 PACVRRST3 CHARACTER VARYING(1) 1
29 PAUNITS SMALLINT 2
30 PAMLTDISC CHARACTER VARYING(2) 2
31 PAACCUM CHARACTER VARYING(1) 1
32 PAINSNAME CHARACTER VARYING(35) 35
33 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 RECORD_TYPE CHARACTER VARYING(16) 16
35 COMMIT_TIMESTAMP TIMESTAMP 8
36 EXTRACT_TIMESTAMP TIMESTAMP 8
37 CDC_ID BIGINT 8
38 COMPANY_CDC SMALLINT 2
39 POLICY_CDC BIGINT 8
40 ACTIVTO_CDC DATE 4
41 EFFECTDTE_CDC DATE 4
42 DW_TIMESTAMP TIMESTAMP 8