Adding a User Defined Table

Here are the basic steps for adding a User Defined Table (UDT).

UDTs are RAMM database tables which you have defined yourself so that you can use RAMM to manage your asset and condition data which are not in the standard RAMM Set.

An Overview Of Adding UDTs
This introductory video gives a brief overview of adding a UDT. You would want to watch the extensive detailed videos explaining each step before you added a UDT.
An Overview Of Adding UDTs (3:52)
Loading UDT Settings
If you have previously saved UDT settings you can load the saved XML file and use the existing UDT structure and settings as the basis for a new UDT.
Loading UDT Settings (3:10)
UDT Table Description Options
At the Table Description Options panel you name the table, group it in the list panel and define how the UDT assets will appear on the Map in Pocket RAMM.
UDT Table Description Options (5:23)
UDT Location Options
At the Location Options panel you determine whether the UDT assets will be Point, Line or Area assets and how they will be located, if at all.
UDT Location Options (7:28)
UDT RAMM Modules Options
At the RAMM Modules Options panel you determine whether the UDT assets will be available in RAMM Contractor and Pocket RAMM and will use the Assessment and Asset Valuation functions.
UDT RAMM Modules Options (4:45)
UDT Optional Columns
At the UDT Optional Columns panel you are able to select standard optional columns for your UDT such as External ID, Financial Year. If you will need to run Status Check for your UDT assets you select the Latest column.
UDT Optional Columns (2:06)
UDT Custom Columns
Custom Columns are highly user-configurable. They also have many facets which are explained in the videos on the Understanding Custom Columns page here.
UDT Custom Columns (4:29)
UDT Options
At the UDT Options panel you select the column which will be used as the asset identifier on the map in Pocket RAMM and whether the UDT is Public or Private.
UDT Options (2:26)
Saving UDT Settings
There is a number of reasons why it may be useful for you to save UDT settings. Watch this video to discover a few.
Saving UDT Settings (2:10)
Finishing and Saving a UDT
Finishing and saving a UDT is not as simple as it sounds. There are several matters to be considered if you want to avoid problems.
Finishing and Saving a UDT (3:49)
Understanding UDT Data Validation Rules
When you have saved your UDT you can define Data Validation Rules so that the UDT assets can be added more quickly and with less opportunity for user error. Here is where you ensure that you understand what is meant by UDT Data Validation Rules.
Understanding UDT Data Validation Rules (8:30)
Adding UDT Data Validation Rules
Once you understand the concept of UDT Data Validation Rules you can add them. Here is where you can view the adding of a very simple Data Validation rule making one column Required when another has a particular value and a far more complex Rule.
Adding UDT Data Validation Rules (7:39)