Touchworks 26.1
[dbo].[Patient_Lab_Def]
Default laboratory for a patient. Seen in the Patient profile dailog.
| Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
|---|---|---|---|---|---|---|
 ![Foreign Keys FK_Patient_Lab_Def_Patient: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png "Foreign Keys FK_Patient_Lab_Def_Patient: [dbo].[Patient_Member].PatientID") | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Patient_Member.ID | |
| ReqPerfLocationDE | [dbo].[dict_id] | 5 | NOT NULL | Lab. Link to Req_Perf_Location_DE.ID | |
| CreateDTTM | datetime | 8 | NOT NULL | (getdate()) | Created Time | |
![Check Constraints CK_Patient_Lab_Def_DefaultFLAG : ([DefaultFLAG]='N' OR [DefaultFLAG]='Y')](../../../../Images/c-constraint.png "Check Constraints CK_Patient_Lab_Def_DefaultFLAG : ([DefaultFLAG]='N' OR [DefaultFLAG]='Y')") | DefaultFLAG | char(1) | 1 | NOT NULL | ('Y') | Default lab for the Patient (Y/N)? |
| LastDefaultedDTTM | datetime | 8 | NULL allowed | Last time this was the Default for the patient. | ||
| LastUpdatedDTTM | datetime | 8 | NULL allowed | Last updated time | ||
| LastUpdatedByID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | User who Last updated. Link to IDX_User.ID. |