14 Output Datasets
Only aggregate tables based on the MIL table are returned SOC for review based on abort status and module flow. All patient-level results will remain with the Data Partner. Aggregate results based on the MIL table will be saved to the dplocal folder and moved to the msoc folder to be shared with SOC for review if the process does not abort during level 1 or 2 checks.
Log, metadata, and signature files will be saved to the msoc folder and provided to the SOC regardless of whether the process aborts during the above steps.
14.1 MSOC Folder
Table 14.1 describes the MIL QA Program Package output datasets found in the msoc directory. These datasets are returned to SOC. Subsection 14.1.16 describes the SCDM Snapshot output.
| Dataset | TabID | Level | Description |
|---|---|---|---|
| all_l1_l2_flags | ALL | This dataset contains one record per unique FlagID for Level 1 or Level 2 non-passing data checks and associated frequency. | |
| all_l1_nobs | ALL | L1 | |
| all_l1_record_count | ALL | L1 | This dataset contains one record per SCDM table variable and includes the count of non-missing, missing, special missing, and null values. |
| all_l1_scdm_comp | ALL | L1 | This dataset contains a comparison of expected SCDM versus actual observed variable attributes by table. |
| all_l3_flags | ALL | L3 | This dataset contains one record per unique FlagID for Level 3 data checks and associated frequency. |
| data_characteristics_sign_off_report_dpid_etlnum | ALL | ALL |
This dataset is a duplicate of the all_l1_l2_flags dataset output as an .xlsx file with additional fields providing context regarding any flags found in that file. dpid will be replaced with the Data Partner callsign and num will be replaced with the appropriate ETL number—e.g., data_characteristics_sign_off_report_nsdp_etl21.
|
| etl_version | ETL | This metadata file contains the number of the ETL under review. | |
| level_signature_mil | LEV |
This metadata file contains module-level metadata and basic benchmarking statistics after each module has completed. level will be replaced with the appropriate module name—e.g., l1_signature, l2_signature.
|
|
| l3_mil_aggregate | MIL | L3 |
This table contains counts of linked and unlinked MIL records where MPatID and CPatID are present, stratified by MatchMethod, DaysDiff, sex, EncType, AgeGroup, ICD_Ver, YearMonth, Year, Birth_Type, and LinkageStatus.
|
| l3_mil_aggregate_deliv | MIL | L3 |
This table contains counts of linked and unlinked deliveries, stratified by InfantsLinked, EncType, AgeGroup, ICD_Ver, YearMonth, Year, Birth_Type, and LinkageStatus.
|
| mil_l1_cont | MIL | L1 | This dataset contains resulting output from SAS proc contents for the MIL Table, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output. |
| mil_l2_cenrstart_agedays_cat | MIL | L2 | This dataset returns the distance between cbirth_date and cenr_start, stratified by birth year. |
| l1_scdm_comp | L1 | ||
| licensed | This metadata file contains DP-specific SAS component license status. | ||
| qa_cc_metadata | This metadata file contains DP-specific information about ETL number, phase, and SCDM table names. |
14.1.1 all_l1_l2_flags
This dataset contains one record per unique FlagID for Level 1 or Level 2 non-passing data checks and associated frequency.
Specification: all_l1_l2_flags
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| FlagID | Tokenized data quality flag indicator | Char (21) | Source: Inputfiles.lkp_all_flags | |||
| AbortYN | Indicates whether flag causes QA process to abort | Char (1) | Source: Inputfiles.lkp_all_flags | |||
| FlagType | Indicates if this flag is considered a Warn or a Fail | Char (4) | Source: Inputfiles.lkp_all_flags | |||
| Flag_Descr | Description of FlagID | Char (255) | Source: Inputfiles.lkp_all_flags | |||
| count | Count of flagged observations in data set | Num (8) |
14.1.2 all_l1_nobs
NA
Specification: all_l1_nobs
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| 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 |
|||
| MemType | Library Member Type | Char (8) |
Source: SCDM table metadata Derivation: “SAS proc contents procedure |
|||
| Count_Obs | Observations in Data Set | Num (8) |
Source: SCDM table metadata Derivation: SAS proc contents procedure |
14.1.3 all_l1_record_count
This dataset contains one record per SCDM table variable and includes the count of non-missing, missing, special missing, and null values.
Specification: all_l1_record_count
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC and populated |
|||
| 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 |
|||
| VarID | 2 character variable identifier | 2 (2) | Source: Input file | |||
| Variable | Variable name | Char (21) | Source: SCDM table | |||
| Count_obs | Count of all records | Num (8) | COMMA13. | Source: SCDM table | ||
| Count_nomiss | Count of populated records | Num (8) | COMMA13. | Source: SCDM table | ||
| Count_spmiss | Count of records populated with SAS special missing values | Source: SCDM table | ||||
| Count_null | Count of null records | Source: SCDM table |
14.1.4 all_l1_scdm_comp
This dataset contains a comparison of expected SCDM versus actual observed variable attributes by table.
Specification: all_l1_scdm_comp
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| TabID | 3 character abbreviation for source SCDM table | Char (3) |
Source: Inputfiles.lkp_all_l1 Derivation: Assigned by the SOC |
|||
| Var | Variable Name | Char (32) | Source: Inputfiles.lkp_all_l1 | |||
| VarID | 2 character variable identifier | Char (2) | Source: Inputfiles.lkp_all_l1 | |||
| MS_var | Expected variable exists | Char (1) | Source: Inputfiles.lkp_all_l1 | |||
| DP_var | Actual variable exists | Char (1) |
Source: SCDM Table metadata Derivation: SAS Proc Contents |
|||
| MS_type | Expected variable type | Char (1) | Source: Inputfiles.lkp_all_l1 | |||
| DP_type | Actual variable exists | Char (1) |
Source: SCDM Table metadata Derivation: SAS Proc Contents |
|||
| MS_length | Expected variable length | Num (3) | Source: Inputfiles.lkp_all_l1 | |||
| DP_length | Actual variable length | Num (3) |
Source: SCDM Table metadata Derivation: SAS Proc Contents |
14.1.5 all_l3_flags
This dataset contains one record per unique FlagID for Level 3 data checks and associated frequency.
Specification: all_l3_flags
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3–6 character Data Partner identifier. | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| FlagID | Flag identifier | Char (21) | $21. | |||
| AbortYN | Indicates QA MIL Package abort status (Y or N) for each FlagID | Char (1) | $1. | |||
| FlagType | Flag type | Char (4) | $4. | |||
| Flag_Descr | Flag description | Char (255) | $255. | |||
| Count | Count of errors | Num (8) | comma12. |
14.1.6 data_characteristics_sign_off_report_dpid_etlnum
This dataset is a duplicate of the all_l1_l2_flags dataset output as an .xlsx file with additional fields providing context regarding any flags found in that file. dpid will be replaced with the Data Partner callsign and num will be replaced with the appropriate ETL number—e.g., data_characteristics_sign_off_report_nsdp_etl21.
Specification: data_characteristics_sign_off_report_dpid_etlnum
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: all_l1_l2_flags Derivation: %upcase(&DPID) |
|||
| FlagID | Flag ID used by SOC to identify specific error checks across all SCDM tables | Char (21) | Source: all_l1_l2_flags & all_l3_flags | Unique FlagID = See Quality Checks | ||
| AbortYN | Indicates QA package abort status (Y or N) for each FlagID | Char (1) | Source: all_l1_l2_flags & all_l3_flags | |||
| FlagType | FlagType | Char (4) | Source: all_l1_l2_flags | |||
| Flag_Descr | Description of flag | Char (255) | Source: all_l1_l2_flags & all_l3_flags | |||
| count_ETL-1 | Count of flagged records from the previous ETL | Num (8) | COMMA15. |
Source: inputfiles.all_l1_l2_flags & inputfiles.all_l3_flags Derivation: Flag count may be record or PatID count. For cases where count is not applicable, use value ‘99999’ |
||
| count_ETL | Count of flagged records from this package run | Num (8) | COMMA15. |
Source: msoc.all_l1_l2_flags & msoc.all_l3_flags Derivation: Flag count may be record or PatID count. For cases where count is not applicable, use value ‘99999’ |
||
| count_delta | Difference in the count of flagged records between the current and previous ETL | Num (8) | COMMA15. | |||
| Sign-Off | Field used by Sentinel Data Partners to indicate that the Data Partner has reviewed each flag | Char (8) | $8 | |||
| Comment | Free-text column for Data Partner to include any information related to the flag that would communicate more knowledge to SOC—e.g., Data Partner added a new stream of data | Char (100) | $100 |
14.1.7 etl_version
This metadata file contains the number of the ETL under review.
Specification: etl_version
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| ETL | ETL number from Common Components | Num (8) |
Source: Common Components macro variable ETL Derivation: Assigned by the SOC |
14.1.8 level_signature_mil
This metadata file contains module-level metadata and basic benchmarking statistics after each module has completed. level will be replaced with the appropriate module name—e.g., l1_signature, l2_signature.
14.1.9 l3_mil_aggregate
This table contains counts of linked and unlinked MIL records where MPatID and CPatID are present, stratified by MatchMethod, DaysDiff, sex, EncType, AgeGroup, ICD_Ver, YearMonth, Year, Birth_Type, and LinkageStatus.
Specification: l3_mil_aggregate
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | Char (6) | 3–6 character Data Partner identifier. | ||||
| Level | Char (4) |
000 = No stratification 001+ = Various levels of combinations of stratification variables |
||||
| Level_desc | Char (200) |
Overall LinkageStatus LinkageStatus*Birth_Type |
||||
| LinkageStatus | Char (1) |
M = Mother/delivery not linked to infant (Filled MPatID and null CPatID) C = Infant not linked to mother (Filled CPatID and null MPatID) L = Linked mother/delivery to infant (Filled MPatID and filled CPatID) |
||||
| Birth_Type | Based upon ICD-9-CM/ICD-10-CM codes in the health plan data for the delivery admission. Will be 0 for non-specific codes | Num (8) |
|
0 = Unspecified # of live births 1 = 1 live birth 2 = 2 live births 3 = 3 live births 4 = 4 live births 5 = 5 live births 8 = Multiple live births, unspecified number 9 = Conflicting code(s) for number of live births |
||
| Year | Char (4) | 20YY | ||||
| YearMonth | Char (7) | 20YY-## | ||||
| ICD_Ver | Char (1) |
9 = ICD9 0 = ICD10 |
||||
| AgeGroup | Char (9) |
10–19 20–44 45–54 Other Infants |
||||
| EncType | Char (2) |
IP = Inpatient ED = Emergency Department AV = Ambulatory Visit IS = Institutional Stay OA = Other Ambulatory |
||||
| Sex | Char (1) |
F = Female M = Male O = Other or Unknown |
||||
| Daysdiff | Char (25) |
< -30 days -11 through -30 days -4 through -10 days -1 through -3 days 0 days 1 through 3 days 4 through 10 days 11 through 30 days 30 days NA |
||||
| MatchMethod | Char (2) |
BC = Birth Certificate RE = DP maintained birth registry SI = health plan subscriber or family number LA = exact or probabilistic last name and address match based upon health plan administrative data N1 = No subscriber/family IDs available for linkage N2 = No name/address available for linkage N3 = Neither subscriber/family IDs nor name/address available for linkage OT = other NA = no linkage made |
||||
| Count | Num (8) | 1+ |
14.1.10 l3_mil_aggregate_deliv
This table contains counts of linked and unlinked deliveries, stratified by InfantsLinked, EncType, AgeGroup, ICD_Ver, YearMonth, Year, Birth_Type, and LinkageStatus.
Specification: l3_mil_aggregate_deliv
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | Char (6) | $6. | 3–6 character Data Partner identifier | |||
| Level | Char (4) | $4. |
000 = No stratification 001+ = Various levels of combinations of stratification variables |
|||
| Level_desc | Char (200) | $200. |
Overall LinkageStatus LinkageStatus*Birth_Type |
|||
| LinkageStatus | Char (1) | $1. |
M = Mother/delivery not linked to infant (Filled MPatID and null CPatID) L = Linked mother/delivery to infant(s) |
|||
| Birth_Type | Based upon ICD-9-CM/ICD-10-CM codes in the health plan data for the delivery admission. Will be 0 for non-specific codes | Num (8) |
|
0 = Unspecified # of live births 1 = 1 live birth 2 = 2 live births 3 = 3 live births 4 = 4 live births 5 = 5 live births 8 = Multiple live births, unspecified number 9 = Conflicting code(s) for number of live births |
||
| Year | Char (4) | $4. | 20YY | |||
| YearMonth | Char (7) | $7. | 20YY-##, where ##= 01–12 and dash is delimiter between values for year and month | |||
| ICD_Ver | Char (1) | $1. |
9 = ICD9 0 = ICD10 |
|||
| AgeGroup | Char (9) | $9. |
10–19 20–44 45–54 Other Infants |
|||
| EncType | Char (2) | $2. |
IP ED AV IS OA |
|||
| InfantsLinked | Num (3) |
|
0+ | |||
| Count | Num (8) | comma15. | 1+ |
14.1.11 mil_l1_cont
This dataset contains resulting output from SAS proc contents for the MIL Table, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output.
Specification: mil_l1_cont
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| 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) |
Source: SCDM table metadata Derivation: SAS proc contents procedure performed on MIL or MIS tables – Applies to all variables except for the last one documented |
|||
| MEMNAME | Library Member Name | Char (32) | Source: SCDM table metadata | |||
| MEMLABEL | Data Set Label | Char (256) | Source: SCDM table metadata | |||
| TYPEMEM | Special Data Set Type (From TYPE=) | Char (8) | Source: SCDM table metadata | |||
| NAME | Variable Name | Char (32) | Source: SCDM table metadata | |||
| TYPE | Variable Type | Num (8) | Source: SCDM table metadata | |||
| LENGTH | Variable Length | Num (8) | Source: SCDM table metadata | |||
| VARNUM | Variable Number | Num (8) | Source: SCDM table metadata | |||
| LABEL | Variable Label | Char (256) | Source: SCDM table metadata | |||
| FORMAT | Variable Format | Char (32) | Source: SCDM table metadata | |||
| FORMATL | Format Length | Num (8) | Source: SCDM table metadata | |||
| FORMATD | Number of Format Decimals | Num (8) | Source: SCDM table metadata | |||
| INFORMAT | Variable Informat | Char (32) | Source: SCDM table metadata | |||
| INFORML | Informat Length | Num (8) | Source: SCDM table metadata | |||
| INFORMD | Number of Informat Decimals | Num (8) | Source: SCDM table metadata | |||
| JUST | Justification | Num (8) | Source: SCDM table metadata | |||
| NPOS | Position in Buffer | Num (8) | Source: SCDM table metadata | |||
| NOBS | Observations in Data Set | Num (8) | Source: SCDM table metadata | |||
| ENGINE | Engine Name | Char (8) | Source: SCDM table metadata | |||
| CRDATE | Create Date | Num (8) | DATETIME16. | Source: SCDM table metadata | ||
| MODATE | Last Modified Date | Num (8) | DATETIME16. | Source: SCDM table metadata | ||
| DELOBS | Deleted Observations in Data Set | Num (8) | Source: SCDM table metadata | |||
| IDXUSAGE | Use of Variable in Indexes | Char (9) | Source: SCDM table metadata | |||
| MEMTYPE | Library Member Type | Char (8) | Source: SCDM table metadata | |||
| IDXCOUNT | Number of Indexes for Data Set | Num (8) | Source: SCDM table metadata | |||
| PROTECT | Password Protection (Read Write Alter) | Char (3) | Source: SCDM table metadata | |||
| FLAGS | Update Flags (Protect Contribute Add) | Char (3) | Source: SCDM table metadata | |||
| COMPRESS | Compression Routine | Char (8) | Source: SCDM table metadata | |||
| REUSE | Reuse Space | Char (3) | Source: SCDM table metadata | |||
| SORTED | Sorted and/or Validated | Num (8) | Source: SCDM table metadata | |||
| SORTEDBY | Position of Variable in Sortedby Clause | Num (8) | Source: SCDM table metadata | |||
| CHARSET | Host Character Set | Char (8) | Source: SCDM table metadata | |||
| COLLATE | Collating Sequence | Char (8) | Source: SCDM table metadata | |||
| NODUPKEY | Sort Option: No Duplicate Keys | Char (3) | Source: SCDM table metadata | |||
| NODUPREC | Sort Option: No Duplicate Records | Char (3) | Source: SCDM table metadata | |||
| ENCRYPT | Encryption Routine | Char (8) | Source: SCDM table metadata | |||
| POINTOBS | Point to Observations | Char (3) | Source: SCDM table metadata | |||
| GENMAX | Maximum Number of Generations | Num (8) | Source: SCDM table metadata | |||
| GENNUM | Generation Number | Num (8) | Source: SCDM table metadata | |||
| GENNEXT | Next Generation Number | Num (8) | Source: SCDM table metadata | |||
| TRANSCOD | Character Variables Transcoded | Char (3) | Source: SCDM table metadata | |||
| filesize | Size of table recorded in bytes | Num (8) | Source: SCDM table metadata | |||
| obslen | Observation length | Num (8) | Source: SCDM table metadata | |||
| nvar | Number of variables | Num (8) | Source: SCDM table metadata | |||
| npage | Number of pages | Num (8) | Source: SCDM table metadata | |||
| pcompress | Percent compression | Num (8) | Source: SCDM table metadata |
14.1.12 mil_l2_cenrstart_agedays_cat
This dataset returns the distance between cbirth_date and cenr_start, stratified by birth year.
Specification: mil_l2_cenrstart_agedays_cat
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3–6 character Data Partner identifier | Character (6) | $6 | |||
| YEAR_CBIRTH_DATE | Infant birth year | Numeric (8) | BEST12. | |||
| AGEDAYS_GRP | Categories for age in days | Character (16) | $16 |
< 0 days = Missing 0–30 days 31–60 days 61–120 days 121–180 days 181–270 days 271–365 days > 366 days |
||
| COUNT | Count of unique CPatIDs | Numeric (8) | BEST12. |
14.1.13 l1_scdm_comp
NA
Specification: l1_scdm_comp
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 6 character Data Partner identifier | Char (6) |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
|||
| 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 |
|||
| Var | Variable name | Char (32) | Variable Name |
Source: inputfiles.lkp_mi l1.variable.l1_cont_{tabid}.name Derivation: Coalesce(variable,name) |
||
| VarID | SCDM variable ID assigned by SOC | Char (2) | $2. | SCDM Variable ID | Source: inputfiles.lkp_mi_l1.varid | |
| MS_var | YN indicator for variable that is expected as per SCDM | Char (1) | Variable expected? |
Source: inputfiles.lkp_mi_l1.variable Derivation: Ms_var=‘Y’ if variable is in lookup table |
||
| DP_var | YN indicator for presence of variable in DP SCDM table | Char (1) | Variable present? | Source: msoc.mi_l1_cont | ||
| MS_type | Expected variable type | Char (1) | $1. | Expected variable type | Source: inputfiles.lkp_mi_l1.vartype | |
| DP_type | Observed variable type | Char (1) | Actual variable type |
Source: Dplocal.l1_cont_{tabid}.type Derivation: If type=1, then dp_type=‘N’, else if type=2, dp_type=’C” |
||
| MS_length | Expected variable length in bytes | Num (3) | Expected variable length | Source: inputfiles.lkp_mi_l1.varlength | ||
| DP_length | Observed length of variable in bytes | Num (3) | Actual variable length | Source: Dplocal.l1_cont_{tabid}.length |
14.1.14 licensed
This metadata file contains DP-specific SAS component license status.
Specification: licensed
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | 3-6 character Data Partner identifier | Char (6) | $6 |
Source: Common Components macro variable DP Derivation: Assigned by the SOC |
||
| COMPONENT | Char (15) | $15 | ||||
| STATUS | Char (25) | $25 |
14.1.15 qa_cc_metadata
This metadata file contains DP-specific information about ETL number, phase, and SCDM table names.
14.1.16 SCDM Snapshot MSOC Output
Table 8.137 lists the SCDM Snapshot Module output datasets produced by the SCDM Snapshot Program and output the msoc/scdm_snapshot subdirectory. These datasets are returned to SOC.
| Dataset | TabID | Description |
|---|---|---|
| mil_linkage_rates | MIL | Mother-infant linkage (MIL) stratified by mother’s age at delivery, encounter type, year, birth_type, and overall. |
14.1.16.1 mil_linkage_rates
Mother-infant linkage (MIL) stratified by mother’s age at delivery, encounter type, year, birth_type, and overall.
Specification: mil_linkage_rates
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| DP | Data Partner ID | Char (6) | $6 | |||
| Variable | Variable | Char (12) | $12 |
agegroup enctype year birth_type overall |
||
| Value | Variable-dependent | Char (50) | $40 | |||
| Deliveries | Delivery Count | Num (8) | Comma18. | Any positive integer | ||
| InfantsLinked | Linked Infant Count | Num (8) | Comma18. | Any positive integer | ||
| LinkageRate | Linkage Rate | Num (8) | Percent6.2 | Any positive integer |
14.2 DPLOCAL Folder
Table 14.12 describes the MIL QA Program Package output datasets found in the dplocal directory. These datasets stay with the Data Partner are not returned to SOC.
| Dataset | TabID | Level | Description |
|---|---|---|---|
| all_l1_flags_mstr | ALL | L1 | This dataset contains one record per unique FlagID for Level 1 data checks and associated MPatID and CPatID frequency. |
| all_l3_flags_mstr | ALL | L3 | This dataset contains one record per unique FlagID for Level 3 data checks and associated frequency. |
| l2_mstr | ALL | L2 | This dataset contains one record per unique FlagID for Level 2 data checks and associated frequency. |
| MIL_IDFileStatus_CPatid | MIL | L2 | This table will include data related to across table checks for all records. |
| MIL_IDFileStatus_MPatid | MIL | L2 | This table will include data related to across table checks for all records. |
14.2.1 all_l1_flags_mstr
This dataset contains one record per unique FlagID for Level 1 data checks and associated MPatID and CPatID frequency.
Specification: all_l1_flags_mstr
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| FLAGID | Flag identifier | |||||
| Format: SAS Character $21 | ||||||
| FLAG_DESCR | Flag description | |||||
| Format: SAS Character $255 | ||||||
| FLAGTYPE | Flag type | |||||
| Format: SAS Character $4 | ||||||
| ABORTYN | Indicates QA MIL Package abort status (Y or N) for each FlagID | |||||
| Format: SAS Character $1 | ||||||
| VARIABLE1 | Variable name | |||||
| Format: SAS Character $32 | ||||||
| VALUE | Observed value | |||||
| Format: SAS Character $20 | ||||||
| MPATID | Mother’s PatID | |||||
| Format: SAS Numeric | ||||||
| CPATID | Child’s PatID | |||||
| Format: SAS Numeric |
14.2.2 all_l3_flags_mstr
This dataset contains one record per unique FlagID for Level 3 data checks and associated frequency.
Specification: all_l3_flags_mstr
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| FlagID | Flag identifier | Char (21) | $21. | |||
| Message | Error message | Char (300) | $300. | |||
| Flag_Descr | Flag description | Char (255) | $255. | |||
| FlagType | Flag type | Char (4) | $4. | |||
| AbortYN | Indicates whether a flag will cause the Quality Assurance Package to abort, if thrown. | Char (1) | $1. |
Y = Flag will cause QA MIL Package to abort N = Flag will not cause QA MIL Package to abort |
||
| count | Count of flagged records | Num (8) | COMMA18. |
14.2.3 l2_mstr
This dataset contains one record per unique FlagID for Level 2 data checks and associated frequency.
Specification: l2_mstr
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| FlagID | Flag identifier | Char (21) | $21. | |||
| Message | Error message | Char (300) | $300. | |||
| Flag_Descr | Flag description | Char (255) | $255. | |||
| FlagType | Flag type | Char (4) | $4. | |||
| AbortYN | Indicates whether a flag will cause the Quality Assurance Package to abort, if thrown. | Char (1) | $1. |
Y = Flag will cause QA MIL Package to abort N = Flag will not cause QA MIL Package to abort |
||
| count | Count of flagged records | Num (8) | COMMA18. |
14.2.4 MIL_IDFileStatus_CPatid
This table will include data related to across table checks for all records.
14.2.5 MIL_IDFileStatus_MPatid
This table will include data related to across table checks for all records.
Specification: MIL_IDFileStatus_MPatid
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES |
|---|---|---|---|---|---|---|
| MPATID | Mother patient identifier | Num (NA) | Source: M-I Linkage Table or DPLocal.Deliveries file | |||
| ENCOUNTERID | Encounter identifier | Num (NA) | Source: M-I Linkage Table or DPLocal.Deliveries file | |||
| IDFILESTATUS | ID File Status | Char (1) | $1 | Source: dplocal.deliveries|MIL |
N = MPatID from the dplocal.deliveries file is not found in MIL Table. E = MPatID from the MIL Table is not found in the dplocal.deliveries file. |