INT_BASE_PI_RES_Z4O1_W4D0_STG

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CANLAPREVEFFDT DATE 4
2 COVCHGEFFDATE DATE 4
3 COVCHGEXPDATE DATE 4
4 COVERAGECODE CHARACTER VARYING(2) 2
5 COVERAGENUMBER CHARACTER VARYING(3) 3
6 COVERSUBCODE CHARACTER VARYING(3) 3
7 DATEAPPROVED DATE 4
8 DATECREATED DATE 4
9 DATEPAID DATE 4
10 TIMESTAMPUPDATED TIMESTAMP 8
11 PAIDSTATUS CHARACTER VARYING(1) 1
12 POLICYNUMBER CHARACTER VARYING(10) 10
13 REVERSALINDIC CHARACTER VARYING(1) 1
14 SEQUENCEALPHA CHARACTER VARYING(3) 3
15 STATE CHARACTER VARYING(3) 3
16 TERMIDENT CHARACTER VARYING(3) 3
17 JOIN_TYPE CHARACTER VARYING(1) 1
18 SUBCOVERIDENT CHARACTER VARYING(1) 1
19 TRANSACTIONTYPE CHARACTER VARYING(2) 2
20 PRODUCTTYPE CHARACTER VARYING(2) 2