7.2 DPLOCAL Folder
Table 7.82 details the QA Program Package output datasets found in the dplocal directory. These datasets stay with the Data Partner are not returned to SOC.
| Dataset | TabID | Level | Description |
|---|---|---|---|
| all_l1_flags | 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. | |
| r01_deliveries | DEL | The Live Birth Deliveries file contains one record per MPatID and ADate. This file is created following identification of mothers (via evidence of live delivery by women aged 10-54 inclusive) in the SDD. This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table. | |
| r02_infants | INF | The Infant File 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. |
7.2.1 all_l1_flags
This dataset contains one record per unique FlagID for Level 1 data checks and associated frequency.
7.2.1.1 all_l1_flags Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | VALUES |
|---|---|---|---|---|---|---|
| FlagID | List of unique FlagIDs | Character | 21 | $21. | Unique FlagID = See Level 1 Quality Checks | |
| Flag_Descr | Character | 255 | $255. | |||
| FlagType | Indicates the flag’s FlagType | Character | 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. | Character | 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 | Character | 21 | $21. | ||
| Value | Character | 6 | $6. | |||
| count | Numeric | 8 | COMMA18. |
7.2.2 all_match_encounterid
This dataset a list of distinct EncounterID values stratified by a binary indicator of presence by each utilization table.
7.2.2.1 all_match_encounterid Specification
| VARIABLE | DESCRIPTION | TYPE | LENGTH | FORMAT | VALUES | SOURCE |
|---|---|---|---|---|---|---|
| EncounterID | Unique encounter identifier | Numeric | Site specific | COMMA15. | Unique encounter identifier | |
| ENC | Binary indicator for presence of EncounterID value in Encounter table | Character | 1 | $1. |
1 = True 0 = False |
ENC.encounterid |
| DIA | Binary indicator for presence of EncounterID value in Diagnosis table | Character | 1 | $1. |
1 = True 0 = False |
DIA.encounterid |
| PRO | Binary indicator for presence of EncounterID value in Procedure table | Character | 1 | $1. |
1 = True 0 = False |
PRO.encounterid |
7.2.3 all_match_facilityid
This dataset a list of distinct FacilityID values stratified by a binary indicator of presence in the Encounter table.
7.2.3.1 all_match_facilityid Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | VALUES | SOURCE |
|---|---|---|---|---|---|---|---|
| FacilityID | Unique facility identifier | Servicing facility identifier | Numeric | Site specific | COMMA15. | Unique encounter identifier | |
| FAC | Binary indicator for presence of FacilityID value in Facility table | Character | 1 | $1. |
1 = True 0 = False |
FAC.FacilityID | |
| ENC | Binary indicator for presence of FacilityID value in Encounter table | Character | 1 | $1. |
1 = True 0 = False |
ENC.encounterid |
7.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.
7.2.4.1 all_match_patid Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | VALUES | SOURCE |
|---|---|---|---|---|---|---|---|
| PatID | Arbitrary Unique patient-level identifier | Arbitrary Unique patient-level identifier | Numeric | Site specific | COMMA15. | Unique encounter identifier | |
| ENR | Binary indicator for presence of PatID value in Enrollment table | Character | 1 | $1. |
1 = True 0 = False |
ENR.PatID | |
| DEM | Binary indicator for presence of PatID value in Demographic table | Character | 1 | $1. |
1 = True 0 = False |
DEM.PatID | |
| DIA | Binary indicator for presence of PatID value in Diagnosis table | Character | 1 | $1. |
1 = True 0 = False |
DIA.PatID | |
| DIS | Binary indicator for presence of PatID value in Dispensing table | Character | 1 | $1. |
1 = True 0 = False |
DIS.PatID | |
| ENC | Binary indicator for presence of PatID value in Encounter table | Character | 1 | $1. |
1 = True 0 = False |
ENC.PatID | |
| PRO | Binary indicator for presence of PatID value in Procedure table | Character | 1 | $1. |
1 = True 0 = False |
PRO.PatID |
7.2.5 all_match_providerid
This dataset a list of distinct ProviderID values stratified by a binary indicator of presence in SCDM utilization tables.
7.2.5.1 all_match_providerid Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | VALUES | SOURCE |
|---|---|---|---|---|---|---|---|
| ProviderID | Unique provider identifier | Unique provider identifier | Numeric | Site specific | COMMA15. | Unique encounter identifier | |
| DIA | Binary indicator for presence of ProviderID value in Diagnosis table | Character | 1 | $1. |
1 = True 0 = False |
DIA.Provider | |
| DIS | Binary indicator for presence of ProviderID value in Dispensing table | Character | 1 | $1. |
1 = True 0 = False |
DIS.ProviderID | |
| PRO | Binary indicator for presence of ProviderID value in Procedure table | Character | 1 | $1. |
1 = True 0 = False |
PRO.ProviderID |
7.2.6 r01_deliveries
The Live Birth Deliveries file contains one record per MPatID and ADate. This file is created following identification of mothers (via evidence of live delivery by women aged 10-54 inclusive) in the SDD. This file will stay at the Data Partner and will be used to subsequently create a Sentinel Mother-Infant Linkage Table.
7.2.6.1 r01_deliveries Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | 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 | Mother patient ID | Numeric | Site specific | ## | Unique Member Identifier |
| MBirth_Date | Mother Birth_Date from SCDM Demographic table | Mother birth date | Numeric | 4 | MMDDYY10. | SAS Date |
| Age | Mother’s age as of ADate | Mother’s age | Numeric | 3 | $2 | Integer age: 10-54 inclusive |
| EncounterID | EncounterID value from SCDM Encounter table, for mother’s delivery encounter | Mother’s delivery EncounterID | Numeric | Site specific | ## | 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. | Encounter Type | Character | 2 | $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. | Servicing provider identifier | Numeric | Site specific | ## | Numeric facility identifier |
| ADate | ADate value from SCDM Encounter table, for mother’s delivery encounter | Admission date for mother’s delivery encounter | Numeric | 4 | MMDDYY10. | SAS Date |
| DDate | DDate value from SCDM Encounter table, for mother’s delivery encounter | Discharge date for mother’s delivery encounter | Numeric | 4 | MMDDYY10. |
SAS Date .U .S |
| Birth_Type |
Based upon ICD-9-CM/ICD-10-CM codes in the health plan data for the delivery admission. Will be 0 for non-specific codes
|
# of babies born | Numeric | 8 |
|
0 = Unspecified # of live births 1 = 1 live birth 2 = 2 live births 3 = 3 live births 4 = 4 live births 5 = 5 live births 8 = Multiple live births, unspecified number 9 = Conflicting code(s) for number of live births |
| Birth_Type_Primes | Multiplication of prime numbers assigned to all Birth_Types found in delivery codes within the selected encounter | All birth types | Numeric | 8 | 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 |
r02_infants
The Infant File 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.7.2.6.2 r02_infants Specification
| VARIABLE | DESCRIPTION | LABEL | TYPE | LENGTH | FORMAT | 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 | Child patient ID | Numeric | Site specific | ## | Unique Member Identifier |
| CBirth_Date | Birth_Date value from SCDM Demographic table | Child birth date | Numeric | 4 | MMDDYY10. | SAS Date |
| Sex | Sex value from the SCDM Demographic table | Child’s Sex | Character | 1 | $1. |
A = Ambiguous F = Female M = Male U = Unknown |
| CEnr_Start | Earliest Enr_Start from Enrollment table | Earliest infant enrollment start date | Numeric | 4 | MMDDYY10. | SAS Date |