Tables [dbo].[PBM_Problem_List]
Problem List of a patient  as available from PBM
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key xcPBMProblemList_Pat_Prov: PatientID\ProviderIDForeign Keys FK_PBM_Problem_List_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. link to Person.ID
Cluster Key xcPBMProblemList_Pat_Prov: PatientID\ProviderIDProviderID[dbo].[uniqueid]9NOT NULLProvider
ReportedSourcevarchar(10)10NOT NULLSource of the reported problem. Ex PSA- Patient , MD - Physician, RPH - Pharmacist etc.
ReportedDTdatetime8NULL allowedReported Date time
ICD9Code[dbo].[code]10NOT NULLICD9 Diagnosis Code
ProblemDescriptionvarchar(512)512NULL allowedProblem description
Sourcevarchar(10)10NOT NULLPBM Souce
Indexes NIX_PBM_Problem_List_LinkActHdrIDForeign Keys FK_PBM_Problem_List_LinkActHdrID_Problem_ID: [dbo].[Problem].LinkActHdrIDLinkActHdrID[dbo].[uniqueid]9NOT NULL(0)Problem. Link to Problem.ID
LinkStatusvarchar(12)12NOT NULLLink Status