PRT_CTP_CLTCOMLG

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 COMMTYPE CHARACTER(4) 4
3 GUID CHARACTER(36) 36
4 COMMCHNL CHARACTER(4) 4
5 COMMVERS SMALLINT 2
6 COYCOMM CHARACTER(20) 20
7 CLTCOMM CHARACTER(20) 20
8 COYCOMML CHARACTER VARYING(120) 120
9 CLTCOMML CHARACTER VARYING(120) 120
10 CLIENT INTEGER 4
11 PRODUCT CHARACTER(3) 3
12 POLICY INTEGER 4
13 CLAIMNO NUMERIC(11,0) 19
14 TRANCNT SMALLINT 2
15 PROGID CHARACTER(8) 8
16 TRANUSER CHARACTER(8) 8
17 TRANDATE INTEGER 4
18 TRANTIME INTEGER 4
19 MSGPART SMALLINT 2
20 RETRYIND CHARACTER(1) 1
21 XMITSTATUS CHARACTER(4) 4
22 XMITDATE INTEGER 4
23 XMITTIME INTEGER 4
24 SUBMRCPT CHARACTER(1) 1
25 SUBMDATE INTEGER 4
26 SUBMTIME INTEGER 4
27 SUBMSTATUS CHARACTER(4) 4
28 DLVRRCPT CHARACTER(1) 1
29 DLVRDATE INTEGER 4
30 DLVRTIME INTEGER 4
31 DLVRSTATUS CHARACTER(4) 4
32 RPLYIND CHARACTER(1) 1
33 RPLYDATE INTEGER 4
34 RPLYTIME INTEGER 4
35 RPLYSTATUS CHARACTER(4) 4
36 RPLYDESC CHARACTER(20) 20
37 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 RECORD_TYPE CHARACTER VARYING(16) 16
39 COMMIT_TIMESTAMP TIMESTAMP 8
40 EXTRACT_TIMESTAMP TIMESTAMP 8