FCT_CIINTCCS_D500_CTRANS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CLAIMID | CHARACTER VARYING(17) | 17 |
| 2 | CLAIMNUMBER | CHARACTER VARYING(15) | 15 |
| 3 | CLAIMORDER | BIGINT | 8 |
| 4 | EXPOSURENUM | BIGINT | 8 |
| 5 | COVERAGEKEY | NUMERIC(11,1) | 19 |
| 6 | SYSCLAIMNUM | INTEGER | 4 |
| 7 | COMPANY | NUMERIC(3,0) | 19 |
| 8 | COMPANYTXT | CHARACTER VARYING(8) | 8 |
| 9 | PRODUCT | CHARACTER(3) | 3 |
| 10 | POLICYNUMBER | CHARACTER VARYING(12) | 12 |
| 11 | ITEMNO | INTEGER | 4 |
| 12 | CLASS | CHARACTER(3) | 3 |
| 13 | SUBCLASS | CHARACTER(3) | 3 |
| 14 | RISK | INTEGER | 4 |
| 15 | TERMIDENT | CHARACTER(3) | 3 |
| 16 | GLCHANNEL | CHARACTER VARYING(5) | 5 |
| 17 | GLPRODUCT | CHARACTER VARYING(6) | 6 |
| 18 | GLCLASS | CHARACTER VARYING(2) | 2 |
| 19 | GLENTITY | CHARACTER VARYING(6) | 6 |
| 20 | GLSTATE | CHARACTER VARYING(1) | 1 |
| 21 | GLCATGORY | CHARACTER VARYING(3) | 3 |
| 22 | GLCENTRE | CHARACTER VARYING(4) | 4 |
| 23 | P | CHARACTER VARYING(4) | 4 |
| 24 | RATINGGROUP | CHARACTER VARYING(28) | 28 |
| 25 | AGTACCTYP | CHARACTER VARYING(4) | 4 |
| 26 | PRODUCTCODE | CHARACTER VARYING(4) | 4 |
| 27 | CLAIMSTATUS | CHARACTER VARYING(22) | 22 |
| 28 | CLAIMSTATUSDESC | CHARACTER VARYING(30) | 30 |
| 29 | CLAIMSTATUSGROUP | CHARACTER VARYING(22) | 22 |
| 30 | TRANSACTIONDATE | DATE | 4 |
| 31 | TRANSACTIONTIME | TIME | 8 |
| 32 | ORIGTRANSACTIONDATE | DATE | 4 |
| 33 | ORIGTRANSACTIONTIME | TIME | 8 |
| 34 | DATEOCCURRED | DATE | 4 |
| 35 | DATEFINALISED | DATE | 4 |
| 36 | REALDATEFINALISED | DATE | 4 |
| 37 | EXPOSUREREALDATEFINALISED | DATE | 4 |
| 38 | GLMONTH | DATE | 4 |
| 39 | TRANSACTIONTYPE | CHARACTER VARYING(2) | 2 |
| 40 | TRANSACTIONCODE | CHARACTER VARYING(5) | 5 |
| 41 | TRANSACTIONCODEDESC | CHARACTER VARYING(60) | 60 |
| 42 | TRANSACTIONGROUP | CHARACTER VARYING(40) | 40 |
| 43 | TRANSACTIONSUBCODE | CHARACTER VARYING(8) | 8 |
| 44 | TRANSACTIONGROUPAPRA | CHARACTER VARYING(40) | 40 |
| 45 | PAYMENTNO | CHARACTER VARYING(10) | 10 |
| 46 | PAYEENAME | CHARACTER VARYING(70) | 70 |
| 47 | RECORDTYPE | CHARACTER VARYING(1) | 1 |
| 48 | PAYMENTTRANS | NUMERIC(14,2) | 19 |
| 49 | RESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 50 | RECOVERYRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 51 | RECOVERY | NUMERIC(14,2) | 19 |
| 52 | EXCESSOFFSETAMOUNT | NUMERIC(14,2) | 19 |
| 53 | RECOVERYWRITEOFF | NUMERIC(14,2) | 19 |
| 54 | RESERVEWRITEOFF | NUMERIC(14,2) | 19 |
| 55 | PAYMENTGROSS | NUMERIC(14,2) | 19 |
| 56 | ITCPAYMENT | NUMERIC(14,2) | 19 |
| 57 | GSTRECOVERY | NUMERIC(12,2) | 19 |
| 58 | ITCRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 59 | EXITCRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 60 | EXITCPAYMENT | NUMERIC(14,2) | 19 |
| 61 | EXRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 62 | EXPAYMENT | NUMERIC(14,2) | 19 |
| 63 | FACITCRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 64 | FACITCPAYMENT | NUMERIC(14,2) | 19 |
| 65 | FACRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 66 | FACPAYMENT | NUMERIC(14,2) | 19 |
| 67 | SURPITCRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 68 | SURPITCPAYMENT | NUMERIC(14,2) | 19 |
| 69 | SURPRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 70 | SURPPAYMENT | NUMERIC(14,2) | 19 |
| 71 | COINSITCRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 72 | COINSITCPAYMENT | NUMERIC(14,2) | 19 |
| 73 | COINSRESERVEMOVEMENT | NUMERIC(14,2) | 19 |
| 74 | COINSPAYMENT | NUMERIC(14,2) | 19 |
| 75 | CLAIMEXPOSURE | CHARACTER VARYING(28) | 28 |
| 76 | MODIFIED | BIGINT | 8 |
| 77 | SOURCESYST | CHARACTER VARYING(3) | 3 |
| 78 | USERID | CHARACTER VARYING(8) | 8 |