INT_BASE_PI_RES_PCSS_POLICY_MOTOR

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 RISKPOSTCODE CHARACTER(9) 9
15 RISKSTATECODE CHARACTER VARYING(3) 3
16 SALESTRANSDATE DATE 4
17 TERMID CHARACTER VARYING(3) 3
18 TERMOFBUSINESSCODE CHARACTER VARYING(1) 1
19 TX_N CHARACTER VARYING(2) 2
20 PAYPLANCODE CHARACTER(2) 2
21 POLICYID CHARACTER VARYING(10) 10
22 PRODUCTCODE CHARACTER VARYING(4) 4
23 COVERTRANSACTIONCODE CHARACTER VARYING(8) 8
24 REPORTDATE DATE 4
25 TRANSACTIONTYPE CHARACTER VARYING(2) 2
26 TIMESTAMPUPDATED TIMESTAMP 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
34 COMM_ACCOUNT_1 CHARACTER(10) 10
35 COMM_ACCOUNT_2 CHARACTER(10) 10