Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (7) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Req_Perf_Location_DE table |
| EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
 | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
 (5) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
 | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
 ![Check Constraints CK_Req_Perf_Location_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
![Check Constraints CK_Req_Perf_Location_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
 (7)![Check Constraints CK_Req_Perf_Location_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
| EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
| LMRP | int | 4 | NOT NULL | | (0) | Local Medical Review Policy. to AHSCharge.dbo.LMRP.LMRP |
| AddressLine1 | varchar(35) | 35 | NULL allowed | | | Address Line 1 |
| AddressLine2 | varchar(35) | 35 | NULL allowed | | | Address Line 2 |
| City | varchar(35) | 35 | NULL allowed | | | City |
| State | varchar(35) | 35 | NULL allowed | | | State |
| ZipCode | char(10) | 10 | NULL allowed | | | Zip Code |
| PhoneArea | smallint | 2 | NULL allowed | | | Phone Area code. |
| PhoneExchange | smallint | 2 | NULL allowed | | | Phone exchange |
| PhoneLast4 | smallint | 2 | NULL allowed | | | Last 4 digits of phone |
| PhoneExtension | [dbo].[extension] | 5 | NULL allowed | | | Phone extension number. |
| FaxArea | smallint | 2 | NULL allowed | | | Fax Area code |
| FaxExchange | smallint | 2 | NULL allowed | | | Fax exchange |
| FaxLast4 | smallint | 2 | NULL allowed | | | Last 4 digits of Fax |
| Custom1 | varchar(35) | 35 | NULL allowed | | | Custom 1 free text value |
| Custom2 | varchar(35) | 35 | NULL allowed | | | Custom 2 free text value |
| Custom3 | varchar(35) | 35 | NULL allowed | | | Custom 3 free text value |
| Custom4 | varchar(35) | 35 | NULL allowed | | | Custom 4 free text value |
| Custom5 | varchar(35) | 35 | NULL allowed | | | Custom 5 free text value |
 | CommunicationMethod | [dbo].[dict_id] | 5 | NULL allowed | | | Communication Method. to Communication_Method_DE.ID |
 | SourceDE | varchar(255) | 255 | NULL allowed | | | Source |
| TransmitInterval | int | 4 | NOT NULL | | (0) | Tranmit future orders N days before to be done date |
 | InboundOrderInterfaceAuthDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Order Interface Authorization. Link to InboundOrder_Interface_Auth_DE.ID |
 ![Check Constraints CK_Req_Perf_Location_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsDCFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Notify When Order is Discontinued (Y/N) |
 ![Check Constraints CK_Req_Perf_Location_DE_AcceptsCanceledFLAG_Yes_Or_No : ([AcceptsCanceledFLAG]='N' OR [AcceptsCanceledFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_AcceptsCanceledFLAG_Yes_Or_No : ([AcceptsCanceledFLAG]='N' OR [AcceptsCanceledFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsCanceledFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Notify when order is Cancelled (Y/N) |
 ![Check Constraints CK_Req_Perf_Location_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsEIEFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Notify when order is Invalidated (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_AcceptsCompletedFLAG_Yes_Or_No : ([AcceptsCompletedFLAG]='N' OR [AcceptsCompletedFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_AcceptsCompletedFLAG_Yes_Or_No : ([AcceptsCompletedFLAG]='N' OR [AcceptsCompletedFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsCompletedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Notify when order is Completed (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_InterfaceEnabled_Yes_Or_No : ([InterfaceEnabled]='N' OR [InterfaceEnabled]='Y') Check Constraints CK_Req_Perf_Location_DE_InterfaceEnabled_Yes_Or_No : ([InterfaceEnabled]='N' OR [InterfaceEnabled]='Y')](../../../../Images/c-constraint.png) | InterfaceEnabled | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Order Interface is used (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITHoldForFirstTime_Yes_Or_No : ([OrderXMITHoldForFirstTime]='N' OR [OrderXMITHoldForFirstTime]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITHoldForFirstTime_Yes_Or_No : ([OrderXMITHoldForFirstTime]='N' OR [OrderXMITHoldForFirstTime]='Y')](../../../../Images/c-constraint.png) | OrderXMITHoldForFirstTime | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Transmit oder when initially becomes on hold (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITHoldForSubsequentTime_Yes_Or_No : ([OrderXMITHoldForSubsequentTime]='N' OR [OrderXMITHoldForSubsequentTime]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITHoldForSubsequentTime_Yes_Or_No : ([OrderXMITHoldForSubsequentTime]='N' OR [OrderXMITHoldForSubsequentTime]='Y')](../../../../Images/c-constraint.png) | OrderXMITHoldForSubsequentTime | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Transmit every order edit while on-hold (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITActiveFirstTime_Yes_Or_No : ([OrderXMITActiveFirstTime]='N' OR [OrderXMITActiveFirstTime]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITActiveFirstTime_Yes_Or_No : ([OrderXMITActiveFirstTime]='N' OR [OrderXMITActiveFirstTime]='Y')](../../../../Images/c-constraint.png) | OrderXMITActiveFirstTime | [dbo].[BOOL] | 1 | NULL allowed | | ('Y') | Transmit oder when initially becomes active (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITActiveSubsequentTime_Yes_Or_No : ([OrderXMITActiveSubsequentTime]='N' OR [OrderXMITActiveSubsequentTime]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITActiveSubsequentTime_Yes_Or_No : ([OrderXMITActiveSubsequentTime]='N' OR [OrderXMITActiveSubsequentTime]='Y')](../../../../Images/c-constraint.png) | OrderXMITActiveSubsequentTime | [dbo].[BOOL] | 1 | NULL allowed | | ('Y') | Transmit every order edit while Active (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITCanceled_Yes_Or_No : ([OrderXMITCanceled]='N' OR [OrderXMITCanceled]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITCanceled_Yes_Or_No : ([OrderXMITCanceled]='N' OR [OrderXMITCanceled]='Y')](../../../../Images/c-constraint.png) | OrderXMITCanceled | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Transmit order when it is Cancelled |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITDiscontinued_Yes_Or_No : ([OrderXMITDiscontinued]='N' OR [OrderXMITDiscontinued]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITDiscontinued_Yes_Or_No : ([OrderXMITDiscontinued]='N' OR [OrderXMITDiscontinued]='Y')](../../../../Images/c-constraint.png) | OrderXMITDiscontinued | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Transmit order when it is Discontinued |
![Check Constraints CK_Req_Perf_Location_DE_OrderXMITEIE_Yes_Or_No : ([OrderXMITEIE]='N' OR [OrderXMITEIE]='Y') Check Constraints CK_Req_Perf_Location_DE_OrderXMITEIE_Yes_Or_No : ([OrderXMITEIE]='N' OR [OrderXMITEIE]='Y')](../../../../Images/c-constraint.png) | OrderXMITEIE | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Transmit order when it is Invalidated |
![Foreign Keys FK_Req_Perf_Location_DE_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDE Foreign Keys FK_Req_Perf_Location_DE_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDE](../../../../Images/fk.png) | DefaultBillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Default billing location. Link to: Billing_Location_DE.ID. |
![Check Constraints CK_Req_Perf_Location_DE_HubUsedFLAG_Yes_Or_No : ([HubUsedFLAG]='N' OR [HubUsedFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_HubUsedFLAG_Yes_Or_No : ([HubUsedFLAG]='N' OR [HubUsedFLAG]='Y')](../../../../Images/c-constraint.png) | HubUsedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Sedn through the HUB (Y/N) |
![Check Constraints CK_Req_Perf_Location_DE_RequisitionLockUsedFLAG_Yes_Or_No : ([RequisitionLockUsedFLAG]='N' OR [RequisitionLockUsedFLAG]='Y') Check Constraints CK_Req_Perf_Location_DE_RequisitionLockUsedFLAG_Yes_Or_No : ([RequisitionLockUsedFLAG]='N' OR [RequisitionLockUsedFLAG]='Y')](../../../../Images/c-constraint.png) | RequisitionLockUsedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Use Requisition Locking (Y/N) |
| Destination | varchar(35) | 35 | NOT NULL | | ('') | Destination ID freetext entry |
| DestinationSite | varchar(35) | 35 | NOT NULL | | ('') | Destination Site ID freetext entry |
| OrderTypes | varchar(75) | 75 | NOT NULL | | ('') | R - Referrals L - Laboratory U - Follow-up X - DX Imaging F - Clinical Findings D - Other Diagnostic Testing P - Precautions S - Supplies I - Instructions |
| ProblemCodesAccepted | varchar(50) | 50 | NOT NULL | | ('ICD-9 Primary Codes Only') | ICD codes accepted from the lab. Values: ICD-9 Primary Codes Only ICD-9 All Primary and Secondary Codes ICD-10 Primary Codes Only ICD-10 All Primary and Secondary |
![Foreign Keys FK_Req_Perf_Location_DE_ServiceLocationDE_Service_Location_DE_ID: [dbo].[Service_Location_DE].ServiceLocationDE Foreign Keys FK_Req_Perf_Location_DE_ServiceLocationDE_Service_Location_DE_ID: [dbo].[Service_Location_DE].ServiceLocationDE](../../../../Images/fk.png) | ServiceLocationDE | [dbo].[dict_id] | 5 | NULL allowed | | | Healthcare Service Delivery Location. Link to Service_Location_DE.ID. |