Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PBM_Problem_List
Touchworks 25.2
[dbo].[PBM_Problem_List]
MS_Description
Problem List of a patient as available from PBM
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. link to Person.ID
ProviderID
[dbo].[uniqueid]
9
NOT NULL
Provider
ReportedSource
varchar(10)
10
NOT NULL
Source of the reported problem. Ex PSA- Patient , MD - Physician, RPH - Pharmacist etc.
ReportedDT
datetime
8
NULL allowed
Reported Date time
ICD9Code
[dbo].[code]
10
NOT NULL
ICD9 Diagnosis Code
ProblemDescription
varchar(512)
512
NULL allowed
Problem description
Source
varchar(10)
10
NOT NULL
PBM Souce
LinkActHdrID
[dbo].[uniqueid]
9
NOT NULL
(0)
Problem. Link to Problem.ID
LinkStatus
varchar(12)
12
NOT NULL
Link Status