Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  (9) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Plan_Item table. |
(3)![Foreign Keys FK_Plan_Item_ItemID_Item_Plan_ID: [dbo].[Item_Plan].ItemID Foreign Keys FK_Plan_Item_ItemID_Item_Plan_ID: [dbo].[Item_Plan].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item. Link to Item_Plan.ID |
| NoteActivityID | numeric(16,0) | 9 | NOT NULL | | Audit Note. Link to Act_Hdr_Note.ID |
 | SourceDE | [dbo].[dict_id] | 5 | NOT NULL | | Source for the specimen. Link to Source_DE.ID |
(2) | WherePerformedDE | [dbo].[dict_id] | 5 | NOT NULL | | Where Performed. Link to Where_Performed_DE.ID. |
 | ClinicalPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | | Priority. Link to Clinical_Priority_DE.ID. Possible values are ASAP, Pre-Op, Routine, Stat, Today |
(2) | OrderStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Status. Link to Order_Status_DE.ID |
 | OrderNumberEXT | varchar(30) | 30 | NOT NULL | (' ') | External Order Number |
| PlanText | varchar(255) | 255 | NOT NULL | (' ') | Order Text. No longer used. |
| PlanReason | varchar(255) | 255 | NOT NULL | (' ') | Order Reason Text. No longer used. |
 | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Who this was entered for. The Ordering Provider. Link to Provider.ID. |
(2) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Who entered the order. Link to IDX_User.ID |
| FuzzyDate | varchar(50) | 50 | NOT NULL | (' ') | Requested order's Date and Time in string format. |
 | RequestedDTTM | datetime | 8 | NULL allowed | | Requested Date and time in proper Date time format |
| OverDueDTTM | datetime | 8 | NULL allowed | | overdue date and time |
![Check Constraints CK_Plan_Item_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E') Check Constraints CK_Plan_Item_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Creation reason. A -Added |
(3) | WhenRecordedDTTM | datetime | 8 | NOT NULL | | Recorded Date and Time |
 | WhenPerformedDTTM | datetime | 8 | NOT NULL | | Performed Date and Time |
 ![Check Constraints CK_Plan_Item_HasChargeInfoFLAG_Yes_Or_No : ([HasChargeInfoFLAG]='N' OR [HasChargeInfoFLAG]='Y') Check Constraints CK_Plan_Item_HasChargeInfoFLAG_Yes_Or_No : ([HasChargeInfoFLAG]='N' OR [HasChargeInfoFLAG]='Y')](../../../../Images/c-constraint.png) | HasChargeInfoFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Indicates whether any Charge is assosciated to the Order (Y/N) |
| QOMOD1DESnapshot | [dbo].[dict_id] | 5 | NOT NULL | ('0') | First Order Modifier. Link to QO_Mod_DE.ID |
| QOMOD2DESnapshot | [dbo].[dict_id] | 5 | NOT NULL | ('0') | Second Order Modifier. Link to QO_Mod_DE.ID |
| QOMOD3DESnapshot | [dbo].[dict_id] | 5 | NOT NULL | ('0') | Third Order Modifier. Link to QO_Mod_DE.ID |
| QOMOD1PicklistSnapshot | varchar(300) | 300 | NULL allowed | ('') | First Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname |
| QOMOD2PicklistSnapshot | varchar(300) | 300 | NULL allowed | ('') | Second Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname |
| QOMOD3PicklistSnapshot | varchar(300) | 300 | NULL allowed | ('') | Third Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname |
 | FuzyPreOpDate | varchar(50) | 50 | NOT NULL | ('') | Pre-Operation date. |
 | AuthorizationNumber | varchar(20) | 20 | NOT NULL | ('') | Authorization Number |
 | NonGeneratedExtID | varchar(255) | 255 | NOT NULL | ('') | External Identifier |
 | LabelTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Label Type. Link to Label_Type_DE.ID |
 | PatientInstructions | varchar(1000) | 1000 | NOT NULL | ('') | Patient Instructions |
 | UseOrderAuthTasking | char(1) | 1 | NOT NULL | ('N') | Create order authorization tasks (Y/N) |
 | ReferralTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Referral Type. Link to Referral_Type_DE.ID |
 | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Specialty. Link to Specialty_DE.ID |
 | InternalExternal | char(1) | 1 | NOT NULL | ('') | I - Internal referral, E - External Referral |
 | ReferredToVendOrgDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Referred to Verdor (External) or Organization. Link to Vendor_DE.ID or Organization.ID. |
 | ReferredToRPLSiteDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Referred to Reqested Performig Location (External) or Site (Internal). Link to Req_Perf_Location_DE.ID or Site_DE.ID. |
 | ReferredToProviderDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Referred to Referring Provider (External) or Provider (Internal). Link to Referring_Provider_DE.ID or Provider.ID. |
 ![Check Constraints CK_Plan_Item_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y') Check Constraints CK_Plan_Item_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y')](../../../../Images/c-constraint.png) | FirstAvailableFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | First available Provider (Y/N) |
 | SpecimenTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Specimen type. Link to Specimen_Type_DE.ID |
 | FirstString | nvarchar(1024) | 2048 | NULL allowed | ('') | First String for Instructions or Precautions. |
 ![Check Constraints CK_Plan_Item_ChronicFLAG_Yes_Or_No : ([ChronicFLAG]='N' OR [ChronicFLAG]='Y') Check Constraints CK_Plan_Item_ChronicFLAG_Yes_Or_No : ([ChronicFLAG]='N' OR [ChronicFLAG]='Y')](../../../../Images/c-constraint.png) | ChronicFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Show on Orders List field in Order Detail window for Instruction/Precaution Order |
 | CallPhoneNumber | varchar(25) | 25 | NOT NULL | ('') | Phone number to call for Instruction/Precautions orders. |
 | ProblemLinkList | varchar(500) | 500 | NULL allowed | ('') | Linked Problems. Links to Problem_Header.ID |
 | PerformingComments | varchar(1000) | 1000 | NULL allowed | ('') | Performing Comments |
 ![Check Constraints CK_Plan_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Plan_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Unverified Order (Y/N) |
 | QOModPicklistID | [dbo].[dict_id] | 5 | NOT NULL | (0) | First Modifier Picklist. Link to Picklist.ID. |
 | QOModPicklist2ID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Second Modifier Picklist. Link to Picklist.ID. |
 | QOModPicklist3ID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Third Modifier Picklist. Link to Picklist.ID. |
 ![Check Constraints CK_Plan_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y') Check Constraints CK_Plan_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')](../../../../Images/c-constraint.png) | QOModPicklistReq | [dbo].[BOOL] | 1 | NOT NULL | ('N') | First Modifier Picklist is required to save the order (Y/N). |
 ![Check Constraints CK_Plan_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y') Check Constraints CK_Plan_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist2Req | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Second Modifier Picklist is required to save the order (Y/N). |
 ![Check Constraints CK_Plan_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y') Check Constraints CK_Plan_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist3Req | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Third Modifier Picklist is required to save the order (Y/N). |
 | SourceSingleOrDefault | varchar(1) | 1 | NOT NULL | ('') | S - Default the Source and it can not be changed. D - Default the source and allow it to be changed. |
 | ReqV4OrderingAuthority | int | 4 | NOT NULL | (0) | Required Ordering Authority |
 | VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Task owner for verification tasks. Link to either IDX_User.ID or Team_DE.ID. |
 | VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Verification Task Owner Type. User or Team. |
 | OrderReasonDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Reason for order. Link to Order_Reason_DE.ID. |
 | Quantity | smallint | 2 | NOT NULL | (0) | Quantity. For supplies orders |
 ![Check Constraints CK_Plan_Item_DAWFLAG_Yes_Or_No : ([DAWFLAG]='N' OR [DAWFLAG]='Y') Check Constraints CK_Plan_Item_DAWFLAG_Yes_Or_No : ([DAWFLAG]='N' OR [DAWFLAG]='Y')](../../../../Images/c-constraint.png) | DAWFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Dispense as Written (Y/N) |
 | Urgency | varchar(10) | 10 | NOT NULL | ('') | Urgency for precaution orders (Call, Urgent, Emergent) |
 | OrderReason | varchar(2000) | 2000 | NULL allowed | ('') | Textual order reason |
![Check Constraints CK_Plan_Item_ToBeCollectedFLAG_Yes_Or_No : ([ToBeCollectedFLAG]='N' OR [ToBeCollectedFLAG]='Y') Check Constraints CK_Plan_Item_ToBeCollectedFLAG_Yes_Or_No : ([ToBeCollectedFLAG]='N' OR [ToBeCollectedFLAG]='Y')](../../../../Images/c-constraint.png) | ToBeCollectedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Specimen Needs to be collected (Y/N) |
![Check Constraints CK_Plan_Item_DoNotReleaseFLAG_Yes_Or_No : ([DoNotReleaseFLAG]='N' OR [DoNotReleaseFLAG]='Y') Check Constraints CK_Plan_Item_DoNotReleaseFLAG_Yes_Or_No : ([DoNotReleaseFLAG]='N' OR [DoNotReleaseFLAG]='Y')](../../../../Images/c-constraint.png) | DoNotReleaseFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Do not release (Y/N) |
![Check Constraints CK_Plan_Item_UserCanOverrideFLAG_Yes_Or_No : ([UserCanOverrideFLAG]='N' OR [UserCanOverrideFLAG]='Y') Check Constraints CK_Plan_Item_UserCanOverrideFLAG_Yes_Or_No : ([UserCanOverrideFLAG]='N' OR [UserCanOverrideFLAG]='Y')](../../../../Images/c-constraint.png) | UserCanOverrideFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | User can override the do not release flag (Y/N) |
| Summary | varchar(2000) | 2000 | NULL allowed | | Summary text |
| OrderInstructionReviewedBy | [dbo].[uniqueid] | 9 | NULL allowed | | Provider who Reviewed the Instruction. Link to IDX_User.ID. |
| OrderInstructionReviewedDTTM | datetime | 8 | NULL allowed | | Reviewed Date and time of the instruction order. |
| RecipientProviderID | [dbo].[uniqueid] | 9 | NULL allowed | | Recipient Provider. Link to provider.ID. |
| HPDProviderID | varchar(50) | 50 | NULL allowed | | Healthcare Provider Directory Provider Identifier |
| HPDProviderName | varchar(255) | 255 | NULL allowed | | Healthcare Provider Directory provider name |
| HPDDirectID | varchar(255) | 255 | NULL allowed | | Healthcare Provider Directory Direct Identifier for the provider |
![Check Constraints CK_Plan_Item_SpecialistResponseReceivedFLAG_Yes_Or_No : ([SpecialistResponseReceivedFLAG]='N' OR [SpecialistResponseReceivedFLAG]='Y') Check Constraints CK_Plan_Item_SpecialistResponseReceivedFLAG_Yes_Or_No : ([SpecialistResponseReceivedFLAG]='N' OR [SpecialistResponseReceivedFLAG]='Y')](../../../../Images/c-constraint.png) | SpecialistResponseReceivedFLAG | [dbo].[BOOL] | 1 | NULL allowed | | Responce received from the specialist (Y/N) |
| CommunityID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Community. Link to CED_Endpoints.ID |
![Check Constraints CK_Plan_Item_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y') Check Constraints CK_Plan_Item_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y')](../../../../Images/c-constraint.png) | FreeTextOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Free Text Order (Y/N) |
| FreeTextDescription | varchar(255) | 255 | NOT NULL | ('') | Free text description |
 | ArchiveState | tinyint | 1 | NOT NULL | ((0)) | 0 = Record is in Main Partition 1 = Record is in Archived Partition |
| LinkedItems | varchar(max) | max | NULL allowed | | List of linked Goals/Interventions |
| SnomedCodeList | varchar(255) | 255 | NOT NULL | ('') | SNOMED term codes of the Orderable item |
| LOINCCodeList | varchar(255) | 255 | NOT NULL | ('') | LOINC codes of the Orderable item |
| CPT4CodeList | varchar(255) | 255 | NOT NULL | ('') | CPT4 Codes of the Orderable item |