Suggestions Required - LOV/Value Meaning

[icon02#009]

So am quite new to EA but have been using it successfully to meet the requirements of my client for last couple of months. They required a "this is what we have / where we are"  model of Apps, API's , Data, and importantly Flows. Managed to create as a sort of "DataFlow" diagram but , importantly, utilising the reverse engineering capabilities to bring in Tables, Views  and Code from Oracle have been able to show the real contents of the dataflow e.g. from an Application to/from an API.

Work has generated interest in EA from other departments in how it could be used to help them.

So the challenge I am struggling with ...

How could one record the Metadata of an attribute ? Specifically how could one record

1. the definitive values and their meaning that a column (attribute) has
2. The derivation rules for the attribute

Not sure I have really explained this very well - feel free to question me !!

[Sunshine]

You can try the following;

• Use the attribute notes
  
• attribute qualifiers
• define your own attribute tag values

[Geert Bellekens]

1. the definitive values and their meaning that a column (attribute) has

Do you mean like an enumeration?
e.g. Attribute Order Status with possible values Pending, Ordered, Processing, Delivered?

In that case you define an enumeration in your model with these values and set it to be the type of your attribute.
On each of the values you can add a description.

Geert

[icon02#009]

Thanks both for the help. 

I have set up a test Entity with one attribute and have added some Tags and Qualifiers to see how they could be reported (as a lot of the consumers of what I produce are not EA users ). Have developed a custom report (been successful in the past with Packages and Flows and what the Flows contain,  although can see that the Publish has limitations ) but cant seem to be able to report the Tags or the Qualifiers that I have against my attribute.

So I though that I would revert to writing my own SQL search ( am a half-able SQL writer although suffering a bit as my experience is with Oracle  ) but can anyone help with which tables I need to look in ?

[qwerty]

Attributes are found in t_attribute with matching ObjectID. Tagged values in t_attributetag with matching ElementID. In both cases it refers to t_object.object_id (note the consistence in the naming).

q.

[Geert Bellekens]

t_attributetag with matching ElementID. In both cases it refers to t_object.object_id (note the consistence in the naming).

Actually t_attributeTag.ElementID corresponds with t_attribute.ID

Geert

[qwerty]

Uh. Thanks for the correction, Geert. Obviously not my day.

q.

[icon02#009]

Attributes are found in t_attribute with matching ObjectID. Tagged values in t_attributetag with matching ElementID. In both cases it refers to t_object.object_id (note the consistence in the naming).

q.

Thankyou  Very helpful and query now built