INT_WCOM_DISTINCT_REFERRALS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 POLICY INTEGER 4
5 ITEMNO SMALLINT 2
6 TRANCNT SMALLINT 2
7 LINENO SMALLINT 2
8 CONTEXT CHARACTER(8) 8
9 REFERTYPE CHARACTER(2) 2
10 REFERKEY CHARACTER(8) 8
11 VALUEX1 CHARACTER(20) 20
12 VALUEN1 NUMERIC(15,4) 19
13 VALUEX2 CHARACTER(20) 20
14 VALUEN2 NUMERIC(15,4) 19
15 LEVEL CHARACTER(2) 2
16 WARNNO CHARACTER(4) 4
17 STATUS CHARACTER(1) 1
18 VOIDFLAG CHARACTER(1) 1
19 APPLID CHARACTER(4) 4
20 PROGID CHARACTER(8) 8
21 AGENT INTEGER 4
22 CLASS CHARACTER(3) 3
23 SUBCLASS CHARACTER(3) 3
24 REFERBY CHARACTER(8) 8
25 REFERDATE INTEGER 4
26 REFERTIME INTEGER 4
27 EFFECTDTE INTEGER 4
28 ACTIONBY CHARACTER(8) 8
29 ACTDATE INTEGER 4
30 ACTTIME INTEGER 4
31 JOBNAME CHARACTER(8) 8
32 REPORTID CHARACTER(8) 8
33 ERRNO CHARACTER(4) 4
34 RUNDATE INTEGER 4
35 MSGTYPE CHARACTER(1) 1
36 POLICY_TERMSTART INTEGER 4
37 POLICY_DUE_DATE_KEY INTEGER 4