INT_BASE_PI_RES_Z4O1_W4D0_STG_01

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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