Single Select Database Object Reference

Single Select Database Object Reference (SSDOR) attributes extend the capability of a single select database attribute, and provide users the ability to create attributes that represent an entity with multiple properties.

Use the following conventions while you create a single select database object reference.
  • Select the database lookup table that has numerous columns that are representing an entity.
  • Select the key column carefully as this table might have many columns, and based on the value in the key column, the dependent attributes are populated. You need to use a primary key constraint on this table, as data might keep growing in this table. If the lookup table that is being pointed to is a view, ensure that the data in the view has unique records that are identified by a unique key column.
  • Choose the appropriate columns from the available ones to be displayed at the instance level.
  • SSDOR attributes are mandatory, but are not read-only.

The underlying database lookup table has multiple columns. An entire row in the lookup table would represent the object (entity). The data in this table may keep on growing.

SSDOR attributes allow users to select the columns they would like to view so that they can make more informed choices of the value to be selected at the outset.

Note: Date/date time type fields are not supported in the SSDOR display column.