# Defining attribute properties
When a datasource is created using a table, the platform generates an attribute for each column in the table. You can also create an attribute manually. You can edit the properties of the attributes as per the requirement.
An attribute can have the following properties:
| **Property** | **Description** |
| ---------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Name** | The name of the attribute being created
Note: The name should not contain any special character other than space.
|
| **Type** | The data type of the column
Note: The number columns are of the data type decimal and the character columns are of the data type String.
|
| **Length** | The maximum length of the data |
| **Scale** | The maximum number of decimal places allowed in numeric data |
| **Default Value** | Note: You can define a default value for the attribute that will be set if the user does not enter the value for the attribute.
- UUID: generates and populates the attribute value with a Universally Unique Identifier (UUID)
- OrgID: populates the attribute value with the Org Id of the current subdomain
- SYSDATE: current date
- master.attributeName: Populates the attribute value from a parent/master row
- CURRENTUSER: The username of the signed in user
- CURRENTUSERID: The user id of the signed in user
- =SELECT: Executes the given select statement and populates the attribute with the resulting value
- PASSWORD: Populates the attribute value with the hash value of a randomly generated 12 alphanumeric value. The actual password value in clear text will be populated withattributeName\_clear. For example, if pwd is the attribute name, then pwd\_clear will have the generated value and pwd will have the hash value.
- String or Number Constant Value: If the specified value doesn't fall under any of the above, then it is treated as a constant value.
|
| **Insert** | Indicates whether the user can provide a value while inserting a row |
| **Update** | Indicates whether the user can change the value while updating a row |
| **Calculated** | Indicates whether the attribute is a calculated value and should not be included in Insert or Update |
| **Column name** | The column name in the database that the attribute is mapped to |
| **Out Parameter** | Applicable when **UseAPI** is selected while defining the datasource details. The parameter in the API will be treated as IN OUT type. |
| **Primary** | Indicates that the attribute is a primary key |
| **Auto Sequence** | Indicates that the value is generated from a database sequence.
If selected, in the Default Value column, enter the sequence name
|
| **Optional** | Indicates if the attribute can be left blank by the user |
| **Audit** | Indicates if the changes to the attribute value should be audited |
| **Query** | Indicates that the column should be automatically included in the Where Clause when a value is passed during a query.
When this property is not selected, the platform will not include the column in the where clause even if a value is specified. The developer should programmatically handle its value through the pre-query script.
|
| **Disable Uppercase Search** | By default, the where clause is constructed as UPPER(column) LIKE 'VALUE%.
When this property is selected, column = 'Value' is constructed instead, which gives better performance when the column is indexed without using the UPPER function
|
| **Select** | Indicates if the column is a part of the select clause |
| **Export** | Indicates if the column is a part of the select clause while exporting the data |
| **Param Name** | Applicable when Use API is selected while defining the datasource details. By default, the parameter name is assumed to be P\_COLUMN\_NAME. If the parameter name in the API is other than P\_COLUMN\_NAME, then specify the exact parameter to be used here. |
* To fetch all the attributes and their values from the database, in the **Attributes** tab, in the actions bar, click. The data from the database is displayed n the table in the **Attributes** section.
* To create an attribute, in the **Attributes** tab, in the actions bar, click . A row is added in the **Attributes** section. You can select/enter the required properties for each attribute.
* To set the attribute property, for the required attribute name, enter or select the appropriate values for the corresponding columns.
* To search for a specific attribute value,
a. In the **Attributes** tab, in the actions bar, click
. Search filters are displayed for each attribute. Clicking onagain will hide with search filters.
b. To search for a specific attribute values, in the search filters for the respective attribute(s), select the search criteria. The attributes are displayed as per the search criteria.
* To delete a data row, in the checkbox column,
a. Select the row(s) that you want to delete and click 
.
b. Click **Delete**. The selected row(s) are deleted.
* To refresh the table, in the **Attributes** tab, in the actions bar, click  .