PRT_PRIORCLM

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 LINENO SMALLINT 2
5 TRANCNT SMALLINT 2
6 ACTIVFROM INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 PCLMYEAR SMALLINT 2
10 PCLMTYPE CHARACTER VARYING(2) 2
11 PCLMAMT INTEGER 4
12 PCLMDESC1 CHARACTER VARYING(50) 50
13 PCLMDESC2 CHARACTER VARYING(50) 50
14 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 RECORD_TYPE CHARACTER VARYING(16) 16
16 COMMIT_TIMESTAMP TIMESTAMP 8
17 EXTRACT_TIMESTAMP TIMESTAMP 8
18 CDC_ID BIGINT 8
19 COMPANY_CDC SMALLINT 2
20 POLICY_CDC BIGINT 8
21 ACTIVTO_CDC DATE 4
22 DW_TIMESTAMP TIMESTAMP 8
23 ANZSICCD CHARACTER(8) 8
24 NOCLAIMS SMALLINT 2
25 NOEMPS INTEGER 4
26 WAGESAMT NUMERIC(11,0) 19
27 ESTOUTAMT INTEGER 4
28 RECOVDAMT INTEGER 4
29 INCURDAMT INTEGER 4
30 TERMSTART INTEGER 4
31 TERMEND INTEGER 4
32 REPORTDTE INTEGER 4
33 NOCLAIM1K SMALLINT 2