INT_PCSRCPN_CLMSTALI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MD5_KEY CHARACTER VARYING(128) 128
2 REC_TYPE_CD INTEGER 4
3 BATCH_KEY INTEGER 4
4 RUN_REG_KEY BIGINT 8
5 ROW_INSERT_DT TIMESTAMP 8
6 ROW_EFFECTIVE_DT TIMESTAMP 8
7 AUDIT_FLAG CHARACTER VARYING(1) 1
8 COMPANY SMALLINT 2
9 CLAIMNO NUMERIC(11,0) 19
10 CATEGORY CHARACTER VARYING(1) 1
11 CIRCUMST CHARACTER VARYING(1) 1
12 CLMNTTYP CHARACTER VARYING(2) 2
13 LITIGATED CHARACTER VARYING(1) 1
14 JRSDCTN CHARACTER VARYING(3) 3
15 CAUSE CHARACTER VARYING(3) 3
16 GNLNAT CHARACTER VARYING(1) 1
17 BDYFNCT CHARACTER VARYING(1) 1
18 SEVERITY CHARACTER VARYING(2) 2
19 VRFYUSR CHARACTER VARYING(8) 8
20 VRFYDTE INTEGER 4