ALIAS NAME: | Dwelling Coverages |
TYPE: | ENTITY |
ENTITY-ID: | NB047 |
DESCRIPTION: | Dwelling level coverage and deductible information. |
PRIMARY KEY: | AppId |
UnitNbr |
AppId | |
ALIAS NAME: | Application Identifier |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | CHARACTER |
LENGTH: | 20 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | The application identifier is the system generated unique ID that is used to link to all tables that comprise a policy or quote. |
UnitNbr | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | SMALLINT |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | This is the unit number, which identifies the specific entity. It is used to differentiate multiple items with similar characteristics. |
FormCode | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | VARCHAR |
LENGTH: | 1 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Form code values describing the type of homeowners policy being written. |
WindHailCode | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | VARCHAR |
LENGTH: | 1 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | The user-defined code that represents wind hail. |
ExtendedCoverage | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | BIT |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Currently not used. |
CovA | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | MONEY |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Coverage A Limit amount (Dwelling). |
CovB | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | MONEY |
DATA REQUIREMENT: | Optional |
DESCRIPTION: | Coverage B Limit amount (Other Structures). |
CovC | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | MONEY |
DATA REQUIREMENT: | Optional |
DESCRIPTION: | Coverage C Limit amount (Personal Property). |
CovD | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | MONEY |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Coverage D Limit amount (Loss of Use). |
CovE | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | VARCHAR |
LENGTH: | 7 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Coverage E Limit amount (Liability). |
CovF | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | VARCHAR |
LENGTH: | 5 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | This field represents the Coverage F Limit amount (Medical Payments). |
TheftExtension | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | VARCHAR |
LENGTH: | 1 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | This is the theft extension. |
TheftDeduction | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | BIT |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Currently not used. |
WindAndHailExclusion | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | BIT |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | Indicates whether wind hail exclusion applies. |
DeductibleType | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | CHARACTER |
LENGTH: | 1 |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | This is the type of deductible. |
DeductibleAmount | |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | MONEY |
DATA REQUIREMENT: | Mandatory |
DESCRIPTION: | This is the amount of the deductible. |
ActivityStatusCd | |
ALIAS NAME: | Activity Status Code |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | CHARACTER |
LENGTH: | 1 |
DATA REQUIREMENT: | Mandatory |
DEFAULT VALUE: | A |
DESCRIPTION: | The status of the record. Status of record defaults to an 'A' which is Add('U'=Update,'D'=Delete). |
ActivityMaximumRecordNbr | |
ALIAS NAME: | Activity Maximum Record Number |
TYPE: | Attribute |
ORIGIN OF DATA: | Base |
DATA TYPE: | SMALLINT |
DATA REQUIREMENT: | Mandatory |
DEFAULT VALUE: | 1 |
DESCRIPTION: | The maximum record number of the record. Maximum record indicator defaults to 1. |