PRT_HST_POLICY

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 TRANCNT SMALLINT 2
5 IMAGEFLAG CHARACTER(1) 1
6 COMPLTIND CHARACTER(1) 1
7 CLIENT INTEGER 4
8 STATE SMALLINT 2
9 BRANCH SMALLINT 2
10 PRVPOLREF CHARACTER(14) 14
11 EFFECTDTE INTEGER 4
12 ACTIVTO INTEGER 4
13 POLSTATUS CHARACTER(1) 1
14 REASON SMALLINT 2
15 INCEPTION INTEGER 4
16 TIMEFROM SMALLINT 2
17 TIMETO SMALLINT 2
18 REP SMALLINT 2
19 AGENT INTEGER 4
20 POLICYFEE NUMERIC(7,2) 19
21 DUEDATE INTEGER 4
22 RNWALTERM SMALLINT 2
23 REVIEWIND CHARACTER(1) 1
24 NTCETO CHARACTER(1) 1
25 NTCEPROD CHARACTER(1) 1
26 NTCETYPE CHARACTER(1) 1
27 CLAUSEIND CHARACTER(1) 1
28 SPCLSIND CHARACTER(1) 1
29 MSGIND CHARACTER(1) 1
30 FORM CHARACTER(10) 10
31 BUSNESSRC CHARACTER(4) 4
32 COYISSUED SMALLINT 2
33 STISSUED CHARACTER(2) 2
34 CUSTREF CHARACTER(14) 14
35 DEBITBSB INTEGER 4
36 DEBITACC INTEGER 4
37 INSTALFRQ CHARACTER(1) 1
38 INSTALAMT NUMERIC(9,2) 19
39 INSTALVAR NUMERIC(9,2) 19
40 PRIORCLM CHARACTER(1) 1
41 CANCDECLN CHARACTER(1) 1
42 IMPEXCESS CHARACTER(1) 1
43 LOCKUSER CHARACTER(8) 8
44 LOCKDATE INTEGER 4
45 LOCKTIME INTEGER 4
46 QTEPRDUCT CHARACTER(3) 3
47 BRCHRESP SMALLINT 2
48 BUSDESC CHARACTER(1) 1
49 SEQPOLICY INTEGER 4
50 TERMSTART INTEGER 4
51 CNOTEEND INTEGER 4
52 DISCGRP CHARACTER(1) 1
53 REPLPOLNO CHARACTER(14) 14
54 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
55 RECORD_TYPE CHARACTER VARYING(16) 16
56 COMMIT_TIMESTAMP TIMESTAMP 8
57 EXTRACT_TIMESTAMP TIMESTAMP 8
58 CDC_ID BIGINT 8
59 COMPANY_CDC SMALLINT 2
60 ACTIVTO_CDC DATE 4
61 POLICY_CDC INTEGER 4
62 AGREEMENT_TYPE_CDC CHARACTER(3) 3
63 EFFECTDTE_CDC DATE 4
64 DW_TIMESTAMP TIMESTAMP 8
65 CORPID CHARACTER(4) 4
66 HOLDCOVER CHARACTER(1) 1
67 LINKEDPOL CHARACTER(1) 1
68 CAPEUUID CHARACTER VARYING(36) 36
69 SDDECCODE CHARACTER(1) 1