The following table contains the UDT videos in the order in which you should watch them if you are going to watch them all.


An Introduction to User Defined Tables(UDTs) This video will give you a brief introduction to the concept of User Defined Tables and how you might use them. This should be the first UDT video that you watch.
An Introduction to User Defined Tables (3:58)


An Overview Of Adding UDTs This video will give you a brief overview of adding a UDT. You should watch this before you start to add your own UDTs so that you understand the process of adding UDTs.
An Overview Of Adding UDTs (3:52)


Planning Complex UDTs You can manage your parks, open spaces, and buildings in RAMM. You do this by creating complex UDTs. Before you launch RAMM Manager to create your complex UDTs you need to plan them very carefully. Here is some advice on asset models, asset trees and asset attributes.
Planning Complex UDTs (3:15)


Setting Up Dropdowns For Multiple UDTs For many of your UDT asset types you will need to store similar data such as Material Used or Colour. You save time and ensure greater consistency if you create drop-down lists that can be used across a number of UDTs. Watch this video to see how to do this.
Setting Up Dropdowns For Multiple UDTs (5:27)


Lookup UDT Attributes Custom Columns are powerful and highly configurable. Not only can you associate attributes with Custom Column values, you can make those attribute values default. Watch this video to find out how you can do this.
Lookup UDT Attributes (4:35)


Grouping UDTs in the List Panel When you are creating your complex UDTs in RAMM Manager you will end up with a large number of component asset type UDTs. You should group the component UDTs in the User Defined Tables List panel so that they match your template and are easier to locate and manage.
Grouping UDTs in the List Panel (3:20)


Grouping or Category UDTs When you are managing your Complex UDT assets in Pocket RAMM or in RAMM Detail, you, your users, and your operators will find them difficult to deal with if they are not logically constructed. So you need Grouping or Category UDTs to make them easier to use.
Grouping or Category UDTs (3:16)


Understanding Linking and Link Types Parks, open space and building UDTs are constructed from many component assets. These components are all linked to the park, open space or building UDT. So before you contemplate adding complex UDTs you need to understand linking and link types.
Understanding Linking and Link Types (5:30)


Understanding UDT Relationships When a user is adding a component to a park, open space, and building UDT, it helps if RAMM Detail or Pocket RAMM prompt them to add the asset in the correct asset group. So before you contemplate creating complex UDTs you need to understand UDT relationships.
Understanding UDT Relationships (4:09)


UDTs and Staff Permissions Users need the correct Staff Permissions to add, update or delete the UDTs themselves and a different set to manage the asset records in the tables. Here is an explanation of the Staff Permissions needed to create UDTs and to add, update, and delete UDT asset records.
UDTs and Staff Permissions (4:01)


UDTs and Pocket RAMM If you want your operators to be able to view and manage your UDT asset records in Pocket RAMM you need to understand how to control this. Here are the details of how UDTs function in Pocket RAMM including Online, Offline, and synchronisation settings.
UDTs and Pocket RAMM (8:09)


Loading UDT Settings If you have previously saved UDT settings, you can load the saved XML file and use the UDT structure and settings as the basis for new UDTs. Loading saved settings is useful if you are creating a number of similar UDTs or if you had to stop halfway through creating one and want to return to where you were.
Loading UDT Settings (3:11)


Exporting UDT Data You can export the asset data from a UDT. This leaves the structure and table data untouched. You would do this if you were making changes to a UDT and wanted to make a backup in case you botch the changes and have to delete the UDT and its data and then recreate the table and its data.
Exporting UDT Data (3:56)


Importing UDT Data You can import asset data into a UDT. You would do this if you were recreating a UDT and its data from a backup. You might also do this if you had created a UDT for asset data created outside of RAMM so that you can manage the assets in RAMM.
Importing UDT Data (4:30)


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. You also determine whether it will be an Asset Type UDT or a Lookup UDT.
UDT Table Description Options (5:23)


UDT Location Options At the Location Options panel you determine how UDT assets will be located, if at all. Normally they are associated with a Road. You also determine whether the UDT assets will be Point, Line or Area assets. You also have displacement, offset, and other location options.
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. You also use this panel for inventory UDTs whch are mobile and require records of replacements.
UDT RAMM Modules Options (4:43)


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, Audit, and Notes. 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 very powerful and highly user-configurable. You can base them on the standard RAMM column types such as text, date, Boolean, fixed list of options, and so on. You can also create Calculated Custom Columns if you need values to default.
UDT Custom Columns (4:29)


Calculated Custom Columns You use Calculated Custom Columns to create UDT Custom Columns for which values will default based on other values you have selected. Once you have opened the Expression Entry screen there is very useful Help if you are not confident to write your own expressions.
Calculated Custom Columns (4:34)


Make Model Fields When creating UDTs you will sometimes want the values in one field to be dependent on the values in another field. For instance if you select Holden at a car Make field, you’ll only want Holden models to be available at the car Model field. Similarly, if you were to choose Toyota at the car Make field, you would want only models such as Corolla, Camry and Hilux to be available at the car Model field.
Make Model Fields (5:05)


Understanding Control Layout When you are adding a Custom Column you can use the Control Layout screen to configure short field labels for Pocket RAMM as well as labels for Grid and Detail screens. There is a helpful section where you can see how your changes will display in the different screen types.
Understanding Control Layout (2:18)


UDT Options At the UDT Options panel you select the table column which will be used as the asset identifier on the map in Pocket RAMM. The default is the System ID. You also determine whether the UDT will be a Public UDT or a Private UDT. Most are Public.
UDT Options (2:26)


Understanding Private UDTs Private UDTs are initially invisible to all users on a database except the users who create them. Users must be granted explicit permission to even view the UDT and its assets. They were created for Contractors to manage their own data which is not specified in the contract.
Understanding Private UDTs (4:53)


Saving UDT Settings When you have defined your UDT you can save the UDT settings in an XML file. There is a number of reasons why it may be useful for you to save UDT settings. For instance, if you are creating a number of similar UDTs. Watch this video to find out more.
Saving UDT Settings (2:10)


Finishing and Saving a UDT The final act in adding a UDT is to finish and save it. Before you do this you should carefully check all the UDT settings if you want to avoid problems in the future. Making changes to UDTs which already have records is problemmatical. Best to do it once and do it right.
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)


Adding a Park, Reserve or Open Space UDT Watch this video for a brief overview of the steps involved in adding a complex UDT. Prior to adding a complex UDT you should watch the grouping, linking and relationships videos. You should also check out the Location Options and RAMM Modules Options videos at least.
Adding a Park or Open Space UDT (3:20)


Adding a Park, Reserve or Open Space Road You create complex UDTs so that you can manage and report on assets such as parks and buildings. Watch this video to understand why when you are adding a complex asset such as a park, reserve, open space or building, it needs to be associated to a road for reporting and other functions.
Adding a Park or Open Space Road (6:57)


Adding UDT Assets In RAMM GIS Best practice is to add UDT asset records in RAMM Detail and RAMM GIS. You add linked assets in RAMM Detail and then their shape files in RAMM GIS. Or add UDT asset shape files first and then complete the asset details and linking. The shapes display in RAMM, RAMM Contractor and Pocket RAMM.
Adding UDT Assets In RAMM GIS (5:08)