The MTR submittal process allows you to load two types of CSV file formats. The basic format contains the tag data and must have the tag name, type, area, and unit. The classification should be specified as MTR to create an MTR submittal. The inverted format contains the tag properties and must have the tag name.
The below table gives you a better understanding of the mappings delivered in the system.
|
Name |
VTLImportDefHeaderOrder |
Column header text |
Column type |
Constant value |
Maps to |
Notes |
|---|---|---|---|---|---|---|
|
Tag_Name |
1 |
Tag_Name |
Physical |
FDWTag/Name |
The FDWTag object must exist. UID=FTG, COMP_ConfigLevelUID, COMP_PlantCodeValue, Tag_Name |
|
|
Description |
2 |
Description |
Physical |
Description |
||
|
Type |
3 |
Type |
Physical |
FDWTagClassification/Name |
The FDWTagClassification object must exist. UID=FTC, Type, ClassificationOccurrence |
|
|
CriticalityRating |
4 |
CriticalityRating |
Physical |
FDWCriticalityRating |
Gets the criticality rating from the csv. |
|
|
Project |
5 |
Project |
Physical |
FDWTagProject relationship |
UID=PR, Project |
|
|
Contractor |
6 |
Contractor |
Physical |
FDWTagOrginatingOrg relationship |
UID=CO, Contractor |
|
|
Area |
7 |
Area |
Physical |
FDWTagArea relationship |
The SDAArea object must exist. UID=FBA, COMP_ConfigLevelUID, Area |
|
|
Unit |
8 |
Unit |
Physical |
FDWTagUnit relationship |
The SDAUnit object must exist. UID=FBU, COMP_ConfigLevelUID, COMP_PlantCodeValue, Unit |
|
|
SECURITYCODE |
9 |
Constant |
Unclassified |
SDAItemSecurityCode2 relationship |
The SDASecurityCode2 (Unclassified) object must exist. |
|
|
ConfigLevel |
10 |
Computed |
Gets the current configuration level 1. |
|||
|
ClassificationOccurrence |
11 |
Constant |
1 |
Sets the CFIHOS classification short code to 1. |
||
|
COMP_ConfigLevelUID |
12 |
Computed |
Replaces any space with an underscore character in the configuration string. |
|||
|
COMP_PlantCode |
13 |
Computed |
Builds the plant code from the configuration level and Area. |
|||
|
COMP_PlantCodeValue |
14 |
Computed |
Gets the plant code object from the system - used in the UID of the Unit. |
|||
|
Resolve_Classifications |
15 |
Computed |
Gets the names of the document or tag classifications related to the current create configuration. |
|||
|
Comp_Classification |
16 |
Computed |
Replaces the empty spaces in names with an underscore (_) and appends a hyphen (-) at the beginning and the end of the string. |
|||
|
Classification_Pattern |
17 |
Computed |
Creates a regular expression pattern for the classification column. |
|||
|
Classification_AppendWildcards |
18 |
Computed |
Constructs a classification pattern for the resolve classification column. For example, if the Resolve_classifications returns AB,A C,and AD, then it constructs a pattern, such as -AB-,-A_C-, and -AD-. |
|||
|
Validate_Classification |
19 |
Computed |
HEXSDxSource |
Sets the SDXSource property to true if the classification entered in csv is available in the current create configuration. Otherwise, sets the property to null. This property is validated using the "HEX Check property HEXFDWDocumentMaster-masterref-HEXSDxSource Is Not blank" rule. |