====== ORSEE-Payment ======

ORSEE payment is set up for the settlement of the participant payments. All relevant data is collected via ORSEE and can also be updated by the participants. \\

The **links to the ORSEE server** (admin and user) can be found on the [[crc:sfb:|SFB wiki page]].
\\
\\
\\
From now on, the ORSEE database automatically exports all entries of the particular experiments on every Sunday and saves the data of the last 4 months (using the variable date of survey) under the export date (format YYYYMMDD) and the corresponding experiment name (e.g. //20210316 -ITC Biasing 2.0 Eyetracking.csv//).
\\
\\
\\
**File Location:** [[\\vs-grp02.zih.tu-dresden.de\nic_projects\ORSEE_Payments\]]\\
An authorization for this file can be requested by contacting <jens.strehle@tu-dresden.de>.
\\
\\
\\
This list contains the data that will be exported for payment:
^ Field Name in Excel ^ Excel ^ ORSEE ^
| Last Name | obligatory | from ORSEE |
| First Name | obligatory | from ORSEE |
| PSP/Source of Funding | obligatory | no ORSEE entry |
| Date of Birth | voluntary | from ORSEE |
| Nationality | voluntary | no ORSEE entry |
| Street Address | obligatory | from ORSEE |
| Postcode | obligatory | from ORSEE |
| City/Town | obligatory | from ORSEE |
| Country | obligatory | from ORSEE |
| IBAN | obligatory | from ORSEE |
| Payment Amount| obligatory | no ORSEE entry |
| Impersonal Account | default: 613390 | no ORSEE entry |
| Payment Reference | default: Probandengeld | no ORSEE entry |
| Payment Pattern | obligatory | no ORSEE entry |
| Error Note | voluntary  | no ORSEE entry |
| Date of Data Collection | not in Excel | from ORSEE |

In this folder (//see **File Location**//) can be found an Excel file (//'NeuSapZahlungen1.2s_js.xlsm'//), which you should save locally.\\

With this file you can import several exported csv files, check the IBAN information and send this file to the SFB940 coordination office.\\

These respective Excel files can be combined and sent to the SACHGEBIET 1.3 - DRITTMITTELVERWALTUNG. The import of the documents will be done in SG 1.3. only with instruction of the original, which should be submitted on paper at the same time please.\\
\\
\\
The following macros are used by this Excel file:
{{ :tools:orsee:orsee:makros_orsee_payment.png?1000 |}}

\\
To be able to start the macro, click on:\\

Datei-> Optionen-> Trust Center-> Einstellungen für das Trust Center-> Makroeinstellungen \\

and select option 2 (**Alle Makros mit Benachrichtigung deaktivieren**).\\

{{ :tools:orsee:trust_center.png?1000|}} \\
\\
\\

After starting the program, you will see a security message that must be confirmed by clicking the 'Inhalt aktivieren' button.

{{ :tools:orsee:sap_payment.png?1000 |}}