HOStructureCoverages

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.
   



Back to Top


Back to Home Page