INT_CIBSECCS_D014_CLMSTATUS_STG01

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMID BIGINT 8
2 CLAIMORDER BIGINT 8
3 CHECKID BIGINT 8
4 CLAIMAMOUNT BIGINT 8
5 CLAIMCONTACTID BIGINT 8
6 COSTTYPE BIGINT 8
7 EXPOSUREID BIGINT 8
8 ISREVERSED BIGINT 8
9 LINECATEGORY BIGINT 8
10 MVBRAND BIGINT 8
11 POLICYID BIGINT 8
12 POLICYNUMBER CHARACTER VARYING(40) 40
13 REOPENDATE TIMESTAMP 8
14 RESERVELINEID BIGINT 8
15 SC_DAMAMOUNT BIGINT 8
16 TRANSACTIONPUBLICID CHARACTER VARYING(20) 20
17 SC_DEDUCTEXCESS BIGINT 8
18 SC_PAYMENTTYPE BIGINT 8
19 SC_RECEIPTPAYMENTMETHOD BIGINT 8
20 SC_SUBROADVERSEPARTYID BIGINT 8
21 TLI_ID BIGINT 8
22 TLI_UPDATETIME TIMESTAMP 8
23 TRANEFFECTIVEDATE TIMESTAMP 8
24 TRANSACTIONAMOUNT BIGINT 8
25 SC_GSTAMOUNT BIGINT 8
26 SC_ITCAMOUNT BIGINT 8
27 IAMAMOUNT BIGINT 8
28 SC_GSTSTATUS BIGINT 8
29 SC_ITCEPERCENT BIGINT 8
30 COSTCATEGORY BIGINT 8
31 TRANSACTIONCREATETIME TIMESTAMP 8
32 TRANSACTIONSTATUS CHARACTER VARYING(1) 1
33 PAYMENTTYPE BIGINT 8
34 PAIDAMOUNT BIGINT 8
35 RECOVEREDAMOUNT BIGINT 8
36 DAMAMOUNT BIGINT 8
37 RESERVEMOVEMENT BIGINT 8
38 RECOVERYRESERVEMOVEMENT BIGINT 8
39 OFFSETAMOUNT BIGINT 8
40 SC_EXCESSGST BIGINT 8
41 TRANSACTIONID BIGINT 8
42 CLAIMSTATUS CHARACTER VARYING(22) 22
43 EXPOSURETRANSTATUS CHARACTER VARYING(22) 22
44 CLAIMSTATE BIGINT 8
45 TRANSACTIONUPDATETIME TIMESTAMP 8
46 RECORDTYPE CHARACTER VARYING(1) 1
47 RECOVERYCATEGORY BIGINT 8
48 DOESNOTERODERESERVES CHARACTER VARYING(1) 1
49 TRANSACTIONSUBTYPE CHARACTER VARYING(50) 50
50 TRANPOSTEDDATE TIMESTAMP 8
51 BATCHDATE TIMESTAMP 8
52 TRANSACTIONPOSTEDDATE TIMESTAMP 8
53 GL_CHANNEL CHARACTER VARYING(5) 5
54 GL_PRODUCT CHARACTER VARYING(6) 6
55 GL_CLASS CHARACTER VARYING(2) 2
56 GL_ENTITY CHARACTER VARYING(6) 6
57 GL_STATE CHARACTER VARYING(1) 1
58 GL_CATEGORY CHARACTER VARYING(3) 3
59 GL_CENTRE CHARACTER VARYING(4) 4
60 INCIDENTSUBTYPE CHARACTER VARYING(50) 50
61 LOSSPARTY BIGINT 8
62 EXPOSURETYPE BIGINT 8
63 DECISION_EXT BIGINT 8
64 REJECTREASON_EXT BIGINT 8
65 CLAIMNUMBER CHARACTER VARYING(40) 40