Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
(17)![Foreign Keys FK_Order_Activity_OrderActivityHeaderID_Order_Activity_Header_ID: [dbo].[Order_Activity_Header].OrderActivityHeaderID Foreign Keys FK_Order_Activity_OrderActivityHeaderID_Order_Activity_Header_ID: [dbo].[Order_Activity_Header].OrderActivityHeaderID](../../../../Images/fk.png) | OrderActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Header. Link to Order_Activity_Header.ID |
(2) | OrganizationID | numeric(8,0) | 5 | NOT NULL | | | Organization. Link to Organization.ID |
| NoteTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Note Type. Link to Note_Type_DE.ID. Always 0. |
| TemplateVersion | smallint | 2 | NOT NULL | | | Note template version. Link to Note_Template_Version.TemplateVersion. Always 0. |
 | OrderSourceDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Order Source. Link to order_source_de.ID |
 | OrderNumberEXT | varchar(20) | 20 | NOT NULL | | (' ') | External Order Number. This will be same as in Item_Result.OrderItemEXT. |
 | AccessionNumber | varchar(255) | 255 | NOT NULL | | (' ') | Accession Number |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | | Who it was entered for. Link to Provider.ID. |
 | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who entered. Link to IDX_User.ID |
(2) | CreatedDTTM | datetime | 8 | NOT NULL | | | Date and time when entry was created. |
![Check Constraints CK_Order_Activity_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Order_Activity_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | No longer Used. |
 | ClinicalDTTM | datetime | 8 | NOT NULL | | | Clinical Date and Time |
 | ClinicalSourceDE | [dbo].[dict_id] | 5 | NOT NULL | | | Clinical Source. Link to Source_DE.ID |
(2) | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Ordering Provider. Link to Provider.ID |
(2) | OrderStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Status. Link to Order_Status_DE.ID |
(2) | OrderPriorityDE | [dbo].[dict_id] | 5 | NULL allowed | | | Priority. Link to Clinical_Priority_DE.ID |
 | CommunicationModeDE | [dbo].[dict_id] | 5 | NULL allowed | | | Communication Method. Link to Communication_Method_DE.ID |
 | WherePerformedDE | [dbo].[dict_id] | 5 | NULL allowed | | | Requested Performing Location. Link to Req_Perf_Location_DE.ID. This is not where it was performed but where it was requested to be performed. |
(2) | ApprovingProviderID | [dbo].[uniqueid] | 9 | NULL allowed | | | Supervising (approving) provider. Link to Provider.ID |
| OrderComment | varchar(255) | 255 | NULL allowed | | | Order Comment. |
| Provider1toNotifyID | [dbo].[uniqueid] | 9 | NULL allowed | | | Provider to Notify. No longer used. |
| Provider2toNotifyID | [dbo].[uniqueid] | 9 | NULL allowed | | | Provider to Notify. No longer used. |
| Provider3toNotifyID | [dbo].[uniqueid] | 9 | NULL allowed | | | Provider to Notify. No longer used. |
| RequestedFuzzyWhen | varchar(50) | 50 | NULL allowed | | | To be done date |
| RequestedFuzzySpecificity | varchar(1) | 1 | NULL allowed | | | Specificity of the to be done date: D - Day M - Month Y - Year F - Freetext |
| RequestedFuzzySortAs | varchar(50) | 50 | NULL allowed | | | Specific date and time for the to be done date. |
(2) | OrderType | varchar(1) | 1 | NOT NULL | | | Type of order(Lab -L , Imageing -X, Diagnostic - D, FollowUp - U, Referral -R, Finding -F, Precaution -P, Instruction -I) |
| ContactName | varchar(50) | 50 | NULL allowed | | | No longer used. |
| ContactPhone | varchar(50) | 50 | NULL allowed | | | No longer used. |
| History | varchar(250) | 250 | NULL allowed | | | No longer used. |
| ExternalStatus | varchar(255) | 255 | NULL allowed | | | No longer used. |
| ScheduledForPart1 | varchar(255) | 255 | NULL allowed | | | No longer used. |
| ScheduledForPart2 | varchar(255) | 255 | NULL allowed | | | No longer used. |
| Resources | varchar(255) | 255 | NULL allowed | | | No longer used. |
 ![Check Constraints CK_Order_Activity_ManualStatusChangeFLAG_Yes_Or_No : ([ManualStatusChangeFLAG]='N' OR [ManualStatusChangeFLAG]='Y') Check Constraints CK_Order_Activity_ManualStatusChangeFLAG_Yes_Or_No : ([ManualStatusChangeFLAG]='N' OR [ManualStatusChangeFLAG]='Y')](../../../../Images/c-constraint.png) | ManualStatusChangeFLAG | [dbo].[BOOL] | 1 | NULL allowed | | | The user manually set the status (Y/N) |
| NoteHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Audit note header. Link to Act_hdr_note.ID |
| NoteActivityID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Audit note version. Link to Act_Note.ID |
 | financialAuthStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Financial authorization status. Link to financial_Auth_Status_DE.ID. |
 ![Foreign Keys FK_OA_OnHold_Status_DE: [dbo].[OnHold_Status_DE].OnHoldStatusDE Foreign Keys FK_OA_OnHold_Status_DE: [dbo].[OnHold_Status_DE].OnHoldStatusDE](../../../../Images/fk.png) | OnHoldStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | On hole status, Link to OnHold_Status_DE.ID |
 ![Foreign Keys FK_OA_Charge_Status_DE: [dbo].[Charge_Status_DE].OrderMNStatus Foreign Keys FK_OA_Charge_Status_DE: [dbo].[Charge_Status_DE].OrderMNStatus](../../../../Images/fk.png) | OrderMNStatus | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Medical Necessity status. Link to Charge_Status_DE.ID |
 (2) | OrderActivityID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Order_Activity table |