CSV File Structure of Data Model Files

When you export an Intelligent Advisor project’s data model, detailed information for each element in the data model is provided in three CSV files:

<filename>.csv (for attributes)
<filename>-entities.csv (only created if there are any non-global entities in the data viewed in Policy Modeling)
<filename>-relationships.csv (only created if there are any containment relationships in the data viewed in Policy Modeling)

Each file includes all information relevant to that object type. The following tables show the information included in each file type.

Table 1. Attribute CSV file columns
Column	Description and notes
Attribute Text	The attribute text.
Entity	The entity that the attribute is assigned to.
Data Type	The type of data that the attribute represents.
Role	The role of the attribute in the policy model.
Name	The identifier given to an attribute and used for substitution on screens and forms and with external applications.
Filter by	The attribute text of the filtering attribute (which can only be set if the data type is a hierarchical value list).
Mapped In	The name of the field in the connected application that is mapped in to the attribute.
Load Stage	The stage when data from the connected application is loaded into the Intelligent Advisor interview. This can be load-at-start or load-after-submit.
Mapped Out	The name of the field in the connected application that the attribute is mapped out to.
Audit?	Indicates whether an audit report is to be saved for the attribute.
Question	The sentence forms for the attribute. Negative forms are only provided for Boolean attributes, and unknown forms are only provided for non-Boolean attributes.
Sentence
Negative
Uncertain
Unknown
Minimum	The minimum and maximum values allowed for the attribute.
Maximum	The minimum and maximum values allowed for the attribute.
Regular Expression	For text attributes, the regular expression used to validate input.
Integer Only	For number and currency attributes, indicates whether integer only values are allowed.
Seed from URL parameter	For global attributes, indicates whether its value can be set from a URL.
Validation Message	For attributes that have input validation, the validation message text that will be displayed when the validation is triggered.
Allow Substitution	For text attributes, indicates whether the attribute allows substitution.
Substitution Gender	For text attributes that allow substitution, indicates whether the gender used for pronoun substitution is personal or impersonal.
Substitution Attribute	For personal text attributes that allow substitution, the attribute used to collect the person's gender.
Invisible If True	Indicates whether the attribute will be hidden in explanations in each circumstance. For more information, see Hide Attributes In an Explanation.
Invisible If False
Invisible If Certain
Invisible If Uncertain
Invisible If Unknown
Invisible Always
Silent If True	Indicates whether the proving attributes will be hidden in explanations in each circumstance. For more information, see Hide Attributes In an Explanation.
Silent If False
Silent If Certain
Silent If Uncertain
Silent If Unknown
Silent Always

Table 2. Entity CSV file columns
Column	Description and notes
Entity Text	The entity text.
Contained By	The parent entity that contains the entity.
Identifying Attribute	The text attribute whose value is used for labeling instances of the entity in explanations, in an interview and in the Debugger.
Name	The identifier given to an entity and used by Analytics Publisher in generated forms and by developers working with the API.
Inferrable	Indicates whether the entity can be inferred.
Mapped to	The name of the table in the connected application that the entity is mapped to.
Mapped Via	The name of the relationship (or link between the tables) in the connected application that the containment relationship in Intelligent Advisor is bound to.
Relationship Text	The text of the relationship from the source entity to the (target) entity.
Relationship Type	The type of relationship from the source entity to the (target) entity.
Relationship Name	The identifier used for the relationship from the source entity to the (target) entity.
Relationship Reverse Name	The identifier used for the reverse relationship from the source entity to the (target) entity.
Relationship Reverse Text	The text of the reverse relationship from the source entity to the (target) entity.
Relationship Invisible If Known	Indicates whether the "invisible" parameter is used to hide the containment relationship in the explanation.
Relationship Silent If Known	Indicates whether the "silent" parameter is used with inferred containment relationships to show the target entities but hide the explanation.

Table 3. Relationship CSV file columns
Column	Description and notes
Text	The relationship text.
Name	The relationship name.
Inferrable	Indicates whether the relationship is inferred.
Type	The type of relationship.
Source	The entity that the relationship comes from.
Target	The entity that the relationship goes to.
Mapped Via	The name of the relationship (or link between the tables) in the connected application that the containment relationship in Intelligent Advisor is bound to.
Reverse Text	The text of the reverse relationship from the source entity to the (target) entity.
Reverse Name	The identifier used for the reverse relationship from the source entity to the (target) entity.
Invisible If Known	Indicates whether the "invisible" parameter is used to hide the relationship in the explanation.
Silent If Known	Indicates whether the "silent" parameter is used with inferred relationships to show the target entities but hide the explanation.