INT_BASE_PI_RES_PCSS_POLICY_HOME_NEW

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY CHARACTER(3) 3
2 CONVERTEDFROM CHARACTER(10) 10
3 COVEREXPIRYDATE DATE 4
4 COVERNUMBER CHARACTER VARYING(3) 3
5 COVERSEQ CHARACTER VARYING(3) 3
6 COVERSUBCODE CHARACTER VARYING(3) 3
7 EFFECTIVEDATE DATE 4
8 PAIDSTATUS CHARACTER VARYING(1) 1
9 CANLAPREVEFFDT DATE 4
10 POLICYSTATUS CHARACTER(2) 2
11 DATEPAID DATE 4
12 DATEAPPROVED DATE 4
13 ISSUEDPAIDFLAG CHARACTER VARYING(1) 1
14 PAYPLANCODE CHARACTER(2) 2
15 POLICYID CHARACTER VARYING(10) 10
16 PRODUCTCODE CHARACTER VARYING(5) 5
17 REPORTDATE DATE 4
18 RISKPOSTCODE CHARACTER(9) 9
19 RISKSTATECODE CHARACTER VARYING(3) 3
20 SALESTRANSDATE DATE 4
21 TERMID CHARACTER VARYING(3) 3
22 TRANSACTIONTYPE CHARACTER VARYING(2) 2
23 TIMESTAMPUPDATED TIMESTAMP 8
24 TERMOFBUSINESSCODE CHARACTER VARYING(1) 1
25 TX_N CHARACTER VARYING(2) 2
26 COVERTRANSACTIONCODE CHARACTER VARYING(8) 8
27 POLICYNUMBER CHARACTER VARYING(10) 10
28 COVERAGENUMBER CHARACTER VARYING(3) 3
29 TERMIDENT CHARACTER VARYING(3) 3
30 SEQUENCEALPHA CHARACTER VARYING(3) 3
31 COVERAGECODE CHARACTER VARYING(2) 2
32 REVERSALINDIC CHARACTER VARYING(1) 1
33 SUBCOVERIDENT CHARACTER VARYING(1) 1