8 Output Datasets

Output datasets are designed to evaluate one or more data checks—i.e., pre-defined data quality measures or characterizations. Each data check is designated a “Level 1,” “Level 2,” or “Level 3” data quality check depending on the complexity and assigned a “FlagID” for tracking and reporting purposes. Please see the section on Quality Checks for more details.

Please note that the tables for each output file are complete and quite lengthy. A sortable version of the QA Package Data Dictionary file can also be downloaded as an Excel workbook from the QA Package git repository.

8.1 MSOC Folder

Table 8.1 describes the QA Program Package output datasets found in the msoc directory. These datasets are returned to SOC. Subsections 8.1.132 and 8.1.133 describe the Mother-Infant Identification and SCDM Snapshot MSOC output, respectively.

Table 8.1: QA Package MSOC Folder Output

Dataset	TabID	Level	Description
all_l1_cont	ALL	L1	This dataset contains resulting output from SAS proc contents for all SCDM tables, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output.
all_l1_l2_flags	ALL	L1	This dataset contains one record per unique FlagID for Level 1 or Level 2 non-passing data checks and associated frequency.
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_l2_crosstab_length_value	ALL	L2	This dataset contains frequency of distinct observed value lengths stratified by table and cross-table variable (e.g. PatID).
all_l2_crosstab_length_var	ALL	L2	This dataset contains a comparison of cross-table variable length across applicable tables.
all_l2_encounterid_match	ALL	L2	This dataset contains frequency of distinct EncounterID values stratified by binary indicator of presence by each utilization table.
all_l2_facilityid_match	ALL	L2	This dataset contains frequency of distinct FacilityID values stratified by binary indicator of presence by each SCDM table.
all_l2_patid_match	ALL	L2	This dataset contains frequency of distinct PatID values stratified by binary indicator of presence by each SCDM table.
all_l2_prm_code_match	ALL	L2	This dataset contains frequency of distinct PRM_Code values stratified by binary indicator of presence in the PRR and PRS Tables.
all_l2_providerid_match	ALL	L2	This dataset contains frequency of distinct Provider values stratified by binary indicator of presence by each utilization table.
all_l2_questionid_match	ALL	L2	This dataset contains frequency of distinct QuestionID values stratified by binary indicator of presence in the PRR and PRS Tables.
all_l2_questionverid_match	ALL	L2	This dataset contains frequency of distinct QuestionVerID values stratified by binary indicator of presence in the PRR and PRS Tables.
all_l2_surveyid_match	ALL	L2	This dataset contains frequency of distinct SurveyID values stratified by binary indicator of presence in the PRR and PRS Tables.
all_l3_dates_dist	ALL	L3	This dataset contains one row per SCDM table date variable with date value distribution statistics.
all_l3_summary	ALL	L3	This dataset contains one row per SCDM table and summarizes key table and variable data.
all_l3_survey_dist	ALL	L3
alltable_signature	ALL		This metadata file contains summarized request-level metadata and basic benchmarking statistics after all modules have completed.
data_characteristics_sign_off_report_dpid_etlnum	ALL	L1	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.
module_signature	ALL		This metadata file contains module-level metadata and basic benchmarking statistics after each module has completed. Module will be replaced with the appropriate module name—e.g., l1_signature, enr_signature.
cod_l2_cod_codetype	COD	L2	This dataset contains frequency of records stratified by CodeType and COD values.
cod_l3_catvars	COD	L3	This dataset contains frequency of records stratified by CauseType, Confidence, and Source values.
control_flow_3	CON		This metadata file is a modified version of the “control_flow” input file, limited to DP-specific SCDM tables to evaluate.
dem_l3_agecat	DEM	L3	This dataset contains frequency of records stratified by derived (using DP_MaxDate) age group category.
dem_l3_ageyr_stats	DEM	L3	This dataset contains the statistical distribution of derived (using DP_MaxDate) age in years.
dem_l3_catvars	DEM	L3	This dataset contains frequency of records stratified by sex, race, Hispanic, imputedRace and ImputedHispanic values.
dem_l3_zip_state	DEM	L3	This dataset contains frequency of records stratified by derived state associated with observed ZIP code values.
dem_l3_zip_verify_y	DEM	L3	This dataset contains frequency of records stratified by ZIP code validation status by derived ZIP_Date year values. Validation status refers to whether a ZIP code is valid or invalid at the time of review.
dem_l3_zip_y	DEM	L3	This dataset contains frequency of records stratified by masked ZIP codes by derived year values. ZIP_masked variable is based on the value format and length of the source zip variable at the time of review.
dia_l2_dx_dxtype_spec	DIA	L2	This dataset contains frequency of records stratified by DX_CodeType, DX, and Specialty values.
dia_l2_enc_dxtype_pdx_ym	DIA	L2	This dataset contains frequency of records stratified by EncType, DX_CodeType, and PDX values and derived year-month values (YearMonth derived by DIA.adate for non IP/IS encounters, and ENC.ddate for IP/IS encounters).
dia_l3_dx_per_enc_stats	DIA	L3	This dataset contains descriptive statistics for the frequency of diagnoses (distinct DX_CodeType and DX) per patient encounter.
dia_l3_padmit	DIA	L3	This dataset contains the frequency of records stratified by PAdmit values.
dis_l2_rx_rxtype_spec	DIS	L2	This dataset contains combinations of Rx, Rx_CodeType, and Specialty values.
dis_l2_rxamt_rxsup	DIS	L2	This dataset contains the frequency of records stratified by RxAmt and RxSup values. It has replaced the now obsolete dis_l3_rxamt and dis_l3_rxsup datasets.
dis_l3_rx_pt_y_stats	DIS	L3	This dataset contains the statistical distribution of frequency of unique dispensings per member stratified by derived year values.
dis_l3_rxdate_ym	DIS	L3	This dataset contains frequency of records stratified by derived year-month values.
dth_l3_catvars	DTH	L3	This dataset contains frequency of records stratified by dtimpute, source, and confidence values.
dth_l3_dthdt_ym	DTH	L3	This dataset contains frequency of records stratified by derived year-month values.
enc_l2_enctype_admit_dc	ENC	L2	This dataset contains frequency of records stratified by EncType, Admitting_Source, discharge_disposition, and discharge_status values.
enc_l2_enctype_dc_ddate_spmiss	ENC	L2	This dataset contains frequency of records stratified by EncType, Discharge_Disposition, and Discharge_Status by DDate population status. Population status refers to whether a DDate is present, missing, or populated with a special missing value.
enc_l2_enctype_ddate_ym	ENC	L2	This dataset contains frequency of records stratified by EncType and Ddate year-month values.
enc_l2_enctype_drg_drgtype	ENC	L2	This dataset contains frequency of records stratified by EncType, DRG, and DRG_Type values.
enc_l2_enctype_drgtype_ym	ENC	L2	This dataset contains frequency of records stratified by EncType, DRG_Type, and Adate year-month values.
enc_l2_enctype_spmiss_ddate_ym	ENC	L2	This dataset contains frequency of records stratified by EncType, Adate (year-month), where Ddate = “.S”.
enc_l3_enctype_los_ym	ENC	L3	This dataset contains frequency of records stratified by EncType, derived length of stay (LOS), and Adate year-month values.
enc_l3_enctype_pt_ym_stats	ENC	L3	This dataset contains the statistical distribution of unique EncounterIDs per PatID stratified by EncType and derived Adate year-month values.
enc_l3_pt_ym_stats	ENC	L3	This dataset contains statistical distribution of unique EncounterID per PatID stratified by derived Adate year-month values.
enr_l2_enrstart_agedayscat	ENR	L2	This dataset contains frequency of unique patient counts stratified by year of earliest enrollment span and age in days at its start.
enr_l2_overlap	ENR	L2	This dataset contains frequency of overlapping enrollment spans and unique PatID stratified by derived overlap subtypes (Duplicate, Subset, or Overlap).
enr_l3_catvars	ENR	L3	This dataset contains frequency of records stratified by MedCov, DrugCov, Chart, PlanType, and PayerType values.
enr_l3_chart_y	ENR	L3	This dataset contains frequency of records stratified by chart and Enr_Start year values, with no exclusion of records by med or DrugCov.
enr_l3_covtype_chart	ENR	L3	This dataset contains frequency of records stratified by MedCov, DrugCov, and chart values.
enr_l3_covtype_duration	ENR	L3	This dataset contains frequency of unique members stratified by total coverage duration in months and coverage type, where MedCov and DrugCov = “Y.”
enr_l3_enrmd_ym	ENR	L3	This dataset contains frequency of records with medical and/or drug coverage stratified by derived year-month of enrollment. This is determined by whether at least one day within an enrollment span crosses a year-month.
enr_l3_mdcov_months_stats	ENR	L3	This dataset contains the statistical distribution on total duration, across all enrollment spans, of combined active medical and drug coverage (in months) by unique member.
etl_version	ETL		This metadata file contains the number of the ETL under review.
irx_l3_ndc	IRX	L3	This dataset contains frequency of records stratified by ndc values.
irx_l3_rx_enc_ym_stats	IRX	L3	This dataset contains statistical distribution of encounters and rx per encounter, stratified by derived year-month.
irx_l3_rx_pt_ym_stats	IRX	L3	This dataset contains statistical distribution of patid and rx per patid, stratified by derived year-month.
irx_l3_rxadate_ym	IRX	L3	This dataset contains frequency of records stratified by rxadate as represented in year-month values.
irx_l3_rxatime_hour	IRX	L3	This dataset contains frequency of records stratified by rxatime as represented in year-month values.
irx_l3_rxatime_ym_stats	IRX	L3	This dataset contains the statistical distribution of dispensing time of day by derived year-month.
irx_l3_rxdose_ym	IRX	L3	This dataset contains frequency of records stratified by rxdose and derived year-month values.
irx_l3_rxroute_ym	IRX	L3	This dataset contains frequency of records stratified by rxroute and derived year-month values.
lab_l2_mapped_tests	LAB	L2
lab_l2_ms_result	LAB	L2	This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Result_type, Fast_ind, Specimen_Source, LOINC, MS_Result_C, MS_Result_N, Modifier, and MS_Result_unit values, excluding records where result type=C for any numeric-only test.
lab_l2_ms_result_x	LAB	L2	This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Result_type, Fast_ind, Specimen_Source, LOINC, MS_Result_C, MS_Result_N, Modifier, and MS_Result_unit values for records where result type=C for any numeric-only test.
lab_l2_record_count	LAB	L2	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, and LOINC values.
lab_l2_test_units	LAB	L2	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Orig_Result_unit, Std_Result_unit, and MS_Result_unit values.
lab_l3_abn_ind	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, and Abn_ind values.
lab_l3_cat_resultn_ptloc_{t}	LAB	L3	This dataset contains frequency of records with MS_Result_N values that fall into pre-defined categories of result value ranges, stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Pt_Loc, MS_Result_unit, and MS_Result_Range (derived).
lab_l3_cat_resultn_ss_{t}	LAB	L3	This dataset contains frequency of records stratified by MS_Result_N values that fall into pre-defined categories of result value ranges, stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Specimen_Source, MS_Result_unit, and MS_Result_Range (derived).
lab_l3_dates	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived labdt, derived resdt, and derived orddt values.
lab_l3_dates_ym	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived Order_ym, derived Lab_ym, and derived Result_ym values.
lab_l3_ms_test_sub_category	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, and PX_CodeType values.
lab_l3_n_patid_enrolled_test_y	LAB	L3	This dataset contains frequency of unique PatID stratified by MS_Test_Name, Result_Type, and derived year values.
lab_l3_n_patid_test	LAB	L3	This dataset contains frequency of unique PatID by MS_Test_Name, and Result_Type values.
lab_l3_n_patid_test_y	LAB	L3	This dataset contains frequency of unique PatID by MS_Test_Name, Result_Type, and derived year values.
lab_l3_n_patid_test_ym	LAB	L3	This dataset contains frequency of unique PatID by MS_Test_Name, Result_Type, and derived year-month values.
lab_l3_n_unmap_loinc_agegrp_sex	LAB	L3	This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by agegroup and sex
lab_l3_n_unmap_loinc_all	LAB	L3	This dataset contains 1-way frequencies for all LOINCS where MS_Test_Name is UNMAPPED
lab_l3_n_unmap_loinc_ym	LAB	L3	This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by year-month
lab_l3_pt_loc	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_type, and Pt_Loc values.
lab_l3_range	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Modifier_low, Norm_range_low, Modifier_high, and Norm_Range_high values.
lab_l3_record_lrodt_ptloc_ym	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Pt_Loc and derived year-month values.
lab_l3_record_lrodt_ym	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, and derived year-month values.
lab_l3_stat	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, and stat values.
lab_l3_test_resultc_stats	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_Loc, MS_Result_C, and Orig_Result values.
lab_l3_test_resultn_stats_ms	LAB	L3	This dataset contains the statistical distribution and frequency of records where Result_type=N, stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_loc, Modifier, Orig_Result_unit, Std_Result_unit, and MS_Result_unit values.
lab_l3_test_resultn_stats_orig	LAB	L3	This dataset contains statistical distribution and frequency of records where Result_type=‘N’, stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_loc, Orig_Result_unit, Std_Result_unit, MS_Result_unit, and Modifier values.
lab_l3_times	LAB	L3	This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived Labtm, and derived Restm values.
pre_l2_orderdate_ym	PRE	L2	This dataset contains frequency of records stratified by year-month values.
pre_l2_rxdaw	PRE	L2	This dataset contains frequency of records stratified by RxDAW values.
pre_l2_rxdoseform	PRE	L2	This dataset contains frequency of records stratified by RxDoseForm values.
pre_l2_rxdosequantity	PRE	L2	This dataset contains frequency of records stratified by RxDoseQuantity values.
pre_l2_rxdoseunit	PRE	L2	This dataset contains frequency of records stratified by RxDoseUnit values.
pre_l2_rxfreqquantity	PRE	L2	This dataset contains frequency of records stratified by RxDoseQuantity values.
pre_l2_rxfrequnit	PRE	L2	This dataset contains frequency of records stratified by RxFreqUnit values.
pre_l2_rxprnflag	PRE	L2	This dataset contains frequency of records stratified by RxPrnFlag values.
pre_l2_rxrefills	PRE	L2	This dataset contains frequency of records stratified by RxRefills values.
pre_l2_rxroute	PRE	L2	This dataset contains frequency of records stratified by RxRoute values.
pre_l2_rxsource	PRE	L2	This dataset contains frequency of records stratified by RxSource values.
pre_l3_pt_orderdate_stats	PRE	L3	This dataset contains a statistical distribution of the number of ordered prescriptions per patient per day.
pre_l3_rx_pt_y_stats	PRE	L3	This dataset contains a statistical distribution of the number of recorded prescription orders per patient per year.
pre_l3_rxamt_rxsup	PRE	L3	This dataset contains frequency of records stratified by RxAmt and RxSup values.
pro_l2_px_pxtype_spec	PRO	L2	This dataset contains frequency of records stratified by PX_CodeType, PX, and Specialty values.
pro_l3_enctype_pxtype_ym	PRO	L3	This dataset contains frequency of records stratified by EncType, and PX_CodeType, and derived year-month values (YearMonth derived by PRO.adate for non IP/IS encounters, and ENC.ddate for IP/IS encounters).
pro_l3_px_per_enc_stats	PRO	L3	This dataset contains descriptive statistics for the frequency of procedures (distinct PX_CodeType and PX) per patient encounter.
prr_l3_response_dt_ym	PRR	L3	This dataset contains frequency of records stratified by derived year-month values.
prr_l3_response_freq	PRR	L3	This dataset contains the count of records stratified by PRM_Code, SurveyID, and QuestionVerID values.
prr_l3_sid_pt_ym_stats	PRR	L3	This dataset contains a statistical distribution of the number of surveys reported per patid per yearmonth.
prs_l3_prm_code_type_subtype	PRS	L3	This dataset contains a count of unique QuestionVerIDs stratified by PRM_Code, PRM_Type, and PRM_SubType values.
prs_l3_question_dt_ym	PRS	L3	This dataset contains frequency of records stratified by derived year-month values.
prs_l3_surveyid_ver_ym	PRS	L3	This dataset countains the frequency of records stratified by SurveyID, QuestionVerID, and derived year-month values.
pvd_l2_spec_spectype	PVD	L2	This dataset contains frequency of records stratified by Specialty_CodeType and Specialty values.
txn_l3_bloodgroup_ym	TXN	L3	This dataset contains the frequency of records stratified by bloodgroup and derived year-month values.
txn_l3_bloodtype_ym	TXN	L3	This dataset contains the frequency of records stratified by bloodtype and derived year-month values.
txn_l3_enctype_ym	TXN	L3	This dataset contains the frequency of records stratified by encType and derived year-month values.
txn_l3_tdate_start_ym	TXN	L3	This dataset contains the frequency of records stratified by tdate_start values as represented in year-month.
txn_l3_trans_duration_stats	TXN	L3	This dataset contains a statistical distribution of the duration of transfusion per derived year-month values.
txn_l3_trans_per_enc_stats	TXN	L3	This dataset contains a statistical distribution of encounters and transfusions per encounter and derived year-month values.
txn_l3_transcode_codetype_ym	TXN	L3	This datset contains frequency of records stratified by transcode, transcode_type, and derived year-month values.
vit_l2_bp_catvar_ym	VIT	L2	This dataset contains frequency of records stratified by blood pressure (BP) type, position, and derived year-month values.
vit_l2_tobacco_ym	VIT	L2	This dataset contains frequency of records stratified by tobacco, tobacco type, and derived year-month values.
vit_l3_measure_date_ym	VIT	L3	vit_l3_measure_date_ym
vit_l3_pt_ym_stats	VIT	L3	This datasets contains a statistical distribution of the number of patients and vital sign records per patient per year-month.
pre_l2_rx_rxtype_spec	PRE	l2	This dataset contains frequency of records stratified by RX_CodeType, RX, and Specialty values.
licensed			This metadata file contains DP-specific SAS component license status.
minmax_dates			This metadata file contains derived minimum and maximum dates for data completeness.
qa_cc_metadata			This metadata file contains DP-specific information about ETL number, phase, and SCDM table names.

8.1.1 all_l1_cont

This dataset contains resulting output from SAS proc contents for all SCDM tables, including table, variable, and engine/host attributes. All variables present, including any non-SCDM variables, will be included in the output.

Specification: all_l1_cont

Table 8.2: Specification: all_l1_cont

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
TABID	3 character abbreviation for source SCDM table	Char (3)			Source: inputfiles.control_flow.module Derivation: Where execute_flag=Y and cc_table ne X
LIBNAME	Library Name	Char (8)	Library Name		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
MEMNAME	Library Member Name	Char (32)	Library Member Name		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
MEMLABEL	Data Set Label	Char (256)	Data Set Label		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
TYPEMEM	Special Data Set Type (From TYPE=)	Char (8)	Special Data Set Type (From TYPE=)		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
NAME	Variable Name	Char (32)	Variable Name		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
TYPE	Variable Type	Num (8)	Variable Type		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
LENGTH	Variable Length	Num (8)	Variable Length		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
VARNUM	Variable Number	Num (8)	Variable Number		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
LABEL	Variable Label	Char (256)	Variable Label		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
FORMAT	Variable Format	Char (32)	Variable Format		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
FORMATL	Format Length	Num (8)	Format Length		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
FORMATD	Number of Format Decimals	Num (8)	Number of Format Decimals		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
INFORMAT	Variable Informat	Char (32)	Variable Informat		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
INFORML	Informat Length	Num (8)	Informat Length		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
INFORMD	Number of Informat Decimals	Num (8)	Number of Informat Decimals		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
JUST	Justification	Num (8)	Justification		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
NPOS	Position in Buffer	Num (8)	Position in Buffer		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
NOBS	Observations in Data Set	Num (8)	Observations in Data Set		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
ENGINE	Engine Name	Char (8)	Engine Name		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
CRDATE	Create Date	Num (8)	Create Date	DATETIME16.	Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
MODATE	Last Modified Date	Num (8)	Last Modified Date	DATETIME16.	Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
DELOBS	Deleted Observations in Data Set	Num (8)	Deleted Observations in Data Set		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
IDXUSAGE	Use of Variable in Indexes	Char (9)	Use of Variable in Indexes		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
MEMTYPE	Library Member Type	Char (8)	Library Member Type		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
IDXCOUNT	Number of Indexes for Data Set	Num (8)	Number of Indexes for Data Set		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
PROTECT	Password Protection (Read Write Alter)	Char (3)	Password Protection (Read Write Alter)		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
FLAGS	Update Flags (Protect Contribute Add)	Char (3)	Update Flags (Protect Contribute Add)		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
COMPRESS	Compression Routine	Char (8)	Compression Routine		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
REUSE	Reuse Space	Char (3)	Reuse Space		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
SORTED	Sorted and/or Validated	Num (8)	Sorted and/or Validated		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
SORTEDBY	Position of Variable in Sortedby Clause	Num (8)	Position of Variable in Sortedby Clause		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
CHARSET	Host Character Set	Char (8)	Host Character Set		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
COLLATE	Collating Sequence	Char (8)	Collating Sequence		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
NODUPKEY	Sort Option: No Duplicate Keys	Char (3)	Sort Option: No Duplicate Keys		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
NODUPREC	Sort Option: No Duplicate Records	Char (3)	Sort Option: No Duplicate Records		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
ENCRYPT	Encryption Routine	Char (8)	Encryption Routine		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
POINTOBS	Point to Observations	Char (3)	Point to Observations		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
GENMAX	Maximum Number of Generations	Num (8)	Maximum Number of Generations		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
GENNUM	Generation Number	Num (8)	Generation Number		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
GENNEXT	Next Generation Number	Num (8)	Next Generation Number		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
TRANSCOD	Character Variables Transcoded	Char (3)	Character Variables Transcoded		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
filesize	Size of File	Num (8)	Size of File		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
obslen	Observation Length	Num (8)	Observation Length		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
nvar	Number of Variables	Num (8)	Number of Variables		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
npage	Number of Pages	Num (8)	Number of Pages		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables
pcompress	Percent Compression	Num (8)	Percent Compression		Source: SCDM table metadata Derivation: SAS proc contents procedure performed on all DP SCDM tables

8.1.2 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

Table 8.3: Specification: all_l1_l2_flags

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
FlagID	Flag ID used by SOC to identify specific error checks across all SCDM tables	Char (21)			Source: inputfiles.lkp_all_flags.flagid	Unique FlagID = See Quality Checks
AbortYN	Indicates whether a flag will cause the Quality Assurance Package to abort, if thrown.	Char (1)	$1.		Source: inputfiles.lkp_all_flags.abortyn	Y = Flag will cause QA Package to abort N = Flag will not cause QA Package to abort
FlagType	FlagType	Char (4)			Source: inputfiles.lkp_all_flags.flagtype
Flag_Descr	Description of flag	Char (255)			Source: inputfiles.lkp_all_flags.flag _descr
count	Count of flagged records	Num (8)	COMMA15.		Derivation: Flag count may be record or PatID count. For cases where count is not applicable, use value ‘99999’
records_evaluated	Count of records evaluated by a given flag.	Num (8)	COMMA15.
Proportion flagged	Proportion of records where a flag is thrown. Calculated as count/records_evaluated.	Num (8)	COMMA15.

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

Table 8.4: Specification: all_l1_record_count

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
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. Used in combination with TabID to represent an unique SCDM variable.	Char (2)			Source: inputfiles.lkp_all_l1.varid
Variable	Variable name	Char (21)			Source: SCDM table
Count_Obs	Count of Table Records	Num (8)	COMMA15.	Count of Table Records
count_nomiss	Non-Missing Value Count	Num (8)	COMMA15.	Non-Missing Value Count
count_spmiss	Special Missing Value Count	Num (8)	COMMA15.	Special Missing Value Count
count_null	Count of null records (blank or missing)	Num (8)	COMMA15.	Null Value Count	Source: SCDM table

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

Table 8.5: Specification: all_l1_scdm_comp

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
TabID	3 character abbreviation for source SCDM table	Char (3)			Source: inputfiles.control_flow.module Derivation: Where execute_flag=Y and cc_table ne X
var	Variable name	Char (32)	Variable Name		Source: inputfiles.lkp_all_l1.variable |dplocal.l1_cont_{tabid}.name Derivation: Coalesce(variable,name)
VarID	SCDM variable ID assigned by SOC	Char (2)	SCDM Variable ID		Source: inputfiles.lkp_all_l1.varid
MS_var	YN indicator for variable that is expected as per SCDM	Char (1)	Variable expected?		Source: inputfiles.lkp_all_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.all_l1_cont
MS_type	Expected variable type	Char (1)	Expected variable type		Source: inputfiles.lkp_all_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_all_l1.varlength
DP_length	Observed length of variable in bytes	Num (3)	Actual variable length		Source: dplocal.l1_cont_{tabid}.length
format_length		Num (3)	Actual FORMATL value, if present
req_length	Required variable length	Num (8)

8.1.5 all_l2_crosstab_length_value

This dataset contains frequency of distinct observed value lengths stratified by table and cross-table variable (e.g. PatID).

Specification: all_l2_crosstab_length_value

Table 8.6: Specification: all_l2_crosstab_length_value

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
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
Variable	Variable name	Char (21)			Source: inputfiles.lkp_all_l1 Derivation: Variable where CrossTab=X
ValueLength	Observed value length in bytes	Num (3)			Source: {tabid}.{variable} Derivation: SAS LENGTHN function
count	Record Count	Num (8)	COMMA15.

8.1.6 all_l2_crosstab_length_var

This dataset contains a comparison of cross-table variable length across applicable tables.

Specification: all_l2_crosstab_length_var

Table 8.7: Specification: all_l2_crosstab_length_var

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
TabID1	3 character abbreviation for SCDM table associated with Variable1	Char (3)	TabID1		Source: inputfiles.control_flow.module Derivation: Where execute_flag=Y and cc_table ne X
TabID2	3 character abbreviation for SCDM table associated with Variable2	Char (3)	TabID2		Source: inputfiles.control_flow.module Derivation: Where execute_flag=Y and cc_table ne X
Variable	Variable name	Char (21)			Source: inputfiles.lkp_all_l1 Derivation: Where CrossTab=X
VarLength1	Variable1 length in bytes	Num (3)
VarLength2	Variable2 length in bytes	Num (3)

8.1.7 all_l2_encounterid_match

This dataset contains frequency of distinct EncounterID values stratified by binary indicator of presence by each utilization table.

Specification: all_l2_encounterid_match

Table 8.8: Specification: all_l2_encounterid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
ENC	Binary indicator for presence of EncounterID value in Encounter table	Char (1)			Source: ENC.encounterid Derivation: 1=True, 0=False
DIA	Binary indicator for presence of EncounterID value in Diagnosis table	Char (1)			Source: DIA.encounterid Derivation: 1=True, 0=False
PRO	Binary indicator for presence of EncounterID value in Procedure table	Char (1)			Source: PRO.encounterid Derivation: 1=True, 0=False
count	Count of unique EncounterID values per stratum	Num (8)	COMMA15.

8.1.8 all_l2_facilityid_match

This dataset contains frequency of distinct FacilityID values stratified by binary indicator of presence by each SCDM table.

Specification: all_l2_facilityid_match

Table 8.9: Specification: all_l2_facilityid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
FAC	Binary indicator for presence of FacilityID value in Facility table	Char (1)			Source: FAC.facilityid Derivation: 1=True, 0=False
ENC	Binary indicator for presence of FacilityID value in Encounter table	Char (1)			Source: ENC.facilityid Derivation: 1=True, 0=False
LAB	Binary indicator for presence of FacilityID value in Laboratory Results table	Char (1)			Source: LAB.facilityid Derivation: 1=True, 0=False
count	Count of unique FacilityID values per stratum	Num (8)	COMMA15.

8.1.9 all_l2_patid_match

This dataset contains frequency of distinct PatID values stratified by binary indicator of presence by each SCDM table.

Specification: all_l2_patid_match

Table 8.10: Specification: all_l2_patid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
ENR	Binary indicator for presence of PatID value in Enrollment table	Char (1)			Source: ENR.patid Derivation: 1=True, 0=False
DEM	Binary indicator for presence of PatID value in Demographic table	Char (1)			Source: DEM.patid Derivation: 1=True, 0=False
DIA	Binary indicator for presence of PatID value in Diagnosis table	Char (1)			Source: DIA.patid Derivation: 1=True, 0=False
DIS	Binary indicator for presence of PatID value in Dispensing table	Char (1)			Source: DIS.patid Derivation: 1=True, 0=False
DTH	Binary indicator for presence of PatID value in Death table	Char (1)			Source: DTH.patid Derivation: 1=True, 0=False
ENC	Binary indicator for presence of PatID value in Encounter table	Char (1)			Source: ENC.patid Derivation: 1=True, 0=False
LAB	Binary indicator for presence of PatID value in Laboratory Results table	Char (1)			Source: LAB.patid Derivation: 1=True, 0=False
PRO	Binary indicator for presence of PatID value in Procedure table	Char (1)			Source: PRO.patid Derivation: 1=True, 0=False
count	Count of unique PatID values per stratum	Num (8)	COMMA15.

8.1.10 all_l2_prm_code_match

This dataset contains frequency of distinct PRM_Code values stratified by binary indicator of presence in the PRR and PRS Tables.

Specification: all_l2_prm_code_match

Table 8.11: Specification: all_l2_prm_code_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PRS	Binary indicator for presence of PRM_Code value in Patient Reported Survey table.	Char (1)	$1.			1 = TRUE 0 = FALSE	2
PRR	Binary indicator for presence of PRM_Code value in Patient Reported Response table.	Char (1)	$1.			1 = TRUE 0 = FALSE	3
count	Count of unique PRM_Code values per stratum	Num (8)	COMMA15.				4

8.1.11 all_l2_providerid_match

This dataset contains frequency of distinct Provider values stratified by binary indicator of presence by each utilization table.

Specification: all_l2_providerid_match

Table 8.12: Specification: all_l2_providerid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PVD	Binary indicator for presence of Provider value in Provider table	Char (1)			Source: PVD.providerid Derivation: 1=True, 0=False
DIA	Binary indicator for presence of Provider value in Diagnosis table	Char (1)			Source: DIA.providerid	1 = TRUE 0 = FALSE
DIS	Binary indicator for presence of Provider value in Dispensing table	Char (1)			Source: DIS.providerid	1 = TRUE 0 = FALSE
PRO	Binary indicator for presence of Provider value in Procedure table	Char (1)			Source: PRO.providerid	1 = TRUE 0 = FALSE
count	Count of unique Provider values per stratum	Num (8)	COMMA15.

8.1.12 all_l2_questionid_match

This dataset contains frequency of distinct QuestionID values stratified by binary indicator of presence in the PRR and PRS Tables.

Specification: all_l2_questionid_match

Table 8.13: Specification: all_l2_questionid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PRS	Binary indicator for presence of QuestionID value in Patient Reported Survey table.	Char (1)	$1.			1 = TRUE 0 = FALSE	2
PRR	Binary indicator for presence of QuestionID value in Patient Reported Response table.	Char (1)	$1.			1 = TRUE 0 = FALSE	3
count	Count of unique QuestionID values per stratum	Num (8)	COMMA15.				4

8.1.13 all_l2_questionverid_match

This dataset contains frequency of distinct QuestionVerID values stratified by binary indicator of presence in the PRR and PRS Tables.

Specification: all_l2_questionverid_match

Table 8.14: Specification: all_l2_questionverid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PRS	Binary indicator for presence of QuestionVerID value in Patient Reported Survey table.	Char (1)	$1.			1 = TRUE 0 = FALSE	2
PRR	Binary indicator for presence of QuestionVerID value in Patient Reported Response table.	Char (1)	$1.			1 = TRUE 0 = FALSE	3
count	Count of unique QuestionVerID values per stratum	Num (8)	COMMA15.				4

8.1.14 all_l2_surveyid_match

This dataset contains frequency of distinct SurveyID values stratified by binary indicator of presence in the PRR and PRS Tables.

Specification: all_l2_surveyid_match

Table 8.15: Specification: all_l2_surveyid_match

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PRS	Binary indicator for presence of SurveyID value in Patient Reported Survey table.	Char (1)	$1.			1 = TRUE 0 = FALSE	2
PRR	Binary indicator for presence of SurveyID value in Patient Reported Response table.	Char (1)	$1.			1 = TRUE 0 = FALSE	3
count	Count of unique SurveyID values per stratum	Num (8)	COMMA15.				4

8.1.15 all_l3_dates_dist

This dataset contains one row per SCDM table date variable with date value distribution statistics.

Specification: all_l3_dates_dist

Table 8.16: Specification: all_l3_dates_dist

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
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
Variable	Date variable name	Char (12)			Source: {TABLE}.{date variable}
N	Frequency of unique date values	Num (8)	BEST4.		Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
Min	Minimum date value	Num (8)	YYMMDD10.	Minimum	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P1	1st percentile value for date variable	Num (8)	YYMMDD10.	1st Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P5	5th percentile value for date variable	Num (8)	YYMMDD10.	5th Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P25	25th percentile value for date variable	Num (8)	YYMMDD10.	25th Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
Median	Median date value	Num (8)	YYMMDD10.		Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P75	75th percentile value for date variable	Num (8)	YYMMDD10.	75th Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P95	95th percentile value for date variable	Num (8)	YYMMDD10.	95th Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
P99	99th percentile value for date variable	Num (8)	YYMMDD10.	99th Pctl	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means
Max	Maximum date value	Num (8)	YYMMDD10.	Maximum	Source: {TABLE}.{date variable} Derivation: Value as calculated by SAS Proc Means

8.1.16 all_l3_summary

This dataset contains one row per SCDM table and summarizes key table and variable data.

Specification: all_l3_summary

Table 8.17: Specification: all_l3_summary

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
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	SAS Member type (either data or view)	Char (4)			Source: SAS metadata
AllRec	Total record count per table	Num (8)	COMMA15.		Source: dplocal.l1_cont_{tabid}.nobs
DupRec	Number of duplicate records by key values by table	Num (8)	COMMA15.		Source: {TABLE}.{key variables} Derivation: Proc sort nodupkey, key variables indicated in inputfiles.lkp_all_l1.keyvar
patid	Count of unique PatID values per table	Num (8)	COMMA15.		Source: {TABLE}.patid
encounterid	Number of unique EncounterID values by table	Num (8)	COMMA15.		Source: {TABLE}.encounterid
providerid	Count of unique ProviderID values per table	Num (8)	COMMA15.		Source: {TABLE}.providerid
facilityid	Count of unique FacilityID values per table	Num (8)	COMMA15.		Source: {TABLE}.facilityid
MinDate	Derived minimum date of data completeness	Num (8)	YYMMDD10.		Source: msoc.minmax_dates.dp _mindate Derivation: See functional specs
MaxDate	Derived maximum date of data completeness	Num (8)	YYMMDD10.		Source: msoc.minmax_dates.dp _maxdate Derivation: See functional specs

8.1.17 all_l3_survey_dist

NA

Specification: all_l3_survey_dist

Table 8.18: Specification: all_l3_survey_dist

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP		Char (6)			1
PRM_CODE		Num (8)			2
Survey_Name		Char (25)	$25.		3
n_surveyid		Num (8)			4

8.1.18 alltable_signature

This metadata file contains summarized request-level metadata and basic benchmarking statistics after all modules have completed.

Specification: alltable_signature

Table 8.19: Specification: alltable_signature

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Variable	Metadata Variable	Char (16)	Metadata Variable		Source: See functional specs
Value	Metadata Value	Char (36)			Source: See functional specs

8.1.19 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

Table 8.20: 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	Unique FlagID = See Quality Checks
AbortYN	Indicates QA package abort status (Y or N) for each FlagID	Char (1)			Source: all_l1_l2_flags
FlagType	FlagType	Char (4)			Source: all_l1_l2_flags
Flag_Descr	Description of flag	Char (255)			Source: all_l1_l2_flags
count_ETL-1	Count of flagged records from the previous ETL	Num (8)	COMMA15.		Source: inputfiles.all_l1_l2_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 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

8.1.20 module_signature

This metadata file contains module-level metadata and basic benchmarking statistics after each module has completed. Module will be replaced with the appropriate module name—e.g., l1_signature, enr_signature.

Specification: module_signature

Table 8.21: Specification: module_signature

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Variable	Metadata variable	Char (14)			Source: See functional specs
Value	Metadata value	Char (22)			Source: See functional specs

8.1.21 cod_l2_cod_codetype

This dataset contains frequency of records stratified by CodeType and COD values.

Specification: cod_l2_cod_codetype

Table 8.22: Specification: cod_l2_cod_codetype

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
COD	Observed COD values	Char (8)	$8.		Source: COD.COD
CodeType	Observed Codetype values	Char (2)	$2.		Source: COD.Codetype
count	Record Count per stratum	Num (8)	COMMA15.

8.1.22 cod_l3_catvars

This dataset contains frequency of records stratified by CauseType, Confidence, and Source values.

Specification: cod_l3_catvars

Table 8.23: Specification: cod_l3_catvars

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
CauseType	Observed CauseType values	Char (1)	$1.		Source: COD.CauseType
Confidence	Observed Confidence values	Char (1)	$1.		Source: COD.Confidence
Source	Observed Source values	Char (1)	$1.		Source: COD.Source
count	Record count per stratum	Num (8)	COMMA15.

8.1.23 control_flow_3

This metadata file is a modified version of the “control_flow” input file, limited to DP-specific SCDM tables to evaluate.

Specification: control_flow_3

Table 8.24: Specification: control_flow_3

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
module	Abbreviated module identification	Char (5)	$5.		Source: inputfiles.control_flow Derivation: Lowcase(module)
execute_flag	Module execution flag/indicator (YN)	Char (1)	$1.		Source: inputfiles.control_flow Derivation: Lowcase(execute_flag)
sascode	Name of each .sas program to be executed	Char (45)	$45.		Source: inputfiles.control_flow
cc_table	Name of CC table variables, if applicable	Char (12)	$12.		Source: CC table macro variable for each table Derivation: Populated as ‘X’ for non-table modules (e.g. Level1)
seqno	Order of module execution	Num (8)	BEST.		Source: inputfiles.control_flow
module_cat	Module category/type (Core, Labs, Level 1, Level 2, Level 3)	Char (10)	$10.		Source: inputfiles.control_flow Derivation: Lowcase(module_cat)
module_util	Utilization table indicator (YN)	Char (1)	$1.		Source: inputfiles.control_flow Derivation: Lowcase(module_util)
unique_id	Base table for each ID variable	Char (15)	$15.		Source: inputfiles.control_flow Derivation: Lowcase(unique_id)
module_required	Derived indicator of module execution	Char (1)			Source: inputfiles.control_flow.execution _flag|CC Derivation: See functional specs

8.1.24 dem_l3_agecat

This dataset contains frequency of records stratified by derived (using DP_MaxDate) age group category.

Specification: dem_l3_agecat

Table 8.25: Specification: dem_l3_agecat

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Age_group	Age group	Char (16)			Source: DEM.birth_date|DP Max Date Derivation: Age in years, as calculated by the Kreuter method, grouped into the following: 0-1 yrs, 2-4 yrs, 5-9 yrs, 10-14 yrs, 15-18 yrs, 19-21 yrs, 22-44 yrs, 45-64 yrs, 65-74 yrs, 75+ yrs. See functional specs for more information.
count	Record count per stratum	Num (8)	COMMA15.

8.1.25 dem_l3_ageyr_stats

This dataset contains the statistical distribution of derived (using DP_MaxDate) age in years.

Specification: dem_l3_ageyr_stats

Table 8.26: Specification: dem_l3_ageyr_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Variable	Name of source variable	Char (9)
N	Frequency of unique values of age in years	Num (8)	BEST3.		Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
Mean	Mean value of age in years	Num (8)	F8.1		Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
std	Standard deviation value of age in years	Num (8)	F8.1	Std Dev	Source: DEM.birth_date|DP Max Date
Min	Minimum value of age in years	Num (8)	F8.1	Minimum	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P1	1st percentile value of age in years	Num (8)	F8.1	1st Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P5	5th percentile value of age in years	Num (8)	F8.1	5th Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P25	25th percentile value of age in years	Num (8)	F8.1	25th Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
Median	Median value of age in years	Num (8)	F8.1		Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P75	75th percentile value of age in years	Num (8)	F8.1	75th Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P95	95th percentile value of age in years	Num (8)	F8.1	95th Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
P99	99th percentile value of age in years	Num (8)	F8.1	99th Pctl	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means
Max	Maximum value of age in years	Num (8)	F8.1	Maximum	Source: DEM.birth_date|DP Max Date Derivation: Value as calculated by SAS Proc Means

8.1.26 dem_l3_catvars

This dataset contains frequency of records stratified by sex, race, Hispanic, imputedRace and ImputedHispanic values.

Specification: dem_l3_catvars

Table 8.27: Specification: dem_l3_catvars

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Sex	Observed Sex values	Char (1)	$1.		Source: DEM.sex	For a list of valid values, please refer to the SCDM Demographic Table documentation
Hispanic	Observed Hispanic values	Char (1)	$1.		Source: DEM.hispanic	For a list of valid values, please refer to the SCDM Demographic Table documentation
Race	Observed Race values	Char (1)	$1.		Source: DEM.race	For a list of valid values, please refer to the SCDM Demographic Table documentation
ImputedHispanic	Observed ImputedHispanic values	Char (1)	$1.		Source: DEM.ImputedHispanic	For a list of valid values, please refer to the SCDM Demographic Table documentation
ImputedRace	Observed ImputedRace values	Char (1)	$1.		Source: DEM.ImputedRace	For a list of valid values, please refer to the SCDM Demographic Table documentation
count	Record count per stratum	Num (8)	COMMA15.

8.1.27 dem_l3_zip_state

This dataset contains frequency of records stratified by derived state associated with observed ZIP code values.

Specification: dem_l3_zip_state

Table 8.28: Specification: dem_l3_zip_state

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Zip_State	The state abbreviation associated with the 5-digit ZIP code	Char (7)			Source: DEM.postalcode_date Derivation: Assigned based on ZIP code to state matching in lookup table
count	Record count per stratum	Num (8)	COMMA15.

8.1.28 dem_l3_zip_verify_y

This dataset contains frequency of records stratified by ZIP code validation status by derived ZIP_Date year values. Validation status refers to whether a ZIP code is valid or invalid at the time of review.

Specification: dem_l3_zip_verify_y

Table 8.29: Specification: dem_l3_zip_verify_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Year	Derived Year values	Char (4)			Source: DEM.postalcode_date Derivation: Convert numeric date to a character value representing the corresponding year
Zip_Check	ZIP Code value validation	Char (7)			Source: DEM.postalcode|inputfiles.lkp_dem_zip Derivation: Assigned as ‘Blank’, ‘Valid’, or ‘Invalid’, based on ZIP Code lookup table
count	Record count per stratum	Num (8)	COMMA15.

8.1.29 dem_l3_zip_y

This dataset contains frequency of records stratified by masked ZIP codes by derived year values. ZIP_masked variable is based on the value format and length of the source zip variable at the time of review.

Specification: dem_l3_zip_y

Table 8.30: Specification: dem_l3_zip_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Year	Derived Year values	Char (4)			Source: DEM.postalcode_date Derivation: Convert numeric date to a character value representing the corresponding year
Zip_masked	Masked (de-identified) ZIP Code value	Char (5)			Source: DEM.postalcode Derivation: Substitute ‘N’ for numeric digit, ‘a’ for alpha or special character, and ’_’ for leading, embedded, or trailing space
count	Record count per stratum	Num (8)	COMMA15.

8.1.30 dia_l2_dx_dxtype_spec

This dataset contains frequency of records stratified by DX_CodeType, DX, and Specialty values.

Specification: dia_l2_dx_dxtype_spec

Table 8.31: Specification: dia_l2_dx_dxtype_spec

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Dx_CodeType	Observed Dx_codetype values	Char (2)	$2.		Source: DIA.dx_codetype
Dx	Observed DX values	Char (7)	$7.		Source: DIA.dx
Specialty	Observed provider Specialty values	Char (10)	$10.		Source: PVD.Specialty Derivation: Requires merge betweren DIA and PVD on ProviderID to attach Specialty for matching records.
count	Record count per stratum	Num (8)	COMMA15.

8.1.31 dia_l2_enc_dxtype_pdx_ym

This dataset contains frequency of records stratified by EncType, DX_CodeType, and PDX values and derived year-month values (YearMonth derived by DIA.adate for non IP/IS encounters, and ENC.ddate for IP/IS encounters).

Specification: dia_l2_enc_dxtype_pdx_ym

Table 8.32: Specification: dia_l2_enc_dxtype_pdx_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: DIA.adate|ENC.ddate Derivation: Convert numeric date to a character value representing the corresponding year-month
EncType	Observed Enctype values	Char (2)	$2.		Source: DIA.enctype
Dx_CodeType	Observed Dx_codetype values	Char (2)	$2.		Source: DIA.dx_codetype
PDX	Observed PDX values	Char (1)	$1.		Source: DIA.pdx
count	Record Count per stratum	Num (8)	COMMA15.

8.1.32 dia_l3_dx_per_enc_stats

This dataset contains descriptive statistics for the frequency of diagnoses (distinct DX_CodeType and DX) per patient encounter.

Specification: dia_l3_dx_per_enc_stats

Table 8.33: Specification: dia_l3_dx_per_enc_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
enc	Frequency of unique encounters	Num (8)	COMMA15.		Source: DIA.patid|encounterid
dxs	Frequency of unique diagnoses	Num (8)	COMMA15.		Source: DIA.dx_codetype|dx
mean	Mean value of unique diagnoses per encounter	Num (8)	F10.2		Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
std	Standard deviation value of unique diagnoses per encounter	Num (8)	F10.2		Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
min	Minimum value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
median	Median value of unique diagnoses per encounter	Num (8)	F10.1		Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means
max	Maximum value of unique diagnoses per encounter	Num (8)			Source: DIA.patid|encounterid|dx _codetype|dx Derivation: Value as calculated by SAS Proc Means

8.1.33 dia_l3_padmit

This dataset contains the frequency of records stratified by PAdmit values.

Specification: dia_l3_padmit

Table 8.34: Specification: dia_l3_padmit

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Padmit	Observed Padmit values	Char (1)	$1.		Source: DIA.padmit
count	Record count per stratum	Num (8)	COMMA15.

8.1.34 dis_l2_rx_rxtype_spec

This dataset contains combinations of Rx, Rx_CodeType, and Specialty values.

Specification: dis_l2_rx_rxtype_spec

Table 8.35: Specification: dis_l2_rx_rxtype_spec

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
row	Row number assigned after sorting summarized dataset by descending record count per stratum	Num (8)
Rx_CodeType	Observed Rx_CodeType values	Char (2)
Rx	Observed Rx values	Char (11)
Specialty	Observed provider Specialty values	Char (10)	$10.	CMS Specialty Codes of the Provider	Source: PVD.Specialty Derivation: Requires merge betweren DIS and PVD on ProviderID to attach Specialty for matching records.

8.1.35 dis_l2_rxamt_rxsup

This dataset contains the frequency of records stratified by RxAmt and RxSup values. It has replaced the now obsolete dis_l3_rxamt and dis_l3_rxsup datasets.

Specification: dis_l2_rxamt_rxsup

Table 8.36: Specification: dis_l2_rxamt_rxsup

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
RxSup	Observed RxSup values	Num (4)			Source: DIS.rxsup
RxAmt	Observed Rxamt values	Num (4)			Source: DIS.rxamt
count	Record count per stratum	Num (8)	COMMA15.

8.1.36 dis_l3_rx_pt_y_stats

This dataset contains the statistical distribution of frequency of unique dispensings per member stratified by derived year values.

Specification: dis_l3_rx_pt_y_stats

Table 8.37: Specification: dis_l3_rx_pt_y_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Year	Derived Year values	Char (7)			Source: DIS.rxdate Derivation: Convert numeric date to a character value representing the corresponding year-month
n_ptyr	Count of unique patients by year	Num (8)	COMMA15.		Source: DIS.patid|rxdate
n_rx	Count of unique dispensings by year	Num (8)	COMMA15.		Source: DIS.patid|rxdate|rx_codetype|rx
Mean	Mean value of unique dispensings per patient by year	Num (8)	F10.2		Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
Std	Standard deviation of unique dispensings per patient by year	Num (8)	F10.2	Std Dev	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
Min	Minimum value of unique dispensings per patient by year	Num (8)	F10.1	Minimum	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P1	1st percentile value of unique dispensings per patient by year	Num (8)	F10.1	1st Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P5	5th percentile value of unique dispensings per patient by year	Num (8)	F10.1	5th Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P25	25th percentile value of unique dispensings per patient by year	Num (8)	F10.1	25th Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
Median	Median value of unique dispensings per patient by year	Num (8)	F10.1		Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P75	75th percentile value of unique dispensings per patient by year	Num (8)	F10.1	75th Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P95	95th percentile value of unique dispensings per patient by year	Num (8)	F10.1	95th Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
P99	99th percentile value of unique dispensings per patient by year	Num (8)	F10.1	99th Pctl	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means
Max	Maximum value of unique dispensings per patient by year	Num (8)	F10.1	Maximum	Source: DIS.patid|rxdate|rx_codetype|rx Derivation: Value as calculated by SAS Proc Means

8.1.37 dis_l3_rxdate_ym

This dataset contains frequency of records stratified by derived year-month values.

Specification: dis_l3_rxdate_ym

Table 8.38: Specification: dis_l3_rxdate_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: DIS.rxdate Derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.

8.1.38 dth_l3_catvars

This dataset contains frequency of records stratified by dtimpute, source, and confidence values.

Specification: dth_l3_catvars

Table 8.39: Specification: dth_l3_catvars

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
DtImpute	Observed Dtimpute values	Char (1)	$1.		Source: DTH.dtimpute
Source	Observed Source values	Char (1)	$1.		Source: DTH.source
Confidence	Observed Confidence values	Char (1)	$1.		Source: DTH.confidence
count	Record Count per stratum	Num (8)	COMMA15.

8.1.39 dth_l3_dthdt_ym

This dataset contains frequency of records stratified by derived year-month values.

Specification: dth_l3_dthdt_ym

Table 8.40: Specification: dth_l3_dthdt_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: DTH.deathdt Derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.

8.1.40 enc_l2_enctype_admit_dc

This dataset contains frequency of records stratified by EncType, Admitting_Source, discharge_disposition, and discharge_status values.

Specification: enc_l2_enctype_admit_dc

Table 8.41: Specification: enc_l2_enctype_admit_dc

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
Admitting_Source	Observed Admitting_source values	Char (2)	$2.		Source: ENC.admitting_source
Discharge_Disposition	Observed Discharge_disposition values	Char (1)	$1.		Source: ENC.discharge_disposition
Discharge_Status	Observed Discharge_status values	Char (2)	$2.		Source: ENC.discharge_status
count	Record Count per stratum	Num (8)	COMMA15.

8.1.41 enc_l2_enctype_dc_ddate_spmiss

This dataset contains frequency of records stratified by EncType, Discharge_Disposition, and Discharge_Status by DDate population status. Population status refers to whether a DDate is present, missing, or populated with a special missing value.

Specification: enc_l2_enctype_dc_ddate_spmiss

Table 8.42: Specification: enc_l2_enctype_dc_ddate_spmiss

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
Discharge_Disposition	Observed Discharge_disposition values	Char (1)	$1.		Source: ENC.discharge_disposition
Discharge_Status	Observed Discharge_status values	Char (2)	$2.		Source: ENC.discharge_status
ddate_check	Ddate value population status	Char (14)			Source: ENC.Ddate Derivation: Assigned as ‘Ddate null’, ‘Ddate present’, or ‘Not discharged’
count	Record Count per stratum	Num (8)	COMMA15.

8.1.42 enc_l2_enctype_ddate_ym

This dataset contains frequency of records stratified by EncType and Ddate year-month values.

Specification: enc_l2_enctype_ddate_ym

Table 8.43: Specification: enc_l2_enctype_ddate_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.ddate Derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.

8.1.43 enc_l2_enctype_drg_drgtype

This dataset contains frequency of records stratified by EncType, DRG, and DRG_Type values.

Specification: enc_l2_enctype_drg_drgtype

Table 8.44: Specification: enc_l2_enctype_drg_drgtype

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
DRG	Observed DRG values	Char (3)	$3.		Source: ENC.drg
DRG_Type	Observed DRG_type values	Char (1)	$1.		Source: ENC.drg_type
count	Record Count per stratum	Num (8)	COMMA15.

8.1.44 enc_l2_enctype_drgtype_ym

This dataset contains frequency of records stratified by EncType, DRG_Type, and Adate year-month values.

Specification: enc_l2_enctype_drgtype_ym

Table 8.45: Specification: enc_l2_enctype_drgtype_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
DRG_Type	Observed DRG_type values	Char (1)	$1.		Source: ENC.drg_type
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.adate Derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.

8.1.45 enc_l2_enctype_spmiss_ddate_ym

This dataset contains frequency of records stratified by EncType, Adate (year-month), where Ddate = “.S”.

Specification: enc_l2_enctype_spmiss_ddate_ym

Table 8.46: Specification: enc_l2_enctype_spmiss_ddate_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.adate Derivation: Convert numeric date to a character value representing the corresponding year-month
DDate	Observed special missing value for patients still in facility (should be IP or IS)	Num (4)	MMDDYY10.		Source: ENC.ddate
count	Record Count per stratum	Num (8)	COMMA15.

8.1.46 enc_l3_enctype_los_ym

This dataset contains frequency of records stratified by EncType, derived length of stay (LOS), and Adate year-month values.

Specification: enc_l3_enctype_los_ym

Table 8.47: Specification: enc_l3_enctype_los_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.adate Derivation: Convert numeric date to a character value representing the corresponding year-month
LOS	Derived length of stay for a unique encounter	Num (8)		Length of Stay	Source: ENC.enctype|ddate|encounterid |adate Derivation: Ddate-Adate + 1
count	Record Count per stratum	Num (8)	COMMA15.

8.1.47 enc_l3_enctype_pt_ym_stats

This dataset contains the statistical distribution of unique EncounterIDs per PatID stratified by EncType and derived Adate year-month values.

Specification: enc_l3_enctype_pt_ym_stats

Table 8.48: Specification: enc_l3_enctype_pt_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
EncType	d	Char (2)	$2.		Source: ENC.enctype
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.adate Derivation: Convert numeric date to a character value representing the corresponding year-month
n_patid		Num (8)	COMMA15.
records	Frequency of unique encounter records by enctype and year-month	Num (8)	COMMA15.		Source: ENC.enctype|adate
mean	Mean number of encounters per patient by enctype and year-month	Num (8)	F10.2		Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
std	Standard deviation of number of encounters per patient by enctype and year-month	Num (8)	F10.2		Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
min	The minimum value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p1	d	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
median	Median value of number of encounters per patient by enctype and year-month	Num (8)	F10.1		Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means
max	Maximum number of unique encounters per patient by enctype and year-month	Num (8)			Source: ENC.patid|enctype|adate Derivation: Value as calculated by SAS Proc Means

8.1.48 enc_l3_pt_ym_stats

This dataset contains statistical distribution of unique EncounterID per PatID stratified by derived Adate year-month values.

Specification: enc_l3_pt_ym_stats

Table 8.49: Specification: enc_l3_pt_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: ENC.adate Derivation: Convert numeric date to a character value representing the corresponding year-month
n_patid		Num (8)	COMMA15.
records	Frequency of unique encounter records by year-month	Num (8)	COMMA15.		Source: ENC.adate
mean	Mean number of unique encounters per patient by year-month	Num (8)	F10.2		Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
std	Standard deviation of number of encounters per patient by enctype and year-month	Num (8)	F10.2		Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
min	Minimum number of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
median	Median number of unique encounters per patient by year-month	Num (8)	F10.1		Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means
max	Maximum number of unique encounters per patient by year-month	Num (8)			Source: ENC.patid|adate Derivation: Value as calculated by SAS Proc Means

8.1.49 enr_l2_enrstart_agedayscat

This dataset contains frequency of unique patient counts stratified by year of earliest enrollment span and age in days at its start.

Specification: enr_l2_enrstart_agedayscat

Table 8.50: Specification: enr_l2_enrstart_agedayscat

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Year	Derived Year values	Char (4)			Source: ENR.enr_start Derivation: Algorithm selects single, earliest value per distinct PatID
agedays_group	Categories for age in days per earliest enrollment span per PatID	Char (16)			Source: ENR.enr_start|DEM.birth_date	< 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 PatID	Num (8)

8.1.50 enr_l2_overlap

This dataset contains frequency of overlapping enrollment spans and unique PatID stratified by derived overlap subtypes (Duplicate, Subset, or Overlap).

Specification: enr_l2_overlap

Table 8.51: Specification: enr_l2_overlap

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
DateConflict	Indicator of date overlap category (Overlap, Duplicate, or Subset)	Char (12)			Source: ENR.patid|enr_start|enr_end Derivation: See functional specs
CountType	Indicator of count type (Record or Unique PatID)	Char (15)
count	Record Count per stratum	Num (8)

8.1.51 enr_l3_catvars

This dataset contains frequency of records stratified by MedCov, DrugCov, Chart, PlanType, and PayerType values.

Specification: enr_l3_catvars

Table 8.52: Specification: enr_l3_catvars

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PlanType	Observed PlanType values.	Char (1)	$1		Source: ENR.PlanType
PayerType	Observed Payer Type Values	Char (2)	$2		Source: ENR.PayerType

8.1.52 enr_l3_chart_y

This dataset contains frequency of records stratified by chart and Enr_Start year values, with no exclusion of records by med or DrugCov.

Specification: enr_l3_chart_y

Table 8.53: Specification: enr_l3_chart_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Year	Derived Year values	Char (4)			Source: ENR.enr_start Derivation: Convert numeric date to a character value representing the corresponding year
Chart	Observed Chart values	Char (1)	$1.	Chart abstraction flag.	Source: ENR.chart
count	Record Count per stratum	Num (8)	COMMA15.

8.1.53 enr_l3_covtype_chart

This dataset contains frequency of records stratified by MedCov, DrugCov, and chart values.

Specification: enr_l3_covtype_chart

Table 8.54: Specification: enr_l3_covtype_chart

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MedCov	Observed Medcov values	Char (1)	$1.	Medical Coverage Indicator.	Source: ENR.medcov
DrugCov	Observed Drugcov values	Char (1)	$1.	Drug Coverage Indicator.	Source: ENR.drugcov
Chart	Observed Chart values	Char (1)	$1.	Chart abstraction flag.	Source: ENR.chart
count	Record Count per stratum	Num (8)	COMMA15.

8.1.54 enr_l3_covtype_duration

This dataset contains frequency of unique members stratified by total coverage duration in months and coverage type, where MedCov and DrugCov = “Y.”

Specification: enr_l3_covtype_duration

Table 8.55: Specification: enr_l3_covtype_duration

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Months	Observed cumulative coverage duration in months per member	Num (8)			Source: ENR.patid|enr_start|enr_end Derivation: Sum of all enrollment spans (consecutive and/or non-consecutive) by coverage type per member
Count_Med	Count of unique members with active Medical coverage per stratum	Num (8)	COMMA15.		Source: ENR.patid|medcov|enr_start|enr _end Derivation: Where medcov=‘Y’
Count_Drug	Count of unique members with active Drug coverage per stratum	Num (8)	COMMA15.		Source: ENR.patid|drugcov|enr_start|enr _end Derivation: Where drugcov=‘Y’
Count_MedDrug	Count of unique members with active Medical and Drug coverage per stratum	Num (8)	COMMA15.		Source: ENR.patid|medcov|drugcov|enr _start|enr_end Derivation: Where medcov=‘Y’ and drugcov=‘Y’

8.1.55 enr_l3_enrmd_ym

This dataset contains frequency of records with medical and/or drug coverage stratified by derived year-month of enrollment. This is determined by whether at least one day within an enrollment span crosses a year-month.

Specification: enr_l3_enrmd_ym

Table 8.56: Specification: enr_l3_enrmd_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: ENR.enr_start Derivation: Convert numeric date to a character value representing the corresponding year-month
med	Count of enrollment records with medical drug coverage by year-month	Num (8)	COMMA15.		Source: ENR.enr_start|enr_end|medcov Derivation: Frequency of active enrollment records where medcov=Y per year-month
drug	Count of enrollment records with active drug coverage by year-month	Num (8)	COMMA15.		Source: ENR.enr_start|enr_end|drugcov Derivation: Frequency of active enrollment records where drugcov=Y per year-month
meddrug	Count of enrollment records with active medical and drug coverage by year-month	Num (8)	COMMA15.		Source: ENR.enr_start|enr_end|drugcov |medcov Derivation: Frequency of active enrollment records where medcov and drugcov=Y per year-month

8.1.56 enr_l3_mdcov_months_stats

This dataset contains the statistical distribution on total duration, across all enrollment spans, of combined active medical and drug coverage (in months) by unique member.

Specification: enr_l3_mdcov_months_stats

Table 8.57: Specification: enr_l3_mdcov_months_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
members	Frequency of unique members	Num (8)	COMMA15.		Source: ENR.patid
meddrug	Total duration in months of active medical and drug coverage	Num (8)	COMMA15.		Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
mean	The mean duration in months of medical and drug coverage per member	Num (8)	F10.2		Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
std	Standard deviation of the duration in months of medical and drug coverage per member	Num (8)	F10.2		Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
min	Minimum duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p1	1st percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p5	5th percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p25	25th percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
median	Median duration in months of medical and drug coverage per member	Num (8)	F10.1		Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p75	75th percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p95	95th percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
p99	99th percentile value for duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means
max	The maximum duration in months of medical and drug coverage per member	Num (8)			Source: msoc.enr_l3_covtype_duration .months|count_meddrug Derivation: Value as calculated by SAS Proc Means

8.1.57 etl_version

This metadata file contains the number of the ETL under review.

Specification: etl_version

Table 8.58: Specification: etl_version

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
ETL	ETL number	Num (8)			Source: qa package master file Derivation: &ETL

8.1.58 irx_l3_ndc

This dataset contains frequency of records stratified by ndc values.

Specification: irx_l3_ndc

Table 8.59: Specification: irx_l3_ndc

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
NDC	NDC code	Char (11)	$11.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.59 irx_l3_rx_enc_ym_stats

This dataset contains statistical distribution of encounters and rx per encounter, stratified by derived year-month.

Specification: irx_l3_rx_enc_ym_stats

Table 8.60: Specification: irx_l3_rx_enc_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
n_enc	Count of unique EncounterID values per stratum	Num (8)	COMMA15.		3	source: IRX.encounterid derivation: Value as calculated by SAS Proc Means
n_rx	Count of unique RxID values per stratum	Num (8)	COMMA15.		4	source: IRX.rxadate derivation: Value as calculated by SAS Proc Means
mean	The mean number of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.2		5	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
std	The mean number of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.2		6	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
min	The minimum number of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		7	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		8	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		9	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		10	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
median	The median number of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		11	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		12	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		13	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1		14	source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
max	The maximum number of inpatient pharmacy dispensings per encounterID per stratum	Num (8)	F10.1			source: IRX.encounterid|rxid|rxadate derivation: Value as calculated by SAS Proc Means

8.1.60 irx_l3_rx_pt_ym_stats

This dataset contains statistical distribution of patid and rx per patid, stratified by derived year-month.

Specification: irx_l3_rx_pt_ym_stats

Table 8.61: Specification: irx_l3_rx_pt_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
n_pt	Count of unique PatID values per stratum	Num (8)	COMMA15.		3	source: IRX.patid derivation: Value as calculated by SAS Proc Means
n_rx	Count of unique RxID values per stratum	Num (8)	COMMA15.		4	source: IRX.rxid derivation: Value as calculated by SAS Proc Means
mean	The mean number of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.2		5	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
std	The mean number of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.2		6	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
min	The minimum number of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		7	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		8	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		9	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		10	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
median	The median number of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		11	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		12	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		13	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1		14	source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means
max	The maximum number of inpatient pharmacy dispensings per patID per stratum	Num (8)	F10.1			source: IRX.patid|rxid|rxadate derivation: Value as calculated by SAS Proc Means

8.1.61 irx_l3_rxadate_ym

This dataset contains frequency of records stratified by rxadate as represented in year-month values.

Specification: irx_l3_rxadate_ym

Table 8.62: Specification: irx_l3_rxadate_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
count	Count of unique RxDate values per stratum	Num (8)	COMMA15.		3

8.1.62 irx_l3_rxatime_hour

This dataset contains frequency of records stratified by rxatime as represented in year-month values.

Specification: irx_l3_rxatime_hour

Table 8.63: Specification: irx_l3_rxatime_hour

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
hour	Derived hour value	Num (3)	Z2.		2
count	Count of unique RxAtime values per stratum	Num (8)	COMMA15.		3

8.1.63 irx_l3_rxatime_ym_stats

This dataset contains the statistical distribution of dispensing time of day by derived year-month.

Specification: irx_l3_rxatime_ym_stats

Table 8.64: Specification: irx_l3_rxatime_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
N	Count of unique RxAtime values per stratum	Num (8)	COMMA15.		3	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
Mean	The mean number of inpatient pharmacy dispensings per rxATime and stratum.	Num (8)	HHMM5.		4	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
Std	The standard deviation of the number of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	Std Dev	5	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
Min	The minimum number of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	Minimum	6	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P1	1st percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	1st Pctl	7	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P5	5th percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	5th Pctl	8	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P25	25th percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	25th Pctl	9	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
Median	The median number of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.		10	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P75	75th percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	75th Pctl	11	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P95	95th percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	95th Pctl	12	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
P99	99th percentile value of inpatient pharmacy dispensings per rxATime per stratum	Num (8)	HHMM5.	99th Pctl	13	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means
Max	The maximum number of inpatient pharmacy dispensings per patID per stratum	Num (8)	HHMM5.	Maximum	14	source: IRX.rxatime|rxadate derivation: Value as calculated by SAS Proc Means

8.1.64 irx_l3_rxdose_ym

This dataset contains frequency of records stratified by rxdose and derived year-month values.

Specification: irx_l3_rxdose_ym

Table 8.65: Specification: irx_l3_rxdose_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
RxDose	Observed RxDose values	Num (8)			3
count	Count of unique RxDose values per stratum	Num (8)	COMMA15.		4

8.1.65 irx_l3_rxroute_ym

This dataset contains frequency of records stratified by rxroute and derived year-month values.

Specification: irx_l3_rxroute_ym

Table 8.66: Specification: irx_l3_rxroute_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month value	Char (7)			2
RxRoute	Observed RxRoute values	Char (10)	$10.		3
count	Count of unique RxRoute values per stratum	Num (8)	COMMA15.		4

8.1.66 lab_l2_mapped_tests

NA

Specification: lab_l2_mapped_tests

Table 8.67: Specification: lab_l2_mapped_tests

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP		Char (6)			1
MS_Test_Name		Char (20)	$20.		2
Result_Type		Char (1)	$1.		3
LOINC		Char (10)	$10.	LOINC Code	4
n		Num (8)			5

8.1.67 lab_l2_ms_result

This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Result_type, Fast_ind, Specimen_Source, LOINC, MS_Result_C, MS_Result_N, Modifier, and MS_Result_unit values, excluding records where result type=C for any numeric-only test.

Specification: lab_l2_ms_result

Table 8.68: Specification: lab_l2_ms_result

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
LOINC	Observed LOINC values	Char (10)	$10.		Source: LAB.loinc
Orig_Result	Observed Orig_Result values	Char (50)			Source: LAB.orig_result
MS_Result_C	Observed MS_Result_C values	Char (50)			Source: LAB.ms_result_c
Modifier	Observed Modifier values	Char (2)			Source: LAB.modifier
MS_Result_N	Observed MS_Result_N values	Num (8)			Source: LAB.ms_result_n
MS_Result_unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
count	Record Count per stratum	Num (8)	COMMA15.

8.1.68 lab_l2_ms_result_x

This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Result_type, Fast_ind, Specimen_Source, LOINC, MS_Result_C, MS_Result_N, Modifier, and MS_Result_unit values for records where result type=C for any numeric-only test.

Specification: lab_l2_ms_result_x

Table 8.69: Specification: lab_l2_ms_result_x

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		2
Result_Type	Observed Result_Type values	Char (1)	$1.		3
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		4
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		5
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		6
LOINC	Observed LOINC values	Char (10)	$10.		7
Orig_Result	Observed Orig_Result values	Char (50)			8
MS_Result_C	Observed MS_Result_C values	Char (50)			9
Modifier	Observed Modifier values	Char (2)			10
MS_Result_N	Observed MS_Result_N values	Num (8)			11
MS_Result_unit	Observed MS_Result_unit values	Char (11)	$11.		12
count	Record Count per stratum	Num (8)	COMMA15.		13

8.1.69 lab_l2_record_count

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, and LOINC values.

Specification: lab_l2_record_count

Table 8.70: Specification: lab_l2_record_count

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
LOINC	Observed LOINC values	Char (10)	$10.		Source: LAB.loinc
count	Record Count per stratum	Num (8)	COMMA15.

8.1.70 lab_l2_test_units

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Orig_Result_unit, Std_Result_unit, and MS_Result_unit values.

Specification: lab_l2_test_units

Table 8.71: Specification: lab_l2_test_units

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
Orig_Result_unit	Observed Orig_Result_unit values	Char (20)			Source: LAB.orig_result_unit
Std_Result_unit	Observed Std_result_unit values	Char (11)	$11.		Source: LAB.std_result_unit
MS_Result_unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
count	Record Count per stratum	Num (8)	COMMA15.

8.1.71 lab_l3_abn_ind

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, and Abn_ind values.

Specification: lab_l3_abn_ind

Table 8.72: Specification: lab_l3_abn_ind

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Abn_ind	Observed Abn_ind values	Char (2)			Source: LAB.abn_ind
count	Record Count per stratum	Num (8)	COMMA15.

8.1.72 lab_l3_cat_resultn_ptloc_{t}

This dataset contains frequency of records with MS_Result_N values that fall into pre-defined categories of result value ranges, stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Pt_Loc, MS_Result_unit, and MS_Result_Range (derived).

Specification: lab_l3_cat_resultn_ptloc_{t}

Table 8.73: Specification: lab_l3_cat_resultn_ptloc_{t}

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_Ind
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
MS_Result_unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
ms_result_range	Standardized result range category for MS_Result_N value	Char (25)			Source: LAB.ms_result_n|inputfiles.lkp _lab_result_ranges Derivation: Convert non-missing MS_Result_N values to a range category based on formats in lookup table. Limit to test names listed in lab_lkp_result_ranges, where Modifier = “EQ”.
count	Record Count per stratum	Num (8)	COMMA15.

8.1.73 lab_l3_cat_resultn_ss_{t}

This dataset contains frequency of records stratified by MS_Result_N values that fall into pre-defined categories of result value ranges, stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Specimen_Source, MS_Result_unit, and MS_Result_Range (derived).

Specification: lab_l3_cat_resultn_ss_{t}

Table 8.74: Specification: lab_l3_cat_resultn_ss_{t}

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_Ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
MS_Result_unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
ms_result_range	Standardized result range category for MS_Result_N value	Char (25)			Source: LAB.ms_result_n|inputfiles.lkp _lab_result_ranges Derivation: Convert non-missing MS_Result_N values to a range category based on formats in lookup table. Limit to test names listed in lab_lkp_result_ranges, where Modifier = “EQ”.
count	Record Count per stratum	Num (8)	COMMA15.

8.1.74 lab_l3_dates

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived labdt, derived resdt, and derived orddt values.

Specification: lab_l3_dates

Table 8.75: Specification: lab_l3_dates

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Labdt	Record-level indicator of whether lab_dt is populated	Num (3)		Lab_dt populated?	Source: LAB.lab_dt Derivation: 1=True, 0=False
Resdt	Record-level indicator of whether result_dt is populated	Num (3)		Result_dt populated?	Source: LAB.result_dt Derivation: 1=True, 0=False
Orddt	Record-level indicator of whether order_dt is populated	Num (3)		Order_dt populated?	Source: LAB.Order_dt Derivation: 1=True, 0=False
count	Record Count per stratum	Num (8)	COMMA15.

8.1.75 lab_l3_dates_ym

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived Order_ym, derived Lab_ym, and derived Result_ym values.

Specification: lab_l3_dates_ym

Table 8.76: Specification: lab_l3_dates_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
YearMonth_LAB	Year and month derived from observed lab_dt values	Char (7)			Source: LAB.lab_dt Derivation: Convert lab_dt from numeric date to character representing the corresponding year (e.g. 01/27/2017 = 2017-01)
YearMonth_RESULT	Year and month derived from observed result_dt values	Char (7)			Source: LAB.result_dt
YearMonth_ORDER	Year and month derived from observed order_dt value	Char (7)			Source: LAB.Order_dt Derivation: Convert order_dt from numeric date to character representing the corresponding year (e.g. 01/27/2017 = 2017-01)
count	Record Count per stratum	Num (8)	COMMA15.

8.1.76 lab_l3_ms_test_sub_category

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, and PX_CodeType values.

Specification: lab_l3_ms_test_sub_category

Table 8.77: Specification: lab_l3_ms_test_sub_category

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
PX_CodeType	Observed Px_codetype values	Char (2)			Source: LAB.px_codetype
count	Record Count per stratum	Num (8)	COMMA15.

8.1.77 lab_l3_n_patid_enrolled_test_y

This dataset contains frequency of unique PatID stratified by MS_Test_Name, Result_Type, and derived year values.

Specification: lab_l3_n_patid_enrolled_test_y

Table 8.78: Specification: lab_l3_n_patid_enrolled_test_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Year	Derived Year values	Char (4)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
count	Count of unique PatID values per stratum	Num (8)	COMMA15.	PatID Count

8.1.78 lab_l3_n_patid_test

This dataset contains frequency of unique PatID by MS_Test_Name, and Result_Type values.

Specification: lab_l3_n_patid_test

Table 8.79: Specification: lab_l3_n_patid_test

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
count	Count of unique PatID values per stratum	Num (8)	COMMA15.	PatID Count

8.1.79 lab_l3_n_patid_test_y

This dataset contains frequency of unique PatID by MS_Test_Name, Result_Type, and derived year values.

Specification: lab_l3_n_patid_test_y

Table 8.80: Specification: lab_l3_n_patid_test_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Year	Derived Year values	Char (4)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
count	Count of unique PatID values per stratum	Num (8)	COMMA15.	PatID Count

8.1.80 lab_l3_n_patid_test_ym

This dataset contains frequency of unique PatID by MS_Test_Name, Result_Type, and derived year-month values.

Specification: lab_l3_n_patid_test_ym

Table 8.81: Specification: lab_l3_n_patid_test_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
YearMonth	Derived Year-Month values	Char (7)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year-month (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
count	Count of unique PatID values per stratum	Num (8)	COMMA15.	PatID Count

8.1.81 lab_l3_n_unmap_loinc_agegrp_sex

This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by agegroup and sex

Specification: lab_l3_n_unmap_loinc_agegrp_sex

Table 8.82: Specification: lab_l3_n_unmap_loinc_agegrp_sex

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Sex	Observed Sex values	Char (1)	$1.	Patient Sex	Source: DEM.sex	For a list of valid values, please refer to the SCDM Demographic Table documentation
AgeGroup	Calculated Age Group at time of Lab test	Char (9)			Source: DEM.birth_date|LAB.order_date
LOINC	Observed LOINC values	Char (10)	$10.	LOINC Code	Source: LAB.loinc
PatID_count	Unique PatID count per stratum	Num (8)	COMMA15.		Source: LAB.patid Derivation: Value calculated count(unique PatID) by stratum
Count	Record Count per stratum	Num (8)	COMMA15.

8.1.82 lab_l3_n_unmap_loinc_all

This dataset contains 1-way frequencies for all LOINCS where MS_Test_Name is UNMAPPED

Specification: lab_l3_n_unmap_loinc_all

Table 8.83: Specification: lab_l3_n_unmap_loinc_all

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
LOINC	Observed LOINC values	Char (10)	$10.	LOINC Code	Source: LAB.loinc
PatID_count	Unique PatID count per stratum	Num (8)	COMMA15.		Source: LAB.patid Derivation: Value calculated count(unique PatID) by stratum
Count	Record Count per stratum	Num (8)	COMMA15.

8.1.83 lab_l3_n_unmap_loinc_ym

This dataset contains frequencies of the top 5000 LOINCS where MS_Test_Name is UNMAPPED, stratified by year-month

Specification: lab_l3_n_unmap_loinc_ym

Table 8.84: Specification: lab_l3_n_unmap_loinc_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Calculated Year-Month value	Char (7)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year-month (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
LOINC	Observed LOINC values	Char (10)	$10.	LOINC Code	Source: LAB.loinc
PatID_count	Unique PatID count per stratum	Num (8)	COMMA15.		Source: LAB.patid Derivation: Value calculated count(unique PatID) by stratum
Count	Record Count per stratum	Num (8)	COMMA15.

8.1.84 lab_l3_pt_loc

This dataset contains frequency of records stratified by MS_Test_Name, Result_type, and Pt_Loc values.

Specification: lab_l3_pt_loc

Table 8.85: Specification: lab_l3_pt_loc

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
count	Record Count per stratum	Num (8)	COMMA15.

8.1.85 lab_l3_range

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Modifier_low, Norm_range_low, Modifier_high, and Norm_Range_high values.

Specification: lab_l3_range

Table 8.86: Specification: lab_l3_range

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
Modifier_low	Observed Modifier_low values	Char (2)			Source: LAB.modifier_low
Norm_Range_low	Observed Norm_range_low values	Char (8)			Source: LAB.Norm_range_low
Modifier_high	Observed Modifier_high values	Char (2)			Source: LAB.modifier_high
Norm_Range_high	Observed Norm_range_high values	Char (8)			Source: LAB.Norm_range_high
count	Record Count per stratum	Num (8)	COMMA15.

8.1.86 lab_l3_record_lrodt_ptloc_ym

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Pt_Loc and derived year-month values.

Specification: lab_l3_record_lrodt_ptloc_ym

Table 8.87: Specification: lab_l3_record_lrodt_ptloc_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
YearMonth	Derived Year-Month values	Char (7)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year-month (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
count	Record Count per stratum	Num (8)	COMMA15.

8.1.87 lab_l3_record_lrodt_ym

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, and derived year-month values.

Specification: lab_l3_record_lrodt_ym

Table 8.88: Specification: lab_l3_record_lrodt_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
YearMonth	Derived Year-Month values	Char (7)			Source: LAB.lab_dt|order_dt|result_dt Derivation: Algorithm combines user-defined date selection hierarchy and data availability to convert numeric date to a character value representing the corresponding year-month (Default hierarchy is Lab_dt, Order_dt, then Result_dt)
count	Record Count per stratum	Num (8)	COMMA15.

8.1.88 lab_l3_stat

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, and stat values.

Specification: lab_l3_stat

Table 8.89: Specification: lab_l3_stat

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Stat	Observed Stat values	Char (1)			Source: LAB.stat
count	Record Count per stratum	Num (8)	COMMA15.

8.1.89 lab_l3_test_resultc_stats

This dataset contains frequency of records stratified by MS_Test_Name, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_Loc, MS_Result_C, and Orig_Result values.

Specification: lab_l3_test_resultc_stats

Table 8.90: Specification: lab_l3_test_resultc_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
MS_Result_C	Observed MS_Result_C values	Char (50)			Source: LAB.ms_result_c
Orig_Result	Observed Orig_Result values	Char (50)			Source: LAB.orig_result
count	Record Count per stratum	Num (8)	COMMA15.

8.1.90 lab_l3_test_resultn_stats_ms

This dataset contains the statistical distribution and frequency of records where Result_type=N, stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_loc, Modifier, Orig_Result_unit, Std_Result_unit, and MS_Result_unit values.

Specification: lab_l3_test_resultn_stats_ms

Table 8.91: Specification: lab_l3_test_resultn_stats_ms

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_test_name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
Orig_Result_Unit	Observed Orig_Result_unit values	Char (20)			Source: LAB.orig_result_unit
Std_Result_unit	Observed Std_result_unit values	Char (11)	$11.		Source: LAB.std_result_unit
MS_Result_Unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
Modifier	Observed Modifier values	Char (2)			Source: LAB.modifier
count	Record Count per stratum	Num (8)	COMMA15.
Mean	Mean value of MS_result_N by stratum	Num (8)	10.199999999999999		Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means
Std	Standard deviation value of MS_result_N by stratum	Num (8)	10.199999999999999		Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means
Min	Minimum value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means
P5	5th percentile value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
P25	25th percentile value for MS_Result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
Median	Median value of MS_result_N by stratum	Num (8)	10.199999999999999		Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means
Mode	Mode value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means
P75	75th percentile value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
P95	95th percentile value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
Max	Maximum value of MS_result_N by stratum	Num (8)			Source: LAB.ms_result_n Derivation: Value as calculated by SAS Proc Means

8.1.91 lab_l3_test_resultn_stats_orig

This dataset contains statistical distribution and frequency of records where Result_type=‘N’, stratified by MS_Test_Name, Result_Type, MS_Test_Sub_Category, Fast_ind, Specimen_Source, Pt_loc, Orig_Result_unit, Std_Result_unit, MS_Result_unit, and Modifier values.

Specification: lab_l3_test_resultn_stats_orig

Table 8.92: Specification: lab_l3_test_resultn_stats_orig

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_test_name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
MS_Test_Sub_Category	Observed MS_Test_Sub_Category values	Char (6)	$6.		Source: LAB.ms_test_sub_category
Fast_Ind	Observed Fast_Ind values	Char (1)	$1.		Source: LAB.fast_ind
Specimen_Source	Observed Specimen_Source values	Char (7)	$7.		Source: LAB.specimen_source
Pt_Loc	Observed Pt_loc values	Char (1)			Source: LAB.pt_loc
Orig_Result_Unit	Observed Orig_Result_unit values	Char (20)			Source: LAB.orig_result_unit
Std_Result_unit	Observed Std_result_unit values	Char (11)	$11.		Source: LAB.std_result_unit
MS_Result_Unit	Observed MS_Result_unit values	Char (11)	$11.		Source: LAB.ms_result_unit
Modifier	Observed Modifier values	Char (2)			Source: LAB.modifier
count	Record Count per stratum	Num (8)	COMMA15.
Mean	Mean value of orig_result by stratum	Num (8)	10.199999999999999		Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table
Std	Standard deviation value of orig_result	Num (8)	10.199999999999999		Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table
Min	Minimum value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table
P5	5th percentile value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
P25	25th percentile value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
Median	Median value of orig_result by stratum	Num (8)	10.199999999999999		Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table
Mode	Mode value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table
P75	75th percentile value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
P95	95th percentile value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means where Result_type=‘N’ and MS_Result_N ne missing
Max	Maximum value of orig_result by stratum	Num (8)			Source: LAB.orig_result Derivation: Value as calculated by SAS Proc Means. Orig_Result is converted from character to numeric for this table

8.1.92 lab_l3_times

This dataset contains frequency of records stratified by MS_Test_Name, Result_Type, derived Labtm, and derived Restm values.

Specification: lab_l3_times

Table 8.93: Specification: lab_l3_times

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
MS_Test_Name	Observed MS_Test_Name values	Char (20)	$20.		Source: LAB.ms_test_name
Result_Type	Observed Result_Type values	Char (1)	$1.		Source: LAB.result_type
Labtm	Indicator whether lab_tm is populated. 0 = Lab_tm is not populated. 1 = Lab_tm is populated .	Num (3)		Lab_tm populated?	Source: LAB.lab_tm Derivation: Convert lab_dt from numeric date to character representing whether lab_tm field is populated (e.g. null lab_dt = 0)
Restm	Indicator whether result_tm is populated. 0 = result_tm is not populated. 1 = result_tm is populated .	Num (3)		Result_tm populated?	Source: LAB.result_tm Derivation: Convert result_tm from numeric date to character representing whether result_tm field is populated (e.g. null lab_dt = 0)
count	Record Count per stratum	Num (8)	COMMA15.

8.1.93 pre_l2_orderdate_ym

This dataset contains frequency of records stratified by year-month values.

Specification: pre_l2_orderdate_ym

Table 8.94: Specification: pre_l2_orderdate_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2	source: PRE.OrderDate derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.94 pre_l2_rxdaw

This dataset contains frequency of records stratified by RxDAW values.

Specification: pre_l2_rxdaw

Table 8.95: Specification: pre_l2_rxdaw

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxDAW	Observed RxDAW values	Char (1)	$1.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.95 pre_l2_rxdoseform

This dataset contains frequency of records stratified by RxDoseForm values.

Specification: pre_l2_rxdoseform

Table 8.96: Specification: pre_l2_rxdoseform

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxDoseForm	Observed RxDoseForm values	Char (40)	$40.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.96 pre_l2_rxdosequantity

This dataset contains frequency of records stratified by RxDoseQuantity values.

Specification: pre_l2_rxdosequantity

Table 8.97: Specification: pre_l2_rxdosequantity

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxDoseQuantity	Observed RxDoseQuantity values	Num (8)			2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.97 pre_l2_rxdoseunit

This dataset contains frequency of records stratified by RxDoseUnit values.

Specification: pre_l2_rxdoseunit

Table 8.98: Specification: pre_l2_rxdoseunit

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxDoseUnit	Observed RxDoseUnit values	Char (25)	$25.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.98 pre_l2_rxfreqquantity

This dataset contains frequency of records stratified by RxDoseQuantity values.

Specification: pre_l2_rxfreqquantity

Table 8.99: Specification: pre_l2_rxfreqquantity

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxFreqQuantity	Observed RxFreqQuantity values	Num (4)			2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.99 pre_l2_rxfrequnit

This dataset contains frequency of records stratified by RxFreqUnit values.

Specification: pre_l2_rxfrequnit

Table 8.100: Specification: pre_l2_rxfrequnit

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxFreqUnit	Observed RxFreqUnit values	Char (1)	$1.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.100 pre_l2_rxprnflag

This dataset contains frequency of records stratified by RxPrnFlag values.

Specification: pre_l2_rxprnflag

Table 8.101: Specification: pre_l2_rxprnflag

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxPrnFlag	Observed RxPrnFlag values	Char (1)	$1.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.101 pre_l2_rxrefills

This dataset contains frequency of records stratified by RxRefills values.

Specification: pre_l2_rxrefills

Table 8.102: Specification: pre_l2_rxrefills

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxRefills	Observed RxRefills values	Num (3)			2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.102 pre_l2_rxroute

This dataset contains frequency of records stratified by RxRoute values.

Specification: pre_l2_rxroute

Table 8.103: Specification: pre_l2_rxroute

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxRoute	Observed RxRoute values	Char (25)	$25.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.103 pre_l2_rxsource

This dataset contains frequency of records stratified by RxSource values.

Specification: pre_l2_rxsource

Table 8.104: Specification: pre_l2_rxsource

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxSource	Observed RxSource values	Char (2)	$2.		2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.104 pre_l3_pt_orderdate_stats

This dataset contains a statistical distribution of the number of ordered prescriptions per patient per day.

Specification: pre_l3_pt_orderdate_stats

Table 8.105: Specification: pre_l3_pt_orderdate_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
pre	Count of unique ordered prescriptions	Num (8)	COMMA15.		2
rxs	Count of prescribed medication or medical device	Num (8)	COMMA15.		3
mean	Mean number of unique prescriptions per patient by year-month	Num (8)	F10.2		4	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
std	Standard deviation of number of prescriptions per patient by enctype and year-month	Num (8)	F10.2		5	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
min	Minimum number of unique prescriptions per patient by year-month	Num (8)			6	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of unique prescriotions per patient by year-month	Num (8)			7	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of unique prescriptions per patient by year-month	Num (8)			8	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of unique prescriptions per patient by year-month	Num (8)			9	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
median	Median number of unique prescriptions per patient by year-month	Num (8)	F10.1		10	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of unique prescriptions per patient by year-month	Num (8)			11	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of unique prescriptions per patient by year-month	Num (8)			12	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of unique prescriptions per patient by year-month	Num (8)			13	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means
max	Maximum number of unique prescriptions per patient by year-month	Num (8)			14	source: PRE.PrescribingID|OrderDate derivation: Value as calculated by SAS Proc Means

8.1.105 pre_l3_rx_pt_y_stats

This dataset contains a statistical distribution of the number of recorded prescription orders per patient per year.

Specification: pre_l3_rx_pt_y_stats

Table 8.106: Specification: pre_l3_rx_pt_y_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
Year	Derived Year values	Char (7)			2	source: PRE.OrderDate derivation: Convert numeric date to a character value representing the corresponding year-month
n_ptyr	Count of unique patients by year	Num (8)	COMMA15.		3
n_rx	Count of prescribed medication or medical device	Num (8)	COMMA15.		4
Mean	Mean number of unique prescriptions per patient by year	Num (8)	F10.2		5	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
Std	Standard deviation of number of prescriptions per patient by year	Num (8)	F10.2	Std Dev	6	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
Min	Minimum number of unique prescriptions per patient by year	Num (8)	F10.1	Minimum	7	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P1	1st percentile value of unique prescriptions per patient by year	Num (8)	F10.1	1st Pctl	8	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P5	5th percentile value of unique prescriptions per patient by year	Num (8)	F10.1	5th Pctl	9	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P25	25th percentile value of unique prescriptions per patient by year	Num (8)	F10.1	25th Pctl	10	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
Median	Median number of unique prescriptions per patient by year	Num (8)	F10.1		11	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P75	75th percentile value of unique prescriptions per patient by year	Num (8)	F10.1	75th Pctl	12	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P95	95th percentile value of unique prescriptions per patient by year	Num (8)	F10.1	95th Pctl	13	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
P99	99th percentile value of unique prescriptions per patient by year	Num (8)	F10.1	99th Pctl	14	source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means
Max	Maximum number of unique prescriptions per patient by year	Num (8)	F10.1	Maximum		source: PRE.PatID|OrderDate derivation: Value as calculated by SAS Proc Means

8.1.106 pre_l3_rxamt_rxsup

This dataset contains frequency of records stratified by RxAmt and RxSup values.

Specification: pre_l3_rxamt_rxsup

Table 8.107: Specification: pre_l3_rxamt_rxsup

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
RxAmt	Observed Rxamt values	Num (4)			2
RxSup	Observed RxSup values	Num (4)			3
count	Record Count per stratum	Num (8)	COMMA15.		4

8.1.107 pro_l2_px_pxtype_spec

This dataset contains frequency of records stratified by PX_CodeType, PX, and Specialty values.

Specification: pro_l2_px_pxtype_spec

Table 8.108: Specification: pro_l2_px_pxtype_spec

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Px	Observed Px values	Char (7)	$7.		Source: PRO.px
Px_CodeType	Observed Px_codetype values	Char (2)	$2.		Source: PRO.px_codetype
Specialty	Observed provider Specialty values	Char (10)	$10.		Source: PVD.Specialty Derivation: Requires merge betweren PRO and PVD on ProviderID to attach Specialty for matching records.
count	Record Count per stratum	Num (8)	COMMA15.

8.1.108 pro_l3_enctype_pxtype_ym

This dataset contains frequency of records stratified by EncType, and PX_CodeType, and derived year-month values (YearMonth derived by PRO.adate for non IP/IS encounters, and ENC.ddate for IP/IS encounters).

Specification: pro_l3_enctype_pxtype_ym

Table 8.109: Specification: pro_l3_enctype_pxtype_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			Source: PRO.adate|ENC.ddate Derivation: Convert numeric date to a character value representing the corresponding year-month
EncType	Observed Enctype values	Char (2)	$2.		Source: ENC.enctype
Px_CodeType	Observed Px_codetype values	Char (2)	$2.		Source: PROC.px_codetype
count	Record Count per stratum	Num (8)	COMMA15.

8.1.109 pro_l3_px_per_enc_stats

This dataset contains descriptive statistics for the frequency of procedures (distinct PX_CodeType and PX) per patient encounter.

Specification: pro_l3_px_per_enc_stats

Table 8.110: Specification: pro_l3_px_per_enc_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
enc	Frequency of unique encounters	Num (8)	COMMA15.		Source: PRO.patid|encounterid
pxs	Frequency of unique procedures	Num (8)	COMMA15.		Source: PRO.px_codetype|px
mean	Mean number of unique procedures per encounter	Num (8)	F10.2		Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
std	Standard deviation of number of unique procedures per encounter	Num (8)	F10.2		Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
min	Minimum number of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
median	Median number of unique procedures per encounter	Num (8)	F10.1		Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means
max	Maximum number of unique procedures per encounter	Num (8)			Source: PRO.patid|encounterid|px _codetype|px Derivation: Value as calculated by SAS Proc Means

8.1.110 prr_l3_response_dt_ym

This dataset contains frequency of records stratified by derived year-month values.

Specification: prr_l3_response_dt_ym

Table 8.111: Specification: prr_l3_response_dt_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)					2
count	Record Count per stratum	Num (8)	COMMA15.				3

8.1.111 prr_l3_response_freq

This dataset contains the count of records stratified by PRM_Code, SurveyID, and QuestionVerID values.

Specification: prr_l3_response_freq

Table 8.112: Specification: prr_l3_response_freq

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
PRM_Code		Num (3)					2
SurveyID		Num (3)					3
QuestionVerID		Num (3)					4
count	Record Count per stratum	Num (8)	COMMA15.				5

8.1.112 prr_l3_sid_pt_ym_stats

This dataset contains a statistical distribution of the number of surveys reported per patid per yearmonth.

Specification: prr_l3_sid_pt_ym_stats

Table 8.113: Specification: prr_l3_sid_pt_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
yearmonth	Derived Year-Month values	Char (7)					2
n_ptym		Num (8)	COMMA15.				3
n_svid		Num (8)	COMMA15.				4
Mean		Num (8)	F10.2				5
Std		Num (8)	F10.2	Std Dev			6
Min		Num (8)	F10.1	Minimum			7
P1		Num (8)	F10.1	1st Pctl			8
P5		Num (8)	F10.1	5th Pctl			9
P25		Num (8)	F10.1	25th Pctl			10
Median		Num (8)	F10.1				11
P75		Num (8)	F10.1	75th Pctl			12
P95		Num (8)	F10.1	95th Pctl			13
P99		Num (8)	F10.1	99th Pctl			14
Max		Num (8)	F10.1	Maximum

8.1.113 prs_l3_prm_code_type_subtype

This dataset contains a count of unique QuestionVerIDs stratified by PRM_Code, PRM_Type, and PRM_SubType values.

Specification: prs_l3_prm_code_type_subtype

Table 8.114: Specification: prs_l3_prm_code_type_subtype

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP		Char (6)			1
PRM_CODE		Num (8)			2
PRM_TYPE		Char (26)			3
PRM_SUBTYPE		Char (25)			4
nquestionverid		Num (8)			5

8.1.114 prs_l3_question_dt_ym

This dataset contains frequency of records stratified by derived year-month values.

Specification: prs_l3_question_dt_ym

Table 8.115: Specification: prs_l3_question_dt_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP		Char (6)			1
yearmonth		Char (7)			2
count		Num (8)	COMMA15.		3

8.1.115 prs_l3_surveyid_ver_ym

This dataset countains the frequency of records stratified by SurveyID, QuestionVerID, and derived year-month values.

Specification: prs_l3_surveyid_ver_ym

Table 8.116: Specification: prs_l3_surveyid_ver_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES	ORDER
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
SurveyID		Num (3)					2
Survey_Name		Char (25)	$25.				3
QuestionVerID		Num (3)					4
yearmonth		Char (7)					5

8.1.116 pvd_l2_spec_spectype

This dataset contains frequency of records stratified by Specialty_CodeType and Specialty values.

Specification: pvd_l2_spec_spectype

Table 8.117: Specification: pvd_l2_spec_spectype

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Specialty_CodeType	Observed Specialty_CodeType values	Char (1)	$1.		Source: PVD.Specialty_CodeType
Specialty	Observed Specialty values	Char (10)	$10.		Source: PVD.Specialty
count	Record Count per stratum	Num (8)	COMMA15.

8.1.117 txn_l3_bloodgroup_ym

This dataset contains the frequency of records stratified by bloodgroup and derived year-month values.

Specification: txn_l3_bloodgroup_ym

Table 8.118: Specification: txn_l3_bloodgroup_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
bloodgroup	Unique bloodgroup value	Char (3)			3
count	Record Count per stratum	Num (8)	COMMA15.		4

8.1.118 txn_l3_bloodtype_ym

This dataset contains the frequency of records stratified by bloodtype and derived year-month values.

Specification: txn_l3_bloodtype_ym

Table 8.119: Specification: txn_l3_bloodtype_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
BloodType	Unique bloodtype value	Char (3)	$3.		3
count	Record Count per stratum	Num (8)	COMMA15.		4

8.1.119 txn_l3_enctype_ym

This dataset contains the frequency of records stratified by encType and derived year-month values.

Specification: txn_l3_enctype_ym

Table 8.120: Specification: txn_l3_enctype_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
EncType	Unique EncType values	Char (2)	$2.		3
count	Record Count per stratum	Num (8)	COMMA15.		4

8.1.120 txn_l3_tdate_start_ym

This dataset contains the frequency of records stratified by tdate_start values as represented in year-month.

Specification: txn_l3_tdate_start_ym

Table 8.121: Specification: txn_l3_tdate_start_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.121 txn_l3_trans_duration_stats

This dataset contains a statistical distribution of the duration of transfusion per derived year-month values.

Specification: txn_l3_trans_duration_stats

Table 8.122: Specification: txn_l3_trans_duration_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
txn	Count of unique transfusions	Num (8)	COMMA15.		3
n_neg	Count of transfusions with reported negative values duration	Num (8)	COMMA15.		4
n_zero	Count of transfusions with reported values of zero for duration	Num (8)	COMMA15.		5
mean	Mean value of duration in minutes per tranfusion	Num (8)	COMMA15.1		6	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
std	Standard Deviation of the mean duration in minutes per tranfusion	Num (8)	COMMA15.1		7	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
min	Minimum value of duration in minutes per transfusion	Num (8)	COMMA15.1		8	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1		9	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1		10	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1		11	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
median	Median value of duration in minutes per transfusion	Num (8)	COMMA15.1		12	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1		13	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1		14	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of duration in minutes per transfusion	Num (8)	COMMA15.1			source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means
max	Maximum value of duration in minutes per transfusion	Num (8)	COMMA15.1		16	source: TXN.tdate_start|ttime_start|tdate_end|ttime_end derivation: Value as calculated by SAS Proc Means

8.1.122 txn_l3_trans_per_enc_stats

This dataset contains a statistical distribution of encounters and transfusions per encounter and derived year-month values.

Specification: txn_l3_trans_per_enc_stats

Table 8.123: Specification: txn_l3_trans_per_enc_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
enc	Count of unique encounterID values	Num (8)	COMMA15.		3
mean	Mean value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		4	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
std	Standard deviation of the mean value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		5	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
min	Minimum value of transfusions per unique encounterID and yearmonth	Num (8)	F10.		6	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p1	1st percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		7	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p5	5th percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		8	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p25	25th percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		9	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
median	Median value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		10	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p75	75th percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		11	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p95	95th percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		12	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
p99	99th percentile value of transfusions per unique encounterID and yearmonth	Num (8)	F10.1		13	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means
max	Maximum value of transfusions per unique encounterID and yearmonth	Num (8)	F10.		14	source: TXN.encounterid|tdate_start derivation: Value as calculated by SAS Proc Means

8.1.123 txn_l3_transcode_codetype_ym

This datset contains frequency of records stratified by transcode, transcode_type, and derived year-month values.

Specification: txn_l3_transcode_codetype_ym

Table 8.124: Specification: txn_l3_transcode_codetype_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2
TransCode_Type	Unique TransCode_Type values	Char (2)	$2.		3
TransCode	Unique TransCode values	Char (15)	$15.		4
count	Record Count per stratum	Num (8)	COMMA15.		5

8.1.124 vit_l2_bp_catvar_ym

This dataset contains frequency of records stratified by blood pressure (BP) type, position, and derived year-month values.

Specification: vit_l2_bp_catvar_ym

Table 8.125: Specification: vit_l2_bp_catvar_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2	source: VIT.measure_date derivation: Convert numeric date to a character value representing the corresponding year-month
BP_Type	Observed Position values	Char (1)	$1.		3
Position	Observed Position values	Char (1)	$1.		4
count	Record Count per stratum	Num (8)	COMMA15.		5

8.1.125 vit_l2_tobacco_ym

This dataset contains frequency of records stratified by tobacco, tobacco type, and derived year-month values.

Specification: vit_l2_tobacco_ym

Table 8.126: Specification: vit_l2_tobacco_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2	source: VIT.measure_date derivation: Convert numeric date to a character value representing the corresponding year-month
Tobacco	Observed Tobacco values	Char (1)	$1.		3
Tobacco_Type	Observed Tobacco_Type values	Char (1)	$1.		4
count	Record Count per stratum	Num (8)	COMMA15.		5

8.1.126 vit_l3_measure_date_ym

vit_l3_measure_date_ym

Specification: vit_l3_measure_date_ym

Table 8.127: Specification: vit_l3_measure_date_ym

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			1	source: qa package master file derivation: %upcase(&DPID)
YearMonth	Derived Year-Month values	Char (7)			2	source: VIT.measure_date derivation: Convert numeric date to a character value representing the corresponding year-month
count	Record Count per stratum	Num (8)	COMMA15.		3

8.1.127 vit_l3_pt_ym_stats

This datasets contains a statistical distribution of the number of patients and vital sign records per patient per year-month.

Specification: vit_l3_pt_ym_stats

Table 8.128: Specification: vit_l3_pt_ym_stats

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	ORDER	NOTES	VALUES
DP		Char (6)			1
YearMonth		Char (7)			2
n_patid		Num (8)	COMMA15.		3
records		Num (8)	COMMA15.		4
mean		Num (8)	F10.2		5
std		Num (8)	F10.2		6
min		Num (8)			7
p1		Num (8)			8
p5		Num (8)			9
p25		Num (8)			10
median		Num (8)	F10.1		11
p75		Num (8)			12
p95		Num (8)			13
p99		Num (8)			14
max		Num (8)

8.1.128 pre_l2_rx_rxtype_spec

This dataset contains frequency of records stratified by RX_CodeType, RX, and Specialty values.

Specification: pre_l2_rx_rxtype_spec

Table 8.129: Specification: pre_l2_rx_rxtype_spec

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)		$6	Source: qa package master file Derivation: %upcase(&DPID)
Rx_CodeType	Observed Rx_codetype values	Char (2)		$2	Source: PRE.Rx_CodeType	ND = National Drug Code (US) SN = SNOMED CT (US) SK = SNOMED CT (UK/CPRD) DM = Dictionary of Medicines and Devices (UK) DI = Drug Identification Number (CA) RN = RxNorm (US) AT = Anatomical Therapeutic Chemical Classification (DK) GP = Generic Product Identifier
Rx	Observed Rx values	Char (#)			Source: PRE.Rx
Specialty	Observed provider Specialty values	Char (10)		$10.	Source: PVD.Specialty Derivation: Requires merge betweren PRE and PVD on ProviderID to attach Specialty for matching records.	=
count	Record Count per stratum	Num (8)		COMMA15.

8.1.129 licensed

This metadata file contains DP-specific SAS component license status.

Specification: licensed

Table 8.130: Specification: licensed

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
Component	Name of SAS component	Char (15)			Source: SAS metadata Derivation: Proc setinit
Status	License status by component	Char (25)			Source: SAS metadata Derivation: Proc setinit

8.1.130 minmax_dates

This metadata file contains derived minimum and maximum dates for data completeness.

Specification: minmax_dates

Table 8.131: Specification: minmax_dates

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 character Data Partner identifier	Char (6)			Source: qa package master file Derivation: %upcase(&DPID)
DP_MinDate	Overall DP Minimum Date for Data Completeness	Num (8)	YYMMDD10.	Overall DP Minimum Date for Data Completeness	Source: DIA|DIS|ENC|ENR|PRO .mindate Derivation: Maximum mindate
DP_MaxDate	Overall DP Maximum Date for Data Completeness	Num (8)	YYMMDD10.	Overall DP Maximum Date for Data Completeness	Source: DIA|DIS|ENC|ENR|PRO .maxdate Derivation: Minimum maxdate
DIA_MinDate	Diagnosis table Minimum Date for Data Completeness	Num (8)	YYMMDD10.		Source: DIA.adate Derivation: See functional specs
DIS_MinDate	Dispensing table Minimum Date for Data Completeness	Num (8)	YYMMDD10.		Source: DIS.rxdate Derivation: See functional specs
ENC_MinDate	Encounter table Minimum Date for Data Completeness	Num (8)	YYMMDD10.		Source: ENC.adate Derivation: See functional specs
ENR_MinDate	Enrollment table Minimum Date for Data Completeness	Num (8)	YYMMDD10.		Source: ENR.enr_start Derivation: See functional specs
PRO_MinDate	Procedure table Minimum Date for Data Completeness	Num (8)	YYMMDD10.		Source: PRO.adate Derivation: See functional specs
DIA_MaxDate	Diagnosis table Maximum Date for Data Completeness	Num (8)	YYMMDD10.		Source: DIA.adate Derivation: See functional specs
DIS_MaxDate	Dispensing table Maximum Date for Data Completeness	Num (8)	YYMMDD10.		Source: DIS.rxdate Derivation: See functional specs
ENC_MaxDate	Encounter table Maximum Date for Data Completeness	Num (8)	YYMMDD10.		Source: ENC.adate Derivation: See functional specs
ENR_MaxDate	Enrollment table Maximum Date for Data Completeness	Num (8)	YYMMDD10.		Source: ENR.enr_start Derivation: See functional specs
PRO_MaxDate	Procedure table Maximum Date for Data Completeness	Num (8)	YYMMDD10.		Source: PRO.adate Derivation: See functional specs

8.1.131 qa_cc_metadata

This metadata file contains DP-specific information about ETL number, phase, and SCDM table names.

Specification: qa_cc_metadata

Table 8.132: Specification: qa_cc_metadata

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Variable	A list of macro variable names	Char (32)			Source: inputfiles.00.1_scdm_standard _macros|sasprograms.00.0 _scdm_data_qa_review_master _file Derivation: See functional specs
Value	Source data for macro variable values	Char (255)			Source: inputfiles.00.1_scdm_standard _macros|sasprograms.00.0 _scdm_data_qa_review_master _file Derivation: See functional specs

8.1.132 Mother-Infant ID MSOC Output

Table 8.133 describes the Mother-Infant Identification Program Package output datasets found in the QA Package msoc directory. These datasets are returned to SOC.

Table 8.133: Mother-Infant Identification MSOC Folder Output

Dataset	Description
motherdeliveries_infants_counts	Provides summary counts of deliveries and infants identified.
r01_deliveries_counts	This dataset provides aggregates of factors related to deliveries identified by the Mother-Infant Identification Program
r02_infants_counts	This dataset provides aggregates of factors related to infants identified by the Mother-Infant Identification Module

8.1.132.1 motherdeliveries_infants_counts

Provides summary counts of deliveries and infants identified.

Specification: motherdeliveries_infants_counts

Table 8.134: Specification: motherdeliveries_infants_counts

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Level	Categorizes the counts in this table	Char (3)	Person type	$3		001 = Deliveries 002 = Mothers 003 = Infants
count	Comma separated counts	Num (8)	Count	COMMA14.		Any positive integer or 0

8.1.132.2 r01_deliveries_counts

This dataset provides aggregates of factors related to deliveries identified by the Mother-Infant Identification Program

Specification: r01_deliveries_counts

Table 8.135: Specification: r01_deliveries_counts

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Level	Aggregation Level	Char (3)	Aggregation Level	$3		000 = Total Counts 001 = By AgeGroup 002 = By Year 003 = By EncType 004 = By AgeGroup and Year 005 = By AgeGroup and EncType 006 = By Year and EncType 007 = By AgeGroup, Year, and EncType 008 = By Birth_type 009 = By Birth_type and AgeGroup 010 = By Birth_type and Year 011 = By Birth_type and EncType 012 = By Birth_type, Year, AgeGroup, and EncType 013 = By YearMonth 014 = By AgeGroup and YearMonth 015 = By YearMonth and EncType 016 = By AgeGroup, YearMonth, and EncType 017 = By Birth_type and Year 018 = By Birth_type, YearMonth, AgeGroup, and EncType
AgeGroup	Categorizes the counts in this table by age group	Char (9)	Age Group	$9.		10–19 20–24 25–29 30–34 35–39 40–44 45–54
Year	Year of delivery	Num (8)	Year	$4.
YearMonth	Year and Month of delivery	Num (8)	YearMonth	Yymmd.
EncType	Encounter Type	Char (2)	Encounter Type	$2.		AV = Ambulatory Visit ED = Emergency Department IP = Inpatient Hospital Stay IS = Non-Acute Institutional Stay OA = Other Ambulatory Visit
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)	# of babies born			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
count	Comma separated counts	Num (8)	Count	COMMA14.		Any positive integer or 0

8.1.132.3 r02_infants_counts

This dataset provides aggregates of factors related to infants identified by the Mother-Infant Identification Module

Specification: r02_infants_counts

Table 8.136: Specification: r02_infants_counts

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
Level	Aggregation Level	Char (3)	Aggregation Level	$3		000 = Total counts 001 = By Sex 002 = By Year 003 = By EnrollDays 004 = By Sex and Year 005 = By Sex and EnrollDays 006 = By Year and EnrollDays 007 = By Sex, Year, and EnrollDays 008 = By YearMonth 009 = By Sex and YearMonth 010 = By YearMonth and EnrollDays 011 = By Sex, YearMonth, and EnrollDays
Sex	Child’s Sex	Char (1)	Child Sex	$1.		A = Ambiguous F = Female M = Male U = Unknown
Year	Year of delivery	Num (8)	Year	$4.
YearMonth	Year and Month of delivery	Num (8)	YearMonth	Yymmd.
EnrollDays	Groupings of medical coverage enrollment days in the 1st year of life	Char (10)	Enrollment days category	$7.
count	Comma separated counts	Num (8)	Count	COMMA14.		Any positive integer or 0

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

Table 8.137: SSCDM Snapshot MSOC Folder Output

Dataset	TabID	Description
cod_pat_codct_md	COD	Number of Cause of death (COD) records by members that had at least one span of medical and drug coverage (active or inactive at time of death).
cod_pat_codct_m	COD	Number of Cause of death (COD) records for members that had at least one span of medical coverage (active or inactive at time of death).
dem_pat_lstagecount_md	DEM	Age distribution of all PatIDs with at least one day of medical and drug coverage. Age reflective of the member’s first day of enrollment of most recent enrollment span.
dem_pat_actagecount_md	DEM	Age distribution of actively enrolled PatIDs with at least one day of medical and drug coverage. Age reflective of the member’s first day of enrollment based on their active enrollment span.
dem_sexct_md	DEM	Distribution of sex for members that have at least one span of medical and drug coverage.
dem_hispanicct_md	DEM	Distribution of Hispanic status for members that have at least one span of medical and drug coverage.
dem_racect_md	DEM	Distribution of race for members that have at least one span of medical and drug coverage.
dem_geolocct_md	DEM	Distribution of geographic location (state-level) for members that have at least one span of medical and drug coverage.
dis_pat_rxcount_md	DIS	Number of dispensings per member, while actively enrolled in medical and drug coverage.
dis_pat_rxcount_d	DIS	Number of dispensings per member, while actively enrolled in drug coverage.
dth_dthct_md	DTH	Number of death records for members that had at least one span of medical and drug coverage (active or inactive at time of death).
dth_dthct_m	DTH	Number of death records for members that had at least one span of medical coverage (active or inactive at time of death).
enc_pat_enccount_md	ENC	Number of encounters per member, while actively enrolled in medical and drug coverage.
enr_rec_covlength_md	ENR	Frequency of length of enrollment spans by record for members with medical and drug coverage.
enr_pat_covlength_md	ENR	Frequency of total length of enrollment span in days by unique PatID.
enr_patid_ct_md_y	ENR	Number of PatIDs with at least one day of medical and drugcoverage by year.
enr_patid_ct_md	ENR	Number of PatIDs with at least one day of medical and drug coverage.
enr_active_patid_ct_md	ENR	Number of actively enrolled patients as of a Data Partner’s overall maximum date for data completeness (DP_MaxDate).
enr_pat_enrcount_md	ENR	Number of enrollment spans per member, while actively enrolled in medical and drug coverage.
lab_pat_testcount_md	LAB	Number of laboratory result records per member, while actively enrolled in medical and drug coverage.
vit_pat_vitct_md	VIT	Number of members with at least one vital sign measurement, per type (height, weight, systolic BP, diastolic BP), while actively enrolled in medical and drug coverage.

8.1.133.1 enr_rec_covlength_md

Frequency of length of enrollment spans by record for members with medical and drug coverage.

Specification: enr_rec_covlength_md

Table 8.138: Specification: enr_rec_covlength_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 Character Data Partner identifier	Char (6)			Source: Data Partner ID populated using Common Components macro variable DP
LOE	Length of Enrollment (days)	Num (8)	COMMA12.	Length of Enrollment (days)	Source: SCDM Enrollment Table Derivation: LOE=Enr_End - Enr_Start +1	Any positive integer
Count	Count of records by length of enrollment.	Num (8)	COMMA16.	Record Count		Any positive integer or 0

8.1.133.2 enr_pat_covlength_md

Frequency of total length of enrollment span in days by unique PatID.

Specification: enr_pat_covlength_md

Table 8.139: Specification: enr_pat_covlength_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 Character Data Partner identifier	Char (6)			Source: Data Partner ID populated using Common Components macro variable DP
tLOE	Total length of Enrollment (days)	Num (8)	COMMA12.	Total length of Enrollment (days)	Source: SCDM Enrollment Table Derivation: tLOE=sum(Enrollment.Enr_End - Enrollment.Enr_Start +1) per unique Enrollment.Patid whereEnrolllment.MedCov=‘Y’ and Enrollment.DrugCov=‘Y’.	Any positive integer
Count	Count of unique Enrollment.PatID per tLOE	Num (8)	COMMA16.	Enrollee Count		Any positive integer or 0

8.1.133.3 enr_patid_ct_md_y

Number of PatIDs with at least one day of medical and drugcoverage by year.

Specification: enr_patid_ct_md_y

Table 8.140: Specification: enr_patid_ct_md_y

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	3-6 Character Data Partner identifier	Char (6)			Source: Data Partner ID populated using Common Components macro variable DP
Year	Calendar Year	Num (8)	YEAR4.		Source: SCDM Enrollment Table Derivation: Enr_Start, Enr_End
Count	Count of unique PatID by year	Num (8)	COMMA15.	PatID count by year		Any positive integer or 0

8.1.133.4 enr_patid_ct_md

Number of PatIDs with at least one day of medical and drug coverage.

Specification: enr_patid_ct_md

Table 8.141: Specification: enr_patid_ct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Count	Count of unique PatID	Num (8)	Comma15.	Total PatID Count		Any positive integer

8.1.133.5 enr_active_patid_ct_md

Number of actively enrolled patients as of a Data Partner’s overall maximum date for data completeness (DP_MaxDate).

Specification: enr_active_patid_ct_md

Table 8.142: Specification: enr_active_patid_ct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
DP_MaxDate	Based on macro variable &dp_maxdate (created by common components)	Num (4)	mmddyy10.
Count	Count of unique PatID where last enrollment.Enr_End ge DP_MaxDate	Num (8)	Comma12.	Active Enrollee Count		Any positive integer

8.1.133.6 dem_pat_lstagecount_md

Age distribution of all PatIDs with at least one day of medical and drug coverage. Age reflective of the member’s first day of enrollment of most recent enrollment span.

Specification: dem_pat_lstagecount_md

Table 8.143: Specification: dem_pat_lstagecount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
SortOrder	An input table will be used to specify these values	Num (3)				Any positive integer
Age_Category	Age Category	Char(TBD) (NA)	TBD		Source: TBD
Count	Count of unique PatID	Num (8)	Comma12.	Enrollee Count		Any positive integer

8.1.133.7 dem_pat_actagecount_md

Age distribution of actively enrolled PatIDs with at least one day of medical and drug coverage. Age reflective of the member’s first day of enrollment based on their active enrollment span.

Specification: dem_pat_actagecount_md

Table 8.144: Specification: dem_pat_actagecount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
SortOrder	An input table will be used to specify these values	Num (3)				Any positive integer
Age_Category	Age Category	Char(TBD) (NA)	TBD		Source: TBD
Count	Count of unique PatID where last enrollment.Enr_End ge DP_MaxDate	Num (8)	Comma12.	Active Enrollee Count		Any positive integer

8.1.133.8 dem_sexct_md

Distribution of sex for members that have at least one span of medical and drug coverage.

Specification: dem_sexct_md

Table 8.145: Specification: dem_sexct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Sex	Sex Category (Ambiguous, Female, Male, Unknown)	Char (1)	$1	Sex Category
Count	Count of unique PatID	Num (8)	Comma12.	Enrollee Count		Any positive integer

8.1.133.9 dem_hispanicct_md

Distribution of Hispanic status for members that have at least one span of medical and drug coverage.

Specification: dem_hispanicct_md

Table 8.146: Specification: dem_hispanicct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Hispanic	Hispanic Status (No, Yes, Unknown)	Char (1)	$1	Hispanic Status		N = No Y = Yes U = Unknown
Count	Count of unique PatID	Num (8)	Comma12.	Enrollee Count		Any positive integer

8.1.133.10 dem_racect_md

Distribution of race for members that have at least one span of medical and drug coverage.

Specification: dem_racect_md

Table 8.147: Specification: dem_racect_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Race	Race Category	Char (1)	$1	Race Category		0 = Unknown 1 = American Indian or Alaska Native 2 = Asian 3 = Black or African American 4 = Native Hawaiian or Other Pacific Islander 5 = White
Count	Count of unique PatID	Num (8)	Comma12.	Enrollee Count		Any positive integer

8.1.133.11 dem_geolocct_md

Distribution of geographic location (state-level) for members that have at least one span of medical and drug coverage.

Specification: dem_geolocct_md

Table 8.148: Specification: dem_geolocct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
StateCode	Geographic Location (2-letter uppercase US state abbreviation, ‘00’ for missing zip, ‘99’ for invalid zip values, and ‘OT’ for Other)	Char (2)	$2	Geographic Location	Source: lkp_dem_zip.sas7bdat Note 1: American Samoa (AS), Micronesia (FM), Guam (GU), Marshall Islands (MH), Northern Mariana Islands (MP), Puerto Rico (PR), Palau (PW) and U.S. Virgin Islands are aggregated as OT	00 = Overall 99 = Missing OT = U.S. Overseas Territories and Freely Associated States AL = Alabama AK = Alaska AZ = Arizona AR = Arkansas CA = California CO = Colorado CT = Connecticut DE = Delaware DC = District of Columbia FL = Florida GA = Georgia HI = Hawaii ID = Idaho IL = Illinois IN = Indiana IA = Iowa KS = Kansas KY = Kentucky LA = Louisiana ME = Maine MD = Maryland MA = Massachusetts MI = Michigan MN = Minnesota MS = Mississippi MO = Missouri MT = Montana NE = Nebraska NV = Nevada NH = New Hampshire NJ = New Jersey NM = New Mexico NY = New York NC = North Carolina ND = North Dakota OH = Ohio OK = Oklahoma OR = Oregon PA = Pennsylvania RI = Rhode Island SC = South Carolina SD = South Dakota TN = Tennessee TX = Texas UT = Utah VT = Vermont VA = Virginia WA = Washington WV = West Virginia WI = Wisconsin WY = Wyoming
Count	Count of unique PatID	Num (8)	Comma12.	Enrollee Count		Any positive integer

8.1.133.12 dis_pat_rxcount_md

Number of dispensings per member, while actively enrolled in medical and drug coverage.

Specification: dis_pat_rxcount_md

Table 8.149: Specification: dis_pat_rxcount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Rx_Count	Dispensing Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.13 dis_pat_rxcount_d

Number of dispensings per member, while actively enrolled in drug coverage.

Specification: dis_pat_rxcount_d

Table 8.150: Specification: dis_pat_rxcount_d

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Rx_Count	Dispensing Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.14 enc_pat_enccount_md

Number of encounters per member, while actively enrolled in medical and drug coverage.

Specification: enc_pat_enccount_md

Table 8.151: Specification: enc_pat_enccount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Enc_Count	Encounter Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.15 lab_pat_testcount_md

Number of laboratory result records per member, while actively enrolled in medical and drug coverage.

Specification: lab_pat_testcount_md

Table 8.152: Specification: lab_pat_testcount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Lab_Count	Lab Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.16 vit_pat_vitct_md

Number of members with at least one vital sign measurement, per type (height, weight, systolic BP, diastolic BP), while actively enrolled in medical and drug coverage.

Specification: vit_pat_vitct_md

Table 8.153: Specification: vit_pat_vitct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
VS_type	Vital Sign	Char (3)	$3	Vital Sign	Source: Valid Values: HGT=Height, WGT=Weight, SYS=Systolic, DIA=Diastolic	HGT = Height WGT = Weight SYS = Systolic DIA = Diastolic
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.17 enr_pat_enrcount_md

Number of enrollment spans per member, while actively enrolled in medical and drug coverage.

Specification: enr_pat_enrcount_md

Table 8.154: Specification: enr_pat_enrcount_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Enr_Count	Enrollment Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.18 dth_dthct_md

Number of death records for members that had at least one span of medical and drug coverage (active or inactive at time of death).

Specification: dth_dthct_md

Table 8.155: Specification: dth_dthct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Count	Death Record Count	Num (8)	Comma12.			Any positive integer

8.1.133.19 dth_dthct_m

Number of death records for members that had at least one span of medical coverage (active or inactive at time of death).

Specification: dth_dthct_m

Table 8.156: Specification: dth_dthct_m

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
Count	Death Record Count	Num (8)	Comma12.			Any positive integer

8.1.133.20 cod_pat_codct_md

Number of Cause of death (COD) records by members that had at least one span of medical and drug coverage (active or inactive at time of death).

Specification: cod_pat_codct_md

Table 8.157: Specification: cod_pat_codct_md

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
COD_Count	COD Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.1.133.21 cod_pat_codct_m

Number of Cause of death (COD) records for members that had at least one span of medical coverage (active or inactive at time of death).

Specification: cod_pat_codct_m

Table 8.158: Specification: cod_pat_codct_m

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
DP	Data Partner ID	Char (6)	$6
COD_Count	COD Record Count	Num (8)	Comma12.			Any positive integer
Count	Enrollee Count	Num (8)	Comma12.			Any positive integer

8.2 DPLOCAL Folder

Table 8.159 describes the QA Program Package output datasets found in the dplocal directory. These datasets stay with the Data Partner are not returned to SOC. Subsection 8.2.6 describes the Mother-Infant Identification DPLOCAL output.

Table 8.159: QA Package DPLOCAL Folder Output

Dataset	TabID	Level	Description
all_l1_flags	ALL	L1	This dataset contains one record per unique FlagID for Level 1 data checks and associated frequency.
all_match_encounterid	ALL		This dataset a list of distinct EncounterID values stratified by a binary indicator of presence by each utilization table.
all_match_facilityid	ALL		This dataset a list of distinct FacilityID values stratified by a binary indicator of presence in the Encounter table.
all_match_patid	ALL		This dataset a list of distinct PatID values stratified by a binary indicator of presence in SCDM enrollment, demographic, and utilization tables.
all_match_providerid	ALL		This dataset a list of distinct ProviderID values stratified by a binary indicator of presence in SCDM utilization tables.

8.2.1 all_l1_flags

This dataset contains one record per unique FlagID for Level 1 data checks and associated frequency.

Specification: all_l1_flags

Table 8.160: Specification: all_l1_flags

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
FlagID	List of unique FlagIDs	Char (21)		$21.		Unique FlagID = See Level 1 Quality Checks
Flag_Descr		Char (255)		$255.
FlagType	Indicates the flag’s FlagType	Char (4)		$4.		FAIL = Indicates a flag which, if thrown, will cause the Data Refresh to fail WARN = Indicates a flag which, if thrown, may require attention NOTE = Indicates a flag used for tracking trends in the data
AbortYN	Indicates whether the flag will cause the Quality Assurance Package to abort, if thrown.	Char (1)		$1.		Y = Flag will cause QA Package to abort N = Flag will not cause QA Package to abort
Variable1	Indicates the SCDM variable associated with the flag	Char (21)		$21.
Value		Char (6)		$6.
count		Num (8)		COMMA18.

8.2.2 all_match_encounterid

This dataset a list of distinct EncounterID values stratified by a binary indicator of presence by each utilization table.

Specification: all_match_encounterid

Table 8.161: Specification: all_match_encounterid

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	FORMAT	LABEL	NOTES	VALUES
EncounterID	Unique encounter identifier	Num (Site specific)	COMMA15.			Unique encounter identifier
ENC	Binary indicator for presence of EncounterID value in Encounter table	Char (1)	$1.		Source: ENC.encounterid	1 = True 0 = False
DIA	Binary indicator for presence of EncounterID value in Diagnosis table	Char (1)	$1.		Source: DIA.encounterid	1 = True 0 = False
PRO	Binary indicator for presence of EncounterID value in Procedure table	Char (1)	$1.		Source: PRO.encounterid	1 = True 0 = False

8.2.3 all_match_facilityid

This dataset a list of distinct FacilityID values stratified by a binary indicator of presence in the Encounter table.

Specification: all_match_facilityid

Table 8.162: Specification: all_match_facilityid

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
FacilityID	Unique facility identifier	Num (Site specific)	Servicing facility identifier	COMMA15.		Unique encounter identifier
FAC	Binary indicator for presence of FacilityID value in Facility table	Char (1)		$1.	Source: FAC.FacilityID	1 = True 0 = False
ENC	Binary indicator for presence of FacilityID value in Encounter table	Char (1)		$1.	Source: ENC.encounterid	1 = True 0 = False

8.2.4 all_match_patid

This dataset a list of distinct PatID values stratified by a binary indicator of presence in SCDM enrollment, demographic, and utilization tables.

Specification: all_match_patid

Table 8.163: Specification: all_match_patid

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
PatID	Arbitrary Unique patient-level identifier	Num (Site specific)	Arbitrary Unique patient-level identifier	COMMA15.		Unique encounter identifier
ENR	Binary indicator for presence of PatID value in Enrollment table	Char (1)		$1.	Source: ENR.PatID	1 = True 0 = False
DEM	Binary indicator for presence of PatID value in Demographic table	Char (1)		$1.	Source: DEM.PatID	1 = True 0 = False
DIA	Binary indicator for presence of PatID value in Diagnosis table	Char (1)		$1.	Source: DIA.PatID	1 = True 0 = False
DIS	Binary indicator for presence of PatID value in Dispensing table	Char (1)		$1.	Source: DIS.PatID	1 = True 0 = False
ENC	Binary indicator for presence of PatID value in Encounter table	Char (1)		$1.	Source: ENC.PatID	1 = True 0 = False
PRO	Binary indicator for presence of PatID value in Procedure table	Char (1)		$1.	Source: PRO.PatID	1 = True 0 = False

8.2.5 all_match_providerid

This dataset a list of distinct ProviderID values stratified by a binary indicator of presence in SCDM utilization tables.

Specification: all_match_providerid

Table 8.164: Specification: all_match_providerid

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
ProviderID	Unique provider identifier	Num (Site specific)	Unique provider identifier	COMMA15.		Unique encounter identifier
DIA	Binary indicator for presence of ProviderID value in Diagnosis table	Char (1)		$1.	Source: DIA.Provider	1 = True 0 = False
DIS	Binary indicator for presence of ProviderID value in Dispensing table	Char (1)		$1.	Source: DIS.ProviderID	1 = True 0 = False
PRO	Binary indicator for presence of ProviderID value in Procedure table	Char (1)		$1.	Source: PRO.ProviderID	1 = True 0 = False

8.2.6 Mother-Infant ID DPLOCAL output

Table 8.165 describes the Mother-Infant Identification output datasets found in the dplocal directory. These datasets stay with the Data Partner are not returned to SOC.

Table 8.165: Mother-Infant Identification DPLOCAL Folder Output

Dataset	Description
r01_deliveries	The Live Birth Deliveries dataset contains one record per MPatID and ADate. This file is created following identification of mothers (via evidence of live delivery by individuals aged 10–54 inclusive and an assigned value of Female in the Sentinel Common Data Model demographic table variable Sex. This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table.
r02_infants	This dataset contains one record per CPatID. This file is created following identification of children with a date of birth during the specified time period in the Sentinel Distributed Database (SDD). This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table.
delivery_codes	This file contains all delivery clinical codes identified in the Encounter in which a delivery occurred. Non-delivery clinical codes that occurred in the Encounter will not be included in this table.

8.2.6.1 r01_deliveries

The Live Birth Deliveries dataset contains one record per MPatID and ADate. This file is created following identification of mothers (via evidence of live delivery by individuals aged 10–54 inclusive and an assigned value of Female in the Sentinel Common Data Model demographic table variable Sex. This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table.

Specification: r01_deliveries

Table 8.166: Specification: r01_deliveries

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
MPatID	Must match mother PatID value in all other SCDM tables. Can appear in more than one row when multiple pregnancies/deliveries for the mother have occurred	Num (Site specific)	Mother patient ID	##		Unique Member Identifier
MBirth_Date	Mother Birth_Date from SCDM Demographic table	Num (4)	Mother birth date	MMDDYY10.		SAS Date
Age	Mother’s age as of ADate	Num (3)	Mother’s age	$2		Integer age: 10-54 inclusive
EncounterID	EncounterID value from SCDM Encounter table, for mother’s delivery encounter	Num (Site specific)	Mother’s delivery EncounterID	##		Unique encounter identifier
EncType	Based on SCDM Encounter table. If delivery codes on the same ADate are evident in more than one EncType, use this hierarchy to assign a single EncType: IP > IS> ED > AV > OA.	Char (2)	Encounter Type	$2		AV = Ambulatory Visit ED = Emergency Department IP = Inpatient Hospital Stay IS = Non-Acute Institutional Stay OA = Other Ambulatory Visit
FacilityID	Local facility code that identifies hospital or clinic. Taken from facility claims.	Num (Site specific)	Servicing provider identifier	##		Numeric facility identifier
ADate	ADate value from SCDM Encounter table, for mother’s delivery encounter	Num (4)	Admission date for mother’s delivery encounter	MMDDYY10.		SAS Date
DDate	DDate value from SCDM Encounter table, for mother’s delivery encounter	Num (4)	Discharge date for mother’s delivery encounter	MMDDYY10.		SAS Date .U = Unknown .S = Still in hospital
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)	# of babies born			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
Birth_Type_Primes	Multiplication of prime numbers assigned to all Birth_Types found in delivery codes within the selected encounter	Num (8)	All birth types	COMMA15.		2 = Unspecified # of live births 3 = 1 live birth 5 = 2 live births 7 = 3 live births 11 = 4 live births 13 = 5 live births 17 = Multiple live births, unspecified number 19 = Conflicting code(s) for number of live births

8.2.6.2 r02_infants

This dataset contains one record per CPatID. This file is created following identification of children with a date of birth during the specified time period in the Sentinel Distributed Database (SDD). This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table.

Specification: r02_infants

Table 8.167: Specification: r02_infants

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
CPatID	Must match child PatID value in all other SCDM tables. Can appear in more than one row when multiple pregnancies/deliveries for the mother have occurred	Num (Site specific)	Child patient ID	##		Unique Member Identifier
CBirth_Date	Birth_Date value from SCDM Demographic table	Num (4)	Child birth date	MMDDYY10.		SAS Date
Sex	Sex value from the SCDM Demographic table	Char (1)	Child’s Sex	$1.		A = Ambiguous F = Female M = Male U = Unknown
CEnr_Start	Earliest Enr_Start from Enrollment table	Num (4)	Earliest infant enrollment start date	MMDDYY10.		SAS Date

8.2.6.3 delivery_codes

This file contains all delivery clinical codes identified in the Encounter in which a delivery occurred. Non-delivery clinical codes that occurred in the Encounter will not be included in this table.

Specification: delivery_codes

Table 8.168: Specification: delivery_codes

VARIABLE	DESCRIPTION	VARIABLE TYPE (LENGTH)	LABEL	FORMAT	NOTES	VALUES
MPatID	Must match mother PatID value in all other SCDM tables. Can appear in more than one row when multiple pregnancies/deliveries for the mother have occurred or when there is more than one delivery code per EncounterID.	Num (Site specific)	Mother patient ID	##.		Unique Member Identifier
EncounterID	EncounterID value from SCDM Encounter table, for mother’s delivery encounter. Can appear in more than one row when there is more than one delivery code per EncounterID	Num (Site specific)	Mother’s delivery EncounterID	##.		Unique encounter identifier
Birth_Type	Indicate number of live births	Num (3)	Birth Type			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
CodeCat	Clinical code category.	Char (2)	Code category	$2.		DX = Diagnosis PX = Procedure
CodeType	Clinical code set type.	Char (2)	Code type	$2.		09 = ICD-9-CM 10 = ICD-10-CM C4 = CPT-4/HCPCS Level 1
ClinCode	Clinical code.	Char (7)	Clinical code	$7.		Valid clinical codes, in concordance with CodeCat and CodeType