ICSPOL

Policy Snapshot | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Policy Snapshot for Claim
POLVNR Counter of Contract Version
CHANGETIME Changed: Date + Time
Column Name Description
Column Name Description
Column Name Description
DUEDATE Due Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
IMPORTSTATUS Import Status of Policy Snapshot Show values
VALIDDATA Overview of Data in Policy Snapshot Show values
MANCHANGE Policy Snapshot Changed Manually Show values
BENEXCLPER Benefit Exclusion Period Show values
CLAUSE Information on Existence of Clauses in Policy Snapshot Show values
MULTI_CURRENCY_CATEGORY Multi-Currency Category Show values
Column Name Description Domain name
VALIDFROM Contract Version: Valid-From Date ICL_TIMESTAMP
VALIDTO Contract Version: Valid To Date ICL_TIMESTAMP
SRCCHANGE Date and Time of Version Change in Policy System ICL_TIMESTAMP
ISSUED Date of Issue ICL_TIMESTAMP
INCEPTION Inception of Contract ICL_TIMESTAMP
EXPIRY End Date and Time of Contract ICL_TIMESTAMP
JURISCOUNTRY Country/Region of Jurisdiction LAND1
JURISREGION Jurisdiction Region REGIO
NCBONUS Claim-Free Discount ICL_NCBONUS1
POLICY Contract Number ICL_POLICY
LRENEWAL Last Renewal of Contract Before Claim Date/Time ICL_TIMESTAMP
POLOBJ_CD ID of PM Insurance Object in CD INSOBJECT_MD
POLICY_PM Number of Policy in FS-PM ICL_POLICY
POLEX_PM External Policy ICL_POLICY
POLICY_PM_TXT Short Name of Policy ICL_PMI_POLICY_PM_TXT
CONTR_PM_TXT Short Name of PM Contract ICL_PMI_CONTR_PM_TXT
PROFILE_PR_LEVEL Benefit Processing Profile at Product Level ICL_PROFILE_PR_LEVEL
ASSIGN_GUID GUID of Length 32 SYSUUID_C
POLPRODN Name of Policy Product TEXT30
INSCOND_GEN General Insurance Conditions
INSCOND_GENN Description of Insurance Conditions
INSCOND_SPEC Special Insurance Condition
INSCOND_SPECN Description of Insurance Conditions
BUKRS Company Code BUKRS
GESNR Business Partner of Company Code BU_PARTNER
PLINEOFBUS Insurance Line of Business ICL_LINEOFBUS
MAINMATUR_DT Main Due Date ICL_MAINMATUR_DT
REQUESTSTATUS Contract Request Status (Content: A = Request, P = Policy) ICL_REQUESTSTATUS
TEXT_LANGU Language Key of Policy Snapshot SPRAS
Master Data Relations Join Conditions
Changed By
  • ICSPOL.CLIENT == USR02.MANDT
  • ICSPOL.CHANGEDBY == USR02.BNAME
Client ICSPOL.CLIENT == T000.MANDT
Currency of Limit and Deductible
  • ICSPOL.CLIENT == TCURC.MANDT
  • ICSPOL.CURR == TCURC.WAERS
Insurance Distribution Channel
Policy Product
  • Policy Product
  • ?
  • ICSPOL.CLIENT == TICL320.CLIENT
  • ICSPOL.POLPROD == TICL320.POLPROD
  • ICSPOL.[column in domain "ICL_GENERAT"] == TICL320.VERSION