...

CREATE FILES(s)  executes usp_rpdo2 stored procedure in the back end by calling the EXEC statement in QT_BREAKDOWN_PATH to create the data file.

• The select statement in the VALUE column is executed to create the data file The result_instance_id value of the query is inserted  dynamically  each time of data file is created for the same table_instance_id. and does not store in the QT_BREAKDOWN_PATH 

1.8.1 Data file creation

CREATE FILES(s)  executes the <data request name>.csv  in QT_BREAKDOWN_PATH.

• The select statement in the VALUE column is executed for the default table data file creation. The result_instance_id value of the query is inserted  dynamically  each time of data file is created for the same table_instance_id. and does not store in the QT_BREAKDOWN_PATH 
• The select statement in the VALUE column  of the <data request name>.CSV for the data request is executed to create the data file. 

Data file format/location and Email parameters set-up

...