EXTRACTION TEMPLATE SETTING
- Jim Roldan
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" } |
| 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. Usage: {"code":"xx", "type":"options" } |
datacode | |
UNITS
| CODE | DESCRIPTION |
|---|---|
| min | |
| hour | |
FORMAT
| CODE | DESCRIPTION |
|---|---|
| "dd/mm/YY" | |