INT_CIBSECCS_D011_CMOV_STG01

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTIONID BIGINT 8
2 CHECKID BIGINT 8
3 CLAIMCONTACTID BIGINT 8
4 COSTCATEGORY BIGINT 8
5 COSTTYPE BIGINT 8
6 TRANSACTIONCREATETIME TIMESTAMP 8
7 TRANSACTIONUPDATETIME TIMESTAMP 8
8 EXPOSUREID BIGINT 8
9 PAYMENTTYPE BIGINT 8
10 PUBLICID CHARACTER VARYING(64) 64
11 RECOVERYCATEGORY BIGINT 8
12 RESERVELINEID BIGINT 8
13 SC_DEDUCTEXCESS CHARACTER VARYING(1) 1
14 SC_RECEIPTPAYMENTMETHOD BIGINT 8
15 TRANSACTIONSTATUS CHARACTER VARYING(50) 50
16 TRANSACTIONSUBTYPE CHARACTER VARYING(50) 50
17 SC_SUBROADVERSEPARTYID BIGINT 8
18 SC_PAYMENTTYPE BIGINT 8
19 DOESNOTERODERESERVES CHARACTER VARYING(1) 1
20 CLAIMID BIGINT 8
21 POLICYID BIGINT 8
22 CLAIMNUMBER CHARACTER VARYING(40) 40
23 CLAIMSTATE BIGINT 8
24 POLICYNUMBER CHARACTER VARYING(40) 40
25 LINEOFBUSINESS BIGINT 8
26 MVBRAND BIGINT 8
27 REOPENDATE TIMESTAMP 8
28 INCIDENTSUBTYPE CHARACTER VARYING(50) 50
29 CLAIMAMOUNT NUMERIC(18,2) 19
30 CREATEUSERID BIGINT 8
31 TLI_ID BIGINT 8
32 RECORDTYPE CHARACTER VARYING(1) 1
33 LINECATEGORY BIGINT 8
34 LOADCOMMANDID BIGINT 8
35 RETIRED BIGINT 8
36 IAMAMOUNT NUMERIC(18,2) 19
37 SC_CONSOLINVITEMFKID BIGINT 8
38 SC_DAMAMOUNT NUMERIC(18,2) 19
39 SC_DAMSETTLEMENTAMOUNT NUMERIC(18,2) 19
40 OFFSETAMOUNT NUMERIC(18,2) 19
41 SC_EXCESSGST NUMERIC(18,2) 19
42 RECOVEREDAMOUNT NUMERIC(18,2) 19
43 RESERVEMOVEMENT NUMERIC(20,2) 19
44 RECOVERYRESERVEMOVEMENT NUMERIC(20,2) 19
45 PAIDAMOUNT NUMERIC(18,2) 19
46 DAMAMOUNT NUMERIC(20,2) 19
47 SC_GSTAMOUNT NUMERIC(18,2) 19
48 SC_GSTSTATUS BIGINT 8
49 SC_ITCAMOUNT NUMERIC(18,2) 19
50 SC_ITCEPERCENT BIGINT 8
51 SC_ITCETYPE BIGINT 8
52 SC_RESERVEGSTAMOUNT NUMERIC(18,2) 19
53 SC_SETTLEMENTAMOUNT NUMERIC(18,2) 19
54 SC_TAXAMOUNT NUMERIC(18,2) 19
55 TRANSACTIONAMOUNT NUMERIC(18,2) 19
56 TLI_CREATETIME TIMESTAMP 8
57 TLI_UPDATETIME TIMESTAMP 8
58 UPDATEUSERID BIGINT 8
59 LOSSPARTY BIGINT 8
60 EXPOSURETYPE BIGINT 8
61 CLAIMORDER BIGINT 8
62 EXPOSURESTATUS CHARACTER VARYING(50) 50