Tables [dbo].[Patient_Occupation_Industry]
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
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key Pk_Patient_Occupation_Industry_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Patient_Occupation_Industry table
Indexes NIX_Patient_Occupation_Industry_PatientIDForeign Keys FK_Patient_Occupation_Industry_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient.. Link to Person.ID.
PatientOccupationDE[dbo].[dict_id]5NULL allowedOccupation. Link to Patient_Occupation_DE.ID.
IndustryDE[dbo].[dict_id]5NULL allowedIndustry. Link to Industry_DE.ID
StartDatedatetime8NULL allowedStart date
EndDatedatetime8NULL allowedEnd date
CreatedDTTMdatetime8NOT NULL(getdate())Create Date, default = Getdate()
UpdatedDTTMdatetime8NOT NULL(getdate())Updated Date, default = Getdate()