Version: 10.2.1c and 10.2.1.c SP3 |
Appendix > ArcFM System Tables |
The MM System Tables are created when an administrator (logged in as SDE) selects the ArcFM Solution System Tables button. Each of these tables must have the ARCFMSYSTEMTABLE model name assigned.
MM_CLASS_MODELNAMES
This table stores model names assigned to features and objects.
Field
Data Type
Description
ModelDatasetName
Text
Contains the name of the dataset to which the feature or object belongs.
ObjectClassName
Text
Contains the name of the feature or object class to which the feature belongs.
SubtypeUsed
Number
Reserved for future use.
Subtype
Number
Reserved for future use.
ModelName
Text
Contains model name assigned to the feature or object class.
MM_DOCUMENTS
This table stores user documents.
Field
Data Type
Description
DocumentName
Text
The user-defined name of the document. This is how it appears in the Documents dropdown menu.
Description
Text
Reserved for future use.
UserName
Text
The Login name of the user who created the document.
Document
OLE Object
Stores the document in binary format.
MM_EDITED_FEATURES
The Feeder Sync tool uses this table to track which features' feeder information is affected by edits. It uses this information to update the Feeder Manager 1.0 fields during sync.
Field
Data Type
Description
ClassID
Long Integer
Unique ID associated with the type feature that has had feeder information impacted by edits.
FeatureID
Long Integer
Unique ID associated with the feature who's feeder information has been impacted by edits.
Version
Text
The version of the edit session during which the feature was modified.
MM_FIELD_MODELNAMES
This table stores model names assigned to attributes.
Field
Data Type
Description
ObjectClassName
Text
Contains the name of the feature or object class to which the feature belongs.
FieldName
Text
Contains the name of the field to which the field model name is assigned.
ModelName
Text
Contains the field model name assigned to the attribute field.
MM_HIDDEN_PACKAGES
This table stores objects that are available system-wide, but don't appear in any of the system or user menus. For example, map books that are associated with designs. (Designer only).
Field
Data Type
Description
Name
Text
The name of the saved object (e.g., design map book). While the length of this value is determined by the length of the field, Schneider Electric strongly recommends this value be at least 32 characters.
Category
Number
Indicates the type of object. This table uses the mmPackageCategory enumeration.
Description
Text
A description of the design map book. This may be generated programmatically.
UserName
Text
Name of the design to which the map book is assigned.
ContentsProgID
Text
Contains the ProgID of the COM object that manages the package.
Contents
OLE Object
Stores the package in binary format.
MM_MOBILE_IMPORT_ORDER
This table stores the order in which features are imported into the enterprise database from the Mobile field database.
Field
Data Type
Description
Object_Class_Name
Text
This is the table name of the feature class (visible in the Packet Template database) to be imported (e.g., Transformer).
Object_Class_ID
Number
This is the identifier for the object class.
Subtype_ID
Number
This is the identifier for the subtype of the object class to be imported.
Import_Order
Number
This is the order in which you want the features to be imported. A feature layer with an import order of 1 is imported first.
MM_PACKAGES
This table stores map books and Structural Analysis scenarios. An object stored in this table is available only to the user who created it. Map book stored in this table may be accessed in Designer only by opening the associated design.
Field
Data Type
Description
Name
Text
The name of the saved object (e.g., map book or structural analysis scenario). While the length of this value is determined by the length of the field, Schneider Electric strongly recommends this value be at least 32 characters.
Category
Number
Indicates the type of object. This table uses the mmPackageCategory enumeration.
Description
Text
A description of the saved object. This may be generated programmatically.
UserName
Text
Login name of the user who saved the object.
ContentsProgID
Text
Contains the ProgID of the COM object that manages the package.
Contents
OLE Object
Stores the package in binary format.
MM_PAGE_TEMPLATES
This table stores user page templates.
Field
Data Type
Description
Name
Text
The user-defined name of the page template. This is how it appears in the Page Templates dropdown menu.
Description
Text
Reserved for future use.
UserName
Text
Login name of the user who created the page template.
Template
OLE Object
Stores the page template in binary format.
MM_PERSIST_INFO
This table stores binary information about user preferences and settings such as user favorites and options settings.
Field
Data Type
Description
TreeName
Text
The type of information stored.
Data
OLE Object
Stores the information in binary format.
UserName
Text
The login name of the user.
MM_QAQC
This table allows you ignore some Feeder Manager 2.0 QA/QC rules for designated features. This functionality and how to enable it is discussed in the Feeder Manager section on the Validation Rules page in the Configuration Guide.
Field
Data Type
Description
FeatureID
Long Integer
Unique ID associated with the piece of equipment that will ignore the specified QA/QC rule.
FeatureClassID
Long Integer
Unique ID associated with the type of equipment that will ignore the specificed QA/QC rule (e.g., an ID to indicate whether the equipment type is switch or transformer, etc.).
QaqcRule
Text
The rule that will be ignored by the feature (e.g., Electric MultiFeed Feature or Electric Loop Feature).
MM_SNAPPING
This table stores snapping information for feature classes.
Field
Data Type
Description
Feature_Class
Text
The feature class that may be snapped.
Subtype
Text
The subtype of the feature class that may be snapped.
Snap_to_feature_class
Text
The feature class to which the feature is snapped.
Snap_to_Subtype
Text
The subtype of the feature class to which the feature is snapped.
HitType
Number
Stores the snapping preferences such as Vertex, Edge, and/or End.
Tolerance
Number
The snapping tolerance as defined by the user.
Subtype_Code
Number
Stores a code that corresponds with a specific subtype for the feature.
MM_STORED_DISPLAYS
This table stores user stored displays.
Field
Data Type
Description
Name
Text
The user-defined name of the stored display. This is how it appears in the Stored Display dropdown menu. Modify the length of this field in the database if you wish to change the maximum length for user stored display names.
UserName
Text
The Login name of the user who saved the stored display.
Map
OLE Object
Stores the stored display in binary format.
MM_SYSTEM_DOCUMENTS
This table stores system documents.
Field
Data Type
Description
DocumentName
Text
The user-defined name of the document. This is how it appears in the Documents dropdown menu.
Description
Text
Reserved for future use.
UserName
Text
Stores a value of SYSTEM to indicate a system document.
Document
OLE Object
Stores the document in binary format.
MM_SYSTEM_PACKAGES
This table stores map books and Structural Analysis scenarios that are available to all users connected to the geodatabase.
Field
Data Type
Description
Name
Text
The name of the saved object (e.g., map book or structural analysis scenario). While the length of this value is determined by the length of the field, Schneider Electric strongly recommends this value be at least 32 characters.
Category
Number
Indicates the type of object. Uses the mmPackageCategory enumeration.
Description
Text
A description of the saved object. This may be generated programmatically.
UserName
Text
Stores a value of SYSTEM to indicate a system map book or scenario.
ContentsProgID
Text
Contains the ProgID of the COM object that manages the package.
Contents
OLE Object
Stores the package in binary format.
MM_SYSTEM_PAGE_TEMPLATES
This table stores system page templates.
Field
Data Type
Description
Name
Text
The user-defined name of the page template. This is how it appears in the Page Templates dropdown menu.
Description
Text
Reserved for future use.
UserName
Text
Stores a value of SYSTEM to indicate a system page template.
Template
OLE Object
Stores the page template in binary format.
MM_SYSTEM_PERSIST_INFO
This table stores binary information about the database including system favorites, CUs, graphic favorites, macros, autoupdaters, and database level model names.
Field
Data Type
Description
TreeName
Text
Type of information stored.
Data
OLE Object
Stores the information in binary format.
MM_SYSTEM_STORED_DISPLAYS
This table stores system stored displays.
Field
Data Type
Description
Name
Text
The user-defined name of the stored display. This is how it appears in the Stored Displays dropdown menu. Modify the length of this field in the database if you wish to change the maximum length for system stored display names.
UserName
Text
Stores a value of SYSTEM to indicate a system stored display.
Map
OLE Object
Stores the stored display in binary format.