5. Reports

5.1. Correlation (affine and splice) table reports

Stratigraphic correlation data is reported in four types of reports (Fig. 5-1, lower left):

• List of affine tables
• Affine tables
• List of splice interval tables
• Splice interval tables

Figure 5-1. Screen capture of correlation reports options within the LIMS Reports framework.

List of affine tables report

This report lists the CCSF alternate depth scales available in LIMS, and the original affine table files that the scales are derived from, one per row (Fig. 5-2). Metadata for each scale are provided as well (see Table 6 for column descriptions). The list can be filtered by entering an expedition number.

To get a list of affine tables report (Fig. 5-2):

• In the Select report panel, expand the Stratigraphic Correlation list and select List of affine tables report.
• In the Hierarchy Search area, filter by Expedition(s), if so desired.
• View data on screen using the View data button.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-2: List of affine tables report.

Table 5-1. Description of List of affine tables report columns.

Affine tables report

This report provides the full affine table information, one core per row (Fig. 5-3; see Table 5-2 for descriptions of columns). Sample identity information (i.e., hole and core) and the cumulative offset for each core resulting from depth shifting, are derived directly from user-uploaded files. However, the CSF-A and CCSF depths as well as differential offset and growth rate are computed in LIMS, based on latest sample registry data for hole and core. The original, unaltered affine table user file can also be downloaded.

To get an affine table report (Fig. 5-3):

• In the Select report panel, expand Stratigraphic Correlation list and select Affine Tables report.
• In the Additional Filters area, use the Alternate depth scale choice list to select the scale corresponding to the appropriate affine.
  • You can reduce the choice list by selecting an expedition from the Expedition(s) filter in the Hierarchy Search area.
• View data on screen using the View data button.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-3: Affine table report.

Table 5-2. Description of Affine tables report columns.

List of splice interval tables report

This report lists the splice interval tables available in LIMS, one per row, including metadata and links generated by the LIMS or added by the user at the time of file upload (Fig. 5-4; see Table 5-3 for description of columns). The list can be filtered by entering an expedition number.

To get a list of splice interval tables report (Fig. 5-4):

• In the Select report panel, expand Stratigraphic Correlation list and select List of Splice Interval Tables report.
• In the Hierarchy Search area, filter by Expedition(s), if so desired.
• View data on screen using the View data button.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-4: List of splice interval tables report.

Table 5-3. Description of List of splice interval tables report columns.

Splice interval tables report

This report provides the full splice interval table information, one interval per row (Fig. 5-5; see Table 5-4 for descriptions of columns). Sample identity information (i.e., hole, core, section, offset) is derived directly from user-uploaded files. However, the CSF-A and CCSF depths are computed in LIMS, based on latest sample registry data for hole and core. The original, unaltered splice interval table user file can also be downloaded.

To get an affine table report (Fig. 5-5):

• In the Select report panel, expand Stratigraphic Correlation list and select Splice table report.
• In the Splice Search area, use the choice list to select the appropriate splice.
  • You can reduce the choice list by selecting an expedition from the Expedition(s) filter in the Hierarchy Search area.
• View data on screen using the View data button.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-5: Splice table report.

Table 5-4. Description of Splice interval tables report columns.

5.2. Alternate depths

This report feature provides CCSF alternate depth for any sample and data point in any data report that uses depth (CSF-A) as the primary independent variable. User must select the appropriate alternate scale for a report.

To retrieve CCSF depths with data (Fig. 5-6):

• In the Select report area, select desired data type by expanding the category of interest.
• In the Hierarchy Search area, filter Expedition(s), Site(s), Hole(s), Core(s), etc., as needed.
• In the Additional Filters area, select the appropriate Alternate depth scale from the choice list.
• View data on screen using the View data button. The alternate depths will be shown in the column nest to the CSF-A depths.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-6. Data report example with alternate depths shown in column #10.

5.3. Data by splice

One of the major goals of stratigraphic correlation is to generate “spliced data”, or to retrieve “data by splice”. To get data by splice (Fig. 5-7):

• In the Select report area, select desired data type by expanding the category of interest.
• In the Splice Search area, select the appropriate splice from choice list.
• You can filter the splice list by selecting an expedition in the Hierarchy Search area.
• View data on screen using the View data button. The alternate depths will be shown in the column nest to the CSF-A depths.
• Option: download data in CSV format using the Download tabular data button.

Figure 5-7. Data set extracted for user-selected splice.

Appendix 1: Specifications for affine tables

The affine table exported from Correlator has the 15 columns described in the table below. In order to take advantage of the features offered from within the LIMS database, affine tables exported from Correlator or any other correlation programs must meet import requirements of the SCORS Uploader and Manager application. As a minimum requirement, the first 7 columns must be present.

Appendix 2: Specifications for splice interval tables

The splice table exported from Correlator has the 15 columns described in the table below. In order to take advantage of the features offered from within the LIMS database, splice tables exported from Correlator or any other correlation programs must meet import requirements of the SCORS Uploader and Manager application.