Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Occupation_Industry
Touchworks 25.2
[dbo].[Patient_Occupation_Industry]
MS_Description
This table is used in Cancer Registry Report to store Patient's working history. It stores Patient's Occupation, Industry , start date and end date. This is displayed in the patient profile
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Patient_Occupation_Industry table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient.. Link to Person.ID.
PatientOccupationDE
[dbo].[dict_id]
5
NULL allowed
Occupation. Link to Patient_Occupation_DE.ID.
IndustryDE
[dbo].[dict_id]
5
NULL allowed
Industry. Link to Industry_DE.ID
StartDate
datetime
8
NULL allowed
Start date
EndDate
datetime
8
NULL allowed
End date
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Create Date, default = Getdate()
UpdatedDTTM
datetime
8
NOT NULL
(getdate())
Updated Date, default = Getdate()