6 Input Files

The inputfiles directory contains programs and submodules used in the execution of the QA Program Package, organized as discrete SAS macros. Table 6.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 6.2 describes the lookup tables found in the inputfiles\qar sub-directory.

Table 6.1: List of QA Package Programs
Module Filename	Description
00.0_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.
00.0_scdm_control_flow.sas	This program module selectively and sequentially executes the QA program modules.
00.1_scdm_standard_macros.sas	Contains macros used across QA program modules.
00.2_scdm_formats.sas	Contains standard formats used across QA program modules.
00.3_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.
00.4_scdm_qasignaturerequest.sas	Creates a final signature file (msoc.alltable_signature) that summarizes metadata from individual module-level signature files.
00.5_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
00.6_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.
01.1_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.
02.1_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.
03.1_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.
04.1_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.
04.2_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.
04.3_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.
05.1_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.
05.2_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.
06.1_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.
06.2_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.
07.1_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.
07.2_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.
09.1_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.
10.1_scdm_data_qa_review-facility.sas	This program queries facility level information.
10.2_scdm_data_qa_review-provider.sas	This program queries provider level information, including Specialty_CodeType and Specialty.
99.1_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).
99.2_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 6.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_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.

6.0.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 6.3: Specification: control_flow
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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
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 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

6.0.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 6.4: Specification: lkp_all_flags
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.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 6.5: Specification: lkp_all_l1
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	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’)

6.0.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 6.6: Specification: lkp_all_l2
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.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 6.7: Specification: lkp_all_minmax
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

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

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

6.0.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 6.10: Specification: lkp_enc_l2
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.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 6.11: Specification: lkp_lab_l2
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.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 6.12: Specification: lkp_lab_l2_nc
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.11 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 6.13: Specification: lkp_lab_result_ranges
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.12 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 6.14: Specification: lkp_lab_test
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.13 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 6.15: Specification: lkp_pre_rxdoseform
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.14 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 6.16: Specification: lkp_pre_rxdoseunit
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.15 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 6.17: Specification: lkp_pre_rxroute
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.16 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 6.18: Specification: lkp_prm_type
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)
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)

6.0.17 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 6.19: Specification: lkp_pvd_specialty
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	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

6.0.18 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 6.20: Specification: lkp_rate_threshold
VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)
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)