PRT_REFERRAL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

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