PRT_PAYOFSET

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 ENCRPAYNO INTEGER 4
4 RECEIPT INTEGER 4
5 RECEIPTSEQ SMALLINT 2
6 RECOVTYPE CHARACTER VARYING(2) 2
7 LINENO SMALLINT 2
8 TRANDATE INTEGER 4
9 TRANTIME INTEGER 4
10 PAYMNTTYP CHARACTER VARYING(2) 2
11 DEDUCTCDE CHARACTER VARYING(4) 4
12 COLLMETH CHARACTER VARYING(2) 2
13 AMOUNT NUMERIC(9,2) 19
14 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 RECORD_TYPE CHARACTER VARYING(16) 16
16 COMMIT_TIMESTAMP TIMESTAMP 8
17 EXTRACT_TIMESTAMP TIMESTAMP 8
18 CDC_ID BIGINT 8
19 COMPANY_CDC SMALLINT 2
20 TRANDATE_CDC DATE 4
21 DW_TIMESTAMP TIMESTAMP 8