Tables [dbo].[Req_Perf_Location_DE]
Requested Preforming Locations
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Req_Perf_Location_DE_ID: IDCluster Key XAK1ReqPerfLocation_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2ReqPerfLocation_DE, XAK3ReqPerfLocation_DE, TWstat_Req_Perf_Location_DE_CommunicationMethod_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_InboundOrderInterfaceAuthDE_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_SourceDE_EntryName_IsCurrentFLAG_ID(7)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Req_Perf_Location_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Req_Perf_Location_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes XAK2ReqPerfLocation_DEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Cluster Key XAK1ReqPerfLocation_DE: EntryName\IsCurrentFLAG\IDIndexes TWstat_Req_Perf_Location_DE_CommunicationMethod_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_InboundOrderInterfaceAuthDE_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_SourceDE_EntryName_IsCurrentFLAG_ID(5)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3ReqPerfLocation_DEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes TWstat_Req_Perf_Location_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Req_Perf_Location_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=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')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1ReqPerfLocation_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2ReqPerfLocation_DE, XAK3ReqPerfLocation_DE, TWstat_Req_Perf_Location_DE_CommunicationMethod_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_InboundOrderInterfaceAuthDE_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Req_Perf_Location_DE_SourceDE_EntryName_IsCurrentFLAG_ID(7)Check Constraints CK_Req_Perf_Location_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
LMRPint4NOT NULL(0)Local Medical Review Policy. to AHSCharge.dbo.LMRP.LMRP
AddressLine1varchar(35)35NULL allowedAddress Line 1
AddressLine2varchar(35)35NULL allowedAddress Line 2
Cityvarchar(35)35NULL allowedCity
Statevarchar(35)35NULL allowedState
ZipCodechar(10)10NULL allowedZip Code
PhoneAreasmallint2NULL allowedPhone Area code.
PhoneExchangesmallint2NULL allowedPhone exchange
PhoneLast4smallint2NULL allowedLast 4 digits of phone
PhoneExtension[dbo].[extension]5NULL allowedPhone extension number.
FaxAreasmallint2NULL allowedFax Area code
FaxExchangesmallint2NULL allowedFax exchange
FaxLast4smallint2NULL allowedLast 4 digits of Fax
Custom1varchar(35)35NULL allowedCustom 1 free text value
Custom2varchar(35)35NULL allowedCustom 2 free text value
Custom3varchar(35)35NULL allowedCustom 3 free text value
Custom4varchar(35)35NULL allowedCustom 4 free text value
Custom5varchar(35)35NULL allowedCustom 5 free text value
Indexes TWstat_Req_Perf_Location_DE_CommunicationMethod_EntryName_IsCurrentFLAG_IDCommunicationMethod[dbo].[dict_id]5NULL allowedCommunication Method. to Communication_Method_DE.ID
Indexes TWstat_Req_Perf_Location_DE_SourceDE_EntryName_IsCurrentFLAG_IDSourceDEvarchar(255)255NULL allowedSource
TransmitIntervalint4NOT NULL(0)Tranmit future orders N days before to be done date
Indexes TWstat_Req_Perf_Location_DE_InboundOrderInterfaceAuthDE_EntryName_IsCurrentFLAG_IDInboundOrderInterfaceAuthDE[dbo].[dict_id]5NOT NULL(0)Order Interface Authorization. Link to InboundOrder_Interface_Auth_DE.ID
Indexes TWstat_Req_Perf_Location_DE_AcceptsDCFLAGCheck Constraints CK_Req_Perf_Location_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y')AcceptsDCFLAG[dbo].[BOOL]1NOT NULL('N')Notify When Order is Discontinued (Y/N)
Indexes TWstat_Req_Perf_Location_DE_AcceptsCanceledFLAGCheck Constraints CK_Req_Perf_Location_DE_AcceptsCanceledFLAG_Yes_Or_No : ([AcceptsCanceledFLAG]='N' OR [AcceptsCanceledFLAG]='Y')AcceptsCanceledFLAG[dbo].[BOOL]1NOT NULL('Y')Notify when order is Cancelled (Y/N)
Indexes TWstat_Req_Perf_Location_DE_AcceptsEIEFLAGCheck Constraints CK_Req_Perf_Location_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y')AcceptsEIEFLAG[dbo].[BOOL]1NOT 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')AcceptsCompletedFLAG[dbo].[BOOL]1NOT 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')InterfaceEnabled[dbo].[BOOL]1NULL allowed('N')Order Interface is used (Y/N)
Check Constraints CK_Req_Perf_Location_DE_OrderXMITHoldForFirstTime_Yes_Or_No : ([OrderXMITHoldForFirstTime]='N' OR [OrderXMITHoldForFirstTime]='Y')OrderXMITHoldForFirstTime[dbo].[BOOL]1NULL 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')OrderXMITHoldForSubsequentTime[dbo].[BOOL]1NULL 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')OrderXMITActiveFirstTime[dbo].[BOOL]1NULL 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')OrderXMITActiveSubsequentTime[dbo].[BOOL]1NULL 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')OrderXMITCanceled[dbo].[BOOL]1NULL allowed('N')Transmit order when it is Cancelled
Check Constraints CK_Req_Perf_Location_DE_OrderXMITDiscontinued_Yes_Or_No : ([OrderXMITDiscontinued]='N' OR [OrderXMITDiscontinued]='Y')OrderXMITDiscontinued[dbo].[BOOL]1NULL allowed('N')Transmit order when it is Discontinued
Check Constraints CK_Req_Perf_Location_DE_OrderXMITEIE_Yes_Or_No : ([OrderXMITEIE]='N' OR [OrderXMITEIE]='Y')OrderXMITEIE[dbo].[BOOL]1NULL allowed('N')Transmit order when it is Invalidated
Foreign Keys FK_Req_Perf_Location_DE_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDEDefaultBillingLocationDE[dbo].[dict_id]5NOT 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')HubUsedFLAG[dbo].[BOOL]1NOT NULL('N')Sedn through the HUB (Y/N)
Check Constraints CK_Req_Perf_Location_DE_RequisitionLockUsedFLAG_Yes_Or_No : ([RequisitionLockUsedFLAG]='N' OR [RequisitionLockUsedFLAG]='Y')RequisitionLockUsedFLAG[dbo].[BOOL]1NOT NULL('N')Use Requisition Locking (Y/N)
Destinationvarchar(35)35NOT NULL('')Destination ID freetext entry
DestinationSitevarchar(35)35NOT NULL('')Destination Site ID freetext entry
OrderTypesvarchar(75)75NOT NULL('')R - Referrals
L - Laboratory
U - Follow-up
X - DX Imaging
F - Clinical Findings
D - Other Diagnostic Testing
P - Precautions
S - Supplies
I - Instructions
ProblemCodesAcceptedvarchar(50)50NOT 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].ServiceLocationDEServiceLocationDE[dbo].[dict_id]5NULL allowedHealthcare Service Delivery Location. Link to Service_Location_DE.ID.