INT_CIBSECCS_D011_CMOV_STG04

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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