13 Input Files
A set of lookup tables is included in the inputfiles sub-directories of the QA MIL Program Package to allow for easy modifications of value sets and error codes.
| Dataset | Description |
|---|---|
| control_flow | This table is used by the control flow module to selectively and sequentially execute QA MIL Package modules. It is also used in the L1 and L2 modules to selectively execute data checks by SCDM table. This table contains one row per integrated module. |
| lkp_all_flags | This SAS output table provides a list of SOC-assigned error codes (FlagID) and descriptions (Flag_Descr), and the name of the output dataset used to evaluate checks associated with the error code. |
| lkp_all_l1 | output table provides information on all variable attributes by SCDM table in order to perform Level 1 model compliance checks. For each variable in the table, the variable identifier, required type (numeric or character), and required length are specified. An indicator of whether a variable is allowed to have a missing/blank value is also included, as well as a list of all allowable variable values (as applicable). |
13.1 control_flow
This table is used by the control flow module to selectively and sequentially execute QA MIL Package modules. It is also used in the L1 and L2 modules to selectively execute data checks by SCDM table. This table contains one row per integrated module.
Specification: control_flow
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES | EXAMPLE |
|---|---|---|---|---|---|---|---|
| module | Abbreviated name of the module to be executed. | char (5) | $5 | Lowercase 2–5 character module abbreviation | enr | ||
| execute_flag | Indicates whether the specific module will be executed. | char (1) | $1 |
Y = Yes. The module will be executed. N = No. The module will not be executed. |
Y | ||
| sascode |
Full name of the SAS program module. Case sensitive and should contain no spaces or special characters except ., _, or -.
|
char (45) | $45 | 02.1_scdm_data_qa_review-level1 | |||
| cc_table | Common Components (CC) macro variable used by all modules, including the QA MIL Package master program. Used to provide DP and ETL-specific SCDM table names to the QA MIL Package. | char (12) | $12 | PROCTABLE | |||
| seqno | Indicates sequence of module execution | char (NA) | BEST12. | 1 | |||
| module_cat | Indicates module category | char (10) | $10. |
Core = Core Table QA modules Clinical = Clinical Table QA modules Dates = Dates module Level1 = Level 1 Module Level2 = Level 2 Module Level3 = Level 3 Module |
Level2 | ||
| module_util | Utilization table indicator. This variable is no longer used by the QA MIL Package functionality, but indicates which tables are broken out from all Encounter claims by the DP (e.g. Encounter, Diagnosis, or Procedure). | char (1) | $1 |
Y = Yes. The table is a utilization table. N = No. The table is not a utilization table. |
N |
13.2 lkp_all_flags
This SAS output table provides a list of SOC-assigned error codes (FlagID) and descriptions (Flag_Descr), and the name of the output dataset used to evaluate checks associated with the error code.
Specification: lkp_all_flags
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES | EXAMPLE |
|---|---|---|---|---|---|---|---|
| FlagID | A unique error code representing an individual data check. | char (21) | $21 | {TableID}{Level}{VarID}{TestID}{CheckID} | ENR-LAB_2_01_05-N_201 | ||
| FlagType | Indicator for implication of the data check for passing or failing an ETL under review. | char (4) | $4 |
Fail = The ETL cannot pass QA review until fixed. Warn = The ETL may be able pass QA review, pending Quality Assurance Analyst Review. Note = This flag is for characterization or reference purposes. It does not generally affect the ability of the ETL to pass QA review. |
Warn | ||
| AbortYN |
Indicator for implication of the data check for the QA MIL Package. AbortYN = Y is used to indicate checks that must pass in order to complete the QA module successfully.
|
char (1) | $1 |
Y = Yes. The QA MIL Package will abort if this flag is present. N = No. The QA MIL Package will not abort if this flag is present. |
N | ||
| TableID | Token indicating the SCDM table or tables associated with the data check. | char (7) | $7 | ENR-LAB | |||
| Level | FlagID token indicating Level of data check. See Quality Checks for details on the levels of checks. | char (1) | $1 |
1 = Level 1 2 = Level 2 3 = Level 3 |
2 | ||
| VarID | Token indicating DMQA-assigned variable identifier representing the primary SCDM variable associated with the check. | char (2) | $2 |
## = Two-digit number representing the variable number in the SCDM table. 00 = 00 represents table-level check that is not associated with a specific variable. |
01 | ||
| TestID | Token indicating Laboratory test identifier associated with the test. | char (4) | $4 |
##-N = Token indicating a labratory test with a quantitative result. ##-C = Token indicating a labratory test with a qualitative result. 00-0 = Token indicating a check that is not associated with a specific laboratory test. |
05-N | ||
| CheckID | Token indicating unique data check identifier. | char (3) | $3 | ### = Three-digit number representing the check number. | 201 | ||
| Variable1 | Primary variable being checked. | char (21) | $21 |
SCDM variable name as it appears in the model NA = Not Applicable |
PatID | ||
| Variable2 | Second variable being checked. | char (21) | $21 |
SCDM variable name as it appears in the model NA = Not Applicable |
NA | ||
| Variable3 | Third variable being checked. | char (21) | $21 |
SCDM variable name as it appears in the model NA = Not Applicable |
NA | ||
| Variable4 | Fourth variable being checked. | char (21) | $21 |
SCDM variable name as it appears in the model NA = Not Applicable |
NA | ||
| MS_Test_Name | SCDM Lab table test name as it appears in the model. | char (20) | $20 |
Labratory test name NA = Not Applicable |
ALP | ||
| Result_type | Laboratory test result type indicator. | char (1) | $1 |
N = Numeric. Quantitative or semi-quantitative test results. C = Character. Qualitative test results. |
N | ||
| Flag_Descr | Description of the data check. | char (255) | $255 | Free text description of the data check. | Enr_Start variable does not exist. | ||
| Dataset | Indicates the QA MIL Package output dataset used programmatically as the base of the check. This may be deleted when no longer needed for processing. | char (50) | $50 |
Dataset name NA = Not Applicable |
dplocal.l1_scdm_comp_enr | ||
| Lookup_Table | Indicates the name of the lookup table required for the check. | char (20) | $20 |
Lookup table name NA = Not Applicable |
lkp_all_l1 | ||
| FlagYN | Indicates whether the data check is automatically executed by QA MIL Package or not. Most Level 1 and Level 2 checks will have FlagYN=Y. | char (1) | $1 |
Y = Yes N = No |
Y |
13.3 lkp_all_l1
output table provides information on all variable attributes by SCDM table in order to perform Level 1 model compliance checks. For each variable in the table, the variable identifier, required type (numeric or character), and required length are specified. An indicator of whether a variable is allowed to have a missing/blank value is also included, as well as a list of all allowable variable values (as applicable).
Specification: lkp_all_l1
| VARIABLE | DESCRIPTION | VARIABLE TYPE (LENGTH) | FORMAT | LABEL | NOTES | VALUES | EXAMPLE |
|---|---|---|---|---|---|---|---|
| SCDMID | SCDM Table Numeric Identifier | num (8) | Numeric Identifier = | 1 | |||
| TabID | SCDM table abbreviation | char (3) | $3 | SCDM table abbreviation | DEM | ||
| VarID | Unique variable identifier | char (2) | $2 | ## | 04 | ||
| Variable | Variable name | char (21) | $21 | Variable name | Hispanic | ||
| VarType | Variable type | char (1) | $1 |
C = Character N = Numeric |
C | ||
| VarLength | Variable length | num (8) | BEST12. | Range of 1–255 | 1 | ||
| SortOrder | Order in which variable should be sorted in the SCDM table. | num (8) | Ordinal number | 1 | |||
| KeyVar | Unique key variable as defined in the SCDM for a given table. Leave as null if not applicable. | char (1) | $1 | K = Is key variable | K | ||
| CrossVar | Indicates whether a variable exists across SCDM tables. Leave as null if not applicable. | char (1) | $1 | X = Is cross variable | X | ||
| ObsReq | Indicates whether all records for a variable are required to be populated, only some, or none. | char (4) | $4 |
ALL = All records required SOME = Some records required NONE = No records required |
ALL | ||
| ValidValueType | Indicates the type of values required for a variable, such as a finite list, numeric range of values, up-cased values, etc. | char (15) | $15 |
find_values list_values num_range numeric only value_case |
list_values | ||
| ValidValue | Indicates valid values for a variable. | char (350) | $350 | ValidValue | SCDM valid values as they appear in the model | N|U|Y | |
| FlagCondition | Indicates what condition will cause a flag to fail | char (425) | $425 | Free text. | Hispanic not in (‘N’,‘U’,‘Y’) |