19 Output Datasets
Output dataset saved to the msoc directory will be returned to SOC. Output datasets saved to the dplocal directory will remain with the Data Partner and will be used as input for future distributed queries to be run against the Data Partner’s data.
19.1 MSOC Folder
Table 19.1 describes the Sentinel Common Components output datasets found in the msoc directory. These datasets are returned to SOC.
| Dataset | Description |
|---|---|
| cc_signature | This metadata file contains module-level metadata and basic benchmarking statistics. |
| test_cc_results |
19.1.1 cc_signature
This metadata file contains module-level metadata and basic benchmarking statistics.
19.1.2 test_cc_results
NA
Specification: test_cc_results
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| test_group | Names or types of parameters tested. | Char (30) | ||||
| grade | Test outcome | Char (5) |
PASS FAIL CHECK |
|||
| details | Description of test. | Char (100) | ||||
| results | Results of test. | Char (300) |
19.2 DPLOCAL
Table 19.4 lists the Sentinel Common Components output datasets found in the dplocal directory. These datasets are remain with the Data Partner and are not returned to SOC.
| Dataset | Description |
|---|---|
| cc_request_paths | This dataset contains paths to the directory where SOC requests will be placed prior to package execution at a Data Partner’s site or the location of a Data Partner’s SCDM data. |
| compare_table_names | This dataset contains a list of expected table names derived from Quality Assurance Package or Mother-Infant Linkage Quality Assurance Package and compares them to the actual table names for each SCDM table in the Data Partner’s Sentinel database. |
| scdm_l1_cont | This dataset contains resulting output from SAS proc contents for all SCDM tables, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output. |
19.2.1 cc_request_paths
This dataset contains paths to the directory where SOC requests will be placed prior to package execution at a Data Partner’s site or the location of a Data Partner’s SCDM data.
19.2.2 compare_table_names
This dataset contains a list of expected table names derived from Quality Assurance Package or Mother-Infant Linkage Quality Assurance Package and compares them to the actual table names for each SCDM table in the Data Partner’s Sentinel database.
Specification: compare_table_names
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| table | SCDM Table | Char (32) | ||||
| expected | Expected SCDM table name | Char (32) | Source: infolder.qa_cc_metadata | |||
| actual | Actual SCDM table name | Char (32) | Source: dplocal.scdm_l1_cont |
19.2.3 scdm_l1_cont
This dataset contains resulting output from SAS proc contents for all SCDM tables, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output.
Specification: scdm_l1_cont
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| LIBNAME | Char (8) | Library Name | ||||
| MEMNAME | Char (32) | Library Member Name | ||||
| MEMLABEL | Char (256) | Data Set Label | ||||
| TYPEMEM | Char (8) | Special Data Set Type (From TYPE=) | ||||
| NAME | Char (32) | Variable Name | ||||
| TYPE | Num (8) | Variable Type | ||||
| LENGTH | Num (8) | Variable Length | ||||
| VARNUM | Num (8) | Variable Number | ||||
| LABEL | Char (256) | Variable Label | ||||
| FORMAT | Char (32) | Variable Format | ||||
| FORMATL | Num (8) | Format Length | ||||
| FORMATD | Num (8) | Number of Format Decimals | ||||
| INFORMAT | Char (32) | Variable Informat | ||||
| INFORML | Num (8) | Informat Length | ||||
| INFORMD | Num (8) | Number of Informat Decimals | ||||
| JUST | Num (8) | Justification | ||||
| NPOS | Num (8) | Position in Buffer | ||||
| NOBS | Num (8) | Observations in Data Set | ||||
| ENGINE | Char (8) | Engine Name | ||||
| CRDATE | Num (8) | DATETIME16. | Create Date | |||
| MODATE | Num (8) | DATETIME16. | Last Modified Date | |||
| DELOBS | Num (8) | Deleted Observations in Data Set | ||||
| IDXUSAGE | Char (9) | Use of Variable in Indexes | ||||
| MEMTYPE | Char (8) | Library Member Type | ||||
| IDXCOUNT | Num (8) | Number of Indexes for Data Set | ||||
| PROTECT | Char (3) | Password Protection (Read Write Alter) | ||||
| FLAGS | Char (3) | Update Flags (Protect Contribute Add) | ||||
| COMPRESS | Char (8) | Compression Routine | ||||
| REUSE | Char (3) | Reuse Space | ||||
| SORTED | Num (8) | Sorted and/or Validated | ||||
| SORTEDBY | Num (8) | Position of Variable in Sortedby Clause | ||||
| CHARSET | Char (8) | Host Character Set | ||||
| COLLATE | Char (8) | Collating Sequence | ||||
| NODUPKEY | Char (3) | Sort Option: No Duplicate Keys | ||||
| NODUPREC | Char (3) | Sort Option: No Duplicate Records | ||||
| ENCRYPT | Char (8) | Encryption Routine | ||||
| POINTOBS | Char (3) | Point to Observations | ||||
| GENMAX | Num (8) | Maximum Number of Generations | ||||
| GENNUM | Num (8) | Generation Number | ||||
| GENNEXT | Num (8) | Next Generation Number | ||||
| TRANSCOD | Char (3) | Character Variables Transcoded |