VW_Base10_Resident_Tests_Export

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PatientID

varchar

35

√

null

FacilityId

int

4

null

PCC_Cache_FacID.FacilityID

Implied ConstraintR

FacilityCode

varchar

5

null

LabReportID

int

4

null

LabReportDetailID

int

4

null

PerformingLab

varchar

200

√

null

ReportDesciption

varchar

250

√

null

ReportDetail

varchar

100

√

null

ReportedDate

smalldatetime

16

√

null

Result

varchar

200

√

null

Relationships

Close relationships within degrees of separation

View Definition

CREATE VIEW dbo.VW_Base10_Resident_Tests_Export AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_Base10_Resident_Tests_Export
Created:		9/1/2021
Description:	 			
*********************************************************************/

    SELECT clr.ResidentNumber AS PatientID,
           clr.FacilityId,
           fac.FacilityCode,
           clr.LabReportID,
           clr.LabReportDetailID,
           clr.PerformingLab,
           clr.ReportDesciption,
           clr.ProfileDescription AS ReportDetail,
           /* Per Paula Love via email:
              "That [ReportDate] is the only date I entered and likely the only one we will use in this instance".
              Thus the other dates (OrderDate, SpecimenCollectionDate, SpecimenReceivedDate) are not passed on in this view.
            */
           clr.ReportedDate,
           UPPER(clr.Result) AS Result
    FROM dbo.Base10_PCC_CovidLabResults AS clr
    JOIN dbo.PCC_Cache_FacID AS fac
    ON clr.FacilityId = fac.FacilityID
    /* Exclude results prior to 8/3/2021, which were already entered in Base 10. */
    WHERE clr.ReportedDate >= '2021-08-04'

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views