PIT
Subrogation/Recovery Data
Technical name: 0ISCM_SUBROG_03
Technical Data
DataSource Type |
Transactional data (transaction data) |
Application Component |
Claims Management (0IS_IS_CM) |
Available as of OLTP Release |
ERP 2005, EHP 4 |
Available as of Plug-In Release |
BI Content 7.0.4 |
RemoteCube-Capable |
Yes |
Delta-Capable |
Yes |
Extraction from Archives |
No |
Verifiable |
No |
Use
This DataSource enables extraction of the data fields at a specific point in time from the Subrogation/Recovery application tables:
- ICL_SUBROG
- ICL_SUBROGITEM
- ICS_SUBROG
- ICS_SUBROGITEM
Delta Update
Fields of Origin in the Extract Structure
Field in Extract Structure |
Description of Field in the Extract Structure |
Field in Table of Origin |
CLIENT |
Client |
CLIENT |
ACTIVE |
Table entry is active (A) or in suspense (S) |
ACTIVE |
CLAIM |
Number of the claim |
CLAIM |
SUBROG_GUID |
Universal Unique Identifier of subrogation/recovery |
SUBROG_GUID |
SUBROGITEM_GUID |
Universal Unique Identifier of subrogation/recovery |
SUBROGITEM_GUID |
I_CHANGETIME |
Changed: UTC date+time |
I_CHANGETIME |
I_CHANGEDBY |
Changed by |
I_CHANGEDBY |
I_DELETED |
Status of database entry (original, changed, deleted) |
I_DELETED |
SUBCLAIM |
Subclaim |
SUBCLAIM |
RESERVEAMT |
Reserve amount of subrogation/recovery item |
RESERVEAMT |
I_CURRENCY |
Subrogation/recovery currency |
I_CURRENCY |
SUBROGITEM_ID |
Number of subrogation/recovery item |
SUBROGITEM_ID |
SUBROGITEM_CGUID |
Subrogation/recovery item: Compressed GUID (Universal Unique Identifier) |
SUBROGITEM_CGUID |
H_CHANGETIME |
Changed: UTC date+time |
H_CHANGETIME |
H_CHANGEDBY |
Changed by |
H_CHANGEDBY |
H_DELETED |
Status of database entry (original, changed, deleted) |
H_DELETED |
TYPE |
Subrogation/recovery type |
TYPE |
REASON |
Subrogation/recovery reason |
REASON |
ESTIMAMOUNT |
Estimated amount of subrogation/recovery |
ESTIMAMOUNT |
H_CURRENCY |
Subrogation/recovery currency |
H_CURRENCY |
LIABRATE |
Liability rate for subrogation/recovery |
LIABRATE |
PROBABILITY |
Subrogation/recovery probability |
PROBABILITY |
BP_SBRG_MAIN |
Party liable |
BP_SBRG_MAIN |
LITHGUID |
Universal Unique Identifier of litigation |
LITHGUID |
SR_STATUS |
Subrogation/recovery status |
SR_STATUS |
SENTDATE |
Date sent (notification that subrogation/recovery is being initiated) |
SENTDATE |
FINISHED |
Subrogation/recovery status "Completed" |
FINISHED |
CLOSEREASON |
Closure reason for subrogation/recovery |
CLOSEREASON |
SUBROG_ID |
Number of subrogation/recovery |
SUBROG_ID |
SUBROG_CGUID |
Subrogation/recovery: Compressed GUID (Universal Unique Identifier) |
SUBROG_CGUID |
KEYDATE |
ICL_BW_KEYDATE |
KEYDATE |
LO_TZONE |
ICL_BW_LOZONE |
LO_TZONE |