Attributes

An attribute is equivalent to a column in a table, available for the end-user to input or select data. For example, an entity is the ''Account'' and the attributes are ''name'', ''age'', ''product'', ''no.ofcontract'', ''policyno'', ''address'', ''income''. Attributes include primary keys and foreign keys (type lookup) as well.

FintechOS supports a variety of field types, from usual fields like: text, date, boolean or numeric, to advanced fields like lookup (referencing other entities) or optionset (drop-down list).

You can access the entity attributes from the Data Model section of the entity.

The buttons at the top left corner of the section have the following functions:

  • Insert - Adds a new attribute. For details, see Adding Attributes.
  • Delete - Deletes the currently selected attributes.
  • Export - Exports the currently selected attributes' metadata in an Excel file.
  • Refresh - Refreshes the list of attributes.

System-generated attributes

When you create an attribute, a new column is added within the table corresponding to your entity in the database.

IMPORTANT!
All entities have a set of auto-generated attributes that are used for entity auditing purposes. DO NOT remove them.

This is the list of system-generated attributes:

Attribute Name Attribute Display Name Type Description
entitynameid entitynameid Primary key (PK) The entity unique identifier, the Name provided when creating the entity name.
createdOn Created On Date Time The date and time when the entity was created.
modifiedOn Modified On Date Time The date and time when the entity was updated.
userId User Lookup The current user or the owner of the entity record.
createdByUserId Created by User Lookup The user who inserted that record.
modifiedByUserId Modified by User Lookup The user who made the last updates on the entity record.
businessUnitId Business Unit Lookup The business unit associated with the attribute userId. It is the business unit of the user.
entityStatusId Status Lookup The status of the entity record.
HINT
The PrimaryAttributeName is also generated automatically because it is required to create an entity, but the actual name is chosen by the user.

Types of Attributes

This section describes the types of attributes (fields) you can add in Innovation Studio:.