UPX Location Record Fields for Import

1

RecTypeCode

Use record type 63 for location records.

2

PolID

Policy identifier

3

LocID

Location identifier

4

ISOBIN

ISO® Building Identification Number

5

Name

Location name

6

Address

Street address

For offshore platforms, Complete Area Definition

7

City

City

For offshore platforms, AIR ID

8

AreaScheme

Area scheme

9

Area

Area (state, CRESTA zone, etc.)

10

SubArea

Subarea (in the U.S., county code)

11

PostalArea

Postal area

For offshore platforms, Block

12

Country

Country code

13

GeoLat

Latitude

14

GeoLong

Longitude

15

EffFrom

Effective start date

16

EffTo

Effective end date

17

Currency

Currency name

18

ExchRate

Currency exchange rate (Reserved for future use)

19

RiskCount

Number of risks

20

RepValBldg

Replacement value for Coverage A

21

RepValOStr

Replacement value for Coverage B

22

RepValCont

Replacement value for Coverage C

23

RepValTime

Replacement Value for Coverage D

24

RVDaysCovered

Number of days covered by RepValTime

25

Premium

Premium

26

ConType

Construction code type

27

ConBldg

Construction class - building

28

ConOStr

Construction class - other structures

29

DamageModFactor

Contents damage modification factor

30

OccType

Occupancy code type

31

Occ

Occupancy class

32

YearBuilt

Year built/upgraded

33

Stories

Number of stories

34

GRCBldg

Guaranteed replacement cost factor, building (default 1.0)

35

GRCCont

Guaranteed replacement cost factor, contents (default 1.0)

36

GrossArea

Gross area of the building (e.g., square feet of square meters)

37

PerilCount

Number of peril combinations

38

Peril

Peril(s) covered code

39

LimitType

Limit type

40

Limit1

Coverage A limit

41

Limit2

Coverage B limit

42

Limit3

Coverage C limit

43

Limit4

Coverage D limit

44

Participation

Percentage of risk covered by the insurer

45

Participation2

Percentage of risk owned by the insured (Working Interest)

46

DedType

Deductible type

47

Ded1

Deductible 1

48

Ded2

Deductible 2

49

Ded3

Deductible 3

50

Ded4

Deductible 4

51

Territory

User-defined territory code

52

SublimitArea

User-defined sublimit area code

53

ReinsCount

Number of reinsurance contracts

54

ReinsOrder

Reinsurance order

55

ReinsType

Ceded reinsurance type

56

ReinsCID

Certificate or program ID

57

Reinsfield1

Ceded reinsurance field 1

58

Reinsfield2

Ceded reinsurance field 2

59

Reinsfield3

Ceded reinsurance field 3

60

Reinsfield4

Ceded reinsurance field 4