SAP ABAP Table /FSIH/STR_INS_POLICY (Insurance Policy)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ /FSIH/IN_APPL (Package) Insurance Handler Application: API Inbound Layer

Basic Data

Table Category	INTTAB	Structure
Structure	/FSIH/STR_INS_POLICY	Table Relationship Diagram
Short Description	Insurance Policy

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	POL_KEY	☐	/FSIH/DTE_POL_KEY	/FSIH/DOM_POL_KEY	RAW	16	0	Insurance Policy Key
2	POL_NO	☐	/FSIH/DTE_POL_NO	/FSIH/DOM_POL_NO	CHAR	40	0	Insurance Policy Number
3	INS_CODE	☐	/FSIH/DTE_INS_CODE		CHAR	6	0	Insurance ID
4	INS_TYPE	☐	/FSIH/DTE_INS_TYPE	/FSIH/DOM_INS_TYPE	CHAR	6	0	Insurance Type
5	INS_TYPE_TXT	☐	/FSIH/DTE_INS_TYPE_TXT	/FSIH/DOM_CHAR40	CHAR	40	0	Name of Insurance Type
6	STATUS	☐	/FSIH/DTE_STATUS	/FSIH/DOM_STATUS	CHAR	1	0	Insurance Status
7	STATUS_DATE	☐	/FSIH/DTE_STATUS_DATE	DATUM	DATS	8	0	Date of Last Status Change
8	STATUS_TXT	☐	/FSIH/DTE_STATUS_TXT	/FSIH/DOM_CHAR40	CHAR	40	0	Description of Insurance Status
9	STATUS_REASON	☐	/FSIH/DTE_STATUS_REASON	/FSIH/DOM_STATUS_REASON	CHAR	1	0	Status Change
10	STATUS_REASON_TXT	☐	/FSIH/DTE_STATUS_REASON_TXT	/FSIH/DOM_CHAR40	CHAR	40	0	Name of Reason for Insurance Status
11	POL_HOLDER	☐	/FSIH/DTE_POL_HOLDER	BU_PARTNER	CHAR	10	0	Policyholder	*
12	INS_COMP	☐	/FSIH/DTE_INS_COMP	BU_PARTNER	CHAR	10	0	Insurance Company	*
13	PORTFOLIO	☐	/FSIH/DTE_PORTFOLIO	/FSIH/DOM_PORTFOLIO	CHAR	10	0	Portfolio	*
14	LAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
15	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	START_DATE	☐	/FSIH/DTE_START_DATE	DATUM	DATS	8	0	Start of Validity Period for Insurance Policy
17	END_DATE	☐	/FSIH/DTE_END_DATE	DATUM	DATS	8	0	End of Validity Period for Insurance Policy
18	MAX_AGE	☐	/FSIH/DTE_MAX_AGE	/FSIH/DOM_MAX_AGE	DEC	3	0	Maximum Age of Policyholder
19	MAX_MATURITY	☐	/FSIH/DTE_MAX_MATURITY	/FSIH/DOM_MAX_MATURITY	DEC	3	0	Mamimum Term of Insurance
20	AUTO_CNCL_DATE	☐	/FSIH/DTE_AUTO_CNCL	/FSIH/DOM_AUTO_CNCL	DATS	8	0	Latest Contract End Date
21	FORCEPLACEMENT	☐	/FSIH/DTE_FORCEPLCM	XFELD	CHAR	1	0	Force Placed Insurance
22	EVENT_OCCURRED	☐	/FSIH/DTE_EVENT_OCC	XFELD	CHAR	1	0	Has an Insurance Event Occurred?
23	DATE_EVENT_OCC	☐	/FSIH/DTE_DATE_EVENT_OCC	/FSIH/DOM_DATE_EVENT_OCC	DATS	8	0	Date Insurance Event Occurred
24	TAX_DEDUCT	☐	/FSIH/DTE_TAX_DEDUCT	XFELD	CHAR	1	0	Tax Deductible?
25	INS_SUM	☐	/FSIH/DTE_INS_SUM	/FSIH/DOM_PREM_AMOUNT	CURR	13	2	Sum Insured
26	MIN_COVERAGE	☐	/FSIH/DTE_MIN_COV	/FSIH/DOM_PREM_AMOUNT	CURR	13	2	Minimum Sum Insured
27	MAX_COVERAGE	☐	/FSIH/DTE_MAX_COV	/FSIH/DOM_PREM_AMOUNT	CURR	13	2	Maximum Sum Insured
28	ITV	☐	/FSIH/DTE_ITV	BU_PARTNER	CHAR	10	0	Insurance Tracking Vendor	*
29	AGENT	☐	/FSIH/DTE_AGENT	BU_PARTNER	CHAR	10	0	Insurance Tracking Vendor	*
30	PLCM_DATE	☐	/FSIH/DTE_PLCM_DATE	DATUM	DATS	8	0	Created On
31	EARNED_AMOUNT	☐	/FSIH/DTE_EARNED_AMNT	WERTV7	CURR	13	2	Partial Amount of Premium Used
32	UNEARNED_AMOUNT	☐	/FSIH/DTE_UNEARNED_AMNT	WERTV7	CURR	13	2	Unused Partial Amount of Premium
33	.INCLUDE	☐				0	0	Premium Data for Insurance Policy
34	CURRENCY	☐	/FSIH/DTE_CURR	WAERS	CUKY	5	0	Currency	*
35	PP_VALID_FROM	☐	/FSIH/DTE_PP_VALID_FROM	DATUM	DATS	8	0	Date from Which Premiums Are Valid
36	PAYER	☐	/FSIH/DTE_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
37	BANK_ID	☐	/FSIH/DTE_BANK_ID	BVTYP	CHAR	4	0	Bank Details ID
38	PAYM_METHOD	☐	/FSIH/DTE_PAYM_METHOD	ZLSCH	CHAR	1	0	Payment Method	*
39	PREM_TYPE	☐	/FSIH/DTE_PREM_TYPE	/FSIH/DOM_PREM_TYPE	CHAR	1	0	Premium Payment Form (Single, Advance, Arrears)
40	PREM_RATE	☐	/FSIH/DTE_PREM_RATE	/FSIH/DOM_PREM_RATE	DEC	10	7	Premium Installment in Procent
41	PREM_AMOUNT	☐	/FSIH/DTE_PREM_AMOUNT	/FSIH/DOM_PREM_AMOUNT	CURR	13	2	Premium Amount
42	REBATE_METHOD	☐	/FSIH/DTE_REBATE_METH	/FSIH/DOM_REBATE_METH	CHAR	2	0	Rebate Method
43	REBATE_METHOD_TXT	☐	/FSIH/DTE_REBATE_METH_TXT	/FSIH/DOM_CHAR40	CHAR	40	0	Description of Rebate Method
44	PAYM_FREQUENCY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
45	ACCRUAL_METHOD	☐	/FSIH/DTE_ACCR_METHOD	/FSIH/DOM_ACCR_METHOD	CHAR	4	0	Calaculation Base for Accrued Premiums
46	FREQ_UNIT	☐	/FSIH/DTE_FREQ_UNIT	/FSIH/DOM_FREQ_UNIT	CHAR	2	0	Period Unit
47	.INCLUDE	☐				0	0	Insurance Policy Link to Account
48	LINK_ID	☐	/FSIH/DTE_LINK_ID	SYSUUID	RAW	16	0	Key for Link Between Loan and Insurance Policy
49	.INCLUDE	☐				0	0	Unique Account Key to Which Insurance Belongs
50	ACC_SYSTEM	☐	/FSIH/DTE_ACC_SYSTEM	/FSIH/DOM_ACC_SYSTEM	CHAR	2	0	Account System
51	ACC_KEY	☐	/FSIH/DTE_ACC_KEY	/FSIH/DOM_ACC_KEY	CHAR	60	0	Unique Account Key to Which Insurance Belongs
52	LINK_STATUS	☐	/FSIH/DTE_LINK_STATUS	/FSIH/DOM_LINK_STATUS	CHAR	1	0	Status of Link
53	MANDATORY	☐	/FSIH/DTE_LINK_MAND_FLAG	XFELD	CHAR	1	0	Force Placed Insurance
54	PROCESS_PREMIUMS	☐	/FSIH/DTE_LINK_PROC_PREM_FLAG	XFELD	CHAR	1	0	Premium Payments Are Included in Loan
55	LNK_VALID_FROM	☐	/FSIH/DTE_LINK_VALID_FROM	DATUM	DATS	8	0	Link Is Valid from
56	LNK_VALID_TO	☐	/FSIH/DTE_LINK_VALID_TO	DATUM	DATS	8	0	Link Is Valid To

History

Last changed by/on	SAP	20130529
SAP Release Created in	600