CMS_INS_PSN - Insurance - Specifications of Persons
Insurance - Specifications of Persons information is stored in SAP table CMS_INS_PSN.
It is part of development package CMS_OMS_RIG in software component FS-CMS-MD-RIG. This development package consists of objects that can be grouped under "Collateral Management Rights".
It is part of development package CMS_OMS_RIG in software component FS-CMS-MD-RIG. This development package consists of objects that can be grouped under "Collateral Management Rights".
Fields for table CMS_INS_PSN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
.INCLUDE | INS_PSN_PKY | X | CMS_STR_INS_PSN_PKY | 0 | ||
INS_PSN_GUID | Insurance Person GUID | X | CMS_DTE_INS_PSN_GUID | RAW | 16 | |
.INCLUDE | INS_PSN_LKY | CMS_STR_INS_PSN_LKY | 0 | |||
INS_GUID | Insurance GUID | CMS_DTE_INS_GUID | RAW | 16 | ||
.INCLUDE | INS_PSN_DATA | CMS_STR_INS_SPEC_PER_PERSON | 0 | |||
INSRD_PRSN_NM | Name of the insured person | CMS_DTE_INS_PRSN_NAME | CHAR | 60 | ||
PRSN_STATUS | Status of insurance | CMS_DTE_INS_STATUS | CHAR | 12 | TCMS_ATT_ID_TY | |
PRSN_STATUS_DT | Status date of insurance | CMS_DTE_INS_STATUS_DT | DATS | 16 | ||
SPEC_INS_RNK_PR | Specification on the insurance rank of the person | CMS_DTE_INS_SPEC_RNK_PRSN | CHAR | 60 | ||
INSURED_RSK | Insured risk | CMS_DTE_INS_RSK | CHAR | 12 | TCMS_ATT_ID_TY | |
SGLE_PRM | Insurance one time Cntribution /Single Premium insurance | CMS_DTE_INS_SGLE_PRM | CURR | 9 | ||
SGLE_PRM_CKY | Currency | CMS_DTE_INS_SGLE_PRM_CKY | CUKY | 10 | TCURC | |
ONE_TME_CON | Undrawn(unused) one time contribution | CMS_DTE_INS_ONE_TME_CON | CURR | 9 | ||
ONE_TME_CON_CKY | Currency | CMS_DTE_INS_ONE_TM_CON_CKY | CUKY | 10 | TCURC | |
RENEW_DAT | Renewal date(insurance premium) | CMS_DTE_INS_RENEW_DAT | DATS | 16 | ||
.INCLUDE | CHG_HISTORY | CMS_STR_CHG_HISTORY | 0 | |||
CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 24 | ||
CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 8 | ||
CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 24 | ||
CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 8 | ||
SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 64 |