18 Input Files
The following files, produced as part of the QA Package and Mother-Infant Linkage QA Package, are required inputfiles for Sentinel Common Components and should be included in inputfiles/dp_metadata:
18.1 all_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: all_l1_cont
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | LABEL | FORMAT | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: qa package master file Derivation: %upcase(&DPID) |
|||
| TABID | 3 character abbreviation for source SCDM table | Char (3) |
Source: inputfiles.control_flow.module Derivation: Where execute_flag=Y and cc_table ne X |
|||
| LIBNAME | Library Name | Char (8) | Library Name |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| MEMNAME | Library Member Name | Char (32) | Library Member Name |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| MEMLABEL | Data Set Label | Char (256) | Data Set Label |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| TYPEMEM | Special Data Set Type (From TYPE=) | Char (8) | Special Data Set Type (From TYPE=) |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| NAME | Variable Name | Char (32) | Variable Name |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| TYPE | Variable Type | Num (8) | Variable Type |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| LENGTH | Variable Length | Num (8) | Variable Length |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| VARNUM | Variable Number | Num (8) | Variable Number |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| LABEL | Variable Label | Char (256) | Variable Label |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| FORMAT | Variable Format | Char (32) | Variable Format |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| FORMATL | Format Length | Num (8) | Format Length |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| FORMATD | Number of Format Decimals | Num (8) | Number of Format Decimals |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| INFORMAT | Variable Informat | Char (32) | Variable Informat |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| INFORML | Informat Length | Num (8) | Informat Length |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| INFORMD | Number of Informat Decimals | Num (8) | Number of Informat Decimals |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| JUST | Justification | Num (8) | Justification |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| NPOS | Position in Buffer | Num (8) | Position in Buffer |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| NOBS | Observations in Data Set | Num (8) | Observations in Data Set |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| ENGINE | Engine Name | Char (8) | Engine Name |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| CRDATE | Create Date | Num (8) | Create Date | DATETIME16. |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
|
| MODATE | Last Modified Date | Num (8) | Last Modified Date | DATETIME16. |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
|
| DELOBS | Deleted Observations in Data Set | Num (8) | Deleted Observations in Data Set |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| IDXUSAGE | Use of Variable in Indexes | Char (9) | Use of Variable in Indexes |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| MEMTYPE | Library Member Type | Char (8) | Library Member Type |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| IDXCOUNT | Number of Indexes for Data Set | Num (8) | Number of Indexes for Data Set |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| PROTECT | Password Protection (Read Write Alter) | Char (3) | Password Protection (Read Write Alter) |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| FLAGS | Update Flags (Protect Contribute Add) | Char (3) | Update Flags (Protect Contribute Add) |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| COMPRESS | Compression Routine | Char (8) | Compression Routine |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| REUSE | Reuse Space | Char (3) | Reuse Space |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| SORTED | Sorted and/or Validated | Num (8) | Sorted and/or Validated |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| SORTEDBY | Position of Variable in Sortedby Clause | Num (8) | Position of Variable in Sortedby Clause |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| CHARSET | Host Character Set | Char (8) | Host Character Set |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| COLLATE | Collating Sequence | Char (8) | Collating Sequence |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| NODUPKEY | Sort Option: No Duplicate Keys | Char (3) | Sort Option: No Duplicate Keys |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| NODUPREC | Sort Option: No Duplicate Records | Char (3) | Sort Option: No Duplicate Records |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| ENCRYPT | Encryption Routine | Char (8) | Encryption Routine |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| POINTOBS | Point to Observations | Char (3) | Point to Observations |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| GENMAX | Maximum Number of Generations | Num (8) | Maximum Number of Generations |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| GENNUM | Generation Number | Num (8) | Generation Number |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| GENNEXT | Next Generation Number | Num (8) | Next Generation Number |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| TRANSCOD | Character Variables Transcoded | Char (3) | Character Variables Transcoded |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| filesize | Size of File | Num (8) | Size of File |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| obslen | Observation Length | Num (8) | Observation Length |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| nvar | Number of Variables | Num (8) | Number of Variables |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| npage | Number of Pages | Num (8) | Number of Pages |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
||
| pcompress | Percent Compression | Num (8) | Percent Compression |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables |
18.2 etl_version
This metadata file contains the number of the ETL under review.
Specification: etl_version
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | LABEL | FORMAT | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: qa package master file Derivation: %upcase(&DPID) |
|||
| ETL | ETL number | Num (8) |
Source: qa package master file Derivation: &ETL |
18.3 minmax_dates
This metadata file contains derived minimum and maximum dates for data completeness.
Specification: minmax_dates
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: qa package master file Derivation: %upcase(&DPID) |
|||
| DP_MinDate | Overall DP Minimum Date for Data Completeness | Num (8) | YYMMDD10. | Overall DP Minimum Date for Data Completeness |
Source: DIA|DIS|ENC|ENR|PRO .mindate Derivation: Maximum mindate |
|
| DP_MaxDate | Overall DP Maximum Date for Data Completeness | Num (8) | YYMMDD10. | Overall DP Maximum Date for Data Completeness |
Source: DIA|DIS|ENC|ENR|PRO .maxdate Derivation: Minimum maxdate |
|
| DIA_MinDate | Diagnosis table Minimum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: DIA.adate Derivation: See functional specs |
||
| DIS_MinDate | Dispensing table Minimum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: DIS.rxdate Derivation: See functional specs |
||
| ENC_MinDate | Encounter table Minimum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: ENC.adate Derivation: See functional specs |
||
| ENR_MinDate | Enrollment table Minimum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: ENR.enr_start Derivation: See functional specs |
||
| PRO_MinDate | Procedure table Minimum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: PRO.adate Derivation: See functional specs |
||
| DIA_MaxDate | Diagnosis table Maximum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: DIA.adate Derivation: See functional specs |
||
| DIS_MaxDate | Dispensing table Maximum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: DIS.rxdate Derivation: See functional specs |
||
| ENC_MaxDate | Encounter table Maximum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: ENC.adate Derivation: See functional specs |
||
| ENR_MaxDate | Enrollment table Maximum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: ENR.enr_start Derivation: See functional specs |
||
| PRO_MaxDate | Procedure table Maximum Date for Data Completeness | Num (8) | YYMMDD10. |
Source: PRO.adate Derivation: See functional specs |
18.4 qa_cc_metadata
This metadata file contains DP-specific information about ETL number, phase, and SCDM table names.
Specification: qa_cc_metadata
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | LABEL | FORMAT | NOTES | VALUES |
|---|---|---|---|---|---|---|
| Variable | A list of macro variable names | Char (32) |
Source: inputfiles.00.1_scdm_standard _macros|sasprograms.00.0 _scdm_data_qa_review_master _file Derivation: See functional specs |
|||
| Value | Source data for macro variable values | Char (255) |
Source: inputfiles.00.1_scdm_standard _macros|sasprograms.00.0 _scdm_data_qa_review_master _file Derivation: See functional specs |