PRT_CLMRIVER

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLAIMNO NUMERIC(11,0) 19
3 RIVERSION SMALLINT 2
4 TRANDATE INTEGER 4
5 MANUALRI CHARACTER VARYING(1) 1
6 SELFRERSK CHARACTER VARYING(1) 1
7 EOLNO INTEGER 4
8 UNDERLY NUMERIC(11,2) 19
9 QSEOLNO INTEGER 4
10 CATNO INTEGER 4
11 SPECNO INTEGER 4
12 SUPUSERID CHARACTER VARYING(8) 8
13 RILINECNT SMALLINT 2
14 RIDETVERS SMALLINT 2
15 EOLINC CHARACTER VARYING(1) 1
16 TERMINCEP INTEGER 4
17 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 RECORD_TYPE CHARACTER VARYING(16) 16
19 COMMIT_TIMESTAMP TIMESTAMP 8
20 EXTRACT_TIMESTAMP TIMESTAMP 8
21 CDC_ID BIGINT 8
22 COMPANY_CDC SMALLINT 2
23 TRANDATE_CDC DATE 4
24 DW_TIMESTAMP TIMESTAMP 8