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.
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)
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)
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)
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)
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)
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)
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)
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)
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 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)
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)
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)