> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Adjustments

> CSV file format reference for bulk uploading adjustments in Atoti Sign-Off, with column names, required fields, and format details for location and input values.

Download sample file: [adjustments.csv](./csv/adjustments.csv)

This file is used to create adjustments in bulk. For information on how to upload adjustments using this file, see [Upload adjustments](../process-tasks/adjustments/signoff-adjustments-upload).

| Column Name    | Description                                                                                                            | Required | Value Example                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| -------------- | ---------------------------------------------------------------------------------------------------------------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| taskId         | The ID of the related task. You should find this in the task viewer of the UI.                                         | Y        | `1`                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| reason         | The reason for the adjustment.                                                                                         | Y        | `Invalid input`                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| comment        | A comment associated with the adjustment to be performed.                                                              | Y        | `The pricing model is producing an incorrect value for this trade id`                                                                                                                                                                                                                                                                                                                                                                                   |
| adjustmentType | The type of adjustment.                                                                                                | Y        | `VAR_ROLL_OVER`                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| validFrom      | The date the adjustment is valid from.                                                                                 | Y        | `2023-09-28`                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| validTo        | The date until which the adjustment is valid.                                                                          | Y        | `2023-09-29`                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| location       | The location of the adjustment.                                                                                        | Y        | `name=AsOfDate\|value=2023-09-28\|memberPath=[Dates].[Date].[2023-09-28];name=MarketDataSet\|value=Official EOD\|memberPath=[MarketData].[MarketDataSets].[Official EOD];name=Desk\|value=Equities\|memberPath=[Booking].[Desks].[AllMember].[Equities];name=Book\|value=EQ_LARG_DM\|memberPath=[Booking].[Books].[AllMember].[EQ_LARG_DM];name=TradeId\|value=EQ_OPT_Dell 3eab66e4\|memberPath=[Booking].[Trades].[AllMember].[EQ_OPT_Dell 3eab66e4];` |
| measures       | The list of measures the adjustment apply to. This list is semicolon (`;`) separated.                                  | Y        | `VaR`                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| input          | The value of the adjustment: data used to fulfill the adjustment. Format may vary depending on the type of adjustment. | Y        | `name=AsOfDate\|value=2023-09-27;`                                                                                                                                                                                                                                                                                                                                                                                                                      |

## Location

```
name=name1|value=value1|memberPath=memberPath1;name=name2|value=value2|memberPath=memberPath2;
```

Resulting in a `List` of `NamedValueDTO`s separated by semicolons `;` (`List<NamedValueDTO>`).

We get:

```
name=name1|value=value1|memberPath=memberPath1
```

and

```
name=name2|value=value2|memberPath=memberPath2
```

These `NamedValueDTO`s are made from the split by the pipe `|`.
Each become:

```
name=name1
value=value1
memberPath=memberPath1
```

and

```
name=name2
value=value2
memberPath=memberPath2
```

## Input

Similar to [Location](#location)

```
name=name1|value=value1;name=name2|value=value2;
```

becomes a `List` of:

```
name=name1|value=value1
name=name2|value=value2
```

<Note>
  The input depends on your adjustment type. Refer to the documentation of your application server to review the supported adjustments.
</Note>