Condition Assessment Import

Column

Field

Required/Optional

Description

1

Assessment Date

Optional

If no date is supplied, this will be defaulted to the date of import.

2

Current Rating Code

Required

The value in this field will be added to the Ratings table if it does not already exist.

3

Priority Description

Required

The value in this field will be added to the Priority table if it does not already exist.

4

Comments

Optional

This is the condition assessment comments.

5

Asset Number

Optional

The assessment must contain either an asset number or a location code.

6

Location Code

Optional

The assessment must contain either a location code or an asset number.

7

Work Element

Optional

The value in this field will be added to the Work Element table if it does not already exist.

8

Work Element Priority

Optional

The value in this field will be added to the Priority table if it does not already exist.

9

Advance/Delay

Optional

The value for the Advance/Delay field must be in the following format: <A/D> <n> <X>. The first character must be "A" to indicate an Advance, or "D" to indicate a delay. <n> is the number of days, weeks, months or years that you want to advance or delay by. <X> is the advance/delay units, either "D" for days, "W" for weeks, "M" for months, or "Y" for years. For example, a delay of 4 weeks would be: D 4 W