INT_CIBSECCS_D011_CMOV_STG03

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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