7 Input Files

The inputfiles directory contains programs and submodules used in the execution of the QA Program Package, organized as discrete SAS macros. Table 7.1 describes the QA Program Package programs and submodules. A set of lookup tables is included in the inputfiles sub-directories of the QA Program Package to allow for easy modifications of value sets and error codes. Table 7.2 describes the lookup tables found in the inputfiles\qar sub-directory.

Table 7.1: List of QA Package Programs
Module Filename Description
scdm_data_qa_review_master_file.sas This master program requires editing by the Data Partner to identify the location of the SCDM tables in staging. It is the only program that is edited and manually executed by the Data Partner, and it must be executed in batch mode.
scdm_control_flow.sas This program module selectively and sequentially executes the QA program modules.
scdm_standard_macros.sas Contains macros used across QA program modules.
scdm_formats.sas Contains standard formats used across QA program modules.
scdm_sas_log_checker_directory_cc.sas Checks all program logs and summarizes notes, warnings, and errors in an output PDF file after all modules have completed.
scdm_qasignaturerequest.sas Creates a final signature file (msoc.alltable_signature) that summarizes metadata from individual module-level signature files.
scdm_data_qa_review-level1.sas Queries applicable SCDM tables to perform level 1 data checks and creates all l1 output datasets. The data checks included in the module check compliance with the current SCDM specifications (e.g., appropriate length, type, and format). Reference Figure 1 in Section 5
scdm_data_qa_review-level2.sas Queries applicable SCDM tables to perform all level 2 abort checks, as well as L2 cross-table checks and output datasets. Reference Figure 2 in Section 5.
scdm_data_qa_review-enrollment.sas Queries the Enrollment table, and outputs L2 and L3 datasets containing information on medical and drug coverage indicators, enrollment start, end, enrollment duration, and chart availability.
scdm_data_qa_review-demographic.sas Queries the Demographic table, and outputs L2 and L3 datasets containing information on age, sex, race, and Postal Code.
scdm_data_qa_review-dispensing.sas Queries the number of members and records in the Dispensing table, and outputs information on dispensing date, dispensings over time, dispensings per member over time, days’ supply and dispensed amount.
scdm_data_qa_review-encounter.sas Queries the number of members, records, encounters, and providers in the Encounter table, and outputs information on admission and discharge date, encounters over time, encounter type, length of stay, facility location, admitting source, discharge status and disposition, DRG and DRG type, and number of encounters per member.
scdm_data_qa_review-diagnosis.sas Queries the number of members, records, encounters, and providers in the Diagnosis table, and outputs information on encounter type, admission date, diagnosis code and type, principal diagnosis indicators, number of diagnoses per encounter, and number of diagnoses over time.
scdm_data_qa_review-procedure.sas Queries the number of members, records, encounters, and providers in the Procedure table, and outputs information on encounter type, admission date, procedure code and type, number of procedures per encounter, and number of procedures over time.
scdm_data_qa_review-death.sas This module is executed only by Data Partners who have death data available. Queries the number of members and records in the Death table, and outputs information on the source of and confidence in death information, number of deaths over time, and if the death date has been imputed.
scdm_data_qa_review-causeofdeath.sas This module is executed only by Data Partners who have cause of death data available. Queries the number of members and records in the Cause of Death table, and outputs information on cause of death codes and cause type, and source of and confidence in cause of death information.
scdm_data_qa_review-labs.sas This module is executed only by Data Partners who have laboratory result data available. This program queries the number of members and records in the Laboratory Result table and outputs information on lab tests included, result values, units, and available dates.
scdm_data_qa_review-vitalsigns.sas This module is executed only by Data Partners who have vital signs data available. This program queries the number of members and records in the Vital Signs table, and outputs information on height, weight, blood pressure, and tobacco use.
scdm_data_qa_review-inpatientpharmacy.sas This module is executed only by Data Partners who have inpatient pharmacy data available. This program queries the number of patients and records in the Inpatient Pharmacy table, and outputs information on dispensing date, dispensings per encounter, dispensings per member, dispensed route, and dispensed amount.
scdm_data_qa_review-inpatienttransfusion.sas This module is executed only by Data Partners who have inpatient transfusion data available. This program queries the number of patients and records in the Inpatient Transfusion table, and outputs information on transfusion start and end date, start and end time, transfusions per member, and transfusion blood product.
scdm_data_qa_review-prescribing.sas This module is executed only by Data Partners who have Prescribing data available. This program queries the number of patients and records in the Prescribing table, and outputs information on OrderDate, RxDaw, RxDoseForm, RxDoseQuantity, RxDoseUnit, RxFreqQuantity, RxFreqUnit, RxPrnFlag, RxRefills, RxRoute, RxSource, Rx_CodeType, RxSup, RxAmt, prescriptions over time, and prescriptions per patient over time.
scdm_data_qa_review-facility.sas This program queries facility level information.
scdm_data_qa_review-provider.sas This program queries provider level information, including Specialty_CodeType and Specialty.
scdm_data_qa_review-minmax_dates.sas Queries SCDM tables and outputs minimum and maximum dates per table (as applicable) and calculates DP Min (calculated as the maximum of the Min Dates) and DP Max (calculated as the minimum of the Max dates).
scdm_data_qa_review-level3.sas Creates Level 3 cross-table and age-related datasets from intermediate table-level datasets, and performs many housekeeping activities, such as moving specific files from dplocal to msoc, and bulk addition of DP variables to msoc datasets.
soc_setup_macros.sas This macro assists with the SAS environment setup.
Table 7.2: List of QA Package Lookup Tables
Dataset Description
control_flow This table is used by the control flow module to selectively and sequentially execute QA 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 QA package integrated module, excluding any ‘add-on’ stand-alone programs—e.g., Mother-Infant Identification.
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).
lkp_all_l2 Provides a comprehensive list of all allowable cross variable value combinations to be used for all modules (excluding LAB) Level 2 data checks.
lkp_all_minmax This SAS output table provides table-level information such as source table and variable names, as well as inclusion status in order to calculate minimum and maximum dates of data completeness.
lkp_all_saslength This SAS output table acts as a crosswalk between an assigned length for numeric SAS variables and the maximum integer value that can be stored by that length.
lkp_dem_zip This SAS output table links valid 5-digit zip codes with the associated state. SAS creates a zip file quarterly and is the source of this data.
lkp_enc_l2 This SAS output table provides a list of valid combinations of variables EncType, DDate, Discharge_Disposition, and Discharge_Status in the SCDM Encounter table.
lkp_lab_l2 This SAS output table provides a comprehensive list of all allowable combinations for the following variables in the Laboratory Result table: MS_Test_Name, Result_type (numeric or character), MS_Test_Sub_Category, Fast_ind, and Specimen_Source. To be used for Level 2 error checks.
lkp_lab_l2_nc This SAS output table provides allowable Laboratory Result table lab test result, modifier, and unit combinations. This lookup table maps the acceptable MS_Result_C values to the Modifier values and MS_Result_unit values, as appropriate. Only characterized laboratory tests are included in this lookup table.
lkp_lab_loinc This SAS output table provides allowable Laboratory Result table LOINC calues. This lookup table maps the MS_Test_Name values to the LOINC values, as appropriate.
lkp_lab_result_ranges This table provides expected Laboratory Result table lab test ranges. This lookup table defines the expected result value ranges for lab tests with numeric results in the Laboratory Result table. Only MS_Test_Name values where Result_Type=N and Characterized=Y are included in this lookup table.
lkp_lab_test This SAS output table provides a comprehensive list of all allowable combinations for the following two variables in the SCDM Laboratory Result table: MS_Test_Name (laboratory test name) and Result_type (numeric or character laboratory result). It has assigned each laboratory test a test identifier, or “TestID,” and test number, or “TestNum,” for identification purposes. It specifies whether each laboratory test must include a unit, “UnitReq” (yes, no, or unknown unit), and whether the laboratory test has been “Characterized” or not (yes or no) – has the lab been standardized in the SDD and has guidance been provided to Data Partners.
lkp_pre_rxdoseform This table provides a comprehensive list of all allowable valid values for the variable RxDoseForm in the SCDM Prescribing table.
lkp_pre_rxdoseunit Provides a comprehensive list of all allowable valid values for the variable RxDoseUnit in the SCDM Prescribing table.
lkp_pre_rxroute Provides a comprehensive list of all allowable valid values for the variable RxRoute in the SCDM Prescribing table.
lkp_prm_type This lookup is used to attach PRM_Type and PRM_SubType to the PRS table to be included in select L3 output.
lkp_pvd_specialty This table provides a comprehensive list of all allowable valid values for the variable Specialty and correlating Speciality_Code_Type, in the SCDM Provider table.
lkp_rate_threshold This inputfile is referenced during check 245 to define the rates to trigger these flags based on the percent of records in the Encounter table with invalid combinations of enctype. ddate. discharge_disposition, and discharge_status.

7.1 control_flow

This table is used by the control flow module to selectively and sequentially execute QA 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 QA package integrated module, excluding any ‘add-on’ stand-alone programs—e.g., Mother-Infant Identification.

Specification: control_flow

Table 7.3: 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 package master program. Used to provide DP and ETL-specific SCDM table names to the QA package. char (12) $12 PROCTABLE
seqno Indicates sequence of module execution char (NA) BEST12. 1

7.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

Table 7.4: 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 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 Package will abort if this flag is present.
N = No. The QA 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 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 package or not. Most Level 1 and Level 2 checks will have FlagYN=Y. char (1) $1 Y = Yes
N = No 		Y

7.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

Table 7.5: 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’)

7.4 lkp_all_l2

Provides a comprehensive list of all allowable cross variable value combinations to be used for all modules (excluding LAB) Level 2 data checks.

Specification: lkp_all_l2

Table 7.6: Specification: lkp_all_l2
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
CheckID Unique data check identifier char (3) $3 2## 223
Tabid SCDM table abbreviation char (3) $3 SCDM table abbreviation DIA
Variable1 Primary variable being checked. char (21) $21 SCDM variable name as it appears in the model PDX
Variable2 Second variable being checked. char (21) $21 SCDM variable name as it appears in the model EncType
Value Indicates valid values char (10) $10 SCDM variable values IP
AbortYN Indicator for implication of the data check for the QA 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 Package will abort if this flag is present.
N = No. The QA Package will not abort if this flag is present. 		N
FlagCondition Indicates what condition will cause a flag to fail char (425) $425 Free text. EncType=‘IP’ and PDX is null

7.5 lkp_all_minmax

This SAS output table provides table-level information such as source table and variable names, as well as inclusion status in order to calculate minimum and maximum dates of data completeness.

Specification: lkp_all_minmax

Table 7.7: Specification: lkp_all_minmax
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
TabID SCDM table abbreviation char (3) $3 SCDM table abbreviation DIS
Library Directory / Folder name char (7) $7 msoc
dplocal 		msoc
Dataset QA output dataset used as source table char (24) $24 dia_l2_enc_dxtype_pdx_ym
dis_l3_rxdate_ym
dth_l3_dthdt_ym
enc_l3_enctype_adate_ym
enr_l3_enrmd_ym
lab_testdates_ym
pre_l2_orderdate_ym
pro_l3_enctype_pxtype_ym
vit_l3_measure_date_ym
irx_l3_rxadate_ym
txn_l3_enctype_ym 		dia_l2_enc_dxtype_pdx_ym
DateVar Derived date variable char (9) $9 yearmonth yearmonth
CountVar Variable being counted char (7) $7 count
meddrug 		count
SumYN Indicates whether dates are summed in SCDM tables for calculation of minimum/maximum date of data completeness char (1) $1 Y = Yes. Dates are summed.
N = No. Dates are not summed. 		Y
DPMinMax Indicates whether SCDM table is included in minimum/maximum date calculation of data completeness char (1) $1 Y = Yes. SCDM table is included.
N = No. SCDM table is not included. 		Y

7.6 lkp_all_saslength

This SAS output table acts as a crosswalk between an assigned length for numeric SAS variables and the maximum integer value that can be stored by that length.

Specification: lkp_all_saslength

Table 7.8: Specification: lkp_all_saslength
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
Bytes Valid numeric variable length num (8)
3
4
5
6
7
8 		4
Capacity Largest interger that can be stored. char (21) $21 8,192
2,097,152
536,870,912
137,438,953,472
35,184,372,088,832
9,007,199,254,740,992 		2,097,152

7.7 lkp_dem_zip

This SAS output table links valid 5-digit zip codes with the associated state. SAS creates a zip file quarterly and is the source of this data.

Specification: lkp_dem_zip

Table 7.9: Specification: lkp_dem_zip
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
PostalCode 5-digit zipcode char (5) $5 02215
STATECODE Two-letter abbreviation fo associated state. char (2) $2 Two-letter abbrev. for state name. MA

7.8 lkp_enc_l2

This SAS output table provides a list of valid combinations of variables EncType, DDate, Discharge_Disposition, and Discharge_Status in the SCDM Encounter table.

Specification: lkp_enc_l2

Table 7.10: Specification: lkp_enc_l2
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
EncType Encounter Type char (2) $2 IP = Inpatient Hospital Stay
AV = Ambulatory Visit
ED = Emergency Department
OA = Other Ambulatory Visit
IS = Non-Acute Institutional Stay 		IP
_ddate Status of of discharge date variable value. char (15) $15 Present
Special Missing
null 		Present
_Discharge_Disposition Value derived directly from SCDM table unless missing. Missing values converted to ‘Null’ char (4) $4 A = Discharged Alive
E = Expired
S = Still in facility
U = Unknown 		A
_Discharge_Status char (4) $4 AF = Adult Foster Home
AL = Assisted Living Facility
AM = Against Medical Advice
AW = Absent without leave
EX = Expired
HH = Home Health
HO = Home / Self Care
HS = Hospice
IP = Other Acute Inpatient Hospital
NH = Nursing Home (Includes ICF)
OT = Other
RH = Rehabilitation Facility
RS = Residential Facility
SH = Still In Facility
SN = Skilled Nursing Facility
UN = Unknown 		SN

7.9 lkp_lab_l2

This SAS output table provides a comprehensive list of all allowable combinations for the following variables in the Laboratory Result table: MS_Test_Name, Result_type (numeric or character), MS_Test_Sub_Category, Fast_ind, and Specimen_Source. To be used for Level 2 error checks.

Specification: lkp_lab_l2

Table 7.11: Specification: lkp_lab_l2
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
TestID Laboratory test indicator char (4) $4 ##-N = Token indicating a labratory test with a quantitative result.
##-C = Token indicating a labratory test with a qualitative result. 		20-N
MS_Test_Name SCDM Lab table test name as it appears in the model char (20) $20 See lkp_lab_test PG
Result_Type Laboratory test result type char (1) $1 N = Numeric
C = Character 		N
MS_Test_Sub_Category Sub-category for MS_Test_Name char (6) $6 BHCG = beta human choriogonadotropin
CLC = calculated
DDU = d-dimer units
DIRECT = direct
EIA = {enzyme} immunoassay
FEU = fibrinogen equivalent units
HCG = human choriogonadotropin
IA_RAP = immunoassay, rapid
IF = immunofluorescence
NS = not specified
PCR = probe and target amplification
SEQ = sequencing
VTC = organism-specific culture 		HCG
Fast_Ind Fasting indicator. char (1) $1 F = Fasting
R = Random
X = Not Applicable
U = Unknown 		X
Specimen_Source Specimen source. char (7) $7 BAL = bronchoalveolar lavage
BALBX = bronchoalveolar biopsy
BLOOD = blood
CSF = cerebrospinal fluid
NPH = nasopharyngeal swab
NPWASH = nasopharyngeal wash
NSWAB = nasal swab or nose specimen
NWASH = nasal wash
OTHER = other
PLASMA = plasma
PPP = platelet poor plasma
SERUM = serum
SPUTUM = sputum
SR_PLS = serum/plasma
THRT = throat swab, oropharyngeal swab
UNK = unknown or missing
URINE = urine
BLD_DOT = blood dot 		BLOOD

7.10 lkp_lab_l2_nc

This SAS output table provides allowable Laboratory Result table lab test result, modifier, and unit combinations. This lookup table maps the acceptable MS_Result_C values to the Modifier values and MS_Result_unit values, as appropriate. Only characterized laboratory tests are included in this lookup table.

Specification: lkp_lab_l2_nc

Table 7.12: Specification: lkp_lab_l2_nc
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
TestID Laboratory test indicator char (4) $4 ##-N = Token indicating a labratory test with a quantitative result.
##-C = Token indicating a labratory test with a qualitative result. 		24-C
MS_Test_Name SCDM Lab table test name as it appears in the model char (20) $20 See lkp_lab_test TROP_T
Result_Type Laboratory test result type char (1) $1 N = Numeric
C = Character 		C
MS_Result_C Standardized value for text or character laboratory results. char (50) $50 BORDERLINE
NEGATIVE
POSITIVE
UNDETERMINED
RANGE: start|end unit 		POSITIVE
Modifier Modifier for laboratory result values. char (2) $2 EQ = equal
GE = greater than or equal to
GT = greater than
LE = less than or equal to
LT = less than
TX = text
UN = Unknown 		TX
MS_Result_Unit Converted/standardized unit for numeric laboratory test result values. char (11) $11 K/UL

7.11 lkp_lab_loinc

This SAS output table provides allowable Laboratory Result table LOINC calues. This lookup table maps the MS_Test_Name values to the LOINC values, as appropriate.

Specification: lkp_lab_loinc

Table 7.13: Specification: lkp_lab_loinc
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
LOINC LOINC value char (4) $4 1783-0 = ALP
6768-6 = ALP
1742-6 = ALT
1743-4 = ALT
1744-2 = ALT
44785-4 = ALT
26499-4 = ANC
751-8 = ANC
752-6 = ANC
753-4 = ANC
14631-6 = BILI_TOT
1975-2 = BILI_TOT
33898-8 = BILI_TOT
33899-6 = BILI_TOT
34543-9 = BILI_TOT
35194-0 = BILI_TOT
42719-5 = BILI_TOT
50189-0 = BILI_TOT
54363-7 = BILI_TOT
59827-6 = BILI_TOT
59828-4 = BILI_TOT
12772-0 = CHOL_HDL
14646-4 = CHOL_HDL
18263-4 = CHOL_HDL
2085-9 = CHOL_HDL
35197-3 = CHOL_HDL
49130-8 = CHOL_HDL
13457-7 = CHOL_LDL
18262-6 = CHOL_LDL
2089-1 = CHOL_LDL
22748-8 = CHOL_LDL
35198-1 = CHOL_LDL
39469-2 = CHOL_LDL
57698-3 = CHOL_LDL
69419-0 = CHOL_LDL
14647-2 = CHOL_TOT
2093-3 = CHOL_TOT
35200-5 = CHOL_TOT
48620-9 = CHOL_TOT
2157-6 = CK
24335-2 = CK
50756-6 = CK
13969-1 = CK_MB
2154-3 = CK_MB
32673-6 = CK_MB
49551-5 = CK_MB
6773-6 = CK_MB
12187-1 = CK_MBI
12189-7 = CK_MBI
20569-0 = CK_MBI
49136-5 = CK_MBI
14682-9 = CREATININE
21232-4 = CREATININE
2160-0 = CREATININE
35203-9 = CREATININE
38483-4 = CREATININE
44784-7 = CREATININE
59826-8 = CREATININE
15129-0 = D_DIMER
15179-5 = D_DIMER
29280-5 = D_DIMER
30240-6 = D_DIMER
3246-6 = D_DIMER
3247-4 = D_DIMER
38898-3 = D_DIMER
48058-2 = D_DIMER
48065-7 = D_DIMER
48066-5 = D_DIMER
48067-3 = D_DIMER
55398-2 = D_DIMER
71427-9 = D_DIMER
7799-0 = D_DIMER
10450-5 = GLUCOSE
14743-9 = GLUCOSE
14749-6 = GLUCOSE
14770-2 = GLUCOSE
14771-0 = GLUCOSE
15074-8 = GLUCOSE
1554-5 = GLUCOSE
1556-0 = GLUCOSE
1557-8 = GLUCOSE
1558-6 = GLUCOSE
17865-7 = GLUCOSE
2339-0 = GLUCOSE
2340-8 = GLUCOSE
2341-6 = GLUCOSE
2345-7 = GLUCOSE
32016-8 = GLUCOSE
35184-1 = GLUCOSE
35211-2 = GLUCOSE
39480-9 = GLUCOSE
39481-7 = GLUCOSE
41604-0 = GLUCOSE
41651-1 = GLUCOSE
41652-9 = GLUCOSE
41653-7 = GLUCOSE
51596-5 = GLUCOSE
14775-1 = HGB
20509-6 = HGB
24360-0 = HGB
30313-1 = HGB
30350-3 = HGB
30351-1 = HGB
30352-9 = HGB
55782-7 = HGB
59260-0 = HGB
718-7 = HGB
17855-8 = HGBA1C
17856-6 = HGBA1C
4548-4 = HGBA1C
4549-2 = HGBA1C
59261-8 = HGBA1C
62388-4 = HGBA1C
71875-9 = HGBA1C
22826-2 = INF_A
22827-0 = INF_A
31858-4 = INF_A
31859-2 = INF_A
34487-9 = INF_A
38270-5 = INF_A
38271-3 = INF_A
38272-1 = INF_A
38381-0 = INF_A
39025-2 = INF_A
39102-9 = INF_A
39103-7 = INF_A
40981-3 = INF_A
43874-7 = INF_A
44263-2 = INF_A
44264-0 = INF_A
44265-7 = INF_A
44266-5 = INF_A
44558-5 = INF_A
44559-3 = INF_A
44560-1 = INF_A
44562-7 = INF_A
44563-5 = INF_A
44564-3 = INF_A
44795-3 = INF_A
46082-4 = INF_A
48310-7 = INF_A
49520-0 = INF_A
49523-4 = INF_A
49526-7 = INF_A
49527-5 = INF_A
49528-3 = INF_A
49531-7 = INF_A
53250-7 = INF_A
55133-3 = INF_A
55134-1 = INF_A
55463-4 = INF_A
55464-2 = INF_A
55465-9 = INF_A
56024-3 = INF_A
57985-4 = INF_A
5860-2 = INF_A
5861-0 = INF_A
5862-8 = INF_A
5863-6 = INF_A
59423-4 = INF_A
59424-2 = INF_A
60494-2 = INF_A
60530-3 = INF_A
60538-6 = INF_A
61101-2 = INF_A
68986-9 = INF_A
68987-7 = INF_A
74038-1 = INF_A
74039-9 = INF_A
74040-7 = INF_A
76077-7 = INF_A
76078-5 = INF_A
77026-3 = INF_A
77027-1 = INF_A
77028-9 = INF_A
77605-4 = INF_A
80588-7 = INF_A
80589-5 = INF_A
80590-3 = INF_A
81305-5 = INF_A
81307-1 = INF_A
81308-9 = INF_A
81320-4 = INF_A
81321-2 = INF_A
81428-5 = INF_A
82166-0 = INF_A
82167-8 = INF_A
82168-6 = INF_A
82169-4 = INF_A
85477-8 = INF_A
86317-5 = INF_A
86568-3 = INF_A
86569-1 = INF_A
88187-0 = INF_A
88193-8 = INF_A
88599-6 = INF_A
88600-2 = INF_A
88835-4 = INF_A
91072-9 = INF_A
91771-6 = INF_A
92142-9 = INF_A
92808-5 = INF_A
92809-3 = INF_A
92977-8 = INF_A
94394-4 = INF_A
94395-1 = INF_A
94396-9 = INF_A
95658-1 = INF_A
24015-0 = INF_AB
31860-0 = INF_AB
31861-8 = INF_AB
31862-6 = INF_AB
33535-6 = INF_AB
44566-8 = INF_AB
44567-6 = INF_AB
48509-4 = INF_AB
49537-4 = INF_AB
61102-0 = INF_AB
62462-7 = INF_AB
6435-2 = INF_AB
6436-0 = INF_AB
6437-8 = INF_AB
6438-6 = INF_AB
6439-4 = INF_AB
6440-2 = INF_AB
6441-0 = INF_AB
6442-8 = INF_AB
82461-5 = INF_AB
31863-4 = INF_B
31864-2 = INF_B
38382-8 = INF_B
40982-1 = INF_B
43895-2 = INF_B
44571-8 = INF_B
44572-6 = INF_B
44573-4 = INF_B
44575-9 = INF_B
44576-7 = INF_B
44577-5 = INF_B
46083-2 = INF_B
49535-8 = INF_B
53251-5 = INF_B
5864-4 = INF_B
5865-1 = INF_B
5866-9 = INF_B
5867-7 = INF_B
74784-0 = INF_B
74785-7 = INF_B
74786-5 = INF_B
76079-3 = INF_B
76080-1 = INF_B
80591-1 = INF_B
81309-7 = INF_B
81325-3 = INF_B
81327-9 = INF_B
82170-2 = INF_B
85478-6 = INF_B
86571-7 = INF_B
86572-5 = INF_B
88195-3 = INF_B
88592-1 = INF_B
88596-2 = INF_B
90886-3 = INF_B
92141-1 = INF_B
92976-0 = INF_B
49524-2 = INF_NS
49521-8 = INF_NS
54240-7 = INF_NS
54243-1 = INF_NS
54244-9 = INF_NS
6601-9 = INF_NS
6602-7 = INF_NS
6603-5 = INF_NS
6604-3 = INF_NS
34714-6 = INR
46418-0 = INR
6301-6 = INR
2572-6 = LIPASE
3040-3 = LIPASE
19080-1 = PG
20415-6 = PG
2106-3 = PG
2107-1 = PG
2110-5 = PG
2111-3 = PG
2112-1 = PG
2114-7 = PG
2116-2 = PG
2117-0 = PG
2118-8 = PG
2119-6 = PG
21198-7 = PG
25372-4 = PG
34670-0 = PG
45194-8 = PG
55869-2 = PG
13056-7 = PLATELETS
24361-8 = PLATELETS
26515-7 = PLATELETS
777-3 = PLATELETS
778-1 = PLATELETS
95423-0 = SARS_COV_2
101289-7 = SARS_COV_2
94307-6 = SARS_COV_2
94308-4 = SARS_COV_2
94309-2 = SARS_COV_2
94314-2 = SARS_COV_2
94316-7 = SARS_COV_2
94500-6 = SARS_COV_2
94533-7 = SARS_COV_2
94534-5 = SARS_COV_2
94558-4 = SARS_COV_2
94559-2 = SARS_COV_2
94565-9 = SARS_COV_2
94639-2 = SARS_COV_2
94640-0 = SARS_COV_2
94641-8 = SARS_COV_2
94660-8 = SARS_COV_2
94756-4 = SARS_COV_2
94757-2 = SARS_COV_2
94759-8 = SARS_COV_2
94760-6 = SARS_COV_2
94763-0 = SARS_COV_2
94766-3 = SARS_COV_2
94767-1 = SARS_COV_2
94822-4 = SARS_COV_2
94845-5 = SARS_COV_2
95406-5 = SARS_COV_2
95409-9 = SARS_COV_2
95424-8 = SARS_COV_2
95425-5 = SARS_COV_2
95608-6 = SARS_COV_2
95609-4 = SARS_COV_2
95824-9 = SARS_COV_2
96091-4 = SARS_COV_2
96119-3 = SARS_COV_2
96120-1 = SARS_COV_2
96123-5 = SARS_COV_2
96448-6 = SARS_COV_2
96765-3 = SARS_COV_2
96797-6 = SARS_COV_2
96829-7 = SARS_COV_2
96957-6 = SARS_COV_2
96958-4 = SARS_COV_2
96986-5 = SARS_COV_2
97097-0 = SARS_COV_2
97098-8 = SARS_COV_2
98131-6 = SARS_COV_2
98132-4 = SARS_COV_2
98493-0 = SARS_COV_2
98494-8 = SARS_COV_2
102048-6 = SARS_COV_2
94562-6 = SARS_COV_2_AB_A
94720-0 = SARS_COV_2_AB_A
94768-9 = SARS_COV_2_AB_A
95427-1 = SARS_COV_2_AB_A
95125-1 = SARS_COV_2_AB_AM
94505-5 = SARS_COV_2_AB_G
94507-1 = SARS_COV_2_AB_G
94563-4 = SARS_COV_2_AB_G
94761-4 = SARS_COV_2_AB_G
95429-7 = SARS_COV_2_AB_G
96742-2 = SARS_COV_2_AB_G
94547-7 = SARS_COV_2_AB_GM
94506-3 = SARS_COV_2_AB_M
94508-9 = SARS_COV_2_AB_M
94564-2 = SARS_COV_2_AB_M
95416-4 = SARS_COV_2_AB_M
95428-9 = SARS_COV_2_AB_M
94661-6 = SARS_COV_2_AB_TOTAL
94762-2 = SARS_COV_2_AB_TOTAL
94769-7 = SARS_COV_2_AB_TOTAL
95542-7 = SARS_COV_2_AB_TOTAL
98069-8 = SARS_COV_2_AB_TOTAL
2947-0 = SODIUM
2951-2 = SODIUM
32717-1 = SODIUM
39791-9 = SODIUM
39792-7 = SODIUM
41657-8 = SODIUM
42570-2 = SODIUM
44783-9 = SODIUM
74353-4 = SODIUM
14927-8 = TRIG
1644-4 = TRIG
17081-1 = TRIG
2571-8 = TRIG
3048-6 = TRIG
30524-3 = TRIG
35217-9 = TRIG
47210-0 = TRIG
10839-9 = TROP_I
16255-2 = TROP_I
42757-5 = TROP_I
49563-0 = TROP_I
33204-9 = TROP_T
48425-3 = TROP_T
48426-1 = TROP_T
6597-9 = TROP_T
6598-7 = TROP_T
67151-1 = TROP_T
11579-0 = TSH
11580-8 = TSH
14297-6 = TSH
24348-5 = TSH
27975-2 = TSH
29575-8 = TSH
3015-5 = TSH
3016-3 = TSH
55462-6 = TSH 		3016-3
MS_Test_Name SCDM Lab table test name as it appears in the model char (20) $20 See lkp_lab_test TROP_T
Result_Type Laboratory test result type char (1) $1 N = Numeric
C = Character 		C

7.12 lkp_lab_result_ranges

This table provides expected Laboratory Result table lab test ranges. This lookup table defines the expected result value ranges for lab tests with numeric results in the Laboratory Result table. Only MS_Test_Name values where Result_Type=N and Characterized=Y are included in this lookup table.

Specification: lkp_lab_result_ranges

Table 7.14: Specification: lkp_lab_result_ranges
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
MS_Test_Name SCDM Lab table test name as it appears in the model char (10) $10 See lkp_lab_test ALP
MS_Test_Sub_Category Sub-category for MS_Test_Name char (6) $6 See lkp_lab_l2
Fast_Ind Fasting indicator. char (1) $1 See lkp_lab_l2 X
MS_Result_Unit Converted/standardized unit for numeric laboratory test result values. char (7) $7 U/L
FMTNAME Format Name char (20) $20 Unique format name made up of MS_Test_Name, MS_Test_Sub_Category, Fast_Ind, and MS_Result_Unit values. ALPXUL
LABEL Format label char (16) The right side of the formatting = sign. >=350
START Range start num (8) BEST12. Minimum numeric value for the range. 350
END Range end num (8) BEST12. Maximum numeric value for the range. .
SEXCL Exclude range start char (1) $1 Y = Exclude range start
N = Include range start 		N
EEXCL Exclude range end char (1) $1 Y = Exclude range end
N = Include range end 		N
HLO Range Ending Value Exceeds value in Start / End char (1) $1 H = High—Value in END is ignored
L = Low—Value in START is ignored
O = Other—both START and END values are ignored 		H
TYPE Variable type char (1) $1 C = Character
N = Numeric 		N

7.13 lkp_lab_test

This SAS output table provides a comprehensive list of all allowable combinations for the following two variables in the SCDM Laboratory Result table: MS_Test_Name (laboratory test name) and Result_type (numeric or character laboratory result). It has assigned each laboratory test a test identifier, or “TestID,” and test number, or “TestNum,” for identification purposes. It specifies whether each laboratory test must include a unit, “UnitReq” (yes, no, or unknown unit), and whether the laboratory test has been “Characterized” or not (yes or no) – has the lab been standardized in the SDD and has guidance been provided to Data Partners.

Specification: lkp_lab_test

Table 7.15: Specification: lkp_lab_test
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
TestID Laboratory test indicator char (4) $4 ##-N = Token indicating a labratory test with a quantitative result.
##-C = Token indicating a labratory test with a qualitative result. 		02-N
TestNum Laboratory test sequence number char (2) $2 ## = Two-digit number indicating the sequence of the laboratory test. 02
MS_Test_Name Laboratory test name char (20) $20 ALP = alkaline phosphatase
ALT = alanine aminotransferase
ANC = absolute neutrophil count
BILI_TOT = total bilirubin
CHOL_HDL = cholesterol high density lipoprotein
CHOL_LDL = cholesterol low density lipoprotein
CHOL_TOT = cholesterol total
CK = creatine kinase total
CK_MB = creatine kinase MB
CK_MBI = creatine kinase MB/creatine kinase total
CREATININE = creatinine
D_DIMER = d-dimer
GLUCOSE = glucose
HGB = hemoglobin
HGBA1C = glycosylated hemoglobin
INF_A = influenza virus A
INF_AB = influenza virus A + B
INF_B = influenza virus B
INF_NS = influenza virus not specified
INR = international normalized ratio
LIPASE = lipase
PG = pregnancy test
PLATELETS = platelet count
SARS_COV_2 = sars coronavirus-2
SODIUM = sodium
TRIG = triglycerides
TROP_I = troponin I cardiac
TROP_T = troponin T cardiac
TSH = thyroid stimulating hormone
SARS_COV_2_AB_TOTAL = sars coronavirus-2 antibody
SARS_COV_2_AB_A = sars coronavirus-2 antibody IgA
SARS_COV_2_AB_G = sars coronavirus-2 antibody IgG
SARS_COV_2_AB_M = sars coronavirus-2 antibody IgM
SARS_COV_2_AB_AM = sars coronavirus-2 antibody IgA + IgM
SARS_COV_2_AB_GM = sars coronavirus-2 antibody IgG + IgM
SARS_COV_2_AB_NS = sars coronavirus-2 antibody not specified
UNMAPPED = LOINC code not mapped to another MS_Test_Name should be mapped to this value 		ALT
Result_Type Laboratory test result type char (2) $2 N = Numeric
C = Character 		N
UnitReq Indicates whether laboratory test requires a unit char (1) $1 Y = Yes
N = No
U = Unknown 		Y
Characterized Indicates whether the laboratory test has been standardized in the SDD char (2) $2 Y = Yes
N = No 		Y

7.14 lkp_pre_rxdoseform

This table provides a comprehensive list of all allowable valid values for the variable RxDoseForm in the SCDM Prescribing table.

Specification: lkp_pre_rxdoseform

Table 7.16: Specification: lkp_pre_rxdoseform
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
Variable Variable to which value applies as valid. char (10) $10 RxDoseForm RxDoseForm
Value Standardized list of values expected in RxDoseForm field, no spaces char (40) $40 See Sentinel Common Data Model Reference Tables DRUG_IMPLANT
Description Free text description of value char (51) $51 See Sentinel Common Data Model Reference Tables Drug Implant

7.15 lkp_pre_rxdoseunit

Provides a comprehensive list of all allowable valid values for the variable RxDoseUnit in the SCDM Prescribing table.

Specification: lkp_pre_rxdoseunit

Table 7.17: Specification: lkp_pre_rxdoseunit
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
Variable Variable to which value applies as valid char (10) $10 RxDoseUnit RxDoseUnit
Value Standardized list of values expected in RxDoseUnit field, no spaces char (25) $25 See Sentinel Common Data Model Reference Tables A/m
Description Free text description of value char (72) $72 See Sentinel Common Data Model Reference Tables Ampere per meter

7.16 lkp_pre_rxroute

Provides a comprehensive list of all allowable valid values for the variable RxRoute in the SCDM Prescribing table.

Specification: lkp_pre_rxroute

Table 7.18: Specification: lkp_pre_rxroute
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
Variable Variable to which value applies as valid. char (7) $7 RxRoute RxRoute
Value Standardized list of values expected in RxRoute field, no spaces char (25) $25 See Sentinel Common Data Model Reference Tables JEJUNOSTOMY
Description Free text description of value char (32) $32 See Sentinel Common Data Model Reference Tables Jejunostomy route

7.17 lkp_prm_type

This lookup is used to attach PRM_Type and PRM_SubType to the PRS table to be included in select L3 output.

Specification: lkp_prm_type

Table 7.19: Specification: lkp_prm_type
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
PRM_CODE Unique integer identifier to a questionnaire type and subtype combination. Used to link across all PRM tables num (8)
PRM_TYPE char (26)
PRO_TYPE_DESCRIPTION char (142)
PRM_SUBTYPE char (25)
PRM_SUBTYPE_DESCRIPTION char (135)
PRM_TYPE_NOTES char (443)

7.18 lkp_pvd_specialty

This table provides a comprehensive list of all allowable valid values for the variable Specialty and correlating Speciality_Code_Type, in the SCDM Provider table.

Specification: lkp_pvd_specialty

Table 7.20: Specification: lkp_pvd_specialty
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL NOTES VALUES EXAMPLE
Specialty_CodeType Correlates to specialty code length num (8)
2 = 2
0 = 10 		0
Specialty Standardized list of specialty codes based on CMS nomenclature. char (10) $10 See Sentinel Common Data Model Reference Tables 207U00000X
Description Free text description of value char (148) $148 See Sentinel Common Data Model Reference Tables Allopathic & Osteopathic Physicians/Nuclear Medicine

7.19 lkp_rate_threshold

This inputfile is referenced during check 245 to define the rates to trigger these flags based on the percent of records in the Encounter table with invalid combinations of enctype. ddate. discharge_disposition, and discharge_status.

Specification: lkp_rate_threshold

Table 7.21: Specification: lkp_rate_threshold
VARIABLE DESCRIPTION VARIABLE TYPE (LENGTH) FORMAT LABEL EXAMPLE NOTES VALUES
CheckID Token indicating unique data check identifier. num (8)
TableID 3 character abbreviation for source SCDM table char (3)
TestID char (4)
FMTNAME char (10)
LABEL char (11)
START num (8)
END num (8)
SEXCL char (1)
EEXCL char (1)
HLO char (1)
TYPE char (1)