SAP ABAP Table /FSIH/STR_POLICY (Insurance Policy)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ /FSIH/GDT_APPL (Package) Insurance Handler Application: Global File Type

Basic Data

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