FCT_CIINTCCS_D600_CMONTH
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CLAIMID | CHARACTER VARYING(17) | 17 |
| 2 | CLAIMNUMBER | CHARACTER VARYING(15) | 15 |
| 3 | CLAIMORDER | BIGINT | 8 |
| 4 | COVERAGEKEY | NUMERIC(11,1) | 19 |
| 5 | COMPANY | NUMERIC(3,0) | 19 |
| 6 | COMPANYTXT | CHARACTER VARYING(8) | 8 |
| 7 | PRODUCT | CHARACTER(3) | 3 |
| 8 | POLICYNUMBER | CHARACTER VARYING(12) | 12 |
| 9 | ITEMNO | INTEGER | 4 |
| 10 | RISK | INTEGER | 4 |
| 11 | TERMIDENT | CHARACTER(3) | 3 |
| 12 | CLASS | CHARACTER(3) | 3 |
| 13 | SUBCLASS | CHARACTER(3) | 3 |
| 14 | GLCHANNEL | CHARACTER VARYING(5) | 5 |
| 15 | GLPRODUCT | CHARACTER VARYING(6) | 6 |
| 16 | GLCLASS | CHARACTER VARYING(2) | 2 |
| 17 | GLENTITY | CHARACTER VARYING(6) | 6 |
| 18 | GLSTATE | CHARACTER VARYING(1) | 1 |
| 19 | GLCATGORY | CHARACTER VARYING(3) | 3 |
| 20 | GLCENTRE | CHARACTER VARYING(4) | 4 |
| 21 | P | CHARACTER VARYING(4) | 4 |
| 22 | PRODUCTCODE | CHARACTER VARYING(4) | 4 |
| 23 | RATINGGROUP | CHARACTER VARYING(28) | 28 |
| 24 | AGTACCTYP | CHARACTER VARYING(4) | 4 |
| 25 | CMONTHSTATUS | CHARACTER VARYING(23) | 23 |
| 26 | DATEOCCURRED | DATE | 4 |
| 27 | DATEFINALISED | DATE | 4 |
| 28 | REALDATEFINALISED | DATE | 4 |
| 29 | TRANSACTIONMONTH | DATE | 4 |
| 30 | SYSCLAIMNUM | INTEGER | 4 |
| 31 | SOURCESYST | CHARACTER VARYING(3) | 3 |
| 32 | CLAIMEXPOSURE | CHARACTER VARYING(28) | 28 |
| 33 | PAIDTODATE | NUMERIC(38,2) | 19 |
| 34 | RESERVE | NUMERIC(38,2) | 19 |
| 35 | INCURREDTODATE | NUMERIC(38,2) | 19 |
| 36 | RECOVERYTODATE | NUMERIC(38,2) | 19 |
| 37 | RECOVERYRESERVE | NUMERIC(38,2) | 19 |
| 38 | ITCPAIDTODATE | NUMERIC(38,2) | 19 |
| 39 | GSTRECOVERYTODATE | NUMERIC(38,2) | 19 |
| 40 | EXCESSOFFSETTODATE | NUMERIC(38,2) | 19 |
| 41 | RESERVEWRITEOFFTODATE | NUMERIC(38,2) | 19 |
| 42 | RECOVERYWRITEOFFTODATE | NUMERIC(38,2) | 19 |
| 43 | PAYMENTGROSSTODATE | NUMERIC(38,2) | 19 |
| 44 | COINSPAIDTODATE | NUMERIC(38,2) | 19 |
| 45 | COINSITCPAIDTODATE | NUMERIC(38,2) | 19 |
| 46 | ITCRESERVE | NUMERIC(38,2) | 19 |
| 47 | EXITCRESERVE | NUMERIC(38,2) | 19 |
| 48 | EXRESERVE | NUMERIC(38,2) | 19 |
| 49 | FACITCRESERVE | NUMERIC(38,2) | 19 |
| 50 | FACRESERVE | NUMERIC(38,2) | 19 |
| 51 | SURPITCRESERVE | NUMERIC(38,2) | 19 |
| 52 | SURPRESERVE | NUMERIC(38,2) | 19 |
| 53 | COINSITCRESERVE | NUMERIC(38,2) | 19 |
| 54 | COINSRESERVE | NUMERIC(38,2) | 19 |
| 55 | RECOVERYRESERVEEXCESS | NUMERIC(38,2) | 19 |
| 56 | RECOVERYEXCESS | NUMERIC(38,2) | 19 |
| 57 | GSTRECOVERYEXCESS | NUMERIC(38,2) | 19 |
| 58 | RESERVEINDEMNITY | NUMERIC(38,2) | 19 |
| 59 | ITCRESERVEINDEMNITY | NUMERIC(38,2) | 19 |
| 60 | PAYMENTGROSSINDEMNITY | NUMERIC(38,2) | 19 |
| 61 | ITCPAYMENTINDEMNITY | NUMERIC(38,2) | 19 |
| 62 | RESERVELEGAL | NUMERIC(38,2) | 19 |
| 63 | ITCRESERVELEGAL | NUMERIC(38,2) | 19 |
| 64 | PAYMENTGROSSLEGAL | NUMERIC(38,2) | 19 |
| 65 | ITCPAYMENTLEGAL | NUMERIC(38,2) | 19 |
| 66 | RESERVENONLEGAL | NUMERIC(38,2) | 19 |
| 67 | ITCRESERVENONLEGAL | NUMERIC(38,2) | 19 |
| 68 | RECOVERYRESERVEOTHERRECOVERY | NUMERIC(38,2) | 19 |
| 69 | RECOVERYRESERVESALVAGE | NUMERIC(38,2) | 19 |
| 70 | RECOVERYSALVAGE | NUMERIC(38,2) | 19 |
| 71 | GSTRECOVERYSALVAGE | NUMERIC(38,2) | 19 |
| 72 | RECOVERY | NUMERIC(38,2) | 19 |
| 73 | PAYMENTGROSS | NUMERIC(38,2) | 19 |
| 74 | ITCPAYMENT | NUMERIC(38,2) | 19 |
| 75 | GSTRECOVERY | NUMERIC(38,2) | 19 |
| 76 | PAYMENTTRANS | NUMERIC(38,2) | 19 |
| 77 | EXCESSOFFSETAMOUNT | NUMERIC(38,2) | 19 |
| 78 | RESERVEWRITEOFF | NUMERIC(38,2) | 19 |
| 79 | RECOVERYWRITEOFF | NUMERIC(38,2) | 19 |
| 80 | EXITCPAYMENT | NUMERIC(38,2) | 19 |
| 81 | EXPAYMENT | NUMERIC(38,2) | 19 |
| 82 | FACITCPAYMENT | NUMERIC(38,2) | 19 |
| 83 | FACPAYMENT | NUMERIC(38,2) | 19 |
| 84 | SURPITCPAYMENT | NUMERIC(38,2) | 19 |
| 85 | SURPPAYMENT | NUMERIC(38,2) | 19 |
| 86 | COINSITCPAYMENT | NUMERIC(38,2) | 19 |
| 87 | COINSPAYMENT | NUMERIC(38,2) | 19 |
| 88 | PAYMENTGROSSNONLEGAL | NUMERIC(38,2) | 19 |
| 89 | ITCPAYMENTNONLEGAL | NUMERIC(38,2) | 19 |
| 90 | RESERVEUNKNOWN | NUMERIC(38,2) | 19 |
| 91 | ITCRESERVEUNKNOWN | NUMERIC(38,2) | 19 |
| 92 | RECOVERYOTHERRECOVERY | NUMERIC(38,2) | 19 |
| 93 | GSTRECOVERYOTHERRECOVERY | NUMERIC(38,2) | 19 |
| 94 | RECOVERYRESERVEUNKNOWN | NUMERIC(38,2) | 19 |