Geotechnical Functions – EnviroInsite Header/Footer Graphic

EnviroInsite templates support the plotting of database functions in Boring Logs or Subsurface Profiles. SQL functions may be used to add graphics to a header/footer in the EnviroInsite template. Functions with names starting with “ei_” will be available in the Functions tab in the right pane of the Template Design window.

Notes:

•EnviroInsite always provides @facility_id and @sys_loc_code as parameters. These functions only support one project (TASK_CODE) per facility.

•These functions support a single image (i.e., DT_FILE entry) per DT_FILE.PLACE_TYPE and PLACE_CODE combination documented below. In cases where there are multiple DT_FILE records for the same DT_FILE.PLACE_TYPE and PLACE_CODE combination, the function will return the file with the most recent DT_FILE.FILE_DATE value.

EI_CAVE_IN_IMAGE

•If there is a record in DT_LOCATION_PARAMETER for PARAM_CODE = ‘Cave_In_Depth’ then this function grabs the graphic (in the CONTENT field – not shown in EQuIS Professional – that stores the file as a Binary Large Object) from DT_FILE.PLACE_TYPE = ‘Cave_In_Graphic’ and DT_FILE.PLACE_CODE = ‘Cave_In_Depth’.

EI_OFFICE_LOGO

•This function checks to see if DT_TASK_PARAMETER has a record with PARAM_CODE = ‘alternative_logo’ . If the PARAM_VALUE for that record is populated, the function will search for the record where DT_FILE.PLACE_TYPE = ‘office logo’ and the DT_FILE.PLACE_CODE that matches that PARAM_VALUE and use the associated image from DT_FILE as the office logo.

•If ‘alternative_logo’ is empty or that record does not exist, then the function searches for a record where DT_FILE.PLACE_TYPE = ‘office logo’ and DT_FILE.PLACE_CODE = ‘Default’ and uses the associated image as the logo.

EI_FIRST_WL_IMAGE

•If there is a record in DT_WATER_TABLE.TYPE = ‘1st Observation’, then this function grabs the image (in the CONTENT field – not shown in EQuIS Professional – that stores the file as a Binary Large Object) from the DT_FILE table where PLACE_TYPE = ‘water_level_graphic’ and PLACE_CODE = ‘1st observation’.

EI_SECOND_WL_IMAGE

•If there is a record in DT_WATER_TABLE.TYPE = ‘2nd Observation’, then this function grabs the image (in the CONTENT field – not shown in EQuIS Professional – that stores the file as a Binary Large Object) from the DT_FILE table where PLACE_TYPE = ‘water_level_graphic’ and PLACE_CODE = ‘2nd observation’.

EI_THIRD_WL_IMAGE

•If there is a record in DT_WATER_TABLE.TYPE = ‘3rd Observation’, then this function grabs the image (in the CONTENT field – not shown in EQuIS Professional – that stores the file as a Binary Large Object) from the DT_FILE table where PLACE_TYPE = ‘water_level_graphic’ and PLACE_CODE = ‘3rd observation’.