INT_PCSRCPN_CLMRIEFF

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 TRANDATE INTEGER 4
11 TRANTIME INTEGER 4
12 TRANTYPE CHARACTER VARYING(4) 4
13 LINENO SMALLINT 2
14 RIACCT CHARACTER VARYING(4) 4
15 ACCTTYPE CHARACTER VARYING(1) 1
16 OSEST NUMERIC(11,2) 19
17 PAID NUMERIC(11,2) 19
18 TTYYRMTH INTEGER 4
19 ITCESTAMT NUMERIC(11,2) 19
20 ITCPAYAMT NUMERIC(11,2) 19
21 PAYWITC NUMERIC(11,2) 19
22 GSTITCIND CHARACTER VARYING(1) 1