IRIS
International Reinsurance and Insurance System
Version 7.13
System Changes
Contents
1 Document Control 3
1.1 Version Information 3
1.2 Distribution 3
1.3 Applicability 3
2 New Files 4
2.1 New Database Files 4
2.1.1 Physical Files 4
2.1.2 Logical Files 5
3 New Fields 11
4 Changed Fields 34
5 Appendix 1 38
5.1 IRIS File List 38
1 Document Control
1.1 Version Information
Version / Document Author / Revision / Date Issued / Revision Description01 / B. Rolfe / - / 14/08/03 / For internal discussion & review
01 / B. Rolfe / 1.1 / 02/09/03 / Incorporate ADC comments
01 / B. Rolfe / 1.2 / 16/09/03 / Incorporate DAY comments
1.2 Distribution
IRIS Clients
1.3 Applicability
Version 7.13
2 New Files
2.1 New Database Files
2.1.1 Physical Files
File / Description / Attribute /ICRGREP / Revenue Group Codes / PF
ILASREP / INCAS Suspended Allocation Sessions / PF
IXJHREP / INCAS Batch File (Header) / PF
IXJIREP / INCAS Items File (Details) / PF
IXLKREP / INCAS Generic Locking File / PF
UCDSREP / Codes Data Area Definitions File / PF
UCDTREP / Codes Data Area Mirror File / PF
UCDUREP / Codes Data Update Timestamp File / PF
UCGDREP / Codes Generic Codes Definition File / PF
UCGEREP / Codes Generic Codes Dynamic File / PF
UCGFREP / Codes Generic Codes Fixed File / PF
UCLTREP / Link Type Codes / PF
UCUNREP / Unit Code / PF
UKKQREP / Claim Syndicate File / PF
UPAAREP / Accounting Terms Amounts File / PF
UPAHREP / Action History File V13.0 / PF
UPFNREP / Field History File (Numeric) V13.0 / PF
UPFTREP / Field History File (Text) V13.0 / PF
UPILREP / Business Items Links / PF
UPINREP / Policy Instalments / PF
UPLKREP / Links File / PF
UPLLREP / Location Links / PF
UPLPREP / Policy Links File / PF
UPPAREP / Policy Amounts File / PF
UPPHREP / Risk Header File / PF
UPPPREP / Premium Amendment File / PF
UPPSREP / Policy Sub-Type File / PF
UPRSREP / Reinstatement Recording File / PF
UPVLREP / Marine Vessels Links / PF
USSLWKP / PKS SL: REVENUE ACCOUNTS DETAIL (*NONE) <*N> / PF
UTDOREP / PKS output file for DSPOBJD. / PF
UTKEREP / Bureau Claims Error Message File / PF
UXUSREP / Next available Slip Identifier (UGYR) / PF
ZZSJCPP / SJ: Submitted Jobs on AX/Ware. / PF
ZZVUREP / User Specific Authority (User file) / PF
2.1.2 Logical Files
/ File / Description / Attribute /CTLLF2 / CTL Message Map File Level 2 Default LF / LF
CTLLF3 / CTL Message Map File Level 3 Default LF / LF
CTLLF4 / CTL Message Map File Level 4 Default LF / LF
FXPOREL0 / Policy Logical (PONO,UGYR,POSQ,DANO,EDNO) / LF
ICBJREL5 / TITLE BJ: Bank Accounts - GUI (BICD!BICU!COCD) / LF
ICCYREL0 / Currency File Unique Key / LF
ICCYREL1 / Single Member Currency Table (Unique key) / LF
ICCYREL2 / Single Member Currency Table by Orig Currency / LF
ICCYREL3 / Single Member Currency Table by Long Currency Name / LF
ICIAREL0 / INCAS: Physical control file (RCFD) / LF
ICLBREL2 / TITLE LB: LEDGER DEFINITIONS - GUI (COCD!SMTY!LETY / LF
ICLBREL3 / TITLE LB: LEDGER DEFINITIONS - GUI (SMTY) / LF
ICNIREL3 / NI: REVENUE ACCOUNTS DETAIL - GUI (COCD!SMTY!BHCD! / LF
ICPFREL6 / Title PF: Pre-allocation flags - GUI (COCD!LECD!IAI / LF
ICXXREL0 / Joined logicals ICXXREP ICCYREP - GUI (XXTY!EHDF!E / LF
ICXXREL1 / Exchange Rates logical - GUI (XXID) / LF
ILASREL1 / INCAS Suspended Allocation Sessions (ALSN|ALSQ) / LF
ILASREL2 / INCAS Suspended Allocation Sessions (SSCD|COCD|LECD|OXID) / LF
ILASREL3 / INCAS Suspended Allocation Sessions - GUI (ALSN!AUNO!ENDT / LF
ILEAQYL0 / LE: Ledger (COCD|LECD|ACID|SBCD|AYCD|OGCU|TRTY) / LF
ILLELGL0 / LE: LEDGER (COCD|LECD|ACID|SBCD|AYCD|OGCU|TRTY) / LF
ILPRREL3 / Reinsurer Paid Amounts logical - GUI (WF#O) / LF
ILT0CPL6 / INCAS Ledger Transactions - Logical 6 / LF
ILT0CPL7 / INCAS Ledger Transactions - Logical 7 / LF
ILT0CPL8 / INCAS Ledger Transactions - Logical 8 / LF
IXJHREL1 / INCAS Batch File (Header) (BTNO|KBET) / LF
IXJIREL1 / INCAS Items File (Details) (BTNO|BTSQ) / LF
UCCSRELL / CS: UCCSRELJ - GUI (AJSQ!CSCD!CSSQ!LQCD) / LF
UCDSREL0 / Codes Data Area Definitions UPD Logical 0 / LF
UCDSREL1 / Codes Data Area Definitions RTV Logical 1 / LF
UCDTREL0 / Codes Data Area Mirror UPD Logical 0 / LF
UCDTREL1 / Codes Data Area Mirror RTV Logical 1 / LF
UCDUREL0 / Codes Data Update Timestamp UPD Logical 0 / LF
UCDUREL1 / Codes Data Update Timestamp RTV Logical 1 / LF
UCGDREL0 / Codes Generic Codes Definition UPD Logical 0 / LF
UCGDREL1 / Codes Generic Codes Definition RTV Logical 1 / LF
UCGEREL0 / Codes Generic Codes Dynamic UPD Logical 0 / LF
UCGEREL1 / Codes Generic Codes Dynamic RTV Logical 1 / LF
UCGFREL0 / Codes Generic Codes Fixed UPD Logical 0 / LF
UCGFREL1 / Codes Generic Codes Fixed RTV Logical 1 / LF
UCNRREL0 / Standard Narrative Code logical - GUI (NRCD!RCFD) / LF
UCUYREL2 / U/W responsibility - GUI (BHCD!CYCD!DPCD!UWCD) / LF
UCV1REL2 / Joined logicals UCV1REP, UCV2REP and UCV3REP - GUI / LF
UKKMRELF / Claims Master (PHID!PSID!CMSQ) / LF
UKKMRELG / Claims Master (PSID!CMSQ) / LF
UKKMRELH / Claims Master - GUI (PONO!MKKF) / LF
UKKMRELI / Claims Master - GUI (MKKF) / LF
UKKMRELJ / Claims Master - GUI (PONO!POSQ!UGYR!MKKF) / LF
UKKMRELK / Claims Master - GUI (PONO!POSQ!UGYR!DANO!CMSQ(DESC / LF
UKKMRELL / Claims Master - GUI (CMSQ!EDID) / LF
UKKNREL1 / Claims Narrative - GUI (CMSQ!NRTY!RCFD) / LF
UKKQREL0 / Claims Syndicates file (PHID!PSID!CMSQ!KQID) / LF
UKKQREL1 / Claims Syndicates File (PSID!CMSQ!KQID) / LF
UKKQREL2 / Joined logicals UKKQREP UPSYREP - GUI (SYID!SYSQ!P / LF
UKKQREL3 / Claims Syndicates File - GUI (PONO!POSQ!UGYR!DANO! / LF
UKKQREL4 / Claims Syndicates file (PSID!SYID) / LF
UKKQREL5 / Claims Syndicates File - GUI (PSID!CMSQ!KQID!PONO! / LF
UKKSREL6 / Claims Summary (PHID!PSID!CMSQ!KQID!KSID) / LF
UKKSREL7 / Claims Summary (PSID!CMSQ!KQID!KSID) / LF
UKKSREL8 / Claims Summary (PHIO!CMSQ!KQID!KSID) / LF
UKKSREL9 / Claims Summary - GUI(PSID!CMSQ!AYCD!OGCU!RICD!PHIO / LF
UKKSRELA / Claims Summary - GUI (PSID!PHIO) / LF
UKKSRELB / Claims Summary - GUI (PSID!CMSQ!OGCU!AYCD) / LF
UKKSRELC / Claims Summary - GUI (PSID!CMSQ!OGCU!AYCD) / LF
UKKTREL9 / Claim Transactions Full Old Key / LF
UKKTRELA / Claims Transactions(PHID!PSID!CMSQ!KQID!KSID!KTID) / LF
UKKTRELB / Claims Transactions(PSID!CMSQ!KQID!KSID!KTID) / LF
UKKTRELC / Claims Transactions(PHIO!CMSQ!KQID!KSID!KTID) / LF
UKKTRELD / Joined logicals UKKTREP, UPSYREP and UKKQREP - GUI / LF
UKKTRELE / Claims Transactions (PSID!CMSQ!AYCD!OGCU!RICD!PHIO! / LF
UKKTRELF / Claims Transactions - GUI (PSID!CMSQ!OE@O) / LF
UKKTRELG / Claims Transactions(PSID!CMSQ!AYCD!OGCU!CMTN!KQID! / LF
UKKTRELH / Claims Transactions -GUI (AYCD!CMSQ!CMTN!DANO!OGCU / LF
UKKYREL2 / Claims Transaction - SCM GUI (PONO!POSQ!UGYR!CMSQ / LF
UKOSREL6 / OCR Balances logical file 6 / LF
UKOSREL7 / OCR Balances (PHID!PSID!SYID!SYSQ!OSID) / LF
UKOSREL8 / OCR Balances (PSID!SYID!SYSQ!OSID) / LF
UKOSREL9 / OCR Balances (PHIO!SYID!SYSQ!OSID) / LF
UKOSRELA / OCR Balances (PSID!OSID!AYCD!OGCU!RICD!OUPO!OUSQ!O / LF
UKOTREL7 / OCR Transactions (PHID!PSID!SYID!SYSQ!OSID!OTID) / LF
UKOTREL8 / OCR Transactions (PSID!SYID!SYSQ!OSID!OTID) / LF
UKOTREL9 / OCR Transactions - GUI (PSID!RICD!CBCD!AYCD!OGCU) / LF
UKOTRELA / OCR Transactions - GUI (PSID!OSID!PONO!POSQ!UGYR!A / LF
UKRSREL3 / TITLE RS: RESERVES SUMM(PHID!PSID!CMSQ!RSID!SYID! / LF
UKRSREL4 / TITLE RS: RESERVES SUMM(PSID!CMSQ!RSID!SYID!SYSQ) / LF
UKRSREL5 / TITLE RS: RESERVES SUMM - GUI (PSID!SV@O) / LF
UKRSREL6 / TITLE RS: RESERVES SUMM - GUI (PSID!CMSQ!OGCU!AYCD / LF
UKRVREL3 / TITLE RV: RESERVES TRN (PHID!PSID!CMSQ!RSID!RVID) / LF
UKRVREL4 / TITLE RV: RESERVES TRN (PSID!CMSQ!RSID!RVID) / LF
UKUPREL6 / TITLE UP: UPR TRANSACTIONS (PONO/POSQ/UGYR/ACYR/DA / LF
UKUQREL4 / TITLE UQ: UPR BALANCES - GUI(PONO!POSQ!UGYR!DANO) / LF
UPAAREL0 / Accounting Terms Amounts File(PHID!PSID!ATID!TMNO) / LF
UPAAREL1 / Accounting Terms Amounts File(PSID!ATID!TMNO!OGCU / LF
UPANREL3 / A/C TERMS NARRATIVE (PONO!POSQ!UGYR!DANO) / LF
UPANREL4 / A/C TERMS NARRATIVE(PHID!PSID!ATID!TMNO!NRTY!NRSQ) / LF
UPANREL5 / A/C TERMS NARRATIVE(PSID!ATID!TMNO!NRTY!NRSQ) / LF
UPANREL6 / A/C Terms Narrative - GUI (PONO!POSQ!UGYR!DANO!NRT / LF
UPANREL7 / A/C Terms Narrative - GUI (QPMU!QPMY!POTY!NRTY) / LF
UPANREL8 / A/C Terms Narrative - GUI (PSID!ATID!NRTY) / LF
UPATREL8 / Accounting Terms File(ATPHID!ATPSID!ATATID!ATTMNO) / LF
UPATREL9 / Accounting Terms File(ATPSID!ATATID!ATTMNO) / LF
UPATRELA / Accounting Terms File - GUI (ATPSID!ATRCFD!ATEDNO! / LF
UPATRELB / Accounting Terms File - GUI (ATPONO!ATPOSQ!ATUGYR! / LF
UPATRELC / Accounting Terms File - GUI (ATPSID!ATTMNO!ATEDNO) / LF
UPATRELD / Accounting Terms File - GUI (QPMU!QPMY!POTY!TMNO) / LF
UPATRELE / Accounting Terms File - GUI (PONO!POSQ!UGYR!DANO!E / LF
UPCDREL5 / Policy Multiple conditions logical file / LF
UPCDREL6 / Policy Multiple Conditions file (PHID!PSID!CDID!CD / LF
UPCDREL7 / Policy Multiple Conditions file (PSID!CDID!CDNO!CD / LF
UPCDREL8 / Policy Multiple Conditions file - GUI (QPMU!QPMY!P / LF
UPCPREL4 / Class split logical file / LF
UPCPREL5 / TITLE CP: CLASS SPLIT FILE (PHID!PSID!CPID!CBCD) / LF
UPCPREL6 / TITLE CP: CLASS SPLIT FILE (PSID!CPID!CBCD) / LF
UPCPREL7 / CLASS SPLIT FILE - GUI (POTY!QPMU!QPMY) / LF
UPDDRELD / DEDUCTIONS FILE (O!PONO!POSQ!UGYR!DANO!) / LF
UPDDRELE / DD: UPDDREL0 (PHID!PSID!DDID!TMNO!DDSQ) / LF
UPDDRELF / DD: UPDDREL0 (PSID!DDID!TMNO!DDSQ) / LF
UPDDRELG / Deductions file - GUI (PSID!DDID!TMNO!EDNO (Desc)) / LF
UPDDRELH / Deductions file - GUI (PSID!DDID!TMNO (Desc)) / LF
UPDDRELI / Deductions file - GUI (QPMU!QPMY!POTY) / LF
UPEDREL1 / ENDORSEMENT LOG PONO,POSQ,UGYR,DANO,EDNO / LF
UPEDREL2 / ENDORSEMENT LOG PSID,EDNO / LF
UPEDREL3 / ENDORSEMENT LOG FILE (PHID!PSID!POID) / LF
UPEDREL4 / Endorsement log file - GUI (PSID!EDID) / LF
UPEDREL5 / Endorsement log file - GUI (EDID) / LF
UPILREL0 / Business Item Links logical 0 / LF
UPILREL1 / Business Item Links logical 1 / LF
UPILREL2 / Business Item Links logical 2 / LF
UPINREL0 / Policy Instalments logical 0 / LF
UPINREL1 / Policy Instalments logical 1 / LF
UPINREL2 / Policy Instalments logical 2 GUI (PHID!PSID!INSQ) / LF
UPIZREL3 / Policy Items logical 3 / LF
UPIZREL4 / Policy Items logical 4 / LF
UPIZREL5 / Policy Items logical 5 / LF
UPIZREL6 / Policy Items logical 6 / LF
UPKPREL3 / Perils exposure logical 3 / LF
UPKPREL4 / Perils Exposure logical 4 (PHID!PSID!KPID) / LF
UPKPREL5 / Perils Exposure logical 5 (PSID!KPID) / LF
UPKPREL6 / Perils Exposure logical - GUI(PONO!POSQ!UGYR!DANO! / LF
UPKPREL7 / Perils Exposure logical - GUI(PSID!KPID!TACD!ZNCD! / LF
UPKPREL8 / Perils Exposure logical - GUI(PSID!KPID!PJCD) / LF
UPKPREL9 / Perils Exposure logical - GUI (QPMU!QPMY!POTY) / LF
UPLKREL0 / Links and Policies(PONP,POSP,UGYP,DANP,EDNP) / LF
UPLKREL1 / Links and Policies(PONO,POSQ,UGYR,DANO,EDNO) / LF
UPLKREL2 / Links and Policies(QPMP,QPYP) / LF
UPLKREL3 / Links Logical (LKID) / LF
UPLKREL4 / Links Logical (LTCD) / LF
UPLKREL5 / Links to Policy Links Join File / LF
UPLLREL0 / Location Links logical 0 / LF
UPLLREL1 / Location Links logical 1 / LF
UPLPREL0 / Policy Links Logical (LKID) / LF
UPLPREL1 / Policy Links logical 1 / LF
UPLPREL2 / Policy Links logical 2 / LF
UPLPREL3 / Policy Links File - PSID, EDID, LKID, PSI2, EDI2 / LF
UPLPREL4 / Policy Links File - PSI2, EDI2, LKID, PSID, EDID / LF
UPLPREL5 / Policy Links File - EDID, LKID, EDI2 / LF
UPLPREL6 / Policy Links File - EDI2, LKID, EDID / LF
UPLPREL7 / Policy Links File - GUI (LKID!PONO!POSQ!UGYR!DANO! / LF
UPLQREL5 / LOCATIONS FILE (O!TACD!TWCD!ZVCD!ZTCD!ZT / LF
UPLQREL6 / Policy Locations Logical 6 / LF
UPLQREL7 / Policy Locations logical 7 / LF
UPLQREL8 / Joined logicals UPLQREP and UPLLREP - GUI (POLQ!ED / LF
UPLQREL9 / Locations file - GUI (QPMU!QPMY!POTY!POLQ(Desc)) / LF
UPLQRELA / Locations file - GUI (PSID!LQID!POLQ!LQSQ) / LF
UPLQRELB / Locations file - GUI (QPMU!QPMY!POTY) / LF
UPPAREL0 / Policy Amounts Logical file / LF
UPPAREL1 / Policy Amounts Logical 1 / LF
UPPAREL2 / Policy Amounts Logical 2 - GUI (PSID!POID!PAID) / LF
UPPHREL0 / Policy Header - PHID / LF
UPPHREL1 / Policy Header - PONO!POSQ!UGYR!DANO / LF
UPPHREL2 / Policy Header - GUI (USRF!PHID) / LF
UPPHREL3 / Policy Header - GUI (PONO!UGYR) / LF
UPPHREL4 / Policy Header - GUI (PONO!UGYR!DANO) / LF
UPPKREL4 / Policy Flags logical 4 / LF
UPPKREL5 / Policy Flags logical 5 / LF
UPPKREL6 / Policy Flags logical 6 - GUI (QPMU!QPMY!POTY) / LF
UPPNREL6 / Policy Narrative logical 6 / LF
UPPNREL7 / Policy Narrative logical 7 / LF
UPPNREL8 / Policy Narrative logical - GUI (PONO!POSQ!UGYR!DAN / LF
UPPNREL9 / Policy Narrative logical - GUI (PONO!NRTY) / LF
UPPORELY / Policy File (PHID,PSID, POID) / LF
UPPORELZ / Policy File (PSID, POID) / LF
UPPPREL0 / Premium Amendment logical 0 / LF
UPPPREL1 / Premium amendment logical 1 / LF
UPPPREL2 / Premium amendment logical 1 - GUI (PONO!POSQ!UGYR! / LF
UPPSREL0 / Policy Sub-Type (PHID,PSID) / LF
UPPSREL1 / Policy Sub-Type logical 1 / LF
UPR#REL1 / RI Worksheet LF (endorsements) / LF
UPR#REL2 / RI Worksheet LF (endorsements) (PHID!PSID!R#ID) / LF
UPR#REL3 / RI Worksheet LF (endorsements) (PSID!R#ID) / LF
UPRFREL2 / Return on Equity File - GUI (QPMU!QPMY!POTY) / LF