An EXTRACTION TEMPLATE can be defined via SETTINGS or explicitly passed by to an extractions functions.

There are different types of extraction templates settings:

EXTRACTION.TASK
EXTRACTION.ADMISSION
EXTRACTION.EVENT

Other templates settings could be added in the future.

An example of a settings:

OBJECT_ID	OBJECT_TYPE	CODE_ID	SETTING_VALUE
system_team_id (*)	SYSTEM	EXTRACTION.TASK	See EXTRACTION TEMPLATE SETTING FORMAT below
system_team_id (*)	SYSTEM	EXTRACTION.ADMISSION
system_team_id (*)	SYSTEM	EXTRACTION.EVENT
team_id	TEAM	EXTRACTION.TASK
team_id	TEAM	EXTRACTION.ADMISSION
team_id	TEAM	EXTRACTION.EVENT
subscription_id	SUBSCRIPTION	EXTRACTION.ADMISSION
task_template_id	TASK	EXTRACTION.TASK
event_template_id	EVENT	EXTRACTION.EVENT

(*) See WEB SERVICES CONFIGURATION on the definition of the SYSTEM_TEAM

EXTRACTION TEMPLATE FORMAT

SETTING_VALUE is a JSON which could contain a list of /wiki/spaces/DES/pages/23003161 or objects i.e:

[{"code": "TASK.DESC"},
{"code": "TASK.DESC", "ref": "xxx"},
{"code": "TASK.DURATION", "units": "min"},
{"code": "TASK.START.DATE", "source" : "ADMISSION(TASK_CODE)", "format": "dd/mm/YY"},
{"code": "TASK.START.DATE", "source" : "ADMISSION", "format": "dd/mm/YY"},
{"code": "HEIGHT", "type" : "datacode"},
"TASK.MODIFIED"]

Note: when the code is defined as an object some extra parameters could be added as "format" to specify a date format.

To define the type of the DB route associated with each #DATA CODE the TEMPLATE uses the /wiki/spaces/DES/pages/33620018.

TEMPLATE ELEMENT STRUCTURE


"code"	the code entry in the /wiki/spaces/DES/pages/23003161
"units"	the units of the measure (i.e. min, hour....)
"format"	the output format of the data (i.e. "dd/mm/YY")
"type"	Look at OPTION TYPE table
"source"
"formula"
"ref"

OPTION TYPE

CODE	DESCRIPTION
array	Will allow to display several values if more than one element is retrieved: Usage: {"code":"xx", "type":"array" } Return: {"code":"xx", "index":1 } {"code":"xx", "index":2}....{"code":"xx", "index":n} where "n" is the maximum number of repeated elements
options	Will show a column for each of the possible option values, with a 1 or "empty string" if the option is checked or not. Empty columns will not be shown by default unless in the future is a parent to set "display empty columns" Usage: {"code":"xx", "type":"options" } Return: {"code":"xx", "option_id":"1" }, {"code":"xx", "option_id":"2" }....{"code":"xx", "option_id":"n" } (this can also be expressed explicitly)
datacode

UNITS

CODE	DESCRIPTION
min
hour

FORMAT

CODE	DESCRIPTION
"dd/mm/YY"

Browser not supported