Map fields for 2014tc16rftn003 producer, XLS file types
Example input data: stub
Transform function: implementation details
recordObject Piece of data to transform before going to harmonized storage.
Returns Project JSON matching the type fields.
Preprocess budget.
Input fields taken from the record are:
Total eligible expenditure allocated to the operationUnion co-financing rate in %
recordObject The row received from parsed file
Returns Budget
Preprocess description.
Input fields taken from the record are:
Priority axisOperation summaryProgramme & operation specific objectiveUnion co-financing rate in % (average as in CP)
recordObject The row received from parsed file
Returns String
Preprocess project_id.
Input fields taken from the record are:
Operation name
recordObject The row received from parsed file
Returns String
Gets NUTS code level from a string.
codeString The NUTS code
Returns Number The level of NUTS or null if one can't be extracted
Preprocess project_locations.
Input fields taken from the record are:
CountryTownOperation postcodeNUTS1NUTS2NUTS3
recordObject The row received from parsed file
Preprocess themes.
Input fields taken from the record are:
Programme's investment priority / thematic priority
recordObject The row received from parsed file
Preprocess third_parties.
Input fields taken from the record are:
CountryBeneficiary name in EnglishHas the lead of the operation (Y/N)
recordObject The row received from parsed file
Returns Array<ThirdParty>
Preprocess/format date.
dateDate DateSupported formats:-DD/MM/YYYY
Returns Date The date formatted into an ISO 8601 date format
Preprocess timeframe.
Input fields taken from the record are:
Operation start dateOperation end date
recordObject The row received from parsed file
Returns Timeframe
Preprocess title.
Input fields taken from the record are:
Operation name
recordObject The row received from parsed file
Returns String